Program does not calculate net worth correctly

Cindy's Avatar

Cindy

11 Feb, 2019 01:24 PM

It seems that no matter what I do, Moneydance insists on adding liabilities to assets to calculate net worth, when liabilities should be subtracted. I tried reversing the entries only to get the exact same result. Net worth is NOT assets plus liabilities.

This forces me to copy and paste reports so that I can correct them, but the formatting and liabilities disappear and that is the same as forcing me to manually calculate and produce the Net worth and balances reports.

Why is this basic accounting procedure so difficult to produce correctly?

  1. 1 Posted by Cindy on 11 Feb, 2019 01:30 PM

    Cindy's Avatar

    The "help" section shuttled me off to view the summary page, but in the example given, Net worth is calculated inaccurately there as well! How can anyone trust this software?

  2. 2 Posted by jeff_l on 12 Feb, 2019 07:29 AM

    jeff_l's Avatar

    Hi Cindy,

    Not sure how you have your Summary Page arranged, as by default the program does not always display all the available accounts.

    If you go to:- File > Preferences > Summary Page, (or Moneydance > Preferences > Summary Page on the Mac) Look in the top box, available Items, Make sure any Debit/Credit accounts there are Added to the left hand box below.

    The best way to arrange them is say have all the relevant positive & negative accounts at the top with the Net Worth item at the bottom. That way, I think you will find your Net Worth is accurately displayed.

    Jeff – Fellow User

  3. 3 Posted by dwg on 12 Feb, 2019 08:00 AM

    dwg's Avatar

    I'm a fellow user.

    Issues around liability accounts have come up before, and a significant number of users have disagreed with the way Moneydance handles them, personally I think it is done wrong.

    The following is an older discussion about it and the responses received.

    http://help.infinitekind.com/discussions/general-questions/34367-liabilities-2nd-time-posting

    As I see it in Liability accounts you enter transactions in a way that is opposite to what you expect. In Moneydance it adds assets and liabilities together so to get it to work liabilities have to be a negative amount, While I do not have a problem with that I think the column labels in a liability account are misleading.

  4. 4 Posted by mawigmore on 12 Feb, 2019 08:42 AM

    mawigmore's Avatar

    I find that if I click on Net Worth on the summary page, the table it shows has a different total. How can that be?

  5. 5 Posted by dwg on 13 Feb, 2019 05:58 AM

    dwg's Avatar

    I'm a fellow user.

    When you click on the Network figure in the body of the summary page the report that displays for some reason includes the value of all accounts including those marked as inactive. I would take a close look at what accounts are listed in the report I found two inactive accounts listed (yes they are suppose to exist but the value is not included in my normal net worth).

    The report I believe is wrong.

  6. 6 Posted by mawigmore on 13 Feb, 2019 08:01 AM

    mawigmore's Avatar

    I have looked carefully at the list of accounts in the popup report box and there are no inactive accounts. What I have noticed is that the valuations of my three Investment Accounts are all wrong. They don't agree with the valuations given on the Summary page, which do agree with the individual Portfolio pages. I also notice that the Net Worth Graph also has this erroneous total.

  7. 7 Posted by dwg on 18 Feb, 2019 04:21 AM

    dwg's Avatar

    The other thing I have noted is that when clicking on net worth on the summary page it appears to use whatever parameters were set on the network report that is on the side bar the last time it was used, hence you could get anything.

Reply to this discussion

Internal reply

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

Attaching KB article:

»

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

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