Quicken wrote the QIF; QuickBooks will not read it. Drop the file here and it comes back as the .qbo, .qfx or .ofx an accounting program imports without a word about columns. Free, no row limit, and the file never leaves this computer.
| Date | Description | Amount |
|---|
QIF is Quicken's own format from the 1980s, and Intuit retired it for bank data when OFX arrived: QuickBooks Desktop imports .qbo, QuickBooks Online takes .qbo, .qfx, .ofx or .csv, and neither offers QIF for a bank account any more. The file is not broken and the transactions in it are perfectly good — it is the envelope that is out of date. Rewriting the same rows into OFX is all that is needed, and that is what this page does.
A QIF record states its date as three numbers and nothing else: no header row, no
format declaration, no convention the writers agreed on. 03/04/2026 is
3 April from a European Quicken and 4 March from an American one, and the file itself
is silent. Where one date in the file is over the twelfth, the question answers itself
and the whole file follows. Where no date is — a short January statement will do it —
this page says so above the table instead of picking for you, and the control changes
every row at once so you can see which reading is right.
Quicken's other flourish is the apostrophe: D01/15'26 means 2026. Both
that and the padding spaces some writers emit are read here.
Date, amount, payee, memo, category and cheque number all survive the trip; the payee, memo and category become the one description column a bank file has, in that order. The cleared flag is kept. Splits are not expanded into separate rows — a split transaction stays one transaction for the same amount, because turning one payment of £100 into two rows of £60 and £40 would double the money as far as a bank import is concerned. An investment QIF is refused outright rather than read as a bank file: it records quantities and prices, not a signed amount per line, and pretending otherwise would be fiction.
Something else? Write to support@ocrsnip.com.
Yes, with no row limit and no account. This page reshapes a file you already have, and the free converters on this site all do that — the paid tools are the ones that read a document and check it, like a PDF statement or an MT940.
Nine times in ten it is the bank id: QuickBooks Desktop matches INTU.BID against its own list before it reads a single transaction, and the number has to be the one for your bank. What is inside a .qbo file explains where it sits. QuickBooks Online is far more forgiving and also takes .qfx and plain .ofx.
Then the file was written day-first and read month-first, or the reverse. Change the control above the table and every row re-reads on the spot — no need to drop the file again. If the page warned you that the dates were ambiguous, this is exactly the case it was warning about.
The .csv button hands back the same rows as columns. For the opposite direction — a .qbo you want as a sheet — QBO to Excel and QBO to CSV are free too.
No. The reader and the writer are both code running in this tab; there is no upload step and no server that receives files. Watch the network panel of your developer tools while you convert: nothing carrying your data leaves.
ocrsnip