Monthly Payroll Movements

About the Template:

This interactive Power BI template centralizes payroll analytics—summarizing total salary, deductions, headcount, and department splits—so HR leaders can compare months and years, control costs, and optimize compensation decisions with calendar-driven filtering.

Key Features:

1. Executive KPIs for Total Salary, Total Deduction, No. of Departments, and No. of Employees
2. Month-by-month salary trend with year comparison (e.g., 2024 vs 2025)
3. Compensation mix breakdown across Basic, Transportation, Other Allowance, and Accommodation
4. Department-wise salary totals to highlight top cost centers
5. Interactive calendar slicers by Year, Quarter, and Month
6. Department slicer for focused analysis across Finance, HR, Leasing, Marketing, and Operations

Top Visuals:

1. Total Salary (KPI Card)
2. Total Deduction (KPI Card)
3. No. of Departments (KPI Card)
4. No. of Employees (KPI Card)
5. Total Salary by Month and Year
6. Salary Distribution
7. Total Salary by Department
8. Calendar (Year, Quarter, Month) (Slicer)
9. Departments (Slicer)