I will created a fully automated (via Macro, Conditional Formatting & Formulation) Employee Payroll and Leave Record Excel based spreadsheet you can record payroll data for multiple employees along with prepared Salary slip. It includes details like basic pay, allowances, deductions, and overtime, etc. of employees.
- Designed for businesses with up to 200 employees
- Flexible design for earnings, deductions.
- Automated calculation of income tax.
- Automated calculation of salary deductions
- Automated pay slips
- Includes monthly leaves with Annual Summary and remaining leave quota.
- Highlight Weekend Dates automatically
If you are looking to add further additions and modifications do let me know.