How Do I Prepare an Employee Attendance Sheet for Salary Submission? Need Your Advice!

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

Hi Vrusha,

While sending the payroll to the Accounts department, we do include the 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 a salary sheet. I think this will solve your problem.

From,
Abhinav

Hi Hiten,

Please guide me on how to calculate salary when the total number of days in a month varies (28/29/30/31), and we need to calculate the per-day salary based on 26 days.

Thanks in advance.

Sadiq

Hi Sadiq,

According to the rule, salary can be calculated by 30, regardless of the number of days in the month.

Regards,
Shilki Bhardwaj

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

Hi Vipin,

It means salary should be calculated according to the days of every month. Is this a compulsion, or does it depend on the company policy?

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:

Dear seniors,

I wanted to know that I have received my PF account details, but I don't know how to see my PF account balance. Please guide me.

Thanks & Regards,
Soni

Dear Soni,

Every year, when you submit the return of PF in April for the last currency period, the PF department issues PF slips. These slips provide information about your PF amount, and you will receive them in May.

Regards,

Vipin :icon1: