[GNC] Reports indentation

[Adrien Monteleone]

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 <ndm.mackay at gmail.com> 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
> gnucash-user at gnucash.org
> 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.