Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
peter141
Level 1

How do I remove duplicate imported items from pending transactions?

This is the result of importing a bank statement more than once.

2 Comments 2
Clark_B
QuickBooks Team

How do I remove duplicate imported items from pending transactions?

Greetings, @peter141. You can use the Exclude option to remove the duplicate items from your pending transactions.

 

Here’s how:

 

  1. In the Accounting section, select Bank Transactions.
  2. Locate your duplicate items in the pending section.
  3. In the Action column, select the drop-down icon of the duplicate items and click Exclude.
  4. Once done, the duplicate will be moved to the Excluded section.

 

 

To remove it entirely, you’ll just have to go through the Excluded tab. Here’s how:

 

  1. Navigate to the Accounting section and select Bank Transactions.
  2. Go to the Excluded tab and find the items you previously excluded.
  3. Select the checkbox next to the Date and click Delete.

 

 

If you need help reconciling your accounts so your bank and credit card statements match, check this article: Reconcile an account in QBO.

 

On top of that, consider checking out our QuickBooks Live Expert Assisted team. They can assist you with duplicate transactions, accounts, categorization, and reconciliation.

 

Please feel free to click the Reply button if you have any other concerns.

inamkhan4545
Level 1

How do I remove duplicate imported items from pending transactions?

To remove duplicate imported items in QuickBooks Online, go to Transactions > Bank Transactions > For Review. Select the duplicates, click Exclude, then go to the Excluded tab and click Delete to remove them permanently. If already categorised, undo them first, then exclude and delete. Excluding prevents them from being added; deleting ensures they don’t re-import. Always review carefully before deleting transactions.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us