Payroll Reporting – All Data Report

At a payroll level, there are multiple types of reports. 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)

All Data Report

An All Data report enables a user with reporting permissions to generate a report that contains employee attributes, employee details, pre and post processing pay elements, payments for a given pay period. An All Data Report utilises one or more All Data report configurations. There are two steps to generating a report, select the report configuration, then select the 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 All Data configurations to create one.
2. Select the pay period for the report.
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. Select report format CSV or Excel.
5. If totals are not required uncheck.
6. If you require a blank report (no data just column headings and employees) to create a template check the template box.

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.
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 All Data 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. Expand each section to see the elements.
2. Drag and drop the element into the report columns.
3. System provides an order number this is useful when building a large report.
4. Drag report item to change the position of the column.
5. 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.
6. This will move all of the element into the reporting columns selection area.
7. Click on add empty column to create a column spacer in the report

Reporting effective date data

There are four data types that have effective dates, salary, civil status, address and bank account. The all data report scans the effective dates for each of these data types returning the most recent effective date values to the pay date of that pay period.

All Data 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. The report configuration has been defined specifically for the supplementary period. During the report kick off process select the report configuration needed for the supplementary period and select the supplementary period.

1. Select a report configuration, if there no configurations in the drop down menu, go to All Data configurations to create one.
2. Select the supplementary pay period for the report.
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. If you require a blank report (no data just column headings and employees) to create a template check the template box.