Bookkeeper Group

Keeping it Real

Reconciliation Template (Free)

Terminal

The "Truth Serum" for Your Books

Bank reconciliation is often the most dreaded part of bookkeeping, but it is also the most critical. Think of it as a "truth serum" for your financial records. It is the process of comparing your internal records (your bookkeeping software or spreadsheet) against an external source of truth (your bank or credit card statement).

If your records don't match the bank's, your records are wrong. It's that simple. Reconciliation ensures that every transaction is accounted for and that your balances are real.

This template provides a simple framework for reconciling your accounts, designed for beginners and small business owners.

Why This Matters

  1. Catch Errors: Everyone makes mistakes. You might have entered $100 instead of $10, or missed an automatic payment.
  2. Detect Fraud: Regular reconciliation helps you spot unauthorized charges early.
  3. Tax Readiness: You can't file accurate taxes if you don't know if your numbers are right.
  4. Sleep Better: Knowing your books match the bank gives you peace of mind.

Step-by-Step Reconciliation Guide

1. Gather Your Records

You need two things:

  • The Bank Statement: The PDF or paper statement from your bank for the month you are closing. Do not just look at the online banking feed; get the actual statement with a starting and ending balance.
  • Your Books: Open your accounting software or spreadsheet to the reconciliation section.

2. Match the Balances

  • Start Date & Balance: Does the starting balance on your bank statement match the starting balance in your books? If not, you have an error from a previous month that needs fixing first.
  • End Date & Balance: Enter the ending balance and the ending date from your bank statement into your software.

3. Clear Transactions

Go through line by line.

  • Deposits: Check off every deposit that appears on both the statement and your books.
  • Withdrawals/Expenses: Check off every expense that appears on both.

4. The "Zero Difference" Goal

Ideally, after checking everything off, the difference between your books and the bank should be $0.00.

  • If it is, congratulations! You are reconciled.
  • If it is not, you have a discrepancy to find.

Finding Missing Transactions (The Detective Work)

If your difference is not zero, don't panic. This is normal. Here is how to find the problem:

Common Culprits

  1. Timing Differences: You wrote a check on Jan 30th, but it didn't clear the bank until Feb 2nd. This is fine! Leave it uncleared in your books.
  2. Duplicate Entries: Did you accidentally import a transaction twice?
  3. Bank Fees: Did you forget to record the $15 monthly service fee?
  4. Interest Income: Did you forget to record the $0.05 interest earned?
  5. Typos: Did you enter $54.00 instead of $45.00? (See the "Rule of 9" below).

Strategies for Finding Errors

  • Check the Number of Transactions: Count the number of deposits on the statement and in your books. Do they match? Do the same for withdrawals.
  • Sort by Amount: Sort both lists by amount and look for the specific dollar amount of your discrepancy.
  • The "Rule of 9": If the discrepancy is divisible by 9 (e.g., $0.27, $9.00, $81.00), it is often a transposition error (swapping two digits, like writing 54 instead of 45).
  • Divide by 2: If the discrepancy is an even number, divide it by 2. Did you enter a debit as a credit, or vice versa?

Reconciliation Checklist

Use this checklist every month for every account (Checking, Savings, Credit Cards, PayPal, Stripe).

  • Statement Downloaded: Saved a copy of the official PDF statement to your records.
  • Opening Balance Verified: Matches the prior month's ending balance.
  • Interest & Fees Recorded: Entered any bank fees or interest earned that weren't in the feed.
  • Transactions Matched: Cleared all matching deposits and expenses.
  • Discrepancies Investigated: All differences explained (e.g., outstanding checks).
  • Difference is Zero: The cleared balance in books equals the statement ending balance.
  • Report Printed/Saved: Save the reconciliation report for your accountant or tax preparer.

Difference Tracking Log

If you absolutely cannot find a small difference (e.g., less than $1.00) after hours of looking, you might choose to "write it off" to an expense account called "Reconciliation Discrepancies" just to move on. However, keep a log of this.

Date Account Discrepancy Amount Reason / Notes Action Taken
2023-01-31 Checking -$0.05 Unknown, likely rounding Wrote off to Misc Expense
2023-02-28 Credit Card $0.00 Balanced perfectly None

Warning: Never write off large amounts. If you are off by $100, you need to find it.

Review Sign-off

Accountability ensures consistency. Even if you are a solo business owner, sign off on your own work.

Month Reconciled: ____________________

Account: _____________________________

Reconciled By: _______________________ Date: _______________

Reviewed By: _________________________ Date: _______________

(If you have a bookkeeper, they sign "Reconciled By", and you sign "Reviewed By")