Month·End·Close
← Month-End Close

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.

SideItemEffect
BankDeposit in transit: recorded in the books, not yet on the statementAdds to the statement balance
BankOutstanding check or payment: recorded in the books, not yet cleared the bankSubtracts from the statement balance
BankBank error: the bank recorded something wrongCorrects the statement balance, either way
BookUnrecorded receipt: interest, a customer payment or a deposit the bank has and the books don'tAdds to the GL balance
BookUnrecorded fee, charge or debit: bank fees, a returned (NSF) check, an automatic paymentSubtracts from the GL balance
BookBook error: the books recorded something wrongCorrects 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.

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.