CSV to QIF Converter — For MYOB and older Quicken
Turn a CSV into a QIF. QIF is the oldest format here and the most widely accepted — MYOB takes it, Quicken's older versions take it, and a great deal of software that takes nothing else will read one.
Not the file you need?
- Have an Excel workbook rather than a CSV: Excel to QIF Converter
- Quicken by Web Connect: CSV to QFX Converter
- QuickBooks Desktop: CSV to IIF Converter
The format MYOB, older Quicken and a long tail of accounting software still take.
Accepted almost everywhere
When a package documents no import format at all, QIF is usually the one it turns out to read.
The running balance in the memo
Where your CSV has a balance column, each entry's memo carries that balance, so you can reconcile against it after the import.
No invented categories
Some converters guess a category from the payee. This does not: a guessed category is a wrong entry in your books that looks deliberate.
What the QIF file contains
Field by field, where each part of the download comes from.
| In your CSV | In the QIF | How |
|---|---|---|
| Date | D line | Written MM/DD/YYYY, month first, whatever order your CSV used. |
| Debit, Credit | T line | One signed amount, money out negative. |
| Transaction Details | P line | The payee: the description, up to 96 characters. |
| Balance | M line | "Balance 4100.00", so each entry carries the balance to reconcile against. |
| Not in a CSV | !Type:Bank | The first line, marking the file as a bank account. |
| Not in a CSV | No L line | No category is written, because none is in your file. |
Sample output
Made by this converter's own code from the made-up file shown. The output is the file it writes, not retyped.
The input: CSV
A made-up CSV in the shape an Australian bank exports: dates day first, Debit and Credit in separate columns.
Date,Transaction Details,Debit,Credit,Balance
02/03/2026,EXAMPLE PTY LTD SALARY,,3200.00,4100.00
05/03/2026,SAMPLE BAKERY NEWTOWN,12.60,,4087.40
16/03/2026,MADE-UP COUNCIL RATES Q3,480.00,,3607.40
23/03/2026,INTEREST PAID,,1.84,3609.24The output: QIF
The whole file.
!Type:Bank
D03/02/2026
T3200.00
PEXAMPLE PTY LTD SALARY
MBalance 4100.00
^
D03/05/2026
T-12.60
PSAMPLE BAKERY NEWTOWN
MBalance 4087.40
^
D03/16/2026
T-480.00
PMADE-UP COUNCIL RATES Q3
MBalance 3607.40
^
D03/23/2026
T1.84
PINTEREST PAID
MBalance 3609.24
^Questions about converting CSV to QIF
Which date format should I choose when importing a QIF?
Month first, MM/DD/YYYY. Every date in this file is written that way. QIF has no field that says which order its dates are in, which is why your software asks - and answering day first would read 03/05/2026 as 3 May instead of 5 March.
Why is there no category on the transactions?
Your CSV does not have one, and a category guessed from a payee name is a wrong entry that looks deliberate. Categorise the transactions in your software after importing, or with its own payee rules.
Does the QIF carry the currency?
No. QIF has no currency field. The transactions take the currency of the account you import them into, so import into an account in the same currency as the CSV.
Have an Excel file?
Use the Excel to QIF converter instead, which reads an .xlsx workbook itself, taking its dates and amounts from the cells. This page reads .csv, .tsv and .txt files, not a workbook.