How do I run a report on compensation changes?

Looking to see changes in compensation over time? Custom reports are for you!

In order to see pay information over time, you should start at Company Reports. You can navigate from the left side menu:

screely-1607375226634-png-1

There are two common compensation reports you may want to pull.

  1. Run a report of compensation at a certain point in time
  2. Run a report of compensation changes over time

To run a compensation report at a specific point in time:

Scroll down to Custom Reports and at the very bottom, click +Add Custom Report.

Name your report and configure the desired settings.

  • For effective date, change the drop down from "Today" to "Custom Date", then choose your date from the calendar.

screely-1607387667431

Click Save in the bottom right corner and the report appears at the bottom of the Reports Page.  Click the three dots to the right of the report title then click View Report. View or download the results from there 🎉

To run a report of compensation changes over time:

Scroll down to Custom Reports and at the very bottom, click +Add Custom Report.

Name your report and configure the desired settings.

  • If you want to include terminated employees on the report, change the first filter to show "All Team Members".
  • In the dropdown for effective date, select "Show Changes Made".
  • Next, pick your desired date range from the second drop down. A common selection is "Year to Date"
  • Under Report Fields, choose the fields you wish to see data for. Effective date will be included on the report by default. 
    • If you want to see the old data too, include Previous Wage Type and Previous Wage Rate.
  • Most commonly your set-up would look something like this:

screely-1607387900962

  • You may want to include other fields like employment type, termination date, etc. Feel free to add as many as you'd like!

Click Save in the bottom right corner, then choose the report from your custom list to run and view the results.

screely-1607388066515

In the above example, it shows that Arya Stark's wage of $300,000 became effective on 2/3/2020 and that her wage type did not change at all the whole year.

You can leave the report and come back to it later or download as needed. 

For more general information on how Change Reports work, see this help article.

 

If you have any other questions please reach out to help@goco.io.