Salary Sheet in Excel - A salary sheet in Excel is a spreadsheet listing every employee's salary components, deductions, and net pay for a given period, with formulas calculating gross pay, statutory deductions, and final net pay across the whole team in one view, rather than a single individual payslip. It typically includes columns for basic pay, allowances, gross salary, itemised deductions such as PF and ESI, and net pay, with totals rolling up automatically as data changes. It is the most common starting point for small businesses running payroll manually, before the complexity of a growing team makes dedicated payroll software worth adopting.
Recommended column structure
A functional salary sheet typically includes these columns, in order: Employee ID, Employee Name, Department, Basic Pay, HRA, Other Allowances, Gross Salary, PF Deduction, ESI Deduction, Professional Tax, TDS, Total Deductions, Net Pay, and Days Present (for pro-rata adjustment).
Core formulas you actually need
Gross Salary (column G, from Basic in D, HRA in E, Allowances in F): =SUM(D2:F2)
PF Deduction (12% of Basic, capped at ₹1,800 per current EPF rules): =MIN(D2*0.12,1800)
Total Deductions (summing PF, ESI, PT, and TDS in columns H to K): =SUM(H2:K2)
Net Pay (Gross Salary minus Total Deductions): =G2-L2
Pro-rata adjustment for partial-month joiners or leavers (using Days Present in column N, against a 30-day standard month): =(G2/30)*N2
Department-wise total payroll cost (using SUMIF against the Department column): =SUMIF(C:C,"Sales",M:M)
Try OfficePortal free for 5 users
All-in-one HRMS — attendance, payroll, leave and more. No credit card needed.
Common mistakes in manual salary sheets
Hardcoded values instead of formulas. Typing a calculated number directly, rather than using a formula, means the sheet won't update correctly if an underlying figure changes — a common source of stale, incorrect totals.
Inconsistent formula copying across rows. A formula that works for row 2 but wasn't copied correctly to row 50 produces a silent error that's easy to miss during a manual review.
No validation against attendance data. A salary sheet built purely from a salary structure, without cross-referencing actual attendance or leave records, risks paying someone for days they weren't present.
Version control issues. Multiple copies of the sheet, edited by different people or across different months, make it hard to trust which version reflects the actual, final figures.
When a salary sheet stops being enough
Manual Excel-based payroll works reasonably well for a handful of employees with simple, stable salary structures. It becomes genuinely risky once statutory deduction rates change (a missed update means every row is now wrong), headcount grows past what one person can carefully audit each month, or multiple locations introduce different Professional Tax and Labour Welfare Fund rules that a single spreadsheet formula can't cleanly handle.
Where OfficePortal fits
OfficePortal's payroll software replaces the manual salary sheet with automated calculation that pulls directly from attendance and leave data, applies current statutory rates automatically, and generates payslips without formula errors or version control risk. What typically takes two to three days to compile manually in Excel runs in under ten minutes. It's free for up to five users.
Explore OfficePortal's payroll software →
Reference Pages
About the author
Raja C
Director@Awarious
Raja C is a Director at Awarious, working in HR technology and business solutions. He shares insights on HRMS, digital transformation, and innovative solutions that help businesses simplify their operations.
Connect on LinkedIn
