Feature Request: Subtotals in Reports

Brainstorm
1

I have a suggestion for an improvement for the reports, especially Income and Expenses.
I would like the ability to add subtotals for certain Accounts.

Example: Our organization holds 2 events per month.
In the Chart of Accounts, they are setup like this:
Income
Event Income
Event 1 Income
Pre-Registration
Door Admission
Event 2 Income
Pre-Registration
Door Admission

In the current Income and Expenses report, all of these levels are reported,
but with a subtotal for only the top level of Event Income.
Event 1 Income and Event 2 Income appear in the report, but with zero values.

Event Income
Event 1 Income 0
Pre-Registration 100
Door Admission 25
Event 2 Income 0
Pre-Registration 150
Door Admission 35
Total 310

I would like subtotals for Event 1 Income and Event 2 Income also.

Event Income
Event 1 Income 0
Pre-Registration 100
Door Admission 25
Total 125
Event 2 Income 0
Pre-Registration 150
Door Admission 35
Total 185
Total 310

One possible way to do this is to add a “Subtotal” checkbox to Account settings.
If it is checked, the Report will output a subtotal for this Account and all its children,
after the last child, as above.

2

Well, the indentation to show the parent-child relationships got stripped out, but I hope you understand what I mean. Here’s another attempt to show that.

Chart of Accounts:
Income
   Event Income
      Event 1 Income
         Pre-Registration
         Door Admission
      Event 2 Income
         Pre-Registration
         Door Admission

Report:
Event Income
   Event 1 Income 0
      Pre-Registration 100
      Door Admission 25
      Total 125
   Event 2 Income 0
      Pre-Registration 150
      Door Admission 35
      Total 185
Total 310
3

It sounds like you want to organize your report by Categories rather than Accounts.

4

Oops, I meant adding a “Report Subtotal” checkbox to the CATEGORY settings, not the Account settings.
The Income report already organizes the data by Categories.
I am just asking for a way to add subtotals wherever I want.