What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Find Uncleared Checks in QuickBooks
QuickBooks Online

Uncleared Checks in QuickBooks: How to Find Them in the Register or Your Last Reconciliation

A vendor says the check never came, or the reconciliation screen shows checks from last spring that nobody remembers. What you want is every check QuickBooks says you wrote that the bank hasn't paid. The bank account's register shows each transaction's status: blank for uncleared, C for cleared, R for reconciled. Filter for the blanks and you have the list.

Where the list lives

Register: open the bank account's register, choose Filter, and set Reconcile status to the uncleared option. Some screens call it No status.

All apps Accounting Chart of accounts View register Filter

A printable report: from the arrow beside View register, choose Run report, set the period to All Dates, then Customize and filter Cleared to Uncleared.

Chart of accounts Run report Customize Filters

As of your last statement: open the reconciliation report for that month. It lists what was still uncleared when you reconciled. Printing reconciliation reports has the clicks.

Narrowing the register to unpaid checks

  1. 1

    Open the right bank account

    All apps Accounting Chart of accounts

    Find the checking account and choose View register in the Action column. In older layouts the chart of accounts sits under Bookkeeping or the gear icon.

  2. 2

    Filter on reconcile status

    Choose the filter icon above the list. Under Reconcile status, pick the option for transactions with no status, then apply it.

    Watch for: the Not reconciled choice where it's offered. It also keeps the C items, which the bank has already paid but you haven't reconciled yet.

  3. 3

    Widen the dates

    The register opens on a recent range. Set the date filter to all dates, or the stale checks you're after stay hidden.

  4. 4

    Leave out deposits if they clutter it

    Filter the transaction type to checks and bill payment checks. Card payments and transfers that haven't cleared will drop out of view.

  5. 5

    Read it oldest first

    Sort by date. Recent checks are usually just in the mail. The ones several weeks old or more are where to look closely, with the bank statement open next to you.

    Watch for: a check that shows uncleared here but the bank says it paid. That usually means the bank feed added the payment as a new expense instead of matching it to the check.

A live register view against a frozen reconciliation list

Register filter

What is uncleared right now

  • Changes the moment a check is matched, edited or voided.
  • Includes checks written since your last reconciliation.
  • Run as a report, it can be saved, printed or exported for a vendor or your accountant.
  • Intuit puts the Cleared filter on Essentials, Plus and Advanced. On Simple Start, sort the report by the cleared column instead.
Reconciliation report

What was uncleared on statement day

  • A snapshot: Intuit says later changes to the books don't alter it.
  • This is the list your accountant or a lender reads when they review the month.
  • Intuit says it can't go straight to Excel, so copying is manual.
  • If it and the register disagree about a check from before that date, something reconciled was changed. Fixing reconciliation discrepancies shows how to trace it.

Working the list down? Use the register. Answering for a closed month? Use that month's reconciliation report.

What each check on the list is telling you

The check What probably happened Next move
Written in the last week or two It's in the mail or sitting on the payee's desk Leave it. It should clear on its own.
Uncleared in QuickBooks, but the bank shows it paid The bank feed added it as a fresh expense Undo that line in Banking, then match it to the check. Otherwise the cost is counted twice.
Six weeks to a few months old Lost, or never deposited Ask the payee before you reissue. If you send a new one, stop payment on the old check at the bank first.
Months old, and the payee has gone quiet Stale Generally reverse it in the current period rather than voiding it in a month already closed. Voiding checks covers the choice.
Never left the office A duplicate, or a check entered but never printed Delete it only if nobody outside could have seen it. Otherwise void it so the number stays on record.

Questions people ask

What are uncleared transactions in QuickBooks, exactly?

They're anything recorded against a bank or card account that hasn't yet appeared on a statement: checks, deposits, transfers. In the register they have no status mark. A check written yesterday and one written in March both count, so the date matters as much as the status.

How do I clear uncleared transactions in QuickBooks once I confirm they went through?

Usually by ticking them off in your next reconciliation, against the statement line that shows them. Outside a reconciliation you can click the status box in the register to mark a transaction cleared, but only do that when a statement shows it. Marking checks cleared to shorten the list just moves the problem to next month.

What do I do with an old uncleared check that will never cash?

Try the payee first. If it really won't be cashed, the usual approach is to reverse it in the current period so a closed month isn't rewritten. Many states treat an uncashed check as unclaimed property after a set time, so the money may not simply come back to you. Rules differ by state, so check yours with your accountant.

How do I view uncleared transactions in QuickBooks Desktop?

Open the register from Banking > Use Register and look at the cleared column. For the list as it stood on a statement date, run Reports > Banking > Previous Reconciliation for that account and month. Desktop's Missing Checks report is a different tool: it looks for gaps in check numbers, not checks still waiting at the bank.

Who can help when the uncleared list runs to dozens of old checks?

For businesses with years of uncashed vendor, refund or payroll checks, n-frames builds the yearly pull from QuickBooks that groups each check by age and state, adds the payee's address from their record, and drafts the letter you'd send before reporting it. Your accountant still decides what gets reported.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.