Best Suited for:
- Back Office administrators
- Users reviewing duplicate invoice records
Important Information:
- A duplicate scan must be completed before duplicates can be removed
- Only duplicate QuickBooks Online invoices are deleted
- The original synchronized invoice is always preserved
- Duplicate deletions cannot be undone
- Scan and deletion tasks cannot run simultaneously
Warning
If payments were manually applied to duplicate invoice records directly in QuickBooks Online, those payments may need to be reviewed after duplicate removal.
Process Description:
- Preview invoices
- Scan for duplicates
- Review duplicate results
- Remove duplicate records
- Verify synchronization
Previewing Invoices:
- Navigate to My Office > QuickBooks Online
- Select QBO Tools
- Select a filter type:
- Created At
- Invoice Date
- Select a From date
- Select a To date
Date ranges are limited to 30 days
- Select Preview
The preview displays invoices within the selected date range but does not initiate a scan.
Scanning for Duplicate Invoices:
- Review the preview results
- Select Scan QBO for Duplicates
- The scan runs in the background. During the scan, the system displays:
- Progress bar
- Total invoices
- Completed invoices
- Failed invoices
- Cancelled invoices
The Duplicates and Scan History tabs refresh automatically when the scan completes.
Reviewing Duplicate Invoices:
- Open the Duplicates tab
- Review the duplicate invoice list
- Available information includes:
- Invoice Number
- Invoice Date
- Customer
- Total
- Payment Status
- Duplicate Count
Deleting a Single Invoice's Duplicates:
- Locate the invoice
- Select Delete Duplicates
- Review the confirmation message
- Select Continue
- Confirm the deletion
Deleting Multiple Invoice Duplicates:
- Select one or more invoices
- Select Delete Selected
- Review the confirmation message
- Select Continue
- Confirm the deletion
Deleting All Duplicate Invoices:
- Select Delete All Duplicates
- Review the confirmation message
- Select Continue
- Confirm the deletion
Monitoring Deletion Progress:
While deletion is running, monitor:
- Progress bar
- Total invoices
- Completed invoices
- Failed invoices
- Cancelled invoices
The Duplicates tab refreshes automatically when processing completes. Successfully cleaned invoices are removed from the duplicate list.
Reviewing Removal History:
- Open the Removal History tab
- Review previous deletion activities
- Available information includes:
- Start Date
- Started By
- Completion Date
- Status
- Invoices Processed
- Duplicate Records Removed
- Jobs Total
- Done
- Failed
- Canceled
Select a history entry to review the invoices included in that cleanup operation.
Running a QuickBooks Resync:
After duplicate cleanup:
- Select QuickBooks Resync
- Allow synchronization to complete
This helps ensure QuickBooks Online is synchronized after duplicate records have been removed.