Guides
Why Excel payroll breaks — and what to use instead
Last updated: 22 August 2026
A lot of small Indian businesses still do payroll in Excel: a salary master, a leave tab, and a formula that is supposed to spit out net pay on the last working day of the month. It is familiar. It is also how unpaid leave gets missed, LOP gets argued after payout, and nobody can say which file was final.
This is not a tutorial on how to do payroll in Excel, and it is not a downloadable template. It is when that workbook stops being honest — and what a simple payroll system should replace, without pretending to be a full statutory suite.
What “Excel payroll” usually is
In a 10–40 person company the workbook is rarely just salaries. It is Basic / HRA / other in one sheet, a leave tracker in another, a calendar of Sundays and holidays in a third, and a person who remembers who joined mid-month. Payslips are a copy-paste into Word, or not issued at all.
That is manual payroll. It works while one person owns the file and leave is simple. It fails as soon as unpaid days, half-days, or a second approver enter the picture. The leave half of this problem is covered in spreadsheet leave tracker vs dedicated software; month-end salary math is what breaks next.
Where Excel-based payroll goes wrong
- Version drift — “Payroll Aug FINAL v4” in email, a different copy on someone’s desktop, and a formula that still points at last month’s leave tab.
- Unpaid leave reconstructed after the fact — chat approvals never reach the sheet, so loss of pay is guessed. See how to calculate LOP from unpaid leave.
- Join and exit dates — pro-rata is a handmade row. Miss it once and the employee is overpaid or underpaid with no audit trail.
- Payslips are not a record — employees cannot open their own slip later. HR reprints from memory, or not at all.
- The file holds too much — salaries, PAN, and leave for the whole company in one workbook that half the office can download.
What replacing Excel payroll should mean
For a small team, “payroll software” should not mean a full HRMS or a PF / ESI / TDS engine. Those are different products, and chasing them in search will land you in a tool you will not finish implementing.
A useful replacement does four jobs:
- Salary structure per employee (Basic, HRA, other, optional deduction).
- Leave already approved as unpaid, so LOP is a count — not a reconstruction. That needs a leave management system, not another Excel column.
- A monthly draft you can review, then a finalize step that freezes the numbers.
- Branded payslips employees can open themselves.
That is simple payroll software: gross, minus LOP from approved unpaid leave, minus any other deduction you recorded, rounded the same way every month. It is not bank payouts, biometric attendance, or statutory filings. Keep those with your accountant if you need them.
When the sheet is still enough
Stay on Excel when most of these are true:
- Fewer than ~8 people, one payroll owner, almost no unpaid leave.
- Nobody is asking for a payslip PDF they can keep.
- Join and exit mid-month almost never happens.
- You are not already fighting last month’s LOP.
Move off the sheet when unpaid leave is regular, more than one person touches payroll, or you want employees to see their own slip without opening the company workbook.
How Leafwage does this
Leave stays the system of record. When Salary & Payroll is enabled — included on Starter and Growth, or as a ₹999/month add-on on Free — admins generate a monthly draft from that unpaid-leave trail, review payable days and net pay, then finalize. Employees print branded payslips from the browser. Teams of 1–10 do not need to buy Starter for payroll alone.
Access is invite-based — request access if you want leave and simple payroll in one workspace instead of another Excel close on the 30th.
Ready to replace the spreadsheet? Request access — we review organisations within one business day.