tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/25541-schwab-transactions-download-via-csvInfinite Kind: Discussion 2023-04-29T00:20:21Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-26T16:49:41Z2023-01-26T16:49:41ZSchwab transactions download via csv??<div><p>Hi davet65,</p>
<p>Unfortunately, CSV files cannot be imported into investment type accounts.</p>
<p>QIF is the bare minimum. There is an Excel add-on called XL2QIF that converts CSV to QIF, but the CSV must be formatted so that it conforms to Moneydance. TBH, it's not for the novice.</p>
<p>There is a CSV to OFX converter in the works by some clever individuals, but it is still in its infancy.</p>
<p>I would say, at this point, your only other option is to manually enter your transactional data from Schwab.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-26T22:04:46Z2023-01-26T22:04:46ZSchwab transactions download via csv??<div><p>Many thanks, Kevin. That is exactly what I feared as I know investment transactions are "harder". So you saved me lots of trouble. Many thanks to you and all the other informal MD support personnel. I would have been long-gone from MD without you.</p></div>davet65tag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-26T23:12:22Z2023-01-26T23:12:22ZSchwab transactions download via csv??<div><p>just a user</p>
<p>Kevin's response is spot on about csv and investment accounts (for almost all finance programs) being incompatible due to no standard existing.</p>
<p>As I work with folks, trying to help, I ask<br>
What is your primary issue with the Schwab/Plaid/Moneydance interface?<br>
I know of several, but I do download my Schwab investment accounts through MD+, and overall, it does work, but I admit that I may have some "workarounds" that I now do without thinking about it (like some journal entries don't appear, and some action items need altering after downloading)... but overall, it works adequately for me.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-27T04:15:15Z2023-01-27T04:15:15ZSchwab transactions download via csv??<div><p>My primary issue with the interface is that I don't want to be a Beta Tester. I just want it to work, and work correctly. And with downloading issues of various types over the decade or so I've been with MD that I have experienced, I just took a wait and see attitude about the third party setup that Plaid created. I saw how long it took MD/Sean to iron some of those earlier download issues out, specifically with Schwab. And the workaround that I created minimized the need for manually recording transactions, but only manually entering the overall account values as an artificial "security" once a week or so. The details of the holdings are only at Schwab, and I'm OK with that. And when I read the post about Quicken having similar issues with Schwab now, I could only say I did the right thing FOR ME.</p>
<p>Thanks for asking, though. A very reasonable question that may help others.</p></div>davet65tag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-27T23:23:39Z2023-01-27T23:23:39ZSchwab transactions download via csv??<div><p>Thanks for the response!</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-28T00:10:55Z2023-01-28T00:10:55ZSchwab transactions download via csv??<div><p>From another perspective.</p>
<p>Outside of the U.S. Direct connect never really existed (some institutions in Canada may have supported it) so the rest never had such an option. With the use of aggregators the data is becoming somewhat more available but not necessarily to the degree people expect.</p>
<p>What I am seeing happening here is that the data that is becoming available is banking type data, i.e. bank and credit card accounts, loans not investment information.</p>
<p>Looking at the available Investment information, for direct shares I see PDF copies of contact notes and PDF files of dividends and the like, nothing of any direct use for data acquisition.</p>
<p>For funds yes CSV files are available but n examination shows something that reads like a bank statement i.e. it has date, description and amount of each item, even if it was available in QIF or OFX format it would still be useless.</p>
<p>There is one major vendor of Personal Financial Management Software customized for this market, so what has he done.</p>
<p>For direct shares nothing, you need specific data off the Dividend statements and no two PDFs are the same, contract notes differ between brokers.</p>
<p>For funds a different approach has been taken and the fund is only maintained at a total level. In the software buy and sells work as normal but additions and removals work as changes in value.</p>
<p>Ok this will not work in Moneydance as it is accounting based, the other software is not and any similarity is purely coincidental :) But in Moneydance changes in value of investment is reflected by changes in the share price.</p>
<p>As institutions move away from providing any useful download data and expect you to use their on line capability for analysis and management (sound like they are trying to lock you in?) I suspect it is going to be come increasingly necessary to just use use tools like Moneydance to monitor total values, Money in and out of the investment using buys/sells and changes in value via share price changes.</p>
<p>There is nothing vendors like Moneydance can do about this, the institutions are becoming increasing unwilling to provide data and governments are often unwilling to force them to.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/577083422023-01-28T00:12:45Z2023-01-28T00:12:45ZSchwab transactions download via csv??<div><p>I should add and where they do provide data it is often in unusable formats, that allow them to say we have provided the data.</p></div>dwg