Skip to main content
H
hr-electric-outl
July 27, 2024
Question

How can I remove a duplicate deposit record in my bank transactions in QB? It's entered as I deposit and I showed it as received from an invoice.

  • July 27, 2024
  • 1 reply
  • 0 views
My 2nd comment should read, "It's entered as a deposit..."

1 reply

H
hr-electric-outlAuthor
July 27, 2024

I want to update the info on this as I've figured out the basic answer to my original question.  I just deleted the A/R records in my bank register in QB.  However, upon doing that, the invoices now show as over due and unpaid.

The problem is, these are all paid.  I can't seem to match the invoices to the payments that show up from my bank account to QB.  If I do show the payments as received, QB creates a duplicate entry but there's no option to associate that invoice with the deposit, as I've stated.

The status now is that I have 3 over-due and unpaid invoices showing at this time; which is false information.  Not sure what to do here.  Any help is always appreciated.

Thanks!

Brooks

H
Heide DC
July 27, 2024

I can help you remove duplicate transactions on your account, hr.

 

Excluding a transaction removes a transaction from any account registers or financial reports and QuickBooks will stop bringing the transaction into the bank feed again. Deleting them on the other hand will recognize that the transaction is not accounted for and will download the same transaction again from the bank.

 

Since you want to remove the transactions, we can exclude them. Here's how:

 

  1. Go to Transactions then Bank transactions.
  2. Select the bank account, then click the For review tab.
  3. Choose transactions you want to exclude.
  4. Click Batch actions, then choose Exclude.

 

Once you exclude a transaction, it will be moved to the Excluded tab. You can also undo a transaction, by going to the Excluded tab and clicking on Undo.

 

For your second concern, there are other reasons why the payments won't show when trying to find a match. Make sure that the transactions:

 

  • Same date, and amount.
  • Hasn't been reconciled.
  • Hasn't been matched to another downloaded transaction.
  • Was entered using the same bank account.

 

After confirming everything, we can utilize the Find Match feature again to show all potentially matched transactions. Learn the complete guide on how to add and match downloaded transactions in QBO: Add and match downloaded banking transactions.

 

In addition, I've added an article for you to learn how to reconcile your accounts, so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

 

Let me know in your reply if you need further questions about duplicated transactions in QuickBooks Online. I'm always here to lend a hand.

H
hr-electric-outlAuthor
July 27, 2024

Hello Heide,

 

Thanks for the reply.  So, the dilemma is that I had already added the deposits in "For Review" and the downloaded transactions are now in the bank register in QB.  (Had I known then...) So, I don't have the option to do this.  In the register (as in "Go to Bank Register") currently, the deposits show from info that came from my bank.  

I "deleted" the A/R version of the deposits - in other words, I had, at one point, "received" the payments on the invoices so they also showed in addition to what came over from my bank.  So, I deleted my A/R version, not the info that came from my bank.  Deleting placed my invoices into an overdue state.  They now sit in "invoices" as past due.  This allowed me to reconcile my back acct w/ QB but doesn't resolve what I should do with my "outstanding" invoices.  Does that make sense?  So, maybe I should ask: Is it best to delete the info that came from my bank account then receive the payments on those invoices?

 

I hope that makes sense.

Brooks

Terms & ConditionsAccessibility statement