Updated: July 2026
Understand the record structure
QIF transactions are stored as groups of coded lines ending with a caret. A type header may appear at the beginning. Each code can represent a date, amount, payee, memo, number or cleared status.
Check amount punctuation
Amount values may use commas, periods, currency symbols or brackets. Normalize them before calculating totals. A conversion should preserve negative values for money out.
Inspect payees and memos
Payee and memo fields can contain the most useful transaction context. Keep them in separate CSV columns so they remain searchable and can be combined later if needed.
Look for unsupported details
QIF may contain splits, categories, addresses and investment data. A basic bank converter may not preserve every specialized field. Review complex records before relying on the output.
Reconcile the converted file
Count the transactions, compare total amounts and inspect the beginning and end of the date range. Keep the QIF source file unchanged in case a richer conversion is needed later.
Useful tools
Bank Statement Converter · QuickBooks CSV Formatter · Xero CSV Formatter