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. Tick the boxes 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. Tick the boxes 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 tick the boxes 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 tick the boxes for duplicate transactions.
5. Select Exclude.
6. To permanently remove them, select the Excluded tab.
7. Tick the boxes for the transactions you want to delete.
8. Select Delete.

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