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 22 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
631 Posted by Stuart Beesley ... on 23 Oct, 2021 04:12 PM
@Brian. Assuming your usaa profile is working for existing accounts, can you try this.... Download the latest useful_scripts package from my site and unzip..
https://yogi1967.github.io/MoneydancePythonScripts/
BACKUP YOUR DATASET
Find ofx_populate_multiple_userids.py and run that in Moneybot... Manage the usaa profile, and select the extra account(s)... Don't change any other data...
Let me know if this lets you add extra accounts to your working usaa profile...?
632 Posted by Stuart Beesley ... on 23 Oct, 2021 10:05 PM
OK, we (me and Sean/IK) have rigged up a fix for this issue (profile dropdown not appearing in MD2022).. You will need to run the latest usaa script (build 20)... MD now recognises this custom profile and it will appear in the select bank drop down box. In theory, this will allow you to add new accounts... @dtd is currently testing this...
NOTE: custom usaa profiles created before October 2022 will not have this new identifier, so whilst they will continue to work, you will not be able to add new accounts to it.... Hence the new script (build 20) is required.... This new script can run on all versions of MD....
https://github.com/yogi1967/MoneydancePythonScripts/raw/master/usef...
As an addendum, there is now another script within this package that allows you to edit a working profile and populate it with multiple UserIDs..... Again, I am sure @dtd will update later...
633 Posted by Stuart Beesley ... on 27 Oct, 2021 05:35 AM
@Brian..... @All...... It's been a busy week, but we have resolved the USAA issues as regards the 'adding a new account to an existing USAA custom profile' issue.... And it gets better, we have resolved some of the core MD functionality too! It's involved script changes, MD code changes (i.e. MD2022 build: 4059) and back-end profile changes... Thanks to @dtd, @Sean (and @me!).. It's highly likely that this may well now work in MD2021 (and backwards too)....
NOTE: If on MD2022, you must be on build 4059 onwards
HOWEVER, it's also highly likely that existing custom usaa profiles will need to be recreated one last time.... or just deleted......
There are now three ways to get USAA working (option 1 is preferred):
1/ Download latest Toolbox extension from my site. Advanced mode, Online Banking Tools Menu, OFX Authentication Menu, select:
"USAA ONLY: Manually 'prime' / overwrite stored Root UserIDs/ClientUIDs" on this screen you then 'prime' MD with your UserID(s) and your unique ClientUUIDs that are needed for the connection. THIS HAS TO BE DONE FIRST.
- Then you can use MD Online Menu, and run the normal Online Setup. From this point, you are 100% just using Online Setup and it should work....
OR
2/ Run Toolbox, Online Menu, and select:
"USAA Only: Executes the special script to create a working USAA OFX Profile" this is an updated version of the 'old' script that completely sets up your USAA profile... But, now the standard MD Online Menu, Online Setup will work to add accounts later.
3/ Download the script from my site (useful_scripts) package.... It's the same as running option 2 above..
PPS - if you need multiple UserIDs and this isn't working for you, then once you have a working 1-user USAA connection, you can use the latest Toolbox, select Online Banking Menu, OFX Authentication Menu, then option:
"Edit/Setup (multiple) UserIDs / Passwords (executes a special script)" This script will allow you to edit any working profile and setup multiple userIDs & passwords....
Links: Latest Toolbox (PREVIEW)
https://yogi1967.github.io/MoneydancePythonScripts/
https://github.com/yogi1967/MoneydancePythonScripts/raw/master/tool...
Let me know if you do any of this, and your results? Thanks
I'm sure @dtd will be posting much better instructions... 😉
634 Posted by dtd on 02 Nov, 2021 10:25 PM
Ok - @dtd here with "much better instructions" ;)
The "fix" is gone. No more script needed.
Creating a new profile for USAA is now built into Toolbox. No more complex to run than anything else Toolbox is called upon to do.
You still have to gather 3 items from USAA. Even if MD built something into their program, this gathering would be required.
But now - run two menu items in Toolbox and you should be in business again.
I'm sure Stuart will modify the initial post of this thread, but here is the new, 2 pages only, documentation. No script. Just get 3 pieces of data from USAA, and run two toolbox items. Done.
Note this documentation is "Version 9" and may be superseded as I've made a couple suggestions to Stuart to make the Toolbox items even simpler than they already are.
The link below should automatically go to your downloads folder.
Note that the USAA only instruction is underneath: MENU: Online Banking (OFX) Tools
635 Posted by dtd on 02 Nov, 2021 11:01 PM
.
636 Posted by hbr245b on 09 Nov, 2021 01:35 PM
I've had this USAA OFX connection working thanks to the script for many months.
Yesterday & today, error 2000 returned from USAA.
Came here to see if anyone else had the same problem.
Downloaded the pdf in the message prior, deleted my USAA profile & tried to setup again but when I enter the access id & password retrieved from the USAA website, I still receive an error 2000.
MD 2022.2 (4060)
Taken from the console:
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
<MESSAGE>SUCCESS
</STATUS>
<DTSERVER>20211109081345.892[-5:EST]
<LANGUAGE>ENG
<FI>
<ORG>USAA Federal Savings Bank
<FID>67811
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>1636463626003-10
<STATUS>
<CODE>2000
<SEVERITY>ERROR
<MESSAGE>General Error
</STATUS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>
637 Posted by doug on 09 Nov, 2021 02:28 PM
I have the same problem, but I feel this whole year I've had this problem intermittently. It usually resolves itself, but it appears that the last transaction date I've got for now is November 5. Could be a longer term issue or it might resolve itself. Fingers crossed.
638 Posted by james.f.roach on 09 Nov, 2021 03:53 PM
Thanks in advance for your work/help....
I have followed the Version 9 "USAA Moneydance USER walk Through"
All was going well during the setup....
Then I tried to access myUSAA account with MD and got the Following
********************
There was an error communicating with your financial institution. The details of this error are below.
Bank Name: USAA Custom Profile (ofx_create_new_usaa_bank_profile_custom.py)
The error code reported by the server was: 2000
General Error
**************************
Help.........
###############
11/10/21 7:30 AM EST update
I logged on today with the patch installed.
Didn't change anything from yesterday.
I only applied the patch to my credit card account.
******** IT WORKED **********
Sooooo ...... I applied the patch to the rest on my accounts with USAA.
Will see how things go tomorrow, will update.
###############
639 Posted by dtd on 09 Nov, 2021 11:31 PM
I always check my own accounts, because you never know when USAA is going to change something again.
USAA has had intermittent issues (lack of connection) for the last few days; I don't know why, but as @doug notes, in the past it has resolved itself at some point.
I just checked my accounts in 2021(3069) (my live data) and 2022.2(4060) (my test data)
I have checking/credit card. Results as of this post:
3069: success/success
4060: success/2000 error
I waited about 15 minutes and downloaded the 4060 credit card again: success
huw.richards - given your history, I would just try it again; maybe even only minutes apart. Or just try once day - if it doesn't work for quite some time, post again. I certainly won't be able to help, but would want to know.
james.f.roach - i'm hopeful you are just falling into the same issue, and trying again at some point will work. OTOH, if your client_id or userid or password was somehow mistyped in toolbox, then you may need to repeat the "priming" of the USAA custom script.
640 Posted by dtd on 09 Nov, 2021 11:44 PM
huw.richards - i note that you deleted the working script and ran the new toolbox item.
I should probably put a note into the the documentation like "if it ain't broke, don't fix it..." :)
I fix it constantly in testing with Stuart, but with my live data 2021(3069) I fixed it in February 2021, and haven't touched it since. But that's good, as I can test the old and the new.
I assume you ran the new USAA only item and entered the client_id and userid before you went back to moneydance to run online setup, but you don't mention that part.
I'd check those items carefully, given they are now "new" again. I'd try downloading again over the next day or two, maybe even minutes apart a couple of times.
641 Posted by hbr245b on 10 Nov, 2021 03:10 AM
You are right - I didn't mention that I followed the instructions to the letter in the pdf I downloaded but I did!
I've had the occasional error over the last few months but not on consecutive days (I usually download around 8/9 am every day) hence my thought to re-run the setup. Once I saw the same 2000 error during setup I realised that it was a USAA error and probably not a MD / me error only now I had a non-working configuration.
Approx 12 hours after my message above, I've been able to successfully re-link my 5 USAA accounts via Online -> Setup Online Banking for each account.
Thanks for the script & your help as always!
642 Posted by dtd on 10 Nov, 2021 04:02 AM
huw.richards - so you "tested" like I do all the time, and the toolbox (non-MD script) bit works. Great!
Glad the simpler instructions (2 pages - most of it is just grabbing the three USAA items now) worked for you!
Hopefully james.f.roach will find a time period where USAA is working right now.
643 Posted by hbr245b on 10 Nov, 2021 02:43 PM
FYI - USAA accounts sync'd ok today (10 Nov 2021 09:38EST)
So probably just a coincidence that I received the 2000 error on two consecutive days.
644 Posted by norwich2 on 01 Feb, 2022 12:06 AM
I successfully used Stuart's scripts earlier this year, but decided to jump to Moneydance22 with "+" recently. I went through the "+" instructions to add USAA and all the accounts appear. However, when I go to download now, it asks me for my custom profile OFX username and password...which works. However, Moneydance+ instructions say that this shouldn't need this step anymore. Also, it does this for every account individually. What exactly do I need to do to remove it so I can use "Download transactions", or are the instructions wrong?
645 Posted by dtd on 01 Feb, 2022 02:51 AM
just a user
OFX always wins over MD+. So if you want to move to plus, then you have to disconnect the OFX connection (and this is true of all accounts, not just USAA).
So, good luck. That said, I personally see no reason to move to MD+ for accounts that still work with OFX, as I am not fond of passing through Plaid to get to my data (though with things like Schwab, I have no choice.)
Hope that helps.
646 Posted by norwich2 on 01 Feb, 2022 10:21 PM
OK, thanks. I'll keep USAA on the OFX since it works...and add Schwab onto +. I assume that, as long as OFX is not set up, that + will work as it is supposed to...even with OFX on other accounts.
647 Posted by dwg on 01 Feb, 2022 10:36 PM
Yes you can use OFX for one institution and Moneydance+ for another, you just cannot have both set up for the one.
OFX/Direct Connect is arguably the superior solution so to use that if it is availble makes sense and to use Moneydance+ if it is not and your institution is support by that solution.
Typically histoically if you wanted minimum manual entry you looked at the solutions in the order of:
Direct Connect -> Download & Import -> Manual entry
With Moneydance plus this becomes:
Direct Connect -> Moneydance+ -> Download & Import -> Manual entry
Now if the developers can get a more complete implementation of the internal browser that is in Moneydance, I'll call this Moneydance Connect, you could potentially end up with:
Direct Connect -> Moneydance+ -> Moneydance Connect --> Download & Import -> Manual entry
If you are not interested in a subscription service or using a third party you remove Moneydance+ from the solution list.
648 Posted by dtd on 01 Feb, 2022 11:23 PM
also note that moneydance+ does not yet support investment accounts - so I keep twiddling my fingers waiting for Schwab investment accounts to be supported again.
649 Posted by norwich2 on 02 Feb, 2022 12:53 AM
Ah, so investment accounts like Schwabs x-USAA cant use either MD+ or OFX. How unfortunate. I guess that means download and import. Well, since Schwab did have OFX at one point, how do I remove that piece...since it won't work like USAA does presently?
650 Posted by dtd on 02 Feb, 2022 01:04 AM
You can disconnect Schwab accounts from OFX, as it's pretty obvious they will never work again. (Sean/MD worked to extend it a year, but Schwab cut it off on Oct 1, 2021)
And, sadly, download and import is only CSV, not OFX. That means it "could" work for bank and credit cards, but not investments...
With investments, you are sitting, and waiting. (as am I) - I can only report that this is probably one of the primary activities that the MD team is working on - just sad it has been 4 months now.... (looking at watch :) )
651 Posted by dtd on 02 Feb, 2022 01:07 AM
added - I've been told that Schwab bank accounts do work with MD+ already (not investments), but for me, that's minor.
652 Posted by norwich2 on 04 Feb, 2022 02:37 AM
That sums it up then... except....does anyone have a link to how to remove a single (broken) OFX connection in MD22? In my case, Schwabbs? I imagine it is a matter of deleting a few lines in a script somewhere. Thanks.
653 Posted by dtd on 04 Feb, 2022 03:12 AM
I think all you really need to do is "Disconnect" ofx, unless something is messed up.
If messed up, Stuart's toolbox extension has the ability to remove the entire account ofx profile, but that's only if things within MD don't work properly.
654 Posted by norwich2 on 05 Feb, 2022 05:54 PM
Sounds like you are referring to a "disconnect" button, something that is available for each discrete institution used with Moneydance. I'll see if I can find that feature.
655 Posted by Stuart Beesley ... on 11 Feb, 2022 05:32 AM
For OFX. Select the account on the left, then menu online banking, then setup online banking, then disconnect.
656 Posted by ik on 20 Apr, 2022 10:41 AM
Deleted
657 Posted by ik on 27 Apr, 2022 10:00 AM
I followed the instructions on https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/connecting-with-usaa
When setting up login banking, when I get to the login, no matter what combination of UserID I use (USAA # or login name) and Password/PIN (both items, either item, both items with or without "/") I get this error:
The given customer ID or PIN is not valid. For more information, contact your financial institution.
Additional information from the server:
Signon Invalid
658 Posted by dtd on 27 Apr, 2022 05:26 PM
just a user
Well, we can both see what is wrong. Your signon is invalid.
First, why are you even trying to use your USAA # ? What is the "/" about?
Why are you trying to use your USAA password?
You also call this "login banking" instead of "automatic OFX downloads" - are you trying to log into the website? That's not what these instructions are about.
The instructions are quite specific - you need to get the quicken id, the quicken password, and the client_id from the url, then approve being set up with quicken. That's what you use when setting up USAA OFX with Moneydance.
The fact that you are trying multiple login ids, login passwords, and maybe even a "/" (where does that come from) suggests that having "signon invalid" would be extremely likely. I'd suggest re-reading the instructions to understand what you need to do.
System closed this discussion on 27 Jul, 2022 05:30 PM.