Canonical page: https://bokeping.com/resources/blog/twelve-minute-reconciliation/

Markdown page: https://bokeping.com/resources/blog/twelve-minute-reconciliation.md

Source updated: 2026-11-12

Text version of the public page. Check the canonical page for current terms and interactive features.

Banking

# Free Bank Reconciliation Template for Excel (With a Worked Example)

Download a free Excel bank reconciliation template for a USD checking account. Get a blank sheet and a worked example with $350 in, $300 out and a missed $10 bank fee.

[Download the Excel template](<https://bokeping.com/downloads/bank-reconciliation/bokeping-bank-reconciliation-template.xlsx>)

.xlsx · Free download · No signup required

BankingBy [Bokeping Team](<https://bokeping.com/about/#content-team>)5 min read

Published August 6, 2026Updated November 12, 2026

Bokeping demo, September 28, 2026. The $350 receipt and $300 payment have cleared. The screen shows a $50 statement balance and a $0 difference before Finish. The $10 fee example below uses a separate, hypothetical statement.

[View the full-size reconciliation screenshot](<https://bokeping.com/images/help/reconciliation.webp>)

## Match the $350 receipt and the $300 payment

Open Worked example and compare it with the screenshot above. The previous cleared balance is $0. Both book entries appear on the September 28 statement, so both rows are marked Yes. Adding $350 and subtracting $300 leaves $50. The bank also reports $50, so the difference is $0.

## What a missing $10 bank fee looks like

Now suppose the bank also charged a $10 service fee before the cutoff. This second statement ends at $40. Your books still show $50. In the fee comparison on Worked example, the worksheet takes $40 minus $50 and shows −$10.

Find the fee on the statement and check whether it is already in the books. If it is missing, record $10 as a bank fee paid from this checking account. Clear that entry against the statement. Total spent is now $310, the cleared balance is $40, and the difference is $0. If the fee already has an entry, match that entry so the expense is counted once.

## Use the blank sheet for your own statement

-   On Blank, enter the account, statement ending date, previous reconciled closing balance and this statement’s ending balance. Enter zero explicitly for a zero balance.
-   Add one book transaction per row, including earlier items still outstanding. Enter a positive amount in either Received or Spent. Mark Yes only when you find the transaction on this statement. Up to 50 rows are available per worksheet.
-   Review any row checks and the signed difference. Carry unchecked deposits and payments forward to the next statement. A zero difference still needs a transaction-by-transaction review.

To use the same workflow in Bokeping, create a company and open Banking → Reconcile. Select the account, enter the statement end date and balance, and select the recorded transactions that cleared. The Excel worksheet is for your own reconciliation and does not post entries to Bokeping.

-   [Follow the reconciliation walkthrough](<https://bokeping.com/help/banking/reconcile/>)
-   [Check bank-file import, reconciliation and plan access](<https://bokeping.com/products/banking/#banking-requirements>)

[Reconcile my bank account in Bokeping](<https://app.bokeping.com/auth/signup?entry=bank_reconciliation_template>)

## A month-end walkthrough with two errors

IRS Publication 583 recommends reconciling your business checking account monthly. This separate July example has two errors in the books and a larger difference than the sample workbook. The first step is the same: compare one account at one cutoff date.

Sources for this explanation:

-   [IRS — Publication 583: Starting a Business and Keeping Records](<https://www.irs.gov/publications/p583>)

## The setup: two numbers that should agree

The July checking statement closes at $18,406.22. The cleared books show $18,641.65. With the same calculation as the template, the difference is −$235.43. Look for entries that leave the books $235.43 higher than the bank.

One rule before you start: never “plug” the difference with an adjustment to make the numbers agree. A forced match doesn’t fix the error — it hides it, and it will come back bigger. The difference is information. Spend it.

## Minutes 1–4: what does the bank have that you don’t?

Near the bottom of the July statement are a $15.44 service charge and a $30.00 wire fee. Neither appears in the books. Record and clear the two charges, then check the difference again. It moves from −$235.43 to −$189.99.

## Minutes 5–9: the suspiciously specific remainder

Search the ledger for $189.99. In this example the customer payment was recorded by hand, then the imported deposit was posted as a second receipt. Check the payment reference, undo the duplicate posting and match the imported line to the original receipt. With the two fees recorded and the duplicate corrected, the books agree with the statement.

-   [How to handle duplicate bank transactions](<https://bokeping.com/help/banking/duplicate-transactions/>)

Check the math: $45.44 in missed bank charges plus a $189.99 duplicated deposit is $235.43. The books were “wrong” in two mundane ways, and both took minutes to find because the amount told you what to look for.

## Minutes 10–12: review the cleared entries

Mark the month reconciled. This step matters more than it feels like it does: a reconciled month is a trusted base, which means next month’s search space is one month wide instead of six. Businesses that reconcile monthly chase differences measured in minutes. Businesses that reconcile at tax time chase a year of compounded ones.

## The three usual suspects

Nearly every reconciliation difference is one of three things:

-   Bank activity your books missed — fees, interest, and the occasional returned payment. The bank never forgets to charge you; you sometimes forget to record it.
-   Duplicates from mixed entry — a transaction typed in by hand and then imported again by feed or CSV. The tell is a difference that exactly equals one transaction.
-   Timing — a check you wrote on the 29th that cleared on the 2nd. It belongs in your books now and on next month’s statement. List it, don’t “fix” it.

And two old tricks for when nothing jumps out. A difference divisible by nine is often a transposition — record $270 as $720 and the $450 gap divides cleanly by nine. A difference that’s exactly double one transaction usually means something was entered backwards: a deposit recorded as a withdrawal moves the balance twice its amount. Neither trick finds the error for you, but both tell you what kind of error to hunt.

## Why twelve minutes and not three hours

Regular recordkeeping can make reconciliation easier because there is less history to investigate. Review the transactions and reconciling items as well as the totals: offsetting errors can leave equal balances. The twelve-minute schedule is a teaching example, not a completion-time guarantee or proof that every accounting entry is correct.

## Sources & further reading

Sources checked November 12, 2026

These references explain the concepts above. Tax guidance and financial reporting standards serve different purposes; each source’s scope is shown below.

-   [IRS — Publication 583: Starting a Business and Keeping Records](<https://www.irs.gov/publications/p583>)
    
    U.S. recordkeeping guidance, supporting documents, and monthly bank reconciliation.
    

General guidance, not accounting or tax advice. Rules differ by state and by business, and they change — check your own state’s published rules, and talk to your accountant about your situation before you act on anything here.

FAQs

## Frequently asked questions

### Do I need a Bokeping account to use the Excel template?

No. Download the .xlsx file directly. Use Blank for your own USD checking account or open Worked example to follow the demo. No email address or account is required.

### How do I handle a check or deposit that has not cleared?

Enter the book transaction and mark Cleared? as No. It stays on the worksheet and is excluded from the cleared balance. Carry it into the next reconciliation and mark Yes when it appears on that statement.

### Why is the difference negative $10 in the bank fee example?

The bank has deducted the fee, so the statement ends at $40 while the cleared books still show $50. The worksheet subtracts the cleared balance from the statement balance. Record the $10 fee once, match it to the statement and the difference becomes $0.

### Which Bokeping plan lets me reconcile a bank statement?

Bank-file import and reconciliation are included on Free, Standard and Pro, subject to company permissions. Automatic bank feeds require Standard, Pro or an active Pro trial.

Keep reading

## More from the blog

[Taxes4 min read ### Cash vs. accrual accounting: what the IRS rules mean Read](<https://bokeping.com/resources/blog/cash-or-accrual/>)[Bookkeeping4 min read ### Money that isn’t income: loans, owner money, and transfers Read](<https://bokeping.com/resources/blog/money-that-isnt-income/>)[Taxes4 min read ### Sales tax for small businesses, without the shoebox Read](<https://bokeping.com/resources/blog/sales-tax-without-the-shoebox/>)[Inventory4 min read ### Inventory margins: know what you make on every product Read](<https://bokeping.com/resources/blog/inventory-margins-every-product/>)[Cash flow3 min read ### Cash flow vs. profit: profitable on paper, out of cash at the bank Read](<https://bokeping.com/resources/blog/profitable-but-broke/>)[Bookkeeping4 min read ### Monthly Bookkeeping Checklist for Small Businesses Read](<https://bokeping.com/resources/blog/fifteen-minute-month-end/>)[Reports4 min read ### How to read a P&L statement without an accounting degree Read](<https://bokeping.com/resources/blog/read-your-pl/>)[Invoicing3 min read ### How to get paid faster: five invoice habits Read](<https://bokeping.com/resources/blog/get-paid-faster/>)
