What's in this page?
Standard Reporting Options
|
Sample Reports
|
Reporting Comp Worksheets Accounting Transactions
|
Retroactive Compensation Worksheets
|
Standard Reporting Options
Most of the reporting options can be used to group compensation data by payroll system and calculation period (payroll pay date). Information on the payroll reporting options can be found in the Compensation Worksheet Payroll Report section below. Each of the system’s reporting options are listed below:
User Reports
User reports can be created to report any kind of compensation data. Both system and company-level user reports can be created.
Navigation: Home Tab
General menu group
System Reports menu
Navigation: Companies Tab
Reports menu
To utilize the user report writer, user report types must be created.
Navigation: Configuration Tab
Documents/Reports menu group
User Report Types menu
Some views have been created to support compensation reporting. These standard views can be selected as a data source for a user report type:
Payroll Report Shadow Export (view)
Payroll Report Comp Export (view)
ASSIGNMENT COMP & PAYROLL INFO
vwEQ_TOTAL_COMPENSATION (Comp Accumulator & Pay Register)
vwEQ_PAYROLL_TO_PAYREGISTER_RECONCILIATION
vwEQ_PAYROLL_REPORT_COMP_PERIODS_DIFF_EXPORT
vwEQ_PAYROLL_REPORT_COMP_PERIODS_DIFF_EXPORT_EXPANDED
vwEQ_COMP_WORKSHEET_TRANSACTION_CHANGES
Note: User reports can be used as payroll feeds (delimited text files) in the payroll reporting screen. Compensation Accumulation views exclude data entered online that has not been submitted yet.
Production Reports
Three standard reports are available at the assignment (individual compensation worksheet level). Each of these reports can be exported as either an Adobe pdf or Excel file:
Compensation Worksheet (Include Zeros) – includes line items with 0 amounts
Compensation Worksheet (Suppress Zeros) – includes line items with 0 amounts
Compensation Worksheet Periods – shows the current and previous comp worksheet data
Comp Worksheet With Categories – Allows line items to be categorized and sub-totaled.
Please see report samples below.
The availability of these reports on screens throughout the system is configured on the production reports screen.
Navigation: Configuration Tab
Documents/Reports menu group
Production Reports menu
One production report has been created to be utilized for each of the payroll reporting types. Each of these reports is an accounting transaction report:
Primary Payroll – Primary Payroll report
Secondary Payroll – Secondary Payment Request report
Primary Payment (Wire) Requests – Primary Payment Request report
Shadow Payroll – Shadow Payroll report
Allowance Payment Requests – Allowance Payment Requests report
Compensation Accumulator Data – Compensation Accumulator report
Please see report samples below.
Other reports have been created so that balance sheets can be delivered to the primary and secondary payroll locations:
Primary Payroll – Compensation Worksheet Periods by Batch Primary Payroll
Primary Payroll – Compensation Worksheet Suppress Zeros by Batch Primary Payroll
Primary Payroll – Compensation Worksheet Show Zeros by Batch Primary Payroll
Primary Payroll – Comp Worksheet with Categories by Batch Primary
Secondary Payroll – Compensation Worksheet Periods by Batch Secondary Payroll
Secondary Payroll – Compensation Worksheet Suppress Zeros by Batch Secondary Payroll
Secondary Payroll – Compensation Worksheet Show Zeros by Batch Secondary Payroll
Secondary Payroll – Comp Worksheet with Categories by Batch Secondary
Note: Accounting transactions must be created to support the use of these reports in the payroll reporting process.
Sample Reports
From the compensation worksheet screen the following 3 reports can be created for an individual assignment:
Compensation Worksheet Report (Include Zeros) – this report will show all lines from a compensation worksheet
This report can be customized with a different header. A custom header can include any of the already existing fields in the standard header as well as up to 10 additional Assignment identifying fields.
The additional fields are:
From Employee ID
To Employee ID
From National ID Number
To National ID Number
From Social Insurance ID
To Social Insurance ID
From National Tax ID
To National Tax ID
From Payroll ID
To Payroll ID
Compensation Worksheet Report (Suppress Zeros) – this report will show all lines with amounts on the compensation worksheet
This report can be customized with a different header. A custom header can include any of the already existing fields in the standard header as well as up to 10 additional Assignment identifying fields.
The additional fields are:
From Employee ID
To Employee ID
From National ID Number
To National ID Number
From Social Insurance ID
To Social Insurance ID
From National Tax ID
To National Tax ID
From Payroll ID
To Payroll ID
Compensation Worksheet Periods Report – shows the previous and current compensation worksheet data
This report can be customized with a different header. A custom header can include any of the already existing fields in the standard header as well as additional Assignment identifying fields.
The additional fields are:
Calculation Annual Salary Amount
Calculation Annual Salary Currency
Salary Effective Date
Family Effective Date
Producer Name
Run Date
Assignment Start Date
From Salary Grade
From Employee ID
From National ID Number
From Social Insurance ID
From National Tax ID
From Payroll ID
To National ID Number
To Social Insurance ID
To National Tax ID
To Payroll ID
Employee System Number
Assignment System Number
Assignment Type
Employment Status
CF_TEXT001
CF_TEXT002
CF_TEXT003
CF_TEXT004
CF_TEXT011
Employee User ID Email
Assignment Primary Telephone
From Company Level 1
From Company Level 2
From Company Level 3
From Company Level 4
From Company Segment Level 1
From Company Segment Level 2
From Company Segment Level 3
From Company Segment Level 4
To Company Level 1
To Company Level 2
To Company Level 3
To Company Level 4
To Company Segment Level 1
To Company Segment Level 2
To Company Segment Level 3
To Company Segment Level 4
Comp Worksheet With Categories Report– shows the current compensation worksheet data in categories if they are configured.
This report can be customized with a different header. A custom header can include any of the already existing fields in the standard header as well as additional Assignment identifying fields:
Assignment Start Date
Assignment Scheduled End Date
Assignment Policy.
To configure the Categories for this report go to the Company Tab and Compensation Report Categories menu item under Company Configuration.
This screen is used to re-title the Comp Worksheet With Categories report as well as to configure Categories for that report.
The Compensation Worksheet Report Categories Configuration screen is used to view, create and edit categories for the Comp Worksheet With Categories report. Line Items are then mapped to these Categories allowing you to organize your report.
Create your Categories
To start, simply click the “New” link
Fill in the information for the Category
Name
Show Subtotal
Sequence
Once all desired information is added, click “Save”.
Repeat this process until you have all the Categories you need.
Map your Line Items
Once the categories are created and saved, click onto the Line Item Mapping tab.
Begin by selecting a Category for you line items by finding the Line Item in the alphabetical list of your active Line Items and clicking the “Please Select Item” box to select the desired Category for the line item. Each Line Item can only have one Category.
You can then specify a sequence within the Category by populating the Sequence field.
*Any Line Items that appear on the report that do not have a Category selected will appear at the top of the report.
Sample Report:
The following batch reports can be created through the payroll reporting screen:
Note: The payroll reporting screen will only allow each of these transactions to be reported once.
Primary Payroll Report – this report includes all payment requests to the primary payroll system for a given payroll system and calculation period (payroll system pay date). The report will be paginated by assignment.
Secondary Payment Request Report – this report includes all payment requests to the secondary payroll system for a given payroll system and calculation period (payroll system pay date). The report will be paginated by assignment.
Shadow Payroll Report – this report includes all pay register entries where a given payroll system is the secondary payroll system for an assignment for a given payroll system and calculation period (payroll system pay date). The report displays data in both the primary and secondary payroll system’s terminology (account descriptions and wage codes). The report will be paginated by assignment.
Compensation Accumulator Report – this is a batch report that is run by the payroll system and calculation period (payroll system pay date). The compensation accumulator report supports 12 monthly buckets (the other bucket).
Employee Earnings Stmt - Shadow Payroll Reporting
The ‘Employee Earnings Stmt - Shadow Payroll Reporting’, can be used to report pay register information as a shadow payroll report to report pay register information to the secondary payroll.
Report Notes:
There must be pay register lines configured for anything to show on this report.
Primary Wage codes must be configured for anything to show on this report.
Pay Register Lines with the same Pay Register Primary Wage Code, Pay Register Shadow Wage Code, Pay Register Home and Host Country Currency are rolled up into the same line.
The Pay Register Lines are ordered by the Pay Register Sequence. When a Sequence is not specified then lines will be displayed in alphabetical order by Pay Register Description.
Deductions will always be shown as negatives. Pay Register deductions are considered to be added as positive numbers on the Pay Register and the sign is flipped on this report unless there is Earnings + Deductions (EQPRS8) Subtotal on Pay Register. In this case, the signs are NOT flipped on the report.
Pay Register Lines with no Payment Location or a Payment Location other than Home (EQPDHM) or Host (EQPDHS) will be excluded from the report.
The Assignment must have a Comp Worksheet to run this report.
Reporting Comp Worksheets Accounting Transactions
In order to report accounting transactions through the payroll reporting screen, the following configuration is required:
Further Define Payroll System – by payroll system the periodic (per pay period) reporting requirements can be specified. On the Reporting tab of the Payroll system screen, specify by payroll reporting process which reports should be generated and delivered each period.
Reporting requirements need to be defined. Available report types:
Production Reports
User Reports
Exports
If during the payment instructions of the compensation worksheets any part of the payment was not being made to primary, then you will need to set-up not only the Primary Payroll report, but the Primary & Secondary Payment Request Reports. Note: During the creation of a new batch, a message will appear on the Payroll Reporting screen if data is available for reporting. If data is available for a report type that is not defined, then you will need to investigate why.
Wage codes need to be defined per account.
Define “Wage Code when Primary” and “Wage Code when Secondary” for each payroll system involved in compensation payroll reporting. These codes will be added to the standard payroll reports.
Confirm that the pay period status for the pay period that you will be reporting is either “Transactions Created” or “Reported”.
Note: A pay period (pay date) will only be available for payroll reporting if the pay period status is “Transactions Created” or “Reported”. If the pay period (pay date) that you are looking for is not available, navigate to the payroll system screen and modify the status of the pay period.
Employee Earnings Stmt - Employee View report
The ‘Employee Earnings Stmt - Employee View Report’, can be used to report pay register information to the Employee (as a pay slip).
Report Notes:
There must be pay register lines configured for anything to show on this report.
Primary Wage codes must be configured for anything to show on this report.
Pay Register Lines with the same Pay Register Primary Wage Code, Pay Register Shadow Wage Code, Pay Register Home and Host Country Currency are rolled up into the same line.
The Pay Register Lines are ordered by the Pay Register Sequence. When a Sequence is not specified then lines will be displayed in alphabetical order by Pay Register Description.
Deductions will always be shown as negatives. Pay Register deductions are considered to be added as positive numbers on the Pay Register and the sign is flipped on this report unless there is Earnings + Deductions (EQPRS8) Subtotal on Pay Register. In this case, the signs are NOT flipped on the report.
Pay Register Lines with no Payment Location or a Payment Location other than Home (EQPDHM) or Host (EQPDHS) will be excluded from the report.
The Assignment must have a Comp Worksheet to run this report.
Reporting Comp Worksheets Accounting Transactions
In order to report accounting transactions through the payroll reporting screen, the following configuration is required:
Further Define Payroll System – by payroll system the periodic (per pay period) reporting requirements can be specified. On the Reporting tab of the Payroll system screen, specify by payroll reporting process which reports should be generated and delivered each period.
Reporting requirements need to be defined. Available report types:
Production Reports
User Reports
Exports
If during the payment instructions of the compensation worksheets any part of the payment was not being made to primary, then you will need to set-up not only the Primary Payroll report, but the Primary & Secondary Payment Request Reports.
Note: During the creation of a new batch, a message will appear on the Payroll Reporting screen if data is available for reporting. If data is available for a report type that is not defined, then you will need to investigate why.
Wage codes need to be defined per account.
Define “Wage Code when Primary” and “Wage Code when Secondary” for each payroll system involved in compensation payroll reporting. These codes will be added to the standard payroll reports.
Confirm that the pay period status for the pay period that you will be reporting is either “Transactions Created” or “Reported”.
Note: A pay period (pay date) will only be available for payroll reporting if the pay period status is “Transactions Created” or “Reported”. If the pay period (pay date) that you are looking for is not available, navigate to the payroll system screen and modify the status of the pay period.
Retroactive Compensation Worksheets
The retroactive calculation can be performed at the assignment and/or at the company level using the compensation worksheet batch . This is based upon a "from" and "to" pay period date range.
The line item retro amount is calculated by taking the difference between the previous comp worksheet line item amount and the retro comp worksheet line item amount. The payment instructions (or the amounts to be paid in the home and host location) are calculating by splitting this line item difference based on the Split Payment Option selected on the retro comp worksheet.
It is important to understand that changes in the payment instructions only (no change to the line item amount) will not have retro amounts calculated. This includes reallocations which do not have line item amounts, only payment instructions.
Another important thing to consider is not to override the exchange rate when performing retro calculations as any changes will result in incorrectly calculated retro amounts.
Some common updates that will result in differences between the Effective Compensation Worksheet and the Retro Compensation Worksheet:
Salary updates back-dated in arrears.
Family size updates back-dated in arrears.
Removing Fixed Amount in Home or Host Currency line items from the Assignment Compensation Worksheet template after the Effective Compensation Worksheet is calculated, but prior to calculating the Retro Compensation Worksheet.
Some common updates that will not result in differences when a Retro is calculated:
Salary updates dated in the future.
Family size updates dated in the future.
Adding Calculate (Home Currency), Fixed Amount in Home Currency, or Fixed Amount in Host Currency line items to the Assignment Compensation Worksheet Template after the Effective Compensation Worksheet is calculated, but before the Retro Compensation Worksheet is calculated.
Adding Calculate (Home Currency), Fixed Amount in Home Currency, or Fixed Amount in Host Currency line items to the Effective Compensation Worksheet, but not to the Assignment Compensation Worksheet Template, prior to calculating the Retro Compensation Worksheet.
Removing Calculate (Home Currency), Fixed Amount in Home Currency, or Fixed Amount in Host Currency line items from the Effective Compensation Worksheet, but not from the Assignment Compensation Worksheet Template, prior to calculating the Retro Compensation Worksheet.
Removing Calculate (Home Currency) line items from the Assignment Compensation Worksheet Template after the Effective Compensation Worksheet is calculated, but before the Retro Compensation Worksheet is calculated.
The retro amounts are stored separately and can be reported separately from the ongoing amount.
Retroactive batches are created on the Compensation Worksheet screen.
Navigation: Assignments Tab
Compensation menu group
Compensation Worksheets menu
Select the Retroactive Batches tab
Choose to create a New batch
Note: If a Compensation Worksheet that was originally calculated for an assignment and used the Exchange Rate Method of ‘Compensation Calculation – Primary’ and the Primary Compensation Calculation has changed since the original Compensation Worksheet was run, the retroactive compensation worksheet will not use the new primary compensation calculation. It will instead use the exchange rate that was used to calculate the original compensation worksheet in order to keep things consistent.