Premium Plus feature: This feature requires a Premium Plus subscription. Trial users have full access to this feature but please note you will need to subscribe to Premium Plus to continue using this after your trial period is over. Existing Premium users can request a new 30-Day trial period for this feature – please raise a Support Ticket.
About Reporting Groups
Reporting Groups allow you to create advanced Financial Statements and sector-specific report layouts that some organisations require. Reporting Groups are an additional Parent/Cost Code attribute that are used to determine where transaction values appear in reports which utilize Reporting Groups.
Reporting Group Sets
Reporting Group Sets determine which Reporting Groups and advanced Reports are available to your organisation.
Currently, the following Reporting Group Sets are available:
- Standard: select for most clubs and organisations
- Charity*: select for charities that need to produce SORP style accounts
- Scout*: select for youth/scout groups that need to produce SORP style accounts
*Under construction
Reporting Groups
Each Reporting Group Set comes pre-populated with it’s own set of Reporting Groups.
Reporting Groups are used to determine the layout and structure of certain advanced Financial Statement reports (see below) and, by assigning Reporting Groups to your Parent/Cost Codes, provide you with more control over where transactions appear in the reports.
Reporting Groups cannot be added or removed, however, you can rename them to better match your organisation’s reporting requirements.
“Standard” Reporting Group Set
The Standard Reporting Group Set provides the following Reporting Groups which can be assigned to your Parent/Cost Codes. It currently provides a more advanced Income Statement/Profit and Loss reporting layout required by larger commercial, non-charitable organisations.
The following Reports are available with the Standard Reporting Group Set:
1. Financial Statements > Income Statement (Standard Reporting Group)
Standard Reporting Groups*
- OPERATING_INCOME (Receipts) = Sales and revenues generated by your organisation’s core activities
- OTHER_INCOME (Receipts) = Other income received by your organisation, eg. Bank Interest Received
- COST_OF_SALES (Payments) = Costs and expenses incurred as direct result of your organisations core activities
- OPERATING_EXPENSES (Payments) = Other running costs and general overheads incurred by your organisation
- INTEREST (Payments) = Interest paid, eg. Bank charges
- TAXES (Payments) = Taxes paid, eg. Corporation Tax
- DIVIDENDS & DISTRIBUTIONS (Payments) = Distributions to owners or shareholders out of Net Profits
- CAPITAL_EXPENDITURE (Payments) = Capital Asset purchases using depreciation. Excluded from Profit & Loss Account
- INCOME EXCLUDED FROM PROFIT & LOSS (Receipts or Payments) = Receipts or Payments are not included in Profit and Loss Report
*All Standard Reporting Groups can be renamed
Advanced Income Statement Layout Example
Operating Income £20,000
Cost of Sales (£12,000)
—————————————————–
GROSS PROFIT £8,000
—————————————————–
Operating Expenses (£2,000)
Other Income £500
—————————————————–
PROFIT BEFORE INT & TAX £6,500
——————————————————
Interest Charges £0
Taxes (£1,000)
—————————————————–
NET PROFIT £5,500
—————————————————–
Dividends (£2,000)
—————————————————–
RETAINED EARNINGS £3,000
—————————————————–
“Scout” Reporting Group Set
The Scout Reporting Group Set is designed for Scouting and other youth group organisations that need to produce an income statement/profit and loss report by Fund type, following scouting group guidelines.
The following Reports are available with the Scout Reporting Group Set:
1. Charity Reports > Scout – Receipts & Payments by Fund Type Report
Scout Reporting Groups*
- MEMBERSHIP_RECEIPTS (Receipts)
- INVESTMENT_INCOME (Receipts)
- DONATIONS_GRANTS_RECEIPTS (Receipts)
- ACTIVITIES_RECEIPTS (Receipts)
- FUND_RAISING_RECEIPTS (Receipts)
- OTHER_INCOME (Receipts)
- SUNDRY_RECEIPTS (Receipts)
- MEMBERSHIP_PAYMENTS (Payments)
- PREMISES (Payments)
- DONATIONS_GRANTS_PAYMENTS (Payments)
- ACTIVITIES_EXPENSES (Payments)
- FUND_RAISING_EXPENSES (Payments)
- ADMIN_EXPENSES (Payments)
- LEGAL_EXPENSES (Payments)
- OTHER_EXPENSES (Payments)
- CAPITAL_PURCHASES_EXPENSE (Payments)
- SUNDRY_PAYMENTS (Payments)
*All Scout Reporting Groups can be renamed
Scout – Receipts & Payments by Fund Type Report Layout
| UNRESTRICTED FUNDs | RESTRICTED FUNDS | ENDOWMENT FUNDS | CURRENT YEAR | PRIOR YEAR | |
|---|---|---|---|---|---|
| RECEIPTS | |||||
| Membership Subscriptions | 7000 | 7000 | 6000 | ||
| Less Paid | (2000) | (2000) | (2000) | ||
| Total Membership Subscriptions | 5000 | 5000 | 4000 | ||
| Total Investment Income Received | 200 | 200 | 500 | ||
| Total Donations/ Grants Received | 200 | 1000 | 1200 | 0 | |
| Total Activities Income | 600 | 600 | 600 | ||
| Total Fund Raising | 1000 | 800 | 1800 | 500 | |
| Total Other Income | 200 | 200 | 100 | ||
| Total Sundry Income | 500 | 500 | 0 | ||
| TOTAL RECEIPTS | 7700 | 1800 | 9500 | 5700 | |
| PAYMENTS | |||||
| Total Premises Costs | 1900 | 1700 | |||
| Total Donations/Grants | 100 | ||||
| Total Activities Costs | 3100 | 3500 | |||
| Total Fund Raising Expenses | 200 | ||||
| Total Admin/Establishment Costs | 2000 | 2000 | |||
| Total Legal Expenses | |||||
| Total Other Expenses | |||||
| Total Capital Purchases | 1000 | ||||
| Total Sundry Payments | 100 | ||||
| TOTAL PAYMENTS | 7000 | 1200 | 9200 | 7400 | |
| SURPLUS DEFICIT | 700 | 600 | 1300 | 1700 |
Reporting Groups Tutorial
Click the “Full Screen” icon below 
to expand. Space bar or Enter to move slides.