Spreadsheet: 852150d1702246295-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip-adjustedgcb
Sheet: Nov Salary

 | PAY AS YOU EARN PAYE TABLE
 | Monthly
 |  | $ |  | $ |  | Rates |  | $
 | From | 0 | to | 100 | multiply by rate | 0 | Deduct | 0
 | From | 100.01 | to | 300 |  | 0.2 |  | 20
 | From | 300.01 | to | 1000 |  | 0.25 |  | 35
 | From | 1000.01 | to | 2000 |  | 0.3 |  | 85
 | From | 2000.01 | to | 3000 |  | 0.35 |  | 185
 | From | 3000.01 | and above |  |  | 0.4 |  | 335
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DEDUCTIONS
Date | Employee Name | Basic Salary | Basic Salary | Over time | Over time | Benefits | Benefits | Bonus | Bonus | TOTAL | TOTAL | ZWL connverted to USD | Total Salary | PENSION | PENSION | NSSA | NSSA | NEC | NEC | PAYE | PAYE | Aids Levy | Aids Levy | Net Pay | Net Pay | Total Deductions | Taxable Income | Tax Payable | PAYE | Aids Levy | USD connverted to ZWL | PAYE | Aids Levy | Net Pay | Net Pay
 |  | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL |  |  | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL | USD | ZWL |  |  |  | USD | USD | ZWL | ZWL | ZWL | USD | ZWL
 |  |  |  |  |  |  |  |  |  |  |  | 5791.0824 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03 |  |  | 0.03
2023-01-25 00:00:00 | [NAME] | 193.56 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | Thums | 293.56 | 550000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | Nobert | 100 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | [NAME] | 393.56 | 650000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | CHELSEA | 193.56 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | OWEN I | 293.56 | 550000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | Norton | 100 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | Sister | 193.56 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-01-25 00:00:00 | [NAME] | 193.56 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 0 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | [NAME] | 200 | 0 | 45 | 150000 | 0 | 90000 | 0 | 300000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | Thums | 300 | 550000 | 0 | 150000 | 0 | 90000 | 0 | 340000 |  |  |  |  | 85 | 85 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | Nobert | 197 | 490000 | 0 | 150000 | 0 | 90000 | 0 | 190000 |  |  |  |  | 85 | 85 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | [NAME] | 200 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 200000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | CHELSEA | 400 | 750000 | 0 | 150000 | 0 | 90000 | 0 | 340000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | OWEN I | 200 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 100000 |  |  |  |  | 85 | 85 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | Norton | 197 | 490000 | 0 | 150000 | 0 | 90000 | 0 | 200000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | Sister | 200 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 200000 |  |  |  |  | 85 | 85 | 45 | 0 | 90 | 0
2023-02-25 00:00:00 | [NAME] | 200 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 100000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | [NAME] | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | Thums | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | Nobert | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | [NAME] | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | CHELSEA | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | OWEN I | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | Norton | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | Sister | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0
2023-03-25 00:00:00 | [NAME] | 210 | 450000 | 0 | 150000 | 0 | 90000 | 0 | 90000 |  |  |  |  | 0 | 0 | 45 | 0 | 90 | 0