---
title: "How do I generate listing and payroll reports?"
slug: "how-do-i-generate-listing-and-payroll-reports"
updated: 2026-06-10T11:26:21Z
published: 2026-06-10T11:26:21Z
canonical: "help.cintra.co.uk/how-do-i-generate-listing-and-payroll-reports"
---

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

# How do I generate listing and payroll reports?

**Cintra iQ** allows you to create and manage your own reports from within the **Cintra iQ** system. Once created, the reports are then available at the bottom right of **Cintra iQ** and can be used whenever required. You can create either a **Listing** or **Payroll** report definition to suit your needs.

Generally, the differences between a listing report and a payroll report are:

**Listing report**

- Multiple rows of data per employee.
- Filter applies to either records and/or data.

**Payroll report**

- Single row of data per employee per pay period.
- Filter applies to data only.
- Running the report.

**Go to Cintra iQ**:

- Lower right-hand corner > Reports > Reports window
- Menu bar > Definitions > Reporting > Reports > Reports window

## Listing report: definition and example

**Listing** reports produce a list of all the data selected when the report is created.

> [!TIP]
> **For example:** to see a report on every period of sickness an employee has had, you can create a Listing report definition to show all periods of sickness belonging to that employment record.

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

When creating the **Listing** report definition, you can:

1. Assign the data on which to base the report.
2. Format individual columns (optional).
3. Sort columns (optional).
4. Format printing options (optional).
5. Filter by record and data.

## Payroll report: definition and example

Payroll reports let you report cash values on one or more pay periods. When you run a Payroll report, you can choose to only view data from specific payroll(s) and period(s).

> [!TIP]
> **For example**: if I wanted to see a report on the net pay of every employee within the company, I would create a Payroll report definition to show all periods of net pay belonging to that employment record.

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

When creating the **Payroll** report definition, you can:

1. Identify the payslip data on which to base the report. For more information, see the Payroll Listing tab.
2. Format individual columns (optional). For more information, see the Field Details tab.
3. Sort columns (optional).
4. Format printing options (optional).
5. Filter by data.

## Generating/running a listing report

1. Navigate to the **Reports** window.
2. Highlight a **Listing** report.
3. Click the **Run** button. The **Filter Historic Records** window appears.
4. Select either the **All**, **As At**, or **Between** criteria to **Filter Historic Records**. The **Filter** details are displayed below the selection, for your review.
5. Click the **OK** button. The report is generated.
6. Continue to process the report's output.

You can embed a filter in the **Listing** report to include or exclude data when the report is run. The system will search for records that contain the **Fieldname** data but not show the actual data unless it is already selected in the **Listing Definition** tab.

> [!TIP]
> **For example:** I want to filter all the employees in the Department Headcount report who have a next of kin. Once the report is generated, I can go into the Contact Information form of the employee's personnel record to check the next of kin.

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

> [!NOTE]
> **Note:** Before you begin, turn off any filters that have already been applied to the report. Because, if a record filter is embedded in the report, it overrides any record filter that is already applied to the Navigator.

### To assign data

1. Navigate to either the **List Definition** tab or **Payroll Listing** tab. **Go to iQ:** Reports window > New button > Report Type: Listing Report > Create Listing Report Definition window **OR** Reports window > New button > Report Type: Payroll Report > Create Payroll Report Definition window
2. Enter the **Title** of the report.
  - The report cannot be saved unless you enter a title.
3. Select the **Category** you wish to assign the report.
  - If no category is selected, the report automatically appears in the Uncategorised category.
4. Select the desired field in the **Available Fields** pane.
  - The field selection for periodic information can be taken from the Payslip form. It allows you to report on exactly what was in the pay period and includes Starter and Leaver indicators.

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/qWcUp_WxQtJ2oJWbibLgsh8YB7O20f8xgQ.png)
5. Click the **Add >** button. The field name appears in the **Selected Fields** pane.
6. Repeat the process as many times as desired using either the **Add >** or **Insert >** buttons.
7. Save and run the report.

### To embed a record filter

1. From the **Available Filters** pane in the **Record Filters** tab, select the desired filter.
  - These filters were already created in the Filters module. For more information, see Filters.
2. Add it to either the **Include records belonging to All of:** or **Exclude records belonging to ANY of:** panes.
3. Click the **OK** button. The filter is now saved and embedded. It will activate when the report is run.

## Generating/running a payroll report

1. Navigate to the **Reports** window.
2. Highlight a Payroll report.
3. Click the **Run** button. The **Payroll Report** window appears showing a list of your company's payrolls
4. Select one or more payrolls and a reporting period.

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/Jma3i2gqJWACT_6OOBmNqugkC4LsgX6BHw.png)
  - **Report figures as at a date**: Select this option to enter the relevant payroll pay period in which the date falls. It displays the current period values in the pay period.
  - **Report figures for pay dates between**: By default, the period values are summed and year to date values display as at the last period in the range.
  - **Report figures for accounting periods**: It works in the same way as Report figures for pay dates between except that Cintra iQ uses the payroll periods in the accounting period instead of the periods falling between the two selected dates.
5. Click **Next**. Now you must confirm which payroll(s) you are reporting on, then
6. Click **Next**. You can now select whether to report on all employees in the payroll, or on specific / multiple employees.
7. Click **Run** to create the report.