Bank reconciliation template (free Excel download)

What is a bank reconciliation template you can use today?

This bank reconciliation template is an Excel workbook that adjusts your bank balance and your ledger balance to the same true cash figure. A difference check turns green at 0.00, so you know the account agrees before you sign. It also includes a filled-in example and a short how-to, so you can see a finished reconciliation first.

Free download

What's in the template?

Enter your work email and the Excel file arrives in your inbox: the ready-to-use sheet, the filled-in example and the how-to.

Excel workbook · 3 sheets · works in Excel and Google Sheets
  • A ready-to-use reconciliation: bank side and book side, each adjusted to the true cash balance
  • Lists for deposits in transit, outstanding checks, bank fees, interest, NSF checks and errors, with totals that calculate
  • A difference check that turns green at 0.00 and red when something is still missing
  • A filled-in worked example (48,215.60 bank, 47,822.10 ledger, both adjusted to 47,550.35)
  • Journal entry guidance and preparer / reviewer sign-off, ready for your month-end file
Bank reconciliation template (Excel): the filled-in example sheet
Free template

Get it in your inbox.

Work email only. We send this one email with the file, and an occasional note you can unsubscribe from. See our privacy policy.

How to fill it in

How do you fill in a bank reconciliation template?

Five steps. Blue cells are yours to type in. Grey cells calculate, so leave them alone.

1Step 1

Enter both starting balances

Type the closing balance from the bank statement on the bank side. Type the general ledger cash balance for the same date on the book side. Both must be as of the statement date.

2Step 2

List the timing items on the bank side

Add deposits in transit, then outstanding checks and payments. These are items your books recorded that the bank has not processed yet. The totals calculate, and the adjusted bank balance follows.

3Step 3

List what the bank did that your books don't show

Add bank fees, interest earned and NSF checks to the book side. Each one needs a journal entry later, because the bank knows about it and your ledger doesn't.

4Step 4

Record any errors, on the right side

A bank error goes on the bank side. A mistake in your own books goes on the book side. Mixing these up is the most common reason an account won't agree.

5Step 5

Read the difference check

At 0.00 the status turns green and you move to journal entries and sign-off. If it's red, something is still missing, and the checklist further down tells you where to look.

How to fill in the bank reconciliation template: Enter both starting balances, List the timing items on the bank side, List what the bank did that your books don't show, Record any errors, on the right side, Read the difference check
The steps at a glance.
Worked example

What does a reconciliation that reaches zero look like?

This is the filled-in example inside the template. Northwind Distribution Inc. (illustrative), operating account ...4471, statement date 31 Oct 2026.

LineAmountWhat it is
Balance per bank statement48,215.60Bank side starting point
Add: deposit in transit, slip 33184,850.00Customer receipts not yet credited by the bank
Add: deposit in transit, lockbox batch 1031-B2,300.00Total deposits in transit: 7,150.00
Less: check 10452 Acme Freight1,240.00Outstanding check
Less: check 10457 Delta Packaging3,615.25Outstanding check
Less: check 10461 City Utilities860.00Outstanding check
Less: ACH 1031-07 Contoso Supplies2,100.00Outstanding payment. Total outstanding: 7,815.25
Adjusted bank balance47,550.35No bank errors
Balance per general ledger47,822.10Book side starting point
Add: interest earned12.40Bank credited it, books didn't
Less: monthly account fee45.00Fee charged by the bank
Less: outgoing wire fee18.15Total fees: 63.15
Less: returned NSF check, customer C-2207275.00Customer's check bounced
Add: book error, check 1044954.00Booked as 1,482.00, cleared at 1,428.00
Adjusted book balance47,550.35Matches the adjusted bank balance
Difference0.00Reconciled

Bank side: 48,215.60 + 7,150.00 - 7,815.25 = 47,550.35. Book side: 47,822.10 + 12.40 - 63.15 - 275.00 + 54.00 = 47,550.35. The example covers timing items, fees, interest, an NSF return and a book error, which is what a real month usually contains.

Journal entries

Which journal entries come out of a bank reconciliation?

Only the book side needs entries. Timing items on the bank side clear by themselves when the bank processes them. Here are the five entries from the example, as debit and credit lines.

