Skip to content
FiftyCalc Free calculators for all 50 states

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

Sample figures

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.

Bank Reconciliation Calculator

Balance on the bank statement, in dollars: enter a number. Prefilled example: 12,500.

Deposits in transit, in dollars: enter 0 or more. Prefilled example: 1,800.

Outstanding checks, in dollars: enter 0 or more. Prefilled example: 2,300.

Bank errors to correct (+ or −, $): enter a number. Prefilled example: 0.

Balance in your books, in dollars: enter a number. Prefilled example: 12,040.

Interest and collections credited by the bank, in dollars: enter 0 or more. Prefilled example: 150.

Bank service fees, in dollars: enter 0 or more. Prefilled example: 40.

NSF (bounced) checks, in dollars: enter 0 or more. Prefilled example: 150.

Book errors to correct (+ or −, $): enter a number. Prefilled example: 0.

How to use this calculator

Fill in the fields in this order; each step takes you to its field.

  1. Balance on the bank statement, in dollars: enter a number.
  2. Deposits in transit, in dollars: enter 0 or more.
  3. Outstanding checks, in dollars: enter 0 or more.
  4. Bank errors to correct (+ or −, $): enter a number.
  5. Balance in your books, in dollars: enter a number.
  6. Interest and collections credited by the bank, in dollars: enter 0 or more.
  7. Bank service fees, in dollars: enter 0 or more.
  8. NSF (bounced) checks, in dollars: enter 0 or more.
  9. Book errors to correct (+ or −, $): enter a number.
  10. 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

  1. Ab=b+dit−oc+be
  2. Bk=bo+c−f−nsf+k
  3. D=Ab−Bk
Symbols used in the formula
SymbolMeaningUnit
bBalance on the bank statement$
ditDeposits in transit$
ocOutstanding checks$
beBank errors to correct (+ or −, $)
boBalance in your books$
cInterest and collections credited by the bank$
fBank service fees$
nsfNSF (bounced) checks$
kBook errors to correct (+ or −, $)
AbAdjusted bank balance$
BkAdjusted book balance$
DDifference$

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
ResultReconciled: the adjusted balances agree
  1. Ab=12,500+1,800−2,300+0=12,000
  2. Bk=12,040+150−40−150+0=12,000
  3. D=12,000−12,000=0

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.

Related calculators