Duplicated Payment

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:

1. Go to the Banking menu and select the bank with the duplicate transaction.
2. Locate the transaction, click the box beside it and select Exclude.
3. In the Excluded section, locate the transaction, and check the box.
4. Select Delete.

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!

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: 

1. Go to the Accounting tab and choose Chart of Accounts. 
2. Select the appropriate account in the list. 
3. Locate the duplicate payment and press the R until the field is blank.
4. Click Save. 

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:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online. 
• Fix a credit card payment processed twice in QuickBooks Online

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.

Hi Michelle,

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.

Please, help.

Thank you,
Panda0210

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:

1. Click the + New button. Then, choose Bank Deposit.
2. From the Account dropdown, choose the account you want to put the money into.
3. Select the checkbox for each transaction you want to combine.
4. Make sure the total of the selected transactions matches your deposit slip. Use your deposit slip as a reference.
5. Click Save and close.

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, 

panda0210.

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.

Thank you,
Panda0210

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:

1. Click the Banking menu, then select the Make Deposits option.
2. In the Received From column, enter the company the funds are coming from.
3. For the Account column, add the bank account.
4. Add the correct transfer amount in the Amount field.
5. Make sure the deposit matches the net bank deposit amount.
6. Click Save and close.

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:

• Categorise and match online bank transactions in QuickBooks Online
• Reconciliation Hub

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!