cancel
Showing results for 
Search instead for 
Did you mean: 
Sunny93117
Level 2

Duplicate Transactions on QBO

I'm doing my bank reconciliations...I see duplicate transactions, See attached...why do I have this? I can clear one but what will I do with the other one?  Does this mean the expense are reflected twice in my books?  help!

 

Thank you

3 Comments 3
JonpriL
Moderator

Duplicate Transactions on QBO

Hello @Sunny93117,

 

In QuickBooks Online, you may review duplicate entries upon reconciliation based on how you categorize them from the list of downloaded transactions. Say QuickBooks already found an exact match of an entry and you also accept them at the same time. 

 

Yes, you can clear them and they're also posted as duplicate transactions on your books. With this, let's consider deleting the other duplicate directly on your account register. Let me show you how.

 

  1. Go to Accounting.
  2. Select your bank account.
  3. Under ACTION, select View register.
  4. Choose the transactions in question, one at a time.
  5. Select Delete.
  6. Click Yes.

 

Additionally, I've also included this reference with a compilation of articles you can use while working with your bank reconciliation: Learn the reconcile workflow in QuickBooks.

 

If you have any other questions or clarifications related to the steps above, please let me know in the comments below. I'll be here to lend a hand.

Sunny93117
Level 2

Duplicate Transactions on QBO

Additional question, so you are saying I did not match but added the transaction that's why there was a duplicate? Also, which one i should delete on the duplicate transaction...the one I added from the banking  or the one that says System-recorded fee for QuickBooks Payments. Fee-name: DiscountRateFee, fee-type: Daily. Thank you for your help.

 

 

 

RenjolynC
QuickBooks Team

Duplicate Transactions on QBO

Thanks for coming back here, Sunny93117.

 

I'd like to share a possible solution. 

 

When you use both Online Banking and QuickBooks Payments, this can duplicate the information in your QuickBooks. To verify, did you add the transactions from the Banking page instead of matching them? If so, you'll want to undo the process and match the downloaded transactions to the fees added in QuickBooks. This way, you'll be able to reconcile the account.

 

To undo, here's how:

 

  1. Go to Transactions > Banking > Categorized tab.
  2. Put a check mark on the transactions you want to undo.
  3. Click the Undo button.

Here's a sample screenshot for a visual reference:

 

 

The transactions will be added back to the For review page, where you can find a match or confirm it when there's already a matched. Then, go back to Accounting > Reconcile and check the transactions. 

 

I'm also adding these articles to help you:

 

Please let me know if you're able to reconcile the account. I want to make sure this is resolved for you. Take care!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us