Bank Reconciliation Calculator applies deposits in transit, outstanding checks, bank interest, and fees to your statement and cash book balances to confirm whether they match.
Reconcile a Bank Statement Against Your Cash Book Balance
This calculator applies deposits in transit, outstanding checks, bank interest, and bank fees to your bank statement and cash book balances to show whether the two records agree. Bookkeepers, small business owners, and accountants use it during monthly closing to locate and quantify any gap between what the bank shows and what the books show.
Enter Starting Balances and Reconciling Items
Enter your bank statement balance, deposits in transit, and outstanding checks, plus your cash book balance, bank interest or credits, bank fees or NSF charges, and any other book adjustment, all in your selected currency. The calculator returns adjusted bank and book balances and flags any remaining discrepancy.
How the Adjusted Balance Method Reconciles Bank and Book Records
The calculator applies the adjusted balance method, the standard bank reconciliation approach described in financial accounting references such as AccountingCoach’s explanation of bank reconciliation. On the bank side, it adds deposits in transit and subtracts outstanding checks from the bank statement balance:
$$\text{Adjusted Bank Balance} = \text{Bank Statement Balance} + \text{Deposits in Transit} – \text{Outstanding Checks}$$
On the book side, it adds bank interest or credits, subtracts bank fees or NSF charges, and applies any other adjustment to the cash book balance:
$$\text{Adjusted Book Balance} = \text{Cash Book Balance} + \text{Interest} – \text{Fees} \pm \text{Other Adjustments}$$
The two adjusted balances are then compared, and the accounts are reconciled when the difference equals zero. A common input mistake is entering outstanding checks or bank fees as negative numbers; the calculator already subtracts those fields based on their position in the formula, so a negative entry doubles the reduction instead of correcting it.
Because the formula is purely additive and subtractive, a negative starting balance is a valid input and correctly represents an overdrawn account rather than breaking the math. One less obvious interaction: the percentage-shift figures shown alongside each adjusted balance divide the adjustment by the starting balance, so when a starting balance is at or near zero, that percentage becomes very large or meaningless even though the dollar-value adjustment is accurate; in that case, read the dollar figures rather than the percentage.
The output reflects only the figures entered and does not verify individual transactions against source documents, so it functions as a computational aid for the reconciliation process rather than a substitute for reviewing the underlying bank statement and ledger, or for guidance from an accountant when a discrepancy can’t be traced to a specific item.
Bank Side and Book Side Converging on the Same Adjusted Balance
Bank Reconciliation Calculator Questions Answered
What happens if I enter outstanding checks as a negative number?
Entering outstanding checks or bank fees as negative numbers doubles the reduction, since the calculator already subtracts those fields internally based on their position in the adjusted balance method. Enter them as positive amounts; the field label already indicates the direction.
What does a nonzero discrepancy actually mean?
A discrepancy means your adjusted bank balance and adjusted book balance do not match after applying deposits in transit, outstanding checks, interest, and fees. Recheck each adjustment for missing or duplicated items, and confirm the starting balances were not swapped.
Can I reconcile an overdrawn or negative bank balance?
Yes. Because the adjusted balance method is purely additive and subtractive, a negative starting balance still produces a mathematically valid adjusted balance and discrepancy figure, reflecting an account that is overdrawn rather than in credit.
What’s the difference between deposits in transit and outstanding checks?
Deposits in transit are payments you have recorded and deposited that the bank has not yet processed. Outstanding checks are payments you have written and recorded that have not yet cleared the bank, so the bank statement does not reflect them yet.
Why does the percentage-shift figure look unusually large?
The percentage shift figures compare an adjustment to a starting balance near zero, which can produce a very large or misleading percentage. When a starting balance is at or near zero, review the dollar amounts directly rather than the percentage.