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.

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

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.

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

Thank you for explaining your concern further.

You're right. It's best to delete the info from your account and receive the payments on those invoices.

To start, let's delete your downloaded transactions:

1. Go to the Banking menu and select the bank account.
2. Find the transactions that correspond to the invoice payments.
3. Delete these transactions from the bank register.

Once done, let's recreate the Received Payments for your Invoices so we can mark them as Paid:

1. Go to the + New button and select Receive Payment.
2. Enter the payment details and make sure to select the correct invoice to apply the payment to.

Once you've recorded the payments and marked the invoices as paid, let's navigate to the Banking menu and Match these transactions.

Since you've already reconciled your accounts despite not marking your invoices as paid, I suggest consulting your accountant, as they have the necessary tools to undo your reconciliation accurately.

Let me know if you need further help. Keep safe.