# QIF to QBO: Moving Old Quicken Data into QuickBooks - Author: SimpleBankConvert (https://simplebankconvert.com) - Published: 2026-10-16 - Category: Import file formats - Canonical: https://simplebankconvert.com/blog/qif-to-qbo > QIF to QBO conversion explained: why QuickBooks won't open a QIF file, how to convert it to QBO and which old Quicken categories won't survive the move. QIF to QBO conversion rewrites an old Quicken Interchange Format file as a QBO file, the format QuickBooks reads for bank transactions. A QIF file has no bank ID and ambiguous dates, so a converter adds both. Expect dates, amounts and payees to come across, and old categories and splits to stay behind. ## Why won't QuickBooks open a QIF file? QuickBooks will not open a QIF file because its bank file import takes QBO and a few related formats, and QIF is not one of them. A QIF file is an older format that carries no bank identity and no unique transaction IDs, both of which the QBO route relies on. Many people ask whether QuickBooks used to take QIF files. Whatever older editions did, [Intuit's page on uploading transactions manually to QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) lists QBO, QFX, CSV, TXT and OFX files for a transaction list upload, and QIF is not on that list. If your bank upload screen does not offer QIF, you convert. The gaps between the two formats explain why a straight rename never works. - **No bank ID.** A QBO file names the institution and account type so QuickBooks can link it. A QIF file only says which kind of account the list belongs to, such as bank or credit card. - **No transaction IDs.** A QBO file gives each line a unique ID so QuickBooks can skip lines it has already imported. A QIF file has no such field, so a converter must make the IDs. - **No fixed date format.** A QIF date is text written the way the program that made it wrote it, so the reader has to guess the order. - **A different structure.** QIF is a list of short lines, each starting with a letter. QBO is a set of tags. Renaming the extension leaves the contents unreadable to the new reader. Renaming a .qif file to .qbo does not work, and is a common first try. The file keeps its old contents, and QuickBooks rejects it. [What a QBO file needs inside it](/blog/qbo-files-explained#whats-inside-a-qbo-file) lists the pieces a converter has to add. ## QIF date formats that trip up a conversion QIF dates trip up a conversion because the file does not say whether 03/04/26 means March 4 or April 3, and it may use a two-digit year. A converter has to be told, or has to guess, and a wrong guess puts transactions in the wrong month without any error. The example below shows one QIF record, then the same transaction as a QBO entry. The values are made up. A QIF record: ``` !Type:Bank D03/04/26 T-412.80 PFlour Supply Co MCard purchase ^ ``` The same transaction as a QBO entry: ``` DEBIT20260304-412.8020260304001Flour Supply CoCard purchase ``` Each QIF line starts with a letter that says what it is: D for the date, T for the total amount, P for the payee, M for the memo, and ^ to end the record. The line `!Type:Bank` at the top says what kind of account the records belong to. ### The date ambiguity The D line says 03/04/26. That could be March 4, 2026, or April 3, 2026. Software made in the United States normally writes month first. Software made elsewhere often writes day first. The QBO entry has no such doubt, because DTPOSTED is year, month, day: 20260304. Some QIF files use an apostrophe for years after 1999, such as 3/4'26. Others use four-digit years. Older files may have two-digit years that a converter must place in the right century. ### How to settle the order 1. Find a date with a day above 12 in the file, such as 03/15/26. It can only be month-first, so you know the order. 2. Check the earliest and latest dates against the account's real history. They should fit the period you expect. 3. After conversion, open the QBO in a text editor and read three DTPOSTED values. 4. If you find dates in months that make no sense, set the converter's date order the other way and run it again. A file written across several years can mix styles if it was edited or merged. Sorting the converted data by date and scanning for a jump of a year or more finds most of these. ## Converting QIF to QBO one account at a time A QIF file holds one account's transactions, as a rule, so you convert one account at a time. Some exports bundle several accounts into one file, separated by account headers, and a converter may need that file split before it can produce one QBO file per account. The reason is that a QBO file describes a single account: one bank ID, one account number, one account type. It cannot hold two accounts. If your QIF file has more than one, you need one QBO per account. A practical way to work: 1. Open the QIF file in a text editor and search for lines starting with `!Account` or `!Type`. Each new account or type heading marks a section. 2. If there is more than one section, copy each into its own file, keeping the `!Type` line at the top of each. 3. Note the account type of each: bank, credit card or other. 4. Convert each file, choosing the matching account type in the converter. 5. In QuickBooks, import each QBO into its own matching account. Getting the account type right matters. A credit card file loaded as a checking account can leave the balance looking wrong. A converter that asks for the type, rather than guessing, is safer. ### Importing and checking Import one account first and compare it to the old data. Count the transactions, and compare the total of all amounts to the total in the old program. If they match, import the rest. A mismatch usually points to a date order problem or to a section that was cut off in the split. If your old accounts do not need to be linked to a bank, a spreadsheet route may be easier. Lay the D, T and P lines out as date, amount and payee columns, save the table as a CSV, and run that through a CSV converter. [A CSV to QBO converter and what to test in it](/blog/csv-to-qbo-converter) covers that. ## What happens to QIF categories and splits? Categories and splits mostly do not come across. A QBO file has no field for a category, and bank files carry no splits, so a conversion keeps the date, amount and payee and drops the Quicken category. You assign QuickBooks categories again after the import. A QIF record can carry an L line for the category and S, E and $ lines for the parts of a split. A split is a single transaction divided across several categories, for example one supermarket purchase divided between groceries and office supplies. QBO has no place for these. The converted entry holds one amount for the whole transaction. What you can expect: - **Kept:** the date, the amount, the payee and the memo. - **Dropped:** the category, the class, the split detail and the cleared status. - **Changed:** the transaction ID, which the converter makes up. Quicken's categories also do not map neatly to a QuickBooks chart of accounts. A name such as "Auto:Fuel" in Quicken has no automatic partner in your books. QuickBooks has its own account list, and it learns from your choices as you categorise imported lines. To keep a record of the categories, do not discard the old QIF. Open it as text or in a spreadsheet and keep it as a reference. If you need the category column in a spreadsheet, copy the L lines alongside the payee and amount. A converted file can then be categorised in QuickBooks using that list as a guide. If you also need to bring in older bank history from other sources, [importing older bank transactions into QuickBooks Online](/blog/how-to-import-older-bank-transactions-into-quickbooks-online) covers the wider job, and [opening balances when importing old history](/blog/how-to-import-older-bank-transactions-into-quickbooks-online#opening-balance-problems-with-older-bank-transactions) explains why the start balance needs care. ## Old QIF history you may not need to import Years of old Quicken data are often not worth converting. If your books already start on a clean date, older history adds work and risk of duplicates, with little payoff. A year-end summary or a saved copy of the old file usually serves the purpose. Ask these questions before you convert the lot: - **Do your QuickBooks books already start at a set date?** Lines before that date can clash with the opening balance. Importing them can make the account balance wrong. - **Do you need them for taxes or an audit?** If so, keep the original QIF and a PDF or spreadsheet of the data. You do not need them in QuickBooks to prove anything. - **Are the years complete?** A QIF export with gaps is worse than none at all, because it suggests a full record. - **Is the account still open?** A closed account's history may be worth a spreadsheet, not an import. A middle path is to import only the last year or two, or just the lines since your opening balance date. The oldest data stays in an archive folder where you can still search it. If you do decide to bring in the history, work one account and one month at a time, and compare totals before moving on. SimpleBankConvert, which is in early access, makes QBO and CSV files from PDF statements, not from QIF files, so it may suit the recent statements you do have in PDF form. See [the homepage](/) for what it does today. For Quicken files that came from a bank download rather than an export, the file is probably QFX. Those need a different, smaller fix, described in [getting a QFX file into QuickBooks](/blog/qfx-to-qbo-converter). The reverse direction is covered in [making a QFX from a CSV](/blog/csv-to-qfx-converter).