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 16 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
451 Posted by Stuart Beesley ... on 18 Apr, 2021 09:19 PM
@tahartman 😂 correction (=59)
452 Posted by Chuck Whittenbe... on 19 Apr, 2021 12:20 PM
Stuart, per your request, I am attaching the redacted Console Messages from this morning when I ran Online>Download Checking Account Transactions. Interesting that is mostly about Credit Card Accounts. Sadly, I will be away from my Computer now until later tonight. I will monitor my phone though.
Thanks,
Chuck Whittenberg
453 Posted by Stuart Beesley ... on 19 Apr, 2021 12:40 PM
@Chuck.. I'm a bit confused. This log says you are downloading Credit Card number ending ....79830 and then it says 'reading statement for (Checking Account: ....995)'. My take on this is that you have linked your online CC account to your MD checking account... Have you checked all your registers to see where the txns are actually going? But then the log is truncated, so I don't know what happens after this. Is what I say possible? If so, you will have to re-run online setup and link the right online accounts to the right MD accounts... ??
454 Posted by Chuck Whittenbe... on 19 Apr, 2021 03:42 PM
Stuart, at this point anything is likely possible!
I’m not sure how to go check the registers. Does your script clear the
registers? If so a straight reload is likely the easiest option. If they
are not cleared I’m not sure what to do.
I was astonished as well that I saw so much Credit Card info on a checking
account report. I have noticed that a new 7-digit Checking Account number
was inserted by the system and when I ran. The download it directly linked
back to my numbers.
Thanks for your help Stuart,
Chuck
455 Posted by Stuart Beesley ... on 19 Apr, 2021 04:18 PM
The script touches NO data, especially not the registers. These 'linkages' are all up to you and what account numbers you have stored on Tools/Accounts, and which of those you have linked to what bank accounts when the standard online menu pops up accounts to link..
Surely you use the 'registers' every day to look at your transactions in Moneydance by account... Select an account on the left side bar and look at your transactions.
@dtd - do you know how to unlink and relink the right accounts?
456 Posted by dtd on 19 Apr, 2021 07:27 PM
@Chuck - first of all FORGET about the script. The script has been run successfully, and you can connect to USAA again. That's it.
At this point you are simply using Moneydance. However, it appears you have linked the wrong accounts to USAA (Did you use nicknames at usaa.com to easily see which goes to what?)
Here's the link to the documentation again:
https://infinitekind.tenderapp.com/discussions/online-banking/18363/r?go=aHR0cHM6Ly9naXRodWIuY29tL3lvZ2kxOTY3L01vbmV5ZGFuY2VQeXRob25TY3JpcHRzL3Jhdy9tYXN0ZXIvc291cmNlL3VzZWZ1bF9zY3JpcHRzL29meF9jcmVhdGVfbmV3X3VzYWFfYmFua19jdXN0b21fcHJvZmlsZS5wZGY%3D
Note that anything I refer to now is in the ADDENDUM, which is about what you do in MONEYDANCE now that it is working again. I assume you set this up before USAA broke things, so you just need to set it up again.
@Stuart - how to do this is in the documentation already. Unlink/Relink is the Online/Change bit, except you have to delete all the misdirected transactions. Here is the pertinent text:
Given your profile has now been fixed, you should be able to use Moneydance to go to each account, do the ONLINE/SETUP BANKING bit, hit Change, find the other accounts in the list (you may have issues linking multiple accounts to weird numbers) and properly link your accounts between USAA/Moneydance. Fixing these one at a time, starting with the ones that match, would be a good process. If an account is missing, it may be due to little or no use. Wake it up with a small transaction; it should reappear once the transaction clears.
This issue of odd numbers and “hard to figure out what goes where” are due to the USAA changes.
Be careful here! Pay attention to which numbers go to which accounts. If you get the matching wrong, change the accounts again to attach to the correct accounts. You may have to delete any transactions you downloaded incorrectly, if the matching was wrong initially.
To add to this, give the list of accounts window time to come up, sometimes it takes a bit, and people pick the first one without realizing it.
I suspect that Chuck has things mismatched. Chuck, go to each and every USAA account, set up online banking for each one, INCLUDING Checking, and make sure you pick the account that goes to the same account in Moneydance.
457 Posted by wbbonneriii on 23 Apr, 2021 01:24 AM
All, I've been able to successfully connect to USAA but for some reason the online function is downloading duplicate transactions each day. How do we fix that?
458 Posted by dtd on 23 Apr, 2021 03:12 AM
@wbbonnerii - have you read the documentation discussing duplicate transactions?
You have to delete the original transactions, and keep the new ones. Please download the latest documentation and read that section.
I'm assuming you are deleting the new duplicates, and keeping the old ones - that will cause them to be downloaded again "each day".
459 Posted by Stuart Beesley ... on 23 Apr, 2021 05:17 AM
@wbbonnerii 😃 +1 (=60).
As @dtd says, pls delete the old txns, and keep the newly downloaded txns.
460 Posted by wbbonneriii on 23 Apr, 2021 03:56 PM
It isn't the previous historical transactions that are the problem. What happens is when I get up in the morning (happened early this morning), the transactions download properly; however, if the download function runs again on the same day (happened just five minutes ago), it duplicates the transactions again. So each day they are being downloaded twice and the program doesn't recognize that the download already happened that day.
461 Posted by Stuart Beesley ... on 23 Apr, 2021 04:47 PM
In the PDF there is a section on editing the last txn download date (to today) using toolbox. Try that.
462 Posted by mgphl52 on 24 Apr, 2021 07:07 PM
OK... finally did the script and all works ok for checking & credit card, but when I try to link the savings account, it doesn't come up in the list of accounts. Is there some limit to number of accounts at a bank? I'm actually connected to 7 separate accounts but only 6 show in the list.
463 Posted by dtd on 24 Apr, 2021 11:17 PM
@mgphl52...
How often do you use the savings account? Others have seen missing accounts, but so far it is because of lack of use. In the documentation, we suggest,
If an account is missing, it may be due to little or no use. Wake it up with a small transaction; it should reappear once the transaction clears.
--- So far that seems to work.
464 Posted by mgphl52 on 25 Apr, 2021 01:13 AM
I just transferred some money to the account. Will check in the AM to see
what happens.
Thanks for the suggestion!
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
465 Posted by dtd on 25 Apr, 2021 01:50 AM
Given today is Saturday, I'd give it till about Tuesday....
Bank accounts are hard to wake up over the weekend... ;)
466 Posted by Stuart Beesley ... on 25 Apr, 2021 04:36 AM
@mgphl52 😃 +1 (=61)
467 Posted by mgphl52 on 27 Apr, 2021 05:05 PM
@dtd & @stuart: Thanks! Appears to be all better now!
468 Posted by Stuart Beesley ... on 27 Apr, 2021 05:16 PM
@mgphl52 😃 +1 (=62)
469 Posted by dwk on 28 Apr, 2021 08:30 PM
For Beesley and dtd --
Hi - and thanks to you and others for making excellent progress in sorting out USAA access.
I have gotten to the point using the script where I established a TESTUSAA file on MoneyDance, using appropriate new data for the 6 essential data needs in the process. But right now I have in MoneyDance I have data up to 19 Jan (expected) but I do not download USAA account data beyond that date. I have tried the 'previous' and 'new' passwords to no avail. I presume I am making a simple error but wish guidance as to what it might be. For example, which 'password' is USAA looking for: new 'userpassword', ' userid', or my usual USAA pin or previous password.
So, help .....
Thanks,
David
470 Posted by Stuart Beesley ... on 28 Apr, 2021 08:48 PM
I’m sure dtd will jump in. But in the PDF it tells you (how) to logon to usaa and request quicken credentials. These are the credentials to use.
471 Posted by dtd on 28 Apr, 2021 08:57 PM
If you are not successfully connecting, have you run the script within the TESTUSAA database? As the documentation says, gather the data from the usaa website (3 are the long data string, the new userid and password), then your one or two account numbers, and the usaa identification number)
Once you run the script and see "successful" - then try downloading data.
Hope that helps. I'd recommend, if you don't have it, the latest documentation (Version 8), and read it carefully (probably again), but this time follow the steps outlined as you go, or confirm that you've done them.
472 Posted by dwk on 28 Apr, 2021 08:59 PM
Thanks, I'll keep on it. Where do I find v8 of the script?
473 Posted by dtd on 28 Apr, 2021 09:02 PM
This would be Version 8 of the documentation. The script has been the same for quite some time, but I keep tweaking the documentation as I see how people interpret what I wrote.
This is the link that is in the first message of this thread.
https://infinitekind.tenderapp.com/discussions/online-banking/18363/r?go=aHR0cHM6Ly9naXRodWIuY29tL3lvZ2kxOTY3L01vbmV5ZGFuY2VQeXRob25TY3JpcHRzL3Jhdy9tYXN0ZXIvc291cmNlL3VzZWZ1bF9zY3JpcHRzL29meF9jcmVhdGVfbmV3X3VzYWFfYmFua19jdXN0b21fcHJvZmlsZS5wZGY%3D
474 Posted by dwk on 28 Apr, 2021 10:20 PM
I redid the script to establish my file but am still not connecting. Error: 2000.
Can you relate for me the terms for a USAA connection; as there are terms that I may be using wrong.
What are the equivalent terms between MoneyDance and USAA, since the logon is blocked by
the wrong info I am sending to USAA.
For example: Equivalence of terms: That is, what are the Moneydance/Quicken term equivalents to the USAA needs for a
"User ID" and for the "Password/Pin" ?
As in the USAA logon:
That is, note these?
clientUid = usaa user name? userID?
userid = usaa PIN? or usaa password ?
userpassword = usaa PIN? or usaa password ?
Thanks ...
David
475 Posted by dtd on 28 Apr, 2021 11:22 PM
Ok. First, did you download the documentation? Anything I say will be simply a repeat of what I have written, but I'll try to be specific to your questions.
There are three items you need from USAA - a long string of numbers called clientUid, a userid, and a password/pin. Gathering those three items are necessary - I spend time describing how to gather these numbers, and suggest you save them in a file. You use all three when the script asks for them.
All of clientuid, userid, and userpassword are described in the documentation.
I really don't know what else to say, other than to explicitly post the documentation itself. As to equivalence of terms, the documentation says what you need to gather and use.
476 Posted by dtd on 28 Apr, 2021 11:28 PM
Actually, what is it in the documentation you do not understand? (That's why I keep tweaking it to newer versions)
You talk about equivalence of terms - I TRY to say what you need to gather and then enter into the script, but there seems to be some disconnect for you. Could you explain to me what doesn't make sense to you between gathering the data you need (based on the documentation) and what you enter into the script when it asks for that same information?
477 Posted by dtd on 28 Apr, 2021 11:34 PM
Also, where are you located? Did you check the information in the documentation about Error 2000? i.e. are you outside the U.S.? Do you have blockers in place? Maybe it all is working, but there are other factors in play.
478 Posted by dwk on 29 Apr, 2021 03:38 AM
dtd
479 Posted by dwk on 29 Apr, 2021 03:47 AM
SEAN -
I HAVE A QUESTION IN THE FINAL ACCOUNT UPDATE ACTION TO USAA. I WOULD APPRECIATE YOUR REPLY ... dtd THINKS I AM NOT USING THE 'SCRIPT' PROPERLY, BUT THIS QUESTION IS POST-SCRIPT AND DEALS WITH A FINAL STEP TO DOWNLOAD DATA.
480 Posted by dwk on 29 Apr, 2021 03:48 AM
Inside US