Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
Then, please follow the steps on how you can undo the added deposit:
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:
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here