Salary Sheet Xls Download - Salary Caluculation

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

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

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.

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

Hi!
Here is a format for salary sheet, i think this will solve your problem.
Frm
Abhinav

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

Hi sadiq
According to rule, salary can be calculated by 30 whatever the days in month.
Regards
Shilki Bhardwaj

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/-

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.

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: