Quick answer

Most QuickBooks report problems come from the report's own settings, not lost data. A blank report is usually a date range or filter issue; a total that disagrees with another report is usually a cash versus accrual difference or a mismatched period. Check dates, basis, and filters before you repair anything.

What QuickBooks report problems usually mean

QuickBooks reports read live from the company file, so a report that is blank, wrong, or missing transactions is almost always showing you a setting: the wrong period, a filter, a hidden row, or a different accounting basis. A QuickBooks Online report and a QuickBooks Desktop report can also legitimately disagree because they count different transactions.

Genuine data damage is the exception. When names, items, or accounts are missing from many reports, transactions, and centers at once, the file needs repair. The diagnostic table below separates setting problems from file problems so you do not rebuild data over a date-range mistake.

Diagnostic table: match the symptom to the cause

What you seeMost likely causeFirst check
Report is blank or shows empty rowsDate range excludes activity, or zero and empty rows are hiddenWiden the report period, clear filters, and check the display options for active rows
Report total disagrees with another reportDifferent date ranges, different basis, items mapped to wrong accounts, or transactions without itemsSet both reports to the same dates and basis, then check item accounts
Report disagrees with the account registerUnreconciled or edited transactions, filters, or a restricted closing dateCompare the transaction detail to the register and review reconciliation
Transactions are missing from a reportFilters, inactive accounts, a closing-date restriction, or damaged listsRun a Transaction Detail by Account for the same period
Totals change every time you run the reportNew or edited transactions, or filters saved on a memorized reportCompare report timestamps and run the built-in version of the report
Cash report and accrual report do not agreeSummary report basis preference, or a detail report that defaults to accrualCheck the basis on both reports and in company preferences
Rows or columns are missing from the reportCustomization, collapsed rows, or a memorized layoutOpen Customize Report and reset rows and columns
Export to Excel is incompleteGrouped reports export flat, list reports have no totals, or the report is too large to displayExport a smaller date range or a detail version, then combine
Print or PDF comes out blankPDF or print driver problem, or browser print settingsUse print preview, then run the PDF and Print Repair tool
Names, items, or accounts are missing everywherePossible company-file damageRun Verify and Rebuild, then File Doctor if needed

Common causes, ranked by how often they appear

  1. Date and filter mistakes. The period is off, a memorized report carries old filters, or a customized report was never reset. This explains most blank and wrong reports.
  2. Cash versus accrual basis. Summary reports can run on either basis; detail reports from the Reports menu default to accrual, so comparing one of each guarantees a mismatch.
  3. Comparing reports that count different transactions. A Profit & Loss includes expense-tab bill lines and journal entries; a sales report usually includes only item transactions.
  4. Items point to the wrong income or expense accounts. The item list drives which account a sale posts to, so wrong mapping produces wrong totals.
  5. A closing date or restricted period. Transactions outside the allowed period stay in the register but vanish from dated reports.
  6. List or transaction damage in the company file. Missing names, items, or accounts across several reports point to damaged data.
  7. Export and print environment problems. Excel is not installed locally, the Office version is unsupported, or the output exceeds a tool limit.

Before you begin

  • Note the report name, exact date range, and the basis shown in the header. Making the two reports match those three fields solves half of all report comparisons.
  • In QuickBooks Desktop, sign in as the admin in single-user mode and close all windows before running repairs.
  • In QuickBooks Online, confirm your user role can view and customize reports.
  • Allow 10–20 minutes for filter and basis problems. Data repairs and rebuilds can take much longer on a large file.

Back up before any repair. Verify and Rebuild, File Doctor, and restore all touch the company file. Copy the entire company-file folder — not just the .QBW — to another drive first. If a report problem is only a filter or basis setting, do not repair the file at all.

How to fix QuickBooks report problems

1

Reset the report period and run the built-in version

In QuickBooks Online, open the report, select the Report period dropdown, and choose a range wide enough to include the transactions you expect. In QuickBooks Desktop, open the report, select Customize Report, set Dates to All, and select OK. Then compare it with the same report opened fresh from the Reports menu rather than a memorized copy with saved filters.

2

Confirm the accounting basis on both reports

Cash and accrual basis each show different income and expenses, so set both reports to the same basis before comparing them. In QuickBooks Desktop, open Edit → Preferences → Reports & Graphs → Company Preferences and check the Summary Report Basis setting; summary reports follow it, while detail reports created from the Reports menu default to accrual. In QuickBooks Online, check Settings → Account and settings → Advanced → Accounting and the accounting method dropdown. In recent Desktop versions you can also toggle basis on the report itself, but the report reverts to the preference default when you close it.

3

Clear filters, customization, and hidden rows

