Payslip Format in Excel For Company Free Download

 

Sample Payslip Format in Excel Sheet with auto calculation formula for office, business, production units and factories in Asia,UK, USA and Europe. This free payslip template is taken from a multinational company. Free download this sample payslip template from below link in excel file. You can visit salary slip format in Excel or Payslip Format in Word for more wage slip options. You can write us back for any suggestions and improvements in the available samples or other letters and applications.

Instructions for How to Create Payslip

Download the pay slip from the links at bottom of the page. If the download format in excel is not available don’t worry just company and paste the below format in excel file and make some required adjustments as per your need. Put all the required information in the first section like name, month, workings days etc and finally put all the values in the amount section of the payslip. You can break down your salary items like advance, allowance, arrears etc. If you downloaded the excel file it will calculate all the amounts automatically but if you copy and paste the payslip then you have to make the calculations manually.

COMPANY NAME FOR PAYSLIP

Pay Slip for the Month of July 2011 Head Office

Name: ________  Gross Salary: _______ Net Pay: ______  Designation:_________

Processing Month: ______   Working Days: _____ Absence: ____ Leave: ______

Earning

Deduction

Description             Amount Description                   Amount
Basic Pay              Rs.__________
Allowance              Rs.__________
Arrears                 Rs.__________
Income Tax                  Rs.__________
Van Fare                      Rs.__________
Security                        Rs.__________
Total Earning       Rs:__________ Total Deduction          Rs:__________

                                                                       

                                                                                    Net Payment        Rs:___________

                                                                                     Payee’s Signature ………………..

 ______________                     _______________                              ______________

Accounts Officer                   Finance Secretary                             Chief Executive

Download Sample Payslip format in MS Excel from below link

Payslip Format In Microsoft Excel Free Download

Payslip Format In Microsoft Excel Free Download for UK, USA and Europe

Details of the Payslip

Payslip Format for download includes all the options like Basic Pay, Allowance, Arrears, Income Tax, Van Fare, Security Deposit and a deductions Section. You can add anything else that you want as per you requirements. Excel format of payslip includes the formula for auto pay calculations. The top section of this payslip includes gross pay, net pay, working days, leaves and absents for the particular month.

If you need any more option or want us to customize the free payslip download. Just leave your comments in the below form.

Payslip and Salary Slip Difference

Payslip is common business document widely used across the world and well renowned in UK, Europe and America. Asian people call this same document as salary slip but in western world it is know as Pay Slip. Payslips always issued by employers, companies, organizations to their paid staff members of any designation.

Download Links:

From the above ready you came to know what is a payslip? How to create Payslip in Excel? and Elements of Payslip used in Europe and Asia. If you have any question regarding pay slip you can ask in the comment form or If you have better format and want to share at Semioffice.com you can send us in email.

We also request you to post your comments about the available format of payslip. So we will improve this after your suggestions and requirements.

 

Related Posts



 
 

16 Comments

  1. emma fe c. Acabal says:

    I like your format of the payslip

  2. emma fe c. Acabal says:

    and pls send me your format in my email thank you

  3. giridharan says:

    Hi! i need to calculate payslip for employees with gross salary of Rs 10,000. i don’t know how to calculate Basic Salary, allowance,arrears, others, income tax, security, others etc. can you please send to my email. awaiting for your reply

    • admin says:

      Hello GiriDharan, It depends that how your Company fix everything like basic salary, allowance, security etc.For tax calculation you can check to your local govt tax rules whether this salary scale fall in income tax or not. If the employee fall in any tax scale than you can charge income tax accordingly like 5% or 7% etc.

  4. abhay mane says:

    need to calculate employees payslip with gross salary of Rs. 6500. Pls let me know how to calculate the salary if i have to deduct salary for his leave without pay days.

    • admin says:

      Hello.
      Please divide the Gross salary on the month days like 6500/31=210, days can be 30 as well. For instance you want to deduct 5 days. Multiply 210X5=1050. Final calculation is 6500-1050=5450

  5. admin says:

    Please download the slip from above links at the bottom of the post

  6. kumar s says:

    send me a formats of pay slip and experience certificate….

  7. Michal Gabris says:

    Hello can you send me your format payslips to my email adress please thank you

  8. ajay says:

    Dear sir

    can you provide me a sheet automatically calculate or show the pay slip format one click employ I’D selected sow all items automatically
    please send this format in excel

  9. Jatin Narula says:

    Dear sir

    I am not downloading my salry slip ..pls help me

  10. akanksha says:

    Hi sir.. please tell me if the company dont have any banck account for the employees and also they are not deducting pf so how to prepare their salary sheets for employees…?

  11. Rajesh Kumar Mishra says:

    want to know the bifurcation of the salary in hand 35000/-and CTC 550000/-per annum

 
 

Leave a Comment