Account Reconciliation

Use this Tallyfy template to reconcile your internal cash register or accounting records with bank statements. It walks you through comparing transactions, finding discrepancies, checking for errors, and making the adjustments needed to balance your books. Run this monthly or whenever you need to verify your cash position. ⏱️ Time estimate: 2-4 hours depending on transaction volume 📊 Difficulty: Intermediate 👥 Best for: Finance teams, bookkeepers, accountants, and small business owners

5 steps 1 automations

Process steps

1

Compare internal cash register to bank statement

5 days from previous step
task
Pull up both your internal cash register (or accounting system export) and the official bank statement for the same period. Go line by line and check that each payment and deposit shows up in both records. What to look for: • Transaction dates that match (or are within normal processing time) • Amounts that are identical down to the cent • Any transactions that appear in one record but not the other Tip: Sort both lists by date or amount to make matching easier. Flag anything that doesn't line up—you'll investigate those in the next steps.
2

Identify unmatched transactions between records

5 days from previous step
task
Now it's time to focus on the differences. Create a list of all transactions that appear in one record but not the other. Common reasons for mismatches: • Outstanding checks – Checks you've written that haven't cleared the bank yet • Deposits in transit – Money you've recorded but the bank hasn't processed • Bank fees or interest – Charges or credits the bank added that you didn't record yet • Timing differences – Transactions recorded on different dates Document each discrepancy with the date, amount, and likely reason. You'll need this list to make adjustments later.
Form fields in this step
Number of discrepancies found *
Total discrepancy amount *
3

Check for bank errors or recording mistakes

5 days from previous step
task
Review the bank statement carefully for errors. Banks make mistakes too—it's rare, but it happens. Common bank errors to watch for: • Duplicate transactions – Same charge appearing twice • Wrong amounts – Decimal points in the wrong place, transposed digits • Missing transactions – Deposits or payments that never posted • Transactions from wrong accounts – Someone else's transaction on your statement Also check your own records for: • Typos when entering amounts • Transactions recorded under the wrong date • Entries that were accidentally deleted or never recorded If you find a bank error, contact the bank immediately and note the reference number for your records.
Form fields in this step
Bank errors identified *
4

Review and verify all matched transactions

5 days from previous step
task
Go back through the transactions that did match between your records and the bank statement. Double-check that they're genuinely the same transaction, not just coincidentally the same amount. Verification checklist: • Dates are within expected processing time (usually 1-3 business days) • Transaction descriptions match or make sense • Payee/payer names correspond correctly • No two different transactions happen to have the same amount Why this matters: It's easy to match two different $50 transactions by mistake. Taking a few extra minutes here prevents headaches later. Mark each verified match as confirmed before moving on.
5

Complete reconciliation and document adjustments

5 days from previous step
task
This is where everything comes together. Take all the discrepancies you've identified and make the necessary adjustments to bring your records in line with the bank. Typical adjustments to make: • Add bank fees and service charges to your records • Record interest earned that the bank added • Note outstanding checks that haven't cleared yet • Document deposits in transit • Correct any errors you found in your own records Final check: After all adjustments, your adjusted book balance should equal the adjusted bank balance. If there's still a difference, go back and look for what you missed. Keep records of: All adjustments made, supporting documents, and the final reconciliation statement. You'll need these for audits and to track recurring items in next month's reconciliation.
Form fields in this step
Adjusted book balance *
Adjusted bank balance *
Reconciliation status *
Attach reconciliation worksheet

Ready to use this template?

Sign up free and start running this process in minutes.

Discover Tallyfy