Bank Reconciliation Calculator

Enter your ending bank statement balance, outstanding checks, deposits in transit, and any errors to calculate adjusted balances and instantly see whether your records reconcile.
Luis GonzalezCreated by Luis GonzalezLast updated:

How to Use This Calculator

  1. 1

    Enter Your Balances and Adjustments

    Input the ending bank statement balance, outstanding checks, deposits in transit, bank errors, and your own book errors.

  2. 2

    Review Your Reconciliation Results

    The calculator displays three result cards — Adjusted Bank Balance, Adjusted Book Balance, and Reconciliation Health — plus an insights card showing the reconciliation status, outstanding checks, deposits in transit, and net bank-side adjustments.

Example Calculation

A small business owner reconciles their bank statement with ending balance $5,000, outstanding checks of $800, deposits in transit of $400, a $50 bank error, and $20 in their own book errors.

Ending Bank Statement Balance ($)

$5,000

Outstanding Checks ($)

$800

Deposits in Transit ($)

$400

Bank Errors ($)

$50

Your Errors ($)

$20

Results

Adjusted Bank Balance

$4,650.00 (Net $350.00 deducted from bank balance)

Adjusted Book Balance

$4,980.00 ($20.00 deducted for your errors)

Reconciliation Health

93% (Excellent — minor variance only)

Insights card shows reconciliation status (Books $330.

Tips

Watch Outstanding Checks Closely

With $800 in outstanding checks on a $5,000 balance, the adjusted bank balance drops to $4,650. If those checks grew to $2,000, the adjusted bank balance would fall to $3,450 and reconciliation health would drop from 93% to 69% — flagging a significant discrepancy.

Correct Bank Errors Promptly

A $50 bank error on a $5,000 balance keeps health at 93%. But increasing that correction to $200 raises the adjusted bank balance to $4,800 and improves health to 96%, showing how catching larger bank mistakes tightens your reconciliation.

Aim for 100% Reconciliation Health

When all outstanding checks, deposits in transit, and errors net to zero on a $10,000 balance, the calculator shows a perfect 100% health score with both adjusted balances matching at $10,000. Any score below 90% warrants immediate investigation.

Track Deposits in Transit Separately

With an $8,000 balance, $1,200 in outstanding checks, and a $600 deposit in transit, the adjusted bank balance is $7,400 versus the $8,000 book balance — a $600 gap and 93% health. Logging each pending deposit individually helps you trace exactly which items clear and which remain outstanding.

The Formulas Behind Bank Reconciliation

The calculator applies two separate adjustments to arrive at reconciled balances:

Adjusted Bank Balance = Ending Bank Statement Balance - Outstanding Checks + Deposits in Transit + Bank Errors
Adjusted Book Balance = Ending Bank Statement Balance - Your Errors
Reconciliation Health = (1 - |Adjusted Bank Balance - Adjusted Book Balance| / Ending Balance) x 100

Outstanding checks reduce the bank balance because the cash has left your books but not the bank.

Deposits in transit increase it because the bank has not yet credited them.

Bank errors correct the bank's mistakes, while your errors correct your own records.

💡 Once your cash position is reconciled, measure how efficiently that cash cycles through your business with our Cash Conversion Cycle Calculator.

Worked Example: Small Business Reconciliation

Consider a business with a $5,000 ending bank statement balance, $800 in outstanding checks, $400 in deposits in transit, a $50 bank error, and $20 in book errors:

Item Amount
Ending Bank Statement Balance $5,000.00
- Outstanding Checks -$800.00
+ Deposits in Transit +$400.00
+ Bank Errors +$50.00
Adjusted Bank Balance $4,650.00
Item Amount
Ending Bank Statement Balance $5,000.00
- Your Errors -$20.00
Adjusted Book Balance $4,980.00

The $330 discrepancy (books higher than bank) produces a 93% reconciliation health score.

To reach 100%, you would need to identify and resolve the remaining timing differences or errors causing that gap.

When Reconciliation Health Drops Below 70%

If outstanding checks jump to $2,000 with all other inputs unchanged, the adjusted bank balance falls to $3,450 while the book balance stays at $4,980 — a $1,530 gap and only 69% health.

This typically signals unrecorded transactions, duplicate payments, or checks that should have cleared weeks ago.

Investigate by matching each outstanding check to its payee and date, and confirm deposits in transit with bank confirmation receipts.

💡 Need to track how much cash your business keeps on hand relative to liabilities? Our Cash Ratio Calculator helps evaluate your short-term liquidity position.

Frequently Asked Questions

How is the adjusted bank balance calculated?

The formula is: Adjusted Bank Balance = Ending Bank Statement Balance - Outstanding Checks + Deposits in Transit + Bank Errors. For example, with a $5,000 ending balance, $800 in outstanding checks, $400 in deposits in transit, and $50 in bank errors, the adjusted bank balance is $5,000 - $800 + $400 + $50 = $4,650.

How is the adjusted book balance calculated?

The formula is: Adjusted Book Balance = Ending Bank Statement Balance - Your Errors. With a $5,000 ending balance and $20 in your own errors, the adjusted book balance is $5,000 - $20 = $4,980.

What does the reconciliation health score mean?

The health score measures how close your adjusted bank and book balances are, on a 0-100% scale. It is calculated as (1 - |Difference| / Ending Balance) x 100. A $330 discrepancy on a $5,000 balance yields 93%. A score of 100% means the accounts are fully reconciled; below 70% indicates a significant discrepancy requiring investigation.

Why might my adjusted bank balance differ from my adjusted book balance?

The difference arises because bank-side adjustments (outstanding checks, deposits in transit, bank errors) may not offset book-side adjustments (your errors). In the default example, bank-side adjustments net to -$350 while book-side adjustments are -$20, producing a $330 gap.

What are deposits in transit?

Deposits in transit are cash or checks recorded in your books but not yet processed by the bank. For instance, a $400 deposit made at month-end adds to the adjusted bank balance because the bank has not yet credited it. These typically clear within 1-2 business days.

What happens when outstanding checks increase significantly?

Large outstanding checks widen the gap. Increasing outstanding checks from $800 to $2,000 (with all other defaults the same) drops the adjusted bank balance from $4,650 to $3,450 and the health score from 93% to 69%, flagging a poor reconciliation that needs prompt attention.