Every bank reconciliation difference has a name. Once you can name it, you know what to do with it.
Bank reconciling items fall into two groups. Timing items, such as outstanding cheques and deposits in transit, are already in your ledger and will appear on the bank statement soon. Items missing from your ledger, such as bank charges, interest, direct debits and bank errors, need a journal or a call to the bank. Old timing items should be investigated, not carried forward forever.
| Item | In the ledger? | On the statement? | Action |
|---|---|---|---|
| Outstanding cheque (or payment) | Yes | Not yet | Reconciling item; clears when presented |
| Deposit in transit | Yes | Not yet | Reconciling item; clears in a few days |
| Bank charges and fees | No | Yes | Post a journal |
| Interest received | No | Yes | Post a journal |
| Direct debits not yet recorded | No | Yes | Post, and check they are authorised |
| Returned or bounced payments | Usually no | Yes | Reverse the receipt; chase the customer |
| Bank error | — | Yes | Ask the bank to correct it; don't post it |
A cheque you've written and recorded but the payee hasn't banked. Normal for a few weeks. If it is still outstanding after several months, contact the payee: the cheque may be lost, and you still owe the money. Depending on local rules, very old unclaimed amounts may have to be treated as unclaimed property rather than simply written back.
Money you've recorded as received but the bank hasn't credited yet, usually because it arrived on the last day of the month. It should clear within a few business days. A deposit in transit that doesn't clear quickly is a red flag: the money may never have been banked.
Bank charges, interest and direct debits should be posted in the same month they appear on the statement. Before posting a direct debit, check that it is expected: an unfamiliar one can be an unauthorised collection.
Set an age limit, for example 60 or 90 days, after which any reconciling item must be investigated and escalated. A reconciliation that "agrees" because of a list of years-old items isn't really agreeing.
Match ledger and statement lines by amount and date window, then list what is left on each side. The XLOOKUP matching method does this in a few formulas, and the bank reconciliation in Excel guide covers the full layout and sign-off.
The person who prepares the bank reconciliation shouldn't be the person who can make payments. A reviewer checks each reconciling item against the next statement: outstanding payments and deposits in transit should clear within days. If they don't, the reviewer asks why before signing.
UK teams say "unpresented cheques" and "outstanding lodgements"; US teams say "outstanding checks" and "deposits in transit". Rules on very old unclaimed payments differ by country and, in the US, by state.
AI software that matches your bank statement to your ledger on your own computer and builds the reconciliation statement. $1,997 once-off; see it on the built-in example first.
The Bank Reconciliation Template reconciles up to five bank accounts across eight transaction categories, with an allocation check that confirms every transaction is coded before the reconciliation counts as clean. Excel, no macros, one-time price.
Money recorded in your books as received but not yet credited by the bank at the statement date, usually because it arrived at month end.
There is no single rule, but anything older than a few months should be investigated. Contact the payee and check local rules on unclaimed money.
No. Your ledger is right; the bank is wrong. Show it as a reconciling item and ask the bank to correct it.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.