Free MSME Tool

MSME Smart Payroll Workbook Generator

Generate a ready-to-use 20-sheet Excel workbook with auto attendance tracking, daily salary calculation, overtime, PF/ESI deductions, hike history, and CTC analysis.

20 Sheets Auto Salary Formula Overtime Tracking PF & ESI Hike History Advances & Purchases CTC Analysis Holiday Config

How it works: Fill in your employee and payroll settings below, then click Generate. You'll get a fully-formatted Excel workbook — just open it and start entering daily attendance times. All salary calculations, deductions, and summaries update automatically.

Employee Information

Name, ID, joining date, year

Employee Name *

Employee ID

Joining Date

Payroll Year *

Salary & Work Hours

Base salary, hours, overtime

Monthly Base Salary (₹) *

Working Hours Per Day

Break Time (minutes/day)

Half-Day Threshold (hours)

Shift Start Time

Enable Overtime Tracking

Overtime Multiplier e.g. 1.5x = time-and-a-half

Weekly Off & Leave

Off days, paid weekly off, leave allowance

Weekly Off Days Select which days are off each week

Weekly Off Days are Paid

Sick Leave Per Month 0 = not applicable

Casual Leave Per Month 0 = not applicable

PF & ESI Deductions

Provident Fund and ESIC configuration

Provident Fund (PF / EPF)

Employee Contribution %

Employer Contribution %

ESIC (Employee State Insurance)

Employee Contribution %

Employer Contribution %

Note: ESI is generally not applicable for companies with fewer than 10 employees or where monthly gross salary exceeds ₹21,000. PF may not be mandatory for companies with fewer than 20 employees.

Holidays

National, state, festival, company holidays

Holiday Name	Date	Type	Paid	Active

Salary Hike History (Optional)

Record salary increments for accurate monthly pay

Leave blank if no hike happened this year. Keep rows sorted by date (oldest first) for formulas to work correctly.

Effective Date	Old Salary (₹)	New Salary (₹)	Reason

Export Format

📄 XLSX (Excel) — Recommended

📄 ODS (LibreOffice / Google Sheets)

Sheets included in the workbook:

Instructions Employee Master Holiday Config January February March April May June July August September October November December Salary Summary Hike History Advances Ledger Purchases Ledger Employer Cost