01 · The problem
What problem does it solve?
A company of 120 people runs payroll in Excel. Attendance comes from a biometric machine export, leave from emails, and the HR executive spends days each month matching them before salaries can be worked out.
PF and ESI are recalculated by hand, a formula error underpays someone every few months, and employees call HR for payslips and leave balances.
Days every month
Attendance, leave and salary sheets matched by hand.
Formula errors
A wrong cell under- or over-pays someone.
Compliance risk
PF, ESI and TDS worked out manually.
Constant questions
Employees ask HR for balances and payslips.