Bank Reconciliation Calculator
Compare bank and book balances after the usual reconciliation adjustments. This page also keeps the formula, examples, FAQs, and references close by so you can check the result with confidence.
What This Bank Reconciliation Calculator Helps You Do
A good reconciliation brings the adjusted bank balance and the adjusted book balance to the same number. Review the formula and examples below if you want to see how the result is derived.
This page is meant to give you a fast answer, but it also helps you double-check the math before you make a decision. Start with the inputs that you already know, run the calculation, and then compare the output with the formula, examples, and FAQs below so you can see whether the answer fits the situation you are modeling.
If the result looks off, the usual causes are a unit mismatch, a missing decimal, the wrong scenario, or a value that needs to be entered as a rate instead of a total. The notes on this page are designed to make those checks easy without forcing you to leave the calculator and search for context elsewhere.
- Use the calculator first for a quick estimate.
- Use the formula to understand how the result is built.
- Use the examples to compare common use cases.
- Use the references when the answer depends on a standard or assumption.
Common Checks
A quick result is useful, but the best result is one that still makes sense when you look at it a second time. If you are comparing scenarios, try changing one input at a time so you can see which variable has the biggest impact on the final answer. That makes it much easier to spot whether the calculation matches your expectations.
It also helps to keep the context of the problem in mind. A calculator can tell you the math, but you still need to decide whether the input represents a total, a rate, an average, or a category-specific assumption. When in doubt, start with a simple example from the page and scale up from there.
- Check that every unit matches the rest of the problem.
- Keep rates, totals, and averages separate.
- Adjust one variable at a time when testing scenarios.
- Use the smallest realistic input first, then scale upward.
Scenario Planning
This calculator is especially useful when you want a quick answer before you commit time, money, or effort. Try one baseline input set, then change a single number and compare the result so you can see how sensitive the answer is to that variable.
That makes the page useful for more than just arithmetic. It becomes a small decision aid that helps you compare options, test assumptions, and explain the final number with confidence when you need to share it with someone else.
Result
--
How to Calculate Bank Reconciliation Calculator
- Enter the statement and book balances: Start with the unreconciled ending balances.
- Add the reconciling items: Enter deposits in transit, outstanding checks, and other adjustments.
- Check the difference: If the result is zero, the account reconciles.
Bank Reconciliation Calculator Formula
| Variable | Meaning | Unit |
|---|---|---|
| Statement balance | Ending balance on the bank statement | $ |
| Book balance | Ending balance in your books | $ |
| Adjustments | Timing and correction items | $ |
Worked Examples
- Bank statement balance: $42,500
- Deposits in transit: $3,500
- Outstanding checks: $2,800
- Book balance: $41,725
Result: $0.00
The account reconciles when the adjustments are entered correctly.
- Bank statement balance: £18,200
- Deposits in transit: £1,100
- Outstanding checks: £900
- Book balance: £18,350
Result: £50.00
A small difference suggests one adjustment may be missing.
- Bank statement balance: €9,800
- Deposits in transit: €500
- Outstanding checks: €300
- Book balance: €9,900
Result: -€100.00
The book side is higher after the listed adjustments.
Reconciliation reference
Common adjustment types used in bank reconciliation.
| Range | Meaning | Action |
|---|---|---|
| Zero difference | The account reconciles | File the reconciliation and keep the support schedule. |
| Small difference | One item may be missing | Review timing differences and bank charges. |
| Large difference | A reconciliation item is likely wrong | Check the balance source and adjustment list. |
| Item | Meaning | Direction |
|---|---|---|
| Deposits in transit | Cash recorded by the company but not yet on the bank statement | Add to the bank side |
| Outstanding checks | Checks written but not yet cleared | Subtract from the bank side |
| Bank charges | Fees charged by the bank | Subtract from the book side |
| Interest earned | Interest credited by the bank | Add to the book side |
Frequently Asked Questions
References
Last reviewed: March 30, 2026