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.xlsx · Free download · No signup required

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.
Reconcile my bank account in BokepingA 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.
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.
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
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
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.