Cellgrids Cellgrids
Home › Excel templates › Attendance and Payroll Template
Attendance and Payroll Template preview

Attendance and Payroll Template

Mark attendance once. Salary and payslips are done for you.

₹349

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

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

How to use it

  1. Open Settings and type company name, month and deduction rates
  2. Add employees with their salary
  3. Mark P, A, L or H for each day
  4. Check Payroll, then print the Payslip

Requirements

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

Invoice & Billing Tracker

Invoice & Billing Tracker

₹249
Inventory Management Template

Inventory Management Template

₹299
Sales & KPI Dashboard

Sales & KPI Dashboard

₹349

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.

All Excel templates · Free Excel practice · Excel formulas