CSV to QFX Converter for QuickBooks & Quicken

Convert bank or credit card .csv and .xlsx spreadsheets into QuickBooks Web Connect (.qfx) or standard .ofx files locally in your browser with our free csv to qfx converter. Auto-map split Debit/Credit columns, set INTU.BID codes, and generate duplicate-safe FITID hashes with zero server uploads.

1. Drop CSV / Excel or Paste Rows

Drag & drop a bank or credit card .csv / .xlsx file here, or paste rows below

0 transactions
100% Client-Side Web Connect Generator · Have a PDF statement instead? Use PDF Bank Statement to CSV first.

How to Convert CSV to QFX for QuickBooks

Generate a valid Intuit Web Connect .qfx bank feed file from any spreadsheet in four steps.

  1. 01

    Load CSV or Excel Statement

    Drag a .csv, .xlsx, or .xls bank export into the dropzone, paste rows from Excel, or test the built-in checking and credit card samples.

  2. 02

    Select Account Type & INTU.BID

    Choose Checking, Savings, or Credit Card (CCSTMTRS), pick an Intuit INTU.BID code, and verify auto-detected Date, Payee, and Amount columns.

  3. 03

    Verify Signs & FITIDs

    Check total Debits and Credits in the preview table (toggle Invert amount signs if your card lists charges as positive numbers).

  4. 04

    Import .QFX Into QuickBooks

    Click Download .QFX (QuickBooks) and import via File -> Utilities -> Import -> Web Connect Files in QuickBooks Desktop or Online.

Why QuickBooks Desktop & Quicken Require a CSV to QFX Converter

While cloud apps accept basic spreadsheets, QuickBooks Desktop (Pro, Premier, Accountant, and Enterprise) and Quicken rely on Intuit's strict Web Connect (.QFX) specification for automated Bank Feeds. Attempting to open a raw bank .csv or Excel export directly inside QuickBooks Bank Feeds triggers format rejection errors, while third-party desktop macros often charge recurring annual licenses or upload confidential client checking ledgers to external servers.

This browser-local csv to qfx converter bridges that gap instantaneously. Drop any bank checking, savings, or corporate credit card .csv (or .xlsx / .xls workbook) into the workbench above to generate a standards-compliant OFX/SGML .QFX file complete with valid <INTU.BID> financial institution routing, normalized YYYYMMDD120000 timestamps, and deterministic <FITID> deduplication hashes—without a single byte leaving your device.

Key Accounting Details Handled Automatically

Building a valid .QFX Web Connect file by hand fails easily because QuickBooks validates header blocks, tag lengths, and account message wrappers strictly:

  • Checking (STMTRS) vs. Credit Card (CCSTMTRS) Message Wrappers: Bank checking and savings imports must be wrapped inside <BANKMSGSRSV1><STMTTRNRS><STMTRS>, whereas credit card feeds require <CREDITCARDMSGSRSV1><CCSTMTTRNRS><CCSTMTRS>. Selecting your account type switches the entire SGML hierarchy automatically.
  • Verified Intuit Bank ID (<INTU.BID>) Selection: QuickBooks Desktop refuses .OFX files that lack a recognized <INTU.BID> tag. Choose Universal Wells Fargo (3000), Chase (10898), Bank of America (5959), Capital One (10941), Citibank (24909), or American Express (3101)—note that INTU.BID simply unlocks the Web Connect parser so you can link the import to any existing QuickBooks chart-of-accounts register.
  • Single Signed Column or Split Debit / Credit Columns: Whether your bank exports a single signed Amount column (-1148.40) or separate Debit and Credit columns, our mapper normalizes outflows as negative DEBIT entries, inflows as positive CREDIT entries, and numbered checks (CHECK 1048) as CHECK entries with <CHECKNUM>.
  • Deterministic <FITID> Duplicate Protection: Every row receives a reproducible date-plus-FNV1a <FITID> identifier derived from its date, amount, and payee. If you accidentally import overlapping date ranges next month, QuickBooks recognizes previously imported <FITID> tags and skips duplicates cleanly.
  • 32-Character <NAME> & 255-Character <MEMO> Compliance: Long ACH settlement descriptions are preserved in <MEMO> while <NAME> is cleanly trimmed to the OFX 32-character limit so vendor matching rules never truncate unexpectedly.

Converting Locked PDF Statements Into QuickBooks QFX

Only have a monthly PDF bank statement or paper credit card scan instead of a CSV? First extract and reconcile the PDF to a 3-column QuickBooks CSV using our PDF Bank Statement to Excel & CSV converter, or digitize paper slips with our Receipt to Excel converter and Image to Excel converter. You can also transform structured bank feeds via the XML to Excel converter and JSON to XLS converter under our strict client-side privacy policy.

CSV Column to QuickBooks QFX Tag Mapping

How spreadsheet columns map into validated OFX 102 / Intuit Web Connect SGML elements.

Spreadsheet InputGenerated QFX / OFX ElementQuickBooks Import Behavior
Date (2026-10-05, 10/05/2026)<DTPOSTED>20261005120000Normalized noon UTC timestamp prevents timezone day-shift
Amount / Split Debit-Credit<TRNTYPE>DEBIT + <TRNAMT>-1148.40Negative outflows & positive inflows matched to Bank Feeds
Payee / Description<NAME> (32 chars) + <MEMO> (255 chars)Clean vendor matching rule name + full ACH reference memo
Check Number (CHECK 1048)<TRNTYPE>CHECK + <CHECKNUM>1048Populates QuickBooks Check # register column automatically
Row Hash (Date + Amt + Desc)<FITID>20261005A8F19C02Blocks duplicate imports across overlapping statement periods

CSV to QFX & QuickBooks Web Connect FAQ

Common questions on Intuit INTU.BID codes, credit card sign inversion, duplicate FITID protection, and local privacy.

Are my bank CSV or Excel files uploaded to a server when using this csv to qfx converter?

Zero files leave your computer. CSV parsing, Excel workbook reading, column mapping, and QFX/OFX SGML generation run 100% locally inside your browser memory.

What is INTU.BID in QuickBooks QFX files, and which code should I pick?

INTU.BID is Intuit's Web Connect institution identifier required by QuickBooks Desktop to accept a .QFX file. Picking 3000 (Wells Fargo Universal) or your bank's code allows QuickBooks to read the file, after which QuickBooks lets you map the transactions into any existing bank or credit card account in your Chart of Accounts.

Why are my credit card charges importing as deposits or payments in QuickBooks?

Some credit card CSV exports list purchases as positive numbers (e.g. 180.00) and payments as negative numbers. In QFX/OFX format, charges must be negative (-180.00) and payments positive (+1850.00). Simply check Invert amount signs and verify Debits vs. Credits in the live preview table before downloading.

How does this converter prevent duplicate transactions when re-importing into QuickBooks?

Yes. Each transaction receives a deterministic FITID hash computed from its date, signed amount, description, and sequence index within that day—preventing duplicate ledger entries if two monthly exports overlap by a few days.

Can I also export standard .OFX files for Xero, Wave, or GnuCash?

Yes! Click Download .OFX (Xero / Quicken) to export clean standard Open Financial Exchange SGML without proprietary Intuit tags for Xero, Wave, FreeAgent, GnuCash, or Microsoft Money.