1. Home
  2. Quicken Personal Finance
  3. QIF EXPORT

QIF EXPORT

I have an investment account called STOCKS. The account contains 5 different stocks. Over the years I have recorded purchases, sales, splits, dividend reinvestments, etc.

What I would like to do is make a separate account for each security. I do not think there is a way to EXPORT by STOCK. If there is how can it be done? On the QIF EXPORT Filter I do not see a filter by security.

If there is not, has any body written a program or script (cscript, wsh, powershell, vb, etc) to break the account QIF EXPORT into multiple files that can be imported into the newly established ACCOUNTS?

Thank You, Fred Jacobowitz

Reply to
Fred Jacobowitz
Loading thread data ...

"Fred Jacobowitz" wrote

What version of Quicken?

Why? Normally, I would think you'd be better off with all the securities in one Quicken account. Do you own the five stocks at five different brokerage firms?

You're right, it can't be done.

Possibly; do you have Excel?

If so, try Googling for and downloading the free Excel macro, "xl2qif". That macro will import QIF files into Excel, rearranging the QIF file records into Excel rows, one row per Quicken transaction; and xl2qif will export properly formatted Excel rows to a QIF file.

I imagine you could have xl2qif import your QIF file with the transactions for all 5 stocks, use Excel to sort the imported QIF data into security sequence, then select just the rows for one security and have xl2qif export those rows to a QIF file ... repeating the select/export process for each security.

Reply to
John Pollard

Maybe I'm missing something, but... Isn't this all moot since the OP will not be able to IMPORT the QIF files back into a Quicken brokerage account?

Reply to
klunk

"klunk" wrote

Even if I believed that Intuit had totally disabled qif file imports into newer versions of Quicken ... I don't know what version of Quicken the op is using, so it could be a non-issue.

But, regardless of what version op is using (excluding Q2007, of which I have no knowledge), it is possible to import qif files into versions of Quicken up through Q2006.

So I thought I would wait and see what else op had to say; might turn out there's be no additional response, and I would think to myself that hopefully op did as suggested, imported to Quicken and all was well.

Reply to
John Pollard

The dialog for QIF imports in Q2007 H&B states: "Don't see your account? QIF import is not available for checking, savings, credit card, 401(k) and all other brokerage accounts."

A "Why?" link goes to:

formatting link
Looks to me that brokerage account imports via QIF last worked in Q2004. So if the OP is using that, maybe he can use your solution before he's sunsetted.

I find it strange that Intuit doesn't offer full OFX import/export option for the accounts no longer allowed to import QIF.

Reply to
klunk

Yup; it says the same thing in Q2006, and almost the same in Q2005 (minus the credit card exclusion) ... but it ain't so (in pre-Q2007 versions, at least).

Offering full OFX import would defeat the purpose of excluding QIF import.

And OFX export would be more problematic: OFX has no specs for a category field (making OFX export/import nearly worthless), and no specs for things like Memorized Transactions, specifying asset, liability, or invoice accounts, etc.

There is room for much improvement in this area, but it's not clear to me that there is much room for profit in it.

Reply to
John Pollard

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.