
Attendance and Payroll Template
Mark attendance once. Salary and payslips are done for you.
Secure payment with Razorpay. Instant download after payment. Login needed to buy.
- Instant download (.xlsx)
- How-to sheet inside the file
- Formula-based, no macros
About this template
Stop calculating salary by hand. Add your employees, mark each day as Present, Absent, Leave or Half day, and the file works out pay days, overtime, deductions and net salary.
Pick any employee and a print-ready payslip appears, ready to save as PDF.
How it helps you
- Save hours of salary work every month
- Fewer mistakes in pay and deductions
- Give every employee a clean payslip
- Works in any country: set your own deduction rates
What you get
- Ready-to-use Excel file (.xlsx), no macros
- Daily attendance grid for 30 employees
- Automatic pay days, overtime, bonus and net salary
- Two deductions you can rename (for example provident fund or tax)
- Printable payslip
- "How to use" sheet inside the file
What is inside the file
- How to use
- Settings
- Employees
- Attendance
- Payroll
- Payslip
Who it is for
- Small business owners and shop owners
- Clinics, offices and factories
- HR and accounts staff
How to use it
- Open Settings and type company name, month and deduction rates
- Add employees with their salary
- Mark P, A, L or H for each day
- Check Payroll, then print the Payslip
Requirements
- Microsoft Excel 2016 or newer on Windows or Mac (also works in Excel for the web)
Questions
Which country does it work for?
Any. You set your own deduction percentages in Settings.
I have more than 30 employees.
Copy the last row of each sheet downward, or request a custom version.
How do I get the template after paying?
The download starts right after payment. You can also download it again from your Purchases page (up to 3 times).
Which Excel version do I need?
Microsoft Excel 2016 or newer on Windows or Mac (also works in Excel for the web)
Will it work with my own data?
Yes. Clear the sample rows and type or paste your own data. The how-to sheet at the start of the file shows where to type.
Can you change it for my business?
Yes. Use the "Request your own template" button and tell us what you need. We reply with a quote.
Can I get a refund?
Because this is a digital file that downloads instantly, all sales are final. If the file does not open or work, contact us and we will help.
More templates
Need something different? Request your own template
Tell us what you need. We build custom Excel templates for your work, and reply with a quote.


