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.
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 › FilterA 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 › FiltersAs 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
Open the right bank account
All apps › Accounting › Chart of accountsFind 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
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
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
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
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
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.
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
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.