Bank reconciliation template Excel that calculates itself
A free bank reconciliation template for Excel and Google Sheets. Enter your balances and the formulas show the difference.
| Ending balance on statement | 48,500.00 |
| Add: deposits in transit | 3,000.00 |
| Less: outstanding checks | (2,200.00) |
| Adjusted bank balance | 49,300.00 |
| Ending balance in ledger | 49,450.00 |
| Less: bank fees not yet recorded | (150.00) |
| Adjusted book balance | 49,300.00 |
| Difference | 0.00 |
Bank reconciliation format in Excel
The standard two-sided format: the bank side on the left, your books on the right. Both end in an adjusted balance, and the two must match.
| Balance per bank statement | Balance per books |
|---|---|
| Ending balance on statement | Ending balance in ledger |
| Add: deposits in transit | Add: interest income and other credits |
| Less: outstanding checks and withdrawals | Less: bank fees and other charges |
| Adjusted bank balance | Adjusted book balance |
A free bank reconciliation template
- Works in Excel and Google Sheets
- A standard .xlsx with the formulas already in place. Enter your balances and the difference calculates itself.
- 1,300+ banks in 121 countries
- Arabic, English and bilingual statements, digital or scanned. Every row is checked against the running balance, and rows that do not add up are flagged.
- Your files stay private
- Each PDF is processed in an isolated environment and deleted as soon as your result is ready. We never sell or share your data.