Directions for Use of Salary Slip Download the attached files of Salary Slip in your desired format in Ms Excel or Ms word from bottom links. If download link is not showing at bottom please copy and past the below salary slip in word or excel sheets. Put the desired values in the amount column. You can change, add or delete the items as per your requirements for your employees. Ms Excel format makes auto calculations so it just need to add or put your desired values in the relevant columns. After adding values your salary slip is ready to be printed on the plan paper and get it signed from the relevant authorities.

• Free Payslip Template

• Here are Salary Slip Formats in Microsoft excel and Microsoft word. This salary slips are fully functional and free to download. You can use these formats.
• Are you looking for 'Salary Slip Format in Excel'? This post will help to solve issues of financial planning regarding maintaining employee’s salary slip.

Salary Slip Format in Excel – Example 1 Salary is the basic right of all the employees and it is due since the day one of project beginning. Now as per the processes and procedures, companies are now following the most processes on computer software base setups, same is the case implementation in salary record maintenance.

Free Payslip Template

Salary Sheet is a document that includes complete details of the amount payable to an employee for work done during a particular period of time. It includes details like basic pay, allowances, deductions and overtime etc of employees.

Salary sheet or Employee sheet is the Payroll or Human Resource document used to calculate salaries of employees in any company. You can also download and Excel templates. With the help of our VBA team and some assistance from, I have created an automated Salary Sheet file. Using this sheet you can calculate salary of multiple employees within minutes. Let’s learn how to use this template in detail. This template workbook consists of 3 different sheets as mentioned below:.

Database. Consolidation. Salary Slip Note: After you download the template, don’t forget to enable the content in the security warning pop up below the ribbon as shown in the images below: 1. Database Database sheet is the master sheet where data of each employee will be entered. This sheet includes all relevant heads like name, designation, gender, basic salary, allowances, Provident fund etc which are required for salary preparation according to Indian Salary structure. Enter data only in blue colored cells.

The pink colored cells are formulated. No data is to be entered in pink colored cells. See image below: In this sheet, some data inputs columns have a drop down menu, which makes easier for the user to select and enter data. Month, Year, Title, Gender etc are drop down menu. See image below: For easy navigation, buttons for each sheet are given on top of the sheet in as shown below: After entering data in the Database Sheet clicking on the “Consolidation button” will navigate to Consolidation Sheet. Consolidation Consolidation sheet is the month wise sheet of salary data entered in Database Sheet.

This sheet is linked with Database sheet and fills in all data automatically when entered in Database sheet. You don’t need to enter any data into this sheet. Please note that if month or year entered in database sheet differs then it will not show in the consolidation sheet for that month.

You can print a monthly report of salary for approval from higher management. Click on the “Go to Salary Slip” button to navigate to Salary Slip. Salary Slip This is the final step.

With the help of Vlookup function select the name from the drop down list and data of the respective employee will appear. Click on the print button to print the Salary Slip. This template is very user-friendly and easy to use for everyone. This template can be helpful for Accounts assistants, Office Admin, HR Assistants, Executive Assistants etc for preparing salaries. If you have any queries please comment below.

I will be more than happy to assist you. Dear Ejazullah, Glad to know that our template is useful to our viewers. CTC basically stands for Cost to the company. The Cost to company is the total cost that an employee is incurring in a company.

This includes the cash components plus other benefits like Bonus, Food etc. Which are in general not seen in your regular Monthly Salary. In general, it means take home salary or salary package of an employee.

You can subscribe to our weekly update to get updated every week with our newly posted template. Thanks Fahim ExcelDataPro.com Content and Marketing Manager.

Shabba ranks greatest hits 2001 rar. Dear Fahem, I have small advertising office, how to manage it in excel in it i need 1- Company That provide advertising material like Flex for hording Billboards 2- Labor fit this hording Flex in Labor more then 40 peoples some time 5 person go fit and some time different 3 go and fit this i want every budget divide them equal all labor project based instead salary. Some time they need daily expense that we pay.

3- Motor vehicle expenses 4- other expenses 5- old flex and material that removed from billboard please help me i am thankful to you. Dear sir, thank you for your Efficient format of Salary/ payroll.

I wonder to edit some column, like need to delete some rows that i do not need while i prepare my salary worksheet without any effect in salary slip and consolidation sheet. Would you please instruct me how do i delete those unnecessary row and column. I do not need – DA,HRA, Conveyance, Conv WorkingMedical ExpensesSpecial column in Total gross salary and Contribution to PF in total deduction.

Best Regards Rajesh Suwal 9203.