prepare a salary slip of an employee in ms excel

Payroll slip month and year, Employee Code.

Company name, logo and address (on letter pad).

So, here are the main employee salary slip components that almost all kinds of payslip formats include: But, all salary slip formats are supposed to contain some general heads. The employee payslip format could be very different for different organizations. You are required to show your employee salary slip whenever you are applying for loans, credit card, or for paying income tax amount every financial year, etc. A salary payslip is very vital since it is the legal proof of the salary payments and deductions.

as well as specific details of his employment.

What is Salary Certificate? How is it different from a salary slip?Ī salary slip is a document issued by an organization to its employee that comprises a list of his various salary components like basic salary, HRA, LTA, Bonus, TA, DA, taxes and deductions etc.

Taxable/partially taxable & non-taxable components of salary slip.

Differences between Cost to Company (CTC) and in-hand salary.

How knowledge of salary slip increases your take-home salary?.

How to Read and Understand Your Salary Slip?.

Important Components of a Salary Slip/Pay Slip.

How does Salary Slip help to Save Income Tax?.

Download Salary Slip/Payslip Sample Format or Template.

Updating employee addition/deletion data in insurance and sales HRġ6. Handling all types of investment queries, leave queries, FCTC (fixed cost to total cost) queries, and exit employees' queriesġ5. Updating supervisor/matrix manager information as per Corporate Communicationġ4. Initiating no dues for exit employees for FnF (Full and Final) processingġ3. Sharing BC (business continuity) pay sheet with HRBP, processed SIP (systematic investment plan) data and headcount data with HO/BU finance, pay register data with HRBP, FnF slip, pay slip, IT sheet, and Form 16 with exiting employeesġ1. Checking and notifying HRBP to update separations in SF according to the IT summit ticketġ0.

Sending emails and reminders to new joiners to update their bank details in SFĩ. Sharing goal setting, mid-year, and annual status reports with the compensation & benefits headĨ. Creating/Updating position details in SF (Salesforce)ħ. Maintaining the professional tax register for live salary, on-hold salary, and full and final settlementsĤ. Preparing PF data and sharing it with Wizemen and the finance teamģ. Selected intern's day-to-day responsibilities include:Ģ.

Prepare a salary slip of an employee in ms excel