Dear seniors,
I need your help in submission to Employees Present day’s calculation Sheet. On the month end when I submit the Employees present days details for salary purpose to the accounts dept, please tell me which information I have to give in sheet. Is the employees designation is required in that sheet? If you have any format please share with me, or help me to which information I have to written in sheet.
Thanks & Regards
Vrusha
From India, Chakan
Acknowledge(0)
Amend(0)
5I need your help in submission to Employees Present day’s calculation Sheet. On the month end when I submit the Employees present days details for salary purpose to the accounts dept, please tell me which information I have to give in sheet. Is the employees designation is required in that sheet? If you have any format please share with me, or help me to which information I have to written in sheet.
Thanks & Regards
Vrusha
From India, Chakan
Acknowledge(0)Amend(0)
Hi Vrusha,
You can follow the simple format below. Open the Excel and add the following columns:
- Sl. No
- Employee Name
- Current Monthly Salary (gross)
- Proposed Revised Salary
- Loss of Pay (Number of days)
- Notes (You can mention the effective date of salary revision, last working date of an employee, etc.)
- Designation
Regards,
~Raghav V
From India, Kochi
Acknowledge(0)Amend(0)
You can follow the simple format below. Open the Excel and add the following columns:
- Sl. No
- Employee Name
- Current Monthly Salary (gross)
- Proposed Revised Salary
- Loss of Pay (Number of days)
- Notes (You can mention the effective date of salary revision, last working date of an employee, etc.)
- Designation
Regards,
~Raghav V
From India, Kochi
Acknowledge(0)Amend(0)
Hi Vrusha.. While sending the payroll to Accounts department, we do send following details- S.No. E.Code Name Number of days absent Account number Regards, Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi Vrusha !
For Accounts department to process the salary for a given month, following details are necessary:
Employee Code (unique to each employee), Name of employee, Department in which he/she works, number of days in the month (30/31/28/29), Present days (nos.), Weekly off applicable (nos.), Paid Holidays (nos.), Absent days (nos.), Approved Leave (nos.), Leave Without pay (nos), Total Payable days Over Time (hours). This consolidated statement you can prepare based on Time Office records (manually / computerised)
The master details (salary, designation, etc.) are supposed to be with the department processing salary. If they are not there, you will also be required to provide the salary details.
Hope the above is of some help to you. Please let me know if you need further help on this.
- Hiten
From India, New Delhi
Acknowledge(0)Amend(0)
For Accounts department to process the salary for a given month, following details are necessary:
Employee Code (unique to each employee), Name of employee, Department in which he/she works, number of days in the month (30/31/28/29), Present days (nos.), Weekly off applicable (nos.), Paid Holidays (nos.), Absent days (nos.), Approved Leave (nos.), Leave Without pay (nos), Total Payable days Over Time (hours). This consolidated statement you can prepare based on Time Office records (manually / computerised)
The master details (salary, designation, etc.) are supposed to be with the department processing salary. If they are not there, you will also be required to provide the salary details.
Hope the above is of some help to you. Please let me know if you need further help on this.
- Hiten
From India, New Delhi
Acknowledge(0)Amend(0)
Hi! Here is a format for salary sheet, i think this will solve your problem. Frm Abhinav
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
hi Hiten plz guide me how to caculate salary when total day in month (28/29/30/31) and we have to calculate per day salary on 26 days thanks in advance sadiq
From Pakistan, Lahore
Acknowledge(0)Amend(0)
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Hi sadiq According to rule, salary can be calculated by 30 whatever the days in month. Regards Shilki Bhardwaj
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear,
As per the act, it is to be calculated by 26 days. For example, A has a gross salary of 15000. Number of days: 26 Present days: 26 Earning Total = Gross salary * Present Days / Number of Days. = 15000 * 26 / 26 = Rs 15000/-
From India, New Delhi
Acknowledge(0)Amend(0)
As per the act, it is to be calculated by 26 days. For example, A has a gross salary of 15000. Number of days: 26 Present days: 26 Earning Total = Gross salary * Present Days / Number of Days. = 15000 * 26 / 26 = Rs 15000/-
From India, New Delhi
Acknowledge(0)Amend(0)
Hi Vipin, It means, salary should be calculated according the days of every month. It is the compulsion or it depends on the company policy.
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear,
It is not a compulsion, but it is better to follow the laws because I have seen people calculating salary on the basis of 30 days. However, have you noticed that we calculate gratuity and leave encashment based on 26 days? Why not the salary? It depends on the company policy.
Regards,
Vipin :icon1:
From India, New Delhi
Acknowledge(0)Amend(0)
It is not a compulsion, but it is better to follow the laws because I have seen people calculating salary on the basis of 30 days. However, have you noticed that we calculate gratuity and leave encashment based on 26 days? Why not the salary? It depends on the company policy.
Regards,
Vipin :icon1:
From India, New Delhi
Acknowledge(0)Amend(0)
Dear seniors, I wanted to know i have received my pf a/c details, but i i don`t know how to see my pf a/c balance. plz giude me. Thanks & Regards Soni
From India, Jamnagar
Acknowledge(0)Amend(0)
From India, Jamnagar
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
SALARY SHEET CALCULATION.xls