Download transactions and reconcile from Merrill Lynch

Merrill Lynch has disabled their OFX server, so automatic retrieval of transactions/positions from Fund Manager is no longer possible, but you can still download/import this data.

Importing Transactions

1. Download a .QFX file from "Download Account Data" on Merrill's website.  On the "Accounts" menu along top there is a link to "Download Account Data" which gives you a form with these options: 
   • Choose category or account: Select which accounts you'd like to download
   • Choose application: Select "Quicken"
   • Choose Settings: Select only the 4 options: "Dividends/interest", "Fund receipts", "Fund transfers", "Security transactions", and pick the date range you'd like to download.
   • Download: Press the "Quicken" button to download the .QFX file
   If you chose "All accounts" it will download a single .QFX file for all your accounts.
2. Import the .QFX file into Fund Manager using "File / Import / Transactions / Open Financial Exchange (*.OFX, *.QFX)".  (If you have associated Fund Manager with the .QFX extension you can also just double click on the .QFX file.)  Select the file you downloaded, choose all accounts, all dates, and make sure it is set to import into FM portfolio "With Matching Account Number as OFX Account".  Usually you would leave on the option to skip transactions already in FM, and create new investments as needed.

Reconciling

1. Open the Reconciliation Wizard and choose the account to reconcile (or right mouse click on a sub-portfolio, and choose "Reconcile...")
2. For the "Reconciliation Statement Source" choose "Open Financial Exchange File (*.OFX, *.QFX)".  Browse to the .QFX file you downloaded from Merrill's website.

Return to the FAQ.