Always hold
Match Vendor Earnings to Company, in this order
Vendor above Company: steps 1–5 reduce in order. Vendor below: step 1 raises PI. With the 50% rule on, anything over the limit moves from PI, Conveyance, HRA into Basic + VDA.
Daily Att MinBasic Rate Cap Qty Mult Months · Basic Bonus Leave Conveyance HRA PI OT WAH Food TADA Gross Allowances Earnings PF ESIC PT Deductions Net Yearly Accrued CTC · Functions: MIN MAX IF ROUND SUM ABS · Rate% means Rate ÷ 100.Minimum wage per day for each skill type. Basic + VDA = daily wage × attendance whenever a sheet's Minimum wage flag is Y. Only Highly Skilled came from your workbook; fill in the other rates.
| Skill type | Daily wage ₹ | Monthly @26 |
|---|
How often Bonus and Leave are paid. Months = 1 is paid every month and goes into Gross. More than 1 (Yearly = 12): the row shows the full amount for that period (× Months), it stays out of monthly Gross, and its monthly share (amount ÷ Months) is added to CTC.
| Frequency | Months |
|---|
Puts every master and both sheets back to the values from your workbook.