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
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
Hi Vrusha,
you can follow the following simple format. Open the excel and add the following columns
Sl.No
Employee Name
Current Monthly Salary (gross)
Proposed revised Salary
Loss of pay (No of days)
Notes (Can mention the effective date of salary revision, last working date of an employee, etc.,)
Designation
Regards,
~Raghav V
From India, Kochi
you can follow the following simple format. Open the excel and add the following columns
Sl.No
Employee Name
Current Monthly Salary (gross)
Proposed revised Salary
Loss of pay (No of days)
Notes (Can mention the effective date of salary revision, last working date of an employee, etc.,)
Designation
Regards,
~Raghav V
From India, Kochi
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
From India, Ahmadabad
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
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
Hi! Here is a format for salary sheet, i think this will solve your problem. Frm Abhinav
From India, Delhi
From India, Delhi
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
From Pakistan, Lahore
Hi sadiq According to rule, salary can be calculated by 30 whatever the days in month. Regards Shilki Bhardwaj
From India, Delhi
From India, Delhi
Dear,
As per the act, it is to be calculated by 26 days.
for e.g.- A has gross salary 15000.
No. of days:-26
Present days-26
Earning Total=Gross salary*Present Days/No. of Days.
=15000*26/26=Rs15000/-
From India, New Delhi
As per the act, it is to be calculated by 26 days.
for e.g.- A has gross salary 15000.
No. of days:-26
Present days-26
Earning Total=Gross salary*Present Days/No. of Days.
=15000*26/26=Rs15000/-
From India, New Delhi
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
From India, Delhi
Dear,
it is not a compulsion, but it is better to follow the laws.
becoz, i have seen people calculated salary on the basis of 30 days.
But have u noticed, we calculate gratuity on 26 days, leave encashment also on 26 days, why not the salary.
it is depend on company policy.
Regards
vipin:icon1:
From India, New Delhi
it is not a compulsion, but it is better to follow the laws.
becoz, i have seen people calculated salary on the basis of 30 days.
But have u noticed, we calculate gratuity on 26 days, leave encashment also on 26 days, why not the salary.
it is depend on company policy.
Regards
vipin:icon1:
From India, New Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
SALARY SHEET CALCULATION.xls