cancel
Showing results for 
Search instead for 
Did you mean: 
CarolCromack
Level 1

Some payments being received twice on QB rgister even with invoice closed

I have noticed that in my QB bank register some deposits being duplicated. For example, I receive payment on an invoice, match to the invoice number and all is fine. Then a week or so later, payment shows up again as a deposit in the QB register-thus the duplicate deposit. My initial thought was I must not have "received payment" properly. But if I click to receive payment again, then my Bank register goes up again! Not only is that happening, but the payment gets randomly matched to things like office supplies or Onwer's draw. These are customer invoices. This has happened to 5 invoices. This is also throwing off my receivables because it looks like I have unpaid invoices. Did the software get updated and could be causing this? Thank goodness I trust my online bank register and know what my receivables really are, because QBO isn't accurate. Thanks for any help.

2 Comments 2
ChristieAnn
QuickBooks Team

Some payments being received twice on QB rgister even with invoice closed

Welcome back to the QuickBooks Community, CarolCromack. I'll be sharing the possible reason why there are double transactions appearing on your Bank register. With this, I'll ensure that you can smoothly link the payment to your invoice by following the steps below based on your situation.

 

You can actually match directly the deposit from your bank feeds to the invoice you recorded in QuickBooks. It could be you added that deposit and then created a Receive Payment option that's why you see duplicate payments. 

 

You can delete one of the payments either the deposit from your bank feeds or the received payment you created. If you choose to use the added payment/deposit, you'll have to undo the entry and match it to the recorded invoice in the program. Beforehand, I suggest unlinking the payment to an invoice so you can remove the Paid stamp and the entry will be tagged as open. 

 

Here's how to unlink the payment: 

 

  1. Go to the Bookkeeping menu and choose Transactions. Then, select Invoices.
  2. Locate the entry that is tagged as paid and open it to expand the page.
  3. Click the payments made in the upper right corner and choose the date link.
  4. You'll be routed to the Receive Payment page. Then, click More at the bottom and select Delete.
  5. Choose Yes to confirm.

 

Then, please follow the steps on how you can undo the added deposit:

 

  1. Go to the Banking menu.
  2. Select the blue tile for the account you want to review.
  3. Select the Categorized tab.
  4. Find the transaction you to undo.
  5. Select Undo from the Action column.

 

Once done, the transaction will go back to the For Review tab. Then, you can now match the deposit to the invoice. You can open this article to see steps on how to perform the process: Categorize and match online bank transactions in QuickBooks Online.

 

However, if you wish to utilize the Received payment, you'll need to undo the added payment on your Banking page. Then, exclude this entry if necessary so it'll no longer appear on your bank register as double data. You can follow the steps I shared above on how you can undo and follow these steps on how to exclude:

 

  1. Go to the For review tab.
  2. Select the checkbox for each transaction you want to exclude.
  3. Select the Exclude button.

 

Excluded transactions move to the Excluded tab and they won’t be added to QuickBooks or downloaded again. Then, you can review your bank's register to check that there are no duplicates and that the actual deposit you received from your customer was linked to the invoice. 

 

Lastly, you may refer to this article to see steps on how you can reconcile your accounts to avoid any discrepancies: Reconcile an account in QuickBooks Online.

 

If you have follow-up questions on this matter or referring to something else, don't hesitate to click the Reply button below. I'm always here to help you further, CarolCromack. Have a good day!

CarolCromack
Level 1

Some payments being received twice on QB rgister even with invoice closed

Hello again. I hadn't been able to go online to try your suggestion. Today when looking at my bank register, everything is spot on. I did not do anything to make any changes to fix the initial problem. Nothing is recorded twice anymore. So- this was clearly a QBO issue. 

 

I still have 3  old invoices that were once marked as paid. They are still showing open. If I "receive payment" again, my bank balance will be off and overstated. 

 

Since QBO fixed itself with regard to the double payments shown on paper in the QBO register, I am tempted to see if the 3 open invoices will also resolve themselves.

 

Lacking faith in quickbooks for sure and seriously thinking of finding another software system to use. These mistakes in the software should not be happening. 

 

Need to get in touch?

Contact us