CSV to QIF converter
Upload the CSV your bank exported and download a .qif file: one block per transaction with the date, the payee and one signed amount. The date, description and amount columns are found by their headers — or by what they contain when there is no header row — so there is nothing to map, and each CSV counts as one page: the first 3 files of your first upload are free.
Upload a file
What the QIF file contains
- A !Type:Bank header, then one block per row of the CSV, in the same order
- D for the date, written MM/DD/YYYY — the order Quicken writes and GnuCash and Moneydance read
- P for the payee: the CSV’s description columns joined into one line
- T for the amount, signed: money out negative, money in positive — Debit and Credit columns become one
- No categories, so nothing lands in a category you did not choose
How CSV columns become QIF lines
QIF is plain text: each line starts with one letter that says what it holds, and ^ closes a transaction. This is where each column of your bank’s CSV goes.
| Your CSV column | QIF line | What happens to it |
|---|---|---|
| Date, Transaction Date, Posting Date, Booking Date | D | Written MM/DD/YYYY. Whether the CSV’s 03/04 is March or April is decided once for the whole file, from the dates that can only be read one way. |
| Amount, or Debit / Credit, Withdrawal / Deposit | T | One signed amount. A decimal comma (3,50) and a currency symbol are read correctly. |
| Description, Payee, Merchant, Details, Memo | P | Several description columns are joined into one payee line. |
| Balance, Running Balance | — | QIF has no balance field, so it is left out. |
| Currency | — | QIF has no currency field either: the transactions take the currency of the account you import into. |
Posting Date,Description,Debit,Credit,Balance
2026-03-02,Direct Debit 4471 Acme Insurance,120.00,,1880.00
2026-03-04,Card Payment Corner Grocer,38.40,,1841.60
2026-03-06,Transfer Received J Smith,,500.00,2341.60What the QIF file looks like
The CSV above as a QIF file. !Type:Bank opens the account; then D is the date, P the payee, T the signed amount, and ^ ends each transaction.
!Type:Bank
D03/02/2026
PDirect Debit 4471 Acme Insurance
T-120.00
^
D03/04/2026
PCard Payment Corner Grocer
T-38.40
^
D03/06/2026
PTransfer Received J Smith
T500.00
^Where the QIF file imports
- GnuCash
- File › Import › Import QIF. GnuCash asks which account the file belongs to, and asks for the date order if a file leaves it open.
- Moneydance, Banktivity, KMyMoney
- Each has a QIF import in its File menu and asks for the target account.
- Quicken for Windows
- File › File Import › QIF File works for cash, asset and liability accounts only — Quicken does not import QIF into checking, savings or credit card accounts. For those, choose Quicken in the format menu instead: see bank statement to Quicken.
How to convert
Export the CSV from your bank
Most banks offer CSV next to the PDF statement, under statements, activity or export.
Upload it here
Drop the .csv in above — QIF is already the selected output. Several CSVs can go in at once.
Import the QIF
Open your finance app’s QIF import, pick the file and the account it belongs to.
Statements it handles
Layouts differ from bank to bank, so nothing is matched against a fixed template. An unusual statement still produces a table you can check before exporting — which is what makes it usable for bookkeepers and accountants who receive statements from every client.
PDF statements and CSV exports
A statement downloaded from your bank, or the CSV your bank lets you export. Both arrive as the same clean table.
Multi-page statements, read as one table
A statement that runs over several pages — or several statements uploaded together — is read as one continuous table, not one file per page.
Amounts and dates kept as your bank prints them
Debit and credit signs, decimal places and date formats are left as printed, so the numbers still reconcile against the statement.
Scanned, image-only PDFs, read with OCR
A statement with no text layer is read with OCR and may need a quick review — the one case where a row can come out wrong.
- CSV
- Scan
Frequently asked questions
How do I convert a CSV file to QIF?
Upload the CSV above, keep QIF as the output and download the .qif file. The columns are detected for you, so there is nothing to map, and no account is needed.
Is there a free CSV to QIF converter?
Each CSV file counts as one page, and the first 3 pages of your first upload are free — three CSV files convert at no cost. After that it is $0.20 a file with a $3.90 minimum per batch, and no subscription.
Can I import the QIF file into Quicken?
Quicken for Windows imports QIF into cash, asset and liability accounts, not into checking, savings or credit card accounts. For a bank or card account, upload the same CSV and choose Quicken in the format menu: Quicken’s own CSV import takes that file. Details on bank statement to Quicken.
Which date format does the QIF use?
MM/DD/YYYY, for example 03/04/2026 for 4 March. It is the order Quicken writes; GnuCash asks you to confirm the order when every date in a file could be read both ways.
Does the QIF keep the balance and the currency?
No — QIF has no field for either. The transactions take the currency of the account you import them into. Convert to OFX if your app should see the currency in the file.
Will my bank’s CSV work?
Column order and header names differ from bank to bank. The columns are found from their headers in several languages, or from their contents when there is no header, and semicolon, tab and pipe separators work too. A file with more than 100,000 rows has to be split first.
Is my file kept after conversion?
No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.