Latest Process Year-to-Date and Periodic Balances Reporting

This topic explains the separate tasks you can use for reporting latest process year-to-date and periodic balances for these three payroll reports:

• Payroll Activity Report
• Statutory Deduction Register
• Payroll Register Report

Latest Process Year-to-Date Reporting

Run these three reports to extract the year-to-date (YTD) payroll balances for large volumes of data.

• Payroll Activity Report for the Latest Process

• Statutory Deduction Register for the Latest Process

• Payroll Register Report for the Latest Process

For large volumes of data, the enhanced report runs much faster

and includes year-to-date totals from the last process run for a person prior to the specified end date, such as the last process run for each TRU.

Periodic Balances Reporting

Run these three reports to extract the periodic payroll balances for large volumes of data:

• Periodic Payroll Activity Report

• Periodic Statutory Register

• Periodic Payroll Register Report

For large volumes of data, the enhanced report runs much faster.

In addition to reporting YTD balances, you can also configure the report to extract payroll balances for these balance dimension types:

• Month-to-Date (MTD)

• Period-to-Date (PTD)

• Quarter-to-Date (QTD)

• Inception-to-Date (ITD)

Before you run the report for the above balance dimension types, complete the following:

1. Determine which of the four balance dimension types you want to include in the report and for which balances. Determine the balance group for each balance by looking up the balance groups for the relevant Global Archive report type under the Balance Group Usages page. The report types for the new reports are the same as those of the existing reports. .

2. For each balance group usage, determine the appropriate balance dimension name that has the relevant contexts. Use the existing balance group usage item for YTD as a reference. For example, if the balance dimension name used for YTD is Relationship Tax Unit Year to Date, you should use Relationship Tax Unit Period to Date for PTD.

3. Ensure that the defined balances exist. Use the Balance Definitions page to ensure the balance is associated with the required balance dimensions.

4. On the Balance Groups page, ensure that the defined balance is part of the determined balance group.

5. Add Balance Group Usage Items for the dimension within each Legislative Data Group and the determined balance group usage.

These reports use a much lighter report template with enhanced performance and scalability capabilities to handle high volumes of data. The reports run much faster for large volumes of data. You can now run the reports to produce CSV/text output that you can easily import into the Excel format. This is in addition to the PDF and Excel outputs we already support.

For very large data sets, it's preferable to run the report for the text output and then converting it to the Excel format. It is much faster than generating the report output directly in the Excel format.

If you have configured changes to your existing extract definition, including but not limited to delivery options, report templates, and so on, then those must be reapplied to these reports, if required.