Skip to main content

Compensation Worksheets / Balance Sheets - Payment Options

Payment options can be specified for a comp worksheet on a company comp worksheet template, an assignment comp worksheet template and on the compensation worksheet itself.  Payment options can drive w

Updated over 2 weeks ago

Payment options can be specified for a comp worksheet on a company comp worksheet template, an assignment comp worksheet template and on the compensation worksheet itself. Payment options can drive which party is responsible for making payments, a percentage or fixed amount in each location, what currency the payment should be made in, and how an employee should be paid.

Note: Payment options vary between compensation worksheet methodologies

Split Payments

The "Do Not Create Transactions" checkbox drives whether or not transactions will be created from a compensation worksheet when the user selects "Process & Create Transactions" on the compensation worksheet or creates a Compensation Worksheet Transaction Batch. The line item will appear on a compensation worksheet report whether the checkbox is checked or not.

Note: This field will have no effect if your business process does not include creating accounting transactions from compensation worksheets.

The Split Payment options in the drop down list are populated based on the Compensation Process Methodology chosen. The purpose of the payment option is to determine what amount is allocated to Primary and Secondary payroll systems or home and host locations (based on methodology).

Allowance Methodology

The allowance methodology allows for split payment between home and host locations. When reporting payment requests through the payroll reporting screen, the allowance payment request report should be selected for the assignment’s primary payroll system. All payment requests or accounting transactions will appear on this report regardless of home or host payment location.

Split payment options are as follows:

Home Country Fixed Amount

Home Country Percentage

Host Country Fixed Amount

Host Country Percentage

Host Country Fixed Amount in 3rd Currency

Host Country Percentage in 3rd Currency

Ex 1. Foreign Service Premium 3000 USD

Amount in Home Currency 3000.00 USD
Exchange Rate 0.5082
Amount in Host Currency 1524.60 GBP

Split Payment Option: Host Country Percentage (50% in Home - 50% in Host)


Home Country

Payment Amount 1,500.00 USD

Host Country

Payment Amount 813.60 GBP

Note: Accounting transactions will look exactly like the payment amounts above and will be reported to the primary payroll system through the payroll reporting screen through use of the "allowance payment requests" payroll type.

Total Compensation Methodology

Using this methodology will allow you to run payroll by payroll system and have split pay payment requests reported by payroll system. Reporting payment requests by payroll system is available through the Comp Worksheet Payroll Reporting screen.

Ex 1. Foreign Service Premium 3000 USD

Amount in Home Currency 3000.00 USD
Exchange Rate 0.5082
Amount in Host Currency 1524.60 GBP

Split Payment Option: Percentage in Secondary Location (50% in Home - 50% in Host)

Secondary (US Payroll)
Home Country

Payment Amount 1,500.00 USD

Primary (UK Payroll)
Host Country


Payment Amount 762.30 GBP

Accounting transactions for the total compensation methodology would be as follows:

Secondary payroll

1500.00 USD

Note: The payment system selected for this amount will determine if the primary or secondary payroll system is responsible for making payment. If "primary payment request" is selected, then the transactions can be reported through the primary payment request report type for the primary payroll system. If "secondary payment request" is selected, then the transactions can be reported through the "secondary payment request" report type for the secondary payroll system.

Primary payroll

1524.60 GBP

-762.30 GBP

Note: This will always include a 100% of total wages record. In the cases where an amount is being paid in the secondary location, a payment request deduction amount will be sent to the primary payroll system as well. The sum of both records is the payment request to the primary payroll system.

Ex 2. Foreign Service Premium 3000 USD

Amount in Home Currency 3000.00 USD
Exchange Rate 0.5082
Amount in Host Currency 1524.60 GBP

Split Payment Option: Percentage in Secondary Location (100% in Home)

Secondary (US Payroll)
Home Country

Payment Amount 3,000.00 USD

Primary (UK Payroll)
Host Country


Payment Amount 0.000 GBP

Accounting transactions for the total compensation methodology would be as follows:

Secondary payroll

3000.00 USD

Primary payroll

1524.60 GBP

-1524.60 GBP

Ex 3. Foreign Service Premium 3000.00 USD

Amount in Home Currency 3000.00 USD
Exchange Rate 0.5082
Amount in Host Currency 1524.60 GBP

Split Payment Option: 100% in Primary Location (100% in Host)

Secondary (US Payroll)
Home Country

Payment Amount 0.00 USD

Primary (UK Payroll)
Host Country


Payment Amount 1524.60 GBP

Accounting transactions for the total compensation methodology would be as follows:

Primary payroll

1524.60 GBP

Creating Zero Amount Transactions

Communicating instructions to payroll can be done every pay period or can be done only when payment amounts change (Good until cancelled). When communicating every payment instruction, payroll systems will not make a payment unless instructed to do so. In this scenario, Compensation Worksheet line items that are no longer to be paid don’t need any special handling. In a “Good until cancelled” scenario, the payroll systems need to be notified to stop payments. The default behavior of Compensation Worksheet transaction creation is to not create zero amount transactions. In order to create zero amount transactions, select “Create Zero Amount Transactions” at the Compensation Worksheet level. This setting can be made at the Company and Assignment template levels as well.

Payment Requests by Location

Allowance Methodology

There are no payment request options for the allowance methodology; instead a payment system field is available for determining if payments should be made by AP, Payroll, etc. The accounting transactions could be created for both home and host, but by default will be in the same file.

Note: Custom reports could be created to split the data in this file by payment system or home/host location.

Total Compensation Methodology

The payment request designation is available for payments to be made in the secondary location. The payment request field determines who is responsible for making the payment.

Secondary Payment Request

When secondary payment request is selected, then transactions are generically available for reporting by the secondary payroll system with the secondary payment request report.

Primary Payment (Wire) Request

When primary payment request is selected, then transactions are generically available for reporting by the primary payroll system with the primary payment request report.

This report (payment request option) could also designate that a group of payments need to be wired to a secondary location by the primary payroll location.

Changes since Last Pay Period

Whether or not a comp worksheet or one of its parts (line item amounts or payments to home or host) has changed is tracked in the system.

Note: Each of these differences can be reported through the user report writer. As of today, the only standard report to note differences between periods is the compensation worksheet periods report.

Changes to a compensation worksheet since the last calculation period can be seen on the compensation worksheet list screen in the “Same as Prior” column.

Navigation: Assignments Tab

Compensation menu group

Compensation Worksheets menu

Changes to a compensation worksheet line item since the last calculation period can be seen on the compensation worksheet screen in the “Same as Prior” column.

Navigation: Assignments Tab

Compensation menu group

Compensation Worksheets menu

Select to View/Edit one of the comp worksheets

Changes to a compensation worksheet payment since the last calculation period can be seen in the payment instructions section of a compensation worksheet line item (denoted by the Changed text by location).

Navigation: Assignments Tab

Compensation menu group

Compensation Worksheets menu

Select to View/Edit one of the comp worksheets

Select to View/Edit one of the comp worksheet line items

Did this answer your question?