Skip to main content

Export Compensation Cycle Results

A
Written by Adam Kroboth

Admins can download a CSV export of final compensation changes to review or upload to an HRIS or payroll system.

  1. Navigate to Admin > Compensation > Compensation cycles.

  2. Click to enter the desired compensation cycle.

  3. Navigate to the Recommendations tab.

  4. On the top right-hand corner of the table, click Export:

    • All cycle results: Download a CSV of all compensation changes for each employee

    • History of all changes: Download a CSV that tracks all manager submissions and notes

All cycle results

The following columns are included in the export:

  • Employee name

  • Employee email

  • Department

  • Job title

  • Manager

  • Status (eligible/ineligible)

  • Currency

  • Pay type

  • Last comp change date

  • Performance rating (if included)

  • Current job function, type, and level

  • Current pay zone

  • Current band min, mid, and max base pay

  • Current band min, mid, and max variable pay

  • Promotion (Y/N)

  • New pay type

  • New job function, type, and level

  • New pay zone

  • New band min, mid, and max base pay

  • New band min, mid, and max variable pay

  • Current and New base salary

  • Current and New variable pay

  • Current and New on-target earnings

  • Current and New base/variable ratio

  • Current and New bonus amount

  • Current and New total cash

  • Current and New compa ratio

  • Raise guidance and recommendation in % and $

  • Bonus plan payout

  • One-time bonus payout

  • Refresh and Promotion equity shares

  • Refresh and Promotion equity award type

  • Refresh and Promotion equity exercise price

  • Refresh and Promotion equity currency

  • Refresh and Promotion equity start date

  • Refresh and Promotion equity term (months)

  • Refresh and Promotion equity vesting cliff (months)

  • Refresh and Promotion equity vesting cadence

  • Annualized pay

  • Custom fields

  • External User IDs (if integrated with an HRIS)

History of all changes

The following columns are included in the export:

  • Employee name

  • Department

  • Recommender name

  • Approver name

  • Approval order

  • Submitted at (date & time)

  • Currency

  • Pay type and New Pay type

  • Current base pay

  • Current base annualized

  • Guidance for base pay raise

  • Recommended base bay

  • Recommended base pay annualized

  • Current variable pay

  • Current compa ratio

  • Guidance for variable pay raise

  • Recommended variable pay

  • Recommended compa ratio

  • Guidance for bonus plan payout

  • Recommended bonus plan payout

  • Guidance for one-time bonus payout

  • Recommended one-time bonus payout

  • Guidance for refresh equity grant

  • Recommended refresh equity grant

  • Guidance for promotion equity grant

  • Recommended promotion equity grant

  • Notes

  • Custom fields

  • External User IDs (if integrated with an HRIS)

Related Articles
Did this answer your question?