When I receive Customer Payments and apply it to the outstanding invoices, the payment is recorded into the file. At the end of the month, when I download the transactions from my bank, the deposit for that payment gets duplicated. How do I receive the payment, but not have that enter into the file. The deposit downloaded is more accurate in terms of date.
Solved! Go to Solution.
I have a similar problem the bank feeds total the day for credit-debit card transactions and I am entering each sale in individually that goes into the check register. Our payments are paid at time of service is complete. If I understood your response correctly I need to add up each day to ensure it matches the total on the bank feed and not pull in the bank feed if the amounts match. We have the same issue with bank deposits when we go to the bank to deposit check and cash those transaction are already in QuickBooks check register as a sale.
The correct process is to ignore the bank feed transactions not pulling them into QuickBooks if they are already in the check register. Correct?
I can provide additional information on how to avoid duplicates transactions in your bank transactions.
In QuickBooks Desktop, there's a specific Accounts Receivables workflow to record your transactions to avoid messing up your accounting data.
To avoid getting duplicates, make sure to select the correct Deposit To bank accountin the Customer Payment window.
By doing the steps above, the payments are directly deposited to your preferred bank account.
Since your transactions are downloaded from your bank, just wait for the transaction to be cleared from your bank and downloaded into QuickBooks. Once downloaded, you can now proceed with matching the transactions.
For additional insights, you may check out these articles:
That should do it! Keep in touch with us here in the Community if you have other questions about recording your customer's payments. I'm always here to help.
I am having the same issue. The transaction gets duplicated and none of the workflows mentioned will remove the duplicate.
Hi there, riedabook.
The steps provided above help you avoid getting duplicates in QuickBooks Desktop. If you have duplicate transactions, they you'll able to remove them depending on which banking mode/view you're using.
Here are the steps to check your mode preferences:
Now, I'm linking an article that will help remove duplicate transactions in QuickBooks Desktop.
You can also check out this article that will help you in the future: Deposit customer payments.
That should do it. Let me know how it goes by leaving a comment below. I'll be here to keep helping. Have a wonderful day.
Hi JaneD, Thank you for the fast response and tips. I should have mentioned that I am using QB Online. I tried to follow these workflows, but they don't seem to wok for the Online version.
I also found this is a known bug with the following investigation # (INV-19995). I wrote to QB to see if there is a fix for this, but did not hear back.
Thanks for the additional information, riedabook.
The INV you’ve provide has already been closed. Though, i can check if there’s an ongoing investigation about this. I just need to know your bank so I can search it easily. Sometimes, duplicate transactions are due to issues on the bank side. The way we fetch data for transactions that change date and/or descriptions within your bank's website can also caused this.
You can exclude duplicate transactions in QuickBooks Online through the steps below:
Please take a look at this article for further information: https://quickbooks.intuit.com/learn-support/en-us/bank-transactions/exclude-expenses-from-downloaded...
Looking forward to your response. I'll be around to help.
The transactions were already Reviewed, and appear in the Reviewed tab. Each transaction only shows up once in that tab, so I can not exclude the duplicate. They are duplicated in the account register. One is labeled a deposit and the other is payment. The payment is matched to the invoice, which is what I expected.
The deposit is to account Sales
The payment is to account AR
This duplication impacts the cash on hand calculation.
Let's get these duplicates deleted, riedabook.
From your register, select the deposit and click on Delete.
Once done, please run the Sales by Customer Summary report to verify if there are no more duplicate sale entries.
Here's also a guide that'll prevent duplicate entries in your register:
By following the recommended steps when receiving payments, your bank account and register will be reconciled. Let us know if you've got more questions. We are here to help.
I looks like I was not following that work flow, which caused the duplicates. If I delete a deposit I didn't intend to how do I bring it back?
Hello again, @riedabook.
You'll have to manually re-enter the transaction once you void or delete them in QBO. For steps and additional insights on how to record and manage Bank Deposits, you can refer to the link.
Additionally, you may check and verify the Audit Log to view the changes made on your account, such as creating, editing, and deleting of transactions. For more details, you can check out this article: Learn about the audit log.
Keep in touch with me if you seek further assistance. You can post your response below, and I'll be sure to get back to you.