# Contract Labour Wage Register with PF and ESI (Excel Worksheet) > Source: https://netray.co/tools/contract-labour-wage-register-pf-esi-worksheet-india > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable register of contract workers with days worked, daily wage, gross, employee PF and ESI deductions and net pay. ## Category ehs-workforce ## Region India ## Industry Discrete Manufacturing ## Audience - HR manager - Plant manager - Contractor ## Tool **Kind:** worksheet **Mode:** editable **Currency:** Rs **Columns:** #### Contractor **Key:** contractor **Type:** text #### Worker name **Key:** worker **Type:** text #### Skill category **Key:** skill **Type:** select **Options:** - Unskilled - Semi-skilled - Skilled - Highly skilled #### Days worked **Key:** days **Type:** number #### Daily wage **Key:** wage **Type:** number **Format:** currency #### Gross wage **Key:** gross **Type:** number **Expr:** days * wage **Format:** currency #### Employee PF at 12% **Key:** pf **Type:** number **Expr:** min(days * wage, 15000) * 0.12 **Format:** currency **Help:** Applied on wages up to the Rs 15,000 ceiling. Your policy may use actual wages. #### Employee ESI at 0.75% **Key:** esi **Type:** number **Expr:** if(lte(days * wage, 21000), days * wage * 0.0075, 0) **Format:** currency **Help:** Applies when monthly wages are within the Rs 21,000 limit #### Net pay **Key:** net **Type:** number **Expr:** days * wage - min(days * wage, 15000) * 0.12 - if(lte(days * wage, 21000), days * wage * 0.0075, 0) **Format:** currency **Rows:** **Contractor:** Balaji Manpower **Worker:** Ramesh Kumar **Skill:** Semi-skilled **Days:** 26 **Wage:** 620 **Contractor:** Balaji Manpower **Worker:** Sunita Devi **Skill:** Unskilled **Days:** 24 **Wage:** 540 **Contractor:** Balaji Manpower **Worker:** Imran Shaikh **Skill:** Skilled **Days:** 26 **Wage:** 780 **Contractor:** Shakti Labour Supply **Worker:** Vijay Patil **Skill:** Highly skilled **Days:** 25 **Wage:** 1100 **Totals:** #### Total gross **Key:** gross **Agg:** sum **Format:** currency #### Total employee PF **Key:** pf **Agg:** sum **Format:** currency #### Total employee ESI **Key:** esi **Agg:** sum **Format:** currency #### Total net pay **Key:** net **Agg:** sum **Format:** currency **Summary:** #### Average net pay per worker **Key:** avg_net **Expr:** sum_net / count **Format:** currency **Primary:** true #### Employee deductions as share of gross **Key:** deduction_pct **Expr:** if(gt(sum_gross,0), (sum_pf + sum_esi) / sum_gross * 100, 0) **Format:** percent **Notes:** Statutory rates and wage ceilings change. Minimum wages, PF wage definitions and ESI coverage depend on your state and current law. The principal employer also has duties for wages and contributions, so confirm the register format your state requires. ## Content **Intro:** Plants using contractors still carry responsibility for wage payment and statutory contributions. This worksheet is a working wage register that computes gross pay, employee PF, employee ESI and net pay from days and daily wages, and exports cleanly for contractor bills and audits. **Sections:** #### How to use the register **Body:** List each worker once per wage period with the contractor name and skill category. Enter days worked and the daily wage. The sheet calculates gross, employee PF at 12 percent on wages up to the Rs 15,000 monthly ceiling, and employee ESI at 0.75 percent where monthly wages are within Rs 21,000. Net pay is gross less those two deductions. Employer contributions are additional and are not shown, so add them in your cost sheet. **Bullets:** - Use one sheet per wage month - Check daily wage against the minimum wage for the skill category in your state - Keep attendance records that support days worked - Reconcile totals to the contractor invoice #### Why this register matters **Body:** Labour law places duties on the principal employer, including in many cases ensuring that wages and contributions are paid by the contractor. Auditors and inspectors often ask for registers of workers, attendance and wages. A tidy register tied to attendance data answers most questions quickly. Under the new labour codes, formats and thresholds may differ, so confirm the current requirements with your labour consultant. #### Common mistakes **Body:** Frequent errors include applying PF on gross even where your policy uses the ceiling, forgetting that ESI stops once wages cross the coverage limit, paying below minimum wage for the skill category, and accepting contractor bills that do not reconcile to the register. Also keep a record of the contractor licence and its validity for each contractor listed. **Cta:** If attendance and payroll sit in your ERP or time system, we can help generate this register straight from that data. The sheet works manually as well. **Faq:** #### Are the PF and ESI rules fixed? **Answer:** The sheet uses common rates: 12 percent employee PF on wages up to Rs 15,000 and 0.75 percent employee ESI where wages are within Rs 21,000. Thresholds and rules can change, so confirm against current law. #### Does it include employer contributions? **Answer:** No. It shows employee side deductions and net pay. Employer PF, ESI and other costs should be added in your costing or contractor billing sheet. #### Can I add overtime or allowances? **Answer:** You can add a number column and edit the totals in your exported Excel copy. Overtime has its own rules, so see the overtime calculator in this series for the Factories Act basis. #### Is this a statutory format? **Answer:** No. It is a working register. Some states prescribe formats such as wage registers, so use the prescribed form where required and treat this as a calculation aid. ## Search terms contract labour wage register format, contract labour register excel, pf esi calculation sheet, labour wage sheet excel india, contractor payroll register format, wage register for factory, principal employer contractor register --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json