How to make salary in excel sheet.
Salary calculation is very difficult to maintain manually, but it can be done very quickly with the help of excel sheet and a simple formula.
As you know salary vary day you attend in the offices of Pvt. firms.
Company salary components are
Basic salary
HRA housings allowance
DA dearness allowance
PF provident fund
So when we have to calculate salary we consider above components.
Take home amout is basic salary plus HRA plus DA minus PF.
So formula is
= basic salary/30*attendance+HRA+DA-PF
By using this simple formula you can calculate the salary take home for each employees of the company.
Questions welcome.
Salary calculation is very difficult to maintain manually, but it can be done very quickly with the help of excel sheet and a simple formula.
As you know salary vary day you attend in the offices of Pvt. firms.
Company salary components are
Basic salary
HRA housings allowance
DA dearness allowance
PF provident fund
So when we have to calculate salary we consider above components.
Take home amout is basic salary plus HRA plus DA minus PF.
So formula is
= basic salary/30*attendance+HRA+DA-PF
By using this simple formula you can calculate the salary take home for each employees of the company.
Questions welcome.
No comments:
Post a Comment