"Everything but the kitchen sink" means almost everything.
I have worked with several employers that have an Excel file called the Kitchen Sink Report. It is a file with all the fields that you could possibly need when doing a compensation analysis.
It is usually developed after the Comp/HR team members determine that they are each pulling separate reports from the HR system, and it is more efficient to have one report with every bit of data in it as a starting point. And then each person can make a copy of the Kitchen Sink Report to start their analysis.
When you start an analysis in an Excel spreadsheet and then midway through you realize you need a couple more fields of data, it is a pain to go back and generate another report. And then you use a Lookup formula to connect the files so you can complete the analysis.
Rarely do I find an HR function or Compensation department with enough staff to do all the work that is expected within the time frames they are given. Prioritization and efficiency (no rework!) are incredibly important.
So, I’m curious. Do you have a Kitchen Sink Report?
#compensation #pay #rewards #excel #hr #humanresources #analysis #report #data #hrsystem #reporting #prioritization #efficiency #norework