

The next section of the salary slip in excel format contains two major headings, Earnings & Deductions. To make a salary slip in excel format, start with entering details like company name, address, and contact details in the headline section in an excel sheet.Ĭreate another two equal sections in the excel sheet to enter details like employee ID, date of joining, month & year, EPF account number, UAN number, pan card, Aadhaar card, department, number of days worked, number of leaves taken, designation, and department.

Number of days worked, number of leaves.EPF Account Number, Universal Account Number (UAN).Employee Pan Card, Adhaar Card, Bank Account details.Month and year the payslip is issued for.


If you are looking for an affordable and one of the best payroll software in India, check Zoho. a HR & payroll software makes it easy to calculate, control and generate reports. Most companies prefer using a hrm payroll software to generate salary slips and pay stubs. it also contains the details of statutory tax deductions like PT, PF, TDS, insurance cost, etc. The main components of a salary slip are Basic Pay, House Rent Allowance (HRA), TA, DA, Reimbursements, Medical, Bonus, etc. of hours paid for, tax deductions, paid to the employee. A salary slip, payslip, or pay stub is payment advice issued to the employees of an organization once their salaries are credited into their accounts.Ī simple salary slip format contains a detailed breakup of the gross and net salary, no.
