Latest Process Year-to-Date Reporting
Run these three enhanced reports to extract the year-to-date (YTD) payroll balances for large volumes of data:
-
Payroll Activity Report for the Latest Process
-
Payroll Register Report for the Latest Process
These reports produce the same output as running the existing reports with the Latest Process YTD Totals Only field set to Yes. However, for large volumes of data, the enhanced report runs much faster.
The 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.
In addition to report 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:
-
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. .
-
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.
-
Ensure that the defined balances exist. Use the Balance Definitions page to ensure the balance is associated with the required balance dimensions.
-
On the Balance Groups page, ensure that the defined balance is part of the determined balance group.
-
Add Balance Group Usage Items for the dimension within each Legislative Data Group and the determined balance group usage.
Use the existing Payroll Activity Report and Payroll Register Report for periodic reporting of balances. The new reports are meant for reporting YTD balances as of the last process run on or before the specified end date.
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 the new report, if required.