How to Make a Salary Slip in Excel
An Excel payroll sheet is never really finished. Every time a rate changes, an employee joins, or a slab moves, somebody has to go poking at formulas — and that is exactly the moment a payslip quietly goes wrong.
This guide doubles as a build manual for a salary slip workbook that keeps working: the sheets to create, the formulas to trust, and the formatting that makes each slip print cleanly on one page. Read it before you build, not after payroll breaks.
If spreadsheets are costing you more time than they save — or a formula error keeps slipping past every month — the generator section at the end does the same job with no formula maintenance.
When an Excel salary slip still makes sense
For teams under about fifty employees, a spreadsheet is a defensible choice: it is free, already installed, and quick to repurpose for a fresh financial year without buying licences.
The trap is treating it as a stopgap forever. As long as you audit the totals each month, an Excel slip is a legitimate payroll system — the problems only begin when nobody actually owns the formulas that drive it.
Laying out a payroll workbook that survives contact with real HR
The workbook layout is the design decision that decides everything else. Keep four sheets: an employee master, a rate-and-structure reference, the monthly payslip, and an archive ledger that doubles as the wage register.
Raw data, lookup tables and the printed slip must never share one sheet. The moment a structure rate starts living inside the payslip itself, your salary slip becomes unreproducible and every correction turns into a hunt.
| Sheet | Purpose |
|---|---|
| Employee master | One row per person: name, ID, designation, PAN, bank account, hire date |
| Structure reference | Basic, HRA, allowance and statutory rates keyed by employee or band |
| Payslip (print) | The A4 slip layout that pulls its values from the other sheets |
| Archive ledger | One row per employee per month — the wage-register record |
Building the employee master sheet
The master sheet is a flat table with strictly one row per employee. Every identifier that should appear on the slip — PAN, bank account, date of joining — lives here, so the payslip tab never needs retyping month after month.
Freeze the header row, keep column types consistent, and avoid merged cells in the master entirely. Merged ranges are the leading reason payroll formulas mysteriously stop dragging partway down the sheet.
The salary-structure reference sheet
This sheet holds the per-employee or per-band components the payslip depends on: basic, the HRA rate or amount, allowance totals, and the professional-tax slab keyed to your state.
Keep statutory ceilings and rates visible on the same sheet. When EPF thresholds or tax slabs change, you change them in this one place instead of hunting through a dozen slip formulas.
Formulas that drive gross, PF and professional tax
The calculation engine is small but must be exact. Gross sums the earnings columns, employee PF multiplies basic by 12% and rounds to the rupee, professional tax resolves from a lookup table, and net salary is gross minus the deduction column.
Karan Mehta's line in the sheet makes it concrete: basic of ₹18,500 plus HRA of ₹7,400, conveyance of ₹1,600 and a special allowance of ₹2,100 give a gross of ₹29,600. A 12% PF formula returns ₹2,220, the state pro-tax lookup returns ₹200, TDS is keyed at ₹1,850, and net lands at ₹25,330.
| Output | Formula |
|---|---|
| Gross earnings | =SUM(E5:H5) |
| Employee PF | =ROUND(C5*0.12,0) |
| Professional tax | =VLOOKUP(D5,ProTax!A:B,2,TRUE) |
| Total deductions | =SUM(J5:M5) |
| Net salary | =ROUND(I5-N5,0) |
Designing a payslip tab that prints on one page
The payslip tab is presentation, not calculation. Set the page to A4 portrait, keep margins tight, and place the company name, payslip number and pay period inside a bordered header band so the identifier block cannot be missed.
Bank reviewers reject slips without those identifiers. Make the net line bold, add the amount in words beneath it, and set the print area to the slip range so nothing spills onto a second page.
Fonts matter less than consistent alignment. Left-aligned labels, right-aligned figures and one decimal style read as professional even on plain A4, while a slip with drifting columns gets questioned the moment it reaches a bank counter.
- Bordered cells around the earnings and deduction zones make the slip scannable.
- A fixed header row repeats the company name and period on every employee copy.
- Print to PDF per employee keeps a clean, signed archive without a printer in the loop.
Generating slips for every employee with a dropdown
With the master and structure sheets in place, the payslip tab can render any employee through a data-validation dropdown. Select a name, the slip recomputes, print to PDF with the employee name as the file name, and move to the next.
This one pattern turns a three-hour monthly chore into a half-hour one and keeps the archive ledger consistent — a row per employee per month drawn from the very same structure.
Catching drift: reconciling Excel payroll against the bank
No workbook survives contact with a mid-month rate change unaccompanied. Reconcile the sheet's net-pay total against your salary transfer file before any payslip goes out to staff.
A one-paisa difference between the two is the sign that a formula or rate drifted mid-month. Hunt the offending cell then, not in April when Form 16 season makes the same mismatch far more expensive.
Build the check into the workbook itself — a summary cell that subtracts the archive-ledger total from the month's transfer-file total. While that cell stays at zero, the slips are safe to print.
Moving from Excel to a generator when it stops scaling
There comes a point — new joiners every week, payroll across multiple states, contractual pay — where formula maintenance outgrows the value of the spreadsheet. The reliable tell is a salary slip you can no longer reproduce by hand in a quiet afternoon.
Crafex's free generator delivers the same payslip without a single formula to maintain; the browser-side tool computes every deduction and exports a professional PDF, making it the natural step beyond the workbook when Excel hits its ceiling.
Salary slip in Excel: questions answered
How to do it, step by step
- 1
Create the employee master table
Add one row per employee with PAN, bank account and joining date; freeze the header row so the table stays navigable as it grows.
- 2
Add the structure reference
Store basic, HRA, allowances and the professional-tax slab in a sheet separate from the slip layout.
- 3
Assemble the printable A4 payslip
Lay out the four zones with bordered cells and keep the print area exactly on the slip range.
- 4
Wire the formulas
Point the gross, PF, professional-tax and net cells at the master and structure sheets so every edit propagates automatically.
- 5
Print a named PDF per employee
Use the payslip dropdown, export each employee's slip to PDF, and append the matching archive-ledger row for the wage register.
Frequently asked questions
I have never built a payroll sheet in my life — can I still make a salary slip in Excel?+
A careful beginner absolutely can, because the sheet is reference-based rather than exotic. Follow the four-sheet structure — master, structure reference, payslip and archive — and copy the template pattern row by row. Start with a single test employee, verify the net against a manual calculation, and only then duplicate the rows for the rest of the team.
Which Excel formula works out professional tax automatically?+
Point a VLOOKUP at a professional-tax slab table stored in the structure sheet, with the wage value as the lookup key. The table returns the correct monthly tax for the employee's wage band, so a slab revision means editing the table once instead of every slip.
Why does my Excel net-pay total never quite match the bank transfer file?+
Compounding decimals inside SUM and ROUND combinations are the usual culprit. Standardise rounding — ROUND at two decimals on gross lines and ROUND to zero on the net — so the sheet's total matches the transfer file rupee for rupee. Also check that no cell still holds a typed figure from a months-old revision, because stale hardcoded values survive recalculation silently.
Can an Excel sheet handle ESI for employees under the wage ceiling?+
An IF formula handles it cleanly, checking whether monthly wages fall within the applicable ceiling before applying the 0.75% employee contribution. Store the ceiling and the employer's roughly 3.25% share in the structure sheet, so a single cell change updates every affected slip the month the limit moves.
How do I stop a colleague from breaking the payroll workbook?+
Protect every sheet, lock the formula cells, and allow edits only on the input columns. Add a review step — someone other than the sheet's author checks the totals before payslips go out — and keep a monthly backup so a mistaken overwrite of a rates table rolls back in minutes rather than hours.
At what headcount should a small business leave Excel for a dedicated generator?+
There is no fixed number, but the switch pays for itself once joiners, revisions or multi-state rules start outpacing your formula upkeep — commonly somewhere in the few-dozen-employee band. The Crafex generator removes the maintenance entirely while keeping the slip output familiar, and the browser-side processing keeps employee data off any server.
Start creating with the free Salary Slip tool
Create a professional salary slip in minutes with the free online generator.
Free Salary Slip GeneratorKeep reading
Related search terms
Why you can trust this guide
Written by Crafex Payroll Desk (Payroll & HR Documentation Experts), last reviewed 2026-08-01. We update these guides when statutory rules and formats change. Where Indian regulations apply, we link the official sources below. Verify critical calculations against the current government notifications before relying on them.
A Crafex editorial guide for Indian professionals and businesses.