Open Excel and create a new worksheet
Create column headers such as Employee Name, Employee ID, Department, Basic Salary, Allowances, Deductions, Gross Salary, Net Salary, and Payment Date
Enter employee details in each row
Add formulas for allowances if needed
Calculate gross salary using the basic salary and allowances
Add deduction columns such as tax, provident fund, loan, or absence deduction
Calculate net salary by subtracting total deductions from gross salary
Format salary columns as currency or number with proper decimals
Apply borders, bold headers, and cell shading for readability
Use AutoSum for totals at the bottom of salary columns
Freeze the top row to keep headers visible while scrolling
Sort or filter data if needed
Save the file with an appropriate name
Protect the sheet if you want to prevent accidental edits