The right section of the salary slip format contains deduction details like PF, PT, and TDS.

The left-hand side of the section includes earning details like Basic pay, HRA, TA, DA, Medical, special allowances, bonus, mobile, and reimbursements. 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.

Sign & Stamp (if not generated by a payroll application).

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.

Organizations name, address, logo, contact details, and registration number.

It’s easy, fast, and reliable.ĬLICK HERE TO DOWNLOAD SALARY SLIP FORMAT IN EXCEL WITH FORMULA & CALCULATIONS FOR PVT LTD COMPANYĪs discussed above, a payslip contains a detailed salary structure and deductions.Ī simple salary slip format contains two major headings.Īn ideal payslip template in an excel format must include details like Most employers use automated payroll software to generate a salary slip format for their employees. Individuals seeking services like loans, credit cards, and other banking services are asked to submit a minimum of six months’ payslips and bank statements to avail of services. It’s also treated as income proof by most of the banks. they are cheap and they offer great customer service too.Īpart from the salary structure and deductions, a payslip also contains vital information like the number of days worked in that month, PF account/UAN number, bank account details of the employee, and leave details.Ī salary slip also certifies that the employer has paid the salaries for the specified month and the employee has received it. 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.

Hotel salary slip format