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.
I am having a similar issue, except my issue is that when a customer pays via quickbooks payments QB's will receive the payment, close out the invoice but not deposit it. It says its deposited but my amount in the bank does not change to match the bank feed. Then the payment comes through on the bank feed. I can't match it to the payment because it is already closed out in QB's. Is there a setting where I can change this? I have unapplied the payment to open up the invoice so I can apply the transaction that has come through the bank feed but then that leaves a credit on the customer's account, and their money is sitting there. Please help!
Good day to you, ABNbookkeeping!
Please avoid making your invoices unpaid. You'll want to deposit the payments to your bank register instead, so you can match them to your downloaded transactions.
On the other hand, there’s a setting, where you can choose which register the payments and the fees would post in QuickBooks. You can set this, so you won’t have to manually do deposits to reflect them to their respective registers. You can find the detailed instructions with a screenshot in this article: Record Merchant Service Deposits. This section: Configure deposit and fees account settings in QuickBooks Desktop.
By the way, if you have unapplied payments at the moment, you can delete them, so they won't show as credits to your customers.
Please let me know if there's anything I can help with your merchant transactions. Always remember that you can ask questions anytime, even on Sundays.
I thought you're using QuickBooks Desktop like other users in this thread. Thanks for the info.
You can do the same thing in QuickBooks Online. You'll want to keep your paid invoices as they are. Then, just deposit the payments to your bank register (+New > Make Deposit), and match them to your online banking transactions.
You can also set an account for your deposit and fees, like in QuickBooks Desktop. In this way, the payments and the fees will directly go to these accounts.
You can check the FAQs for additional reference.
We're just around if you still need help handling your merchant transactions.
Hi all. I'm using QBO. I'm reconciling and having the same issue as previously mentioned. Wire transfers that show up as both a PAYMENT and a DEPOSIT. Only the deposit is checked and cleared and will allow the reconcile, but the payment transaction remains. When I delete it, it ALSO deletes the deposited one and throws off my register by that same amount. Any clue why this is happening and what the actual fix is? Thanks in advance!
Thanks for following on this thread, @7261211.
The wire transfers will show up as both a PAYMENT and a DEPOSIT when you use the same bank as the posting account. To rectify the issue, use a different account to categorize the entries.
Let’s perform this process one at a time. Here’s how:
Once done, you can start reconciling the account. Here’s an article that provides an overview of how to balance transactions in QBO: Reconcile.
If you have any clarifications or additional questions, enter a comment below. I’ll jump right back in to answer them for you. Have a great rest of the day.