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

--

Quick Answer: 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.

How to Calculate Bank Reconciliation Calculator

  1. Enter the statement and book balances: Start with the unreconciled ending balances.
  2. Add the reconciling items: Enter deposits in transit, outstanding checks, and other adjustments.
  3. Check the difference: If the result is zero, the account reconciles.

Bank Reconciliation Calculator Formula

Adjusted bank balance = Statement balance + Deposits in transit - Outstanding checks | Adjusted book balance = Book balance + Interest earned + Direct deposits - Bank charges - NSF checks
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

USA - Simple reconciliation
  • 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.

UK - With charges
  • 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.

EU - Cashbook items
  • 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.
Common adjustment types used in bank reconciliation.
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

Timing differences and bank-side or book-side adjustments cause the two balances to differ temporarily.

It means the adjusted balances match after all listed items are applied.

Yes. They are commonly treated as a book-side adjustment.
Planning note: This calculator is a planning aid and not a substitute for formal bookkeeping controls.

References

Last reviewed: March 30, 2026