Duplicate Payments

here is an exaample

Hello, @donskull.

I can walk you through the steps on how to remove the duplicates transactions in QuickBooks Online so your books will accurate. 

Let's exclude the duplicate transaction by going to the Banking page. This won't affect your reconciliation, it will make your balances match when you reconcile the account.

Here's how: 

1. Click on Banking in the left navigation tab.
2. In the In QuickBooks tab, select the duplicate transactions. 
3. Hit on Undo.
4. In the For Review tab, pick the duplicate transactions. 
5. In the Excluded tab, check the boxes for these duplicates.
6. Hit on Batch actions and select Delete.

For more details, check out this article: Exclude a bank transaction from your expenses in QuickBooks Online. 

Once done, you can now reconcile your account. For the step-by-step instructions, visit this article: Reconcile an account in QuickBooks Online.

After that, you can access the Reconciliation report to track and manage the transactions. Then select a Report period and Account to show the specific transactions. 

You can read through this article for more details in troubleshooting reconciliations: 

• How to adjust a reconciliation
• How to unreconcile a transaction or undo a reconciliation
• Reconcile hub

Reach out to me if you have other questions. I'm glad to help. Take care!

When I click on banking I don't have the "In Quickbooks" tab you mention.  

Also, no duplicates show.  I can go to Categorized and there is an option to UNDO, but it warns it will affect other things and linked transactions.

Hi there, donskull.

I'll make sure that you can delete the duplicate transactions.

We can undo the duplicates from the Categorized tab to get rid of them. Since the transactions are already reconciled, the program will prompt you that saving the changes might affect your next reconciliation. We'll just have to select Continue to successfully undo them. 

Here's how to do it:

1. Select Banking or Transactions from the sidebar menu.
2. Click Banking, then select the appropriate bank account.
3. Go to the Categorized tab.
4. Locate the duplicate, then click Undo from the Action column.
5. Select Continue to confirm the changes.

Once done, let's go to the For review tab to exclude the duplicate transactions. Please know that you may also need to undo and then redo the previous reconciliation to keep the account balance and up-to-date.

Additionally, here are some articles that you can read to help resolve common reconciliation issues:

• Fix issues when you're reconciling accounts

• Fix beginning balance issues if you've reconciled the account in the past

• Fix QuickBooks Payment deposits that don't match your bank statement

If there's anything else that I can help you with, please don't hesitate to add a comment below. Have a pleasant day ahead.