tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/6006-import-qif-transactions-from-investment-brokers-csv-fileInfinite Kind: Discussion 2021-10-02T01:00:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-06-28T22:53:17Z2021-06-28T22:53:17ZImport QIF Transactions from Investment Brokers CSV file<div><p>I'm a fellow user.</p>
<p>Most CSV files that I have seen investment houses provide are unsuitable for conversion to QIF, the only ones I have found that are close to being good enough are from other financial programs.</p>
<p>That being said Quicken actions should work, provided Moneydance has the same functionality. The QIF import is often used to import QIF files produced by Quicken.</p>
<p>The syntax of QIF files is very straight forward. Intuit have produced some specification documents that can be found on the web, plus there is a wiki article that spells it out pretty well.</p>
<p>Many years ago someone produced an Excel macro that produces QIF files from properly structured CSV files.</p>
<p><a href="http://xl2qif.chez-alice.fr/xl2qif_en.php">http://xl2qif.chez-alice.fr/xl2qif_en.php</a></p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-01T02:37:23Z2021-07-01T02:37:23ZImport QIF Transactions from Investment Brokers CSV file<div><p>You might find this page useful too...</p>
<p><a href="https://en.wikipedia.org/wiki/Quicken_Interchange_Format">https://en.wikipedia.org/wiki/Quicken_Interchange_Format</a></p>
<p>(I've been happily using the xl2qif extension mentioned by dwg for years, but not for investment transactions, sorry, no direct experience there) Cheers,<br>
Tony<br>
(a fellow user)</p></div>tgilbert666tag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-01T03:24:00Z2021-07-01T03:24:00ZImport QIF Transactions from Investment Brokers CSV file<div><p>I've used xl2qif for investment transactions with CSV data from Reckon, I did have to use VBA first to "fix" the data.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-01T12:15:53Z2021-07-01T12:15:53ZImport QIF Transactions from Investment Brokers CSV file<div><p>Just create a new blank account. Delete all categories, accounts, secuties , currencies. Create a dummy investment account and security(s). File export backup this to save a copy. Now, Create dummy txns. Do file export QIF to create example qif format you can copy.</p>
<p>Test the import on the blank account.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-01T12:30:56Z2021-07-01T12:30:56ZImport QIF Transactions from Investment Brokers CSV file<div><p>Also see here:<br>
<a href="https://infinitekind.tenderapp.com/discussions/investments/6008-create-qif-file-for-investments">https://infinitekind.tenderapp.com/discussions/investments/6008-cre...</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-02T16:16:01Z2021-07-02T16:16:01ZImport QIF Transactions from Investment Brokers CSV file<div><p>Thanks to everyone who responded to my discussion.<br>
I got most of the suggestions to work.<br>
The only things that I am having a problem with, is that I can't supply the category for the Div and ReinvDiv.</p></div>smith.seabtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-02T21:06:54Z2021-07-02T21:06:54ZImport QIF Transactions from Investment Brokers CSV file<div><p>In a Dividend type transaction an L line in the transaction should handle a category -</p>
<p>Lcategoryname</p>
<p>If it is a subcategory the entry could look something like:</p>
<p>LInvestments:Dividends</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-02T21:31:04Z2021-07-02T21:31:04ZImport QIF Transactions from Investment Brokers CSV file<div><p>Thanks,</p>
<p>But, the L line didn't work.</p>
<p>The category "Dividend Income" was created and the dollar amount was put<br>
into that category.</p>
<p>Seab</p>
<p>From: dwg [mailto:<a href="mailto:tender+dd1985ba00@tenderapp.com">tender+dd1985ba00@tenderapp.com</a>]<br>
Sent: Friday, July 2, 2021 4:07 PM<br>
To: <a href="mailto:smith.seab@comcast.net">smith.seab@comcast.net</a><br>
Subject: Re: Import QIF Transactions from Investment Brokers CSV file<br>
[Investments #6006]</p></div>smith.seabtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-02T22:07:32Z2021-07-02T22:07:55ZImport QIF Transactions from Investment Brokers CSV file<div><p>The developer told me he fixed that years ago, not impressed!.</p>
<p>I found in Moneydance 2012 that a Dividend type transaction would go to a category called Dividend or perhaps it was Dividend Income no matter what.</p>
<p>In my case it was totally inappropriate or to put it bluntly wrong in Australia dividends must be categorised into Franked or Unfranked - the Australian Tax Office doesn't care what software does or does not do, you do it their way.</p>
<p>The only way I found around it back then was to treat all dividends as MisInc which did allow the L line and for Dividend reinvestment I had to break that into a MiscInc and a Buy, i.e. two transactions.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-03T00:09:03Z2021-07-03T00:09:03ZImport QIF Transactions from Investment Brokers CSV file<div><p>Thank you a lot.</p>
<p>I will play around with your suggestions.</p>
<p>Actually, the CSV from Schwab almost does just as you suggest.</p>
<p>The 2 transactions are ReinvDiv and ReivnShrs.</p>
<p>Thanks Again</p>
<p>Seab</p>
<p>From: dwg [mailto:<a href="mailto:tender+dd1985ba00@tenderapp.com">tender+dd1985ba00@tenderapp.com</a>]<br>
Sent: Friday, July 2, 2021 5:08 PM<br>
To: <a href="mailto:smith.seab@comcast.net">smith.seab@comcast.net</a><br>
Subject: Re: Import QIF Transactions from Investment Brokers CSV file<br>
[Investments #6006]</p></div>smith.seabtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-03T00:51:46Z2021-07-03T00:51:46ZImport QIF Transactions from Investment Brokers CSV file<div><p>If you already have two transactions it makes it a lot easier I would think, one becomes your MiscInc and the other the Buy, in my case I only had one so I had to create the two rather than modifying what was there.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/492666382021-07-03T00:54:35Z2021-07-03T00:54:35ZImport QIF Transactions from Investment Brokers CSV file<div><p>While on the subject a ReinvDiv is really two transactions rolled into one in any case, it is a convenience in the software.</p>
<p>With the way Reinvested dividends often work here. I have since ended up doing them as two transactions in any case.</p></div>dwg