bank statement → OFX

Bank Statement to OFX Converter: What to Use Instead of QIF for Quicken, GnuCash and Moneydance

Turn a PDF or scanned bank statement into a clean OFX file that imports into GnuCash, Moneydance, and modern finance software. The tool extracts date, description, and amount and writes a spec-correct OFX file.

Free to try, no credit card
256-bit encryption
Exports OFX and CSV

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|
<OFX> for MS Money & accounting software, <CSV> for spreadsheets

Convert a bank statement to OFX (and what to do about QIF)

This converter reads the transactions in your PDF statement and writes a clean OFX file that GnuCash, Moneydance and modern finance programs import directly. Upload the statement, let the tool extract each date, description, and amount, then download the OFX. QIF is the older, plain text Quicken format some legacy setups still require; this page explains when you actually need it and where it fits, since this converter produces OFX and CSV rather than QIF.

Why QIF still trips people up

QIF is older than OFX, some setups still require it, and hand building one from a statement is fiddly and error prone.

Quicken Limits QIF To Some Accounts

Quicken documents QIF import for asset, liability and cash accounts, and states it is not available for checking, savings or credit card accounts, which need a QFX (Web Connect) file instead.

GnuCash and Legacy Tools

GnuCash and several older or niche finance programs still accept QIF imports, but most of them read OFX directly too, so QIF is rarely the only option.

No QIF Download From the Bank

Banks almost never offer QIF anymore, so if your software specifically needs one you have to build it yourself or find a tool that supports that output.

Hand Building QIF Is Fiddly

QIF uses a specific line by line syntax with date, amount, and payee codes. One malformed line and the whole import fails.

Date Format Ambiguity

QIF date handling varies between programs, so the wrong format quietly imports transactions on the wrong day.

No Duplicate Protection

QIF has no transaction IDs, so re importing can double up entries. OFX solves this with a unique FITID on every transaction.

How the bank statement to OFX converter works

Upload a statement and get a spec-correct OFX file with dates, amounts, and payees coded correctly, ready for GnuCash, Moneydance, MS Money and most accounting software.

Spec-Correct OFX

Writes valid OFX with date, amount, payee, and memo fields so the import does not fail on a malformed entry.

From PDF or a Scan

Reads the PDF your bank issues, including image only and scanned statements, and writes the transactions straight into a clean OFX file.

Correct Date Codes

Formats dates the way OFX importers expect so transactions land on the right day.

Signed Amounts

Debits and credits are coded correctly so your balance stays accurate after import.

CSV Too

Export the same statement as a plain CSV in one click for a quick review or a spreadsheet.

Private by Default

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

Convert a bank statement to OFX in 3 steps

No install, no bank download, no credit card to start.

1

Upload the statement

Drop in the PDF or scanned statement from your bank or card.

Tip: Multi page and multi month statements are fine.

2

Convert to OFX

The tool extracts every transaction and writes a valid OFX file automatically.

Tip: Need QIF for a legacy program? See the QIF file format guide below for what the format requires.

3

Import into your software

Download the OFX and import it into GnuCash, Moneydance, or your accounting software, then pick the account.

Tip: Import to a test account first if you are unsure how the program handles the import.

Who needs OFX, and who still needs QIF

Most people converting a bank statement today want OFX. A smaller group is stuck on software that only takes the older QIF format.

Quicken Asset And Cash Accounts

Import into the Quicken asset, liability or cash accounts where QIF is the documented route and QFX is not offered.

GnuCash Users

GnuCash reads OFX directly, so this converter's OFX output works there without needing QIF at all.

Bookkeepers

Convert statements to OFX for most clients; only fall back to hand-built QIF for legacy software that cannot take OFX.

Accountants

Convert statements to OFX for most ledgers, and use the QIF format guide below when a program strictly requires the legacy format.

Common Search Terms

bank statement to ofx converter convert bank statement to ofx qif file format what is a qif file ofx vs qif

When QIF is the right format to use

OFX has largely replaced QIF, but QIF still matters for specific programs. Quicken keeps QIF import for asset, liability and cash accounts while refusing it for checking, savings and credit card accounts, and GnuCash and Moneydance can accept QIF as a fallback import path, though both also read OFX directly. If your software reads OFX, prefer it, since it carries transaction IDs that prevent duplicates. Use QIF only when a program specifically requires it or when it is the only import your tool offers. If you are on modern Quicken, export CSV instead and follow the Quicken import guide.

What the QIF format looks like

QIF is a plain text format with a strict line by line syntax, and a single malformed line can make the whole import fail. Each transaction is a block of coded lines: a date line, an amount line, a payee line, and an optional memo line. The table below explains what each code represents.

QIF fieldWhat it represents
D (date)The transaction date
T (amount)A signed amount, debits negative
P (payee)The transaction description or payee
M (memo)Any extra detail from the statement line

This converter does not generate QIF. If your software accepts OFX, the same statement exports to OFX for MS Money and open tools here, or follow the Quicken import guide. OFX is worth using when available because it protects against duplicate imports the way QIF cannot.

Bank Statement to OFX Converter: Common Questions

Upload the PDF or scanned statement to the converter above and download the OFX. The tool extracts every transaction and writes a spec-correct OFX file, formatting the dates so it imports cleanly into GnuCash, Moneydance, or accounting software.

QIF stands for Quicken Interchange Format, an older plain text format Quicken used before OFX and QFX. It stores each transaction as coded lines for date, amount, payee, and memo. Many legacy programs still import QIF even though banks rarely offer it as a download anymore.

Use OFX when your software accepts it, because it carries transaction IDs that prevent duplicate imports. Use QIF only when a program specifically requires it, such as an older Quicken account type or a legacy GnuCash setup; in that case you will need a QIF built by hand or by a tool that supports it, since this converter produces OFX and CSV.

No. Quicken states that QIF import is not available for checking, savings or credit card accounts, a restriction that dates back to the 2006 version. QIF still imports into asset, liability and cash accounts. For a bank or credit card account, export the statement as CSV instead, since Quicken cannot import OFX either, and use File, then File Import, then Banking Transactions, then From (.CSV) File.

QIF has no built in transaction IDs, so re importing an overlapping period can double up entries. Import each period once, and if you need duplicate protection, use OFX instead, since it includes the unique IDs finance software uses to skip duplicates.

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

Related Resources

Other Bank Statement Converters

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 Citizens Bank Santander Bank Flagstar Bank PNC Credit Card U.S. Bank Credit Card Apple Card

Payment Processor and Marketplace Statement Converters