PayrollPro — Attendance & Salary Workbook (Excel + Google Sheets)

Run your monthly payroll in minutes, not days

PayrollPro is a ready-to-use Excel and Google Sheets workbook for small businesses. Mark attendance, and the workbook calculates earned salary, deductions, net pay and employer cost, then produces a printable payslip for every employee.

What's inside

• Attendance sheet with dropdown codes: Present, Absent, Paid Leave, Holiday, Weekly Off, Half Day. Paid days are counted automatically.
• Salary register that prorates Basic, DA, HRA and other allowances by paid days and calculates gross pay, deductions and net pay.
• One-click payslips: choose an employee ID and print or save as PDF.
• Dashboard with total gross pay, net pay, statutory liabilities and cost to company, plus a chart.
• Setup sheet: company details, payroll month, currency and every rate in one place.
• Step-by-step guide inside the file.
• Up to 100 employees. Formula cells are protected so they can't be overwritten by accident.

Bonuses included (free)

• Leave Register workbook: tracks EL, CL, SL and leave-without-pay balances for up to 100 employees.
• Printable Monthly Payroll Checklist (PDF): every step from attendance close to PF, ESI and TDS deposit, on one page.

Built for India, usable anywhere

• India: PF and ESI are calculated automatically using the 2026 rules: PF wage ceiling of ₹25,000 (effective 17 September 2026), the EPS/EPF employer split, the ₹21,000 ESI limit and the Code on Wages 50% wage rule. All rates are editable.
• Outside India: switch PF and ESI off, set your currency (USD, GBP, AED or any other), and use it as a clean attendance and salary system. Add any fixed monthly deduction per employee.

Who it's for

Owners and office managers of businesses with 5–100 staff, shops, clinics, schools, NGOs, and accountants who run payroll for clients.

What you need

Microsoft Excel 2010 or later, or a free Google account for Google Sheets. No macros, no add-ins, no subscription.

Support

If the file doesn't open or a formula doesn't work as described, email me within 7 days of purchase and I'll fix it or refund you in full.

Note: this workbook is a calculation tool, not legal, tax or payroll advice. Statutory rates change over time, so please confirm current rates with the relevant authority or your accountant before filing. Rates last reviewed November 2026.

Frequently asked questions

I'm outside India. Will it work?

Yes. Switch PF and ESI off on the Setup sheet and set your currency. Add any fixed monthly deduction per employee.

Does it follow Indian labour codes?

Calculations follow the Code on Wages 50% rule, the ₹25,000 PF wage ceiling from 17 September 2026 and the ₹21,000 ESI limit. It is a calculation tool, not a legal certificate.

What if rates change?

Change the rate once on the Setup sheet and the whole file updates.

How many employees can it handle?

Up to 100.

Do I need a new file every month?

No. Save a copy for each month and update the attendance.

Does it file PF or ESI returns?

No. It shows how much to pay; you or your accountant file on the official EPFO and ESIC portals.

Can I use it for several companies?

One licence covers one business. Accountants managing several clients need one licence per client business.

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. It also works in Microsoft Excel 2010 or later. No macros, no add-ins and no subscription.

I'm not good at Excel. Can I use it?

Yes. You only type in the yellow cells; every formula is already built and protected. A step-by-step guide sheet is inside the file.

Does it work on mobile?

It opens in the Google Sheets and Excel apps, but a laptop or desktop is much easier for regular work.

Is my data safe?

The file stays on your own computer or Google Drive. We never receive or see your data.

How do I pay and get the file?

Pay by PayPal or card worldwide, or by UPI, card or net banking in India. The download link appears instantly and is also emailed to you.

What if the file doesn't work?

If the file doesn't work as described and we can't fix it within 7 days, you get a full refund. Email us through the store's contact page.