- #PAYROLL SYSTEM EXCEL TEMPLATE UPDATE#
- #PAYROLL SYSTEM EXCEL TEMPLATE SOFTWARE#
- #PAYROLL SYSTEM EXCEL TEMPLATE PROFESSIONAL#
To process the salary for a particular month please go to Home sheet, in that you will have to double click on the month for which you want to process the salary, if the salary process is already completed for that particular month the cell colour will change to blue and if you click on that it will show a message “salary already processed for this month”.
#PAYROLL SYSTEM EXCEL TEMPLATE SOFTWARE#
Based on this information tax computation is done and the TDS is deducted each month accordingly.Īfter updating company master, salary master and tax master the payroll software is ready for salary processing. The details are perquisite details, any other income declared by the employee and the deduction claimed for tax computation.
#PAYROLL SYSTEM EXCEL TEMPLATE UPDATE#
In tax master you have the update the details required for tax calculation. The bank account details of the employee to which we are making the payment of salary is also to be updated in this sheet.
#PAYROLL SYSTEM EXCEL TEMPLATE PROFESSIONAL#
Then you will have to update the salary details like income components, deduction components like PF, professional tax, insurance, Income Tax deduction will be automatically updated based on the projections. Also the company contribution is to be updated along with these information. In that the employee Name which you have updated in home sheet is automatically updated. It will take you to employee salary master sheet. To update salary master, double click on Salary Master in home sheet. In case if an employee resign, you can select Left in status column, that employee record will not be considered for salary processing.Īfter updating company master and employee details the next step is to update salary master of the employee. If the status of a employee is active then that employee record will be considered for salary processing. In this sheet you can update of 100 employees details to process the salary.
Then update Employee number, Employer name, Department, Designation, Date of birth, Date of joining, PF number, Contact details in this sheet. Before updating employee details first select the status as active in drop down list. In HOME sheet you have to update the details of employees. If you want to use this software for different financial year you can update the payroll period in the company master and in case if you want to rerun the payroll for a particular month you can come to company master sheet and delete the payroll status for that particular month. Similarly you can also make changes to the income tax exemption limit for the year, presently the limits are updated as per the financial year 2017-18. In this sheet you have to update the company master, that is company name and address the salary component of the company which includes income components, deduction components and company contributions. In HOME sheet you can double click on company master and it will open the company master sheet. Below are the procedure to use the payroll software. When you open the excel file you will see the HOME sheet this is the main sheet of this software which will connect to all other screens.