From the payroll spreadsheet only one person understands
Representative scenario — illustrativeA school of 180 teaching and non-teaching staff keeps records in a filing cabinet, attendance in a gate register, and salary in a spreadsheet that lives on one accountant’s laptop.
Every payroll week is a reconstruction: someone reads the gate register, tallies leave against loose slips, and computes PF and ESI by hand into a formula nobody else can follow. When that accountant is on leave, the salary run stops. Loss-of-pay is a judgement call, and the bank file is retyped from scratch each month.
The cheap ERP stored employee names but modelled payroll as a flat amount — it couldn’t read shifts, cross-midnight duty or attendance-linked deductions, so loss-of-pay was still worked out in Excel and pasted in. Statutory components didn’t reconcile, and the org chart was a stale diagram nobody updated. Six months in, the accountant was back to the trusted spreadsheet and the ERP held only half a register.
ez.school keeps the whole staff lifecycle in one register — teaching and non-teaching alike — with documents, reporting lines and an org chart that draws itself. Payroll reads that record: salary structures, attendance-linked deductions, advances and statutory components come together in a run with per-employee preview and exceptions held for review. The bank file and the auditor’s register export in the formats they ask for, no retyping.
| By hand | Ordinary ERP | ez.school | |
|---|---|---|---|
| Staff record | Filing cabinet + gate register | Names only, no structure | One register, org chart self-drawn |
| Loss-of-pay | A monthly judgement call | Still worked out in Excel | Attendance + leave feed the run |
| PF / ESI | By-hand formulas | Doesn’t reconcile | Statutory components computed |
| If the clerk is away | Payroll stops | Nobody else can drive it | Run is a reviewed process, not a person |
- One runAttendance to salary
- PreviewBefore anything commits
- No retypeBank + auditor files
Cost up 6% but cost-per-head is flat — growth is headcount, not wage drift.
Payroll cost by component and department — earnings, deductions and statutory dues reconcile to the register that ran them, not to a private formula.