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 2 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
31 Posted by hollidayjr on 26 Feb, 2021 03:43 PM
Yes, I entered the hyphens
32 Posted by Mark G on 27 Feb, 2021 07:45 PM
Stuart, YOU ROCK!!!!!!
This worked for me. I am using version 2021. Thank you!
33 Posted by Stuart Beesley ... on 27 Feb, 2021 07:47 PM
@Mark G +1
34 Posted by Stuart Beesley ... on 27 Feb, 2021 08:38 PM
(PS - @dtd and @hleofxquotes also rock too)
35 Posted by dewd on 27 Feb, 2021 08:43 PM
Thanks! MD is now working with USAA again. I'm not happy I had to jump thru so many hoops to make it work (I'll be addressing that later this year USAA) but I'm happy we have folks like you to keep things moving along. The scripts are perfect!
36 Posted by Stuart Beesley ... on 27 Feb, 2021 08:44 PM
@dewd +1
37 Posted by Stephen Skidd on 27 Feb, 2021 09:10 PM
Stuart and Co.,
I had a chance to run the scripts today and they worked beautifully. I
thought I might get lucky with the simple “fix” script but my account
credentials must have been broken/disconnected at some point. No matter, I
ran the “create new” option and it did what it was supposed to do. Thank
again for taking time to create a solution! Much appreciated.
Steve
38 Posted by Stuart Beesley ... on 27 Feb, 2021 09:35 PM
@Stephen Skidd +1
39 Posted by Stephen Skidd on 28 Feb, 2021 06:41 PM
Hi Stuart. I thought I would update you on my findings with access to USAA
accounts using the script. I have no problem downloading checking account
transactions but USAA credit download is a no go. I don't know why it's not
working. I re-ran the script to make sure I didn't overlook anything but
it's still out of commission. Just thought I would pass that on. I don't
know if anyone else is having the same issue.
Steve
40 Posted by Stuart Beesley ... on 28 Feb, 2021 07:02 PM
The CC is tricky as USAA sometimes use a new number... Now that your profile is working, try this
- click the cc account in the left sidebar. - Menu Online, setup online banking, Change, (the USAA profile should be showing), Next, then after you authenticate it should pop up with the list of valid CC numbers. select the right one and then try that...
@ dtd may have more guidance...
41 Posted by Stephen Skidd on 28 Feb, 2021 07:14 PM
That worked Stuart and, yes, it was tricky. The account is a joint account
with two separate card numbers. In order for the download to work, I had to
set up online banking using the other card number.
Thanks again!
Steve
42 Posted by Stuart Beesley ... on 28 Feb, 2021 07:17 PM
Great. So that’s +2
43 Posted by dtd on 01 Mar, 2021 12:04 AM
A read through of the documentation will make this easier.
It's long (like 6-7 pages) but it covers all the tricky stuff.
That said, the tricky stuff may be why you don't see an update from Moneydance to fix this. Not because they can't handle the tricky stuff, but because they want to make it not "tricky". And USAA.Quicken have implemented new items to make it less easy to put into place.
Moneydance is working on it, to make it part of a standard solution. We've figured it out, but it isn't standard. Still it WORKS.
And I've striven to make the documentation such that it doesn't SEEM "tricky" - just do this/that/other and you are done.
PS - After all the testing on test databases, I finally implemented it myself on my live database yesterday.
44 Posted by dwk on 01 Mar, 2021 02:43 AM
I am a bit confused about the word "documentation". To which note/reply should I refer to be sure I try the latest advice/documentation?
This one? " ofx_fix_existing_create_new_usaa_bank_profile.pdf " 174 KB
Should I try it on an real account that is less important than others. Or somehow create a 'test database'? But exactly what does that mean? Presumably it is in the documentation.
And thanks very much for you talented users to come up with a solution w/o yet having a buy-in from MD or USAA,
dwk
45 Posted by Stuart Beesley ... on 01 Mar, 2021 08:23 AM
As per the initial post (1), the latest PDF 'documentation' and latest scripts are on my site. Direct download link posted again here:
https://github.com/yogi1967/MoneydancePythonScripts/raw/master/usef...
It makes no difference which account you use... we are changing the bank profile.
As a minimum, make a backup -> File / Export backup
Please read the PDF and then come back here with any questions?
46 Posted by gelaw on 02 Mar, 2021 12:06 AM
Thanks for working this.
I downloaded and executed the "fix" script but had issues.
First issue - Not a big deal - I had 2 USAA credit cards in my account. The script errored out and I needed to delete one of the credit card accounts for the script to run. I think it would be better if it simply ignored the second credit card. Then at least I would not need to recover my old data.
Second issue - big deal! - I have 4 checking accounts and 5 savings accounts. They were all reported recognized and they downloaded. The savings accounts appeared to work correctly. But only one of my checking accounts worked correctly. After a sync with USAA, three of those checking accounts are FUBAR - including the account that was specifically identified in the script.
Backups are good.
47 Posted by dtd on 02 Mar, 2021 12:23 AM
@gelaw - thanks a lot for the feedback. Yes, backups aren't just good, they are essential.
Both scripts were originally written and tested for one checking account and one credit card. Your feedback indicates that Stuart's work to allow more accounts (mostly through documentation) still needs some tweaking.
I do have one thought - with that many accounts (I have tons of chase credit cards), is it
possible you didn't match them correctly? I've done that, even when matching carefully.
Another issue might be if you've manually entered for a month and then download - you will get duplicates and have to merge the transactions.
IOW, knowing what was FUBAR about the 9 accounts would be good information.
As for the two credit cards - you might say "NO credit card" to the script and maybe it won't error out - because basically the scripts fix the bank profile, not the accounts (except for the one checking/one credit card). Then you could check both credit cards as you did the 9 accounts.
A third thought, with that many accounts, maybe create_new would work better? (I don't know, I'm not Stuart, I just test things, and I hope he's gone to bed (he doesn't sleep enough) given his time zone.
But I'm sure he will be weighing in on this in about 6-7 hours.
48 Posted by gelaw on 02 Mar, 2021 01:28 AM
@dtd, A little more info.
I did not "match" any accounts. I simply ran the script, exited and restarted Moneydance, and then selected "Download All Accounts". The script file originally reported it found 11 pre-linked MD Bank/CC accounts. (4 checking, 5 savings, and 2 CC). I did note that the getOFXAccountType() was sometimes correct, sometimes not. Then I deleted one CC account and ran the script again.
This time the script completed. but....
Investigating further, I see that some of the account numbers do not match any of my account numbers - I wonder where those account numbers originated? In the case of my primary checking account, the account number matches correctly, but the account is labeled as a SAVINGS account.
Also, it reportedly configured 13 accounts, including 2 CC accounts. But my live MD live file only has 10 USAA accounts (including one USAA CC account. I deleted the second USAA CC account to get the script to run)
I do have 2 CC accounts that are not USAA.
AND - my account balances were messed up after running the script - did not download any accounts this time.
Hope that information helps
49 Posted by dtd on 02 Mar, 2021 01:42 AM
Stuart said he really didn't want to handle multiple accounts since MD should fix this soon, which is why doing multiples is only in the documentation I wrote.
OTOH, Stuart loves a challenge, and your knowledge of getOFXAcountType() suggests you two should have a cup of tea together.... ;)
My suggestion to go ahead and run Download All Accounts (which you did) was on the 1/1 assumption that they would all be fixed by the script. Obviously wrong. And it does appear there are mismatches. (and the account numbers are often wonky - I THINK (I do not know) that USAA might change a credit card number, but keep the previous number in the database. Don't know about savings/checking.
Account balances being messed up is probably due to mismatches, or if you've been manually entering, needing merging.
Trying to fix 11 (don't know why 13) accounts at once is challenging to make them all work. I spent hours fixing my chase cards when I accidentally hit forget all passwords in the moneydance menu (they NEED an "are you sure?"
I'll let Stuart weigh in later, I've learned a lot during this process, and historically am I/T, but I'm just the tester at this point.
50 Posted by Stuart Beesley ... on 02 Mar, 2021 06:05 AM
@gelaw - I suspect that ‘deleting’ the CC account caused the issue. Would be great to handle this unusual situation. Could you email me so we can work out exactly what happened. Can you try forgetting the fix script, and just run the create new script on a test system. Link 1 checking and 1 CC account. This will build a brand new profile. Check this works and then use the normal online menu on each additional checking account, CC account, one by one, to link to the new profile. Let me know?
51 Posted by Stuart Beesley ... on 02 Mar, 2021 06:40 AM
(PS - I've just confirmed that if you delete an account in Moneydance, that the existing OFX profiles do not get updated in Moneydance - perhaps this is where some of the old info came from... One thing to try before you start is to install my toolbox extension, go to OFX banking menu and examine your profile for USAA. In fact you can do this before and after). I remain pretty certain, that running the create new script will be fine as it starts again. Let us know? Thx
52 Posted by vievelyn on 02 Mar, 2021 07:08 AM
It worked! Thank you so much!
I have been following this issue for a some time and finally decided to try it out. Took a while, but glad to have it done. Found that it didn't work with 2015, so finally bit the bullet and upgraded to 2021. The fix script did not like the multiple CC accounts it found, but after I disabled online banking for all but one it worked beautifully.
53 Posted by Stuart Beesley ... on 02 Mar, 2021 07:26 AM
@vievelyn Fantastic! +1 . FYI - Now that you have a working USAA profile you can use the standard Online menu to enable / link all other USAA accounts.. I.e. Moneydance will work normally again... Let us know if you do this and that it's OK. Thx
54 Posted by Stuart Beesley ... on 02 Mar, 2021 01:52 PM
All, FYI - I have just updated ofx_fix_existing_usaa_bank_profile.py (build 13) to include extra validation of the profile linkages prior to execution... If it doesn't validate then it will suggest you run the ofx_create_new_usaa_bank_profile.py script which creates a new (clean) profile from scratch. Once you have run this, you can use the normal Moneydance Online menu to link extra USAA accounts... Keep updating us with your results here...
55 Posted by Stephen Skidd on 02 Mar, 2021 03:31 PM
@Stuart
I was able to reestablish connection to all of my USAA accounts, 5 total.
Everything is running like it did before. The only exception is that the
memo section is now automatically filled with the same information from the
description and the Check# column now indicates a default value of 0 for
EFT transactions. Other than that, I haven't noticed anything else that's
different.
I very much appreciate what you and the other guys have done.
Steve
56 Posted by Stuart Beesley ... on 02 Mar, 2021 03:50 PM
@Stephen Skidd +1 (odd abut the memo point, but I haven’t touched that. It if interest which script did you run?)
57 Posted by vievelyn on 02 Mar, 2021 03:57 PM
@Stuart, yes, I was able to link other accounts using the Moneydance Online menu.
58 Posted by Stephen N. Skid... on 02 Mar, 2021 04:16 PM
@Stuart
I ran the following script shown below. As I previously noted, it allowed reconnection to all of my other USAA accounts with no problem.
ofx_fix_existing_usaa_bank_profile.py
59 Posted by rdmyers.42 on 02 Mar, 2021 04:40 PM
Just took the plunge, and backed up all directories, just incase.
Took a few tries to get things working.
Now, checking, savings, and CC all download as they did.
Many thanks
60 Posted by Stuart Beesley ... on 02 Mar, 2021 05:13 PM
@rdmyers.42 +1