Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
dr.jessicatripp@
Level 1

How do I fix duplicate transactions due to importing reports from earlier in the year?

I had a bookkeeper tracking my books Jan-Aug of this year, and I took over in Sept. I now have duplicate transactions for Jan-Aug because my bank account that is linked is showing the transactions from that time frame. Is there a way to fix this issue? Can I specify for my bank account to show only from September forward?
1 Comment 1
Rubielyn_J
QuickBooks Team

How do I fix duplicate transactions due to importing reports from earlier in the year?

Welcome to the Community page, @DR.jessicatripp@.

 

I'm here to help you handle duplicate transactions in QuickBooks Online. 

 

When you come across duplicate transactions in QuickBooks Online (QBO), you can remove them based on your bank statement. Since you manually import them, we can proceed to the Categorize tab and then undo the duplicate entry.

 

Here's how: 

 

  1. Navigate to Transactions, then select Bank Transactions (Take me there).
  2. Go 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.

 

Regarding your second question, QuickBooks will only download the initial 90 days when you first connect your bank. You can specify your bank account to display transactions only from September onward. 

 

If you experience any challenges during your reconciliation in the future, please refer to this article for additional guidance on the steps you should take: Fix issues at the end of a reconciliation in QuickBooks Online.

 

If you have any further questions about managing your banking transactions, please don't hesitate to reach out. I'm here to support you in managing your financial records effectively.

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

Need to get in touch?

Contact us