Import errors

QuickBooks duplicate transactions: causes and fixes

Why QuickBooks shows duplicate bank transactions, how to remove them in QuickBooks Online and Desktop, and how to import bank files without overlap.

By Updated Last verified

On this page
  1. Why duplicates happen
  2. Remove duplicates in QuickBooks Online
  3. QuickBooks Desktop for Mac: "Nothing imported"
  4. QuickBooks Desktop for Windows
  5. Prevent duplicates when importing files
  6. How StatementLoom handles IDs and overlap
  7. Sources

Intuit lists four causes of duplicate bank transactions in QuickBooks Online: reconnecting an account, importing a file that overlaps the bank feed, adding a downloaded transaction instead of matching it, and recording the same sale in two ways (Intuit (opens in a new tab)). In QuickBooks Online you remove the extra copies by excluding them (undo first if they were already added), because Intuit's US article says a deleted bank-feed transaction is downloaded again (deleting from the Excluded tab, as in Intuit's global steps below, is a different action); in QuickBooks Desktop you delete them from the bank feed. To stop them recurring, import files that start after the newest transaction already in QuickBooks.

Why duplicates happen

Intuit's QuickBooks Online article gives these causes (Intuit (opens in a new tab)):

  • Reconnecting an account. Disconnecting and reconnecting makes QuickBooks download past transactions again, which creates more duplicates.
  • Overlapping imports. You import a file that overlaps with your bank feed.
  • Adding instead of matching. You add a downloaded transaction instead of matching it.
  • Recording a sale twice. You record the same sale in two different ways.

Check a QBO, QFX or OFX file

See whether a bank file is well formed before you import it: dates, amounts, transaction IDs and the account block. Free, no account, nothing stored.

Open the file checker Convert a PDF statement

Remove duplicates in QuickBooks Online

Intuit's US help explains how added, excluded and deleted transactions behave (Intuit (opens in a new tab)):

  • Exclude. Once a downloaded transaction is added or excluded, QuickBooks stops the bank from downloading it again.
  • Delete. If you delete the transaction instead, QuickBooks downloads it again from the bank.
  • Undo an exclusion. If you exclude the wrong transaction, select the Excluded tab, tick its checkbox and select Undo. It goes back to the For review tab.

Intuit's global help, for regions outside the US, describes removing duplicates that were already posted (Intuit global (opens in a new tab)):

  1. In Bank transactions, select the Posted tab, tick each duplicate and select Undo. This moves them back to the Pending tab.
  2. On the Pending tab, tick the duplicates and select Exclude.
  3. On the Excluded tab, tick them and select Delete.

Only after the last step does the article say the duplicate entries are permanently removed from your QuickBooks bank account records. Duplicates still on the Pending tab skip step 1.

These actions work on the transactions you select.

QuickBooks Desktop for Mac: "Nothing imported"

Every account and transaction in a Web Connect file has a unique identifier (Intuit (opens in a new tab)). When transactions are added or matched to the register, QuickBooks stores their IDs. It will not import a transaction with the same ID more than once.

Transactions with duplicate IDs are ignored, and QuickBooks for Mac shows:

"Error: Nothing imported. Account up to date."

Intuit notes that editing the account ID in the QBO file lets you import a file that was imported before. It also says the purpose of the account ID is to make sure you don't import duplicate entries.

QuickBooks Desktop for Windows

In QuickBooks Desktop, you remove duplicates from the bank feed, and the steps depend on the bank feeds mode you use (Intuit (opens in a new tab)). One step is to select Delete Selected, then Yes to confirm.

Intuit also says deleting the matched statement stops unwanted transactions appearing the next time you download. If you don't delete it, the transactions that weren't matched keep appearing.

You cannot undo an import in QuickBooks Desktop, so back up the company file before importing (Intuit (opens in a new tab)).

Prevent duplicates when importing files

Intuit's advice is to import files that start after the newest transaction already in QuickBooks (Intuit (opens in a new tab)). Before you import, check the newest transaction in the account and pick a file, or a date range, that begins after it. Avoid disconnecting and reconnecting the account.

The transaction IDs matter too. In the OFX specification, the bank assigns each transaction an ID called FITID, and its primary purpose is to let software detect duplicates (OFX specification (opens in a new tab)). A FITID must be unique within an account, and it is not unique across banks. Intuit's help speaks of a unique identifier without naming the tag.

The QBO file validator checks that every FITID in a file is unique and lists any transactions that share one. The QBO viewer shows the file's period, so you can compare it with what is already in QuickBooks. More on the format: QBO file.

How StatementLoom handles IDs and overlap

StatementLoom builds QBO files from text PDF statements (PDF to QBO). Each transaction gets a deterministic FITID: exporting the same statement again gives the same IDs, and two identical rows on one statement still get distinct IDs. StatementLoom also warns when two statements for the same account overlap.

None of this removes duplicates inside QuickBooks. You still choose which file and period to import. The free converter gives Excel or CSV without an account; QBO downloads need a free account.

Sources

Tools for this

Frequently asked questions

Why does QuickBooks show duplicate transactions?

Intuit lists reconnecting an account, importing a file that overlaps the bank feed, adding a downloaded transaction instead of matching it, and recording the same sale two ways.

Should I delete or exclude a duplicate in QuickBooks Online?

Once a downloaded transaction is added or excluded, QuickBooks stops it downloading again. A deleted transaction is downloaded again from the bank.

Why does QuickBooks for Mac say Nothing imported. Account up to date?

QuickBooks for Mac stores the ID of each transaction it adds or matches and ignores transactions with an ID it has already stored.

How do I avoid duplicates when importing a bank file?

Intuit says to import files that start after the newest transaction already in QuickBooks, and that disconnecting and reconnecting the account makes QuickBooks download past transactions again, which creates more duplicates.

Check a QBO, QFX or OFX file

See whether a bank file is well formed before you import it: dates, amounts, transaction IDs and the account block. Free, no account, nothing stored.

Open the file checker Convert a PDF statement