Spreadsheet: 852084d1702159075-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip
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
Date | Employee Name | Basic Salary | Basic Salary | Over time | Benefits | Bonus | TOTAL | TOTAL | ZWL connverted to USD | Total Salary | PENSION | NSSA | NEC | Total Deductions | Taxable Income | PAYE | PAYE | Aids Levy | PAYE | USD connverted to ZWL | Aids Levy | Net Pay | Net Pay
 |  | USD | ZWL | ZWL | ZWL | ZWL | USD | ZWL |  |  | USD | USD | USD |  |  | IZW | USD | USD | ZWL |  | ZWL | USD | ZWL
 |  |  |  |  |  |  |  |  | 5791.0824 |  |  |  |  |  |  |  |  | 0.03 |  |  | 0.03
2023-01-25 00:00:00 | [NAME] | 193.56 | 450000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | Thums | 293.56 | 550000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | Nobert | 100 | 450000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | [NAME] | 393.56 | 650000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | CHELSEA | 193.56 | 450000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | OWEN I | 293.56 | 550000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | Norton | 100 | 450000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | Sister | 193.56 | 450000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-01-25 00:00:00 | [NAME] | 193.56 | 450000 | 150000 | 90000 | 0 |  |  |  |  | 0 | 45 | 90
2023-02-25 00:00:00 | [NAME] | 200 | 490000 | 150000 | 90000 | 300000 |  |  |  |  | 0 | 45 | 90
2023-02-25 00:00:00 | Thums | 300 | 550000 | 150000 | 90000 | 340000 |  |  |  |  | 85 | 45 | 90
2023-02-25 00:00:00 | Nobert | 197 | 490000 | 150000 | 90000 | 190000 |  |  |  |  | 85 | 45 | 90
2023-02-25 00:00:00 | [NAME] | 200 | 450000 | 150000 | 90000 | 200000 |  |  |  |  | 0 | 45 | 90
2023-02-25 00:00:00 | CHELSEA | 400 | 750000 | 150000 | 90000 | 340000 |  |  |  |  | 0 | 45 | 90
2023-02-25 00:00:00 | OWEN I | 200 | 450000 | 150000 | 90000 | 100000 |  |  |  |  | 85 | 45 | 90
2023-02-25 00:00:00 | Norton | 197 | 490000 | 150000 | 90000 | 200000 |  |  |  |  | 0 | 45 | 90
2023-02-25 00:00:00 | Sister | 200 | 450000 | 150000 | 90000 | 200000 |  |  |  |  | 85 | 45 | 90
2023-02-25 00:00:00 | [NAME] | 200 | 450000 | 150000 | 90000 | 100000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | [NAME] | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | Thums | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | Nobert | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | [NAME] | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | CHELSEA | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | OWEN I | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | Norton | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | Sister | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90
2023-03-25 00:00:00 | [NAME] | 210 | 450000 | 150000 | 90000 | 90000 |  |  |  |  | 0 | 45 | 90