Why are some historical transactions missing from my QuickBooks Online reports after importing data?

Common QuickBooks Online Import Issues & How to Fix Them

1. Wrong Dates During Import (Most Common Cause)

Sometimes import files use different date formats:

  • U.S. format (MM/DD/YYYY)
  • International format (DD/MM/YYYY)

QBO may read them incorrectly, causing transactions to appear in the wrong period.

Fix:

  1. Reopen your CSV file and verify the date format.
  2. Reimport or manually correct affected dates.

2. Transactions Imported as Journal Entries Instead of Real Transactions

Some migration tools convert:

  • Invoices → Journal entries
  • Bills → Journal entries
  • Payments → Journal entries

Result: Sales, A/R, Vendor Expenses, and Cash Flow reports won’t show them.

Fix: Reimport using correct transaction type mapping.

3. Transactions Imported Without a Category or Account

If a CSV line lacks an account, QBO may:

  • Reject the line
  • Import it with missing details
  • Place the amount in Uncategorized accounts

Fix:

  1. Run Reports → Transaction Detail by Account
  2. Check for:
    • Uncategorized Expense
    • Uncategorized Income
    • Ask My Accountant
  3. Reclassify to correct accounts

4. Mapping Errors During Import

Common mistakes include:

  • Amount column mapped incorrectly
  • Vendor name in Description column
  • Wrong account selected

Fix: Reimport or use Tools → Batch Reclassify (if using QBO Accountant).

5. Transactions Imported into a Closed Books Period

QBO may block the import or restrict edits if a closing date is set.

Fix: Go to Settings → Advanced → Accounting → Remove or adjust Close Date.

6. Currency Issues (Multi-Currency Turned On)

If transactions use unsupported currencies or wrong exchange rates:

  • Amounts may appear as zero
  • Amounts may appear in the wrong account

Fix: Enable the correct currencies or reimport with proper currency mapping.

7. Imported Transactions Didn’t Hit Both Sides (Unbalanced Entries)

Some tools import only one side of a transaction, missing the offset account.

Fix: Check the Import Error Log or Skipped Transactions under Settings → Import Data.

8. Transactions Imported but Not Added to Books

If imported via Bank Feed, they must be categorized, matched, or added. Otherwise, they remain in “For Review.”

Fix: Go to Banking → For Review and add or match them.

9. Filters in Reports Hide Transactions

Report filters may hide historical data:

  • Date filter
  • Cash vs Accrual basis
  • Filter by Vendor/Customer/Class
  • Excluded accounts

Fix: Always click Report → Reset before reviewing.

💡 Special Note: QuickBooks Desktop → Online Imports

Common problems include:

  • Inventory doesn’t convert properly
  • Memorized transactions lost
  • Opening balances overwritten
  • Some payroll data missing

Recovery may require special steps to re-import or adjust the data.

Submit Your Details for Expert Support

    Contact Form Demo