Quicken 2016 is released and its behaviour is the same as Quicken 2015. Quicken 2015 tutorial is applicable for Quicken 2016.
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.)
Three easy steps to Import CSV into Quicken 2015
- use the latest CSV2QIF to create expected QIF
- create IMPORT cash account in Quicken as place to import
- move transactions under bank or credit card account
Get the latest CSV2QIF
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.
ProperSoft offers several PDF converters for bank and credit card statements in PDF format:
PDF2QBO – this PDF file converter converts PDF files to QBO (Web Connect) format ready to import into Quickbooks PC or Mac (up to three years old version), and Quickbooks Online
PDF2QFX -this PDF file converter converts PDF files to QFX (Web Connect) format compatible with Quicken PC or Mac (up to three years old version)
PDF2OFX -this PDF file converter converts PDF files to OFX format ready to import into various personal finance and accounting software such as Quickbooks Online, Sage 50, Sage 300, ACCPAC, YNAB, iBank, Wave Accounting, Less Accounting, AccountEdge and others
PDF2QIF -this PDF file converter converts PDF files to QIF file format for Quicken for Mac 2007, Quicken 2014 or earlier (Quicken 2015 for cash accounts, but you you cut and paste transactions after into other account), and other software support QIF import.
ProperSoft is proud to announce PDF2QFX, a brand new, easy to use program that seamlessly converts your bank and credit card statements into importable Web Connect (.QFX) files. Do you use Quicken or other personal finance software to manage your money? Can you imagine how quickly you much faster transporting your bank and credit card statements into your chosen program would be if the actions were somewhat automated? While we don’t actually transport the files for you, we do the hard part by converting your financial statements to .QFX.
Instead of taking the time to enter data manually, use PDF2QFX to better manage your time. Think of the what you could do with an extra hour….Instead of manually inputting your bank and credit card transactions into Quicken or other software, you could be watching tv, going on a date, or otherwise having fun!
The trusted ProperSoft team invites you to explore PDF2QFX and try our new program for free today!
Updated: check out detailed tutorial how to import CSV into Quicken 2015 with categories.
Quicken 2015 was released for PC and Mac, and there is some changes: good and bad.
Quicken for Mac 2015 now imports CSV from Mint. CSV file has date, amount, CATEGORY(!), and memo.
Bank2CSV was updated and now creates “Minted” CSV files ready to import into Quicken for Mac 2015. Your source file could be QIF, QFX, OFX, QBO.
Quicken 2015 (for pc) no longer imports “correct” QIF files into bank and credit card accounts. The QIF file is actually imported, and even dialog shows up that transactions are imported, but transactions are not seen under the account.
The workaround for this is to import into a Cash account first (call it “IMPORT”) and then cut and paste transactions under correct account.
Quicken for Mac 2015 imports QFX files, but not OFX. Quicken Essentials for Mac was importing both QFX and OFX, but not CSV.
If you have your transactions downloaded or entered in CSV, TSV, TXT, XLS, XLSX (Excel) format, convert them the QIF to import into Quicken 2014.
Quicken 2014 imports QIF files for all account types. There are some messages that QIF format is discontinued and only Cash account can import QIF, but just tried it yesterday with freshly purchased Quicken Deluxe 2014 download and it imported QIF file created by CSV2QIF at http://www.propersoft.net/csv2qif/ just fine.
So to convert CSV (or Excel or Text) file to QIF, use CSV2QIF at http://www.propersoft.net/csv2qif/
QIF to PDF in three clicks
To convert QIF to PDF, use QIF2CSV at http://www.propersoft.net/qif2csv/
In QIF2CSV use print button, and then export to PDF.
Another option is to export to CSV and work on the file in Excel and print to PDF from Excel.
QIF2CSV creates spreadsheet for your QIF transactions. QIF2CSV also understands QIF files exported from Quicken including category list and Memorized transactions.
Quicken 2014 does not provide import for CSV, TXT, XLS, XLSX (Excel) files. How to import Excel into Quicken 2014? you can easily convert Excel files into one of the following formats and then import converted files.
How to import an Excel file into Quicken
- Convert to QIF and import
- Convert to QFX and import
Convert Excel to QIF
Convert Excel to QIF using CSV2QIF. CSV2QIF is capable to create different QIF variants (for Quicken, for MS Money, or for other finance applications), so you need to make sure to select Quicken as the QIF target (Quicken is selected by default when you start the program for the first time).
CSV2QIF supports direct import from Excel (XLS or XLSX) files.
But Quicken 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014 does not allow QIF files to be imported under checking, savings, credit card, broker and investment accounts, right? Not exactly. There is different QIF file variations. QIF created for MS Money, or provided for download by your bank are not accepted by Quicken unless you import them under a cash account.
However, CSV2QIF creates QIF files for Quicken, and Quicken does accept these files. In fact all Quicken versions for Windows (up to Quicken 2012) import QIF files just fine under checking, savings, credit card, broker, and investment accounts.
Where is the catch then? The catch is that you need to enter the account name in CSV2QIF exactly as you have it Quicken, otherwise during QIF import, Quicken will try to create a new account with that name. For example, if your checking account in Quicken is called “Checking” or “Bank checking” or other name, you need to enter this name exactly in CSV2QIF (as well as select correct account type) before saving a QIF file.
What is the advantage of using QIF files? Quicken does not require “online call home” during the import. You do not need to have internet connection active and firewall enabled for Quicken to go through to import a QIF file. This can come quite handy when you work and travel and do not have internet always on, but need to complete your finance report on time.
Another advantage? Creating investment transactions becomes quite easy, when you comfortably working in Excel, then copy and paste them in CSV2QIF and import QIF into Quicken.
So when QIF is not good? For Quicken Essentials for Mac. This Quicken variant does not allow QIF files at all. Please see the next paragraph on how to import your CSV into Quicken including Quicken Essentials for Mac.
Convert Excel to QFX (Web Connect)
Convert Excel to QFX (Web Connect) using CSV2QFX. CSV2QFX creates QFX files acceptable by Quicken. CSV2QFX covers bank (checking and savings, credit line and credit card accounts. During QFX import, Quicken ‘calls home’ using internet connection (so please make sure your firewall allows it to go through), and assigns bank details supplied in QFX file with selected account in Quicken. Even more, if Quicken find the match for bank details in the QFX to details with an account, it imports data there automatically. Otherwise, if offers you the import dialog to select existing “unlinked” account, or create new one.
CSV2QIF supports direct import from Excel (XLS or XLSX) files.
QFX format supplies unique id for each transaction, and Quicken uses it to avoid import for the same transaction next time. However, when you prepare your CSV file, it is common you may notice some transactions mistakes, so you need to fix them and import the file again. Even if you deleted the transaction in Quicken, it still refuses to import it the second time.
To deal with your need to import corrected transactions again, CSV2QFX allows to create unique transaction IDs every time you save the QFX file (this option is turned on by default), as well as keep transaction IDs consistent if you need them to be this way.
Import bank transactions into Excel (or convert to CSV and open either in Excel or other spreadsheet software). Online banking sites (as well online credit card sites or investment brokers) provide “accounting downloads” in QIF, OFX, QFX, QBO formats. To open these files in Excel (or convert to CSV), use the converters listed below. Bank2CSV and QIF2CSV converters support extended QIF format to convert data exported from Quicken as QIF format (for transactions, memorized transactions and categories).
Import bank transactions into Excel (convert to CSV).
- Use Bank2CSV to convert QIF, QBO, OFX, QFX, QBX, OFX, ASO files to CSV format
- Use QIF2CSV to convert QIF files to CSV format
- Use OFX2CSV to convert OFX, ASO files to CSV format
- Use QFX2CSV to convert QFX files to CSV format
- Use QBO2CSV to convert QBO, QBX files to CSV format
Import transactions directly into Excel without saving to CSV file
- Select the converter above, install and start it
- Open your bank statement file
- Click “Copy to clipboard” button and switch to Excel (start Excel or press CTRL+TAB)
- Click Edit then Paste to paste your transactions
Convert bank transactions to a PDF file
- Select the converter above, install and start it
- Open your bank statement file
- Click “Print” button and switch to Excel (start Excel or press CTRL+TAB)
- Click “Export to PDF” (acrobat icon) button