Report Groups

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 Report Groups

Report Groups allow you to create advanced Financial Statements and sector-specific report layouts that some organisations require. Report Groups are an additional Parent/Cost Code attribute that are used to determine where transaction values appear in reports which utilize Report Groups.

Report Group Sets

Report Group Sets determine which Report Groups and advanced Reports are available to your organisation.

Currently, the following Report Group Sets are available:

Standard: select for non-charity, commercial organisations – provides access to the advanced Income Statement report.
Scout: select for youth/scout groups that need to produce SORP style accounts
Charity: select for charities that need to produce CC16 accounts

Each Report Group Set comes pre-populated with its own set of Report Groups.

Report Groups are used to determine the layout and structure of certain advanced Financial Statement reports (see below) and, by mapping Report Groups to your Cost Codes, they effectively create an alternative Cost Code hierarchy that can be used to give you more control over where transactions appear in the advanced reports.

Report Groups cannot be added or removed, however, you can rename them to better match your organisation’s Report requirements.

“Standard” Report Group Set

The Standard Report Group Set provides the following Report Groups which can be assigned to your Parent/Cost Codes. It currently provides a more advanced Income Statement (Profit and Loss) report layout required by larger commercial, non-charitable organisations.

The following Reports are available with the Standard Report Group Set:

Income Statement (Standard Report Group)

Standard Report 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 Report 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” Report Group Set

The Scout Report 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 Report Group Set:

1. Charity Reports > Scout – Receipts & Payments by Fund Type Report

Scout Report 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 Report Groups can be renamed

Scout – Receipts & Payments by Fund Type Report Layout

	UNRESTRICTED FUNDs	RESTRICTED 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

“Charity” Report Group Set

The Charity Report Group Set address the requirements for Charity Commission (England and Wales) submissions and trustee annual Report, based on the widely recognized CC16 format.

What is CC16?

CC16 provides a simplified method for smaller charities to record cash inflows and outflows, crucial for fulfilling annual Report obligations.

CC16 Reports Available:

Navigate to Reports > Charity Reports and Financial Statements by Funds to access:

Charity CC16 – Section A – Receipts & Payments Report: A clear and concise summary of your charity’s income and expenditure.
Charity CC16 – Section B – Statement of Assets & Liabilities: A snapshot of your charity’s financial position at the end of the Report period.

Both reports are designed to mirror the Charity Commission’s official templates, offering “out-of-the-box” compliance. For detailed guidance on CC16 requirements, please refer to: https://www.gov.uk/guidance/prepare-a-charity-annual-return

Getting Started: Utilising Charity Report Groups

To leverage these reports effectively, your organisation needs to use the “Charity” Report Group Set. This allows you to categorise your Cost Codes for accurate mapping within the CC16 reports.

Here’s how:

Switch to the Charity Report Group Set:
- Go to Setup > Report Groups and select “Charity” from the Report Group Set dropdown.
- Important: Please note that switching Report Group Sets will overwrite existing assignments. Only one Group Set can be active at a time.
- Premium Plus Subscription Required: Report Groups are a feature of our Premium Plus subscription.
Edit the Reportunbg Group labe l
Map Cost Codes to Report Groups:
- Go to Setup > Cost Codes.
- Switch to Table view and select “Show Parents Only” to simplify the structure.
- Open the Parent Codes and assign the appropriate Report Group to each. Click Save. (Note: Assigning a Report Group to a Parent Code will apply it to all child Cost Codes. You can then adjust individual Cost Codes as needed).
  - Charity Report Groups:
    - A1 Receipts: For operating income.
    - A2 Asset & Investment Sales: For asset sales and investment income.
    - A3 Payments: For operating expenses.
    - A4 Asset & Investment Purchases: For asset and investment purchases.
    - AX Capex Expenditure (Not in P&L): For CAPEX (not used in CC16 reports).
    - Ensure all Cost Codes are mapped.
Run Your CC16 Reports:
- Your financial data will now populate the CC16 reports based on your Cost Code mappings, ensuring accurate and compliant Report.

Report Groups Tutorial

Click the “Full Screen” icon below to expand. Space bar or Enter to move slides.