Remove duplicate bank transactions in QuickBooks Online

Keep your books accurate by removing duplicate bank transactions. If you spot the same transaction twice in your bank feed, you can exclude it from review or delete it if it’s already been categorised.

Exclude duplicate transactions from the Pending tab

If your duplicate transactions appear in the Pending tab, follow these steps to remove them from your active list.

1. Go to All apps , select Accounting, then select Bank transactions (Take me there).
2. Select the affected bank account.
3. Select the checkboxes for each duplicate transaction in the Pending tab.
4. Select Exclude.

The selected transactions move from the Pending tab to the Excluded tab.

To permanently remove transactions from the Excluded tab:

1. Select the Excluded tab.
2. Select the checkboxes for the transactions you want to delete.
3. Select Delete.

Remove categorised or matched duplicates

1. Go to All apps , select Accounting, then select Bank transactions (Take me there).
2. Select the Posted tab, then select the checkboxes for each duplicate transaction.
3. Select Undo. This moves the transactions back to the Pending tab.
   Note: If you have selected multiple transactions, select Undo, then select Continue.
4. Select the Pending tab, then select the checkboxes for duplicate transactions.
5. Select Exclude.
6. To permanently remove them, select the Excluded tab.
7. Select the checkboxes for the transactions you want to delete.
8. Select Delete.

The duplicate entries are permanently removed from your QuickBooks bank account records.