For information about outages and scheduled maintenance, click here

How do I produce a gross to net report?

Modified on Tue, 10 Dec at 2:30 PM

The columns in this standard Gross to Net report, within Cintra iQ, can be broken down as defined by reporting groups. This is useful if you want to see separated data. For example, you can see Deductions from Pay separated from Build up to Gross Pay and Net Pay.
 
 
 

To produce a report

  1. Go to Cintra iQ: Payroll> Payroll Tools> Payroll Reports> Gross to Net Report.  The Gross to Net Report - 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 Select Reporting Period range form appears.

    1. Select the desired Payroll.
    2. Select the desired period range.
    3. Click the Next button. The Gross to Net Report - Select Subtotals and Sort Order form appears.
    4. Select the desired sort order(s) and/or subtotals. e.g. Subtotal and sort by: Organisation Unit; Then by: Employment ID
    5. Click the Next button. The Gross to Net Report - Include Records for form appears.
    6. Select the desired option.
    7. Click the Next button. The Gross to Net Report  - Selection Summary form appears.

    Payroll period within a range of dates

    The 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 Gross to Net Report  - Select Subtotals and Sort Order form appears.
    3. Select the desired sort order(s) and/or subtotals. Click the Next button. The Gross to Net Report - Include Records for form appears.
    4. Select the desired option.
    5. Click the Next button. The Gross to Net Report - Selection Summary form appears.

    Year-to-date figures for a specific payroll

    The 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 Gross to Net Report - Select Subtotals and Sort Order form appears.
    4. Select the desired sort order(s) and/or subtotals. 
    5. Click the Next button. The Gross to Net Report - Include Records for form appears.
    6. Select the desired option.
    7. Click the Next button. The Gross to Net Report - Selection Summary form appears.

    Year-to-date figures for multiple payrolls

    The Select Payrolls to include form appears. 

    1. Select the desired Payroll Period and ranges.
    2. Click the Next button. The Gross to Net Report - Select Subtotals and Sort Order form appears.
    3. Select the desired sort order(s) and/or subtotals. 
    4. Click the Next button. The Gross to Net Report - Include Records for form appears.
    5. Select the desired option.
    6. Click the Next button. The Gross to Net Report - Selection Summary form appears.

    Accounting period

     

    The Select Subtotals and Sort Order form appears.

      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. Select the desired sort order(s) and/or subtotals. 
    2. Click the Next button. The Gross to Net Report - Include Records for form appears.
    3. Select the desired option.
    4. Click the Next button. The Gross to Net Report - Selection Summary form appears.
  3. Review the summary.
  4. Click the Run button. The Gross to Net Report is displayed.
  5. Continue to ArchiveEmailSave and/or Print the report.

 

PDF Output example

Spreadsheet Output example

 
 
 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article