A good salary slip format in Excel shows earnings, deductions and net pay in a layout that anyone can read and check. This guide explains the structure, the formulas in words and the checks to run, so you can build or review a payslip. Statutory rules change, so confirm current requirements with your payroll team or a qualified professional.
Header section
Keep the top of the sheet simple.
- Company name and address.
- Employee name, employee ID, designation and department.
- Pay period, for example the month and year.
- Days in the month, days worked and loss-of-pay days.
- Bank account details, masked, such as the last four digits only.
Earnings columns
List each earning as its own row with an "Amount" column, and if you track it, a "Monthly fixed" column next to it.
- Basic pay.
- House rent allowance.
- Special or other allowance.
- Conveyance or similar allowances, if your structure has them.
- Variable pay or incentive, in months when it is paid.
- Reimbursements, shown separately so they are not mixed with fixed pay.
Gross earnings equal the sum of all earning rows.
Deductions columns
- Provident fund, where applicable.
- Professional tax, where your state applies it.
- Income tax deducted at source.
- Other deductions such as advance recovery or insurance contribution.
Total deductions equal the sum of all deduction rows. Net pay equals gross earnings minus total deductions.
A tiny illustrative layout
Imagine a month with illustrative gross earnings of Rs 70,000 and total deductions of Rs 12,000. Net pay is Rs 58,000. In Excel, use SUM for each block and a subtraction for net pay, and lock those cells so they cannot be overtyped by accident.
Checks that make a salary slip format in Excel reliable
- Use formulas, not typed totals.
- Add a check cell comparing net pay with the bank transfer amount.
- Keep loss-of-pay logic visible: monthly pay divided by days in the month, multiplied by LOP days.
- Round consistently, and say whether you round per line or on the total.
- Add a note line for arrears or corrections, so past changes are traceable.
Common mistakes
- Mixing reimbursements and taxable allowances in one row.
- Showing CTC components that are not paid monthly, such as employer contributions, as if they were part of net pay.
- Forgetting to protect personal data when sharing the file.
- Using a template that ignores your actual company policy.
If you are an employee checking a slip
Compare each row with your offer letter, confirm the deductions against statements you receive, and ask HR to explain anything unclear. A payslip is also useful evidence when you apply for a loan or a new job, so store the last few months safely.
Next step
Use your latest payslip details to keep your CVTara primary resume accurate, then tailor it to each application.
You can also run an ATS match against a real job description, or read our related guide: Current Salary Resume Wording Helper.
Frequently asked questions
What should a salary slip include?
It typically shows employee details, pay period, earnings, deductions and net pay. Your employer's policy and applicable law decide the exact fields.
How do I calculate net pay in Excel?
Sum all earnings for gross pay, sum all deductions, and subtract deductions from gross. Use SUM formulas so totals update automatically.
Can I make my own salary slip for official use?
A self-made slip is not a substitute for one issued by your employer, so use official documents wherever verification is needed.