Payroll & Salary Templates Run payroll accurately and keep every salary record in one place. These payroll and salary templates calculate gross and net pay, overtime, allowances and deductions, track salary advances and leave, and produce the figures you need at month-end in Excel or Google Sheets.
What's in this collection
- Payroll Calculator: gross and net pay for every employee, including overtime, bonuses and deductions.
- Overtime Tracker: overtime hours and pay at normal and premium rates.
- Salary Advance & Employee Loan Tracker: advances, monthly deductions and balances.
- Employee Cost-to-Company Calculator: the true cost of each employee, including visa, insurance and tickets.
- End-of-service tools:Gratuity Calculator (UAE) and Final Settlement Calculator.
- Payslip logs, payroll variance reports, increment planners, bonus calculators and headcount budgets.
Who these templates are for
Small and growing businesses with up to a few hundred staff, HR and admin teams, accountants who run payroll for clients, and households that pay domestic staff.
A clean monthly payroll routine
- Update the employee list for joiners, leavers and salary changes.
- Import attendance, leave and overtime for the month.
- Enter deductions such as advances, loans and absences.
- Review the payroll variance report against last month and explain every change.
- Approve, pay, and keep a locked copy of the month's file for your records.
Accuracy and compliance
The templates calculate from the figures and rules you enter. Overtime rates, allowances and deductions vary by country and contract, so set them to match your employment contracts and local law. In the UAE, salaries are usually paid through the Wage Protection System (WPS); these files help you prepare and check the figures you upload to your bank or exchange house.
Build a complete HR toolkit with our bundles or the value packs, from AED 29 for 25 templates.
Frequently asked questions
Does the payroll calculator generate payslips?
It calculates every pay component per employee, ready to copy into your payslip format. For letters, the store also has a Word Salary Certificate template.
Can I use it for WPS?
The files help you prepare and check salary figures. The WPS file format itself comes from your bank or payroll agent.
How many employees can it handle?
It is designed for small and medium teams and works comfortably with a few hundred rows.
Can I change the overtime rate?
Yes. Normal and premium overtime multipliers are input cells, so you can match your contracts and local rules.
