When I go into to reconcile, I often have duplicate or triplicate transactions. Happened in 2020 and my accountant had to go in and delete. Now it is in 2021. HELP!

Hello, lupinecase.

I understand the importance of reconciling an account to ensure that the balance in QuickBooks matches your bank and credit card statement balance. I'm here to assist you in eliminating duplicates during reconciliation.

First and foremost, could you tell me the name of your bank linked to your QuickBooks account? This will assist me in determining whether or not there has been a reported issue with duplicate transactions.

When you connect your bank account, QuickBooks downloads transactions depend on the information shared by your financial institution. One of the possible reasons for a duplicate is that you've recorded the transactions within QuickBooks and added the uploaded transactions from the Banking page instead of matching them.

Let's check your Audit log report so we can determine the proper action to take to remove the duplicates. Here we'll know if someone added transactions or if they were downloaded from your bank account.

Here's how:

1. Sign in to your QuickBooks Online (QBO) account.
2. Navigate to the Gear icon.
3. Select Audit log.
4. Click the Filter drop-down menu.
5. Personalize it to All users, select Show all events, or thick the Transactions box.
6. Then hit Apply
7. Select the duplicate transactions and delete them.

Additionally, you can consider undoing and excluding the duplicates if they're coming from downloaded transactions. I'll show you how.

1. Go to the Banking menu.
2. Select the appropriate bank account.
3. Go to the Categorized tab, then find the duplicate transactions.
4. Click Undo under the Action column.

After that, the transactions will be back to the For Review tab. Then, you can exclude them.

Once everything is in order, you can now proceed with reconciling your account. I've also included this article if you need to fix issues from the past reconciliation period: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Don't hesitate to reply if you need further assistance with reconciliation. I'll be delighted to work with you again.

Bank is b of A

BoA

Thanks for the additional information, 

Looking into that, I suggest continuing the recommended troubleshooting steps shared by Giovann_G above. 

If the steps didn't work, I recommend reporting this to our Quickbooks Online Support team. They have the tools to pull up your account and investigate the error you're receiving. 

Here's how to contact our Customer Support Team: 

1. Go to the Help menu at the upper right. 

2. Select Contact Us. 

3. Enter your concern. 

4. Click Let's talk. 

5. Select either Get a callback or Start messaging. 

6. Type in your info. 

7. Choose either Confirm my call or Send a message.

In addition to that, you visit these links about reconciliation in QBO:

• Reconcile an account in QuickBooks Online
• Learn the reconcile workflow in QuickBooks

Should you have anything else you'd like to go over while reconciling, feel free to reach out to us again. I'm always here to assist you further.

This has been happening to me as well. My question is should I simply not select the item and continue with reconciling, OR should I get these 11 duplicate transactions to go back to be excluded once again? Typically, I was deleting or voiding the transactions and continuing with the reconciliation only to end up beginning balance reconciliation discrepancies. 

I recognize how time-consuming it is for you to reconcile your account and still have discrepancies due to the duplicates, @dgriffin5104.

I'll help you sort out this issue so you can balance your books seamlessly in QuickBooks Online (QBO).

Before anything else, would you mind telling me your bank? So that I can check here on my end if there are reported issues regarding this matter.

If the duplicate transactions are from the Banking page, you'll want to Undo them and Match or Exclude them so they won't show again as duplicate transactions. I'll be providing the steps below for further guidance. Here's how:

1. Go to the Transactions menu and then click Bank Transactions.
2. Choose the tile of your bank.
3. From the Categorized section, locate those duplicates and then click Undo under the Action column.
4. Once done, find the transactions and select Match.
5. Otherwise, click the transaction and hit Exclude.

Then, you can now proceed with reconciling your accounts.

Furthermore, I'll add this handy guide for more ways to fix issues after reconciling an account: Fix issues at the end of a reconciliation in QuickBooks Online.

If you want to pull up a report each time you finish reconciling, this handy resource gives you the details: How do I view, print, or export a reconciliation report?

The Community space is still open for banking and reconciliation queries. We always have your back. Take care always.

How do you do it on the desktop? I have same problem. Thanks

Let's remove the duplicate transactions so you can wrap up your reconciliation, kperkic. I'll guide you through the process of how you can do this in the Desktop version.

First, let's identify the transactions that appear as duplicates. Here's how:

1. Go back to the Reconcile window.
2. Take note of the duplicate transactions, then exit out of the page.

Next, run transaction list reports for both customers and vendors to cross-reference them with your bank statement. Then, keep an eye out for any entries that have matching amounts, dates, and payees. These transactions might have been inadvertently entered multiple times in the bank register.

Let me share these steps on how to run the reports:

1. Go to the Reports menu, scroll down to Consumers and Receivables, and then choose Transaction List by Customer.
2. Go back to the Reports menu, hover your mouse to Vendors and Payable, and then click Transaction List by Vendor.
3. Change the dates to the period that's part of your reconciliation in the Dates section.
4. Look for the duplicate transactions and review them one at a time.

Once you confirm a transaction is duplicated, you can either delete or void it. To do this:

1. Open the duplicate transaction.
2. Click the Delete or Void option, depending on your preference. Deleting removes the transaction completely. Voiding on the other hand changes the amount to zero but keeps a record in QuickBooks.
3. Choose Yes to confirm the action when prompted.

After removing duplicates, return to the Reconciliation window and proceed with reconciling your account.

Additionally, here are some articles that can serve as references while you process your reconciliations in the software:

• Reconcile previously deleted and re-entered checking or credit card transactions
• Correct customer payments that have been deposited or reconciled

Don't hesitate to reach out if you have any questions while finishing your reconciliation or tackling other year-end tasks. We're here to help whenever you need us. Just reply to this thread, and we'll provide further assistance.