Tools
Bank reconciliation calculator with stale-item flags
Enter the statement balance, the GL cash balance and the items that didn't match. You get the adjusted bank and book balances, the unexplained difference in dollars, where to look when it isn't zero, which items are getting old, and the entries the books still need.
Most bank reconciliation calculators stop at "doesn't tie." The useful part is what comes next: which item, if it were entered differently, would close the gap, and which items have sat on the list long enough that someone should ask about them.
Runs entirely in your browser. Nothing you paste is uploaded or stored; it stays in your browser.
Balances
The aging limits are yours to set. Leave them blank and nothing is flagged for age.
Reconciling items
One row per item, tab or comma separated, copied straight from Excel: type, amount, date (optional), description (optional). Types: deposit in transit, outstanding check (or payment), unrecorded receipt (or interest), bank fee (or service charge, NSF, auto-debit), bank error, book error. Amounts are positive; the type sets the direction. For a bank or book error, use a signed amount: positive if correcting it raises that side's balance, negative if it lowers it. A header row is fine; dates are read month first.
How it's calculated
A bank reconciliation explains the difference between two numbers that should agree: the balance on the bank statement and the cash balance in the general ledger. Each reconciling item belongs to one side. Items the books have and the bank doesn't yet adjust the bank side. Items the bank has and the books don't yet adjust the book side.
| Side | Item | Effect |
|---|---|---|
| Bank | Deposit in transit: recorded in the books, not yet on the statement | Adds to the statement balance |
| Bank | Outstanding check or payment: recorded in the books, not yet cleared the bank | Subtracts from the statement balance |
| Bank | Bank error: the bank recorded something wrong | Corrects the statement balance, either way |
| Book | Unrecorded receipt: interest, a customer payment or a deposit the bank has and the books don't | Adds to the GL balance |
| Book | Unrecorded fee, charge or debit: bank fees, a returned (NSF) check, an automatic payment | Subtracts from the GL balance |
| Book | Book error: the books recorded something wrong | Corrects the GL balance, either way |
Adjusted bank is the statement balance after the bank-side items. Adjusted book is the GL balance after the book-side items. When the list is complete and right, they're equal. The unexplained difference is adjusted bank minus adjusted book, in dollars, and it's the number that matters: anything other than zero means the list is missing something or has something wrong.
When it doesn't tie: where to look
The tool tests a few things that close a gap exactly. They're computed, not guessed, but they're leads: a match tells you where to look first, not what happened.
- An item equal to the gap. Taking it off the list would close the gap, so check whether it's entered twice, or has already cleared or been booked.
- An item equal to half the gap. Entering an item with the opposite effect moves the gap by twice its amount. A deposit entered as a check, a bank item entered as a book item, or an error with the wrong sign all look like this.
- Two swapped digits. If swapping two neighboring digits in an item, the statement balance or the GL balance would close the gap, the tool says which one. Any gap from swapped digits divides evenly by 9, so the page also notes when the gap does, as a weaker lead.
- What a missing item would look like. Whether the gap needs a bank-side subtraction or a book-side addition, or the reverse, narrows what to search for.
Items that are getting old
A deposit in transit should clear within a few business days. The tool ages deposits in transit in weekdays, Monday to Friday, with no holiday calendar, so a deposit that spans a bank holiday counts a day older for each holiday than the bank would; outstanding checks are aged in calendar days. A deposit that hasn't cleared is worth tracing before the reconciliation is signed, because a deposit recorded in the books that never reaches the bank is exactly the kind of item a reconciliation exists to catch. Outstanding checks that sit for months need a decision too: contact the payee, void and reissue, or follow your unclaimed-property process. The limits for both are yours; the tool only applies them.
The entries the books still need
Every book-side item means the bank recorded something the books haven't, so each one needs an entry: bank fees to expense, interest to income, a returned customer check back to receivables, and so on. The tool lists them with suggested accounts and shows the cash balance they'd produce. Use the account the source document supports; the suggestions are a starting point, not a chart of accounts.
What it doesn't do
It doesn't match transactions. You bring the list of items that didn't match, from your bank feed, your ERP's reconciliation screen or a tick-and-tie. It covers one bank account at a time, in one currency. Unapplied or misapplied customer payments don't belong here: they don't change the cash balance, so they never appear on a bank reconciliation. That's a receivables question, covered in why month-end close takes so long to start. And it doesn't book anything; it gives you the entries to book.
The balances and items in the worked examples are synthetic.
A cash balance that ties is one less question in the monthly flux review. The free flux template flags the accounts that moved enough to need explaining; the other free tools help with the explaining.
Related: bank reconciling items, what each one means, who owns it and which need an entry; why month-end close takes so long to start, where the bank rec and receivables loop slows everything down; when the GL doesn't match the trial balance; and balance sheet flux analysis.
Found something wrong or missing? Tell me here — anonymous, thirty seconds.