Even with your example, the Income and Sales amounts should be further to the
right. I agree, child account amounts should be on the left and
parents/subtotals/totals should be on the right.
Try this in your report options:
Set Parent Account Balances to ’Subtotal’
Set Parent Account Subtotals to ‘Do Not Show’
This will produce the following:
Revenues R0,00
Income R0,00
Interest Income R0,00
Other Income R0,00
Sales R0,00
Consignment R0,00
Consignment R0,00
Core Business R0,00
Biltong R0,00
Miscellaneous R0,00
Total Revenue R0,00
This will give you all parent totals to the right of their children, however,
you do get a duplication with the grand totals for each section (revenues,
expenses)
If you chose to show subtotals, you’d get duplication there as well.
Personally, I prefer these settings:
Parent Account Balances to ‘Account Balance’
Parent Account Subtotals to ’Show Subtotals’
I also set Omit Zero Balance figures and Show Accounting Style Rules.
This produces the following:
Revenues
Income
Interest Income R0,00
Other Income R0,00
Sales R0,00
Consignment
Consignment R0,00
Total Consignment ----- R0,00
Core Business
Biltong R0,00
Miscellaneous R0,00
Total Core Business ----- R0,00
Total Sales ----- R0,00
Total Income ----- R0,00
Total Revenue ----- R0,00
The totals are always to the right of the children and are made more obvious
with the lines. While there is duplication with the account names and
subtotals, the subtotals stand out more and are easy to spot and read.
Note, I also dropped the total for revenue and expenses simply to reduce
another instance of duplication as the revenue and expense accounts show their
own subtotals already.
Regards,
Adrien
> On Jul 19, 2018, at 12:10 PM, Nigel <[email protected]> wrote:
>
> I have looked for references to the problem via Google, but with no luck.
>
> My problem is with indentation in reports with accounts that have children. I
> feel that the parent should be indented further than the children, to give
> the correct hierarchy. That way, the entries in a column are the total of the
> entries in the column to the left (children.) This makes it a lot easier to
> read. In a way, it also causes display redundancy, where some values are
> displayed more than once.
>
> Of course, there may be significant problems in implementing this.
>
> I created a report with accounts that have children and children that have
> children. Formatted with borders in Excel to help visualise the situation.
> Sub-totals are switched off because they seem to cause even more
> "redundancy." Any account with children is a placeholder.
>
> Levels of Subaccounts is 4. This is what we get:
> Revenues
> Income R0,00
> Interest Income R0,00
> Other Income R0,00
> Sales R0,00
> Consignment R0,00
> Consignment R0,00
> Core Business R0,00
> Biltong R0,00
> Miscellaneous R0,00
> Total Revenue R0,00
>
> This is not right. The sub-total Core-business should not be in the same
> column as the children Biltong and Miscellaneous.
>
> This is how it should look:
> Revenues
> Income R0,00
> Interest Income R0,00
> Other Income R0,00
> Sales R0,00
> Consignment R0,00
> Consignment R0,00
> Core Business R0,00
> Biltong R0,00
> Miscellaneous R0,00
> Total Revenue R0,00
>
>
> Reducing Levels of Subaccounts to 3 you get:
> Revenues
> Income R0,00
> Interest Income R0,00
> Other Income R0,00
> Sales R0,00
> Consignment R0,00
> Core Business R0,00
> Total Revenue R0,00
>
> This is loss of one level of detail, which is correct.
>
> At any time one can look down a column and see only valid entries, not a
> total followed by what generated the total.
>
>
>
>
>
>
>
>
>
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> _______________________________________________
> gnucash-user mailing list
> [email protected]
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
