How do I produce a payroll analysis grouped report?

Have more questions? Submit a request
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)

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.
  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:

    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.
  1. Review the summary.
  2. Click the Run button. The Payroll Analysis Summary is displayed. 
  3. Continue to EmailSave and/or Print the report.

 

PDF Output example

Spreadsheet Output example

 
 
 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful