An unreconciled transaction is an entry in your QuickBooks bank register that has not been matched to a line on a bank statement. A few from the last week are normal. Anything older than the last statement date is one of three things: a duplicate, a real payment the bank never saw, or a reconciliation someone forced with an adjusting entry. Each one means the QuickBooks cash balance is wrong by that amount. You can list unreconciled transactions in QuickBooks Online in two minutes from the register or the Transaction Detail by Account report, and the count and age say more about your bookkeeper than any interview.
Three words that get confused
Reconciled, marked R in the register, means the transaction was matched to a line on a bank or card statement during a reconciliation, and the statement's ending balance agreed with QuickBooks on that date. It is the only status that means the bank confirms the entry.
Cleared, marked C, means the transaction was matched to a line in the bank feed but has not yet been through a reconciliation. The feed is a download, not a statement. It can bring the same transaction twice, miss one, or be matched to the wrong entry by whoever was clearing the feed on a Friday afternoon.
Uncleared, a blank in the column, means neither has happened. The entry exists in QuickBooks and nothing from the bank has been attached to it.
Owners hear "the bank feed is up to date" and assume the books are reconciled. They are different things. A file can have every feed transaction accepted and not have been reconciled since October, and the cash balance can be off by five figures.
Why it matters to an owner
The cash number in QuickBooks is only as good as the last reconciliation. One check shows the problem: $12,400 to a subcontractor, dated 11 February, still uncleared in June. It is one of three things. If the sub cashed it and the bookkeeper also entered the bank feed's version of the same payment, the check is a duplicate, expenses are overstated by $12,400 and February's profit is understated by the same. If the sub never cashed it, the money is still in your account but QuickBooks says it is gone, and any cash decision made from QuickBooks was $12,400 too cautious. If the bookkeeper reconciled February by posting an adjustment to make the difference disappear, the check and the adjustment cancel in the balance but neither is real, and the P&L has an expense line nobody can explain.
Multiply that by the count. A file with 23 uncleared items older than the last statement, totaling $41,730, has a cash balance that is wrong by some combination of those amounts, in a direction nobody knows. The five-minute check of your bookkeeper's file starts here for that reason.
Ledge's 2025 survey of 100 finance teams found 94% still use Excel in the close, 27% take more than seven business days to close a month, and cash reconciliation eats 20 to 50 hours a month. Those are companies with finance teams. A 30-person company with an outside bookkeeper has less time than that, which is why old items pile up.
How to find unreconciled transactions in QuickBooks Online
The register is the fastest route. Open the bank account's register, click the cleared column header to sort by status, and every uncleared item rises to the top. Read the dates. Anything before the last statement's ending date is what you are looking for.
The Transaction Detail by Account report does the same across accounts. Set the date range to all, filter to the bank or card account, set the Cleared filter to Uncleared, and sort by date. Export it, and you have a list to hand to the bookkeeper with the oldest item at the top.
The reconciliation history page, under the reconcile tool, shows the last statement date reconciled for every account. This is the one to read first. An account whose last reconciliation is three months old has three months of items that cannot yet be called anything.
The Reconciliation Discrepancy report exists for the case where a reconciliation used to tie and now does not. Intuit's help article on beginning balance problems describes it as showing what changed, when, and who changed it. The same article lists the four reasons a beginning balance stops matching: the opening balance was entered wrong, a reconciled transaction was edited, deleted or unreconciled, a bank feed match was undone, or a manual reconciliation was backdated. Three of the four are somebody touching a transaction that was already confirmed by the bank.
The Audit Log is where deleted and voided transactions go. If the discrepancy report shows a reconciled item that no longer exists, the log says who removed it and when. Sorting it by user tells you whether that person was your bookkeeper, your office manager, or you.
What normal looks like
Normal for a checking account is nothing uncleared older than the current statement period, with the last reconciliation dated within the past six weeks. Credit cards should look the same. Payment processors like Stripe or Square should be reconciled to their own statements, because the bank only sees the net deposits.
Loan accounts are the exception owners rarely check. They are often never reconciled to the lender's statement, which means the principal balance on your balance sheet is whatever the bookkeeper's split of each payment produced, and the interest on your P&L is a guess. The fix is a reconciliation of each loan to the lender's annual statement, once a year at least, and it belongs on the list of questions to ask your bookkeeper every month.
The red flag in any account is an entry called reconciliation adjustment, reconciliation discrepancy, or something similar, posted to an expense account. It is a plug. Someone could not make the statement tie and forced it. One adjustment of $3.17 from four years ago is not a concern. A $2,840 adjustment last quarter means the reconciliation was declared done when it was not, and the items behind it are still wrong.
A QuickBooks Community thread from August 2022 describes an owner whose transactions from 2017 to 2019 still showed as unreconciled while the reconciliation reports for those years said everything tied. The moderator's answer was to go through each register by hand. There is no button for it, and that is the honest limit of the method: the reports tell you what is unreconciled and the register tells you when it was entered, but only the bank statement can tell you which of the three things each item is.
Several companies, one vendor
The multi-entity version has its own pattern. A vendor gets paid from the wrong company's account. The company that paid has an uncleared bill or a bank feed transaction with nowhere to post it. The company that owed the bill still shows it open, then pays it again, or the bookkeeper enters a payment that never happened so the bill goes away, and that payment sits uncleared forever. Intercompany transfers do the same on a larger scale: the sending company records the transfer and the receiving company's bookkeeper, working a different file, never does, so one side clears and the other never can. If you have three files, run the uncleared list in all three the same morning and look for amounts that appear in two of them.
Intuit's ERP blog, citing a 2025 QuickBooks survey, reports that 84% of owners worry about the accuracy of their numbers and 87% say manual processes hurt timeliness. Reconciliation is where both worries meet. Navigator reads the reconciliation status of every bank, card and loan account in each connected QuickBooks Online file and reports it in the morning brief, so an account that has not been reconciled since March shows up before the bank statement does; the free accounting health check runs the same test on every file you connect, on the base plan.
What to ask your bookkeeper
Which accounts did you reconcile last month, and through what statement date. How many uncleared items are older than that date, and what is each one. Are there any reconciliation adjustments in the last twelve months, and what were they for. When were the loan accounts last reconciled to the lender's statement. What do you need from me to clear the old ones.
The common advice for a file full of old uncleared items is to delete them and move on, and we disagree, because deleting a transaction in a closed month changes that month's P&L, and if the year has been filed, the tax return and the books no longer agree, which is a worse problem than the one you started with. Duplicates go once the real copy is identified. Payments the bank never saw are voided in the current period. Forced reconciliations are undone and redone.
If the oldest item is more than a year old, or the count runs past a few dozen per account, the job has stopped being a monthly task and become a project. What a QuickBooks cleanup costs and what it fixes covers that, and NerdWallet's March 2026 pricing survey puts the prior-period add-on at bookkeeping services at $1,000 and up, which is the price of the months nobody reconciled.
Questions owners ask
What does unreconciled mean in QuickBooks Online?
It means the transaction is in your QuickBooks register but has not been matched to a line on a bank or card statement during a reconciliation. The register shows a blank in the cleared column instead of an R. A recent one is normal. One older than the last statement date means the QuickBooks balance and the bank disagree by that amount, and someone needs to find out why.
How do I see all uncleared transactions in QuickBooks Online?
Run the Transaction Detail by Account report, set the date range to all, filter to the bank or card account, and set the Cleared filter to Uncleared. Sort by date. The same view is available in the register by sorting on the cleared column. Do this for every bank, card and loan account, in every company file you own, and note the oldest date in each.
Why doesn't my beginning balance match in QuickBooks?
Intuit's help article on beginning balance problems lists four causes: the opening balance was entered wrong, a reconciled transaction was edited, deleted or unreconciled, a bank feed match was undone, or a manual reconciliation was backdated. The Reconciliation Discrepancy report shows what changed, when and by whom. The Audit Log shows anything that was deleted or voided.
Should I delete old unreconciled transactions?
Not until you know what each one is. A duplicate can be deleted, but the correct copy has to be identified first. A real payment the bank never saw should be voided in the current period, not deleted from the old one, because deleting changes a closed month's P&L and a filed tax return no longer ties to the books. A forced reconciliation needs to be reversed and redone.
How often should bank accounts be reconciled?
Every account, every month, within a week or two of the statement arriving. Checking, savings, credit cards, loans and any payment processor with a statement. If your bookkeeper reconciles quarterly, or only the main checking account, the QuickBooks cash balance is a guess for eleven weeks out of thirteen, and the P&L carries whatever the unreconciled items are hiding.
Related
The reconciliation date is one of the tests in the five-minute check of your bookkeeper's QuickBooks file, and the reason the check exists. If the close is the thing that keeps slipping, how long month-end close should take sets a reasonable expectation. And if the QuickBooks cash number and the bank have parted ways for reasons beyond reconciliation, why net income doesn't match your bank balance covers the rest.
To see the last reconciliation date on every account in every file you own, without opening any of them, the free accounting health check takes a few minutes: navigatorhq.ai/health-check.
You're on the list.
The next post goes to . While you wait, the free Accounting Health Check scores your own books.
Published . Last updated . Reviewed by a CFO on the Navigator team.