Salary Register with Auto-Calculations
Summary sheet: payroll KPIs (employees, total gross/deductions/net, average) and a payroll-composition chart. Register sheet: basic + allowances auto-sum to Gross, minus Deductions = Net, with a TOTAL row, AED formatting, status dropdown, and a data-bar on net salary.
There is also a lightweight version of this template: Salary Register · Free
This free Salary Register makes monthly payroll simple. Enter each employee's basic pay, allowances and deductions and the template instantly calculates gross and net salary, with a TOTAL row that sums the whole payroll. Amounts are formatted in AED and a net-salary data bar makes high and low earners easy to spot.
A separate summary sheet gives you the headline numbers — total gross, total deductions, total net payroll and average pay — plus a payroll-composition chart. Built for Microsoft Excel 2016+, it comes with sample employees so you can see exactly how every formula works.
Key features
- Auto gross = basic + allowances
- Auto net = gross minus deductions
- Payroll TOTAL row
- Monthly payroll summary and chart
- AED currency formatting
- Built for Microsoft Excel 2016+
This template is designed for HR and finance teams who process monthly salaries, manage deductions and need an accurate payroll record without specialist software — without the need for expensive specialist software.
The Salary Register with Auto-Calculations is part of our HR & Workforce Management collection — downloaded 4 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Frequently asked questions
Is the salary register free?
Yes, free download with no sign-up.
Does it calculate net pay?
Yes, gross and net salary calculate automatically as you enter figures.
Can I change the currency?
Yes, it is set to AED but you can reformat to any currency.