Free download, no sign-up
A bank reconciliation template
that actually calculates itself
Two sides, bank and books, with formulas that total everything and flag the difference automatically. Works in Excel and Google Sheets.
Download the template (.xlsx)Bank Reconciliation Statement
PER BANK STATEMENT
Balance per Bank Statement45,230.00
Add: Deposits in Transit3,150.00
Less: Outstanding Withdrawals(1,875.50)
Adjusted Bank Balance46,504.50
PER BOOKS
Balance per Books46,910.00
Add: Interest Income12.50
Less: Bank Fees(418.00)
Adjusted Book Balance46,504.50
Difference (should be 0)0.00
How to use it
- 1
Enter your closing balance from the bank statement and from your books.
- 2
List any deposits in transit and outstanding checks or withdrawals the bank hasn't cleared yet.
- 3
Add any items your books are missing, like bank fees or interest income shown on the statement.
- 4
The two adjusted balances should match. If they don't, the difference points you straight to the missing transaction.
Doing this every month by hand?
Bayainy reads your PDF bank statement directly and extracts every transaction with the running balance already checked, so there's nothing left to type into a template.
Try Bayainy free