The Compensation Worksheet Payroll Reporting screen will display the Payroll Reporting Batch History. Information will be sorted by Pay Date with the most recent at the top. When there are multiple payroll systems with the same Pay Date, they will be sorted by Payroll System names.
If you filter the list by selecting a letter, the results are displayed by Payroll System name, and then sorted by Pay Date.
The following steps can be followed to create Compensation Worksheet Payroll Reporting:
Navigate at the Company Level. This process is usually under the Compensation Processing menu group.
Click the
The Compensation Worksheet Payroll Reporting process is designed to mark compensation transactions as sent to payroll and automatically generate reports that can be sent to a payroll system or accounts payable system.
The Total Compensation Methodology creates transactions that can be reported for both payment and wage transactions. Compensation worksheets that are set-up under the Allowance methodology will not have transactions available by default through this screen for payroll reporting.
The Split Payment Method allows for a compensation line item to have payments sent to more than one location.
The Shadow Payroll Method allows for total wage reporting to be communicated between primary and secondary payroll systems for an assignee. This communication is accomplished when payroll systems send pay register to the Equus Platform as a record of total compensation for an assignee. The communication between payroll systems occurs when shadow payroll reporting is executed for an assignee's secondary payroll system.
This process generically supports the following payroll report types:
Primary Payroll
Primary Payment Requests
Secondary Payment Request
Shadow Payroll
Allowance Payment Request
Compensation Accumulator Data
The Up to and Including Pay Date logic will pick-up transactions that have yet to be sent to payroll for all pay dates up to and including the pay date selected for the batch. Pay dates will be available for this screen based on the payroll reporting types chosen for the payroll system and pay period statuses.
4. Click the
to proceed generating the reports.
Example: An assignment has a primary payroll system in the US and a secondary payroll system in the UK. The assignee has requested the payments be sent to both locations. The upcoming pay dates for the UK are Jan. 20th and Feb. 3rd. The upcoming pay dates for the US are Jan. 31st and Feb. 28th.
Accounting transactions are created in a Comp Worksheet Transaction Processing batch for the US payroll system for the Jan. 31st pay date. Note: Based on the employee’s request and the payment options of the comp worksheet lines, this has created payment requests that should be reported for both the US and UK payroll systems.
Primary payroll is run for the US payroll system using the Jan. 31st pay date.
In order to report the secondary payroll system payment request (created from the Jan 31st comp worksheet) a payroll reporting batch should be created using the UK payroll system and an up to and including pay date equal to or greater than the pay date that the transactions were created for (Jan 31st). Since Jan. 20th does NOT meet those requirements, the Feb. 3rd pay date should be used to create the new payroll reporting batch.
If compensation worksheets will not be created for employees having this payroll system as their primary payroll system, then most likely only Secondary Payment Request and Shadow Payroll reports are being processed for this payroll system. In this case, all pay dates that do not have a pay period status of Future or Complete will be available as a payroll reporting pay date.
If compensation worksheets will be created for employees having this payroll system as their primary payroll system, then the primary payroll reporting type (at a minimum) should be chosen for payroll reporting. In this case, pay dates that have a pay period status of Process Transactions or Reported will be available as a payroll reporting pay date.
The
button will re-apply the Wage Codes and Payroll date to the records marked with the payroll reporting batch.
The
button will save the externally visible comments, send notifications to payroll system contacts and the payroll reports are flagged as available for external visibility. This will make the reports available on the Payroll Portal for external download.
The
button will delete the batch and its associated reports. It will also remove the wage code, report date and payroll date from the transactions that were associated with the batch.
The
button will undo the Save & Publish function. Selecting this button will notify payroll system contacts that the reports will be removed from the portal (made unavailable for external visibility). Special Page Security is available for the undo batch function.
Things to Note:
The logic that sets a given Payroll Calendar’s Pay Period Status to Complete is as follows:
a. The system looks to see if Primary Payroll, Primary Payment Request, Secondary Payment Request, or Shadow are configured to be included for that payroll, within the Payroll configuration, Reporting tab.
b. The system will check to see if there is at least one Compensation Worksheet Payroll Reporting batch including at least one of the above listed Payroll Feed Types with a Status of Reports Created.
c. If there is at least one Compensation Worksheet Payroll Reporting batch with a Status of Reports Created, containing the Payroll Feed Types listed above, the Pay Period Status is Complete for all periods within that payroll that have a Pay Date less than or equal to the Pay Date of the Calendar Period being run
Note: Undoing the Compensation Worksheet Payroll Reporting does not rollback the Pay Period Status. The Compensation Worksheet Payroll Reporting Process will not mark Vouchers/ Expenses as sent to payroll.
Compensation worksheets that are set-up under the Allowance methodology will not have transactions available by default through this screen for payroll reporting and will not process compensation worksheet transactions in the Compensation Worksheet Payroll Reporting screen
The Split Payment Method allows for a compensation line item to have payments sent to more than one location.
The Real-time Shadow Payroll Method allows for total wage reporting to be communicated between primary and secondary payroll systems for an assignee.
The Up to and Including Pay Date logic will pick-up transactions that have yet to be sent to payroll for all pay dates up to and including the pay date selected for the batch. Pay dates will be available for this screen based on the payroll reporting types chosen for the payroll system and pay period statuses.
In general, the logic that sets a given Payroll Calendar’s Pay Period Status is as follows:
a. Run a Compensation Worksheet batch = Create Worksheets, if the batch creates one or more worksheets
b. Run a Compensation Worksheet Transaction Processing batch = Process Transactions
c. Undoing a Compensation Worksheet Transaction Processing batch = Create Worksheets
d. Run a Compensation Worksheet Report Batch (reporting to the Employee) = Reported
e. Run a Compensation Worksheet Payroll Reporting batch = Reported (if not already Complete)
f. Tick the Complete Pay Period? checkbox on the Compensation Control Panel = Complete