Custom Compensation Excel Reports
Service
Our
Custom Compensation Excel Reports Service allows you to request
an unlimited number of reports, at no
additional fee, with
detailed compensation data in Excel format with outputs for one or more jobs.
After you complete
participation requirements,
we provide powerful and easy-to-use tools for
customizing reports to only show the data
you need. Participants can select preferences for compensation components, data cuts, benchmark groups,
statistical metrics, and data aging.
Additionally, you can save your report preferences in an
unlimited number of profiles that can be re-used in future reports or shared
with other users in your company ... saving you valuable time.
Compensation
Components
You can select from
a wide range
of compensation data components from base salaries to long-term incentives.
-
Annual Cash Compensation
-
Base Salary
-
Cash Allowances
-
Car Allowances
-
Housing Allowances
-
Other Allowances
-
Total Cash Allowances
-
Guaranteed Cash Compensation
(Base Salary + Cash Allowances)
-
Short-Term Incentives (STIs)
-
Targeted Short-Term Incentives
-
Targeted Short-Term Incentives
as % of Base Salary
-
Actual Short-Term Incentives
-
Actual Short-Term Incentives as
% of Base Salary
-
Total Annual Cash Compensation
-
Salary Range Structures
-
Minimum of Salary Structure Range
-
Mid Point / Control Point of Salary
Structure Range
-
Maximum of Salary Structure Range
-
Overtime Eligibility / FLSA Exemption
Status
-
Sales Quota
-
Incentive Eligibility
-
Long-Term Incentives (LTIs)
View LTI data by individual job, job level, or salary level.
-
Billing Rates
(For Employees Working on Billable Projects)
Statistical Metrics
You can
customize
calculations for your compensation outputs by selecting statistical
metrics.
-
Average
-
Percentiles
(10th, 25th, 33rd, 40th, 50th, 60th,
65th, 67th, 75th, 90th)
-
Your Company's Percentile Rank
(see how your company compares
to market)
Data Cuts and
Filter Options
We
provide numerous
data cut and
filter options that enable you to target and view relevant segments of
compensation data.
- Standard Data Cuts
-
Data Cuts
for Start-ups and VC Funded Companies
-
Data Cut Filter -- Combine
Two Data Cuts (Cross-Tab)
If sufficient data is available for a specific job, we allow you to
combine two different data cuts. Examples include, but are not
limited to:
-
Industry Sector by Geographic Location
-
Company Size by Geographic Location
-
Company Size by Industry Sector
-
Corporate Status by Industry Sector
-
Create Custom Benchmark/Peer Groups
You can create and save an unlimited number of custom
benchmark groups
comprised of individually selected peer companies.
Note: We do not disclose or show data
for individual companies. Custom benchmark groups require a minimum
of 10 companies.
-
Incumbent Filters
-
New Hires
(Filter outputs to view compensation
for new hires)
-
Founder of Company
(Filter outputs to exclude or
include compensation for company founders)
-
Incumbents Receiving Short-Term Cash
Incentives
-
Incumbents Not Receiving Short-Term
Cash Incentives
-
Incumbents Receiving Cash Allowances
-
Incumbents Not Receiving Cash
Allowances
-
View Your Company's Data for
Comparisons to Market Data
We provide a separate
row of data that shows your company's
pay levels for each selected job, allowing you to see how you compare to market. This helps you
quickly detect which jobs are above or below market rates, providing a
useful method of communicating exceptions to management.
Note: Your company's data is not visible by other participants or
organizations.
Data Aging
You also have
the option to view cash compensation data adjusted to a common effective
salary date using budgeted base salary increase factors provided by
participants. Alternatively, you can view raw data (in aggregate form)
collected from participants that is not aged.
Sample Report
Click here to
request a sample custom report, trial subscription, or guided web demo. |