Office, HR & Freelancers Toolkit
Small offices and growing teams need payroll paperwork long before they can afford HR software: a salary sheet with PF and ESI, payslips for every employee, offer and experience letters, and a record of leave taken.
This toolkit gives you that paperwork as editable Excel and Word files with the calculations already in place, and an online salary slip maker for a quick single payslip.
Made for: Small business owners, office managers, HR executives, startups and freelancers who pay helpers.
What each one does
💰 Salary Sheet & Payslip (Excel)
Monthly payroll for a small team in one workbook. List your employees and their monthly salary once; each month type the days paid and any deductions. The sheet works out earned salary, employee PF and ESI, net pay and employer contributions, and the Payslip sheet prints a salary slip for any employee with the net pay in words.
- Setup: company, month, working days, PF and ESI on/off
- Employees: code, name, designation, department, joining date, PAN, UAN, bank account, basic, HRA and other allowances
- Salary sheet: days paid, earned salary, PF (12% of basic up to the ₹15,000 wage ceiling), ESI (0.75% when gross is up to ₹21,000), professional tax, TDS, advance, net pay
✉️ Offer Letter & Experience Letter (Word)
Two letters every employer writes: an offer letter when someone joins and an experience letter when they leave. Both are written in plain, professional English with clear blanks in [brackets] to replace. Edit once with your company details and reuse for every employee.
- Offer letter: position, department, reporting manager, joining date, place of work, monthly CTC with a salary table, probation, working hours, notice period, documents to bring, acceptance signature
- Experience letter: dates of employment, last designation, duties, conduct statement and good wishes, authorised signatory
- Company letterhead area at the top and reference number and date lines
🌴 Employee Leave Tracker (Excel)
Record every leave with its dates and type; the tracker counts the working days (skipping Sundays and your holiday list) and shows each employee's leave taken and balance for every leave type for the year.
- Settings: year start, leave types with yearly quota (Casual 12, Sick 12, Earned 15 to start with)
- Holidays list for the year
- Leaves sheet: employee, type, from, to, half day, reason; days counted automatically
⚡ Online Salary Slip Maker
A neat salary slip in a minute. Enter the company, employee and month, then the earnings and deductions. It totals, shows net pay in figures and words, and gives you a payslip ready to print or download. Company details are remembered on this device.
- Company and employee details
- Earnings and deductions lines you can add or remove
- Optional automatic PF (12% of basic up to ₹15,000) and ESI (0.75% when gross is up to ₹21,000)
Good to know
- Every template is free and contains no macros, so it opens without security warnings.
- Yellow cells are for typing; grey cells calculate by themselves and are protected against accidental overwriting (Review › Unprotect Sheet, no password).
- Online tools keep your details only in this browser on this device. Nothing is uploaded.
- Tax rates and statutory limits mentioned in these files are a help, not advice: check the current rules before relying on them.