No Tags Found!

vrusha
5

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
Raghav
45

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
Amitmhrm
496

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
Hiten Parekh
29

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
Abhinav9412516071
Hi! Here is a format for salary sheet, i think this will solve your problem. Frm Abhinav
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls salary_format_258.xls (15.0 KB, 2478 views)

sadiq106
1

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
Shilki Bhardwaj
Hi sadiq According to rule, salary can be calculated by 30 whatever the days in month. Regards Shilki Bhardwaj
From India, Delhi
vipinmanav
32

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
Shilki Bhardwaj
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
vipinmanav
32

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






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.