Process Payroll in Excel

Processing Payroll in excel with tax computation, Monthly Salary statement, Pay slip etc.

Process up to 10 employees salary.

 
 
 
1    Update Employee master with employee details.
 
      In employee master select status “EXISTING” Or “LEFT”
 
      if you select the status “LEFT” the salary will not be processed for that employee
 
      If a employee leaves , you need not delete the record, just change the status to “LEFT”
     
2    After updating employee master, update the salary details of each employee.
     
3    Update the tax master with other income and Chapter VI deductions.
 
      PF contribution and LIC deduction from salary is taken automatically.
     
4    After updating all the masters, you can run the payroll for each month.
     
5    If there any revision in the salary , that can be updated in salary master.
     
6    You can view the following report after processing the salary.
 
Salary Statement for the Month
Pay Summary -Bank
Tax Computation
Pay Slip Print
 
 
 
 
Request you to give your valuable feedback to improve.
 

5 thoughts on “Process Payroll in Excel”

  1. Very useful for salary can I process more then 10 employee ?

    Reply
  2. kindly share salary payroll software for FY 19-20

    Reply
  3. indly share salary payroll software for FY 19-20

    Reply
  4. Hi.. The article looks Great with Good Commentaries.. Yet still the Download DOES NOT WORK.. Site Not Found, cannot Evaluate

    Reply

Leave a Comment