QuickBooks

“QuickBooks says the bank ID in the file is wrong”

A QBO file carries identifiers naming the institution that produced it, and QuickBooks checks them before reading a single transaction. When they are missing, malformed or unrecognised, the file is refused whole — the transactions inside are never examined.

Symptoms

  • QuickBooks reports an invalid or unrecognised financial institution
  • The file is refused before any transactions are shown
  • A file from the same bank imported successfully last month

What actually causes it

Cause 1

The BANKID or INTU.BID field is empty

The routing identifier and the Intuit branding identifier are both required for a Web Connect import. Some banks emit files with these blank when the export is generated from a secondary system, and QuickBooks then has nothing to validate against.

Cause 2

The identifier changed after a bank merger

When institutions merge, routing numbers are reassigned and the identifier in new exports no longer matches the one your existing account is linked to. The file is valid; it simply no longer belongs to that account as far as QuickBooks is concerned.

Cause 3

The file was renamed rather than converted

Renaming a QFX to QBO does not change what is inside it. The two formats share a structure but carry different identifier fields, and QuickBooks fails on the one it cannot find.

How to fix it

  1. Run the file through the tool below to see whether the identifier fields are present at all before assuming they are wrong.
  2. Let the tool repair structural faults, then retry the import into the existing account rather than a new one.
  3. After a bank merger, deactivate and reconnect the account so QuickBooks records the new identifier.
  4. Never rename between QFX and QBO; download the correct format from the bank instead.

Skip the manual edit — fix it automatically

The tool shows which identifier fields the file actually contains, which separates a missing value from one QuickBooks merely does not recognise. Free, no signup, no upload.

Open the fixer

Your file never leaves your browser.