cancel
Showing results for 
Search instead for 
Did you mean: 
lupinecase
Level 3

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!

 
6 Comments 6
Giovann_G
Moderator

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.

lupinecase
Level 3

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!

Bank is b of A

lupinecase
Level 3

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!

BoA

Charies_M
Moderator

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!

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:

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.

dgriffin5104
Level 1

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!

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. 

Carneil_C
QuickBooks Team

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!

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us