Bank Reconciliation Calculator

Written by Great Medico

Updated September 25, 2026 •2 min read

Share Print Save

Bank Reconciliation Calculator turns the values on the form into a focused planning estimate. It compares an adjusted bank-statement balance with an adjusted book balance after accounting for deposits in transit, outstanding checks, bank fees, and interest not yet recorded and keeps the arithmetic visible enough to sanity-check.

What this calculator does

Bank Reconciliation Calculator compares an adjusted bank-statement balance with an adjusted book balance after accounting for deposits in transit, outstanding checks, bank fees, and interest not yet recorded. The form asks for ending bank statement balance, deposits in transit, outstanding checks, bank fees not yet recorded, interest earned not yet recorded, and company book balance. The result should therefore be read as a calculation from those displayed assumptions, not as live market, lender, tax, or government-program data unless the page explicitly supplies such a feed.

How to use it

Enter Ending bank statement balance, Deposits in transit, Outstanding checks, Bank fees not yet recorded, Interest earned not yet recorded, and Company book balance. Keep monetary inputs in one currency; the currency selector formats results and does not convert exchange rates. Before calculating, recheck Ending bank statement balance, Deposits in transit, Outstanding checks against the source values you intend to model. If a default value is already filled in, confirm that it matches the scenario you actually want to test rather than assuming the preset is current or personally appropriate.

How the calculation works

Adjusted bank balance = bank statement balance + deposits in transit − outstanding checks. Adjusted book balance = book balance − bank fees + interest earned. Reconciliation difference = adjusted bank balance − adjusted book balance. This is the calculation method to use when checking the result from Bank Reconciliation Calculator; values not represented by a visible input should not be inferred as part of the model.

Example

With a $10,000 bank statement balance, $1,200 deposits in transit, and $900 outstanding checks, the adjusted bank balance is $10,300. A $10,275 book balance minus $35 of bank fees plus $10 of interest is $10,250, leaving a $50 difference to investigate.

How to interpret the result

A result near zero means the entered reconciling items bring the bank side and book side together. A nonzero difference is an amount to investigate, not automatically an accounting loss or gain. Keep the assumptions with the result so a later recalculation can be compared consistently.

Limitations and notes

The calculator includes only the reconciliation items shown. Errors, duplicate postings, NSF items, merchant fees, automatic payments, timing differences, and bookkeeping adjustments not entered remain outside the result. Rounding and timing conventions can cause a real statement or account balance to differ slightly from the model.