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.
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.
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)
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"
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.
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
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.
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
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.