Import Fidelity and Robinhood transactions

jsk's Avatar

jsk

16 May, 2020 02:49 PM

Hi,
I am new to MoneyDance and just leaving quicken behind after 10+ years of using it.
I am trying to setup a new set of accounts since Quicken file is already bloated and also contains data data and categories from MS Money era.
While setting up investments, I found that Fidelity direct connect works fine but it only imports last three months of data. Do I need to enter past data manually?
Also since it is a new set of data, I don't have records of fund transfer data aging at least 4-5 years. How can I manage those? Can I create temporary bucket from which I just transfer money to these institutions but doesn't display anywhere in the reports?

Also Robinhood is not listed for direct downloads. Can I please have OFX information so that I can download my transactions from there?

Thanks

  1. Support Staff 1 Posted by Ethan on 16 May, 2020 06:22 PM

    Ethan's Avatar

    Hello,

    Banks vary with how much transaction history they make available to customers through direct connections via programs like Moneydance. 90 days sounds fairly common, although I've seen this range from a month to several years. Moneydance will just ask for and take whatever the bank's servers are set up to send. You may be able to import previous history from farther back by logging into your bank's website to download and import OFX, QFX, or QIF files (sometimes called Quicken or MS Money files). The availability of this again varies based on the bank.

    For older transactions, you can either manually enter them, or enter in an initial balance for the account (by going to Account -> Edit Account from the menu bar) to bring your account balances up to date. For investment transactions that are not included in these downloads, you will likely need to manually enter in the initial purchases for proper investment tracking. One way to handle that would be to simply have the funds come out of that investment account, while increasing the initial balance to take into account those purchases. You can also create an extra account just for those initial purchases, but you'll have to remember to exclude that account from your reports, and you'll also have to enter in an initial balance for those accounts to make up for those funds.

    Unfortunately, it doesn't appear that Robinhood supports direct OFX connections, which Moneydance requires in order to talk directly to a bank. The best way to get your transactions into Moneydance is to use a web browser to download them from your bank's web site. You can download into QFX, OFX, OFC, or QIF files (sometimes referred to as Quicken or MS Money files), any of which will import cleanly into Moneydance. If your bank begins to support direct OFX connections in the future, we will be happy to work with them.

    Please let me know if I can be of further assistance,

    Ethan
    Infinite Kind Support

  2. 2 Posted by jsk on 17 May, 2020 01:33 PM

    jsk's Avatar

    Ethan,
    Thanks for your prompt response. I appreciate that.

  3. Maddy closed this discussion on 17 May, 2020 11:26 PM.

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