{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Ref","Package","Sheet1"],"not_rendered":{"external_links":1,"defined_names":5},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Ref","index":0,"n_rows":70,"n_cols":6,"rows_kept":70,"merged":[[0,1,0,2],[1,1,1,2],[3,1,3,2],[22,1,22,2],[35,1,35,2],[53,1,53,2],[65,1,65,2]],"flags":["formulas_cached_only"]}
[null,"COMPANY NAME"]
[null,"1 Mar-13 to 28 Feb-14"]
[]
[null,"PAYSLIP"]
[null,"Employee name"]
[null,"Employee Identity Number"]
[null,"Date"]
[]
[]
[]
[null,"Annual package",{"v":0,"d":"0.00"}]
[null,"Monthly taxable income",{"v":0,"d":"0.00"}]
[null,"Financial year","28 FEBRUARY 2008"]
[]
[null,"Taxable Expenses",{"v":0,"d":"0.00"},"Do not enter anything here"]
[null,"Travel allowance p.m.",{"v":0,"d":"0.00"}]
[null,"Entertainment allowance p.m.",{"v":0,"d":"0.00"}]
[null,"Telephone Re-Imbursment",{"v":0,"d":"0.00"}]
[null,"Cell Phone Re - Imbursment",{"v":0,"d":"0.00"}]
[null,"Company Medical Aid + 67 %",{"v":0,"d":"0.00"}]
[null,"Private Medical Aid ",{"v":0,"d":"0.00"}]
[null,"Bonus / Commisions / Leave Pay",{"v":0,"d":"0.00"}]
[null,"INCOME"]
[]
[null,"Basic Salary",{"v":0,"d":"0.00"}]
[null,"Travel Allowance",{"v":0,"d":"0.00"}]
[null,"BONUS",{"v":0,"d":"0.00"}]
[null,"COMMISSION",{"v":0,"d":"0.00"}]
[null,"Retirement & Medical",{"v":0,"d":"0.00"}]
[]
[null,"Total Income",{"v":0,"d":"0.00"}]
[]
[]
[]
[]
[null,"DEDUCTIONS"]
[null,"Retirment annuity",{"v":0,"d":"0.00"}]
[]
[]
[null,"Acceptable package  50 % <",{"$error":"#DIV/0!"}]
[]
[null,"PAYE",{"v":0,"d":"0.00"}]
[null,"UIF Deducted",{"v":0,"d":"0.00"}]
[null,"Other Deductions",{"v":0,"d":"0.00"},null,null,"Negative Amount"]
[null,"Other Deductions",{"v":0,"d":"0.00"},null,null,"Negative Amount"]
[]
[null,"Total Deductions",{"v":0,"d":"0.00"}]
[]
[]
[]
[null,"Net Pay",{"v":0,"d":"0.00"}]
[]
[]
[null,"COMPANY CONTRIBUTIONS"]
[]
[null,"Medical Aid",{"v":0,"d":"0.00"}]
[null,"Provident / Pension Fund",{"v":0,"d":"0.00"}]
[null,"Other Contributions",{"v":0,"d":"0.00"}]
[null,"UIF",{"v":0,"d":"0.00"}]
[null,"SDL",{"v":0,"d":"0.00"},null,null,"If Annual Payroll less than R500,000.00, make SDL 0.00"]
[]
[null,"Total Contributions",{"v":0,"d":"0.00"}]
[]
[]
[]
[null,"COST TO COMPANY"]
[]
[null,"Total Income",{"v":0,"d":"0.00"}]
[null,"Total Contributions",{"v":0,"d":"0.00"}]
[null,null,{"v":0,"d":"0.00"}]

{"sheet":"Package","index":1,"n_rows":44,"n_cols":16,"rows_kept":44,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,"FINANCIAL YEAR ",null,null,"2014-02-28"]
[null,null,"MONTH",null,null,"00:00:00"]
[]
[null,null,"SALARY ADVICE"]
[]
[null,null,"EMPLOYEE NAME",0]
[]
[null,null,"TOTAL MONTHLY PACKAGE"]
[]
[{"$nulls":3},"Taxable Portion","UIF Portion","Exempt Portion","Total income"]
[{"$nulls":3},"Amount","Amount","Amount","Amount"]
[null,"Income"]
[null,null,"Basic Salary",0,0,0,0]
[null,null,"Travel Allowance",0,0,0,0]
[null,null,"BONUS",0,0,null,0]
[null,null,"COMMISSION",0,0,0,0]
[null,null,"Retirement & Medical",0,0,0,0]
[{"$nulls":3},0,null,null,0]
[null,null,"Private Medical Aid ",0,null,0,0]
[{"$nulls":3},0,null,0,0]
[null,"Tax Deductions",null,0,null,null,0]
[null,null,"Retirement annuity",0,0,0,0]
[{"$nulls":6},0]
[{"$nulls":3},0,0,0,0]
[null,"Deductions",{"$nulls":7},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":165600,"d":"165,600.00"},{"v":258750,"d":"258,750.00"},{"v":358110,"d":"358,110.00"},{"v":500940,"d":"500,940.00"},{"v":638600,"d":"638,600.00"}]
[null,null,"Pay As You Earn",{"$nulls":3},0,null,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":29808,"d":"29,808.00"},{"v":53096,"d":"53,096.00"},{"v":82904,"d":"82,904.00"},{"v":132894,"d":"132,894.00"},{"v":185205,"d":"185,205.00"}]
[null,null,"Unemployment Insurance",{"$nulls":3},0,null,{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},0.18,0.25,{"v":0.3,"d":"0.30"},0.35,0.38,{"v":0.4,"d":"0.40"}]
[null,null,"Company Medical Aid Contribution",{"$nulls":3},0]
[null,null,"Pension Fund Contributions",{"$nulls":3},0,null,"Primary rebate","Under 65",{"v":12080,"d":"12,080.00"}]
[null,null,"Retirement annuity Contribution",{"$nulls":3},0,null,null,"Over 65",{"v":18830,"d":"18,830.00"}]
[{"$nulls":9},"Over 75",{"v":21080,"d":"21,080.00"}]
[null,"NET TAKE HOME SALARY",{"$nulls":4},0]
[]
[]
[null,"COST TO COMPANY"]
[{"$nulls":6},{"v":0,"d":"0.00"}]
[null,null,"Employer UIF portion",{"$nulls":3},0]
[null,null,"Skills Development Levy",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,null,"Medical Aid Contribution",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,null,"Pension Fund Contribution",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,null,"NET COST TO COMPANY",{"$nulls":3},{"v":0,"d":"0.00"}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}