bank statement → OFX

CSV to QFX Converter: Convert CSV to QFX for Quicken

Turn a CSV of transactions into a Quicken ready QFX file. Map your columns once and download a Web Connect QFX that imports into Quicken with correct dates, signed amounts, and account details.

Free to try, no credit card
256-bit encryption
Imports into Quicken

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|
<OFX> output ready for Quicken, MS Money & accounting software

Convert a CSV file to QFX for Quicken

A CSV to QFX converter reads a spreadsheet of transactions and writes a QFX file, the Quicken Web Connect format, so the data imports straight into Quicken instead of being retyped by hand. Upload a CSV with date, description, and amount columns and download a QFX that Quicken accepts with correct dates, signed amounts, and account details. This is the fix when your bank only offers a CSV download, or you keep transactions in a spreadsheet, but Quicken wants a QFX to import cleanly.

Why Quicken will not import your CSV

Modern Quicken does not import a plain CSV of transactions the way it imports a QFX. If all you have is a spreadsheet, you either retype every line or convert the CSV to QFX first.

Quicken Wants QFX, Not CSV

Quicken imports its Web Connect QFX format cleanly, but a raw CSV from a bank or spreadsheet is not something it reads directly.

Your Bank Only Gives CSV

Some banks export CSV or Excel but no OFX or QFX, leaving Quicken users without an import file.

Manual Entry Is Painful

Retyping months of transactions into Quicken by hand is slow and easy to get wrong across hundreds of lines.

Columns Have to Map Correctly

Date, description, and amount must land in the right QFX fields, or Quicken rejects the file or imports garbage.

Dates and Signs Trip Imports

The wrong date format or an unsigned amount is the usual reason a converted file fails to import into Quicken.

Account Details Are Required

A valid QFX carries account and routing style identifiers that a bare CSV does not include, which the converter fills in.

How the CSV to QFX converter works

Upload the CSV, confirm which columns hold the date, description, and amount, and download a Quicken ready QFX file.

Quicken Web Connect QFX

Writes a proper QFX file, the Web Connect format Quicken imports, not a renamed CSV that Quicken will reject.

Flexible Column Mapping

Point the converter at your date, description, and amount columns in any order, and it builds the file correctly.

Correct Date Handling

Reads common US date formats and writes the OFX date stamps Quicken expects so the import does not choke.

Signed Debits and Credits

Keeps debits negative and credits positive so balances and reconciliation in Quicken come out right.

Account Details Filled In

Adds the account identifiers a valid QFX needs so Quicken treats the import as a real account feed.

Private by Default

256-bit encryption in transit and you can delete your uploaded file at any time.

Convert CSV to QFX in 3 steps

No install, no scripting, no credit card to start.

1

Upload the CSV file

Drop in the CSV of transactions from your bank export or spreadsheet. Excel files work too.

Tip: One row per transaction with date, description, and amount columns.

2

Map your columns

Confirm which columns hold the date, description, and amount so the converter builds the QFX correctly.

Tip: Check the amount sign so debits stay negative.

3

Download and import to Quicken

Download the QFX and open it in Quicken to import the transactions into the right account.

Tip: Verify the imported total against your statement.

Who converts CSV to QFX

Quicken users whose data starts as a spreadsheet or a CSV bank download rather than a QFX.

Quicken Users

Get a CSV bank export or a hand kept spreadsheet into Quicken without retyping every transaction.

Small Business Owners

Import business account activity into Quicken when the bank only offers CSV or Excel downloads.

Bookkeepers

Convert a client spreadsheet into QFX to load a full history into Quicken in one import.

Spreadsheet Keepers

Anyone tracking money in Excel or Google Sheets who wants those transactions inside Quicken.

Common Search Terms

csv to qfx converter csv to qfx convert csv to qfx csv to qfx converter online convert csv to qfx for quicken quicken convert csv to qfx

When your data is CSV but Quicken wants QFX

Quicken imports its Web Connect QFX format without complaint, but it does not read a plain CSV of transactions the way older versions did. If your bank only exports CSV, or you track money in a spreadsheet, converting CSV to QFX is what bridges the gap. The converter reads your rows, maps the date, description, and amount columns to the right QFX fields, and writes a file Quicken treats as a real account feed. If you started from a PDF statement rather than a spreadsheet, the PDF to QFX converter reads the statement directly, and to load transactions into Quicken generally, see convert bank statement to Quicken.

What makes a CSV import into Quicken cleanly

Most failed Quicken imports come down to three things: the date format, the amount sign, and missing account details. A good conversion writes the OFX style date stamps Quicken expects, keeps debits negative and credits positive so reconciliation adds up, and includes the account identifiers a valid QFX carries. The table below shows how spreadsheet columns map into the QFX file.

CSV columnQFX field
Transaction dateDTPOSTED date stamp Quicken reads
Description or payeeNAME and MEMO
Amount, debit or creditTRNAMT, signed correctly
Account (optional)Account identifiers a valid QFX needs

Prefer the older, unbranded format your other software reads? The CSV to OFX converter builds a plain OFX from the same spreadsheet. And if you already have an OFX or QFX and want it back in a spreadsheet, the OFX to CSV converter goes the other direction.

CSV to QFX Converter: Common Questions

Upload the CSV to the converter above, confirm which columns hold the date, description, and amount, and download the QFX. The converter writes a Web Connect QFX with correct date stamps, signed amounts, and account details so it imports straight into Quicken.

Current Quicken imports its Web Connect QFX format rather than a plain CSV of transactions, so a raw spreadsheet has nothing for it to read. Converting the CSV to QFX first gives Quicken a file in the exact format it expects, which is why the import then works.

At a minimum a date, a description or payee, and an amount. One row per transaction, with debits and credits in a single amount column or in separate columns. The converter lets you map whichever columns you have to the right QFX fields.

Yes. The converter keeps debits negative and credits positive when it writes the QFX, so your Quicken register and reconciliation add up. If your CSV uses separate debit and credit columns, map both and the signs are handled for you.

Yes. QFX is the Quicken branded version of OFX. If your software reads plain OFX, use the CSV to OFX converter for an unbranded file. Choose QFX specifically when you are importing into Quicken, which expects the Web Connect variant.

Your upload is protected by 256-bit encryption in transit and you can delete the file at any time. Before sending financial data to any online tool, confirm it encrypts uploads and lets you control deletion, and review its privacy and retention policy.

Related Resources

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Financial Capital One TD Bank Charles Schwab Bank of New York Mellon State Street BMO USA Ally Financial Regions Financial Fifth Third Bank Huntington Bancshares KeyBank Citizens Financial Group First Citizens BancShares Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bancorporation East West Bancorp First National of Nebraska Cullen Frost Bankers BOK Financial Fulton Financial Associated Banc-Corp Valley National Bancorp Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Financial Partners Webster Financial Cadence Bank Old National Bancorp First Interstate BancSystem Umpqua Holdings First Hawaiian Bank Prosperity Bancshares SouthState Corporation First Merchants First Bank Holding Glacier Bancorp First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Bancorporation Pacific Premier Bancorp Bank OZK United Community Banks Customers Bancorp Texas Capital Bancshares SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA