In this guide 6 sections
Run the month in a fixed order. Lock attendance from gate and muster records, build the wage register, work out deductions, prepare the PF and ESI files, then fill the principal employer’s formats. Software holds each step in one place. Confirm current rules with your compliance consultant.
Lock attendance before anything else
Every later number depends on attendance. Pull the gate swipe or entry register for each plant or mine where you supply workers, and set it beside your own muster sheet. Mark every difference against a worker code.
Typical gaps are easy to name. A worker swiped in at Bokaro but was shifted to a second gate. A night shift crosses midnight and splits across two dates. A replacement worker used the absent man’s card. Settle each gap with the site supervisor in writing. Then freeze the month.
Do this by the second working day of the month. Late attendance fixes push every later step back, and the bank run for wages waits on them.
Build the wage register from the frozen muster
The wage register lists each worker with days worked, overtime hours, the rate for the skill grade and the earned amount. Keep worker code, name, UAN, ESIC insurance number, bank account and site on the same row, so nothing is retyped later. Overtime needs its own column. Plants ask for it separately.
Advances need their own care. A worker who took money at Dhanbad mid-month should show the recovery against the right month, with the date and the supervisor who approved it. A disputed recovery is far easier to answer from a dated line than from memory. Casual workers who join mid-month need care. Enter the joining date and the gate card number on day one, and raise the UAN and insurance number request at once. Workers left without numbers are the commonest reason a file is rejected or a claim delayed later.
Advances need their own care. A worker who took money at Dhanbad mid-month should show the recovery against the right month, with the date and the supervisor who approved it. A disputed recovery is far easier to answer from a dated line than from memory.
- Worker code, name, UAN and ESIC number
- Site, department and skill grade
- Days present, weekly offs and overtime hours
- Rate card applied and earned wages
- Advances and other recoveries
- Net payable and bank account
Prepare the PF and ESI files
Once the register is final, the contribution figures come from it. The provident fund return is uploaded as an ECR text file on the EPFO portal. ESI contributions are filed on the ESIC portal against each insurance number.
Check the file totals against the register before you upload. Keep the downloaded acknowledgement for each upload, with the date, the amount and the file name. The principal employer will ask for it. So will an inspector, someday.
Check the file totals against the register before you upload.
Fill the principal employer formats
Each plant or colliery asks for its own set of papers before it releases your bill. Common asks are a wage sheet in its layout, proof of contribution payment, a bank statement or payment advice and a list of workers deployed.
Produce these from the same register, not by hand. A plant in Jamshedpur may want a different column order from one in Dhanbad, and a template per principal employer saves the retyping.
Keep a signed copy of each submission, or a dated email, so you can show when the papers reached the plant.
- Wage sheet in the employer’s column order
- Challan receipts for the month
- Bank payment advice for net wages
- Deployment list with gate pass numbers
Let software hold the sequence
A good setup moves a month through states: attendance open, attendance locked, register final, files uploaded, formats sent. Nobody can edit a locked month without a recorded reason, which protects you if a worker disputes a figure later.
A short monthly calendar also helps. Put a date against each state and one person against each date. Print it for your next close and tick the states as they pass.
Month-end wage and challan calendar
A worksheet with two blocks. The first block lists the five states of the month, from attendance locked to formats sent, each with a target date, an owner and a tick box. The second block has one row per principal employer, listing the formats it needs and the date they were submitted.
Open a blank worksheet to printQuestions owners ask
Can one register serve several plants?
Yes, if each worker row carries a site code. Filters then produce a wage sheet per plant in that plant’s layout from the same underlying data.
What happens when attendance is corrected after the register is final?
Reopen the month with a reason and a name against it, correct the entry and regenerate the files. The record of the change stays for audits.
Does software replace my compliance consultant?
No. Software prepares the figures and files. Interpreting rules, ceilings and due dates stays with a qualified person who knows your case.
