cancel
Showing results for 
Search instead for 
Did you mean: 
Community Contributor *

QB 2019, Duplicated Banking Statement Transactions, How do I remove statement or individual transactions?

I am using QB 2019 Desk Top. I am trying to bring my bookkeeping up to date and audit my accounts. I have found that for several months the downloaded credit card statements have created duplicate transactions (one will be check as if reconciled and the other has a lightning bolt by it in the register view) and it creates a duplicate entry in my bank register for a payment which adversely affects my balance. 

Can someone tell me how to delete statement and start over, or delete the individual transactions. Do I have something set wrong that is creating this problem or am I doing something wrong in bring the data in. 

I am a contractor, a one man show and I am not a proficient user of QB. I need to get everything in my system up to date and cleaned up. Then I want to do something to archive the older years and just have them available to dig up if ever needed for reference and then I am thinking about switching over to QB Online.  

I am in a crunch because I have to file taxes by the 15th.  

Can someone give me some guidance.

3 Comments
Highlighted
Moderator

Re: QB 2019, Duplicated Banking Statement Transactions, How do I remove statement or individual t...

Hi Hugh McG,

 

Let's go to the bank register and delete the duplicate transactions one by one.

 

  1. Go to the Lists menu.
  2. Click Chart of Accounts to select a bank account by clicking twice.
  3. Double click those transactions with lightning bolts.
  4. Then, press CTRL+D to delete.
  5. Click OK to confirm deleting the transaction.

 

It's possible that you've downloaded the entire statement via web connect to QuickBooks. This is why you're having duplicate transactions. To avoid this from happening, you'll have to check the date range before importing them. 

 

On the other hand, we are not able to archive a part of the company file. You can still keep the company file as your reference. Though, you can start using QuickBooks Online with the new fiscal year.

 

Lastly, I'd suggest reaching out to your accountant to help you submit your taxes on time.

 

I'll be right here if you need more help with QuickBooks Desktop.

Community Contributor *

Re: QB 2019, Duplicated Banking Statement Transactions, How do I remove statement or individual transactions?

Hi Sarahann, 

Thank you for responding. Is it ok to use Journal Entries to make these corrections or should I not. I started doing that but I can easily void or delete them.  

Thanks, Hugh

QuickBooks Team

Re: QB 2019, Duplicated Banking Statement Transactions, How do I remove statement or individual t...

I appreciate you for coming back, Hugh McG.

 

We don't advise creating a Journal Entry to correct this. Yes, you can simply follow SarahannC's recommendation which is to manually delete those duplicate transactions.

 

Moving forward, I suggest reviewing the transactions before importing them. 

 

Stay in touch if you have any other concerns. I'd be happy to help you all the way.

Need to get in touch?

Contact us