---
title: "Payroll analysis grouped report"
slug: "how-do-i-produce-a-payroll-analysis-grouped-report"
description: "How to produce the grouped payroll analysis report in Cintra iQ."
updated: 2026-07-29T10:01:04Z
published: 2026-06-10T13:12:53Z
canonical: "help.cintra.co.uk/how-do-i-produce-a-payroll-analysis-grouped-report"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.cintra.co.uk/llms.txt
> Use this file to discover all available pages before exploring further.

# Payroll analysis grouped report

The **Payroll Analysis Grouped** report within **Cintra iQ** displays similar content to the payroll analysis report. However, this report is grouped by organisation unit.

The report shows the following summarised information:

- Reconciliation totals for costs and liabilities (employer and employee)
- Employee payslips produced
- Employee activity (starters, leavers etc.)
- Gross pay by element
- HMRC liabilities (total due to HMRC)
- Pension liabilities (total due to pension providers)
- Benefit scheme liabilities (Childcare vouchers)
- Other liabilities (other deductions)

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001066619.png)

## To produce a report

1. Go to **Cintra iQ**: Payroll > Payroll Tools > Payroll Reports > Payroll Analysis Grouped. The **Payroll Analysis - Select Reporting Period** form appears. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001066620.png)
2. Depending on what payroll period option you've selected and clicked the **Next** button, perform either of the following:

| Payroll Period Option | Description |
| --- | --- |
| **Payroll periods for a specific payroll** | The **Payroll Analysis Grouped - Select Payroll and Period range** form appears. 1. Select the desired **Payroll**. 2. Select the desired period range. 3. Click the **Next** button. The **Payroll Analysis Grouped - Select Sort Order and Detail level** form appears. 4. Select the desired **Sort by** option. 5. Click the **Next** button. The **Payroll Analysis Grouped - Include Records for...** form appears. 6. Select the desired option. 7. Click the **Next** button. The **Payroll Analysis Grouped - Selection Summary** form appears. |
| **Payroll period within a range of dates** | The **Payroll Analysis Grouped - Select Payrolls to include and Period Range for each** form appears. 1. Select the **Payroll Period** and range(s). 2. Click the **Next** button. The **Payroll Analysis Grouped - Select Sort Order and Detail level** form appears. 3. Select the desired **Sort by** option. 4. Click the **Next** button. The **Payroll Analysis Grouped - Include Records for...** form appears. 5. Select the desired option. 6. Click the **Next** button. The **Payroll Analysis Grouped - Selection Summary** form appears. |
| **Year-to-date figures for a specific payroll** | The **Payroll Analysis Grouped - Select Payroll and Year-to-date period** form appears. 1. Select the desired **Payroll**. 2. Select the desired period. 3. Click the **Next** button. The **Payroll Analysis Grouped - Select Sort Order and Detail level** form appears. 4. Select the desired **Sort by** option. 5. Click the **Next** button. The **Payroll Analysis Grouped - Include Records for...** form appears. 6. Select the desired option. 7. Click the **Next** button. The **Payroll Analysis Grouped - Selection Summary** form appears. |
| **Year-to-date figures for multiple payrolls** | The **Payroll Analysis Grouped - Select Payrolls to include** form appears. 1. Select the desired **Payroll Period** and ranges. 2. Click the **Next** button. The **Payroll Analysis Grouped - Select Sort Order and Detail level** form appears. 3. Select the desired **Sort by** option. 4. Click the **Next** button. The **Payroll Analysis Grouped - Include Records for...** form appears. 5. Select the desired option. 6. Click the **Next** button. The **Payroll Analysis Grouped - Selection Summary** form appears. |
| **Accounting period:** | > [!NOTE] > **Note:** Before you confirm the relevant accounting period, you can see its Accounting Period details and associated Payroll Periods by clicking the Details button. 1. **The Payroll Analysis Grouped - Select Sort Order and Detail level form appears. Select the desired Sort by option.** 2. **Click the Next button. The Payroll Analysis Grouped - Include Records for...** form appears. 3. Select the desired option. 4. Click the **Next** button. The **Payroll Analysis Grouped - Selection Summary** form appears. |
3. Review the summary.
4. Click the **Run** button. The **Payroll Analysis Summary** is displayed.
5. Continue to **Email**, **Save** and/or **Print** the report.

Once you have run the report, you can archive it and publish it to Cintra Cloud. To do this, click **Archive**. To view all the archived reports, see [How do I view the report pack in the report archive?](/iq/docs/how-do-i-view-the-report-pack-in-the-report-archive)

## PDF Output example

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001066621.png)

## Spreadsheet Output example

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001066622.png)