Reports

Gareth Mostyn's Avatar

Gareth Mostyn

11 Jan, 2020 02:23 PM

I have tried to run reports from Money dance having transferred 20 years of data over from Quicken.
I find that the some costs appear as negative income and some negative costs appear as positive.
I cannot find how I change these settings.

Can you help me?

Thanks

Gareth

  1. 1 Posted by Andrew on 17 Jan, 2020 03:59 PM

    Andrew's Avatar

    Hi Gareth,

    We are sorry to hear about the problem you have encountered.

    • To transfer your data from Quicken, you should export your accounts in the QIF file format.

    It is highly recommended to export all data into a single QIF file, as this makes the import process much smoother. Use the option in Quicken to export "all accounts" if available.

    You can then follow the steps in this article to import the QIF file to Moneydance.

    • We would recommend downloading the latest version, Moneydance 2019.3 (1880) from here, if you haven't already.

    • In order to fix the issue described, you need to make sure you select the"Ignore Transaction Types in Favor of Amount Signs" checkbox, in the Network tab of the Preferences.

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

    --
    Andrew, Infinite Kind Support

  2. 2 Posted by Gareth Mostyn on 07 Feb, 2020 01:39 PM

    Gareth Mostyn's Avatar

    Hi Andrew

     

    Thank you for your email.

    I have successfully downloaded my data from Quicken and I have been using it with no problems for the last six months

    My problem is that some of my expenditure appears as negative income and some of my income appears as negative expenditure.

    Can you tell me how to change that.

     

    I have had some difficulty bringing over a second set of accounts from Quicken. I will come back and ask you for some help on that at a later date. I had a few goes and wasted too much time so I am leaving it in Quicken for the time being. When I have resolved the first problem I will come back to address that. If you have any tips on ensuring the two sets of accounts do not overlap, that would be helpful, but I will not do it until I sort the first problem out.

    Thank you

     

    Gareth

  3. Support Staff 3 Posted by Maddy on 07 Feb, 2020 03:01 PM

    Maddy's Avatar

    Hi Gareth,

    • 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 this is not possible, you should export one QIF file for each account in your file. You should name each file so it's clear which account is contained within each QIF 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 one of your QIF files.

    The import window will appear, and you should see the name of the account you're importing (as it was displayed within Quicken).
    Highlight the account name, and check the account is displayed as the correct account 'type' (bank, credit card etc.), and also ensure the correct currency is used. If needed, you can amend the account type and currency within the import window by selecting these options to the right of the account name.

    Below the account names, Moneydance will automatically try to determine the date format and decimal character used within the QIF file.
    The 'Date Format' field should be set to the date format used in the QIF file, rather than the date format you used in Quicken or want to use in Moneydance.
    If you want to check these settings, 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 within the QIF file.

    When you're happy with the settings, choose 'Import' and wait for your data to populate into the Moneydance program.

    As you're just importing one account at a time, you'll see accounts that have transfers to/from the imported account are automatically created within Moneydance. These account balances will likely display discrepancies, but they will eventually correct themselves as you import the other QIF account files.

    Repeat these steps for each QIF file you have until all of your accounts have populated into Moneydance.

    If it appears some of your accounts are missing from the left side bar after importing, 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

  4. 4 Posted by g.mostyn on 09 Feb, 2020 05:40 PM

    g.mostyn's Avatar

    HI Maddy

     

    Thank you for your answer, but I think you did not understand my question.

    I have been using Money Dance for 6 months. If I reimport the data from Quicken I will loose the last 6 months of data that I have been entering on Money Dance. I do not want to reimport (although I have other accounts I will want to import in the future)

     

    No my current problem is twofold and is all about categories of income and expenditure. The first problem is the important one.

    1. A small minority of my spending categories (less than one in ten) are showing as income categories. Although there is an edit function against categories, it does not seem to do anything. How can I change a category from income to expenditure?
    2. Secondly the categories do not come in alphabetical order. I have about 95 categories and subcategories that go in alphabetical order and that it starts again 2 or 3 times with other categories presented in alphabetical order.

    a. Is there a way of making them all appear in the right order? Looking at it whether the category starts with a capital might be an issue

     

    Can you help me to get these categories to work properly so that I can produce some useful reports.

     

    Thanks

     

    Gareth

  5. 5 Posted by dwg on 10 Feb, 2020 03:47 AM

    dwg's Avatar

    I'm a fellow user.

    Once a category has been created it is not possible to change the type. You need to take an indirect approach to facilitate this. We need to create a new category of the correct type and move the transactions to this new category.

    As with any restructure you should take a backup before you start, but it is especially import here because any mistake can really damage your data.

    Firstly create a new category of the correct type. After doing this open the category you wish to change the type of, you do this by going to the category window through the menu command Tools → Categories, select the category then right click and in the drop down select “Open in New Window”.

    This displays a register window – but note this is a category register window not the account type registers you are used to working with. Select all transaction in this register, generally you can do this by selecting a transaction then using the keyboard shortcut CTRL-A (CMD-A on Mac)

    Now right click on the transactions and Select Batch Change. Select to Change the Account. (Yes Account this is not a typo) The software will then display a window where you can scroll down and select the Category to move the transactions to.

    After pressing the OK button the transactions will be moved.

    The original category should now be empty and you should be able to delete this category.

    They are in Alphabetic order but in the drop down they are initial grouped into Accounts, Income and Expense, so they are initially sorted by type and .there is no intermingling of types. Within Income and Expenses they are in Alphabetic order at the top level category with sub categories under each again sorted alphabetically.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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