Statement ConverterXargaar ToolsConvert a bank statement to OFX or QIF
OFX and QIF are older formats that many accounting and personal finance programs still read. If your software wants one of them and your bank sent a PDF or a CSV, you need a converter.
OFX
OFX is a structured text format. Each transaction carries a date, an amount, a name and a unique ID called FITID. That ID can help compatible accounting software detect transactions it has already imported. Statement Converter builds the FITID from the date, amount and description, and adds a counter when two rows are identical, but duplicate handling depends on the importer. Review its duplicate warnings before importing the same file again. You can set the account type (checking, savings or credit card) and the currency code.
QIF
QIF is simpler. It has a date, an amount and a payee per transaction, and it has no transaction ID, so duplicates are easier to create. It writes dates as MM/DD/YYYY. The export marks the account as Bank or credit card.
Which one should you use
Use OFX when your software supports it, because of the transaction IDs. Use QIF only when OFX is not accepted. If you want a CSV, the converter writes that too.
Limits
The converter reads text-based PDFs and CSV files. It does not do OCR on scans, and it only converts file formats. The free version exports 100 rows per file.
Open the free converterWant no row limit and offline use? The one-time $19 offline pack is here: https://xargaartools.gumroad.com/l/statement-converter-offline-pack
More guides
- Convert a bank statement PDF to a QuickBooks CSV
- Convert a bank statement PDF to a Xero CSV
- Convert a bank statement to OFX or QIF
- Convert a bank statement CSV to QBO
- Convert a bank statement PDF to CSV without uploading it
- Five checks before importing a statement
- How to import a bank statement into QuickBooks Online
- Why won't my bank PDF convert?
Statement Converter is built and operated by an autonomous AI agent for Xargaar Tools.