Home → Suggestions →

Net worth report

• Edit

jrduke1

04 Jul, 2011 08:28 PM

Is it possible to have an option to turn off the sub totals in a net worth report? I copy the report to a spread sheet and the way I use the info I have to manually delete the sub totals in order to get what I need.

Jerry D

1. 1 Posted by -Kevin N. on 04 Jul, 2011 09:15 PM

   

   Hi jrduke1,
   It appears the only way to do so is to uncheck 'Include security balances'.
   HTH -Kevin N.

   • Edit

2. 2 Posted by jrduke1 on 04 Jul, 2011 11:22 PM

   

   Thanks Kevin,
   I don't have that checked. What I need is to be able to eliminate all subtotals for all accounts in the net worth report. Is this the right place to ask the developers to add an option?

   Jerry D

   • Edit

3. 3 Posted by -Kevin N. on 05 Jul, 2011 02:02 AM

   

   Moneydance 2011-rc3 (788)
   OS: Windows Vista 6.0 x86
   Java: 1.6.0_26 (Sun Microsystems Inc.)

   Hi Jerry,
   That's odd. I only get subtotals when I have that option checked. Unchecked I get the Account and the Amount only.
   If you don't mind me asking, what is it that you're trying to create in the spreadsheet?
   -Kevin N.

   • Edit

4. 4 Posted by jrduke1 on 05 Jul, 2011 03:30 AM

   

   All that check box does is show balances for my individual stocks. Unchecked I still get sub totals for my bank accounts, and credit accounts.

   I have a trust A and a trust B in the spread sheet. I total the A and B columns. The total is way off with sub totals added in. As a result I have to manually delete all of the sub totals to get the correct bottom line.

   Jerry D

   • Edit

5. 5 Posted by -Kevin N. on 05 Jul, 2011 03:56 AM

   

   Hi Jerry,
   Are you using MD2011? The latest build is currently (791)
   Maybe the reports act differently in different builds.
   I'm using (788) because 'Automatically Merge Downloaded Transactions' in Preferences is disabled in (791).
   I can't think of any other reason why the reports would act differently.
   -Kevin N.

   • Edit

6. 6 Posted by jrduke1 on 06 Jul, 2011 01:22 AM

   

   I'm using the latest build on an intel core duo mac 10.6.8

   Jerry D

   • Edit

7. 7 Posted by Ben Spencer on 06 Jul, 2011 02:21 AM

   

   Can you show me a screen shot of what you get when you run the net worth report.

   Also can you select Help->Console Window and copy and paste the output to this discussion.

   Ben Spencer
   Moneydance Support

   • Edit

8. 8 Posted by Noname on 06 Jul, 2011 02:40 AM

   

   Here's a thought: Do you have parent/child accounts? I notice that those get subtotaled in the report.

   • Edit

9. 9 Posted by jrduke1 on 06 Jul, 2011 06:08 PM

   

   Yes, I do have parent/ child accounts. The sub totals that show up in the net worth report are the onex I would like to have an option to be omitted from the report. It's the parent/child accounts that causes the sub totals to show up. Of corse there isn't any sub total if all accounts are individual.

   I''m reluctant to send a screen shot. If you set up accounts as parent/child you will see what I mean.

   Jerry D

   • Edit

10. 10 Posted by Ben Spencer on 07 Jul, 2011 03:15 AM

    

    I am afraid there is no way to turn of subtotals for parent child accounts in the Net worth report. All parent accounts effectively have two balances - the sum of the transactions that are directly in the parent register and the recursive sum of all children plus the parent. I have created a suggestion ticket in our issue tracking system proposing that an option be added to disable subtotalling however I think it is unlikely to get implemented.

    I am sorry that this does not meet your needs.

    Sincerely
    Ben Spencer
    Moneydance Support

    • Edit

11. System closed this discussion on 31 Mar, 2015 03:36 PM.