Exploring Payroll Analytics

Modified on Tue, 16 Apr 2024 at 12:46 PM

TABLE OF CONTENTS

Introduction


Keka's Payroll analytics feature is a valuable tool for gaining insights into your financial data. Here, you can access various details related to payroll, such as your most recently processed salary, upcoming salary payments, pending revisions, and a comprehensive breakdown of compensation.


It also allows you to visually compare planned versus actual compensation, view salary ranges across different financial years, and assess the average base pay. This tab provides an analysis of all payroll activities within Keka and offers a glimpse into future compensation projections.


Accessing Payroll Analytics


Click on Payroll (1), you will automatically be directed to the Analytics (2) tab under Payroll Analyics



To understand your financial insights, first select the pay group for which you need an analytical report. Click on the dropdown arrow indicated beside the name of the pay group and select a pay group from the dropdown. 



Under the pay group name, you will find the Last Salary Processed amount, which is generated based on the most recent payroll run in Keka. In the Upcoming Salary widget, you'll find the amount scheduled for processing in the coming month.


The next two widgets concern Upcoming Revisions and Pending Revisions. In Upcoming Revisions, you will see the number of employees whose salaries are due for revision. Clicking view employees provides a detailed report, including their names, job titles, departments, and the dates of their upcoming salary revisions. In Pending Revisions, you can view employees awaiting revision, along with the duration they've been overdue. Click view employees for employee details and period of overdue.



Compensation Summary

The compensation summary section offers a comprehensive report on compensation, categorized by Departments and locations, and projected as a pie chart. You can click on any slice of the pie chart to see the amount spent for a specific department or location. Furthermore, there are summaries near the pie charts to provide a quick overview of expenses. To view compensation data from past years, simply use the dropdown menu next to Financial Year at the upper right corner of the screen, and select your preferred year.



Planned vs. Actual Compensation

In this section, you'll discover a bar graph that shows the comparison between planned and actual compensation.

To explain further, Planned Compensation is the total sum of salaries promised to employees.  Actual Compensation is the real amount spent on compensation, which may differ from the planned amount for various reasons. 


This information is presented in the bar graph, with each bar representing a different month of the year. Just below the graph, you can find the amount of planned compensation, actual compensation, and their variance. Next to variance you have a hyperlink "What caused the dive?" click on it to find the reasons that caused a difference between actual and planned compensations.



Employees by Salary Range

In this section, you'll find an analytical report about the salary ranges of employees. This graph helps you understand the salary distribution, showing the range of salaries that employees fall into. The data is presented in percentages on the graph.


Note: The data represented in this graph is only for the last 4 years


Below this tab, you can explore the View Average Base Pay section, which displays information about experience and salary range. It's shown as a scale where one represents the average years of experience, and the other represents the annual salary range. The average values are listed below the scales. You can customize the settings and generate data of your choice by setting the criteria and clicking run to get the data displayed on these scales. The pie chart to the right illustrates the distribution of average pay.



In summary, the Analytics tab is a crucial tool for organizations to gain in-depth insights into their payroll data. With Keka, accessing this information is made simple and efficient, with just a few clicks.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article