# Hiring and Payroll Projection Model in India: Hiring triggers to cash

Published: 29 Oct 2026
Author: Treelife
Practice area: Finance
Tags: fully loaded employee cost India, headcount planning model, hiring and payroll projection model, manpower cost projection, payroll cost projection, people cost forecast, startup payroll budgeting India
Source: https://treelife.in/finance/hiring-and-payroll-projection-model-in-india/

---

Blog Content Overview

- [0.1 What is a hiring and payroll projection model?](#What_is_a_hiring_and_payroll_projection_model)

- [1 Why a hiring and payroll projection model beats a salary sheet](#Why_a_hiring_and_payroll_projection_model_beats_a_salary_sheet)
- [2 Headcount planning model structure: position level, not department level](#Headcount_planning_model_structure_position_level_not_department_level)
[2.1 Should open requisitions be in the model?](#Should_open_requisitions_be_in_the_model)

- [3 How many people to hire: demand drivers and hiring triggers](#How_many_people_to_hire_demand_drivers_and_hiring_triggers)
- [4 Fully loaded employee cost in India: the employer cost stack](#Fully_loaded_employee_cost_in_India_the_employer_cost_stack)
[4.1 Is employer PF part of CTC?](#Is_employer_PF_part_of_CTC)
- [4.2 Worked example: three positions, fully loaded](#Worked_example_three_positions_fully_loaded)
- [4.3 How does the ₹25,000 PF ceiling change payroll cost projection?](#How_does_the_25000_PF_ceiling_change_payroll_cost_projection)
- [4.4 Does the 50% wage rule raise gratuity cost?](#Does_the_50_wage_rule_raise_gratuity_cost)

- [5 Manpower cost projection beyond salary: the lines most models miss](#Manpower_cost_projection_beyond_salary_the_lines_most_models_miss)
- [6 Payroll cost projection for non employees: contractors, fixed term and EOR](#Payroll_cost_projection_for_non_employees_contractors_fixed_term_and_EOR)
[6.1 How is ESOP cost shown?](#How_is_ESOP_cost_shown)

- [7 How to build the payroll projection model step by step](#How_to_build_the_payroll_projection_model_step_by_step)
- [8 Attrition and backfill: modelling the cost of exits](#Attrition_and_backfill_modelling_the_cost_of_exits)
- [9 Scenario planning for a headcount planning model](#Scenario_planning_for_a_headcount_planning_model)
- [10 Reconciling the model to payroll: what investors test](#Reconciling_the_model_to_payroll_what_investors_test)
- [11 Common mistakes in hiring and payroll projection models](#Common_mistakes_in_hiring_and_payroll_projection_models)
- [12 FAQs on hiring and payroll projection models in India](#FAQs_on_hiring_and_payroll_projection_models_in_India)

A hiring and payroll projection model turns a hiring plan into a position level, monthly forecast of people cost, showing when each hire is triggered, what it costs fully loaded, and when that cost leaves the bank. People cost is the largest line in most Indian startup budgets, commonly 50% to 70% of monthly burn (Treelife VCFO engagement range, estimate), so a 10% error in this model moves runway by months. The inputs changed in the last year: the four Labour Codes took effect on 21/11/2025, the Income Tax Act 2025 applies from 01/04/2026, and the EPF wage ceiling rose to ₹25,000 a month from 17/09/2026. This guide covers how to size headcount, price each position under Indian rules, model attrition and timing, and reconcile the model so it survives diligence.

### What is a hiring and payroll projection model?

It is a position level spreadsheet or planning tool that forecasts headcount and people cost by month. It links each planned role to a trigger (revenue, customers, product milestones), a start date and a fully loaded cost that includes employer PF, EDLI, ESI, gratuity, bonus, benefits and hiring costs. Its outputs feed the P&L, the cash flow forecast and runway in the parent financial model.

## Why a hiring and payroll projection model beats a salary sheet

A salary sheet records who was paid; a hiring and payroll projection model decides who should be hired, when, and at what all in cost. The difference shows up in three places: hires are tied to business triggers instead of requests, cost is fully loaded instead of CTC, and timing follows joining and payment dates instead of offer dates.

The model answers questions the board will ask:

- How many months of runway does each senior hire cost at the current cash balance?

- If revenue lands 20% below plan, which hires move and by how much?

- What did the Labour Codes and the revised PF ceiling add to cost per head?

- What does attrition at the current rate cost in rehiring, not just in salary saved?

It is the people module of the [startup financial model](https://treelife.in/finance/financial-modeling-for-startups/). Its total feeds payroll in the P&L, the operating outflow in the cash forecast, and from there the runway figure explained in our [burn rate and runway guide](https://treelife.in/finance/burn-rate-runway-calculation-for-startups-in-india/).

## Headcount planning model structure: position level, not department level

A headcount planning model should be built one row per position, existing or planned, with a unique position ID. Department level plans (“Engineering: +6 in H1”) cannot model start dates, backfills, CTC conventions or state specific costs, which are exactly the items that make Indian payroll forecasts miss.

**Table 1: Recommended tab layout for a hiring and payroll projection model**

**Tab****Contents****Owner****Updated**DriversRevenue, customers, tickets, deployments and ratios that trigger hiresFounder, department headsMonthlyPosition registerPosition ID, status (filled, open, planned), department, cost centre, state, employment type, CTC band, CTC convention flagHROn every hire or exitComp assumptionsCTC bands, increment cycle, variable pay, joining bonus, notice buyoutHR, founderAnnually, plus offersStatutory rate tablePF, EDLI, admin, ESI, gratuity, bonus, LWF rates with ceilings, source and effective dateFinanceOn every legal changeMonthly gridPosition by month: FTE fraction, CTC, statutory cost, benefits, one time costsFormula onlyNever edited by handCash bridgeLag from P&L month to payment month for each cost lineFormula onlyNever edited by handScenariosBase, conservative, freeze togglesFinanceBoard cyclesReconciliationModel month vs payroll register vs HRMSFinanceMonthly

### Should open requisitions be in the model?

Yes. Approved but unfilled positions carry cost from their expected joining date, weighted by a fill probability. Leaving them out understates the committed cost the board has already approved; including them at 100% from the approval date overstates it.

## How many people to hire: demand drivers and hiring triggers

Hiring should follow business drivers, not requests. Each department needs one or two ratios that convert the operating plan into headcount, and each planned position needs a trigger that fires when the driver crosses a threshold. This makes the plan self correcting: if revenue slips, the hires slip with it.

**Table 2: Illustrative headcount drivers by function (calibrate to your own data)**

**Function****Driver****Illustrative ratio****Trigger example**Sales (B2B SaaS)New ARR target, quota per AEOne AE per ₹1 to 1.5 crore new ARR a year (estimate)Hire AE when pipeline coverage exceeds 3x for two monthsCustomer successAccounts or ARR managedOne CSM per 40 to 60 mid market accounts (estimate)Hire when accounts per CSM exceed 55SupportTickets per monthOne agent per 600 to 900 tickets a month (estimate)Hire when backlog exceeds 48 hours for four weeksEngineeringRoadmap milestonesSquad of 5 to 7 per product stream (estimate)Hire when the next funded milestone is approvedOperations (D2C)Orders per dayDepends on fulfilment model; use your own dataHire when orders cross a set daily volumeG&ATotal headcountOne HR or finance hire per 40 to 60 employees (estimate)Hire at headcount thresholds

The ratios above are planning starting points, not benchmarks; replace them with your own trailing six month data as soon as you have it. Sales hires also need a productivity ramp on the revenue side, which is covered in our [expansion budget preparation](https://treelife.in/finance/expansion-budget-preparation/) guide; this model carries only their cost.

Two useful checks on the output: revenue per employee (track the trend rather than an absolute target) and people cost as a percentage of revenue. If a plan pushes people cost above revenue growth for several consecutive quarters, the triggers are too loose.

## Fully loaded employee cost in India: the employer cost stack

Fully loaded employee cost is everything the company pays for a position in a year: CTC (adjusted for whether it includes employer contributions), employer statutory contributions, benefits, hiring costs, equipment and tools. Global guides add US payroll taxes; Indian models need PF, EDLI, admin charges, ESI, gratuity, bonus and state levies instead, each with its own wage base and ceiling.

The legal changes behind the stack (the 50% wage definition in section 2(y) of the Code on Wages 2019, the Code on Wages (Central) Rules 2026, and the ₹25,000 PF ceiling under Notification S.O. 5109(E) dated 17/09/2026) are explained in our [budget forecasting guide](https://treelife.in/finance/budget-forecasting-services-for-startups/). This section covers only how to compute them in the model.

**Table 3: Employer statutory cost components for a FY 2026-27 model**

**Component****Employer rate****Base and ceiling****Source****Formula logic**EPF + EPS12%PF wages; ₹25,000 a month ceiling from 17/09/2026 (₹15,000 earlier) where contribution is restrictedCode on Social Security 2020, Chapter III; EPF Scheme 195212% x MIN(PF wages, ceiling) if restricted, else 12% x PF wagesEDLI0.5%PF wages, capped at ceilingEDLI Scheme 19760.5% x MIN(PF wages, ceiling)EPF admin charges0.5%PF wagesEPFO notification (minimum to verify)0.5% x PF base usedESI3.25%Gross wages up to ₹21,000 a monthCode on Social Security 2020, Chapter IVIF(gross ≤ 21,000, 3.25% x gross, 0)Gratuity4.81% provisionWages as defined in section 2(y); ₹20 lakh tax free limitCode on Social Security 2020, section 5315/26 x monthly wages / 12, monthlyStatutory bonus8.33% to 20%Eligibility and calculation ceilings (₹21,000 and ₹7,000 or minimum wage under the repealed Payment of Bonus Act); current notified ceilings to verifyCode on Wages 2019, Chapter IVApply only to eligible positionsLabour welfare fundSmall fixed amountPer employee, state specificState LWF ActsLookup on state column

Wages for every row should be computed as MAX(basic + DA, 50% of total remuneration), so the 50% rule is enforced by formula rather than by memory.

### Is employer PF part of CTC?

It depends on the offer letter, and the model must record it per position. Most startups quote CTC inclusive of employer PF and gratuity, in which case the stack is already inside CTC and take home pay absorbs any increase. Where CTC is exclusive, the stack sits on top and raises company cost. A team hired over several years usually carries both conventions.

### Worked example: three positions, fully loaded

Assumptions: Maharashtra, FY 2026-27 full year at the ₹25,000 ceiling, PF restricted to the ceiling, CTC quoted exclusive of employer PF and gratuity, group health insurance ₹15,000 a head (flag: insurer quote needed), laptop and software ₹60,000 a head in year one (estimate).

**Table 4: Fully loaded annual cost by position, FY 2026-27 (₹)**

**Line****Support executive, ₹2.4 lakh CTC****Engineer, ₹12 lakh CTC****Engineering manager, ₹40 lakh CTC**Fixed CTC2,40,00012,00,00040,00,000Wages at 50%1,20,0006,00,00020,00,000Employer PF (12%)14,40036,00036,000EDLI and admin (1%)1,2003,0003,000ESI (3.25% of gross ₹20,000)7,80000Gratuity (4.81% of wages)5,77228,86096,200Statutory bonus (8.33% on ₹7,000 base, flag)6,99700Health insurance15,00015,00015,000Laptop and software60,00060,00060,000Recruitment fee (8.33% agency, engineer and manager only, estimate)099,9603,33,200**Year one fully loaded****3,51,169****14,42,820****45,43,400****Loaded multiplier on CTC****1.46x****1.20x****1.14x**

Two points the table makes that single employee calculators miss. First, the multiplier is highest on low CTC roles, because ESI, bonus and fixed per head costs weigh more there; applying one flat loading across the team understates support and operations cost. Second, year one is heavier than year two because recruitment and equipment are one time costs; the model should separate them so the run rate is visible.

### How does the ₹25,000 PF ceiling change payroll cost projection?

Only for companies that restrict PF to the statutory ceiling. For each such employee with PF wages of ₹25,000 or more, employer PF rises from ₹1,800 to ₹3,000 a month, or ₹14,400 a year. For employees with PF wages between ₹15,001 and ₹25,000 who were previously outside mandatory coverage, PF becomes a new cost. September 2026 needs a split month, with the new ceiling from 17/09/2026.

### Does the 50% wage rule raise gratuity cost?

Yes, wherever basic was below 50% of CTC. Gratuity under section 53 of the Code on Social Security 2020 is computed on wages as defined in section 2(y) of the Code on Wages 2019. A company with basic at 35% of CTC sees its gratuity base rise by about 43%. Fixed term employees also qualify for pro rata gratuity after one year, so they need the same provision line as permanent staff.

> Related reading: the legal background is in our explainer on the [new labour law in India](https://treelife.in/legal/new-labour-law-in-india-2025/).

## Manpower cost projection beyond salary: the lines most models miss

A manpower cost projection that stops at CTC and statutory contributions still misses 5% to 15% of real people cost (Treelife engagement observations, estimate). These lines are small per head but large across a growing team, and most are one time or event driven, so they need their own rows.

- **Recruitment cost.** Agency fees commonly run 8.33% to 15% of first year CTC for senior roles (market range, estimate), plus job boards and referral bonuses.

- **Joining bonus and notice buyout.** Buying out a 60 to 90 day notice period is common for senior tech hires; model it as a one time cost in the joining month.

- **Equipment and software seats.** Laptop, SaaS licences and access costs per head, with laptops capitalised if your policy says so.

- **Variable pay and commissions.** Accrue monthly, pay on the payout calendar. Sales commissions are often better modelled from bookings in the revenue model and linked in.

- **Overtime.** For non managerial staff, the Code on Wages 2019 requires overtime at twice the normal wage rate. Operations, warehouse and support teams should carry an overtime percentage.

- **Leave encashment.** Provide for accumulated leave that is encashable under your policy and the applicable state Shops and Establishments Act; it becomes cash on exit.

- **Remote employees in other states.** Professional tax (an employee deduction, capped at ₹2,500 a year under Article 276 of the Constitution) and labour welfare fund follow the employee’s state, so the position register needs a state column.

- **Minimum wage check.** Entry level CTC bands must clear the applicable minimum wage; the national floor wage under the Code on Wages is yet to be notified, so state notifications govern for now.

## Payroll cost projection for non employees: contractors, fixed term and EOR

Not every position should be an employee, and the payroll cost projection should compare routes on the same fully loaded basis. The three common alternatives each change the cost stack and the risk.

**Table 5: Cost treatment by engagement route**

**Route****Cost in the model****Statutory layer****Main risk to flag**Permanent employeeCTC plus employer stackFull PF, ESI, gratuity after five years, bonus if eligibleExit costs and fixed burnFixed term employeeSame as permanent, pro rataSame benefits; gratuity after one year under the Code on Social Security 2020Assuming fixed term is cheaperIndependent consultantFee plus 18% GST (input credit if eligible)None for the company; TDS under section 393 of the Income Tax Act 2025 deducted from paymentReclassification as employee if the role is controlled like oneStaffing agency or EORAgency invoice: CTC plus statutory cost plus margin, plus 18% GSTBorne by agency, recovered in invoiceMargin of 8% to 20% (estimate) and principal employer liability for contract labour

Contract labour rules and principal employer obligations are covered in our [contract labour compliance](https://treelife.in/legal/contract-labour-compliance-in-india/) guide.

### How is ESOP cost shown?

As a separate non cash line. ESOP expense under Ind AS 102 (or the ICAI Guidance Note on share based payments) is spread over vesting and sits in the P&L view only; it does not enter burn. The board should be able to read EBITDA with and without it.

## How to build the payroll projection model step by step

The build runs in eight steps. Each step reads only from the one before, so any error can be traced back to an input.

- **Fill the driver tab** with the operating plan: revenue, customers, tickets, milestones by month.

- **Load the position register** from the payroll register for filled roles and from approved and planned roles for the rest, each with a trigger or a target joining month.

- **Generate the FTE grid.** 1 for a full month, days employed divided by days in the month for joining and exit months, 0 otherwise. Multiply planned roles by fill probability in the base case.

- **Apply CTC with increments.** Annual CTC divided by 12, stepped up in the increment month (usually April), by band.

- **Compute wages** as MAX(basic + DA, 50% of total remuneration), then apply each statutory row from the rate table using its effective date.

- **Add benefits and one time costs** on their own rows: insurance, equipment, recruitment, joining bonus, notice buyout.

- **Bridge to cash.** Salary and PF or ESI lag one month, bonus and variable pay go to the payout month, gratuity and leave encashment become cash on exit. Our [cash flow forecasting guide](https://treelife.in/finance/cash-flow-forecasting-for-startups/) sets out the full statutory cash calendar.

- **Summarise** by department, cost centre and GL code, with headcount, cost per head and people cost as a percentage of revenue.

## Attrition and backfill: modelling the cost of exits

Attrition is not a saving; in most Indian tech teams it is a net cost once rehiring is counted. Model it with an annual attrition rate by department converted to a monthly rate, a backfill lag of two to three months (estimate), and an exit cost block.

The exit cost block should carry the full and final settlement (due within two working days of exit under the Code on Wages 2019), leave encashment, gratuity where the employee qualifies, recruitment fee for the backfill, and a productivity gap while the new hire ramps. Once recruitment fees, notice buyouts, settlement payouts and the productivity gap are added up, a 20% attrition rate on a 60 person engineering team costs more than the salary saved during vacancies.

Two practical rules: model attrition on the active headcount, not on the starting headcount, and never let backfills draw from the planned hiring budget silently. They should appear as their own line.

## Scenario planning for a headcount planning model

Scenarios should change drivers and toggles, not the grid. Because hires are trigger based, a revenue scenario automatically moves the sales and support hires, and a funding scenario moves the discretionary ones.

- **Base case:** drivers as planned, fill probability as estimated, increments at mid band.

- **Revenue miss case:** drivers 20% below plan; trigger based hires slip automatically; increments at the low end.

- **Hiring freeze case:** no new offers after a set month; backfill only for revenue critical positions.

- **Accelerated case:** funding closes early; senior hires pulled forward one quarter.

Each scenario should end in months of runway and the month cash hits the board’s minimum floor. Approval rules for moving a hire between scenarios sit in the budget governance described in our [budget forecasting guide](https://treelife.in/finance/budget-forecasting-services-for-startups/).

## Reconciling the model to payroll: what investors test

A model that does not reconcile to payroll will be discounted in diligence. Every month, compare three numbers: headcount and cost in the model, the payroll register, and the HRMS employee list. Differences usually come from leavers still in the final payroll cycle, consultants recorded in one system and not the other, employees on long leave, and CTC convention mismatches.

Keep a variance log by position, with a reason code. Investors typically test the current month against the payroll register and PF challans, then challenge increment and hiring assumptions. If the reconciliation is clean for six months, the forward plan gets credibility it would not otherwise have. The monthly payroll close itself is set out in our [virtual CFO payroll and TDS compliance](https://treelife.in/finance/virtual-cfo-payroll-tds-compliance/) guide.

## Common mistakes in hiring and payroll projection models

- **Planning by department, not position.** It hides start dates, state costs and CTC conventions. Fix: one row per position ID.

- **One flat loading percentage.** Low CTC roles carry a much higher multiplier than senior roles (Table 4). Fix: compute the stack per position.

- **Hard coded statutory rates.** Models built before September 2026 still carry the ₹15,000 ceiling inside formulas. Fix: one rate table with effective dates.

- **Hires driven by requests, not triggers.** The plan does not move when revenue misses. Fix: link every non leadership hire to a driver threshold.

- **Attrition treated as a saving.** Vacancy savings are counted; rehiring cost is not. Fix: an exit cost block per attrition event.

## FAQs on hiring and payroll projection models in India

**Q: What is the difference between a headcount plan and a payroll projection?**

A: The headcount plan says who and when; the payroll projection prices it. A good model holds both in one position register so a date change reprices automatically.

**Q: What loading should I add to CTC for budgeting?**

A: None as a flat rate. Compute the stack per position. In our worked example the year one multiplier ranged from 1.14x for a ₹40 lakh role to 1.46x for a ₹2.4 lakh role.

**Q: What gratuity rate should the model use?**

A: 4.81% of annual wages as a monthly provision, being 15/26 of monthly wages for each year of service under section 53 of the Code on Social Security 2020. Replace it with an actuarial valuation once the obligation is material.

**Q: How long does it take to build the model?**

A: Two to three weeks for 30 to 100 employees. Most of the time goes into cleaning CTC data, confirming conventions and reconciling to payroll.

**Q: What documents are needed?**

A: The last three payroll registers, CTC breakups or offer letters, the HRMS employee list, the approved hiring plan, and the leave, bonus and variable pay policies. The payroll register closes most gaps.

**Q: How often should it be updated?**

A: Actuals and reconciliation monthly; drivers and triggers quarterly or whenever the operating plan changes.

**Q: Does the ₹25,000 PF ceiling apply to every employee?**

A: It changes cost only where PF is restricted to the ceiling or where employees between ₹15,001 and ₹25,000 now enter mandatory coverage. Companies already contributing on actual wages see no change.

**Q: Are fixed term employees cheaper to model?**

A: No. Under the Code on Social Security 2020 they receive the same benefits as permanent staff and pro rata gratuity after one year.

**Q: How should co-founder salaries be treated?**

A: As employee cost with the full stack if co-founders are on payroll. Modelling them at zero inflates runway and is one of the first items investors correct.

**Q: Does DPIIT recognition change payroll cost?**

A: Not employer cost. It can defer tax on ESOP perquisites for eligible employees, which changes employee cash flow, not the company’s people cost.

**Q: What happens to the model if a planned hire falls through?**

A: The trigger stays live and the position moves to the next feasible month; the base case already discounts it by fill probability. Show the saving against budget rather than reallocating it.

**Q: How do investors review the payroll model?**

A: They reconcile the current month to the payroll register and PF challans, then test increments, triggers and attrition. An unreconciled starting month is the first red flag.

**Q: Should ESOP cost be in the payroll model?**

A: Yes, as a separate non cash line under Ind AS 102, excluded from burn so both EBITDA and cash can be read.

**Q: Is a consultant cheaper than an employee?**

A: Often on paper, because there is no statutory stack, but GST at 18% applies (with input credit if eligible) and a role controlled like employment carries reclassification risk. Compare on a fully loaded basis.

**Regulatory references**:

- Code on Wages 2019: section 2(y) (wages, 50% rule), Chapter IV (bonus), overtime and wage payment provisions; in force from 21/11/2025; Code on Wages (Central) Rules 2026 notified 08/05/2026

- Code on Social Security 2020: Chapter III (EPF), Chapter IV (ESI), section 53 (gratuity, including fixed term employees); in force from 21/11/2025

- Notification S.O. 5109(E) dated 17/09/2026: EPF wage ceiling raised from ₹15,000 to ₹25,000 a month

- EPF Scheme 1952, EDLI Scheme 1976

- Income Tax Act 2025: section 393 (TDS on payments other than salary); in force from 01/04/2026

- Constitution of India, Article 276 (professional tax cap)

### Related posts:

- [What Is An Income Statement?](https://treelife.in/finance/what-is-an-income-statement/)

- [The Rise & Fall Of Indian IPO’s](https://treelife.in/finance/the-rise-fall-of-indian-ipo/)

- [Tyke’s CSOPs: Bridging Startups with Investors or Crossing Regulatory Boundaries?](https://treelife.in/finance/tykes-csops-bridging-startups-with-investors-or-crossing-regulatory-boundaries/)

- [Revised Valuation Rules for Angel Tax](https://treelife.in/finance/revised-valuation-rules-for-angel-tax/)

---

This is informational content from Treelife. For advice specific to your situation, contact support@treelife.in