Skip to main content

Compensation Worksheets / Compensation Calculations Feature Matrix - APPENDIX A

Should you use compensation worksheets or are compensation calculations a better fit for your needs?  This section will highlight which features are available in each compensation delivery tool. C

Updated over 2 weeks ago

Should you use compensation worksheets or are compensation calculations a better fit for your needs? This section will highlight which features are available in each compensation delivery tool.

Compensation Feature

Compensation Worksheets

Compensation Calculations

Salary per Compensation/Payroll Date

Yes

Yes

Family Size per Compensation/Payroll Date

Yes

Yes

Exchange Rates per Compensation/Payroll Date

Yes

Yes

Data Provider Data per Compensation/Payroll Date

Yes

Yes

Custom Calculations per Compensation/Payroll Date

Yes

Yes

Payment Transactions

Yes

with Total Compensation methodology

No

Multiple Payrolls

Yes

Yes

Payroll Calendars/Schedules

Yes

No

Pay Register Collection

Yes

No

Pay Register Audit/Reconciliation

Yes

No

Shadow Payroll

Yes

No

Real Time Shadow Payroll

Yes

Yes

Annual Amounts

Yes

If # Pay Periods within a Payroll System = 1, or Report annualizes amounts

Yes

“Pay Slip” Reporting

Yes

No

Company Compensation Templates

Yes

Yes

Assignment Compensation Templates

Yes

No

Pay Location Specified per Allowance/Line Item

Yes

Yes

Payment Split per Allowance/Line Item

Yes

No

Fixed Amounts in Assignment Home/Host Currency

Yes

Yes

Fixed Amounts in Company Currency

No

Yes

Show Amounts in both Home/Host Currencies

Yes

Yes

Use Data Provider Exchange Rates within Data Provider Data

Yes

No

Use Company/System Exchange Rates

Yes

Yes

One Time Payments Added to Individual Compensation Worksheets/Calculations

Yes

No

Include Data Provider Calculations (AIRINC, ECA, Mercer, ORC)

Yes

Yes

Specify Data Provider Subscription/Version to Use

Yes

No

Include Equus E4C Hypo Tax Calculator

No

Yes

Specify the Salary Min/Max into Calculations

Yes

No*

Specify the Min/Max of Calculated Output Amounts

Yes

No*

Payment Begin/End Dates

Yes

No

Payment Amount Change Thresholds

Yes

No

Primary/Secondary Payroll

Yes

with Total Compensation methodology

No

Home/Host Payroll

Yes

Yes

Amounts in Payroll Currencies

Yes

No

Amounts in Home/Host Currencies

Yes

Yes

Payments in a 3rd Currency

Yes

No

Dictionary of Line Items to Choose From

Yes

No

Ability to Add/Delete Line Items at the Assignment Level

Yes

No

Generate Reports to the Employee from an Individual Compensation Worksheet/Calculation

Yes

Yes

Generate Reports to the Employee in Batch

Yes

Yes

Generate Reports to Payroll from an Individual Compensation Worksheet/Calculation

Yes

Yes

Generate Reports to Payroll in Batch

Yes

Yes

Compensation Worksheet/Calculation Locked Down after Being Reported

Yes

No

Not automatically, but can do manually individually

Retro Compensation Worksheets/Calculations

Yes

No

Show Zero Amounts

Yes

Yes

Report Only Changes Since Last Report

Yes

No

Process Stages/Statuses

Yes

No~

Include/Exclude Assignments in Batch

Yes

Run a Batch per Payroll System

Yes

No

Run a Batch per Home/Host Country

No

Yes

Override Family Size for Calculations

Yes

No*^

Can do individually, not in batch

Override Salary for Calculations

Yes

Yes

Can do using the Cascading feature or Custom Calculations

Override Exchange Rate

Yes

Yes

Can override at individual level, and not refresh in batch

Post Assignee Reports to the Employee Portal

Yes

Yes

Post the Payroll Reports to the Payroll Portal

Yes

Yes

Deliver the Assignee Reports via Email

Yes

Yes

Deliver the Payroll Reports via Email

Yes

Yes

Data Feeds (csv, pipe delimited, etc) to Payroll

Yes

No

Only supports Production Reports in PDF or Excel

Did this answer your question?