What is account reconciliation, and how do you do it?
Account reconciliation is the process of comparing a general ledger balance to an independent record, such as a bank statement or a subledger, and explaining every difference. It proves a balance is right before you report it. Auditors expect each one to be documented, reviewed and signed off every period.
Account reconciliation is the control that compares the balance of a general ledger account with a second, independent source, then identifies and resolves each difference. The result is either a balance that agrees, or a short list of explained reconciling items. It differs from bank reconciliation (one type of account reconciliation, cash against a bank statement) and from the month-end close (the wider process that includes accruals, reporting and review).
Microsoft describes the same idea for cash: bank reconciliation helps ensure that what is in your books matches the statements you receive from your bank, per Microsoft Learn.Reconciling item: a known, explained difference between two balances. Some are timing differences that clear on their own. Others are errors that need a journal entry.
Subledger: a detailed record behind one general ledger account. Accounts receivable (AR) and accounts payable (AP) are the usual ones. Each holds one line per invoice, credit memo and payment.
Control account: the single general ledger account that summarizes a subledger. The subledger total should equal it at all times.
Outstanding cheque: a cheque you recorded that the bank hasn't paid yet. Deposit in transit: money you recorded that the bank hasn't credited yet. Both are timing items, and neither needs a journal entry.
Suspense account: a temporary account that holds amounts you can't yet classify. It should be zero, or fully explained, at every close.
Where the three differ. Bank reconciliation checks cash against the bank. Account reconciliation covers every balance sheet account, from cash and AR to accruals and intercompany. The month end close process is the schedule that makes all of them happen on time.
Here is one illustrative bank reconciliation (the numbers are made up). Both sides are adjusted until they land on the same figure: $50,500.
| Line | Bank side | Book side |
|---|---|---|
| Balance per bank statement / per general ledger | $48,650 | $51,677 |
| Add: deposit in transit (recorded, not yet credited) | +$6,200 | |
| Less: outstanding cheques #4471, #4475, #4479 ($2,100 + $1,850 + $400) | -$4,350 | |
| Less: bank service fee not yet booked | -$35 | |
| Less: customer cheque returned NSF (not sufficient funds) | -$1,250 | |
| Add: interest earned, not yet booked | +$18 | |
| Add: error correction (a $450 payment was booked as $540) | +$90 | |
| Adjusted balance | $50,500 | $50,500 |
Only the book-side lines need journal entries. Timing items on the bank side (deposits in transit, outstanding cheques) clear when the bank catches up. If the two adjusted figures differ by even $1, an item is missing or wrong.
Each book-side adjustment becomes one entry. These match the example above.
| Item | Debit | Credit |
|---|---|---|
| Bank fee ($35) | Bank charges expense $35 | Cash $35 |
| NSF cheque ($1,250) | Accounts receivable $1,250 (the customer owes it again) | Cash $1,250 |
| Interest income ($18) | Cash $18 | Interest income $18 |
| Payment error ($90): the original entry was Dr Accounts payable $540, Cr Cash $540, but the cheque was for $450 | Cash $90 | Accounts payable $90 |
Net effect on cash: -$35 - $1,250 + $18 + $90 = -$1,177, which takes the book balance from $51,677 to $50,500. Note the NSF entry: it reopens the receivable, so collections needs to know the same day.
The same six steps apply to cash, AR, AP, accruals and intercompany. Only the support document changes.
Use the last day of the period. Pull the general ledger balance as of that date, not today's balance.
Use something the ledger didn't produce: a bank statement, a subledger aging report, a vendor statement, a payroll register or a counterparty confirmation.
Match line to line on amount, date and reference. Start with exact matches, then tolerance matches (same amount, date within a few days), then the leftovers by hand.
Label each leftover as a timing item (it clears on its own), an error (it needs a correcting entry) or an unknown (it needs investigation). Never carry an unlabeled difference.
Book the entries for errors and for items the bank initiated, like fees and interest. Re-run the comparison until the adjusted balances agree.
Attach the support, list the reconciling items with aging, and sign as preparer. A different person reviews and signs with a date. Preparer and reviewer should never be the same person.
This is the reconciliation most distributors and 3PLs struggle with, because the control account is posted by both modules and by manual journals. Illustrative numbers below.
| Reconciling item | Effect | Resolution |
|---|---|---|
| GL AR control account balance | $1,291,800 | Starting point |
| AR subledger aging total | $1,284,300 | Support balance |
| Variance to explain | $7,500 (GL higher) | Needs two items |
| Manual journal posted straight to the AR control account (a misposted $9,000 accrual) | GL higher by $9,000 | Dr Accrued revenue $9,000, Cr AR control $9,000 |
| Invoice posted in the subledger but missing from the GL (a stuck $1,500 batch) | GL lower by $1,500 | Post the batch: Dr AR control $1,500, Cr Sales $1,500 |
| Net of the two items | $9,000 - $1,500 = $7,500 | Variance fully explained, then re-run to confirm $0 |
The cure is to block direct posting to control accounts. Our [accounts receivable reconciliation routine](https://www.qservicesit.com/accounts-receivable-reconciliation-routine) covers the daily and monthly checks, and [cash application](/departments/cash-application) removes the unapplied receipts that cause most AR variances.
Intercompany: each entity records its side, and the two must mirror each other before consolidation. A parent's receivable from a subsidiary should equal the subsidiary's payable, converted at the same rate.
Illustrative example. A US parent bills its UK subsidiary £10,000 on 28 October at 1.25. The parent books Dr Intercompany receivable $12,500, Cr Intercompany revenue $12,500.
At 30 November the rate is 1.28. The £10,000 is now $12,800. The parent books Dr Intercompany receivable $300, Cr Unrealized FX gain $300.
Without that entry, the two companies show a $300 gap that nobody can explain. With it, the receivable and the payable agree in pounds and in dollars. The gain reverses or settles when the cash moves.
Rule of thumb: reconcile intercompany in the transaction currency first, then in the reporting currency. Most FX noise disappears at the first step.
Dynamics 365 Business Central. Search for Bank Account Reconciliation, choose New, pick the bank account, then enter the Statement Date and Statement Ending Balance. Fill the Bank Statement Lines pane with Import Bank Statement (a file or an Envestnet Yodlee bank feed) or with Suggest Lines.
Then choose Match Automatically, which compares text on statement lines to bank account ledger entries and takes a Transaction Date Tolerance (Days). Use Match Manually for the rest. Fees and interest that have no ledger entry go through Transfer to General Journal.
Run the Test Report first. It shows Outstanding Bank Transactions and Outstanding Checks. You can post only when the statement total equals Balance To Reconcile plus Balance Last Statement. Posted statements sit in the Bank Account Statement List, where Undo reopens a mistake. Don't allow direct posting on the bank's G/L account, because it breaks the link to the bank ledger.
The Payment Reconciliation Journal does a related job for customer and vendor payments: the Post Payments and Reconcile Bank Account action closes open ledger entries and reconciles the bank at once. North American versions also offer the Bank Rec. Worksheet for cheques and deposits. Microsoft also documents a Reconcile with Copilot action in a bank reconciliation assist feature that was in preview when we checked, so confirm availability in your environment.
Dynamics GP. Bank Reconciliation compares the checkbook to the statement. For subledgers, Reconcile to GL sits under Tools, Routines, Financial and produces an Excel file that matches Payables or Receivables Management transactions to what posted to General Ledger.
Microsoft is clear that it is a troubleshooting tool, and its balances are simple calculations from distribution tables, not true balances. The real reconciliation is the aged trial balance against the GL trial balance.
NetSuite. Oracle's current flow uses the Match Bank Data page, which attempts to auto-match imported statement lines to transactions, and the Reconcile Account Statement page, where you finish the reconciliation. You enable both with the matching box on the bank account record.
Where all three stop: they match what is already in the system. None of them chases the missing remittance email, explains why a variance exists or decides which reconciling item is stale. That judgment still lands on your team.
Set thresholds in writing before the close, so nobody debates them at midnight. This is an example policy (illustrative; set yours with your auditors).
| Variance | Action | Sign-off |
|---|---|---|
| $0 to $50 | Clear with a note, no investigation | Preparer, reviewed monthly |
| $51 to $1,000 | Investigate within 5 business days | Reviewer |
| $1,001 to $10,000 | Resolve before the close is final | Controller |
| Over $10,000 | Resolve before close and tell the CFO | Controller and CFO |
| Any item older than 60 days | Explain in writing or write off | Controller |
| Any suspected fraud, any amount | Stop and escalate | Controller, CFO, audit committee as applicable |
Frequency by account: cash daily or weekly for active accounts and always monthly; AR, AP, inventory and intercompany monthly; payroll every pay run; fixed assets, equity and other low-activity balance sheet accounts quarterly.
Print this list. Then use the template columns for every account.
Red flags: reconciling items that never clear; round-dollar adjustments; manual journals into control or cash accounts; the same person who handles cash also reconciling it; and statements that arrive late or only as screenshots.
ACFE data: the Association of Certified Fraud Examiners' 2024 report estimates organizations lose about 5% of revenue to fraud, and 43% of cases were first detected by a tip. Reconciliation is a detective control: it finds what the tip line doesn't.
SOX 404 and PCAOB: public companies' management must assess internal control over financial reporting, and the auditor tests it under PCAOB AS 2201, designing tests to serve both the control audit and the financial statement audit. A signed, dated and independently reviewed reconciliation is standard evidence. An unsigned or late one is a common deficiency finding.
IFRS vs US GAAP: the reconciliation method is the same under both. The differences show up in the balances you reconcile, for example inventory costing (US GAAP permits LIFO, IFRS doesn't) and impairment reversals. Reconcile to the framework you report under.
An agent does the matching and drafting inside your ERP. A person approves every posting.
The agent collects the bank file, the subledger aging and the GL balance at the cut-off date.
It matches exact and tolerance items, then labels leftovers as timing, probable error or unknown, with the evidence beside each.
For fees, interest and known errors it prepares draft journals. It never posts them.
The preparer or controller approves, edits or rejects each draft. Judgment calls, such as stale items, stay with a person.
Every action is logged with who approved it, which is what your auditor wants to see.
It is checking that a balance in your books agrees with an independent record, like a bank statement or subledger, and explaining any gap. You do it every period so errors and fraud surface early.
They ask the same thing. The meaning is the plain idea: make two records agree. The formal definition adds the control aspects: independent support, documented differences, and preparer and reviewer sign-off.
Bank reconciliation is one type, comparing cash to a bank statement. Account reconciliation covers every balance sheet account, including AR, AP, accruals, inventory and intercompany.
Active cash accounts daily or weekly, and every account that moves at least monthly at the close. Low-activity balance sheet accounts can be quarterly. High-risk accounts should stay monthly.
A reconciling item is a known, explained difference between two balances. Timing items, like outstanding cheques, clear by themselves. Errors need a correcting journal entry.
Someone who didn't prepare it and doesn't handle the underlying transactions. The reviewer signs and dates it after the preparer, which is what auditors test.
It can draft them. In an approval-first setup a named person approves each posting, so accountability and the audit trail stay with your team.
Tell us which reconciliations hurt most. We'll show you how an approval-first agent would handle them in your ERP. See month-end close automation.
Facts on this page checked on 16 November 2026.

Founder and CEO

Chief Sales Officer
Thanks, we’ve got your details. A named member of our team will reply within one business day.