tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/17962-cant-download-usaa-transactionsInfinite Kind: Discussion 2023-07-12T01:37:54Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T13:56:51Z2021-02-18T13:56:53ZCan't download USAA transactions<div><p>I sent a written complaint. I do agree that the more people complain the better chance of USAA fixing this sooner.</p></div>mchristensontag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T16:15:47Z2021-02-18T16:15:49ZCan't download USAA transactions<div><p>I feel the need to repost this again.....</p>
<p>For everyone saying this is NOT a Moneydance issue but a USAA issue, you are dead wrong. Be mad, thats fine but you are.</p>
<ol>
<li>USAA changed the connect, fine its done.<br></li>
<li>They are not bringing the old way back no matter how much people complain. Our complaints are insignificant to their business bottom line and even if 1/10th of al the customers left, they would stay in business so leaving USAA over this is just asinine.<br></li>
<li>This is now an IK issue. Its proof that they need to fix it because other companies have fixed theirs. As I posted before, GNU cash now works.<br></li>
</ol>
<p>Keep in mind, you are not dealing with a one off guy in a basement writing code. You are dealing with a company that accepts funds for producing an app and service connection. By creating the app and offering the service the company took responsibility to maintain these connections etc.</p>
<p>They either need to fix it, or publicly announce they will not support USAA one or the other. As a company that you have PAID money to for the software pressure should be placed on them to produce.</p>
<p>Put it this way.....</p>
<p>Your grocery store 1 mile away no longer has bananas because the way the banana distributor does business changed. The grocery store 15 miles away was able to figure it out and get bananas.</p>
<p>Now do you go yell at the banana man for changing his ways ands tell him you are never buying his bananas ever again or the store for not figuring out how to get bananas?</p></div>TJtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T18:23:47Z2021-02-18T18:24:37ZCan't download USAA transactions<div><p>@TJ - So... why can't USAA simply make an OFX export file an option??? If you pay attention to your USAA website, you will also see they heavily promote TurboTax too. Sure looks suspicious to me!</p>
<p>And, unfortunately, you are correct about leaving USAA, however, it is a very strong option, but a total PITA for all the bill pay data I have there... :(</p></div>mgphl52tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T19:11:21Z2021-02-18T19:11:21ZCan't download USAA transactions<div><p>I am also a long-time USAA customer and switched to Moneydance years ago after Quicken dropped meaningful support for the Mac. This is really frustrating and I hope we see a resolution soon.</p>
<p>I did find this link - <a href="https://df3cx-services.1fsapi.com/casm/usaa/enroll">https://df3cx-services.1fsapi.com/casm/usaa/enroll</a> - in the Quicken community forums. This is the page Quicken users are sent to to get a dedicated ID and pin for the USAA Direct Connect access. Interestingly the ID and pin that are generated for me do seem to work in Moneydance, but just the same as our current login/pin, meaning it seems to connect successfully but no transactions are ever downloaded.</p>
<p>Since others have reported that 3rd-party software other than Quicken is working again it seems Moneydance may need to adapt to changes USAA has made. Or maybe those other programs are impersonating Quicken so that USAA doesn't block them?</p>
<p>BTW, the Quicken community forums seem to also be awash in complaints and issues with connecting to USAA for the past couple months as well. I am looking forward to Infinite Kind figuring this out because I know the support and performance will outclass Quicken once again when it's figured out.</p>
<p>Last thought, has anyone switched Checking over to Schwab from USAA (in addition to the investments)? How does Schwab work with Moneydance?</p></div>joetag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T19:22:20Z2021-02-18T19:22:20ZCan't download USAA transactions<div><p>All of the Quicken folks are also talking about needing to change to a "USAA - new" connection, as if the Direct Connect server information has changed. Have the USAA connections in Moneydance been updated since January? I see "- New" connections listed for other institutions but not USAA.</p>
<p>Does anyone know the current OFX server details for USAA so that we can try adding manually through the Moneydance:Online Banking Signup:New Connection:Advanced Setup option then use the USAA Direct Connect ID/pin provided at <a href="https://df3cx-services.1fsapi.com/casm/usaa/enroll">https://df3cx-services.1fsapi.com/casm/usaa/enroll</a> ?</p></div>joetag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T19:36:46Z2021-02-18T19:36:46ZCan't download USAA transactions<div><p>FYI, here's Moneywell's statement on the matter - <a href="https://help.moneywell.app/article/73-usaa-direct-connect">https://help.moneywell.app/article/73-usaa-direct-connect</a></p>
<p>Wish we could get something like this from Infinite Kind.</p></div>joetag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T21:09:20Z2021-02-18T21:09:20ZCan't download USAA transactions<div><p>@Joe,</p>
<p>Re: Advanced Setup option</p>
<p>Just setting those values won't be sufficient.<br>
There are values more than just those 4 that need to be configured/override. In particular a clientUid needed to be set.</p>
<p>See also:</p>
<ul>
<li><a href="https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/USAA_Background_Notes">https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/USAA_Backg...</a></li>
<li><a href="https://infinitekind.tenderapp.com/discussions/online-banking/18262-usaa-using-hleofxquotes-to-download-ofx">https://infinitekind.tenderapp.com/discussions/online-banking/18262...</a></li>
</ul></div>hleofxquotestag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-18T21:44:15Z2021-02-18T21:44:15ZCan't download USAA transactions<div><p>@joe: re Wish we could get something like this from Infinite Kind.</p>
<p>I have been disappointed in the lack of communication as well, and I've been a tiny bit more aware of work behind the scenes than some.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-19T03:52:20Z2021-02-19T03:52:22ZCan't download USAA transactions<div><p>Updating to a more secure/modern connection is a GOOD thing for all of us. The lack of notice sucks. That said... it's time for IK to get out in front of this since it appears that there's a path forward.</p></div>andrewtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-19T19:54:42Z2021-02-19T19:54:42ZCan't download USAA transactions<div><p>btw, in the main discussion for the Schwab issue (link below), Sean posted something just five days after the discussion was started, thanking everyone for their investigations and giving a progress update. Within 2 weeks he had posted 8 more times with info and updates. It's been more than three weeks on this issue and not a single post from Sean. Hmmmm.</p>
<p><a href="https://infinitekind.tenderapp.com/discussions/problems/63978-moneydance-stopped-downloading-transactions-from-charles-schwab/page/1">https://infinitekind.tenderapp.com/discussions/problems/63978-money...</a></p></div>ppinoccitag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-19T22:44:50Z2021-02-19T22:44:50ZCan't download USAA transactions<div><p>Hey all, I just tried Mint from Intuit and it linked with USAA no issues. Now, I am not sure I like Mint but it works. It is free but has ads, not ideal. Would love to see IK get this fixed</p>
<p>Bill</p></div>billtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-20T17:51:34Z2021-02-20T17:51:35ZCan't download USAA transactions<div><p>I just spoke with a web support representative at USAA. She said that USAA has changed their direct connect method, and they have chosen Quicken only for compatibility. Yes, USAA required Quicken to create an access ID and PIN for each user of their software. To connect with Quicken, you have to contact USAA web support for them to walk you through the steps required for direct connect. I asked her if there were steps that Moneydance could take to make their software compatible, and she said NO, there is nothing Moneydance can do. USAA has decided to partner with Quicken, only.<br>
Others who commented that USAA is not what it used to be, are right on target. USAA has chosen to partner with Quicken, and block other software from directly downloading account transactions.<br>
Not going to drop USAA over it. Just have to muddle through exporting CSV and importing it into Moneydance from now on. NOT going back to Quicken.<br>
Hope this helps to answer some of y'alls questions.</p></div>jimtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-20T18:07:00Z2021-02-20T18:07:00ZCan't download USAA transactions<div><p>@jim - Thank you for the update. I was afraid this was the case but I do not understand why Moneydance cannot access our USAA data using our unique access id & pin. Several pages back there was info for testing connectivity and I was able to retrieve status data of all of my accounts. Since I do not know all of the ins & outs of OFX protocol, I did not get transaction, but I did prove I could connect without Quicken!</p></div>mgphl52tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-20T18:12:21Z2021-02-20T18:12:24ZCan't download USAA transactions<div><p>Sigh . . . while I'm on board with removing outdated protocols and modernizing, USAA's new refusal to support non-Quicken products really sucks. I dropped Quicken years ago because their iOS app is a complete disaster area, and I've been extremely happy with Moneydance - but even if IK does choose to reverse engineer this it'll always be a hack and not officially supported.</p>
<p>I guess it's on to the CSV export to see if I can make that work nicely while I decide how badly I want to stay with USAA.</p></div>Scotttag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-20T19:13:48Z2021-02-20T19:14:52ZCan't download USAA transactions<div><p>To put up with the CSV files, I wrote this basic Perl filter (to run in a windows bash session). This one is for my credit card:<br></p>
<pre>
<code>#!/usr/bin/perl
print "!Type:CCard\n";
while (<>) {
chomp;
next if ( $_ =~ /^$/ );
$_ =~ s/&amp;amp\;/ & /g;
$_ =~ s/(-\d+)$/$1.00/;
$_ =~ s/(-\d+.\d)$/${1}0/;
$_ =~ s/,--(\d)/,$1/;
($clr, $x, $dt, $x, $payee, $memo, $tran) = split /,/;
printf "D%s\nT%s\nC*\nP%s\nM%s\n^\n",
$dt, $tran, $payee, $memo;
}</code>
</pre>
I have a separate file for the checking account with Type:Bank' at the beginning.<br>
I then execute the following in a bash session:<br>
<pre>
<code>./csv2qifcc.pl cc.csv > cc.qif</code>
</pre>
to format the USAA export file into a QIF file, ready for import to Moneydance.</div>mgphl52tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-20T21:06:00Z2021-02-20T21:06:03ZCan't download USAA transactions<div><p>@Jim thats false. If that were the case other apps would not be being able to connect. They are not blocking it they may just be choosing not to cooperate with other developers. But 100% they are not "blocking" it.</p></div>TJtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-20T23:36:00Z2021-02-20T23:36:00ZCan't download USAA transactions<div><p>Don't know a thing about Perl but that script is a lifesaver mgphl52!<br>
For those using it name your download cc.csv<br>
I got an error until I made a blank txt file named cc.qif</p>
<p>Similar process for bank download</p></div>jamdotag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T02:46:21Z2021-02-21T02:46:23ZCan't download USAA transactions<div><p>Just going to note Ethan (IK support) commented on this thread: <a href="https://infinitekind.tenderapp.com/discussions/online-banking/18333-transactions-not-downloading-after-moving-to-a-new-computer">https://infinitekind.tenderapp.com/discussions/online-banking/18333...</a></p>
<p>in case someone didn't see it. Of note, he mentions USAA dropped OFX support, which seems to imply that Moneydance are waiting for USAA to fix the issue. Even though there are several other programs that work great with USAA imports (I'm personally using Personal Capital and someone else mentioned Fidelity worked as well as Quicken and GNUCash). So it's not that USAA dropped third party support, they just dropped this particular channel. Which may have been a security concern for them and Moneydance have to change up their connection mechanism if they want USAA to work for their customers.</p>
<p>IK has said they're "working on it," but I'm concerned working on it is waiting for USAA to reinstate the previous connection, which seems unlikely. It also appeared several other users took it upon themselves to make it work with the new method using Moneydance's extensibility. Personally, I've just been doing things manually, but I might be switching to Personal Capital full time as they've been pretty solid for what I want. There are some significant limitations there that I have grown accustomed to in Moneydance, so I do hope InfiniteKind get this resolved, but I have my doubts it'll be anytime soon.</p></div>doug browntag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T03:31:17Z2021-02-21T03:31:17ZCan't download USAA transactions<div><p>There are many things happening, some in different directions.</p>
<p>CSV import works within moneydance, with the right criteria. (I posted those criteria a while back in this uber long thread and can probably dig it up).</p>
<p>OFX import works with hleofxquotes tool (in another thread). That's what I'm currently using.</p>
<p>Reverse engineering the issue is happening, but MD needs to make some changes to make this work. Sean stated he is working on this directly to me (as I gave permission to use my computer to test).</p>
<p>I, and Stuart (toolbox guy), and someone who has made this work outside moneydance have been working to reverse engineer MD as well.</p>
<p>So, things are definitely happening, day by day.</p>
<p>Just as I was extremely disappointed in USAA for the January 26 fiasco, and still am due to lack of information or willingness to help out their clients ---</p>
<p>I wish MD would post weekly updates. So, I guess I'm writing a "just a user" update instead. (Not my job! :) :) :) )</p>
<p>Things are happening. You can download and import CSV at this time, or use hleofxquotes tool to create and import OFX - both work. So, you don't have to sit and wait if you are a bit technically savvy. But no it isn't dirt simple yet.</p>
<p>JUST A USER<br>
Hope this helps.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T07:57:21Z2021-02-21T07:57:21ZCan't download USAA transactions<div><p>A quick update... dtd and I (using the technical info provided by hleofxquotes) tonight successfully edited the Moneydance profile setup and then successfully downloaded both Checking and Credit Card Txns from usaa using Moneydance.</p>
<p>I will be passing my 'fixes' onto the IK developer for his information.</p>
<p>I plan to create a script to edit usaa profile, but this will need more testing..</p>
<p>I have no affiliation with MD, so please don't send any negative vibes my way...</p>
<p>So there is hope (I would say)....</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T14:03:23Z2021-02-21T14:03:24ZCan't download USAA transactions<div><p>Keeping my fingers crossed!!! Hopefully IK follows-up and develops the fix.</p></div>Bernard A Bretontag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T15:54:03Z2021-02-21T15:54:03ZCan't download USAA transactions<div><p>If we have any technically savvy people willing to test out the new scripts, head over to:</p>
<p>NO PROMISES!</p>
<p><a href="https://infinitekind.tenderapp.com/discussions/online-banking/18262-usaa-using-hleofxquotes-to-download-ofx#comment_49047605">https://infinitekind.tenderapp.com/discussions/online-banking/18262...</a></p>
<p>Post 29.</p>
<p>testing only please at this stage....</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T16:51:38Z2021-02-21T16:51:40ZCan't download USAA transactions<div><p>I just signed up here to watch this thread and let IK know I'm another long time USAA user who is looking forward to them getting this working. I definitely don't want to go back to Quicken, but online download needs to work or I'll have to find something else. I don't want to have to do that as I really like Moneydance!</p></div>wainscotttag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T18:17:43Z2021-02-21T18:17:43ZCan't download USAA transactions<div><p>I've been very disappointed with USAA; I've come to trust and rely on them as my providers for just about everything they offer. This incident and a couple of other non-software USAA problems I've had make me fear they're slipping.</p>
<p>I'm also getting very fed up with Infinite Kind. They seem to be ignoring this thread. Periodically checking in with us as to what's going on behinds the scenes would be the polite thing to do.</p>
<p>Is Infinite Kind trying to drive customers away, too?</p>
<p>I'd really hate to have to abandon either or both USAA and Infinite Kind, but both are really testing me.</p></div>A Btag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-21T18:24:49Z2021-02-21T18:24:52ZCan't download USAA transactions<div><p>Commented on the other thread but @Stuart, worked like a charm!!!</p></div>TJtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-22T05:49:33Z2021-02-22T05:49:34ZCan't download USAA transactions<div><p>Anyone having a problem with CSV export on USAA only giving the first transaction, no matter if you choose selected transactions or all the displayed ones?</p>
<p>The CSV file is literally one line long, the first transaction selected, no matter what. What gives?</p></div>Wtag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-22T07:23:40Z2021-02-22T07:23:40ZCan't download USAA transactions<div><p>An update, a couple of people have tested the profile update scripts and successfully downloaded from USAA within Moneydance: To monitor the discussions, visit here: <a href="https://infinitekind.tenderapp.com/discussions/online-banking/18262-usaa-using-hleofxquotes-to-download-ofx#comment_49047605">https://infinitekind.tenderapp.com/discussions/online-banking/18262...</a>.</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-22T18:53:09Z2021-02-22T18:53:10ZCan't download USAA transactions<div><p>Since it seems some industrious users have found a good work around, I'm assuming IK will have a fixed version out, hopefully very soon.</p>
<p>How will we know? Will there be an announcement here, or an update on their website, or ???</p>
<p>I've been using Moneydance 2017 since I got it, and have had no need to update. I'll gladly pay for a newer version as soon as this issue is fixed, and as soon as possible then so I can balance my accounts. How will I know when the fixed version is available?</p></div>wainscotttag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-22T19:26:52Z2021-02-22T19:26:52ZCan't download USAA transactions<div><p>@W - I do not have that problem with CSV files, but I select the transaction by date-range. Yes, each transaction is a single line but it exports all transactions within the selected date range.</p></div>mgphl52tag:infinitekind.tenderapp.com,2009-01-14:Comment/489989742021-02-22T21:35:04Z2021-02-22T21:35:06ZCan't download USAA transactions<div><p>I have MD Version 2021 (2006), the latest version according to their website. I just got off the phone with USAA about not being able to download. The guy was basically clueless when I told him the problems I was having. He put me on hold for several minutes, came back on and said he was "opening a ticket". #INC5533955. There was nothing else he could do. Requested they email me when the issue is solved. I'm NOT holding my breath. USAA has essentially screwed over all account holders that do not use Quicken. To say I am severely disappointed in USAA is putting it mildly!</p></div>Paula Smith