Payroll Sample With Dynamic Salary Slip

Description
This is a template of Payroll that consist of complex and nested IF functions and conditional formatting.
You have it for learning purpose.

Payroll Template consist of following Allowances and Deductions:

Allowances:
1) DA Allowances 10%
2) Travelling Depends upon the conditions given in spreadsheet
3) Medical Depends upon the conditions given in spreadsheet
4) Cellphone 5%

Deductions:
1) Income Tax Depends upon the conditions given in spreadsheet.
2) EOBI is 2%

All the rates are dynamic they can be change and upon changing the rates all the values will automatically change.

This payroll is based on sample data which was created by myself for learning purposes. Further in this template you can find the deep learning of following formula function:

1) IF
2) AND
3) VLOOKUP
4) SUM
5) Nested IF

It is a perfect template for the people who works in Finance or Human Resource departments of their respective company.

Further in this template you will also find a good knowledge of conditional formatting, I have tried my best to make a maximum use of conditional formatting in this payroll template.

You can use this payroll template in your corporate life by modifying it as per your requirements.