QIF to CSV Converter

QIF is a plain text format with one genuine trap in it: its dates are ambiguous. 01/02/2024 is the 1st of February in a file written in Britain and the 2nd of January in one written in America, and the file itself usually does not say which. That is dealt with here explicitly rather than quietly.

With the date ambiguity QIF is famous for resolved, and reported.

The date order worked out from the whole file

If any date anywhere has a day above 12, the order is proven and every date is read that way.

And said out loud when it cannot be

When no date in the file settles it, you are told so, told which reading was used and why, and told to check one date before importing. A converter that silently picks is a converter that is silently wrong a month at a time.

Splits not double-counted

A split transaction is one payment across several categories. Its parts are reported without adding the total to itself.

Related guides

• OFX, QFX, QBO and QIF: Which Format Does Your Software Want?
• Why QuickBooks Rejects Your QBO File
• Why Your QIF Import Lands a Month Out
• How to Convert a CSV to QBO for QuickBooks
• Bank Feeds vs Statement Conversion: When You Need Each
• Bank Statement Converter vs Manual Data Entry: A Real Comparison
• Why Your Converted Bank Statement Doesn't Balance
• The Bank Statement Date Format Problem (DD/MM vs MM/DD)