Calculate employee salaries with PAYE tax, pension deductions, and net pay (Nigerian tax rules)
📋 Required Data Format
Required Columns:
- Employee_Name
- Basic_Salary
Optional Columns (will enhance output):
- Housing_Allowance
- Transport_Allowance
- Other_Allowances
- Bank_Account
📊 Sample Data Format
Your Excel file should look like this:
| Employee_Name |
Basic_Salary |
Housing_Allowance |
Transport_Allowance |
| John Doe |
300000 |
150000 |
50000 |
| Jane Smith |
450000 |
200000 |
75000 |
🚀 Upload Your File
Upload your Excel file matching the format above and we'll process it automatically
✨ What You'll Get
- Multiple sheets: Payroll Summary, Individual Payslips, Bank Transfer List
- Automatic calculations:
Gross_Salary,
Pension_8_Percent,
Taxable_Income
- Beautiful formatting with currency symbols
- Professional Excel file ready to share