To clean up old reconciling items, list every item on the reconciliation with its date and age it into buckets. Research the oldest first against bank records, payees and customers. Then void and reissue, correct, or write off each one with support, and set a monthly rule so new items cannot sit unexamined past one cycle.
Why old reconciling items pile up
Old reconciling items pile up because carrying an item forward is easier than resolving it. A reconciling item is any line that explains the gap between the bank balance and the book balance: an outstanding check, a deposit in transit, an unbooked fee. Each month the list is copied to the next reconciliation, and nobody owns the oldest lines.
The usual sources:
- Uncashed checks. A vendor lost the check, a former employee moved, or a refund was mailed to an old address.
- Errors disguised as timing items. A check recorded for the wrong amount stays partly outstanding forever, because the bank cleared a different figure.
- Deposits that never arrived. A deposit recorded twice, or a customer payment recorded before it was received, sits as a deposit in transit that never clears.
- Book-side items nobody posted. A fee or interest line marked "to be recorded" and then forgotten.
- Staff changes. A new bookkeeper inherits a list without the history behind it.
A list of old items is not harmless. It makes every reconciliation harder to review, it can hide new errors among the old ones, and it may include money that legally belongs to someone else.
Aging the list of old reconciling items
Aging sorts the reconciling items by how long they have been outstanding, so the work starts with the items most likely to be errors. An item that cleared within a few days is a normal timing difference. One that has sat for six months almost never is. Put each item in a bucket and label its type.
The table below is an example of an aged list for one operating account at 30 September. The items and amounts are invented.
| Item | Type | Date | Age bucket | Amount | Research result | Action |
|---|---|---|---|---|---|---|
| Check 1184, Pine Hill Hardware | Outstanding check | 12 Sep | Under 30 days | 640.00 | Normal timing | Leave |
| Check 1102, R. Alvarez, payroll | Outstanding check | 28 Apr | 90 to 180 days | 812.44 | Employee left; check never cashed | Contact payee; hold for unclaimed property |
| Deposit, Corner Bistro | Deposit in transit | 3 Mar | Over 180 days | 1,450.00 | Same deposit recorded on 1 Mar and 3 Mar | Reverse duplicate |
| Check 1067, Valley Signs | Outstanding check | 9 Feb | Over 180 days | 300.00 | Cleared at 30.00 in Feb | Correct the ledger amount |
| Wire fee, to be recorded | Book-side item | 15 Jan | Over 180 days | 25.00 | Fee shown on January statement | Book the fee |
| "Difference" | Unknown | 31 Dec | Over 180 days | 118.20 | No support found | Document; write off with approval |
Buckets of under 30 days, 30 to 90, 90 to 180 and over 180 days work for most small businesses. Use whatever split your close policy sets, but keep it the same each month so the list can be compared.
The type column matters as much as the age. Outstanding checks need payee research. Deposits in transit need customer and bank research. Book-side items just need posting. Unknown items need the most care.
How do you research an old outstanding check or deposit?
Research an old outstanding check by looking at the bank's record first and the payee second. Search the statements for the check number and the amount, including amounts that are close. For an old deposit, search the statements for the amount, then confirm with the customer how and when they paid.
For outstanding checks:
- Search every statement since the check date for its number. A check can clear under a different amount, and a check that cleared for a different amount explains how to handle that difference.
- Search for the amount alone. A check can clear with an unreadable or wrong number.
- Check whether the check was voided in the books but not on the reconciliation, or the reverse.
- Contact the payee. Ask whether they received it and whether they still expect payment.
- Ask the bank whether a stop payment was ever placed on it.
For deposits in transit:
- Search for the amount on later statements, and for amounts that add up to it.
- Look for a second entry of the same deposit in the ledger.
- Ask the customer for proof of payment, such as a bank reference or a canceled check.
- Check whether the deposit went into a different account at the same bank.
Write down what you found for each item, even when the answer is "nothing". That note is the support for whatever action follows.
Voiding, reissuing or writing off old reconciling items
The action for each old item depends on what the research found, not on its age. An error gets corrected. A genuine uncashed check gets voided and either reissued or reported. An item with no support gets documented and written off with approval. Matching the action to the finding keeps the books right.
The common actions:
- Void and reissue. The payee confirms they never cashed the check and still want payment. Place a stop payment, void the old check in the books, and issue a new one.
- Void and hold as a liability. The payee cannot be reached. Void the check, but credit a liability account rather than income or expense, because the money is still owed. See the unclaimed property section below.
- Correct the entry. The item is an error: a duplicate deposit, a check booked for the wrong amount, a fee never posted. Book the correction in the current period with a description of the original entry.
- Write off. No support exists and the research is documented. Book the amount to a miscellaneous account with reviewer approval.
Each correction should be dated in the current open period. Editing closed months changes reports already relied on and breaks the reconciliations that were signed.
Old uncashed checks and unclaimed property rules
An old uncashed check usually cannot be voided back into the business's own income. The money still belongs to the payee. US states run unclaimed property programs, and after a set dormancy period with no contact, the holder must turn the property over to the state. Uncashed payroll and vendor checks are common examples.
The National Association of Unclaimed Property Administrators lists uncashed payroll checks among the usual types of unclaimed property and describes the dormancy period, a designated time with no activity or contact, after which the property goes to the state. Dormancy periods and reporting dates vary by state and by property type, so check the rules of the state that applies to the payee's last known address.
In practice:
- Move voided uncashed checks to an unclaimed property liability account, not to income.
- Keep the evidence of your attempts to reach the payee.
- Track each item's dormancy date and report it when due.
The same caution applies with more force to accounts that hold other people's money. In a title or escrow account, an old outstanding check is a disbursement owed to a party to the closing, and title escrow reconciliation covers the stricter rules there.
What if an old reconciling item has no support at all?
An old reconciling item with no support is one nobody can explain: no matching document, no bank record, no payee. It often has a vague label such as "difference" or "adjustment". Treat it as a possible error first, then as a candidate for write-off once the search is documented and a reviewer agrees.
Before writing it off, try these:
- Find the month it first appeared. The reconciliation for that month may show what changed.
- Divide the amount by nine. A clean result suggests a transposition or slide error in a nearby entry.
- Check whether it equals the sum or the difference of two other items on the list.
- Look at the entry that created it. A user name and date can point to who might remember.
If nothing works, record what you checked and ask a reviewer to approve the write-off. If the amount is large, or several unsupported items run in the same direction, stop and look at it as a control problem rather than a bookkeeping one. The full catalogue of error types and their tests is in the bank reconciliation errors that cause most differences.
Keeping cleaned-up reconciling items from coming back
A clean list stays clean only with a monthly rule. The simplest rule is an age limit: any item older than one statement cycle is researched before the reconciliation is signed. Book-side items are posted in the same month, never carried. The reviewer checks the aged list, not just the totals.
A monthly routine:
- Age the reconciling items every month, using the same buckets.
- Post every book-side item before sign-off.
- Research anything past 30 days and write the finding on the list.
- Review outstanding checks at 90 days and contact the payee.
- Have the reviewer initial the aged list, not just the summary.
It helps to see the list from the bank side as well. PreciseBankFlow extracts each statement line and matches it to your ledger, so the items still unmatched after each month are listed as exceptions with their dates, ready to age.