Skip to content

How to Delete Duplicate Transactions in QuickBooks – Explained

Delete Duplicate Transactions in QuickBooks Desktop and Online

QuickBooks users can add their bank transaction details to their company files through a manual process or just connect their bank to QB and it automatically adds the data. Certain transactions can sometimes reflect multiple times in the Charts of Accounts due to human error or technical glitches. This error can create discrepancies in the books of accounts. In such scenarios, users are required to delete the extra transactions. The method to delete duplicate transactions in QuickBooks is totally different in QBD and QBO. Further, the steps you need to follow can be different while deleting transactions in Register Mode and Side-by-Side mode. 

Do you want to learn how to delete duplicate transactions in QuickBooks Desktop? Get an expert on call at +1-(855)-955-1942 and they will guide you on what you need to do. 

What causes QuickBooks duplicate transactions?

There are a few reasons that can cause QuickBooks duplicate transactions for you:

  • You might encounter a double or duplicate entry while importing lists or transactions into the company file. This importing list can be a result of some external software. In such cases, QuickBooks rebuild data utility can lead to these double transactions in QuickBooks. You will experience this when the utility tool tries to recover unrecoverable transactions.
  • While in some cases, if the details are missed out, then also duplicate entries can occur in the QuickBooks point of sale. 
  • Also, if you have added a few transactions manually, especially when the automatic feature is turned on, then also this double-entry issue can be seen.

The steps to delete duplicate bank transaction in QuickBooks online require users to run a report, find out the duplicate transactions, and then delete them. For QuickBooks Desktop steps, users must follow different steps for register mode and side-by-side mode. Let’s look at the steps users need to follow in detail:

Remove Duplicate Transactions in QuickBooks Desktop

There are two different sets of actions that users are required to follow in QuickBooks Desktop, depending on which mode they are in. Deleting transactions in Side-by-side mode is comparatively easier than in Register Mode. Look at the steps users need to follow for both of them:

1. Delete Duplicate Transaction in Register Mode 

Your register is shown at the top of the screen in the register mode. At the bottom of the page, you’ll find your downloaded transactions. Match the relevant transactions anyway if you know QuickBooks is correct and wish to eliminate the transactions that don’t match. Then remove the entire statement from the equation.

  • Click on the Banking tab and choose Bank Feeds from the list.
  • Further select Bank Feeds Center and browse and choose the statement from the Items Received from Financial Institution section. Then click on View from the drop-down menu.
  • To match the transactions, locate them and click Done.
  • When the Not finished Matching page appears, click on Yes to return to the Online Banking Center.
  • Look for and select the same statement in the Items Received From Financial Institution area. Then select Delete.
Delete Duplicate Transaction in Register Mode
Delete Duplicate Transaction in Register Mode

Duplicate Transactions should not appear the next time when you download a statement. If you don’t delete the matched statements, it will continue appearing in future downloads.

2. Delete Duplicate transactions in Side-by-Side Mode

In this mode, The downloaded transactions appear on the left side of the desktop. These are the steps you need to follow:- 

  • Tap on the Banking tab and select the Bank Feeds option.
  • Further, choose the Bank Feeds Center, and in the Item Reviewed section select the account for which you want to delete the transactions.
  • Click on Items to Delete and then choose the items you wish to delete.
  • Then tap on Delete Selected and press Yes to confirm.

NOTE: Tap on Select all downloaded transactions older than and set the date to the last statement end date if you’ve previously matched your statement. Then choose Delete Selected from the drop-down menu. To erase everything, you may need to switch to Register mode.

Delete Duplicate Transactions in QuickBooks Online

Users are required to run a traditional report, find out duplicate transactions and then delete transactions. These are the steps you need to follow:- 

Find Duplicate Transactions Through Traditional Report

NOTE: Type Vendor Balance Detail for the expense report. 

  • Click on Customize from the top and go to Transactions Date.
  • Set it to All dates and tap on Run Report.
  • Click on Sort drop-down and change sort by to Num.
  • Select Ascending or Descending as per your preferences and tap on Run Report.

Now find the duplicate transactions from the menu.

Deleting Duplicate Bank Transactions In QuickBooks Online

In QuickBooks Online, the process for deleting bank transactions is determined on the tab in which the transaction appears. If your transaction is categorized or matched, the steps are the same.

