CSV converter Options
Output format — QIF or OFX?
The converter produces two output formats. Which one you need depends on your accounting software:
- QIF (Quicken Interchange Format) — an older but very widely supported format. Compatible with Quicken, MS Money, GnuCash, Moneydance, MoneyWorks, KMyMoney, and most desktop accounting applications. QIF is a plain-text format and is human-readable.
- OFX (Open Financial Exchange) — a more modern format based on a structured markup language (similar to XML). Supported by Quicken 2005 and later, MS Money, iBank, and most online accounting tools. OFX carries more detail (such as a running balance and transaction IDs) and is preferred when your software supports it.
If you are unsure, try QIF first — it is accepted by almost every desktop accounting package.
Loose mode vs Strict mode
This setting controls how long field values are allowed to be in the output file:
- Loose (recommended for most users) — the full content of each field is preserved exactly as it appears in your CSV. Description and payee names can be as long as your CSV contains. Use this unless you experience import errors.
- Strict — the payee and category fields are truncated to 32 characters, and the memo field to 249 characters. This matches the limits defined in the original QIF specification from the 1990s. Some older versions of Quicken and MS Money enforce these limits strictly and will reject or garble entries that exceed them. If you are using an older version of Quicken (pre-2010) or MS Money, try Strict mode if imports fail.
This is a Credit Card statement
Tick this box if your CSV is a credit card statement rather than a bank account statement. Credit card statements reverse the sign convention: a purchase of £50 appears as a positive number on a credit card statement (money you owe), whereas in a bank account it would appear as −£50 (money leaving the account).
When this option is ticked, the converter inverts all amounts and sets the output account type to Credit Card (!Type:CCard in QIF, CREDITCARDMSGSRSV1 in OFX). This ensures the transactions import correctly into the credit card account in your accounting software.
Export transactions with Amount = 0
When ticked (the default), rows where the amount is zero are included in the output. Untick this if your CSV contains fee-free or informational rows with no monetary value that you do not want to import.
Delivery method
- Download — the converted file is downloaded directly to your computer when you click the button.
- Email — the converted file is sent to the email address you specify. Useful if you are converting on a mobile device and want to open the file on your desktop.