Bank Statement Reconciliation Sheet for Excel and Google SheetsBank Statement Reconciliation Sheet for Excel and Google Sheets
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
A bank reconciliation trick that saves bookkeepers a lot of hunting.
When a statement won't balance, don't re-check every line. Next to your running balance, type the balance the bank prints after each line. The first row where they disagree is your mistake: usually a missing line, a duplicate, or an amount in the wrong column.
I built this check into my new Bank Statement Reconciliation Sheet (Excel and Google Sheets, no macros). It shows a green RECONCILED when opening + in - out matches the closing balance to the cent, and points to the first bad row when it doesn't.
It's in my Contra shop alongside invoice, expense, supplier and multi-project tracker templates. Happy to answer spreadsheet questions in the comments.
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started