Hi QB Team,
Can you please help us? We have received a duplicated payment for a certain invoice which has been already paid a few months back.
And this duplicated payment has been already refunded as well.
How we will enter the duplicated payment?
Please see, attached screenshot.
Thank you and God bless,
Hello there, @panda0210. I can share more details on how to manage your duplicate bank transactions in QuickBooks Online (QBO).
You can exclude and delete the duplicate transaction on the Banking page. I'll show you the way how to do that:
I've also included this article to learn more about managing bank transactions: Categorise and match online bank transactions in QuickBooks Online.
Moreover, you can consider checking out this reference about fixing reconciliation issues in case you'll encounter any of these in the future: Undo or remove transactions from reconciliations in QuickBooks Online.
I'll be around if you have any questions about the exclude process or any QuickBooks-related questions. Take care always!
If I am going to exclude the transaction on the banking page, how about in the reconciliation? Because I checked our bank statement for the month of April and that amount appears in the statement.
Thanks for verifying your April bank statement. I'll share a suggestion about exclusion of duplicate payments in QuickBooks Online. This way, I can guide you accordingly on this matter.
Before excluding the duplicate payment, you'll need to manually unreconciled it in the register.
Do the following:
Once done, you may now undo the transaction on the Banking page. You can follow the instructions provided by my peer above.
After unreconciling, undoing, and excluding, the transaction will auto-delete in the Reconciliation Report. See the sample screenshot below for your reference:
Furthermore, visit these articles below on how to fix duplicate credit card payments and reconciliation errors in QuickBooks:
If you have a follow-up question about your duplicate transaction issue, feel free to drop me a line. I'd be happy to offer you some advice, and I'll be here should you need anything.
Thank you for your reply, however, I am still confused.
The amount is shown in our bank statement for April. Therefore, I think I need to enter the amount in our QBO so that when I do the reconciliation, our Bank Statement and QBO will reconcile.
Just like the same amount shown as Spent/Withdrawals. I enter it in QBO as a refund and it is showing both in the Bank Statement and QBO so I can easily reconcile both. But since the amount received is not yet entered in QBO, if I do the reconciliation it will not appear in the QBO but only appear in our Bank Statement which then will not match.
Please see the screenshot of our April Bank Statement, showing the debit and credit statements of that duplicated payment.
PS. I tried your suggestion to unreconcile manually the duplicated payment but unfortunately, it is not showing in the Chart of Accounts (Account List). Only the refund was there as an expense.
I appreciate you for coming back to the thread and adding further details about your concern, panda0210. With this, I'll ensure you'll be able to resolve the duplicate transactions and be able to reconcile your entries correctly.
To start with, you can exclude the duplicate payment that has been already paid and refunded that appears on the Banking page. However, if the double-entry has been added to QuickBooks, you can undo the payment first and then start excluding this transaction. That way, it won't appear in the statement.
On the other hand, you'll also have the option to enter the payment as a deposit in QuickBooks and record the same details. With this, you'll be able to see the deposit and double-entry appears in the Banking section as a match.
Here's how to enter the deposit:
Once everything is already accurate, you can now begin to reconcile your transactions. You may open this article to see the detailed steps on how to perform the process: Reconcile an account in QuickBooks Online.
Lastly, you may refer to this article to view various guidelines that will help you fix any reconciliation issues that you might encounter: Learn the reconcile workflow in QuickBooks.
Reach out to me if you have any other questions besides fixing duplicate payments. I'm a few clicks away to help. Have a wonderful day,
Hi Christie Ann,
I hope the second option is to enter the duplicated payment received as a deposit, however, I am just wondering if I do this option, the duplicated amount received will be added to our Sales.
Please help and be patient with me.
I'm joining the thread to share some insights about this duplicate payment posting concern, @panda0210.
Don't worry. I will help you make sure there aren't any duplicate sales entries recorded.
The key to a successful reconciliation is ensuring the bank statement matches with QuickBooks Online (QBO) transactions. With that said, you need to make sure you have recorded the returned amount in QuickBooks. There is no need to exclude any entries if they reflected in the bank statement. Doing so will only create a discrepancy during reconciliation.
First thing to do is using a bank deposit to show an increase in your bank balance for the duplicate payment. Then, match the two entries after (QB entry and downloaded bank transaction). This way, it doesn't show double on the register.
To enter a Bank Deposit, follow these steps:
The next and last thing to do is to record the refund. To do that, write a cheque to account for the return of funds. Cheques are money-out transactions, and they will reduce the register's balance for the duplicate amount. Just go to the + New menu, then Cheque.
I'll be adding some related links to help you out with matching your transactions and some reconciliation tips:
Come back anytime for any follow-up questions with this payment concern. I'm always here to make sure you're all set. Have a nice day!