Bank Reconciliation Imbalance Calculator

Calculator

Currency symbol

Bank statement ending balance

Book cash ending balance

Deposits in transit

Outstanding checks

Bank error to add

Bank error to deduct

Bank collections or credits

Interest income

Direct deposits or transfers

Bank fees and service charges

NSF or returned checks

Automatic payments or loan debits

Book error to add

Book error to deduct

Rounding tolerance

Known transaction amounts to test

Reviewer note

Clear

Formula Used

Adjusted Bank Balance = Statement Balance + Deposits in Transit - Outstanding Checks + Bank Error Add - Bank Error Deduct

Adjusted Book Balance = Book Balance + Bank Collections + Interest Income + Direct Deposits - Bank Fees - NSF Checks - Automatic Payments + Book Error Add - Book Error Deduct

Difference = Adjusted Bank Balance - Adjusted Book Balance

Status Rule = Balanced when absolute difference is less than or equal to tolerance.

How to Use This Calculator

Enter the bank statement ending balance.
Enter the book cash account ending balance.
Add deposits in transit and outstanding checks.
Enter bank-side errors, if the bank made a mistake.
Add bank credits, interest, fees, NSF items, and autopayments.
Enter book correction fields when the ledger needs adjustment.
Add known transaction amounts for diagnostic matching.
Press calculate and review the difference.
Download the CSV or PDF report for records.

Example Data Table

Item	Example Amount	Side
Bank statement ending balance	$50,000.00	Bank
Book cash ending balance	$52,240.00	Book
Deposits in transit	$7,250.00	Bank adjustment
Outstanding checks	$4,120.00	Bank adjustment
Bank collections	$1,000.00	Book adjustment
Interest income	$25.00	Book adjustment
Bank fees	$35.00	Book adjustment
NSF checks	$100.00	Book adjustment
Adjusted bank balance	$53,130.00	Result
Adjusted book balance	$53,130.00	Result
Unexplained difference	$0.00	Balanced

Bank Reconciliation Imbalance Guide

Why the Reconciliation Fails

Bank reconciliation fails when two trusted records tell different stories. The statement shows what the bank cleared. The books show what the business recorded. A balanced reconciliation proves that timing items and corrections explain the gap.

Adjust the Bank Side

The first step is to adjust the bank side. Add deposits in transit because the business recorded them, but the bank has not cleared them. Subtract outstanding checks because they reduced the books, but not the statement. Then add or subtract known bank errors.

Adjust the Book Side

The second step is to adjust the book side. Add interest, collections, transfers, and other bank credits. Subtract service charges, returned checks, automatic payments, and loan debits. Correct book mistakes with increase or decrease fields. These entries should match the cash account after posting.

Read the Difference

The difference line is the key control. A zero difference means the reconciliation balances within tolerance. A positive difference means the adjusted bank side is higher. The book side may need an increase. A bank-side deduction may also be missing. A negative difference means the adjusted book side is higher. The books may need a decrease, or a bank-side addition may be missing.

Review Common Patterns

Good review work also checks patterns. If the difference is divisible by nine, a transposition or slide error may exist. If half the difference equals a transaction, a sign reversal may exist. If the full difference equals one known item, that item may be omitted, duplicated, or entered in the wrong column.

Use the Report

This calculator supports those checks in one place. It compares adjusted balances. It tests tolerance. It reviews likely causes. It creates a report for CSV and PDF export. It is useful during month end, audit review, and daily cash control.

Close the Gap

Use exact statement and ledger balances. Enter known timing items separately. Do not net deposits against checks. Keep charges, interest, and corrections in their own fields. Review the suggested causes after calculation. Then open the bank statement, cash ledger, and deposit log. Trace each item. Post valid book adjustments. Carry valid timing items forward. Recalculate until the difference is cleared. Always save supporting notes for reviewers. Clear notes explain why each adjustment exists. They also help managers avoid repeat mistakes in future reconciliations and cash close routines for every closed period.

FAQs

1. Why does my bank reconciliation not balance?

It usually fails because of timing items, omitted bank charges, missed deposits, outstanding checks, duplicated entries, or posting errors in the cash ledger.

2. What is an adjusted bank balance?

It is the bank statement balance after adding deposits in transit, subtracting outstanding checks, and correcting known bank errors.

3. What is an adjusted book balance?

It is the ledger cash balance after adding bank credits and subtracting bank debits that were not posted in the books.

4. What does a positive difference mean?

It means the adjusted bank balance is higher than the adjusted book balance. Review missing book increases or overstated book deductions.

5. What does a negative difference mean?

It means the adjusted book balance is higher than the adjusted bank balance. Review missing fees, NSF items, autopayments, or bank-side additions.

6. Why test if the difference is divisible by nine?

A difference divisible by nine can indicate a transposition or slide error. It is not proof, but it is a useful review clue.

7. Should bank fees be entered on the book side?

Yes. Bank fees reduce the book cash balance when they were charged by the bank but not recorded in the ledger.

8. Can I export the reconciliation result?

Yes. After calculation, use the CSV or PDF buttons to save the result, diagnostics, formulas, and review notes.