Downloading transactions

I am testing the Moneydance free trial version in Linux/Ubuntu.
I like the features and, if I can can get it to work, I will definitely switch from Quicken.
I loaded a recent backup file from Quicken, and the account balances are all quite wrong - not even close to accurate. How do I download current transaction and balance information from my bank - Bank of America. BofA no longer uses the OFX standard. Thanks!

  1. It is not possible to load Quicken data files (QDF) or Quicken backup files into Moneydance, they are in a proprietary format.

    The standard process is to use Quicken to export the raw transactions data into QIF files and import these.

    QIF files however rarely contain an opening balances since in most instances these have not been recorded in Quicken as a transaction, so it will be necessary to record the initial account balances into Moneydance manually. There is a field on the Account Information screen for this purpose.

    As well as OFX/QFX Moneydance supports importing transaction files in the QIF format as well as for non-investment accounts in the CSV format. For regular use of CSV files the user written CSV importer is a good option as it provides for you to save the CSV file layouts as named custom definitions for ongoing use.

    For automated downloads there is the possibility of using the paid for Moneydance+ aggregator service.

  2. Hey, that's frustrating about the inaccurate balances! I had a similar issue when switching accounting software a while back. For Bank of America, since OFX is out, you'll likely need to explore direct connect options or potentially utilize a web-scraping tool if Moneydance supports it. Also, double-check the date range of your imported data. Sometimes importing incomplete data is like playing the Dinosaur Game – you know things are going to crash eventually! Good luck getting it sorted!
    https://dinosaurgamefree.com/

  3. Hi Keith,
    Thank you for contacting Moneydance support.

    You may want to consider importing your Quicken data by following the steps below:

    • If you are importing from Quicken please note, QDF and QXF files use a proprietary file format that can only be read by Quicken and Intuit programs. You need to open Quicken to export your data into one or more QIF files.

    Ideally you'll export one QIF file that contains all of your account data. Use the option to export 'all accounts' within one QIF file if this is available within the software you're using.
    If not, you should export one QIF file for each account in your file.

    Make sure you export any closed or inactive accounts containing transfers to your open accounts. You may need to re-open these accounts before exporting.

    If you're using Moneydance for the first time, when you open the program, you'll see the Welcome window. Choose “Create a new account set” and setup a new data file.
    If you have opened Moneydance previously, you can create a new data file by choosing File --> New --> Create a New File. Then follow the prompts to enter a name and currency for your new file.

    When viewing your new data file, choose File --> Import. Then navigate to and select the QIF file.

    You'll be asked which account you want to import your data into. If you have data for multiple accounts within one QIF file, you can pick any account.

    Below this, Moneydance will automatically try to determine the date format and decimal character used within the QIF file.
    If you want to check this, open the QIF file with a text based program like NotePad or TextEdit. This will allow you to check which date format and decimal character are being used.

    Choose 'Import' and wait a moment while your accounts and data are imported into Moneydance.

    If it appears some of your accounts are missing from the left side bar, press the '+' button at the bottom of the side bar. Choose 'Advanced'. You should see the missing accounts in the panel on the left - highlight the account name and press 'Add' to move the accounts into the panel on the right. When you're done press OK and these accounts should then be available for selection from within the side bar.

    Some QIF files don’t include an 'Initial Balance' for your accounts (sometimes referred to as a beginning balance or a starting balance). If this is the case, you'll see all transactions have imported but the account balance will show a discrepancy.
    To fix this, select the account and choose Account --> Edit Account. In this window, you can enter an amount into the 'Initial Balance' field.

    For investment accounts, QIF file don’t always carry security prices other than buy/sell prices, so investment account balances may be wrong until you update with the current security prices.

    Reminders are not included in QIF files as the QIF file format has no ability to include reminder data.

    Finally, it may be worth referring you to this article of the Knowledge Base on Possible Problems After QIF Import.


    Unfortunately, Bank of America has discontinued their use of OFX Direct Connect. 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 QIF or QFX file format, which you can import into Moneydance using File > Import. The steps for manually importing your data are outlined in this article.

    The steps are as follow:

    • Go to the account’s online statement page.

    • Click the Download link at the top.

    • Choose the statement period.

    • Select QIF or QFX as the file format.

    • Click Create Download File and save it to your computer

    • Finally you can import it


    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 Moneydance 2024 license key and you have registered the program, 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

  4. Since BofA dropped OFX, you’ll need to use Moneydance’s ‘Import from file’ option with QFX, QIF, or CSV exports from your BofA account. Log in to BofA online banking, download recent transactions in one of these formats, and then import them into Moneydance. This will overwrite or adjust the balances to match your current bank data.

    Zen@[sydney audio visual consultant](https://audiovisualconsultants.com.au/)

  5. Please unsubscribe

  6. Maddy closed this discussion on 20 Oct, 2025 11:54 AM.

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