Calculators
Bank Reconciliation Calculator
Reconcile a bank statement with your books by adjusting for deposits in transit, outstanding cheques, fees and errors.
- Runs in your browser
- Nothing uploaded
The tool
Enter your numbers below. Results update as you type, and nothing leaves your browser.
Everything you enter stays on your own machine. Nothing is sent to us or to anyone else, which you can confirm in your browser network tab.
What people use it for
- Month-end close
- Finding bookkeeping errors
- Preparing for an audit
- Training new bookkeepers
About this tool
What the Bank Reconciliation Calculator does
A bank reconciliation explains the difference between the bank statement balance and the cash balance in your books. Timing items such as deposits in transit and outstanding cheques adjust the bank side; fees, interest and returned cheques adjust the book side. When both adjusted balances match, the books are reconciled.
Formula
- Adjusted bank = statement balance + deposits in transit − outstanding cheques ± bank errors
- Adjusted book = book balance − fees + interest − returned cheques ± book errors
- Difference = adjusted bank − adjusted book
Worked example
Using the starting values in the calculator above:
| Input | Value |
|---|---|
| Bank statement balance | $25,400 |
| Deposits in transit | $3,200 |
| Outstanding cheques | $4,100 |
| Bank errors (+/−) | $0.00 |
| Book balance | $24,865 |
| Bank fees not recorded | $45.00 |
| Interest earned not recorded | $30.00 |
| Returned (NSF) cheques | $350 |
| Book errors (+/−) | $0.00 |
| Result | Value |
|---|---|
| Status | Reconciled |
| Unexplained difference | $0.00 |
| Adjusted bank balance | $24,500.00 |
| Adjusted book balance | $24,500.00 |
How to read the result
A difference that divides exactly by 9 often signals transposed digits, such as 54 entered as 45.
Book-side adjustments need journal entries; bank-side items do not, because they will clear on the next statement.
Related calculators
- Payroll Reconciliation Calculator: Reconcile a payroll register with net pay sent from the bank and payroll taxes remitted, and flag differences.
- Accrued Expenses Calculator: Calculate month-end accruals for expenses incurred but not yet invoiced or paid, prorated by days.
- Bad Debt Reserve Calculator: Calculate a bad debt reserve by the percentage-of-sales or percentage-of-receivables method and the adjustment to book.
- Segment Profitability Calculator: Calculate profit by product line, client or revenue account after direct costs and an allocated share of overheads.
Browse every calculator in Tax and Accounting Calculators, or talk to us about finance workflow automation.
More tools and services
- 1031 Exchange Calculator
- 401(k) Contribution Optimizer
- 529 College Savings Calculator
- A/B Test Significance Calculator
- Accessible Ramp Calculator
- Accounts Payable Aging Calculator
If you would rather someone did this properly for you, we offer Web Design Services and Website Development, SEO Services: Search Engine Optimization, AI Automation Agency.
Questions
Questions about this tool
The things clients actually want to know — costs, timelines, ownership and what happens after launch.
A comparison of the bank statement with your accounting records, explaining every difference between them.
Money recorded in your books but not yet shown on the bank statement.
Book-side items such as bank fees, interest and returned cheques.
Free strategy session
Let’s build something worth finding.
Tell us where you want the business to be in twelve months. We will come back with a costed plan, a realistic timeline, and the numbers we expect to move — no obligation, no jargon.
- 30-minute call, no pitch deck
- Fixed-price proposal in 48 hours
- You own everything we build
Talk to a developer
Not a sales team
- Response time
- Within 1 business hour
- Where we work
- UK, USA & the Gulf
- Contracts
- No lock-in, monthly rolling
- Working since
- 2023