Home Page link  

Exporting accounts from one qdf and importing them into another

  
Groups | Search | About
User Password
Register Now! Lost Password?

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
Exporting accounts from one qdf and importing them into another none 02-21-2008
Posted by none on February 21, 2008, 11:33 am
Please log in for more thread options
 I've started looking into this and it sounds like this might not be as
easy as I'd assumed it would be.

I have a bookkeeper doing some work for me on some financial bills,
and she'll be entering them into Quicken for me using a different
account for each provider. I'd prefer to then import what she's done
into my copy of Quicken that has my other non-medical related expenses
and investments. It's not that I don't trust her, it's just that those
other accounts need some work to be right and I'd rather do those
myself.

Can anyone confirm that this can be done? I've searched, but only
found older posts that I'm not sure are still relevant. I posted to
Quicken.com's online forums and had one response from one of their
Senior Contributors, "this is NOT even close to being a simple
operation, and is one that I would discourage most users from
attempting."

It seems hard to me to believe that something this basic would be hard
to do, but I sure don't want to mess things up either.

Can anyone confirm it's something I shouldn't attempt, or can give me
the steps to do it if it is something I can do?

Posted by P.Schuman on February 21, 2008, 11:50 am
Please log in for more thread options
 none wrote:
> I've started looking into this and it sounds like this might not be as
> easy as I'd assumed it would be.
>
> I have a bookkeeper doing some work for me on some financial bills,
> and she'll be entering them into Quicken for me using a different
> account for each provider. I'd prefer to then import what she's done
> into my copy of Quicken that has my other non-medical related expenses
> and investments. It's not that I don't trust her, it's just that those
> other accounts need some work to be right and I'd rather do those
> myself.
>
> Can anyone confirm that this can be done? I've searched, but only
> found older posts that I'm not sure are still relevant. I posted to
> Quicken.com's online forums and had one response from one of their
> Senior Contributors, "this is NOT even close to being a simple
> operation, and is one that I would discourage most users from
> attempting."
>
> It seems hard to me to believe that something this basic would be hard
> to do, but I sure don't want to mess things up either.
>
> Can anyone confirm it's something I shouldn't attempt, or can give me
> the steps to do it if it is something I can do?

What version of Q are you running ?

In my Quicken 2006 - there is still an Export to QIF menu command
that allows you to specify accounts, dates, types of data, etc
and export to a QIF format.....
--> File --> Export --> QIF file (only selection available) --> export menu

Is this still possible in later versions ?



Posted by John Pollard on March 5, 2008, 10:01 am
Please log in for more thread options
none wrote:
> I've started looking into this and it sounds like this might
> not be as
> easy as I'd assumed it would be.
>
> I have a bookkeeper doing some work for me on some financial
> bills,
> and she'll be entering them into Quicken for me using a
> different
> account for each provider. I'd prefer to then import what
> she's done
> into my copy of Quicken that has my other non-medical related
> expenses
> and investments. It's not that I don't trust her, it's just
> that those
> other accounts need some work to be right and I'd rather do
> those
> myself.
>
> Can anyone confirm that this can be done? I've searched, but
> only
> found older posts that I'm not sure are still relevant. I
> posted to
> Quicken.com's online forums and had one response from one of
> their
> Senior Contributors, "this is NOT even close to being a simple
> operation, and is one that I would discourage most users from
> attempting."
>
> It seems hard to me to believe that something this basic would
> be hard
> to do, but I sure don't want to mess things up either.
>
> Can anyone confirm it's something I shouldn't attempt, or can
> give me
> the steps to do it if it is something I can do?

The advice you got was essentially correct, though there were
probably some assumptions involved that may not apply to you.

The only method available to accomplish your goal (other than a
purely manual effort) is the export/import of QIF files. I see
at least three drawbacks to using QIF files for your purpose.

1.) There is no surgical way to export specific transactions.
The only selections one can make for exporting transactions are:
one specific account or all accounts; and a date range.

2.) When importing QIF files into newer versions of Quicken,
there is no longer an "Accept transactions into register"
window. This means that the "Status" ("New" or "Match") of all
imported transactions is determined by Quicken, and may not be
correct and the transactions will all be accepted without you
having any control of the process. While you can import
non-investment account transactions into a dummy (cash, asset,
or liability) account, investigate them in that dummy account,
and move them from that dummy account to the appropriate
destination account ... you still can not rely on getting a
correct "Status" ... and there is no practical way to handle
"match" transactions.

3.) As indicated in #2, you can not import investment
transactions into anything other than a Quicken investment
account. That requires some extra manual pre-processing of the
QIF file to allow it to be imported into the investment account.
And again, all the transactions will be given whatever Status
Quicken decides and accepted automatically.

If all the transactions you are interested in should have a
"Status" of "New" and are non-investment account transactions;
importing into the dummy Quicken account and moving the
transactions should work.

That still leaves the problem of how to get only the desired
transactions "exported" to the QIF file.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Similar ThreadsPosted
Exporting as a TXT file? February 27, 2007, 11:47 am
Trouble exporting as QIF? March 20, 2007, 7:15 pm
Difficulties exporting to Excel January 19, 2007, 1:52 pm
exporting Securities list to Excel March 4, 2007, 11:25 pm
Exporting New Purchases From Quicken to Home Inventory September 5, 2006, 12:18 pm
Exporting data to EXCEl compatible format June 15, 2008, 6:18 pm
Exporting the Proceeds of ESPP Transactions from Quicken to TurboTax April 5, 2008, 7:29 pm
Importing Turbotax October 19, 2006, 2:48 am
Importing prices December 29, 2006, 6:23 pm
Importing old data January 22, 2007, 3:40 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