Transfering data to new file

Susan's Avatar

Susan

29 Jan, 2020 12:58 AM

I have a huge file of data that was originally transferred from Quicken (20+ years) and it's just too time consuming to open, save, switch, etc. I like to have the old data to search through for old purchases for warranties, house expenses, etc. I thought I could extract 1-2 years worth of data to a new smaller file, leaving the large file for historic purposes. There are about 15 accounts I want to work with.

I tried exporting the entire database from 1/1/19 on but that didn't work correctly; balances were off and I've had to delete a bunch of old accounts that have not been active since 2019.

 I tried exporting a single account and importing that but I don't have all the categories and the account types were all off.

Is there a recommended way to do this, creating a new file with more current data?

  1. Support Staff 1 Posted by Maddy on 29 Jan, 2020 02:54 PM

    Maddy's Avatar

    Hi Susan,
    Thank you for contacting Moneydance support.

    • 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.

    I hope this information is helpful. Please let me know if you have further questions or need any assistance.

    --
    Maddy, Infinite Kind Support

  2. 2 Posted by Susan Barnhart on 29 Jan, 2020 05:42 PM

    Susan Barnhart's Avatar

    Hi Maddy - I think I'm all set. The file I was trying to split into an
    archive and current was a Moneydance file that is a couple of years old.
    Originally I created the large file from an exportbfrom quicken. Last
    night I worked on it for a while. I exported the Moneydance data from
    1/1/19 on and imported into a new Moneydance file. I deleted any account
    that I no longer used. Then with a report from the old Moneydance file I
    determined the value of each account as of 12/32/18 and adjusted the
    starting balance of the accounts in the new file. Then I had to re-enter
    all the reminders. The new file loads and closes much faster which was my
    intent and I have all my historical data in the old file.

    My only suggestion would be to add an export capability for the reminders.
    That was laborious. I ended up taking a screenshot of each reminder to
    enter into the new file. It took most my the night.

     - Susan

  3. Support Staff 3 Posted by Maddy on 29 Jan, 2020 06:07 PM

    Maddy's Avatar

    Hi Susan!
    I'm very pleased to hear that. Also, Thank you for your suggestion.
    I'll close this discussion for now, but do not hesitate to contact us again, if you need further assistance.

    --
    Maddy, Infinite Kind Support

  4. Maddy closed this discussion on 29 Jan, 2020 06:07 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