0 of 5 settled
Entries for the Northwind example
If it won't balance

What should you check when a bank reconciliation doesn't balance?

Work through these in order. Most differences are one of the first four.

0 of 10 settled
Find the difference
Common mistakes
Review and sign-off

Who should review a bank reconciliation, and when?

The template has preparer and reviewer sign-off fields. These practices are our suggestions, so adjust them to your own close policy.

0 of 5 settled
Suggested review rules
In your ERP

How do you do a bank reconciliation in Business Central, GP or NetSuite?

The template works on any ledger. If your ERP has its own reconciliation screen, use it to do the matching, and keep the template as your proof and review sheet. Check the exact screens against your version, since vendors change them.

1Business Central

Bank Acc. Reconciliation

Open Bank Acc. Reconciliations, enter the statement date and ending balance, and use Suggest Lines. Choose Match Automatically to pair statement lines with bank ledger entries, then Post once every line is matched. Microsoft also documents a Copilot-assisted option for matching.

2Dynamics GP

Reconcile Bank Statements

Go to Transactions, Financial, Reconcile Bank Statements. Select the checkbook and enter the statement ending balance. Then open Select Bank Transactions to mark what cleared. Enter fees and interest in the Reconcile Bank Adjustments window. Microsoft also describes reconciling the checkbook to the GL cash account.

3NetSuite

Match Bank Data, then Reconcile Account Statement

Oracle's current flow is Transactions, Bank, Match Bank Data to match imported lines against transactions. You then finish on Reconcile Account Statement. The older Reconcile Bank Statement page is documented as being retired, so check which one your account uses.

4Any ERP

Use the template as the check

Take the adjusted balances from your system and drop them into the template. If the difference check isn't green, the ERP reconciliation has a gap, and the checklist above shows where to look.

With an AI agent

How does an approval-first AI agent do the bank reconciliation work?

We build AI agents that work inside your ERP and CRM. A person approves every action. For bank reconciliation, the agent prepares the work and your controller decides.

  1. 1
    Agent

    Pulls the statement and the ledger

    The agent reads the bank statement lines and the cash ledger entries for the period, inside Business Central, Dynamics GP, NAV, Epicor, SYSPRO, NetSuite or Sage.

  2. 2
    Agent

    Matches and lists the exceptions

    It proposes matches, then groups what's left into timing items, fees, interest, NSF returns and unexplained differences, with the evidence for each.

  3. 3
    Agent

    Drafts the journal entries

    For book-side items it drafts the entries and leaves them unposted, so you see the debit and credit lines first.

  4. 4
    Your team

    Approves or rejects

    The preparer reviews the proposals and approves what's right. Nothing posts without that click. The reviewer signs off as usual.

  5. 5
    Our team

    Sets up the controls

    We configure the approval rules, thresholds and audit trail with your finance team, and we maintain the agent after go-live.

FAQ

What do people ask about a bank reconciliation template?

Is this bank reconciliation template free?

Yes. Enter your work email in the form on this page and the Excel file arrives in your inbox.

What's in the file?

A ready-to-use reconciliation with a bank side and a book side, lists for deposits in transit, outstanding checks, bank fees, interest, NSF checks and errors, a difference check, a filled-in example, journal entry guidance and preparer and reviewer sign-off.

What do the colors mean?

Blue cells are for you to fill in. Grey cells calculate. The status turns green when the account agrees at 0.00 and red when something is still missing.

Why are the bank balance and the ledger balance different?

Timing items explain part of it: deposits in transit and outstanding checks. The rest is activity the bank recorded first, such as fees, interest and NSF returns, plus any errors on either side.

How often should you reconcile a bank account?

At least monthly, as part of the close. Accounts with heavy volume are often reconciled more often, because small differences are easier to trace while they're fresh.

Can an AI agent post the entries for me?

Not without approval. Our agents draft the matches and journal entries, and a person approves each action before anything posts in your ERP.

Want this running inside your ERP?

Get the template, then close faster

Download it today. If you'd like the matching and entry drafting handled by an approval-first agent, we'll walk through your close with you in 30 minutes. See also the month-end close automation page and our month end close process checklist.

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.