Payroll Reporting – Variance Report

At a payroll level, there a three types of reports All Data, Changes and Variance. Each of these reports require a report configuration to be created, to specify the information needed and the structure of the report. All reports have a kick off page, requiring the selection of a set of parameters, the report is then generated in a background process. The completed report is stored in My Files. 

1. Select the type of report (All data, changes or variance).
2. Create or edit report configurations (All data, changes or variance).

A variance report enables a user with reporting permissions to generate a report that details the percentage change or absolute change to payments, pre and post processing pay elements for a given pay period. A variance report utilises one or more variance report configurations. There are two steps to generating a report, select the report configuration, then select the reporting parameters, pay period and language. The completed report is stored in My Files.  

1. Select a report configuration, if there no configurations in the drop down menu, go to variance report configurations to create one.
2. Select the ‘To period’, the system will automatically populate the from period.
3. Select the reporting language for the report headings (pay elements and employee details). If translations have not been added for the language chose, the headings will be in the default language.
4. List employees all employees or only those with changes.
5. Percentage or value difference or both (this will generate columns per element in the report).

Report completion notification

All of the payroll and pay period reports are generated in a background process, when the process is complete, the system sends an email to the user who requested the report. It will state if the report is successful or not, and will provide a link to the report and results, which can be also found in My Files. 

1. Type of report requested and client tenancy.
2. A link to retrieving the report from My Files. 

View or downloading a report

To access a report generated by the system, open files and select My Files. The system has a folder hierarchy of report type, payroll and report configuration. In each reporting folder, the system stores a file called details which contains the report parameters selected, results which lists if the report is successful or what errors had been encountered and the report. 

1. Open my files folder.
2. A folder per reporting type (All data, variance or changes).
3. A folder per payroll.
4. A folder for each reporting configuration.
5. Folder for the generated report.
6. Details – reporting parameters.
7. The report – view, download, rename or transfer report.
8. Results – outcome of the report process

Creating a new variance report configuration

A report configuration determines the which employee attributes, employee details and pay elements appear in a report and the ordering of those columns. A report configuration has two tabs, report details and report columns.

1. Give the report a name.
2. Select the period type, standard, off-cycle or year-end.
3. Add a header if needed, this will appear in the first cell of the report.
4. Add a footer is needed, this will appear in the cell below the data.
5. Select the default language, this is the language shown on the kick off page. The language can changed changed at the time of running the report. 

A report configuration has two tabs, report details and report columns. In the report columns tab, drag a drop the elements into the report column pane, positioning them in the order that they will appear on the report. 

1. Employee attributes.
2. Expanding data types.
3. Select all available, check this box to automatically add to the reporting columns any new elements for that category created on the system after the report configuration had been created.
4. This will move all of the element into the reporting columns selection area.
5. Position by dragging and dropping the reporting columns in the order needed for the report.
6. Click on add an empty column to be included in the report

Variance Report – supplementary periods

Pay data can be held against any supplementary period (Off-cycle, quarter-end or year-end). The reporting process is exactly the same as for the standard periods. During the report kick off process select the report configuration needed for the supplementary period and select the supplementary period. The variance report will compare the chose supplementary period to the previous supplementary period (of that type)

1. Select a report configuration, if there no configurations in the drop down menu, go to variance report configurations to create one.
2. Select the ‘To period’, the system will automatically populate the from period.
3. Select the reporting language for the report headings (pay elements and employee details). If translations have not been added for the language chose, the headings will be in the default language.
4. List employees all employees or only those with changes.
5. Percentage or value difference or both (generate columns per element in the report.