The Wage Sheet and the Duty Count Finally Agree
Duties by guard become the wage sheet. Overtime, night allowance, advances and uniform recovery are applied by the rules you set with your accountant, the same way for everybody.
Three evenings in Excel
Overtime, double duties, weekly offs and advances are worked out late at night, in a sheet rebuilt every month. One formula gets dragged a row short. A guard paid two duties less comes to the office on the 8th and does not leave until it is fixed.
What the sheet is made of
Duties, from the gate
Present days come from the marks at the post, so the wage sheet and the client invoice are counting the same thing.
Overtime and night allowance
Hours past the shift and night duties are applied on your rules, with no room for who spoke to the accountant last.
Advances recovered
Money given during the month is set against the wage, and the balance carried stays on the guard’s record until it is cleared.
Uniform and kit recovery
Shoes, a torch and a second set of uniform issued in June are recovered the way you agreed when they were handed over.
PF, ESI and professional tax
Worked out on rules configured with the person who files your returns, and checked against last month’s sheet before go-live.
What comes out of it
- Wage sheet by site, so a costly contract shows itself
- Overtime hours by site and by month
- Payroll files your accountant asks for
- Advances still outstanding, guard by guard
- Wage cost set against duties billed, site by site
Frequently asked questions
Does this file our PF and ESI returns?
No. It works out the deductions on your rules and hands your accountant the figures behind them. What gets filed, and any notice that comes back, stays between you and him.
Our rates differ by client site. Does that work?
Yes. The rate belongs to the post, so a man moved from a warehouse to a corporate lobby is paid at the rate for the duty he actually stood that night.
What about a guard who joined on the 14th?
He is paid for the duties he stood, because the sheet counts duties rather than a month. Joiners and leavers need no separate arithmetic.
Can wages go out as a bank file?
Yes. A salary transfer file comes out in the format your bank accepts, and the same month exports for Tally with your ledger names.
Tell us what you need.
Send a short brief and one of our engineers will come back to you — usually the same day.
- No obligation
- We reply the same working day
- Your details stay private