Open Customize Report and review every filter, especially account, class, customer, and item filters saved on a memorized report. In QuickBooks Online, use Customize and check the rows and columns settings, including options that hide empty rows or zero totals — a row can be missing because the report was told to hide it. Reset the layout to the default if you are unsure what changed.

4

Reconcile two reports that disagree

Set both reports to the same dates and basis, then compare detail rather than summary. In QuickBooks Desktop, quick zoom the amount in question, set Total By to Item, and scroll to the bottom for transactions grouped under No Item — those are journal entries and expense-tab lines that appear on the Profit & Loss but not on a sales report. Then check that sales items point to the correct income account, and tile the two detail reports with Window → Tile Vertically to compare line by line.

5

Hunt missing transactions in the register and closing date

Run a Transaction Detail by Account report for the same period and compare it with the account register. Look for excluded accounts, inactive items, or a closing date that blocks older transactions from reports. If a reconciled transaction was edited or deleted, the register and the balance sheet can legitimately disagree until you re-reconcile; the reconciliation troubleshooting guide covers that case in detail.

6

Repair data damage only when list data is missing

When names, items, or accounts are missing from reports, transactions, and centers at once, treat it as data damage. Run File → Utilities → Verify Data, then Rebuild Data with a backup first. Press F2 and check the Versions Used on File section for RB before running File Doctor — Intuit warns against File Doctor on a file that was recently rebuilt, and in that case the correct move is to restore the backup made before the rebuild. The data damage recovery order walks through the full sequence.

7

Fix export and print failures

In QuickBooks Online, use the Export/Print dropdown to export to Excel or CSV. If a report will not display because of its size, export it or run smaller date ranges and combine the files. In QuickBooks Desktop, open the report from the Reports Center and use the Excel dropdown to create a new worksheet. If QuickBooks reports too many columns, clear the space-between-columns option under Advanced. Desktop exports cap at 65,536 detail lines, so split large reports. When nothing exports, work through the export to Excel failures guide; for blank printouts, use the PDF and Print Repair tool as described in print not working.

Verify the fix

  1. Run both reports again with the widest date range and the same basis, and confirm the totals agree.
  2. Quick zoom the total to the detail report and confirm the individual transactions exist in the register.
  3. Export a short date range to Excel and confirm the row and column totals match the on-screen report.
  4. Print or save one page as PDF and confirm the content appears.
  5. If you repaired the file, run Verify Data once more and confirm it reports no problems.

If report problems persist

If totals still disagree after the reports match on dates, basis, filters, and item accounts, the remaining causes are damaged transactions or damaged lists. Keep the original file untouched, restore the pre-repair backup if a rebuild made things worse, and escalate. For Desktop, Intuit Data Services can attempt recovery; the company file repair overview explains what each tool can and cannot fix. Decisions about which account an item should point to are accounting work for your bookkeeper or accountant, not a software fix.

Prevention

  • Reconcile bank and credit card accounts monthly so register and report differences get caught early.
  • Name memorized reports with their period and basis so nobody compares unlike reports.
  • Keep the item list clean; every item should point to the correct income and expense accounts.
  • Run Verify and Rebuild twice a year, and always before a QuickBooks Desktop upgrade.
  • Install Microsoft Office before QuickBooks Desktop so the Excel integration registers correctly.
  • Keep QuickBooks updated, and test your key reports after each update.

Frequently asked questions

Why is my report blank when I know there are transactions?

The date range almost always excludes them, or the report is hiding empty and zero rows. Set the period to a wider range, clear custom filters, and check the display options before assuming data is missing. Running the same report from the standard Reports menu instead of a memorized copy is the fastest test.

Why does my Profit & Loss not match my sales report?

Common causes are different date ranges, different accounting bases, sales items pointing to the wrong accounts, and transactions that appear on the Profit & Loss without items, such as journal entries and expense-tab bill lines. Fix those first, then check for data damage if the gap remains.

Why does my report differ from my register?

Registers include unreconciled and future-dated transactions that dated reports may exclude, and editing or deleting a reconciled transaction changes the account balance until you re-reconcile. Check the report period, filters, and closing date, then review the reconciliation for changed transactions.

Can I fix report problems by rebuilding data?

Only when names, items, or accounts are missing from several reports, transactions, and centers. Rebuild is data-affecting, so back up first and run Verify afterward. Filter, date, and basis problems are fixed in the report settings and never need a rebuild.

Why is data missing when I export a report to Excel?

Grouped reports export as flat rows, list reports do not include totals, and very large reports can be trimmed or fail to display. Export a detail version, use a narrower date range, and combine the files in Excel. Also confirm desktop Microsoft Excel is installed locally and is a supported version.

Sources & further reading