Dear Friends,
Could you kindly do me a favor by sending the salary breakup sheet in Excel format which includes the following fields: Basic, House Rent Allowance, Conveyance, Medical Allowance, Snacks (6%), Factory Allowance (7%), Special Allowance (.9%), and Leave Travel Allowance (10%). The breakup sheet may have the same percentages as mentioned.
By the way, please find the attachment for a better understanding to process the information provided above.
Waiting for your reply.
Regards,
Praveen
Location: Panipat, India
Tags: salary breakup, travel allowance, City-India-Panipat, Country-India
From India, Panipat
Acknowledge(0)
Amend(0)
Could you kindly do me a favor by sending the salary breakup sheet in Excel format which includes the following fields: Basic, House Rent Allowance, Conveyance, Medical Allowance, Snacks (6%), Factory Allowance (7%), Special Allowance (.9%), and Leave Travel Allowance (10%). The breakup sheet may have the same percentages as mentioned.
By the way, please find the attachment for a better understanding to process the information provided above.
Waiting for your reply.
Regards,
Praveen
Location: Panipat, India
Tags: salary breakup, travel allowance, City-India-Panipat, Country-India
From India, Panipat
Acknowledge(0)Amend(0)
To create a salary breakup sheet in Excel with the specified fields and percentages, follow these steps:
- Open a new Excel spreadsheet.
- Create column headers for each of the fields: Basic, House Rent Allowance, Conveyance, Medical Allowance, Snacks (6%), Factory Allowance (7%), Special Allowance (0.9%), and Leave Travel Allowance (10%).
- Enter the corresponding percentages in the rows next to each field.
- Input the employee's salary information in the respective columns under each field.
- Calculate the amounts for each allowance based on the given percentages. For example, if the Basic salary is Rs. 50,000, multiply it by 6% to calculate the Snacks amount.
- Add up all the amounts to get the total salary breakup.
- You can use Excel formulas to automate the calculations and make adjustments easily.
- Save the file once you have completed the salary breakup calculations.
This structured approach will help you organize the salary details efficiently and ensure accurate calculations based on the provided percentages.
From India, Gurugram
Acknowledge(0)Amend(0)
102- Open a new Excel spreadsheet.
- Create column headers for each of the fields: Basic, House Rent Allowance, Conveyance, Medical Allowance, Snacks (6%), Factory Allowance (7%), Special Allowance (0.9%), and Leave Travel Allowance (10%).
- Enter the corresponding percentages in the rows next to each field.
- Input the employee's salary information in the respective columns under each field.
- Calculate the amounts for each allowance based on the given percentages. For example, if the Basic salary is Rs. 50,000, multiply it by 6% to calculate the Snacks amount.
- Add up all the amounts to get the total salary breakup.
- You can use Excel formulas to automate the calculations and make adjustments easily.
- Save the file once you have completed the salary breakup calculations.
This structured approach will help you organize the salary details efficiently and ensure accurate calculations based on the provided percentages.
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls