1. Imported Records Already Exist

• If invoices or sales were already entered manually or via another integration, importing the same records again will create duplicates.
• Example: You recorded January invoices manually, then import a CSV for January → QBO sees them as new transactions.

2. Incorrect or Missing Unique Identifiers

• QBO relies on Invoice Numbers or Transaction IDs to identify duplicates.
• If the import file:
  • Does not include invoice numbers, or
  • Uses numbers that conflict with existing invoices,

  QBO treats every row as a new invoice.

3. Multiple Imports of the Same File

Sometimes the same CSV/Excel file is imported twice, accidentally or during testing. QBO does not automatically detect duplicates for imports.

4. Overlapping Integrations

If you use a third-party app such as Shopify, PayPal, Stripe, or A2X and also import CSVs manually, the same transactions may be imported by both methods.

5. Partial or Failed Imports

An import that fails partway and is retried may duplicate the records that succeeded in the first attempt.

Step 1: Identify the Duplicates

• Go to Sales > All Sales.
• Sort by Invoice Number or Customer.
• Look for invoices with:
  • Same number, date, and amount
  • Same customer name

Step 2: Decide Which to Keep

• Usually, keep the original entry or the version with full details.
• Delete duplicates:
  1. Open the invoice > More > Delete.
  2. Confirm deletion.
• Do not edit numbers to merge; deletion avoids conflicts in reports.

Step 3: Prevent Future Duplicates

1. Always include Invoice Numbers in your import file, QBO uses these to track transactions.
2. Check for existing records before importing.
3. Use one integration per sales channel to avoid overlaps.
4. Enable “Custom Transaction Numbers” (Settings > Sales > Sales form content) to control numbering and avoid conflicts.

Optional: Merge or Remove in Bulk

• If there are many duplicates, you can:
  • Export All Sales to Excel
  • Filter duplicates by invoice number
  • Delete them in bulk using Batch actions in QBO (Sales > All Sales > checkboxes > Batch Delete)
• Batch delete is permanent, always back up or export first.

Summary