Net Worth amount is different in two appearances
After upgrading to v2011r2 I note the 'Net Worth' that appears in the bar at the top of the window is 6 UK pence more than the 'Net Worth' that appears lower down the Home Page.
I run a different money application on my smartphone, quite seperate with no synchronising, and the Net Worth on there agrees with the Moneydance 'Net Worth' lower down the Home Page,
So it appears that the 'Net Worth' at the top of the window is 6 pence over.
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
1 Posted by Ben Spencer on 28 Oct, 2011 03:03 PM
Are any of your accounts marked as inactive?
Ben Spencer
Moneydance Support
2 Posted by -Kevin N. on 28 Oct, 2011 03:51 PM
Hi Peter,
It appears that the Net Worth graph seems to be calculated with a 'This Year' date parameter but the Net Worth amount that appears on the Home Page seems to be calculated as 'Year to Date'.
I may be 100% wrong about this but this slight variance in the date range may have something to do with the discrepancy.
-Kevin N
3 Posted by Peter S on 28 Oct, 2011 08:58 PM
Hello Ben
I did make some accounts 'inactive', but I have now remade them 'active' and checked their balances are all at zero.
The difference remains at 5 pence.
Kind regards
Peter S
4 Posted by Peter S on 28 Oct, 2011 09:16 PM
Hello Kevin
I have just tried the Net Worth graph facility in Graphs & Reports. The final figure on that graph agees with the 'Net Worth' amount lower down the home page (i.e., just above Exchange Rates). I am sure this figure is the correct one, it agrees with my mobile phone application. (If I hadn't had that, I probably wouldn't have noticed this difference in totals for some time!).
The 'Net Worth' amount at the top of the Home Page is still 6p more and remains the same regardless of the settings of the accompanying graph (i.e., This month, This year, All dates).
I am certain this issue started after the Update.
All for 6 pence?! ;-)
Kind regards
Peter S
5 Posted by -Kevin N. on 28 Oct, 2011 09:22 PM
Hi Peter,
I honestly have rarely used the New Worth graph. I opt for the Buget Status View.
However, upon loading the NW graph, I can see a difference of .26 USD more on the NW graph than on the Home Page total.
Odd indeed.
-Kevin N.
6 Posted by Ben Spencer on 28 Oct, 2011 09:33 PM
I have not been able to reproduce the problem. Could one of you make an example data file that shows the problem?
Ben Spencer
Moneydance Support
7 Posted by -Kevin N. on 28 Oct, 2011 09:56 PM
Hi Ben,
I tried to recreate this issue in a new data file but I can not.
But just so you don't think I'm 1 bottle short of a six pack, I've attached a screenshot of my personal data file.
-Kevin N.
8 Posted by ljb on 28 Oct, 2011 10:46 PM
My 2 cents - actually 5 cents, which is how much my net worth figures disagree between the Net Worth graph and the Net Worth on home page display.
I played with it a bit and found that the discrepancy is coming from investment accounts - not bank, asset, or credit card accounts. And it isn't one account, or one transaction. It's seems to be a cumulative error.
I cannot duplicate it with a from-scratch data file, so it takes more transactions than I am willing to try. But it is real. My speculation: the two calculations are doing round-off differently, and there is a small accumulated discrepancy. Which makes sense, since investment accounts are the only place you could get sub-penny items (security price x number of shares, both with more than 2 decimal places).
9 Posted by -Kevin N. on 28 Oct, 2011 11:02 PM
Hi All,
I think that Peter S may be on to something when he stated that " I am certain this issue started after the Update."
I've attached a screenshot of the same data file shown in post # 8 except I opened it with MD 2010r3 Build (757)
There is no discrepancy.
HTH -Kevin N.
10 Posted by Peter S on 28 Oct, 2011 11:45 PM
Hello all
It seems the 'Net Worth' amount at the top of the Home Page is the only appearance wrong.
How is this item calculated in the software?
I've now tested several different reports and the resultant Net Worth is always the same & correct. I've even added up all the items on the Home Page, with a calculator??!! And that is correct.
The Net Worth amount at the top of the Home Page seems the only appearance 'out of step'.
Kind regards to all contributing.
Peter S
11 Posted by Peter S on 29 Oct, 2011 11:57 AM
Hello Ben
With reference to ljb's post 28 Oct, he seems to be on the case. I also have investment accounts.
My finances are in UKP except for some IBM Corp stock. This account is in USD together with categories that feed it. On the Home Page IBM is valued in USD, but within the stock it is valued at UKP, the same valuation as before the upgrade,
No currency conversion updates have been done since 23 Sep., well before the Moneydance upgrade, and the UKP valuation of IBM Corp stock is the same as before the Moneydance upgrade..
It is still strange that the two 'Net Worth' amounts displayed on the Home Page are different? There must be a difference in the way each one is calculated?
Best wishes to all. Enjoy your weekend.
Peter S
12 Posted by Ben Spencer on 30 Oct, 2011 07:52 PM
It might be a refresh issue with the net worth shown in the top bar. If you close and reopen the program is the difference still present?
Ben Spencer
13 Posted by Peter S on 30 Oct, 2011 09:56 PM
Hi Ben.
I have had refresh issues of the top appearance in the past, after working on investment accounts.
However, I have been closing & opening this program several times since I started this conversation, and I have added some transactions (not investment accounts).
The top appearance is still 6 UK pence over.
Kind regards
Pete Soper
14 Posted by Peter S on 05 Nov, 2011 12:00 AM
Hello Ben
And there's more . . . . . !
I have just been manually updating the today unit values of all my 16 Investment Accounts. Within the Accounts there are numbers of units, and prices, going into 2,3, or 4 decimal places.
As I did this excercise, after updating each Investment Account, I checked the two Net Worth totals. I noticed that the top appearance difference started to decrease from 6 UK pence OVER to 5, then 4, then 2. For about 3 Account updates it was the same. Then it went 1, 2, then 3 UK pence UNDER. The direction of the change in the difference was always the same.
The lower appearance still always agrees with the application on my smartphone.
The top appearance of Net Worth is now 3 UK pence under.
(Incidentally, after updating each Account, to get the updated Net Worth, I had to refresh the top Net Worth value by clicking on 'Net Worth' & then clicking on one of the items, (This month, This year, All dates). The lower appearance was always updated OK).
Kind regards
Pete Soper
15 Posted by rock.house on 05 Nov, 2011 10:22 AM
Mine is showing a 2 pence difference. I have both investment and Euro accounts. It is not a refresh issue either.
16 Posted by ljb on 05 Nov, 2011 09:50 PM
There is a refresh issue, but it is unrelated to the problem. Starting with 2011r2, the net worth displayed in the "dashboard" is calculated in the background (per the release change log). So depending on what else you are doing in Moneydance, and how much has to be processed to get the net worth, updates to the displayed value might lag behind by a variable amount of time, or be updated too quick to notice.
17 Posted by rock.house on 05 Nov, 2011 10:28 PM
Why does the total show incorrectly on launch where no transactions have been updated?
18 Posted by northern dancer on 29 Nov, 2011 01:56 AM
I’ve just manually entered all of my Quicken data into the Moneydance software I bought a week or so ago. We live in the US and use USD as our base currency, but also enter bank, investment, and credit card transactions in CAD. We need to see our total net worth expressed in USD.
There is a $827.99 discrepancy between the Investments total displayed on the Home Page and the total I calculated in Excel. Two of our investment accounts are denominated CAD and hold only CAD-denominated securities. When I convert the two CAD accounts to USD at the October 31 rate (1.003 US $ per CDN $) rate, the Excel total is $827.00 more than the total shown on the Home Page.
I have triple-checked to confirm that I set up the accounts in CAD, and that the currency for each security in the accounts is CAD. I can’t recall whether I did that before or after I entered the Buy transaction during the conversion from Quicken.
I have also checked the totals for all the other mixed accounts: Bank, Savings, Assets, Credit Card. They come out right; there’s no discrepancy between what the Home Page shows and what I get when I do the conversion and add it up in Excel. And finally, I used the Translate Currency tool to confirm that the prices for each CAD-denominated security are being correctly converted into USD at October 31's 0.997 US $ per CDN $.
Could you tell me what I’ve overlooked? Or perhaps this is a bug?
Thank you for your help with this. Apart from this currency thing, I really value how easy this software is to use.
19 Posted by Peter S on 16 Dec, 2011 06:05 PM
Hi Ben
If it helps any . . . . ?!
Since my post of 5 Nov, I have been adding many transactions (not to stock entries)and there has been no change to the diference of 3 pence.
As previoulsy mentioned, I use UK pounds but I have one stock in US dollars. I have just revised the USD/UKP exchange rate manually, and also revised the value of the US Stock in USD. Again, there was no change to the 3p difference.
I will be doing a revision of all my stock values shortly. I'll let you know if anything changes again.
Wishing all contributors & readers a very Merry Christmas!
Pete
20 Posted by Peter S on 27 Dec, 2011 05:36 PM
Hello again Ben.
Another if it helps . . . . .?
I note the difference of the top appearance has gone down from 3 UK pence lower to 2 UK pence lower.
On 24/12/11 there was an automatic Exchange Rate update on the US Dollar.
The change is in the table attached. I also note the title value is only 6 decimal places against 8 decimal places in the table.
Best wishes.
Pete
21 Posted by Jamie on 27 Dec, 2011 06:45 PM
I seem to have the same issue, but there are no currency issues here, i'm all USD. I noticed that the Net worth graph gives a different value depending on All Dates, This Month, or This Year selected, and these may or may not differ from the value calculated by the Net Worth Homepage section. See the attached screenshots.
22 Posted by Peter S on 27 Dec, 2011 08:14 PM
With regards to Jamie's post #22, I have just checked my amounts displayed with the home page header graphs of Net Worth > This Month, This Year, All Dates.
In my case, it is identical in all three cases with, like Jamie, a six figure sum.
Kind regards
Pete
23 Posted by Angie Rauscher on 06 Mar, 2012 06:46 AM
Hi all,
I'm sorry for the long delay in our response. We haven't been able to re-create this issue with our testing data files, so it's been a tough one to diagnose. Are any of you willing to send along a data file to assist with this? It might work if you strip out all accounts aside from the investment account from the file, if this is truly the source of the issue. If any of you are willing to do so, you can send this file to us securely at support (at) moneydance (dot) com , with the subject line "Net Worth amount is different in two appearances- sample file".
Thanks for the work you've all done to help diagnose this sticky issue,
Angie Rauscher
Moneydance Support
24 Posted by northern dancer on 06 Mar, 2012 09:38 PM
Dear Angie,
Thanks for including me on this email, but my problem isn't that the net worth is different in two appearances.
My problem is that we have investments denominated in both $CDN and $US. We established separate accounts for the $CDN investments, and maintain correct CDN currency data. However, the Investment Account summary on the Home Page just adds up the values of all of our investment accounts without converting the $CDN to $US. To get our true Investment Accounts total, I need to do the conversion myself and add up the different account totals. (I haven't even checked the Net Worth calculation!)
If you can help with this, please do.
Thanks,
Elisabeth
Elisabeth S. Graham
Mobile 415-407-3291
Alternate, no voicemail 415-332-6627
43 Cypress Place, Sausalito, California, 94965
[email blocked]
25 Posted by Peter S on 07 Mar, 2012 11:36 PM
Hello Angie
I've sent a file as requested to you at the email address requested.
Good luck!
Kind regards
Pete Soper
26 Posted by Ben Spencer on 24 Jun, 2012 09:27 PM
I think this is being cause because the net worth at the top of the screen is calculating the amount overtime using the transaction history and the security/exchange rate history, where as the net worth shown on the home page is using the current price on security and exchange rates. Either a small rounding error is creeping in or there is a discrepancy between the most recent price in the history table and the current price. Either way I have filed a bug report.
System closed this discussion on 31 Mar, 2015 03:40 PM.