Learning Center

How to Clean Up Duplicate Transactions in QuickBooks Online

One of the most common QuickBooks Online problems isn't a missing transaction.

It's the same transaction showing up twice.

Duplicate transactions can distort revenue, inflate expenses, throw off account balances, and make financial reports unreliable. Fortunately, cleaning them up is usually easier than many business owners think.

Here's how to identify and remove duplicate transactions in QuickBooks Online.

Why Duplicate Transactions Happen

Most duplicate transactions occur because information enters QuickBooks through multiple channels.

Common causes include:

  • Bank feeds importing transactions already entered manually

  • Duplicate uploads from CSV files

  • Multiple users entering the same transaction

  • Third-party app integrations creating duplicate records

  • Reconnected bank feeds importing historical transactions again

Even a few duplicate entries can significantly impact financial reporting over time.

Step 1: Review Your Bank Register

Navigate to:

Accounting → Chart of Accounts → View Register

Review the account in question and look for:

  • Identical transaction amounts

  • Matching transaction dates

  • Duplicate payees

  • Repeated deposits

These are often the easiest duplicates to identify.

Step 2: Check Bank Feed Transactions

Navigate to:

Transactions → Bank Transactions

Review recently imported items.

Watch for:

  • Transactions that were manually entered before import

  • Transactions categorized twice

  • Items sitting in "For Review" that already exist in QuickBooks

Step 3: Run a Transaction Detail Report

Navigate to:

Reports → Transaction Detail by Account

Customize the report by:

  • Narrowing the date range

  • Sorting by amount

  • Sorting by vendor or customer

Patterns often become obvious quickly.

Step 4: Determine Which Transaction to Keep

Before deleting anything:

Ask:

  • Is one reconciled?

  • Is one connected to a bill or invoice?

  • Does one contain attachments or notes?

Keep the more complete version whenever possible.

Step 5: Delete or Exclude the Duplicate

For manually entered duplicates:

  • Open the transaction

  • Select More

  • Click Delete

For bank feed duplicates:

  • Select the transaction

  • Choose Exclude

Step 6: Review Financial Reports

After cleanup, run:

  • Profit & Loss

  • Balance Sheet

  • Account Quick Reports

Verify that balances now appear accurate.

Preventing Future Duplicates

The best cleanup strategy is prevention.

Consider:

  • Establishing clear bookkeeping workflows

  • Limiting duplicate data entry

  • Reviewing imported transactions weekly

  • Monitoring integrations regularly

Duplicate transactions are one of the most common QuickBooks Online issues, but they don't have to become a major bookkeeping headache.

Regular review of bank feeds, reports, and account registers can help keep your records clean and your financial reports accurate. 

Share this article...

NEVER MISS A STORY.

Sign up for our newsletters and get our articles delivered right to your inbox.

I confirm this is a service inquiry and not an advertising message or solicitation. By clicking “Submit”, I acknowledge and agree to the creation of an account and to the and .

Social Media

Rose Tax & Financial

8 Pinon Ave
Cedar Crest, New Mexico 87008
Mon - Fri: 10:00am to 6:00pm
Sat: 10:00am to 2:00pm

Check the background of your financial professional on FINRA's BrokerCheck
Avantax affiliated Financial Professionals may only conduct business with residents of the states for which they are properly registered. Please note that not all of the investments and services mentioned are available in every state. Securities offered through Avantax Investment Services℠, Member FINRA, SIPC, Investment Advisory services offered through Avantax Advisory ServicesSM, Insurance services offered through an Avantax affiliated insurance agency. 3200 Olympus Blvd., Suite 100, Dallas, TX 75019. 972-870-6000.
The Avantax family of companies exclusively provide financial products and services through its financial representatives. Although Avantax Wealth Management® does not provide or supervise tax or accounting services, Avantax representatives may offer these services through their independent outside business. Content, links, and some material within this website may have been created by a third party for use by an Avantax affiliated representative. This content is for educational and informational purposes only and does not represent the views and opinions of Avantax Wealth Management® or its subsidiaries. Avantax Wealth Management® is not responsible for and does not control, adopt, or endorse any content contained on any third party website.
This information is not intended as tax or legal advice. Please consult legal or tax professionals for specific information regarding your individual situation.
The information being provided is strictly as a courtesy. When you link to any of the web sites provided here, you are leaving this web site. We make no representation as to the completeness or accuracy of information provided at these web sites. Nor is the company liable for any direct or indirect technical or system issues or any consequences.
For Important Information and Form CRS please visit https://www.avantax.com/disclosures.

FAQs Frequently Asked Questions
Type your message here.
Please fill out the form and our team will get back to you shortly The form was sent successfully