2026-11-10 · Accounting

Old Uncleared Checks in Your Bank Reconciliation: How to Clear Them Without Changing a Filed Year

↓ Get the free Excel + PDF kit for this article

Open almost any small-business bank reconciliation and you will find them at the bottom: checks from last year, or from 2023, that never cleared. Maybe a deposit or two that never reached the bank. Every month they roll forward, every month someone scrolls past them, and at year-end they quietly overstate what you owe or what you have. This post walks through a clean, repeatable way to clear them out, using QuickBooks Desktop, QuickBooks Online or just a spreadsheet, without reopening a year whose tax return is already filed.

Why old uncleared checks are more than clutter

An uncleared check means your books say the money left, but the bank says it is still in your account. Three things make old ones a real problem:

Timeline of an uncashed check from the issue date to stale at about 180 days, the payee letter, dormancy and the state report
Figure 1. The life of one uncashed check (example; your state's periods may differ).

Step 1: Get the list of uncleared items

QuickBooks Desktop

  1. Go to Reports > Banking > Previous Reconciliation, choose the bank account and your latest statement date, and pick the Detail report. Uncleared transactions are listed at the end.
  2. Or create Reports > Custom Reports > Transaction Detail, set the dates through your cleanup date, and on the Filters tab choose your bank account and Cleared = No.
  3. Export with Excel > Create New Worksheet.

QuickBooks Online

  1. Select Settings (gear) > Reconcile, then History by account. Choose the bank account and open the most recent reconciliation report; it shows the uncleared transactions as of that statement date.
  2. Or open the account register from the Chart of accounts (View register) and filter by reconcile status for items that are not cleared or reconciled.
  3. Export the report to Excel with the export icon. Menu names in QuickBooks Online change from time to time; if yours differ, search Intuit's help for "reconciliation report".

You only need five columns: Date, Type, Number, Name and Amount. Make check amounts positive with =ABS(E5).

Step 2: Age each item with three formulas

Put your cleanup date (for example 12/31/2026) in cell B1, your last closed tax year (for example 2025) in B2, and the dormancy years from your state's rules in B3. With dates in column A starting in row 5, type:

These formulas work the same in Excel and Google Sheets.

DateItemAmountAgeStaleClosed yearPast dormancy*
11/20/2026Check #2210186.4041NoNoNo
04/02/2026Check #2101950.00273YesNoNo
08/15/2025Check #1987640.00503YesYesNo
06/30/2023Check #16501,200.001280YesYesYes
10/30/2026Deposit1,500.0062YesNon/a

Table 1. EXAMPLE values. Cleanup date 12/31/2026, last closed year 2025, *3-year dormancy used only as an example.

Step 3: Decide what each item needs

Work down the decision tree below. The key idea: never delete old checks, and never void a check dated in a year you already filed. Voiding it there changes that year's expenses (and maybe a 1099 or payroll form). Instead, fix it with an entry dated in the current, open period.

Decision tree for old uncleared checks: wait, contact the payee, move to a liability or report to the state
Figure 2. Decision tree used for each old check (example rules).

Step 4: Contact the payee

Send a short letter: the check number, date and amount, a reply-by date (30 days is common), and a sentence that the amount may have to be reported to the state as unclaimed property if you do not hear back. Keep a copy and the mailing date; many states expect proof of this "due diligence" notice before you report. If the payee asks for a new check, reissue it (see Step 5 so the expense is not counted twice).

Step 5: Book the cleanup entry

First create one account: type Other Current Liability, name Uncashed Checks Payable. In QuickBooks Desktop use Lists > Chart of Accounts > Account > New; in QuickBooks Online use Chart of accounts > New. Then enter one journal entry dated on your cleanup date (Desktop: Company > Make General Journal Entries; Online: + New > Journal entry):

AccountDebitCreditMemo
Checking1,998.90Uncashed checks #1987, #1650, #2005
Uncashed Checks Payable1,998.90Owed to payees or the state

Table 2. EXAMPLE journal entry: $640.00 + $1,200.00 + $158.90 = $1,998.90.

When you later reissue a check or pay the state, code that payment to Uncashed Checks Payable, not to the original expense.

Step 6: Reconcile both sides together

In your next reconciliation (Desktop: Banking > Reconcile; Online: Settings > Reconcile), tick each old check and the journal entry line. They offset to zero, so the cleared balance still equals the bank statement, and the old items finally drop off the uncleared list. In QuickBooks Online, do not try to match the journal entry in the bank feed; it will never appear there.

Before and after table showing three old checks and one journal entry offsetting to zero in a bank reconciliation
Figure 3. Before and after: the old checks and the entry offset to $0 (example).

Step 7: Report to the state when required

Find your state's unclaimed property program through unclaimed.org (the National Association of Unclaimed Property Administrators). Note the dormancy period for vendor and payroll checks, the due-diligence letter rules, and the annual report date. Generally the payee's last known address decides which state gets the report. File on time and pay from the liability account.

Common mistakes

FAQ

Can I just void a check from two years ago?

Only if that year is still open and nothing was filed from it. Otherwise use a current-period journal entry so filed reports stay the same.

Is a check that is more than six months old invalid?

Not exactly. The bank does not have to pay it, but it may. More importantly, the debt to the payee does not disappear.

Do I owe the state money for every stale check?

Only once it passes your state's dormancy period with no contact and you have followed any notice rules. Check your state's holder guide.

What about an old deposit that never cleared?

Look for it on the bank statement first. If it was recorded twice, void the duplicate in an open year, or credit the bank with a current-period entry in a closed year.

Checklist

You can download the ready-made Stale Check & Uncleared Item Cleanup Kit for free in the Free kit download box below (Excel + PDF guide, no sign-up).

This article is educational information, not tax, legal or accounting advice. Unclaimed property rules vary by state; confirm with your CPA or attorney. All example numbers are made up. QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.

Sources

Free kit download

Tools to follow this article step by step. No sign-up needed.

Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records. QuickBooks is a trademark of Intuit Inc.; BIZLEX is not affiliated with Intuit.

← All articles Privacy