Sample Bank Reconciliation: Free Template and Complete Walkthrough

Bank reconciliation is the monthly ritual every accountant, bookkeeper, and small business owner must complete. Yet without a clear sample of bank reconciliation to follow, the process is easy to get wrong — and small errors compound into real headaches at year-end. This guide provides a complete example of bank reconciliation with real numbers, a free template structure you can copy today, and a brief look at balance sheet account reconciliation.

What Is Bank Reconciliation?

Bank reconciliation is the process of comparing your accounting records against your bank statement to confirm that your cash balance is accurate. The goal is to ensure both records agree after accounting for timing differences and any errors.

Every business — from solo freelancers to multi-entity firms — needs to reconcile its bank accounts regularly. Monthly reconciliation is standard practice. It protects against fraud, catches data-entry mistakes, and ensures financial statements reflect reality. A completed reconciliation also gives you confidence when presenting reports to lenders, investors, or tax authorities.

Why the Balances Never Match Right Away

When you pull your bank statement at month-end, the ending balance will almost never equal your book balance. This is not an error — it is expected. Differences arise because:

• Outstanding checks: You wrote the check and recorded it in your books, but the payee has not cashed it yet, so the bank does not reflect it.
• Deposits in transit: You recorded a deposit before the bank posted it.
• Bank service fees: The bank charged your account, but you have not yet recorded the expense in your books.
• NSF (non-sufficient funds) checks: A customer payment bounced; the bank reversed the deposit, but your books still show it as received income.
• Interest earned: The bank credited interest that you have not yet recorded.

The reconciliation process adjusts both sides until they arrive at the same Adjusted Balance.

Complete Worked Example of Bank Reconciliation

Here is a realistic account reconciliation example you can follow step by step.

Starting Figures

The two figures differ by $818 at the outset. The reconciliation will explain every dollar of that difference.

Step 1 — Adjust the Bank Statement Balance

Outstanding items affect the bank's figure, not yours. You have already recorded these transactions; the bank simply has not processed them yet.

Bank Statement Balance:           $5,420.00
Less: Outstanding Check #1108:     −$385.00
Less: Outstanding Check #1109:     −$215.00
Plus: Deposit in Transit:        +$1,200.00
                                ──────────
Adjusted Bank Balance:            $6,020.00

Step 2 — Adjust the Book Balance

These items appear on the bank statement but are missing from your internal records. Your ledger needs to be updated to reflect them before you can close the month.

Book Balance:                     $6,238.00
Less: Bank Service Fee:             −$18.00
Less: NSF Check Returned:          −$200.00
                                ──────────
Adjusted Book Balance:            $6,020.00

Result: Both Sides Match

The reconciliation is complete. The next step is to post two journal entries: one for the $18 bank service fee (debit Bank Charges Expense, credit Cash) and one for the $200 NSF check (debit Accounts Receivable, credit Cash). Without those entries, your ledger will still overstate cash by $218 heading into next month.

Free Bank Reconciliation Template Structure

A solid bank reconciliation template organizes the two-sided comparison and automatically flags any remaining discrepancies. Whether you build it in Excel or Google Sheets, the following columns and formulas create a reliable, repeatable structure.

Section 1 — Header Block

Section 2 — Bank Statement Side

Add a sub-table for outstanding checks and flag any check older than 90 days — it may be lost or may need to be voided and reissued.

Section 3 — Book Balance Side

A validation cell at the bottom compares the two adjusted balances: =IF(B5=B13,"RECONCILED","CHECK FOR ERRORS"). Format it conditionally — green when reconciled, red when a discrepancy remains. This single cell tells you at a glance whether the close is complete.

Balance Sheet Account Reconciliation

Bank reconciliation is one type of account reconciliation. The same logic applies across every balance sheet account. A balance sheet account reconciliation template verifies that each GL account balance agrees with its supporting schedule, sub-ledger, or external document.

Accounts that should be reconciled every month-end include:

• Accounts Receivable — tie to the AR aging report
• Accounts Payable — tie to the AP aging or vendor statements
• Prepaid Expenses — tie to the prepaid amortization schedule
• Fixed Assets — tie to the depreciation and asset register
• Loans Payable — tie to the lender amortization schedule
• Payroll Liabilities — tie to the payroll register

A standard balance sheet account reconciliation template includes: GL account name and code, prior-period balance, current-period activity (debits and credits), expected ending balance, actual ending balance (from the sub-ledger or external source), variance (should be zero), and preparer sign-off with date.

A non-zero variance signals a misposting that requires a correcting journal entry before you close the period. Catching these monthly prevents a chaotic year-end scramble and keeps auditors happy.

Frequently Asked Questions

What is a sample of bank reconciliation used for?

A sample bank reconciliation is a reference document showing how to structure the two-sided comparison, where each type of adjustment belongs, and what the completed output looks like. Accounting managers and practice owners use them to train new staff and standardize their month-end close procedures.

How often should I reconcile my bank accounts?

Monthly is the standard for most businesses. High-transaction businesses sometimes reconcile weekly. If you use accounting software with a live bank feed, you can review auto-matched transactions daily and reduce the formal monthly reconciliation to a quick sign-off review.

What do I do if the adjusted balances still do not match?

Work backwards through the period transaction by transaction. Compare each item on the bank statement to your ledger. The most common causes are transposed digits (e.g., $954 entered as $594), a deposit recorded in the wrong period, a duplicate entry, or a check that cleared for a different amount than recorded.

What is the difference between bank reconciliation and account reconciliation?

Bank reconciliation compares your cash ledger to the bank statement specifically. Account reconciliation is the broader practice of verifying any balance sheet account against an external source or supporting schedule. Bank reconciliation is one subset of account reconciliation.

Can bank reconciliation be automated?

Yes. Accounting platforms like QuickBooks Online and Xero import bank feeds and auto-match many transactions. AI-powered tools like LedgerLift go one step further — converting PDF bank statements to structured CSV or Excel before you import, eliminating manual data entry entirely.

Start Every Reconciliation With Clean Data

The biggest obstacle to smooth bank reconciliation is not the math — it is messy source data. PDF bank statements with inconsistent formatting, multi-page exports, and scanned documents slow everything down before you even open the spreadsheet.

LedgerLift converts any PDF bank statement into a clean, structured CSV or Excel file in seconds. No templates required, no bank-specific setup — LedgerLift works with any bank using AI. Upload your statement, get structured rows, and push directly to QuickBooks Online or sync automatically to Google Drive, Dropbox, or OneDrive. Your first 120 pages are free, and no credit card is required.

Start your first reconciliation with clean data at ledgerlift.me