Payroll Practical Assignment in Tally

Payroll Practical Assignment in Tally

Bharat Stones having a factory cutting granite into slabs and polishing them, selling them at the retail outlet.  It wants to calculate Employees pay as per company’s pay rules and adhere to laws pertaining to payroll.  Set up Tally for managing company’s payroll requirements.

Munir Khan is a factory employee working since 1^st April 2012. Given below is his salary structure from April 2019.

Pay Head	Calculation Type	Calculation criteria
Basic Salary	On Attendance	Rs. 15,000/- Per Month, as per calendar period
Conveyance Allowance	Flat Rate	Rs 1,500/- Per Month
House Rent Allowance	As Computed	40% of Basic Salary
Telephone Allowance	User Defined	As per the bill value
Overtime	Hourly(Production)	Rs. 150/hour
Employee PF @ 12%	As Computed	As per statutory
Employee Contribution to ESI @ 1.75%	As Computed	As per statutory

 

      Muneer Khan was present on all working days in April 2019 and worked overtime of 10 Hrs.Telephone bill amounting to Rs. 354 has been submitted by him. 

      Generate payslip for Mr Muneer Khan for the month of April 2019

 

      On 1^st May 2019, the Company has approved and paid Mr Muneer Khan the Loan request amounting 30,000/- for his personal emergency. From the following month, the company decides to deduct 3,000/- every month for ten months.

       Pay staff advance on 1^st May 2019 and deduct the amount from salary from May 2019.

      Muneer Khan was absent for 2 days in May 2019, salary needs to be deducted for absent days and worked overtime of 15 Hrs.  Telephone bill amounting to Rs. 380 has been submitted by him. 

       Generate payslip for Mr Muneer Khan for the month of May 2019

 

       On 1st June 2019, the company has decided to hike the salary of Mr Muneer Khan, see the table for revised salary.

Pay Head	Calculation Type	Calculation criteria
Basic Salary	On Attendance	Rs. 13,000/- Per Month
Conveyance Allowance	Flat Rate	Rs 1,750/- Per Month
House Rent Allowance	As Computed	40% of Basic Salary
Telephone Allowance	User Defined	As per the bill value
Overtime	Hourly(Production)	Rs. 175/hour
Employee PF @ 12%	As Computed	As per statutory
Employee Contribution to ESI @ 1.75%	As Computed	As per statutory

 

      Muneer Khan was present on all working days in June 2019 and worked overtime of 5 Hrs. Telephone bill amounting to Rs. 350 has been submitted by him. 

     Generate payslip for Mr Muneer Khan for the month of June 2019 and see the difference in salary as per increment.

 

      Below are the outcomes after setting up payroll as per business scenarios, this is for your reference to ensure that you have done it properly.

 

2.1.           business scenario i

Muneer Khan’s Pay Slip for the month of Apr 2019

 

 

2.2.           business scenario ii

Muneer Khan’s Pay Slip for the month of May 2019 with absent days and salary advance deduction

Salary Advance report for checking balance receivable from Employee Muneer Khan

 

2.3.           business scenario iii

Muneer Khan’s Pay Slip for the month of June 2019 with increment