QuickBooks HelpQuickBooksHelpIntuit

How to remove duplicate bank transactions in QuickBooks Online

SOLVEDby QuickBooksQuickBooks Online22Updated 1 month ago

Learn how to remove bank transactions that show up as duplicates in your QuickBooks bank account.

If the duplicate transactions are showing in the 'For review' tab: 

1. Go to Bookkeeping, select Transactions, then select Bank accounts.

2. Select the affected bank account, then in the For Review tab, tick the duplicate transactions. 

3. A black box will appear at the top of all transactions, showing how many are selected. Select Exclude.

4. To permanently remove these transactions from QuickBooks, select the Excluded tab, then select the tick box to the left of the Date column to tick all transactions. Select Delete.

If the duplicate transactions are already categorised or matched:

1. Go to Bookkeeping, select Transactions, then select Bank accounts.

2. Navigate to the Categorised tab and tick all the duplicate transactions.

3. A black box will appear at the top of all transactions, showing how many are selected. Select Undo. This will move them over to the For review tab.

4. Navigate to the For review tab and tick the duplicate transactions.

5. In the black box at the top of all transactions, select Exclude.

6. To permanently remove these transactions from QuickBooks, select the Excluded tab, then select the tick box to the left of the Date column to tick all transactions. Select Delete.

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.