Salary Slip Discrepancy
I have tried everything possible, but something is not clicking, and my salary slip has gone bonkers. Please find attached the salary annexure we have for our company and the salary slip. However, when I input the salary annexure info into the salary slip, it shows an additional 200-300 Rs extra. I am unable to figure out what is going on.
Please help me sort this out, as I have to create salary slips for our employees. If you find a flaw in either the salary annexure or the slip, please help me correct it. I am not a pro in Excel; I did these two as per the knowledge I had.
Thank you in advance.
Regards,
Ashwin
From India, Bangalore
Acknowledge(7)
Amend(0)
8I have tried everything possible, but something is not clicking, and my salary slip has gone bonkers. Please find attached the salary annexure we have for our company and the salary slip. However, when I input the salary annexure info into the salary slip, it shows an additional 200-300 Rs extra. I am unable to figure out what is going on.
Please help me sort this out, as I have to create salary slips for our employees. If you find a flaw in either the salary annexure or the slip, please help me correct it. I am not a pro in Excel; I did these two as per the knowledge I had.
Thank you in advance.
Regards,
Ashwin
From India, Bangalore
Acknowledge(7)+2 more
Amend(0)
To resolve the discrepancy between the salary annexure and the salary slip, follow these steps:
1. Cross-Check Data: Verify each entry in the salary annexure against the corresponding entry in the salary slip to identify the source of the extra amount.
2. Check Formulas: Review the formulas used in the salary slip to ensure accurate calculations. Any discrepancies might be due to formula errors.
3. Formatting: Check the formatting of cells in Excel. Sometimes, formatting issues can lead to incorrect calculations. Ensure that the cells are formatted correctly for numbers.
4. Manual Entry: If some data is manually entered, double-check for typos or incorrect entries. Even a small mistake can cause significant discrepancies.
5. Consult HR or Finance: If you are unable to identify the issue, seek assistance from your HR or finance department. They might have insights into common errors or discrepancies.
6. Training: Consider attending an Excel training session to enhance your skills. Excel proficiency is crucial for accurate financial calculations.
By following these steps, you should be able to identify and rectify the discrepancy between the salary annexure and the salary slip effectively.
From India, Gurugram
Acknowledge(0)Amend(0)
1. Cross-Check Data: Verify each entry in the salary annexure against the corresponding entry in the salary slip to identify the source of the extra amount.
2. Check Formulas: Review the formulas used in the salary slip to ensure accurate calculations. Any discrepancies might be due to formula errors.
3. Formatting: Check the formatting of cells in Excel. Sometimes, formatting issues can lead to incorrect calculations. Ensure that the cells are formatted correctly for numbers.
4. Manual Entry: If some data is manually entered, double-check for typos or incorrect entries. Even a small mistake can cause significant discrepancies.
5. Consult HR or Finance: If you are unable to identify the issue, seek assistance from your HR or finance department. They might have insights into common errors or discrepancies.
6. Training: Consider attending an Excel training session to enhance your skills. Excel proficiency is crucial for accurate financial calculations.
By following these steps, you should be able to identify and rectify the discrepancy between the salary annexure and the salary slip effectively.
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 slip final.xls
Salary slip.doc