Quicken 2017 (deluxe, premier, home and business) imports the following formats:
“regular” QIF for cash accounts
“correct” QIF for all accounts including checking, savings and credit card. Quicken tells it is not possible, but it does import anyway as long as QIF if prepared correctly. Use CSV2QIF or Bank2QIF to create “correct” QIF files
QFX (Web connect), extended OFX format with Quicken attributes to import under all accounts. If your QFX file is not importing under specific account, edit that account, click “Online services” and delete online services link there before importing. Use OFX2QFX to convert your OFX files to QFX format
QXF – new Quicken format used to move data between Quicken applications. I may be wrong, but last time I checked banks do not offer QXF downloads or third party software creates QXF files.
To import QIF into Quicken (to import a QIF file into Quicken 2005-2014, 2017), you need to create a correct QIF file and follow the instructions below.
QIF and QFX format
Quicken imports QIF and QFX (Web Connect) files with transactions. Once Quicken becomes three years old, it stops import QFX (Web Connect) files. Investing in a converter that creates QIF files from your CSV or OFX or QFX or QBO files is a good idea because you keep using your Quicken version until you see features worthy upgrade to new Quicken version.
There is also QXF files that you do not want. Unlike QFX (Web Connect) and QIF files, QXF replace whole data file and can create only from another Quicken that is the same year and the same platform (PC/Mac) as you have. QIF and QFX (web connect) files add transactions to your Quicken file, not replace them.
Yes, Quicken says QIF files are not supported, but yes, QIF files correctly prepared are importable directly into bank or credit account in Quicken. Import QIF into Quicken gives you ability to supply transactions, as QFX (Web Connect) format does not provide them.
QIF files should be created either by CSV2QIF (CSV to QIF converter) or Bank2QIF (Bank to QIF Converter) (you can use Bank2QIF to ‘fix’ your QIF as well).
Quicken 2005-2014, 2017? You are fine
Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2017 import QIF files fine for account types. Your QIF file must be correctly created to import directly into an account you need it to imported, and CSV2QIF helps you create such QIF files.
When you convert a CSV file to QIF using CSV2QIF, enter the account name exactly as you have in Quicken and select the account type (Bank for checking and saving accounts, CCard for credit card accounts, Invst for investment accounts).
When you convert a bank file (OFX, QFX, QIF, QBO) to QIF using Bank2QIF (Bank to QIF Converter), load the file and click on the Account Mapping tab and enter the account name as you have in Quicken for each listed account.
Once you saved the QIF file, do the following:
Start Quicken and click File, then File Import, then QIF file.
On the import screen, select from the account drop-down list. Ignore the Quicken message about QIF limitations.
Why? Short answer: Quicken does not import OFX files (even if it says it does).
If you are looking to convert CSV or Excel files to QFX format, use the CSV2QFX converter.
To convert PDF files to QFX format, use the PDF2QFX converter.
Use the QIF2QFX converter, when you need to convert QIF to QFX format.
Quicken does not import OFX, and to convert OFX to QFX, use the OFX2QFX converter.
For multiple formats conversion (QBO, QFX, OFX, QIF or to correct non-importable QFX file) to QFX format, use the Bank2QFX converter.
Quicken imports QFX files (not .OFX) and calls them “Quicken OFX files.” From Quicken point of view, Quicken should import OFX as it calls QFX files “Quicken OFX files.” In reality, Quicken imports QFX files only, and
QFX files are EXTENDED OFX files. It means QFX files follow OFX specification and have ADDITIONAL ATTRIBUTES that Quicken looks for when it imports a QFX or an OFX file.
If you are using Quicken for PC, a great and working alternative is the QIF format. Quicken for PC imports correctly prepared QIF files fine. Quicken 2017 imports QIF files fine, Quicken versions from 2005 to 2014 import QIF files fine.
If you happened to be a Quicken for Mac (2015-2017) user, there is a possibility to import CSV Mint files (files similar to CSV files exported from Mint). CSV2CSV converts your Excel or CSV files to “CSV Mint” files.
What about QXF format?
QXF format adds to this confusion, as it looks very similar to QFX. Even more, your autocorrect may switch QXF to QFX or QFX to QXF as you type, so if you ask a support question, you may get an unexcepted answer. QXF format is not for transaction import, but for data transfer: you will replace your whole dataset in Quicken when you get a QXF file successfully imported.
Backup before any import
Safety first: make sure to backup your Quicken file before any import: QFX, QIF, QXF or even OFX.
If you have an Excel or CSV file with transactions from your bank (checking,l, savings or credit line) account or credit card statement and need to import into Quickbooks 2017, the best would be to convert to a QBO (Web Connect) file.
Use CSV2QBO as your one-stop solution for all your Excel, CSV or TXT files to convert to The QBO format ready to import into Quickbooks 2017.
QBO format provides advantages for a bookkeeper or an accountant in Quickbooks:
Imported QBO files are stored separately under Bank Feeds and Quickbooks provides an interface to review imported transactions, match to vendor records, assign Expense/Income accounts and add to the register.
Unwanted, duplicate or incorrectly converted transactions can be easily ignored under the Bank Feeds as well
When matched to a vendor record, Quickbooks remembers yourbchoice for the next QBO import
Expense/Income account assogned to a Vendor/Customer record is used to prefill account for the matched transaction
CSV2QBO provides abolity to paste table data copied from Excel or other spreadsheet software directly into the application without need to to save the CSV/Excel file.
Quicken 2017 for PC imports QIF files with categories. Quicken 2015 and Quicken 2016 had issues with a direct QIF import, but Quicken 2017 for PC does not have this issue anymore. Quick video below shows the full process using CSV2QIF.
QIF files are a great format to import transactions with categories and tags. CSV2QIF converts CSV and Excel files to QIF format ready to import into Quicken 2017 for PC, as well as Quicken 2016, Quicken 2015, Quicken 2014 and earlier versions. Also, you can create QIF files for Quicken 2007 for Mac, and other personal finance applications like MS Money, You need a Budget (YNAB), NetSuite, etc.
Important details for successful conversion from CSV to QIF and import into Quicken or other accounting software are the following:
Check that expenses are negative and payments to the account are positive. Some credit card companies supply amounts on CSV files in opposite way (expenses are positive, and credit card payments are negative). Use “Change +/-” button on the sidebar to reverse the amount signs for the whole file in a single click
Make sure to select correct QIF target (which accounting or personal finance software are you importing into)
Make sure to select correct account type (BANK vs CCARD vs INVST)
Make sure to enter the account NAME exactly as you have in Quicken for direct import into that account. Quicken reads the account name from the QIF file and locates the account before importing. If the account name is not found, Quicken prompts to create new account
Date format is ignored if QIF target is Quicken – Quicken expects only one date format and CSV2QIF uses expected format
Quicken 2015, 2016 do not import QIF files directly into bank or credit card account. Use proxy cash account to import your transactions and then move transactions to another account.
If you have PDF file from your bank or converted PDF file to CSV file, try PDF2QIF.
To import a PDF file to Quickbooks, use PDF2QBO (PDF to QBO Converter). PDF2QBO reads your PDF bank or credit card statement, finds transactions there, shows them for your review and creates a QBO (web connect) file ready to import into Quickbooks Desktop or Quickbooks online.
Quickbooks desktop has to be not older than three years old to import QBO (web Connect) files. If the current year is 2017, Quickbooks 2015, 2016, 2017 import QBO files. Quickbooks 2014 imports QBO files as well until April 2017 when Quickbooks 2014 stops importing QBO files.
PDF files have to be text-based (you can select text when you open a PDF file in a Pdf viewer or browser. PDF2QBO reads PDF files, find transactions there and converts them to a QBO file.
PDF2QBO cleans the description to be used for payee and keep full description as bank memo.
QBO files are Web connect files and they are imported in Quickbooks under the Bank Feeds Center. Under the Bank Feeds center, once imported, transactions are matched to vendor records and assigned expense/income accounts and then added to the register.
Quicken 2014 for PC may give an error during the update:
C:\ProgramData\Intuit\Quicken\INET\COMMON\Patch\Update\patchw32.dll is either not designed to run on Windows or it contains an error. Try installing the program again using the original installation media or contact your system administrator or the software vendor for support.
if this happens, download the manual update and install it over the existing version from the following page:
Bank2QIF to convert various formats to QIF (OFX, QFX, QBO, and correct incorrect QIF files)
If you have to complete your 2016 taxes before the end of April 2017, use both QIF and QFX format, whichever you find easier. We do suggest to choose QIF over QFX if you decide to keep using Quicken 2014. If you upgrade Quicken to newer version, if you have both QIF and QFX choices, but read below:
Quicken 2015, Quicken 2016 for PC have a bug for QIF import and have to use a workaround with a cash proxy account
Quicken 2017 for PC imports QIF files fine as Quicken 2014 does
Quicken 2015, Quicken 2016, Quicken 2017 for Mac do not import QIF files at all, only QFX files
So if you are planning to complete your taxes and switch to Mac, QFX format is a great choice as well. There CSV2QFX, PDF2QFX, Bank2QFX, QIF2QFX, OFX2QFX converters to help you.
As reported on the Quicken community forum when Quicken 2016 R7 US edition (only this release) a QFX file with USD currency is imported on non-USD account (Quicken allows to choose non-USD account during QFX import), the account currency is changed to USD currency. User cannot change the account currency back, so this is considered an issue that hopefully will be changed in next release.
Quicken users face the issue with importing QFX files on non-USD accounts (again, this is about the US edition of Quicken 2016 R7) that could be resolved by changing the currency of the QFX file from non-USD to USD and import the QFX file successfully. With Release 7, importing QFX files with USD currency on non-USD accounts makes the account currency USD.
It is strongly advised to make backup before importing any file into Quicken.
With release R7, Quicken 2016 US edition users have only one option to import transactions into non-USD account: convert to QIF file, import into a proxy CASH account and then move transactions under non-USD account.
The following converters should help with the conversion to QIF format:
Video is at the bottom of the post. Quicken 2015 changed QIF import process into non-cash accounts. Before Quicken 2015, Quicken 2014 and earlier versions imported “correctly” prepared QIF files even if Quicken “stopped” officially importing QIF files for non-cash accounts since Quicken 2005.
When you import a “correct” QIF file (with the account header part) that imports fine into Quicken 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, you will a message that transactions are imported, but you will not see the transactions when you open the account. There are a trick to see those transactions and get them into the register, but it is much more time consuming than a simple way to convert and import CSV into Quicken 2015 with categories shown below.
(Note: As another option, you can switch from QIF to QFX, but you won’t be able to import categories as QFX format does not support them.)
create IMPORT cash account in Quicken as place to import
move transactions under bank or credit card account
Get the latest CSV2QIF
Make sure you are using the latest version of CSV2QIF. Download it from the CSV2QIF download page.
Start CSV2QIF and load a CSV/Excel/TXT file. Select QIF target as “Quicken 2015”.
Click the Convert button to create a QIF file.
Create IMPORT cash account in Quicken
Many our users use “buffer” or “import” account approach to import transactions:
Import transactions into a “buffer” or “import” account to review imported transactions in isolated place.
Select all transactions and cut and paste them under other “final” account
For Quicken 2015, you must create a CASH IMPORT account, since the cash type is only account type that will import QIF files.
Do it in three easy steps.
Call the account “IMPORT” or something else standing out for as special account for imports.
Enter the account balance (the screenshot below shows just click “next”, but as I’m writing this I realized that BY ENTERING ACCOUNT BALANCE, YOU WILL NOT HAVE EXTRA BALANCE TRANSACTION CREATED that you see below on screenshots).
Now you have IMPORT account created.
Import the QIF file into the IMPORT account
Select File, then Import, then, QIF file under the main menu.
IMPORTANT: Select “IMPORT” account. The MAIN difference from the guide for Quicken 2014 or earlier is to select “All accounts” from the dropdown list. In this case the account NAME is entered in CSV2QIF. For Quicken 2015, you must select the “IMPORT” account, not “All accounts”.
Once the QIF file is imported, go to the IMPORT account register.
Review and move transactions to bank or credit card account
Select the transactions there. You may spend little time to review transactions, amounts, payees, descriptions, categories. If you see the amounts are reversed (deposits and withdrawals), go back to CSV2QIF and click “Change +/-” and create new QIF file. In this case, delete already imported transactions and import new QIF file. The buffer account approach also proves to be effective as you can import several times without messing with your main account register.
Now click the first transaction once, and press Shift key and click the last transaction to select all transactions. Then right click on any select transaction and select “Move Transactions” (not “Cut transactions”, but “Move Transactions”).
The final step is to select an account to move transactions into (your checking or credit card account).
You are done!
Now switch to checking or credit account used above and review imported transactions with the categories there.
How about Quicken 2015 for Mac?
Another painful topic is to how to import a CSV/Excel/TXT file into Quicken 2015 for Mac as the Mac version of Quicken does not support QIF import at all. There is a way as well:
Quicken for Mac 2015 imports “CSV Mint” files that carry the category
Your CSV file layout may not match expected CSV Mint layout, you have Excel or TXT file
use CSV2CSV to make your CSV/Excel/TXT file a “CSV Mint” file
When you import a .QBO file into Quickbooks, you may receive the following message “quickbooks is unable to verify the financial institution information for this download”.
Why would QuickBooks give such message? Possible reasons are below
if your Quickbooks copy is three years old (for example, for current 2015, QuickBooks 2012 or earlier (or Quickbooks enterprise 12 or earlier), it will not import .QBO files. You must either update to the newer version or use Bank2IIF or CSV2IIF converters depending on the file you have and import as IIF file instead of QBO.
Your bank or credit card company is no longer “allowed” by Quickbooks. Use Bank2QBO to make your QBO file from “allowed” financial institution.
Your .QBO file was not created correctly or “not ready” for your Quickbooks version. Banks and credit card companies create .QBO files differently. QBO files are extended OFX files (QBO is also called Quickbooks OFX), but there some small but important differences between QBO and OFX files. QBO file may follow OFX specification, but is not acceptable for QuickBooks. In addition, different Quickbooks versions have slightly different requirements for “good” QBO files.Use Bank2QBO to make your QBO file ready for your Quickbooks version.
Your .QBO file is from US bank, and you are trying to import it on QuickBooks Canadian edition. Or your .QBO file is from Canadian bank and you are trying to import into QuickBooks US edition. Use Bank2QBO to make your .QBO file importable into Quickbooks.
Your .QBO file was created from CSV or Excel file by third-party software. Use CSV2QBO to recreate QBO (Web Connect) file importable by Quickbooks.