Home Page link  

Import investment acct QIF to Q 2007 successful

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Import investment acct QIF to Q 2007 successful klunk 10-09-2006
Posted by klunk on October 9, 2006, 2:19 pm
Please log in for more thread options
I'm not sure if this has been posted, but I have just confirmed
that using the workaround posted earlier (see below) does
indeed work with Q 2007. I successfully imported a QIF
produced by John Hancock into a 401k account.

=== quote from previous John Pollard post (thanks!!) ===

How to Import QIF Files to Non-cash Accounts, post Q2004:

The following assumes you have downloaded a qif file for a single account
from a financial institution, or have a qif file exported from a single
account in a Quicken data fileset.

Open the qif file in Notepad and add the following four lines at the very
beginning of the file:

!Account
NMyAccount
Txxxx
^

substituting the *exact* Quicken name of the account you want to import to
for "MyAccount", and substituting from the following list for "xxxx"

1.) "Bank" for checking or savings accounts
2.) "CCard" for credit card accounts
3.) "Invst" for investment accounts

"Save" the qif file.


Then in Quicken:

File > Import > QIF file

Enter (or browse to) the name of your qif file in the "Location of QIF file"
box.

Select the name of *any* "cash", "asset", or "liability" account in the
"Quicken account to import to" box. (If you have no such account types,
create one).

Click Next.

You should get a message saying "Transactions found for MyAccount. Import
transactions into MyAccount?". Click Yes.


For investment accounts, you may not get the option to review the
transactions or to match them to existing register transactions. They may
all be imported as "New" transactions. This can be important if you manually
enter transactions in those accounts before downloading the real-world
transactions.



Similar ThreadsPosted
Another successful Update December 10, 2007, 4:56 am
How to change Cash Amount and Cash Balance in Q2008 Investment Acct? January 1, 2008, 9:34 pm
How to import historical investment transactions October 25, 2006, 2:29 pm
Quicken 2007 - can not use one step update for my Chase acct September 13, 2007, 4:51 am
Cannot import Vanguard download to correct investment account May 15, 2008, 12:19 pm
Moving acct into a new acct - Q2004dlx August 28, 2006, 1:13 pm
QB 2007 Home & Business - will it import QIF? August 16, 2006, 1:14 pm
On import - unidentified securities - Quicken 2007 April 30, 2007, 4:58 pm
Import QIF Files in Quicken 2005, 2006, 2007 January 25, 2007, 6:54 pm
Quicken 2008 can't import TurboTax 2007 data August 31, 2007, 5:22 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap