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

  1. 631 Posted by Stuart Beesley ... on 23 Oct, 2021 04:12 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @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...?

  2. 632 Posted by Stuart Beesley ... on 23 Oct, 2021 10:05 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    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...

  3. 633 Posted by Stuart Beesley ... on 27 Oct, 2021 05:35 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @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... 😉

  4. 634 Posted by dtd on 02 Nov, 2021 10:25 PM

    dtd's Avatar

    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

  5. 635 Posted by dtd on 02 Nov, 2021 11:01 PM

    dtd's Avatar

    .

  6. 636 Posted by hbr245b on 09 Nov, 2021 01:35 PM

    hbr245b's Avatar

    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>

  7. 637 Posted by doug on 09 Nov, 2021 02:28 PM

    doug's Avatar

    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.

  8. 638 Posted by james.f.roach on 09 Nov, 2021 03:53 PM

    james.f.roach's Avatar

    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.
    ###############

  9. 639 Posted by dtd on 09 Nov, 2021 11:31 PM

    dtd's Avatar

    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.

  10. 640 Posted by dtd on 09 Nov, 2021 11:44 PM

    dtd's Avatar

    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.

  11. 641 Posted by hbr245b on 10 Nov, 2021 03:10 AM

    hbr245b's Avatar

    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!

  12. 642 Posted by dtd on 10 Nov, 2021 04:02 AM

    dtd's Avatar

    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.

  13. 643 Posted by hbr245b on 10 Nov, 2021 02:43 PM

    hbr245b's Avatar

    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.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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