bank of america screws us
So, if we upgrade our Moneydance can we find a way to download from Bank of America? How difficult is it.
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
Support Staff 1 Posted by Maddy on 20 Nov, 2025 05:20 PM
Hi,
Thank you for contacting Moneydance support.
Unfortunately, Bank of America has discontinued their use of OFX Direct Connect in 2022. This service is required to download your transactions automatically into Moneydance for free.
Without Direct Connect, you can still easily import your data into the program for free. You can use a web browser to download files from your bank's website. We recommend you download using the OFX, QFX or QIF file format, which you can import into Moneydance using File > Import. The steps for manually importing your data are outlined in this article.
Alternatively, you can subscribe to Moneydance+. This is an optional subscription service that allows you to download transactions from your banks using the Plaid aggregator.
You can read more about Moneydance+ in this blog post and in this section of the knowledge base.
There is a 30-day free trial so you can fully test downloading from Bank of America before you're charged.
If you own a license key of Moneydance 2022 or later (and you do) and you have registered the program using your key, the cost to use Moneydance+ is $4/monthly or $40/yearly. The steps for setting up this service are outlined in this section of the knowledge base.
I hope this information is helpful. Please let us know if you have further questions or need more assistance.
--
Maddy, Infinite Kind Support
2 Posted by dcarls3 on 20 Nov, 2025 10:29 PM
I just downloaded CSV. format (Microsoft) format from BAC - it works
3 Posted by jbaca16 on 20 Nov, 2025 11:17 PM
Yes, but it won’t migrate to my financial hardware, unless I just don’t
know how to do it.
On November 20, 2025 at 3:29:25 PM, dcarls3 ([email blocked])
wrote:
4 Posted by dwg on 20 Nov, 2025 11:23 PM
Moneydance can import CSV data to non-Investment accounts either using the inbuilt import or the user written CSV importer.
For a one off import the inbuilt import is effective enough. See the Knowledge Base article:
https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/importing-csv-files
For routine imports the CSVimporter is arguably better as it allows you define and keep a custom reader. The reader specifies the layout of the CSV file.
With CSV files, in either case, you have to map columns in the CSV table to the account register fields.
The CSVimporter is installed through the Extensions => Manage Extension menu item.
Support Staff 5 Posted by Maddy on 21 Nov, 2025 11:06 AM
Generally we recommend using the OFX, QFX or the QIF file format, if they available from your bank's website.
Although CSV files can be imported, unfortunately the import process is a little more involved. CSV files were not designed to transfer data to personal finance programs, so there is no standard format or layout for these files.
If CSV is the only format available, you'll be able to import the file to Moneydance using File --> Import. During the import process, you'll assign the columns in your CSV file to fields within the Moneydance account register.
Once we've determined the import settings you need, they should not change.
Please keep us posted on your progress, Thank you!
--
Maddy, Infinite Kind Support
6 Posted by Sarah on 22 Nov, 2025 10:44 PM
Yeah BoA seems to have discontinued offering OFX or QIF, the only option is XLS.
7 Posted by Doug Glover on 04 Dec, 2025 02:27 AM
I was able to download OFX files from Bank of America as of October 2025. Now Bank of America says "Important update: Quicken file downloads no longer supported". It only allows quickbooks and csv now.
8 Posted by dwg on 04 Dec, 2025 04:33 AM
QBO files are supposedly based on QFX file i.e OFX. I wonder just how close the relationship is and if Moneydance's OFX import capability could be extended.
Support Staff 9 Posted by Maddy on 04 Dec, 2025 05:10 PM
Does anyone happen to have a sample QBO file you could share?
If it’s the same or similar to OFX, it should be a text file that can be edited to remove or redact any private details.
Would it be possible for you to upload a sample file to the link below?
In this way the development team can look into this in more detail.
https://www.dropbox.com/request/MWl0JDdufTqlKiJUQtqz
Thank you
--
Maddy, Infinite Kind Support
10 Posted by Doug Glover on 04 Dec, 2025 06:21 PM
So I just checked again and unfortunately regular checking and savings accounts at Bank of America are only allowing text and csv downloads.
Only my Bank Of America credit card is allowing a QBO which I uploaded to the above dropbox link.
I did set up the csv import for both my credit card and regular Bank of America accounts and it worked just fine.
Support Staff 11 Posted by Maddy on 08 Dec, 2025 12:03 PM
Thank you for the additional information, Doug!
Bank of America’s QBO files can be renamed with an .ofx extension, allowing them to be imported into Moneydance. However, the development team has added a feature in the upcoming release that will automatically recognize QBO files without the need for renaming.
I hope this information is helpful. Please let us know if you have further questions or need more assistance.
--
Maddy, Infinite Kind Support
12 Posted by Douglas Glover on 08 Dec, 2025 04:50 PM
13 Posted by Sean Dayton on 14 Dec, 2025 10:08 AM
With my BOA accounts listed as BOA All Other States in Quicken. I do not have the option to download QBO files. Only XLS or plain text files. I noticed when BOA and Merrill shutdown the QFX activation with Quicken on September 1. They left the BOA Cash Pro Accounts active using the INTUBID 54111. I know this INTUBID is active because I can create QFX files with ProperSoft Transactions and currently import them into Quicken using 54111. BOA Cash Pro is BOA Business account sector. For those who have the luxury to own a perpetual license of Propersoft to handle file conversions. Your downable statement data in xls or cvs can be converted to OFX with ease using MS Copilot that imports into Moneydance with issue,
14 Posted by Sean Dayton on 14 Dec, 2025 10:16 AM
With my BOA accounts listed as BOA All Other States in Quicken. I do not have the option to download QBO files. Only XLS or plain text files. I noticed when BOA and Merrill shutdown the QFX activation with Quicken on September 1. They left the BOA Cash Pro Accounts active using INTUBID 54111. I know this INTUBID is currently active because I can create QFX files with Propersoft Transactions and currently import them into Quicken using 54111 for the INTUBID. BOA Cash Pro is BOA Business account sector. For those who don’t have the luxury to own a perpetual license of Propersoft to handle file conversions. Your downable statement data in xls or cvs can be converted to OFX with ease using MS Copilot that will import into Moneydance without any issues.
15 Posted by kjaspan on 16 Dec, 2025 01:03 AM
BofA has now ceased to support OFX. They now only provide plain text or csv file type exports. For those of you familiar with Python, there is a python app csvofx which, in (Ubuntu) and Debian Linux can be installed with
apt install csvofx
Thereafter there is some further legwork to be done: create a mapping file, ensure your csv file contains only the heading line and data lines beginning with Date. There are other details to attend to but I was able to use the app to process the csv and create an ofx file which Moneydance will happily import.
16 Posted by kjaspan on 16 Dec, 2025 05:08 PM
I have created a Python script to do the conversion in one single step, but there is other preparation to do to set up the environment properly.
Here is the Github repository:
https://github.com/bikingfreak/Moneydance-preprocessor-for-Bank-of-America-files
For BofA credit cards the csv format is different. The code and mapping file are now in the Github Repository listed above.
Instructions are in the README in the Repository.
17 Posted by Allan on 27 Dec, 2025 01:05 AM
Hi kjaspan,
I'm trying to get your python scripts to work. It seems the github repository is missing mapping_cc.py.
Thanks for your work on this!
-Allan
18 Posted by kjaspan on 27 Dec, 2025 01:41 AM
Allan,
I would be glad to help. Maddy seemed to have ignored my suggestion that
my work merited a free upgrade.
Which files do you need? I can send them by mail.
Kevin
On Fri, Dec 26, 2025 at 8:05 PM Allan <[email blocked]>
wrote:
19 Posted by Allan Bommer on 27 Dec, 2025 02:15 AM
Thanks, Kevin.
I’ve just started, but I believe I’m only missing the mapping_cc.py file.
(I’m downloading BofA credit card statements).
-Allan
On Fri, Dec 26, 2025 at 5:41 PM kjaspan <[email blocked]>
wrote:
20 Posted by kjaspan on 27 Dec, 2025 02:20 AM
Let me know how it goes, please.
21 Posted by Allan Bommer on 27 Dec, 2025 03:27 AM
I have the script running and the result looks reasonable.
I need to wait for next month's statement to give it a real test (I've
already imported this month's with CSV...which didn't go that well, but I
already fixed the errors).
Thanks for your help, Kevin!
On Fri, Dec 26, 2025 at 6:20 PM kjaspan <[email blocked]>
wrote:
22 Posted by kjaspan on 27 Dec, 2025 03:47 AM
Allan,
You're welcome. Let me know if you get any more problems or errors. I only
use it once month after I get my BofA checking statement and then I run
imports for all my accounts. I will retest it then, on about Jan.. 15th. I
will update Github if I need to make any changes.
Happy New Year.
Kevin