Home → Problems →

Net Worth calculation logic change in MD2024.3(5219)

• Edit

Stuart Beesley (Mr Toolbox)

12 Feb, 2025 07:34 PM

This is a thread for users upgrading to 2024.3(5219) who see a changed net worth (NW) value from previous versions.

MD’s NW calculations have all been fixed/aligned between the Summary Screen NW widget and top menu bar mini NW graph, and also the NW Report and NW Graph.

One key change is that it now includes inactive accounts (that had a balance).. These were previously excluded..

You can now permanently exclude accounts from NW calculations using tools/accounts/edit and UNTICK the include in NW flag.

There is also a little up/down config arrow you can click to further config the NW calculation on the widget and mini-graph, but this should not be necessary.

Do post issues and also whether setting this flag resolves the issue for you.

Also, for advanced purposes. You can go to help/show console, then click (…) and enable NW logging. This then adds extra NW debugging information into console. But don’t do this unless really necessary.

1. 1 Posted by Stuart Beesley ... on 14 Feb, 2025 02:13 PM

   

   Now there’s a KB article too:

   https://infinitekind.tenderapp.com/kb/accounts-and-categories/net-w...

   • Edit

2. 2 Posted by Rosie on 17 Feb, 2025 02:38 AM

   

   That logic change made my net worth off by $90 million!!! I imported to Moneydance from Quicken last year, so inactive accounts that should have been zero show up as having crazy high value. I've fixed it now by using the steps above. Maybe this "upgrade" worked find for folks who have used Moneydance from the get go, but not for me.

   • Edit

3. 3 Posted by dtd on 17 Feb, 2025 02:45 AM

   

   You are not alone.... I had a few million due to the move from Quicken to MD in 2021, but I had already zeroed them out (by creating a Quicken Garbage category.... :) )

   The addition of inactive accounts was necessary to fix issues with Net Worth calculations, specifically net worth history values.

   • Edit

4. 4 Posted by dtd on 17 Feb, 2025 02:47 AM

   

   Obviously, given the added click box, this issue was anticipated, and a solution provided.

   • Edit

5. 5 Posted by dwg on 17 Feb, 2025 02:54 AM

   

   The various net worth figures you could see in Moneydance have been problematic for a long time, people have taken various measures to get the "right" figure in what they are displaying.

   The changes made have been to get consistency across the whole application, for some it may mean a one-off change.

   Hopefully though, it means we can say goodbye to explaining the differences between the various Net worth "figures" that people could see and people being confused by them in the first place.

   • Edit

6. 6 Posted by Stuart Beesley ... on 17 Feb, 2025 06:32 AM

   

   I agree. Personally I would get all those quicken inactive accounts with balances zeroed out somehow, possiblly to a “quicken garbage” category as @dtd suggests.

   • Edit

7. 7 Posted by Stuart Beesley ... on 19 Feb, 2025 06:01 AM

   

   [script removed - see toolbox post below]

   • Edit

8. 8 Posted by Stuart Beesley ... on 19 Feb, 2025 11:04 AM

   

   I have now built this feature into the latest toolbox (preview build 1068). Available here:

   https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sign...

   Accounts Menu:
   

   DIAG: Show all inactive accounts that are included in Net Worth calculations (MD2024.3 onwards)
   

   with update mode:
   

   FIX: Exclude all inactive accounts from Net Worth calculations (MD2024.3 onwards)
   

   You can safely run the DIAG - it's read-only. The fix will of course change data. But also note that undo mode is on so that you can use Edit/Undo to reverse this change.

   Let me know if you use this?

   • Edit