Explain about salary sheet preparation process using MS Excel file as the base source of employee daily attendance record.

Hemabati

• Jun 9th, 2017

Name, Deduction (EPF, Advance, Loan, Etc), Gross, Overtime, LOP, Late deduction.

annastacia mutinda

• Jan 22nd, 2016

We have the payroll system which is updated every month eg advances , loans then you export the system then create an excel report which have columns for grosspay overtime, deductions then you have the net pay

Answer Question  Select Best Answer

Sashi

• Jul 7th, 2017

PF,ESI,PT and Advance/Lon if any taken....

Ganesh Shetty

• Sep 23rd, 2015

Provident Fund, Employer state Insurance Corporation, Tax deduct at Source, Professional Tax, Medical Claim. It depends upon company HR rules.

Answer Question  Select Best Answer

Neha

• Aug 26th, 2017

10 Lac

KRISHNA

• Jun 4th, 2014

10 LAKHS ONLY

Answer Question  Select Best Answer

Srinivasalu R

• May 27th, 2018

Employee has to work minimum 4 years 240 days for gratuity eligible

Achirabhadra

• Jan 18th, 2018

Basic*15/26*no of years.. emp have to work for more than 5 years .

Answer Question  Select Best Answer

If Gratuity Calculation :Gratuity=Last Basic Pay*15 Days* Number of Year ServiceA person works for 41 year & 6 months in a company.Calculate the Number of the service year

selli

• Apr 26th, 2019

Gratuity= Basic/26*15*41
(41 yr and 6 months =41 yr)
bcz you will have to round up till 6 months

waseer

• Nov 11th, 2017

What is Payroll Disbursements Journal?
What are the steps in Payroll Management?

Answer Question  Select Best Answer

Md Faraz

• May 17th, 2019

SAP is the best software or peoplesoft

Code
 

Answer Question  Select Best Answer