TechBrot is an independent firm, not Intuit. We never ask for your Intuit login, remote control of your computer, or payment by gift card or link.
ERROR · REPORTSQuickBooks help
QuickBooks reports show wrong numbers: causes & fixes.
“The numbers are wrong” usually means a report — the Profit & Loss, the balance sheet, or another statement — doesn’t match reality or doesn’t tie out. Most cases trace to a handful of causes: the wrong report basis, a date range or filter that excludes or includes the wrong data, transactions sitting uncategorized, duplicates, an off reconciliation, or a chart of accounts that mixes things up. The self-fix steps below work in order of likelihood. Below that: when miscategorization spanning months means it’s a ProAdvisor call.
§ TL;DR
“QuickBooks reports show wrong numbers” means a report — most often the Profit & Loss or the balance sheet — doesn’t match what you know to be true, or doesn’t tie out against your bank statements and source documents.
The most common single cause is a report set to the wrong basis (cash vs accrual) or to a date range or filter that quietly excludes or includes the wrong data — and many cases clear once the basis, dates, and filters are set correctly and uncategorized transactions are cleaned up. The same causes apply in both QuickBooks Online and QuickBooks Desktop; report accuracy is a bookkeeping problem, not a software bug.
§ 01 · What throws the numbers off
Common causes, in order of likelihood.
The self-fix steps address these in the same order — so working through them in sequence resolves most wrong-number reports efficiently.
Cause 01 · The report basis is wrong (cash vs accrual)
The single most common cause. A report set to cash when you expected accrual — or vice versa — shows very different income and expense totals, because the two bases recognize money at different points. If a P&L looks far off, the basis toggle is the first thing to check.
Cause 02 · The date range or a filter is wrong
A report scoped to the wrong period, or carrying a filter that excludes or includes the wrong customers, accounts, classes, or transaction types, will quietly leave data out or pull extra in. The numbers look wrong simply because the report isn’t showing what you think it’s showing.
Cause 03 · Uncategorized or misclassified transactions
Transactions sitting in Uncategorized Income, Uncategorized Expense, or Ask My Accountant — or posted to the wrong account — throw off every total they touch. Income lands in the wrong line, expenses disappear into a catch-all, and the report no longer reflects how the business actually performed.
Cause 04 · Duplicate transactions inflating totals
The same transaction entered twice — manually keyed and then imported, or downloaded twice after a reconnect — inflates income, expenses, or both. Duplicates are a frequent reason a P&L or sales report reads higher than reality.
Cause 05 · Reconciliation is off, so balances are wrong
If bank and credit-card accounts aren’t reconciled — or were force-reconciled with an adjustment — the balance sheet won’t tie to the actual bank balance, and account balances feeding other reports are wrong. Unreconciled or mis-reconciled accounts are a leading source of numbers that won’t tie out.
Less common · Less common: wrong account or class structure
A chart of accounts or class structure that mixes things up — personal and business spending in one account, the wrong account types, or classes applied inconsistently — produces reports that are technically “correct” but meaningless. This is where surface fixes stop working and a file review is warranted.
§ 02 · The self-fix
How to fix wrong report numbers yourself.
Six steps, in order. Most reports come back into line within the first two or three — if all six don’t resolve it, or the books are already behind, stop and get the file reviewed.
- 1
Set the correct basis, date range, and filters
Open the report and check the basis toggle (cash vs accrual) against what you’re trying to see, set the date range to the right period, and clear any filters you didn’t intend — customer, account, class, or transaction-type filters that quietly exclude or include data. This alone explains a large share of wrong-looking reports.
- 2
Review and reclassify uncategorized transactions
Find transactions sitting in Uncategorized Income, Uncategorized Expense, or Ask My Accountant and move them to the correct accounts. Reclassifying these so income and expenses land where they belong is usually the single biggest improvement to a report that doesn’t reflect reality.
- 3
Find and remove duplicates
Look for the same transaction entered twice — keyed manually and then imported, or downloaded twice — and remove genuine duplicates carefully, so you don’t delete real transactions. Duplicates inflate totals, so clearing them often pulls an over-stated P&L or sales report back to reality.
- 4
Confirm accounts are reconciled
Check that your bank and credit-card accounts are reconciled and that each month ties to the statement. An unreconciled or force-reconciled account leaves the balance sheet out of sync with the real bank balance — reconcile, and the balances feeding your reports come back into line.
- 5
Check the chart of accounts and class mapping
Review the chart of accounts and any class or location structure for miscategorizations — personal and business mixed together, the wrong account types, or classes applied inconsistently. Correcting the structure makes the reports meaningful, not just balanced.
- 6
Re-run the report and compare to source documents
After the steps above, re-run the report and compare it against your bank statements and source documents to confirm it ties out. If it still won’t tie — or the miscategorization spans months — stop and get the file reviewed before tax or a lender depends on the numbers.
§ 03 · When to call
Three signals it’s a ProAdvisor call.
The numbers still won’t tie
You’ve set the right basis, dates, and filters and cleaned up the obvious items, and the financials still don’t tie out to the bank statements or each other. That points to deeper categorization or reconciliation problems a report setting can’t fix.The books need to be CPA-ready
Taxes, a loan application, a sale, or an investor needs financials that are clean and defensible. Getting a file from “roughly right” to CPA-ready — tied out, properly categorized, and reconciled — is bookkeeping work, not a report tweak.The miscategorization spans months
The numbers have been off for a while and now you’re looking at months of misclassified, uncategorized, or duplicated transactions across the file. That’s a cleanup — the moment to have the file assessed before the discrepancy compounds into tax season.§ 04 · Software, or the books?
When a wrong report is no longer a software problem.
If the report settings, dates and basis are right and the number is still wrong, the report is faithfully showing a ledger that is wrong.
- Profit changes depending on who ran the report and when.
- Balance sheet accounts carry balances nobody can explain.
- The miscategorization behind the report runs back several months.
Start with the free QuickBooks file review — a limited review that identifies likely issues and the information needed for a written scope, with the findings in plain English. If the findings show that the books themselves need work, that is QuickBooks cleanup, quoted as a fixed fee against a written scope before any work starts.
Numbers still won’t tie, or the books need to be CPA-ready?A QuickBooks ProAdvisor reviews the file free, then fixes the categorization and reconciliation behind the report — a focused diagnostic is a fixed-fee scope from $450; bookkeeping cleanup runs $1,200–$15,000+ if the books are behind.
Get the free file review
§ 05 · Who fixes it
A QuickBooks ProAdvisor makes the reports reflect reality.
Changing a report’s basis or date range is the easy part. The work that actually restores trust in the numbers is everything underneath: reclassifying transactions out of Uncategorized Income, Uncategorized Expense, and Ask My Accountant; finding and removing duplicates without deleting real entries; correcting a chart of accounts where personal and business were mixed; and re-running reconciliation until each month ties to the bank statement — so the P&L and balance sheet tie out and the file is CPA-ready. A QuickBooks ProAdvisor holding the Intuit QuickBooks Certification Level 2 does that against a written scope and verifies the reports tie before closing.
Freefile review first — we look before we scope
From $450fixed-fee diagnostic for a focused report + reconciliation fix
§ 08 · Questions
What people ask about wrong report numbers.
Why are my QuickBooks reports showing wrong numbers?
Most often the report is on the wrong basis (cash vs accrual) or a date range or filter is excluding or including the wrong data. Other common causes: transactions sitting in Uncategorized Income/Expense or Ask My Accountant; duplicate transactions inflating totals; a reconciliation that’s off so balances are wrong; or a chart of accounts that mixes personal and business together. Report accuracy reflects the data and settings in your file, so wrong numbers point to the books, not a software bug.
Why doesn’t my Profit & Loss match my bank balance?
It usually isn’t supposed to match exactly — a P&L shows income and expenses over a period, while the bank balance is a point-in-time figure on the balance sheet. But if the balance sheet’s bank balance doesn’t match the actual statement, the account likely isn’t reconciled, or duplicates and miscategorized transactions are throwing the numbers off. Reconcile the account and clean up categorization, then compare again.
What does cash vs accrual basis change on a report?
Cash basis recognizes income when money is received and expenses when they’re paid; accrual recognizes them when invoiced or billed, regardless of payment. The same file can show very different income and expense totals depending on which basis the report uses, so a P&L that looks “wrong” is often just set to the basis you didn’t expect. Check the basis toggle first.
Is a report showing wrong numbers a software bug or a bookkeeping problem?
Almost always a bookkeeping problem. A QuickBooks report simply totals the transactions in your file using the basis, dates, and filters you select — so wrong numbers mean the data or the report setup is off, which is the operational work TechBrot does inside your books. A genuine software bug, or an Intuit account or billing issue, is Intuit’s to resolve and isn’t something we can reach.
Does this affect QuickBooks Online and QuickBooks Desktop?
Both. The same causes apply in QuickBooks Online and QuickBooks Desktop — the wrong basis, a date range or filter, uncategorized transactions, duplicates, an off reconciliation, or a chart-of-accounts mix-up. The exact menus differ between the two, but the order of likelihood is the same: check basis, dates, and filters, then categorization, duplicates, and reconciliation.
When does reports that are wrong need a ProAdvisor?
When the financials still don’t tie after you’ve checked the basis, dates, and filters; when the books need to be CPA-ready for taxes, a loan, or a sale; or when the miscategorization spans months. That’s bookkeeping repair a report setting can’t fix. We start with a free file review, then a focused diagnostic is a fixed-fee scope from $450, or a cleanup ($1,200–$15,000+) if the books are behind.
Can you fix my Intuit account or a QuickBooks software bug?
No — an Intuit account, login, subscription, or billing matter, or a genuine software bug, is Intuit’s to resolve, and an independent firm can’t access your Intuit account. For those, contact Intuit directly. We work inside your own QuickBooks file: fixing the categorization, duplicates, and reconciliation so the reports reflect reality and tie out.
TechBrot is an independent firm, not Intuit. We never ask for your Intuit login, remote control of your computer, or payment by gift card or link.Call (877) 751-5575Book a discovery call
Numbers still won’t tie, or the books need to be CPA-ready?