Payroll Calculator

Description

Run payroll in minutes. Earned pay follows attendance, deductions are worked out from the rates you set, and net pay is ready for every employee, with a monthly history for the year. This payroll calculator Excel template also works in Google Sheets.

What it does

• Earned pay from salary and paid days
• PF, ESI, professional tax and TDS with editable rates
• Employer contributions and cost to company
• Net pay per employee and payroll totals
• Dashboard with gross vs net, cost by month and deductions

How it works

1. Settings: set the payroll month.
2. Directory and Attendance: add employees and mark attendance for the month.
3. Payroll: check rates, review pay and copy the totals to Payroll History.

What’s inside

Start Here guide, Dashboard (31 headline numbers and 15 charts), Directory, Attendance, Payroll, Payroll History, Analysis and Settings sheets.

Good to know

• Excel and Google Sheets: open it in Microsoft Excel, or upload it to Google Drive and choose Open with → Google Sheets. Formulas, dropdowns and charts carry over.
• Colour-coded: blue cells are for your entries, grey cells calculate automatically, so you can’t break a formula by accident.
• Sample data included: a demo business fills every sheet so the dashboard works from day one. Clear the blue cells when you start.
• Any currency: amounts show without a symbol, and you set your currency once in Settings.

Want every template?

This template is part of the Small Business Complete Bundle: all 38 templates in six workbooks, each with its own dashboard.

Step-by-step guide

New to this? Read our guide: How to Calculate Payroll in Excel for a Small Business in India.

Delivery

Instant download right after payment. The download link is also emailed to you and works up to 5 times within 30 days. One-time payment, no subscription. As a digital product, it is non-refundable once downloaded, but if a file is faulty we fix it, replace it or refund you. See our refund policy.