Bank Reconciliation Calculator
Test cases replayed : 2 of 2 match · Methodology · No outside source listed
Bring the bank statement balance and your book balance to the same adjusted cash figure.
Result
Difference
Adjusted bank balance ($)
- Adjusted book balance ($)
- Result
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Balance on the bank statement, in dollars: enter a number.
- Deposits in transit, in dollars: enter 0 or more.
- Outstanding checks, in dollars: enter 0 or more.
- Bank errors to correct (+ or −, $): enter a number.
- Balance in your books, in dollars: enter a number.
- Interest and collections credited by the bank, in dollars: enter 0 or more.
- Bank service fees, in dollars: enter 0 or more.
- NSF (bounced) checks, in dollars: enter 0 or more.
- Book errors to correct (+ or −, $): enter a number.
- Read the result: Difference; the panel also shows Adjusted bank balance ($), Adjusted book balance ($) and Result.
How this calculator works
Adjusted bank balance = statement balance + deposits in transit − outstanding checks ± bank errors.
Adjusted book balance = book balance + interest and collections − bank fees − NSF checks ± book errors. The two must be equal; items on the book side need a journal entry.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Balance on the bank statement | $ | |
| Deposits in transit | $ | |
| Outstanding checks | $ | |
| Bank errors to correct (+ or −, $) | ||
| Balance in your books | $ | |
| Interest and collections credited by the bank | $ | |
| Bank service fees | $ | |
| NSF (bounced) checks | $ | |
| Book errors to correct (+ or −, $) | ||
| Adjusted bank balance | $ | |
| Adjusted book balance | $ | |
| Difference | $ |
Worked example
| Balance on the bank statement | $12,500 |
|---|---|
| Deposits in transit | $1,800 |
| Outstanding checks | $2,300 |
| Bank errors to correct (+ or −, $) | 0 |
| Balance in your books | $12,040 |
| Interest and collections credited by the bank | $150 |
| Bank service fees | $40 |
| NSF (bounced) checks | $150 |
| Book errors to correct (+ or −, $) | 0 |
| Adjusted bank balance ($) | $12,000.00 |
|---|---|
| Adjusted book balance ($) | $12,000.00 |
| Result | Reconciled: the adjusted balances agree |
Difference $0.00
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What goes on the bank side of a reconciliation?
Items the bank has not recorded yet: deposits in transit, outstanding checks, and the bank's own errors.
What goes on the book side?
Items the bank recorded that are not yet in your books: interest earned, collections, service fees and bounced checks, plus your own errors.