What is a bank reconciliation statement, and how do you prepare one?
A bank reconciliation statement lists the items that explain why your bank balance and your cash book differ, then proves both reach the same adjusted figure. The rule is simple: adjusted bank balance equals adjusted book balance, and any gap left over is an error you still have to find. Below you get the format, a dated October 2026 example, every journal entry, and the exact steps in Business Central, Dynamics GP and NetSuite.
A bank reconciliation statement is a schedule, prepared at a set date such as month end, that starts from the bank's closing balance and the company's cash book balance and adjusts each for timing differences and errors until the two agree. Deposits in transit and outstanding checks adjust the bank side. Fees, interest, NSF checks and book errors adjust the book side. The signed and dated statement is the evidence that cash was reconciled.
Definition consistent with Microsoft Learn: Reconcile bank accounts in Business Central.The format has two columns that finish on the same number. Use this layout every month so a reviewer knows where to look. The amounts below are illustrative and come from the worked example in the next section.
| Line | Bank side | Book side |
|---|---|---|
| Balance per bank statement, or per cash book | $48,615.00 | $52,617.50 |
| Add: deposits in transit | $6,200.00 | not applicable |
| Add: bank error in our disfavor | $400.00 | not applicable |
| Less: outstanding checks | ($3,730.00) | not applicable |
| Less: bank service fee | not applicable | ($85.00) |
| Add: interest earned | not applicable | $12.50 |
| Less: NSF customer check returned | not applicable | ($1,150.00) |
| Add: book error, check recorded too high | not applicable | $90.00 |
| Adjusted balance | $51,485.00 | $51,485.00 |
| Difference | $0.00 | $0.00 |
Put the preparer, reviewer, statement date and bank account number at the top of the page. A statement without those four items won't satisfy most auditors.
Seven steps cover a clean month. Skip none of them, because each one catches a different kind of difference.
Use the statement ending date, for example 31 October 2026. Take the bank's closing balance from the statement and the general ledger cash balance at the same date. Don't use today's ledger balance.
Tick every deposit and payment that appears in both the bank statement and the cash book. Match on amount, date and reference. What you can't tick is your list of differences.
Deposits recorded in your books but not yet on the statement are deposits in transit. Checks you issued that the bank hasn't paid are outstanding checks. These need no journal entry, because the books are already right.
Fees, interest, direct debits, returned checks and wire charges show on the statement but not in your books. Each needs a journal entry on the book side.
Look for transposed digits, duplicate postings and amounts the bank keyed wrong. A book error needs a correcting entry. A bank error needs a call to the bank and no entry.
Adjust the bank balance for timing items and bank errors. Adjust the book balance for fees, interest, NSF items and book errors. The two totals must be identical.
Post the book-side entries, attach the statement and bank PDF, and have a second person review it. Carry forward every outstanding item to next month's list so none is forgotten.
Here are the reconciling items behind the statement above, with the side each one adjusts and whether it needs a journal entry. All figures are illustrative. Bank balance at 31 October 2026 is $48,615.00 and the unadjusted cash book balance is $52,617.50.
| Reconciling item | Amount | Adjusts | Journal entry? |
|---|---|---|---|
| Deposit of 30 October, not yet credited by the bank | $6,200.00 | Bank, add | No |
| Check 4471 to a freight carrier, not yet cashed | $1,420.00 | Bank, subtract | No |
| Check 4478 to a supplier, not yet cashed | $2,310.00 | Bank, subtract | No |
| Bank debited $400.00 that belongs to another account holder | $400.00 | Bank, add | No, ask the bank to correct it |
| Monthly service fee | $85.00 | Book, subtract | Yes |
| Interest credited by the bank | $12.50 | Book, add | Yes |
| Customer check returned NSF | $1,150.00 | Book, subtract | Yes, reinstates the receivable |
| Check 4465 for utilities recorded as $540.00, cleared at $450.00 | $90.00 | Book, add | Yes |
Check the arithmetic. Bank side: 48,615.00 + 6,200.00 + 400.00 − 3,730.00 = 51,485.00. Book side: 52,617.50 − 85.00 + 12.50 − 1,150.00 + 90.00 = 51,485.00. Both reach $51,485.00, so the difference is zero.
Only book-side items need an entry. Timing items and bank errors never touch your ledger. Competitor examples often stop at the totals, so here is each entry in full, using the October 2026 numbers.
| Item | Debit | Credit |
|---|---|---|
| Bank service fee | Bank Charges Expense $85.00 | Cash $85.00 |
| Interest earned | Cash $12.50 | Interest Income $12.50 |
| NSF customer check | Accounts Receivable $1,150.00 | Cash $1,150.00 |
| Check 4465 recorded as $540.00, cleared at $450.00 | Cash $90.00 | Utilities Expense $90.00 |
| Deposit in transit | No entry | No entry |
| Outstanding checks 4471 and 4478 | No entry | No entry |
| Bank error of $400.00 | No entry in our books | Bank corrects its own records |
Net effect on cash is a $1,132.50 decrease: 85.00 + 1,150.00 less 12.50 and 90.00. That moves the book balance from $52,617.50 to $51,485.00. If the NSF check also carries a bank charge, post that as a second Bank Charges Expense line.
In Dynamics 365 Business Central, open Bank Account Reconciliations and choose New. Pick the bank account, enter the Statement Date and the Statement Ending Balance, then fill the Bank Statement Lines pane. You can import a statement file with Import Bank Statement, use a bank feed through the Envestnet Yodlee service, or choose Suggest Lines to pull open ledger entries. Microsoft documents all of this on Microsoft Learn.
Next, choose Match Automatically. You set a Transaction Date Tolerance in days, and the action compares the text on each statement line with the text on bank ledger entries. Matched lines turn bold green. Anything it misses, you match with Match Manually. If you manually match, auto-match won't overwrite your choice.
Unmatched statement lines such as fees and interest need ledger entries. Choose Transfer to General Journal, complete the balancing account on each line, post, then match the new entries. Run the Test Report before you post. It shows the Statement Ending Balance, Outstanding Bank Transactions, Outstanding Checks and Sum of Differences, so it works as your bank reconciliation statement.
Two limits matter. You can't post a reconciliation that has statement lines with differences, and you can't post many-to-one matches whose combined amounts differ, even if the differences net to zero. Post the difference, then match it. Also, don't let your bank's G/L account allow direct posting. Microsoft warns that direct postings break the link between bank ledger entries and the G/L account, which is a common reason the Test Report won't tie.
Business Central also offers the Payment Reconciliation Journal, which applies receipts to open customer and vendor entries and reconciles the bank account when all payments are applied. Microsoft describes it on Learn. Use it when you want cash application and reconciliation in one pass, and the Bank Acc. Reconciliation page when you only need to reconcile.
Copilot adds a Reconcile action to the same page. Microsoft labels the feature a preview. It runs auto-match first, then proposes extra matches from dates, amounts and descriptions, for example one lump-sum receipt against several invoices. It can also suggest G/L accounts for residual lines. Nothing is saved until you choose Keep it, and Microsoft lists operating limits of roughly 1,000 open ledger entries on 2025 release wave 1 and earlier, and roughly 3,000 from wave 2. Details are on Microsoft Learn.
In Dynamics GP, the Bank Reconciliation module holds the bank transactions you enter, the statement balance, and the clearing marks. The routine is the same: enter the statement ending balance and date, mark cleared checks and deposits, enter adjustments for fees and interest, and confirm the difference is zero before you reconcile. Check that adjustments post to the right G/L accounts, and that checkbook and G/L balances agree at the cut-off date. Menu names differ slightly between GP versions, so follow your release's documentation.
In NetSuite, you import the bank or card statement, then use the reconcile screen to match imported lines to book transactions, and create transactions for items the bank has but your books don't. Confirm the statement ending balance, the reconciled balance and the difference all line up before you close. Check that auto-matched pairs are real matches, not just equal amounts, and that bank fees land in the account you expect.
The statement is only as good as the exceptions you chase. Use these groups when a difference won't clear.
An agent does the matching and drafting. A person approves every posting. Here is the split we build inside Business Central, Dynamics GP, NetSuite and other ERPs. It sits on top of the month-end routine described in our month end close process checklist and the month-end close automation page.
The agent pulls the bank file or feed and the cash ledger entries up to the statement date, and checks that the opening balance equals last month's closing balance.
It matches on amount, date and reference, groups lump-sum receipts against several invoices, and lists each unmatched line with the likeliest explanation.
For fees, interest and returned items, it prepares the journal lines with account names and attaches the statement evidence. Nothing posts yet.
The controller or AP/AR manager reads the draft statement, changes any match, and approves or rejects each entry. The agent can't post without that approval.
Approved entries post to the ERP, and the agent logs who approved what and when, so the statement is audit-ready.
We review exceptions with your team, adjust matching rules and approval limits, and connect receivables work such as accounts receivable reconciliation and cash application.
A bank reconciliation is the process: comparing the bank's records with your cash book and clearing differences. The bank reconciliation statement is the document that process produces. It lists each reconciling item and shows both adjusted balances agreeing at one date. You do the reconciliation, then file the statement as evidence.
Adjusted bank balance equals adjusted book balance. Start with the bank balance, add deposits in transit and bank errors that understated it, and subtract outstanding checks. Start with the book balance, add interest and book errors that understated it, and subtract fees and NSF items. In the October 2026 example, both sides reach $51,485.00.
Only book-side items. Bank fees, interest, NSF checks, direct debits and your own recording errors need entries. Deposits in transit, outstanding checks and bank errors need none, because your books are right or the bank must fix its records.
Monthly is the minimum, and it should be done within the close calendar. High-volume accounts, such as lockbox or card receipts, are often reconciled weekly or daily so unmatched items stay small. Prepare it for every bank account, including idle accounts, which are an easy place for fraud to hide.
Check the opening balance first, then transpositions (a difference divisible by nine often means one), duplicated postings, items matched to the wrong month and entries posted directly to the cash G/L account. If a difference stays unexplained after that, escalate it, and treat unknown cleared checks as a fraud question.
Tell us which bank accounts and ERP you reconcile, and we'll show where an approval-first agent removes the matching work. #BankReconciliation #MonthEndClose #BusinessCentral #Controllers
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.