{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Ref","Package"],"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":11,"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",{"$nulls":4},"Medical Aid Nr of Dependants",null,{"v":1,"d":"1.00"}]
[null,"1 Mar-11 to 29 Feb-12"]
[]
[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",{"$nulls":5},"No Medical Aid",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":7},"Member only",null,{"v":1,"d":"1.00"},{"v":720,"d":"720.00"}]
[null,"Basic Salary",{"v":0,"d":"0.00"},{"$nulls":4},"Member + 1  Dependant",null,{"v":2,"d":"2.00"},{"v":1440,"d":"1,440.00"}]
[null,"Travel Allowance",{"v":0,"d":"0.00"},{"$nulls":4},"Member + 2  Dependants",null,{"v":3,"d":"3.00"},{"v":1880,"d":"1,880.00"}]
[null,"BONUS",{"v":0,"d":"0.00"},{"$nulls":4},"Member + 3  Dependants",null,{"v":4,"d":"4.00"},{"v":2320,"d":"2,320.00"}]
[null,"COMMISSION",{"v":0,"d":"0.00"},{"$nulls":4},"Member + 4  Dependants",null,{"v":5,"d":"5.00"},{"v":2760,"d":"2,760.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,null,"If Company pays towards Medical Aid, insert nr of Members on M/A in field I1"]
[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,"2011-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":150000,"d":"150,000.00"},{"v":235000,"d":"235,000.00"},{"v":325000,"d":"325,000.00"},{"v":455000,"d":"455,000.00"},{"v":580000,"d":"580,000.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":27000,"d":"27,000.00"},{"v":48250,"d":"48,250.00"},{"v":75250,"d":"75,250.00"},{"v":120750,"d":"120,750.00"},{"v":168250,"d":"168,250.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":10755,"d":"10,755.00"}]
[null,null,"Retirement annuity Contribution",{"$nulls":3},0,null,null,"Over 65",{"v":16767,"d":"16,767.00"}]
[{"$nulls":9},"Over 75",{"v":18767,"d":"18,767.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"}]