Go Back  IT Forums > Software > Financial Software
User Name
Password
Reply
 
Thread Tools Search this Thread Display Modes

Import investment acct QIF to Q 2007 successful
  #1
Old 10-09-2006, 10:19 AM
klunk
Junior Member


klunk is offline
klunk's Info
Join Date: Oct 2003
Posts: 157
Default Import investment acct QIF to Q 2007 successful

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.


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Style Design by vBStyles.com


Top Contact Us - IT Forums - Archive - MyLounge Top
MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service