Bank reconciliation calculator

Bank reconciliation is the month-end control that explains why the cash figure printed on a bank statement almost never equals the cash figure sitting in the general ledger on the same date. Timing items — checks the company has written but the bank has not yet paid, and deposits the books have already recorded that have not yet posted to the statement — sit between those two totals until they clear. This bank reconciliation calculator accepts four finite amounts: the ending statement balance, outstanding checks, deposits in transit, and the book (cash-ledger) balance. It forms the adjusted bank figure as statement plus deposits in transit minus outstanding checks, then reports that adjusted balance and the difference versus the books. A zero difference means the two records meet on the same cash total; a non-zero difference flags an unrecorded bank charge, an NSF check, a transposition, or another item that still has to be booked.

What the four figures mean and how the adjusted balance is formed

A bank statement is a third-party snapshot of cash the depository has posted through a cutoff date. The cash book, or cash ledger, is the company's own running record of the same cash. Those two numbers disagree on most closing days for reasons that are ordinary, not fraudulent: checks the company has already recorded as disbursements but that payees have not yet presented, and deposits the company has already recorded as receipts that arrived at the bank after the statement cutoff.

Those two timing items are called outstanding checks and deposits in transit. The textbook bank-side adjustment is therefore mechanical. Start with the ending statement balance, add every deposit in transit, and subtract the total of outstanding checks.

The result is the adjusted bank balance — the cash figure both records should share after timing items are recognized. This calculator treats the book balance as already complete on the ledger side, so the adjusted balance it returns is that bank-side figure, and the difference is adjusted balance minus book balance. When the difference is zero, the statement and the books have been reconciled to the same cash total.

When it is not zero, something besides timing remains: a service charge or interest the books have not yet recorded, an NSF check, a deposit recorded at the wrong amount, a check the bank paid that is not on the outstanding list, or a simple transposition. The calculator does not invent those book-side items; it surfaces the dollar gap so a bookkeeper can find them.

Amounts may be positive, negative, or zero so a reversing correction can be entered as a signed number; the only hard rule is that every amount must be a finite number.

Where a bank reconciliation calculator earns its keep

Controllers and bookkeepers run a bank reconciliation calculator at month-end so they can confirm cash before they close the period, without rebuilding a spreadsheet each time the bank file is late. Accounting classrooms and exam-prep courses use the same four-field contract so learners can check that they added deposits in transit and subtracted outstanding checks in the right order, and so a grader can treat a non-zero difference as a signal to look for a missing fee instead of a silent pass. Failed validation does not consume balance.

Keep requests small, pin the rounded cents in tests, and you get a reproducible adjusted balance and difference for close packages, course plugins, and edge workers without standing up a general ledger of your own. Use the difference as a tick mark: zero means the timing items explain the gap; anything else means another reconciling item still has to be found and booked.