Report totals

Norma Leask's Avatar

Norma Leask

14 Feb, 2018 01:17 AM

Hi.
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?

    Norma

      _____

  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"
    eventually?

    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:

    http://infinitekind.com/preview

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

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

        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.

    Norma

      _____

  10. 10 Posted by Norma Leask on 18 Feb, 2018 05:44 PM

    Norma Leask's Avatar

    I thought I would let you know that I finally figured out the issue. I set
    the account in Canadian dollars when I opened it, but the "base amount" by
    default was in US. I tried redoing the account as if in US dollars and all
    was fine with the total, but I then went in and changed the base currency
    and that corrected all the report totals. Since I had imported all my data
    from Quicken, I assumed the currency would have been in Canadian dollars.
    Now I know.

    I did notice when doing a split transaction that the "rate" from Canadian to
    US was just below $1 and the reverse was just above, so I assume the
    original report took my Canadian funds, converted to US and then back and a
    small bit was "lost" during the process. Does this make sense? Since I reset
    the base currency the rate now is listed at 1.

    I hope my "ah ha" will be of help to other canadian users who import their
    existing data.

    Norma Leask

      _____

  11. 11 Posted by dwg on 18 Feb, 2018 08:40 PM

    dwg's Avatar

    I think it may have been the closeness of the USD/CAD rate that threw everyone.

    It is not uncommon to see this sort of problem and a confusing report, but the rates are usually far enough apart for the problem to be apparent. In the reports it is common for MD to report the individual transactions in the account currency and then the total in the base currency so that the totals all roll up in the base currency.

    QIF files do not have a currency indicator in them (there is nothing in the spec for currency handling), so Moneydance has no idea what the currency is, hence depending on how the QIF data is imported i.e. all data in one QIF file or data in multiple QIF files changes how it is imported when multiple currencies are involved.

  12. System closed this discussion on 20 May, 2018 08:50 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