Import compensation history



After you've turned on a Payroll Sync, ChartHop will automatically capture all compensation changes going forward. However, while onboarding, you may want to import the history of past compensation changes.

You can import this past information by uploading a CSV from the Import CSV Data page.

Columns

  • Identifier: Similarly to any other data import, you must provide an identifier for the person. We recommend using Work Email to uniquely identify individuals.
  • Date: Each row should contain the effective date of the compensation.
  • Other columns may include:

Column

Meaning

Example value

Base Comp

Annual base compensation as of the effective date

$80,000

Hourly Comp

If the compensation is hourly, the hourly rate

$14.50

Variable Comp

Annual variable compensation (OTE or target bonus)

$40,000

Currency

ISO three-digit currency code of the compensation (if different from your org's default)

EUR

Example

Email

Date

Base Comp

Variable Comp

6/1/2016

$80,000

 

3/1/2017

$95,000

 

1/1/2018

$105,000

$20,000

Sample CSV file: