USAA Script to fix the broken download issue
Need to reconnect to USAA? I have written a (run one-time only) script to make USAA download to Moneydance work again. All it does it fix your connection profile. You simply run once, and then use standard Moneydance. It's not needed again.
This is now the IK recommended fix as they are working on 'medium and long-term' improvements to ofx connections
You must be on MD version 2019.4 (build 1904) or newer (if older, you must upgrade, else usaa will never work again).
[@@ UPDATE Oct 2021: This script is now built into the Toolbox extension (MD2021 onwards) under the Online Banking menu and it also works with MD2022 too. Further, we have worked with Moneydance so that once you have ‘primed’ MD with your USAA specific ClientUID number(s), the standard Moneydance Online Setup will work. Further again, there is now an even simpler way to get the connection working (which we haven’t documented: In Toolbox run the USAA ‘Prime’ option and then just use standard MD Online Setup. Lastly, if you need to get multiple UserIDs working, then Toolbox / Online Banking / OFX Authentication / Edit Multiple UserIds. NOTE: if you still just want the script, it’s still available, read on…. @@]
Following these simple, but complete, PDF instructions will make USAA download to your Moneydance file.
My python script creates a new USAA profile in Moneydance to replace the broken USAA profile. It has been used since Feb 23 by more than 100+ users successfully 😃
This script will allow you to download USAA transactions again. It isn't rocket science, really. You don't have to wait for IK/MD to fix the problem, nor will it stop you from embracing the Moneydance fix if/when it happens. I just fix the connection profile.
NOTE: usaa have changed their download data (content, format). If you get some data duplication afterwards, this is NOTHING to do with the script, it's what usaa are now sending. You simply need to do a one-time cleanup, keep the new data, and that's it.
DISCLAIMER: I have no affiliation with Moneydance. It's entirely possible that this won't work for you. Pretty much the worst that can happen is that your bank logon / service profile won't work - but then it's not working anyway.. You can always just delete the profile and start again, if you wish.
PLEASE ALWAYS BACKUP YOUR DATA FIRST!
The first thing to do is read the walk through PDF guide: ofx_create_new_usaa_bank_custom_profile.pdf
The latest PDF guide (now version 8a) is always here:
[https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sour...]
The latest zip file containing the script to fix USAA/Moneydance is at: [https://github.com/yogi1967/MoneydancePythonScripts/raw/master/usef...]
FYI - When you click these links, you may see a blank screen (depending on your browser) and the file(s) will auto download to your downloads folder
You need to unzip this file. The script is called: ofx_create_new_usaa_bank_custom_profile.py
Quick Details:
- Make a backup first.
- Read the instructions.
- Once you run the script, Moneydance takes over with the new profile.
PS - If you get issues ensure a) you are connecting from a USA IP; and that any PiHole, Blockers etc are not getting in the way..
If you have problems, post - We love to solve problems.
CREDITS and thanks: @dtd and @hleofxquotes
I am not support, just a fellow user and creator of the very free and most-excellent Toolbox 🧰 extension for Moneydance.
The latest useful_scripts.zip package and Toolbox are on my site: [https://yogi1967.github.io/MoneydancePythonScripts/]
Showing page 21 out of 22. View the first page
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
601 Posted by jenkins007 on 24 Aug, 2021 03:19 PM
This was working but now I'm getting this error in the screen shot for my 1 checking, 3 savings, and 1 credit card. All were working a few days ago.
UPDATE: USAA must have had server issues this morning. It is working fine tonight. No problems. Apparently early in the mornings (4am–6am and issue appears to be varied), USAA is running some batch jobs that makes this fail. If you attempt to download transactions later in the day, the download will work.
THIS IS NO LONGER AN ISSUE. IT MUST HAVE BEEN A USAA SERVER DOWN ISSUE!!! This post can be deleted.
602 Posted by dtd on 25 Aug, 2021 01:27 AM
@excobrapilot - the script only does one thing - changes the USAA automated file download description.
The rest of your message doesn't relate to running the script. You may wish to post a new thread saying someting like "I get this error on all accounts" - please help.
603 Posted by gs2022 on 29 Sep, 2021 03:25 PM
ofx_create_new_usaa_bank_custom_profile.py is throwing an exception at line 3153:
Exception: LOGIC ERROR: listAccountMDProxies != 2 - Some changes have been made - review log.....
Of course I double/triple checked all the account numbers and ran the script several different times. If I don't add the CC file, the error is listAccountMDProxies != 1. Returning to MoneyDance and trying to download results in no action. It doesn't ask for the PIN or show a "downloading" message or anything.
Reviewing the log in the console window, the only other error I see is "Found account [...] but no service profile exists (thus dead)"
I just upgraded from 2015 to version 2022 (4043).
Any suggestions?
604 Posted by dtd on 29 Sep, 2021 10:05 PM
I'd suggest installing 2021(3069). The script is months old, and some of the 2022 preview changes may have broken it, especially given that a lot of the recent changes have to do with online downloads.
I'm sure @Stuart will be looking this over.
605 Posted by Stuart Beesley ... on 30 Sep, 2021 06:42 AM
.
606 Posted by Stuart Beesley ... on 01 Oct, 2021 06:16 PM
@gs2022. Moneydance builds 4040-4045 have a few issues (bugs that I have pointed out to Sean) with OFX which confuse the situation... 4045 is the best so far, but there are still more fixes pending.. With this in mind, I have spent a lot of time talking to Sean, understanding the 'upgraded' system, and I have enhanced my fix script to 'cope' with MD2022.... It's uploaded to my site.. I would be grateful to anyone (any brave souls) running build 4045 if they would be willing to try my upgraded script (build 15) to confirm that it runs OK, and that the usaa connection works afterwards... Thanks
607 Posted by dtd on 01 Oct, 2021 11:06 PM
Will the new fix script still work with older versions of MD?
608 Posted by Stuart Beesley ... on 02 Oct, 2021 11:09 AM
(PS - I have confirmed that the 'listAccountMDProxies' error mentioned in post 603 above was caused by the bug in the early MD2022 preview builds. This is resolved as of build 4045. If running this script on MD2022, then also please download the latest version of this script: build 15)....
609 Posted by jpbears1 on 02 Oct, 2021 01:11 PM
I have been successfully using Moneydance with USAA for many months now after running this script just a single time earlier this year. If I update to the latest preview build 4045 - will things "just work" or do I need to re-run any scripts?
Question 2 - since this is a USAA discussion - many of us also have Schwab accounts now too - did anyone's Schwab download stop working in Sept 2021? Will updating to preview build 4045 fix that?
610 Posted by dtd on 02 Oct, 2021 06:45 PM
just the writer of the script documentation :) - i.e. just a user
Normally, I could give a definitive answer, but I just moved and am living among boxes right now, so testing isn't my current priority.
Still - here are my "thoughts" based on lots of testing and writing early this year.
I'd say if you upgrade to 4045, USAA should continue to just work, as it is a "working profile" that you created many months ago. The SCRIPT may or may not be CURRENTLY working, Stuart has commented on that.
That said, there are quite a few things that broke and are now being fixed (in 4040, OFX was pretty much broken, period). These are PREVIEW versions, not releases. Unless you NEED the changes, or like testing, I'd stick with 2021(3069) for now, or if you have it 2021(3095) which was before the major changes now being looked at.
I am running 2021(3069) on my "real" database, and run preview versions with test databases. For 2022, I'll have to pay the half price upgrade fee, which is fine with me, but given my move, I haven't done so yet.
As for Schwab, I have a few accounts there, but not with much activity. Still, I did get a couple of dividend income items on Sep 30, so my Schwab download has not stopped working as of that date. Updating to preview 4045 should not change Schwab, unless you want to move to Moneydance+ , which I'd let others work with for the time being, again, unless you like testing software.
Hope that helps.
611 Posted by dtd on 02 Oct, 2021 07:03 PM
@jpbears1 - I see a report that Schwab quit working, but that was in moving to 4045, but with two reports (and one (me) that it is working) I'd keep an eye on it, but wouldn't move to 4045 thinking that would help.
612 Posted by dtd on 02 Oct, 2021 07:05 PM
One thing that might help is to get an errlog.txt or the console window output and post it (in a new thread) along with your version number, since we now have multiple versions being used.
If you post it here, under USAA, it might not get noticed as much.
613 Posted by dtd on 02 Oct, 2021 07:21 PM
I can now verify that I'm getting:
<TITLE>Access Denied</TITLE>
plus other stuff of course
for my Schwab accounts, and this is with 2021(3069).
This is definitely something Sean needs to look into, as all of Schwab is piped through a MD server. Schwab may have turned it off, or something expired, or whatever.
I can also verify that I did get a connection on 9/30...
614 Posted by Boris on 02 Oct, 2021 09:36 PM
Hi,
I get stuck at the very first step :
After typing https://www.usaa.com/accessid
I get:
Access denied
Error 16
df3cx-services.1fsapi.com
2021-10-02 21:24:27 UTC
What happened?
This request was blocked by the security rules
Are there any other alternatives? Thanks!
615 Posted by dtd on 02 Oct, 2021 09:42 PM
Have you logged in to USAA before typing that?
Also, wrong date/time, antivirus, firewalls, vpns can possibly block websites.
616 Posted by dtd on 11 Oct, 2021 10:59 PM
This may be temporary, or it may be permanent.
As of 10/9 it worked. But now when I try to download USAA I get the FORBIDDEN bit when I try to connect.
Reporting it now, will keep watch. Still using 2021(3069) on live data so it doesn't have anything to do with 2022 release.
617 Posted by dtd on 14 Oct, 2021 10:34 PM
I'm not seeing any other posts about USAA stopping working.
Can someone verify that USAA is still working for them? If so, I'll try diagnosing differently than just assuming they shut more than me down.
618 Posted by jpbears1 on 14 Oct, 2021 10:45 PM
I can confirm that USAA is still working for me.
619 Posted by dtd on 14 Oct, 2021 10:49 PM
Great! Made me call USAA and they reset my account for Quicken access and now all is working again. Thanks for sending me down a different path.
620 Posted by Kevin on 16 Oct, 2021 06:11 PM
With the latest version of MD and the new MD+, is there any action required to remove this connection profile for the MD+ service to work?
621 Posted by dtd on 16 Oct, 2021 07:57 PM
just a user
You would need to Disconnect it just as you would with any other profile.
You don't need to remove the profile, just don't use it (i.e. Disconnect)
622 Posted by Kevin on 17 Oct, 2021 01:25 AM
dtd: Simple enough, thank you
623 Posted by brian on 20 Oct, 2021 12:45 PM
Previously added all of my USAA accounts successfully using this process;
https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/connecting-with-usaa
I don't recall the exact version.
Yesterday installed Moneydance version 2022 (4056). All USAA downloads continue to work fine however I'm no longer able to add new USAA online accounts from menu Online/Setup Online Banking. Not seeing the "ofx_create_new_usaa_bank_custom_profile.py" selection and instead seeing standard "Connect to OFX Service" or "Connect to Moneydance+".
What happened to the "ofx_create_new_usaa_bank_custom_profile.py" selection?
624 Posted by dtd on 21 Oct, 2021 12:29 AM
@Bruan - just a user here.
Try this - pick the "Connect to OFX service", then search for USAA in the bank list.
You should find something like USAA Custom Profile (ofx_create.....) Choose that.
Hopefully that will work. (I'm not yet on 2022(4056) with my live data.)
Given your issues, do a backup first of course.
Hope that helps.
625 Posted by brian on 21 Oct, 2021 01:41 AM
@dtd
Name is actually Brian LOL typo on my part. Thanks for advice and tried suggestion but no luck, see attached png
Where does the custom profile get stored? In the .moneydance folder? I'm running ubuntu,
626 Posted by dtd on 21 Oct, 2021 01:46 AM
You'll have to get @Stuart to answer those questions, I'm just the instruction writer.
Also, no png attached?
If you can verify it is totally missing, you could break the rule of "you only need to run the script once" and have it recreate the profile, but I'd personally hesitate to do that as USAA is working for you with other accounts, so the profile has to be somewhere.
627 Posted by brian on 21 Oct, 2021 11:24 AM
Here is attached screen shots of what I'm seeing when adding a new online account and no option to select the custom USAA profile script.
Also an additional screen shot of current settings for one of my online USAA accounts. In this case the profile was created with previous version of moneydance and now persists in latest version.
628 Posted by dtd on 21 Oct, 2021 07:36 PM
Looks like something changed between versions, but I'm not sure what. Again, back to Stuart.
That said, Stuart just wrote a new script for version 4056 that allows multiple login ids for a bank, and he said he included usaa, so he may already be aware of the issue.
I'm supposed to be testing it, but, well, you know, life. He may be waiting for me to verify that this new script works for USAA in the new version (he can't test the real situation, given he's not in USAA).... but I'm not real available right now other than answering a couple messages here and there.
629 Posted by Stuart Beesley ... on 23 Oct, 2021 03:19 PM
Apologies. Somehow I missed these posts. I will review the problem.
630 Posted by Stuart Beesley ... on 23 Oct, 2021 03:56 PM
OK, the profile dropdown not appearing in MD2022 is an MD 'bug' / the feature has been 'removed' (it's not there any more)... Thus, this would apply to any profiles not just usaa... I have just reported this to Sean... It's nothing to do with my script... You won't be able to add new accounts to any profiles....