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:
- Reopen your CSV file and verify the date format.
- 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:
- Run Reports → Transaction Detail by Account
- Check for:
- Uncategorized Expense
- Uncategorized Income
- Ask My Accountant
- 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.