Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 15, 2024
Solved

How do I fix duplicate bank entries from invoices and bank deposits in QuickBooks Online?

  • January 15, 2024
  • 6 replies
  • 101 views

Hi,

 

I am new to quickbooks.  I am seeing duplicate entries in my bank transaction.  1. My invoices I list as accounts receivable and when I send it to my client, they automatically pay my business account, not through quickbooks as they have a 3rd party provider provide payment directly to my business account. 

 

The issue:

 

When I go and click on invoice paid, it will show in my bank transaction and so will the automatic payment my client paid.  

1 How do I link the invoice to that payment that is in my bank so it shows it's matching and/or 2, how do I remove one of the of them so its not a duplicate in my bank transactions. 

Best answer by cody_a

This happens when a customer pays an invoice directly into your bank account outside of QuickBooks, so the payment shows up twice: once when you mark the invoice paid, and again when the bank feed downloads that same deposit. The fix is to match the downloaded bank transaction to the invoice payment you already recorded, instead of letting QuickBooks add it as a second, separate entry.

Step 1: Find the downloaded transaction

  1. Go to All apps, then Accounting, then Bank transactions.
  2. Select the bank account the deposit came into.
  3. Open the For review tab and find the deposit that matches your client's payment.


Step 2: Match it instead of adding it

QuickBooks usually suggests a match automatically when the amount and date line up (within 90 days before to 20 days after the transaction date).

  1. In the Categorize or Match column, look for the suggested match, or select the transaction to expand it.
  2. Review the details to confirm it's the same payment.
  3. Select Post to complete the match, rather than Add.


Matching links the bank deposit to the invoice payment you already created, so it counts once instead of twice. If you already selected Add by mistake and ended up with a duplicate, you can undo it: go to the Posted tab, find the transaction, and select Undo. That sends it back to For review so you can match it correctly.

Why this keeps happening

If your client's payment method sends money straight to your bank account rather than through QuickBooks, you'll see this every time you invoice them. You'll still want to create the invoice for your own records, but plan to match, not add, the resulting deposit each time it lands in your bank feed.

Learn more: Match your bank and credit card transactions

 

Have more questions about keeping your bank transactions clean? Drop a reply below.

6 replies

Level 6
January 15, 2024

Welcome to the Community. I understand that managing bank transactions can be challenging. I'm here to lend a hand to help you address your duplicate entries, @DDOW12


It looks like your client's online payment went directly into your bank account and was automatically added to your bank register. Meanwhile, you also manually marked the invoice as paid, causing a duplicate payment deposit in QuickBooks. 

 

What we can do here is undo the downloaded payment to bring it back to the Banking page. Then, match it to the manually added payment instead of matching it to the invoice. This will help ensure that the payment is correctly linked to the invoice and avoid the duplication in your bank transactions.

 

To do this, you can follow these steps:

 

  1. Go to the Transactions menu.
  2. Click the Bank transactions tab and select the bank tile in question.
  3.  Locate the downloaded payment transaction  in the Categorized tab that is causing the duplication.
  4.  Select Undo or remove the match for this transaction.
  5. Then, manually match it to the corresponding invoice payment within QuickBooks.

See this screenshot below for your reference.

Additionally, here's an awesome resource that you can access to have a guide in managing your transactions: Categorize and match online bank transactions in QuickBooks Online.

 

It's also recommended to perform the reconciliation process regularly to make sure your accounts are matched. To get started, check out this link for the detailed instructions: Learn the reconciliation workflow in QuickBooks.

 

I'd love to know updates about this. If you have any other questions about managing your bank transactions in QBO, feel free to leave a reply below. I'm just around the corner to help. Have a good one and keep safe. 

DDOW12Author
January 15, 2024

Thank you!  

It was still showing when I tired that method but I did see I can match the invoice to the bank deposit by finding a match in the transaction and either confirming.   This appears to have removed the duplicates. 

 

 You are correct that our client pays directly to the bank so this will happen every time but for my bookkeeping I still need to create invoices.   I will need to do this each time.  

 

Appreciate you help. 

 

 

 

 

QuickBooks Team
January 15, 2024

Hi there, @DDOW12.

 

I'm happy to hear that my colleague, was able to assist in finding the solution with your duplicate transactions in managing your roles in your QuickBooks Online (QBO) account.

 

Feel free to contact me if you need help managing your account or using any QBO features. I'm always here to assist you at any time.

cody_a
cody_aCommunity ManagerAnswer
Community Manager
August 25, 2026

This happens when a customer pays an invoice directly into your bank account outside of QuickBooks, so the payment shows up twice: once when you mark the invoice paid, and again when the bank feed downloads that same deposit. The fix is to match the downloaded bank transaction to the invoice payment you already recorded, instead of letting QuickBooks add it as a second, separate entry.

Step 1: Find the downloaded transaction

  1. Go to All apps, then Accounting, then Bank transactions.
  2. Select the bank account the deposit came into.
  3. Open the For review tab and find the deposit that matches your client's payment.


Step 2: Match it instead of adding it

QuickBooks usually suggests a match automatically when the amount and date line up (within 90 days before to 20 days after the transaction date).

  1. In the Categorize or Match column, look for the suggested match, or select the transaction to expand it.
  2. Review the details to confirm it's the same payment.
  3. Select Post to complete the match, rather than Add.


Matching links the bank deposit to the invoice payment you already created, so it counts once instead of twice. If you already selected Add by mistake and ended up with a duplicate, you can undo it: go to the Posted tab, find the transaction, and select Undo. That sends it back to For review so you can match it correctly.

Why this keeps happening

If your client's payment method sends money straight to your bank account rather than through QuickBooks, you'll see this every time you invoice them. You'll still want to create the invoice for your own records, but plan to match, not add, the resulting deposit each time it lands in your bank feed.

Learn more: Match your bank and credit card transactions

 

Have more questions about keeping your bank transactions clean? Drop a reply below.