A unique identifier assigned to each transaction by the bank within OFX/QBO files. QuickBooks uses FITIDs to detect and prevent duplicate transaction imports.
Understanding FITID (Financial Institution Transaction ID)
FITID (Financial Institution Transaction ID) is a unique identifier assigned to each transaction within OFX and QBO files. It serves as the primary mechanism for QuickBooks to detect and prevent duplicate transaction imports — if a transaction with the same FITID already exists in the account, QuickBooks skips it.
FITIDs are typically generated by the bank or financial institution and embedded in the OFX/QBO file they produce. When creating QBO files from non-bank sources (like marketplace reports or CSV files), conversion tools must generate unique, deterministic FITIDs to ensure proper duplicate detection.
A well-designed FITID is both unique (no two transactions should share the same FITID within an account) and deterministic (the same transaction should always generate the same FITID). This combination ensures that re-importing the same file won't create duplicates, while importing different files with overlapping date ranges also avoids duplicates.
Why It Matters for Ecommerce
Duplicate transactions are one of the most common QuickBooks import problems for ecommerce sellers. If FITIDs in your converted QBO files aren't properly unique, you'll get duplicate entries that inflate revenue and expenses. PrimeConnect generates deterministic FITIDs based on transaction date, amount, and description to prevent this.
Practical Example
You import a QBO file for January 1-31 Amazon transactions (FITID pattern: "AMZ20260101001" through "AMZ20260131150"). Later, you import February 1-28. If some January transactions appeared on the February settlement, QuickBooks recognizes them by FITID and skips them automatically. Without proper FITIDs, those transactions would be imported twice.
Related Terms
OFX (Open Financial Exchange)
An open standard XML-based format for exchanging financial data between institutions, software, and services. Supports bank statements, credit card statements, and investment data.
File FormatQBO (QuickBooks Online / Web Connect)
A variant of the OFX format used by QuickBooks to import bank transactions via Web Connect. Despite the name, QBO files work with both QuickBooks Online and QuickBooks Desktop.
File FormatWeb Connect
QuickBooks' method of importing bank transactions from a downloaded file (QBO/OFX format) rather than a direct bank feed. The user downloads a file and then imports it manually into QuickBooks.
Related Tools
Free PrimeConnect tools related to fitid (financial institution transaction id)
Put This Knowledge Into Practice
Now that you understand fitid (financial institution transaction id), use PrimeConnect's free accounting tools to convert your ecommerce data into QuickBooks-ready formats — 100% browser-based.
Browse Free Tools