School staff payroll: from Excel to reviewed, one-click runs
2026-10-18 · 6 min read
What school payroll involves, the real cost of doing it in Excel, and why “system calculates, accountant approves” is the design schools actually adopt.
What school payroll actually involves
A school’s monthly salary run brings together three things that usually live in different places: each staff member’s salary structure, the month’s staff attendance and leave, and the statutory deductions. In many schools these meet for the first time in an Excel sheet a few days before salary day.
Common salary components in Indian schools
- Earnings such as basic pay, dearness allowance (DA), house rent allowance (HRA) and other allowances.
- Provident Fund (EPF), where applicable — commonly 12% of basic pay and DA from the employee, with a matching employer contribution.
- Employees’ State Insurance (ESI), for staff whose gross wages fall under the scheme’s ceiling.
- Professional tax, which varies by state.
- Income tax deducted at source (TDS) where salary crosses the taxable limit.
- Deductions for unpaid leave, derived from staff attendance.
The real cost of doing payroll in Excel
- Attendance is copied in by hand, so a missed half day becomes an argument after salaries are paid.
- Formulas are edited month to month, and nobody can say which version produced last month’s numbers.
- One person knows how the sheet works. When they are on leave, payroll waits.
- There is no record of who approved the final numbers.
System calculates, accountant approves
The design that schools adopt is not “fully automatic payroll”. It is software that prepares the run from salary templates and attendance, shows the accountant each staff member’s numbers, and waits. Finalising is a separate, deliberate step, recorded with who approved it and when. Payslips are generated only after that.
This keeps the accountant in charge while removing the arithmetic and the copying — the parts that cause mistakes.
What to look for in school payroll software
- Salary templates with Indian earning and deduction components.
- Staff attendance in the same system, so leave flows into the run without re-typing.
- Per-staff review before finalisation.
- An approval record: who finalised the run and when.
- Payslips generated and stored for every month.
- Access limited to the accounts desk — not every staff login.
Payroll in Gritticon SMS
Gritticon SMS has salary templates with Indian earning and deduction components. Monthly runs are prepared by the system and reviewed per staff member; finalisation is its own step, stamped with who approved it and when; payslips are generated and stored. Staff profiles, departments and attendance feed the same salary run.