1. Duplicate Transaction Appearing in ‘For Review’ Menu

  • Click on Banking or Transactions button in the left menu. 
  • Select the bank account that has duplicate transactions and click on the For Review tab and select the duplicate transactions.
  • A black box will appear above all the transactions showing all the selected transactions. Tap on Exclude.
Exclude Transactions
Exclude Transactions
  • Click on the Exclude menu, To permanently remove these transactions from QuickBooks, and then tick the box at the left of the Date column. Then select Delete.
Delete Duplicate Transaction Appearing in ‘For Review’ Menu

Delete Transactions in For Review Menu

2. If the Duplicate Transactions are in Categorised or Matched Transactions

  • Click on the Transactions menu.
  • Go to Categorised tab and tick all the duplicate transactions.
  • A black box will appear at the top of all transactions, show how many are selected. Click on Undo and then they will move to the For Review tab.
Checking for Duplicate Transactions in QuickBooks
Checking for Duplicate Transactions in QuickBooks
  • Go to For Review tab and tick mark all the duplicate transactions.
  • A black box will appear, go to the Exclude menu.
Clear Duplicate Transactions in QuickBooks
Clear Duplicate Transactions in QuickBooks
  • Select the Excluded tab, then tick all transactions in the tick box to the left of the Date column to permanently remove these transactions from QuickBooks. Click on Delete.
Steps to Delete Transactions (If the Duplicate Transactions are in Categorised or Matched Transactions)
Steps to Delete Transactions (If the Duplicate Transactions are in Categorised or Matched Transactions)

So this is all about how to delete duplicate transactions in QuickBooks desktop and online version. Follow these steps in case your books show discrepancies due to duplicate entries. If you still have any doubts left, reach out to an expert at QuickBooks Data Service Solutions Helpline Number +1-(855)-955-1942 and they will solve all your queries.

1. How do I switch Bank Feeds mode to delete the duplicate transactions in QuickBooks Online?

If you want to switch Bank Feeds mode while deleting duplicate transactions in QuickBooks Online, click on the Edit menu option followed by the Preferences tab. After that, from the left side of the screen, click on the Checking option, then on the Company Preferences tab. After that, from the Bank Feeds option, you can choose from Classic Mode, Express Mode, or Advanced Mode and then press OK.

2. How to review and match the transactions on QuickBooks?

To review and match the transactions in QuickBooks, go to the QB Online Banking menu, then go to the Bank Feeds option. After that, select the Bank Feed Center, and you can review the transactions in each category.

Leave a Reply

Your email address will not be published. Required fields are marked *

nv-author-image

Lily Evans

Lily Evans is a Certified Accountant with Expertise in QuickBooks, Sage and Quicken Accounting Software. Lily has been working with Data Service Solutions for the last 3 years as a QuickBooks Expert and is Helping Accounting software users with their day to day accounting tasks and issues.

© Dataservicesolutions - All Rights Reserved

Disclaimer

"Data Service Solutions" is a Accounting and Bookkeeping service provider. We are distinguished by the virtue of our expertise in various products developed by a wide range of third-party companies. The use of any third-party trademarks, logos, or brand names on our website or other platforms is for informational purpose only. It does not imply any endorsement by Data Service Solutions or vice-versa or that the trademark owner has authorized or collaborated with Data Service Solutions to promote their products and services.

Data Service Solutions does not have any affiliation from any third-party companies, unless any such relationship is explicitly specified. We have no link or affiliation with any of the brand or third-party company as we independently offer support service for all the product errors you face while using different accounting software.

For detailed information on permitted use and specific warranties associated with the software or its peripherals, please contact the concerned third-party directly. Any content accessed, downloaded, or otherwise obtained from or through the use of the website should be at your own discretion.

Intuit and QuickBooks are trademarks and service marks of Intuit Inc., registered in the United States and other countries. It’s Completely Your Choice to Purchase Your Product Directly from Intuit® And Contact Intuit® Directly for Support. Intuit®, The Intuit® Logo, QuickBooks®, TurboTax®, Quicken® Are Registered Trademarks of Intuit Inc. Data Service Solutions Is an Independent from Intuit Inc. Intuit®, QuickBooks®, TurboTax®, Quicken® Among Others, Are the Registered Logos, Trademarks and Brand Names of Intuit Inc. And Are Used Here Solely for The Purpose of Reference.