Maddy on 19 Oct, 2019 04:20 PM
We are sorry to hear about the problem you have encountered.
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.
Can you let me know which bank you wish to connect to?
Moneydance supports automatic downloads via Direct Connect, and you can view a list of financial institutions that support this feature here.
If your bank is listed, you can set this up within Moneydance by navigating to Online --> Set Up Online Banking. Then select 'New Connection' and choose your financial institution from the list.
Most banks require that you contact them to enable Direct Connect before you can download your data from within Moneydance. When you do this, you'll be given the login credentials you need to connect. Generally, these login details differ from those used for ATM or online banking. You can find the steps for setting this up outlined in this article.
If your bank does not support Direct Connect, you are still able to easily import your data into the program. The best way to get your files 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 (aka Quicken or MS Money files), any of which will import cleanly into Moneydance. You can find the steps for manually importing your data in this article.
You can also open your banks website directly from Moneydance by selecting Online --> Open Account Website, which makes the download process easier.
I hope this information is helpful. Please let me know if you have further questions or need any assistance.
Thanks for the reply. I am using Quicken 2019 on a subscription basis. I
want to move because of their insistence that you must be a subscriber. No
longer can I upgrade every three or four years. I need to pay them every
year - grrrrrrrrr! I've been using Quicken since it was a DOS program.
Now I want to be finished with them.
Reading on your website I see that Q2019 is not suitable for importing into
Moneydance. Should I reload an older version of Quicken and try to import
my current (2019) data so I can then import QIF files into Moneydance? I'm
not sure Quicken will do that - move data to an older version???
Your program sound very interesting and useful to me however my bank won't
connect with you (or the other way around) in order to write checks locally
and transmit them to the bank for payment. That means double entry for me.
I can export transaction from the bank to my laptop in various file
formats. (Quicken now imports transactions from the bank (cleared checks)
and I can match them with entries I've made locally.
Without an easier way to get my history into Moneydance I'm feeling very
cautious and not eager to try for fear I will screw something up beyond
Maddy on 22 Oct, 2019 01:55 PM
You should export your data from a version of Quicken allowing QIF file format. If available, use the option to export all accounts within one QIF file, as this makes the import process easier. Then, follow the steps outline in my earlier post.
In regards to future downloads from your financial institution, please note:
by only using Direct Connect, we can guarantee that your username, password and financial data only ever exists with your bank or on your own personal computer, and at no point are your details stored on another server.
You can read more about why we only support this connection type in our blog and also in this article.
Without Direct Connect, you are still able to easily import your data into the program. The best way to get your transactions into Moneydance is to use a web browser to download files from your bank's web site.
We'd recommend you download using the OFX or QFX file format if available. If not, use the QIF file format. (These files are sometimes referred to as Quicken or MS Money files). You can import the files to Moneydance using File --> Import.
The steps for manually importing your data are outlined in this article from the knowledge base.
Moneydance 2019 includes en embedded browser (currently a beta feature) that makes downloading from the banks website much easier. We're also working on another feature (coming soon) that will remember how you download from the banks site and help to automate the manual import process.
Please keep us posted on your progress and do not hesitate to get back in touch, if you need additional information.