Bank reconciliation statement: format, worked example and journal entries

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.

DefinitionBank reconciliation statementnoun · accounting, cash control
Also calledbank reconciliation schedulebank recBRScash reconciliation statement

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.
Format

What is the standard bank reconciliation statement format?

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.

LineBank sideBook side
Balance per bank statement, or per cash book$48,615.00$52,617.50
Add: deposits in transit$6,200.00not applicable
Add: bank error in our disfavor$400.00not applicable
Less: outstanding checks($3,730.00)not applicable
Less: bank service feenot applicable($85.00)
Add: interest earnednot applicable$12.50
Less: NSF customer check returnednot applicable($1,150.00)
Add: book error, check recorded too highnot 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.

Steps

How do you prepare a bank reconciliation statement, step by step?

Seven steps cover a clean month. Skip none of them, because each one catches a different kind of difference.

1Step 1

Fix the cut-off date and pull both balances

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.

2Step 2

Match cleared items

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.

3Step 3

List the timing items

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.

4Step 4

List the bank-only items

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.

5Step 5

Check for errors on either 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.

6Step 6

Compute both adjusted balances

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.

7Step 7

Post, sign and file

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.

Example

What does a worked bank reconciliation example look like for October 2026?

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 itemAmountAdjustsJournal entry?
Deposit of 30 October, not yet credited by the bank$6,200.00Bank, addNo
Check 4471 to a freight carrier, not yet cashed$1,420.00Bank, subtractNo
Check 4478 to a supplier, not yet cashed$2,310.00Bank, subtractNo
Bank debited $400.00 that belongs to another account holder$400.00Bank, addNo, ask the bank to correct it
Monthly service fee$85.00Book, subtractYes
Interest credited by the bank$12.50Book, addYes
Customer check returned NSF$1,150.00Book, subtractYes, reinstates the receivable
Check 4465 for utilities recorded as $540.00, cleared at $450.00$90.00Book, addYes

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.

Journal entries

Which journal entries does a bank reconciliation statement require?

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.

ItemDebitCredit
Bank service feeBank Charges Expense $85.00Cash $85.00
Interest earnedCash $12.50Interest Income $12.50
NSF customer checkAccounts Receivable $1,150.00Cash $1,150.00
Check 4465 recorded as $540.00, cleared at $450.00Cash $90.00Utilities Expense $90.00
Deposit in transitNo entryNo entry
Outstanding checks 4471 and 4478No entryNo entry
Bank error of $400.00No entry in our booksBank 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.

ERP steps

How do you reconcile a bank account in Business Central, Dynamics GP and NetSuite?

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.

Exceptions

What should you check for stale items, missed months and possible fraud?

The statement is only as good as the exceptions you chase. Use these groups when a difference won't clear.

0 of 15 settled
Stale and old items
Missed months and carry-forward errors
When a difference signals fraud
Industry patterns
With an AI agent

How does an approval-first AI agent help with the bank reconciliation statement?

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.

  1. 1
    Agent

    Collect the statement and the ledger

    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.

  2. 2
    Agent

    Match and rank the leftovers

    It matches on amount, date and reference, groups lump-sum receipts against several invoices, and lists each unmatched line with the likeliest explanation.

  3. 3
    Agent

    Draft the entries

    For fees, interest and returned items, it prepares the journal lines with account names and attaches the statement evidence. Nothing posts yet.

  4. 4
    Your team

    Review and approve

    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.

  5. 5
    Agent

    Post and keep the trail

    Approved entries post to the ERP, and the agent logs who approved what and when, so the statement is audit-ready.

  6. 6
    Our team

    Tune the rules

    We review exceptions with your team, adjust matching rules and approval limits, and connect receivables work such as accounts receivable reconciliation and cash application.

FAQ

What do people ask about the bank reconciliation statement?

What is the difference between a bank reconciliation statement and a bank reconciliation?

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.

What is the formula for a bank reconciliation statement?

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.

Which items need a journal entry on a bank reconciliation statement?

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.

How often should you prepare a bank reconciliation statement?

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.

What should you do when the statement won't balance?

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.

Next step

Get your month-end bank rec done before the close call

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

Book Appointment
Sahil kataria (1)
Sahil Kataria

Founder and CEO

amit Kumar
Amit Kumar

Chief Sales Officer

Talk To Sales

USA

+1 270-550-1166

flag

+1 270-550-1166

Phil J.
Phil J.Head of Engineering & Technology​
QServices Inc. undertakes every project with a high degree of professionalism. Their communication style is unmatched and they are always available to resolve issues or just discuss the project.​
Assured

Thank You

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