Report totals

Norma Leask's Avatar

Norma Leask

14 Feb, 2018 01:17 AM

When I generate an Income and Expense Report for a specific account (so I can view the specific amount allotted to specific categories) the total income does not match the sum of the individual categories. I find the breakdown is consistent with what I could produce in Quicken, but the total is always off. I have attached a sample of a report I produced today. I made a transfer of $23,500 to this GIC, balanced all the splits when doing so, but somehow end up with a balance of $23, 446.08, even though the account balance is listed correctly on the account summary. Where is the $3.92?
This is something I notice with all Income and Expense Reports.

  1. 1 Posted by sth on 14 Feb, 2018 03:30 PM

    sth's Avatar

    That is weird. If you adjust the dates by 1 day does it change? Maybe there is an issue of the included day for example transactions on 2/13/2018 are included or not? Maybe IK can take a look at the file and suggest something.

  2. 2 Posted by Norma Leask on 14 Feb, 2018 03:48 PM

    Norma Leask's Avatar

    I just changed the date to todays date and the result is the same. This
    seems to happen to all my reports. I thought perhaps it had something to do
    with the imported data from Quicken, but this specific account was zeroed
    yesterday, showed a zero balance on the report, then I transfered the funds
    in and set up a split to catagorize it.

    How do I send the file for you to look at?



  3. 3 Posted by sth on 14 Feb, 2018 09:08 PM

    sth's Avatar

    Norma, I was suggesting Infinite Kind (IK) look at the file. Not me, I am just a user like you. I can't think of what is going wrong and if the official help folks chime in here, they may be able to dig into what the issue is.

    The first question they will ask is what OS and version are you running on your computer? What version of MoneyDance are you using? And suggest updating to the latest release if it is an older one.

    I just checked on my income report for last year and though it has a lot more categories than yours it is correct to the penny.
    Mac OS X 10.11.6 (El Capitan)
    MD 2017.7 (1663)

  4. 4 Posted by Norma Leask on 14 Feb, 2018 10:14 PM

    Norma Leask's Avatar

    I had no idea you weren't with the IK support staff, sorry. Did I post on
    an open forum? When I read IK in your response I assumed you meant I can
    look at the file and you had just slipped on the keys. Thank you for your
    suggestion. How do I redirect my question to the IK support people? Do I
    just repost my original question and check the "private discussion" box or
    would they have the question already in their system and will "chime in"

    Thank you kind stranger.


  5. Support Staff 5 Posted by Tom Freeman on 14 Feb, 2018 11:04 PM

    Tom Freeman's Avatar

    Which version of MD are you using? Help > About MD

    If you are running MD 2017 I would suggest updating to the most recent build from here:

    If the problem is not resolved with the update can you please attach a screen shot of your income and expense report with the edit box open. And please let me know which OS you are running.

    Tom Freeman
    Infinite Kind Support

  6. 6 Posted by sth on 15 Feb, 2018 12:43 AM

    sth's Avatar

    Norma, yes this is an open user forum. Tom is official support staff as noted by the big bright orange bar. There are just some of us who try to answer some of the questions. That one caught my eye since it is so weird to be off on the printed totals.

  7. 7 Posted by Norma Leask on 15 Feb, 2018 01:29 AM

    Norma Leask's Avatar

    Hi Tom

        We are running Windows 10. The version of Moneydance is 2017. I
    installed it on January 26 for a trial and I just bought the licence
    yesterday. I tried to install the update, but got an error message, then the
    setup wizard appeared. I am not sure if I now have the most recent build
    installed. It is listed as Moneydance2017.7(1665). Is that correct? Sorry, I
    know my way around finances but am not very intuitive with computer

        The report is unchanged. I am not sure what you mean by "edit box open".
    Here is a screen shot of the report. There is no edit box on the report


  8. 8 Posted by -Kevin N. on 15 Feb, 2018 02:19 AM

    -Kevin N.'s Avatar

    Hi Norma,

    I'm following your post as it is so unusual.

    I'm curious if whether the Start Date of 12/31/1969 is playing into this issue. Since you're dealing with a 1 year GIC, perhaps changing the Start Date of the report to reflect the actual date that you acquired the GIC, it may correct the anomaly.

    -Kevin N. (not a member of MD support)

  9. 9 Posted by Norma Leask on 15 Feb, 2018 03:46 AM

    Norma Leask's Avatar

    Hi Kevin

        I played around with the start and finish dates on the report and the
    total still doesn't equal the sum of the parts. Thanks for trying.



Reply to this discussion

Internal reply

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

Attaching KB article:


Already uploaded files

  • MnyDcReport.doc 51.5 KB

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


? 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