Spreadsheet: 696046d1600571229-nssa-deductions-with-age-limit-nssa-with-age-limit
Sheet: EMPLOYEE DATA BASE

Tax Law change in period 8 |  |  | NSSA DEDUCTIONS
 |  |  | PLEASE NOTE deductions are made for all employees below the age of 65 |  |  | Rates  and amounts change in period 8
 |  |  | NSSA RATES | 0.035 |  | NSSA RATES | 0.045
 |  |  | Period | 1 |  | Period | 8
 |  |  | Ceiling | 500 |  | Ceiling | 5000
 |  | **** | If any employee earn less $500, multiply basic salary by 3.5% |  |  | If any employee earn less $5000, multiply basic salary by 4.5%
 |  | **** | If any employee earn more than $500, multiply $500 by 3.5% |  |  | If any employee earn more than $5000, multiply $5000 by 4.5%
 | Date | Period | Employee Code Number | Employee Name | Employee I.D Number | Designation | [NAME] | Age | Disability | Standard Hours | Rate | Basic Salary | Overtime Hours | Overtime Pay Rate | Overtime Pay | Holiday Hours | Holiday Pay Rate | Holiday Pay | Vehicle Engine Capacity | Motoring Benefit | House  Allowance | Transport Allowance | Cash in lieu of leave | Bonus | Total Earnings | Taxable Bonus | Taxable Income | Pension Rate | Pension | Profesional subscription | Nssa
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  |  | 2
 | 2020-01-20 00:00:00 | 10 | CA1 |  |  |  |  |  |  | 150 | 20 |  | 3 |  |  | 2 |  |  |  |  | 2700 | 2700 |  | 6000 |  |  |  |  |  | 1000
 | 2020-02-20 00:00:00 | 2 | CA2 |  |  |  |  |  | No | 150 | 3 |  | 4 |  |  | 2 |  |  |  |  | 1000 | 1500 |  |  |  |  |  |  |  | 1000
 | 2020-03-20 00:00:00 | 3 | Ca3 |  |  |  |  |  | No | 150 | 3 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-04-20 00:00:00 | 4 | [NAME] |  |  |  |  | 20 | No | 150 | 10 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-05-20 00:00:00 | 5 | CA1 |  |  |  |  |  |  | 150 | 10 |  | 3 |  |  | 2 |  |  |  |  | 2700 | 2700 |  | 6000 |  |  |  |  |  | 1000
 | 2020-06-20 00:00:00 | 6 | CA2 |  |  |  |  |  | No | 150 | 10 |  | 4 |  |  | 2 |  |  |  |  | 1000 | 1500 |  |  |  |  |  |  |  | 1000
 | 2020-07-20 00:00:00 | 7 | Ca3 |  |  |  |  |  | No | 150 | 12 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-08-20 00:00:00 | 8 | [NAME] |  |  |  |  | 20 | No | 150 | 35 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-09-20 00:00:00 | 9 | CA1 |  |  |  |  |  |  | 150 | 30 |  | 3 |  |  | 2 |  |  |  |  | 2700 | 2700 |  | 6000 |  |  |  |  |  | 1000
 | 2020-10-20 00:00:00 | 10 | CA2 |  |  |  |  |  | No | 150 | 33 |  | 4 |  |  | 2 |  |  |  |  | 1000 | 1500 |  |  |  |  |  |  |  | 1000
 | 2020-11-20 00:00:00 | 11 | Ca3 |  |  |  |  |  | No | 150 | 36 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-12-20 00:00:00 | 12 | [NAME] |  |  |  |  | 20 | No | 150 | 32 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | Desired Outcome
 | Date | Period | Employee Code Number | Employee Name | Employee I.D Number | Designation | [NAME] | Age | Disability | Standard Hours | Rate | Basic Salary | Overtime Hours | Overtime Pay Rate | Overtime Pay | Holiday Hours | Holiday Pay Rate | Holiday Pay | Vehicle Engine Capacity | Motoring Benefit | House  Allowance | Transport Allowance | Cash in lieu of leave | Bonus | Total Earnings | Taxable Bonus | Taxable Income | Pension Rate | Pension | Profesional subscription | Nssa
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  |  | 2
 | 2020-01-20 00:00:00 | 1 | CA1 |  |  |  |  | 70 |  | 150 | 20 |  | 3 |  |  | 2 |  |  |  |  | 2700 | 2700 |  | 6000 |  |  |  |  |  | 1000 | 0
 | 2020-02-20 00:00:00 | 2 | CA2 |  |  |  |  |  | No | 150 | 3 |  | 4 |  |  | 2 |  |  |  |  | 1000 | 1500 |  |  |  |  |  |  |  | 1000
 | 2020-03-20 00:00:00 | 3 | Ca3 |  |  |  |  | 65 | No | 150 | 3 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000 |  |  |  |  |  |  | 0
 | 2020-04-20 00:00:00 | 4 | [NAME] |  |  |  |  | 20 | No | 150 | 10 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-05-20 00:00:00 | 5 | CA1 |  |  |  |  |  |  | 150 | 10 |  | 3 |  |  | 2 |  |  |  |  | 2700 | 2700 |  | 6000 |  |  |  |  |  | 1000
 | 2020-06-20 00:00:00 | 6 | CA2 |  |  |  |  |  | No | 150 | 10 |  | 4 |  |  | 2 |  |  |  |  | 1000 | 1500 |  |  |  |  |  |  |  | 1000
 | 2020-07-20 00:00:00 | 7 | Ca3 |  |  |  |  | 65 | No | 150 | 12 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000 |  |  |  |  |  |  | 0
 | 2020-08-20 00:00:00 | 8 | [NAME] |  |  |  |  | 20 | No | 150 | 35 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-09-20 00:00:00 | 9 | CA1 |  |  |  |  |  |  | 150 | 30 |  | 3 |  |  | 2 |  |  |  |  | 2700 | 2700 |  | 6000 |  |  |  |  |  | 1000
 | 2020-10-20 00:00:00 | 10 | CA2 |  |  |  |  |  | No | 150 | 33 |  | 4 |  |  | 2 |  |  |  |  | 1000 | 1500 |  |  |  |  |  |  |  | 1000
 | 2020-11-20 00:00:00 | 11 | Ca3 |  |  |  |  |  | No | 150 | 36 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000
 | 2020-12-20 00:00:00 | 12 | [NAME] |  |  |  |  | 20 | No | 150 | 32 |  | 0 |  |  |  |  |  |  |  | 300 |  |  | 6000