{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Read Me","Errors","Data","Validations","Macros_Disabled","A_Basic_Info","B_Employees_Dtls_Simplified","C_Lump_Sum_Payments_Dtls","D_FBT_Dtls","ValidationList","ImportCsv","E_Tax_Due","Sheet1","Amendment"],"not_rendered":{"images":7,"macros":1,"defined_names":144},"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"merged":[[0,0,0,2],[26,1,26,2],[28,0,28,2],[29,0,29,2],[31,0,31,2]]}
["Help on Enable Macro (Enable Validate button):"]
[]
["FOR EXCEL 2010 :-"]
[null,"To \"Enable Macro\" please follow steps below."]
[null,1,"Click the File Menu (Office BackStage), and then select Options from the left sidebar."]
[null,2,"Click Trust Center, click Trust Center Settings, and then click Macro Settings."]
[null,3,"Select \"Enable all macros\". Click on 'OK'."]
[null,4,"Open the file again."]
["FOR EXCEL 2007 :-"]
[null,"To \"Enable Macro\" please follow steps below."]
[null,1,"Click the Microsoft Office Button                 , and then click Excel Options."]
[null,2,"Click Trust Center, click Trust Center Settings, and then click Macro Settings."]
[null,3,"Select \"Enable all macros\". Click on 'OK'."]
[null,4,"Open the file again."]
[]
["FOR OTHER EXCEL VERSIONS :-"]
[null,"To \"Enable Macro\" please follow steps below."]
[null,1,"Select the Tools menu option and then select Macro and Security. In the resulting Security dialog, set the security level to Low by clicking the Low radio button."]
[null,2,"Close the file and any other instances of the application currently running on the computer (close all excel applications that also use the application you are currently running)."]
[null,3,"Open the file again."]
[null,4,"Click the Enable button to allow the macro to run."]
[]
[null,null,"Fields marked in White color is enabled and data can be entered in that field."]
[null,null,"Fields marked in Grey color is Disabled."]
[null,"\n","Fields marked in Light Grey color is showing Description of field."]
[]
[null,"Change your regional date option from \"Control Panel --> Region and Language\" to \"English(Unites States)\""]
[]
["Please click on \"Validate\" button to check errors in excel sheet. If there is no error in excel sheet then upload file gets generated."]
["Note : While opening a MS Excel 2007 file, macro security issue may arise. To overcome this issue, upgrade to \nMS Excel 2007 Service Pack 2"]

{"sheet":"Errors","index":1,"n_rows":1,"n_cols":5,"rows_kept":1}
["Sr. No.","Section Name","Field","Error Description","Reference Cell"]

{"sheet":"Data","index":2,"n_rows":137,"n_cols":34,"rows_kept":137,"hidden":true}
[null,null,"Boolean","TypeOfEmp","TypeOFEmpCode",null,"TypeOfHousing","TypeOfHousingCode","SortedTypeOfHousing",null,"RefSchedules","RefSchedulesCode","CarTypeCode","CarType","SortedCarType",null,"BodyType","BodyTypeCode","SortedBodyType",null,"EntityType","EntityCode","SortedEntityCode",{"$nulls":3},"Lump Sum Payment Due Year","SlabStart","SlabEnd","Rate"]
[null,null,"Yes","Primary Employee","PRMEMP",null,"Benefit not given","3","Agriculture Farm",null,"B_Employees_Dtls","SCH1","HIRED","Owned","Hired",null,"Saloon Hatch Backs and Estates","LANDOVER","Land Rovers/ Cruisers(excludes Range Rovers and vehicles of similar nature)",null,"Head Office","BRET","Branch",{"$nulls":3},"2000","0","116160","10",null,null,"Specified Term Contract with Compensation (STC-COMP)","Transfer of Gratuity to Registered Pension Scheme"]
[null,null,"No","Secondary Employee","SCNDEMP",null,"Employer's Owned House","0","Benefit not given",null,"C_Disabled_Employees_Dtls","SCH2","OWNED","Hired","Owned",null,"Pick Ups, Panel Vans Uncovered","PICKUPS","Pick Ups, Panel Vans Uncovered",null,"Branch","HOET","Head Office",{"$nulls":4},"116161","225600","15",null,null,"UnSpecified Term Contract with Compensation (USTC-COMP)","Gratuity Payment to Employee"]
[{"$nulls":6},"Employer's Rented House","1","Employer's Owned House",null,"G_Arrears_Dtls_E","SCH6",{"$nulls":4},"Land Rovers/ Cruisers(excludes Range Rovers and vehicles of similar nature)","SLNHTCH","Saloon Hatch Backs and Estates",{"$nulls":8},"225601","335040","20",null,null,"UnSpecified Term Contract with No Compensation (USTC-NOCOMP)"]
[{"$nulls":6},"Agriculture Farm","2","Employer's Rented House",null,"H_Arrears_Dtls_DE","SCH7",{"$nulls":15},"335041","444480","25"]
["MonthsList","Month","SortedMonthList",null,"PurposeOfPolicy","PolicyCode","House to Non full time service Director","4","House to Non full time service Director",{"$nulls":18},"444481",null,"30"]
["Jan","04","April","01","Education","EDU",null,"PolicyHolder","PolicyHolderCode",{"$nulls":17},"2001","0","116160","10"]
["Feb","08","August","02","Health","HLTH",null,"Child","C",{"$nulls":18},"116161","225600","15"]
["Mar","12","December","03","Life","LIFE",null,"Self","S",{"$nulls":18},"225601","335040","20"]
["Apr","02","February","04",{"$nulls":3},"Wife","W",{"$nulls":18},"335041","444480","25"]
["May","01","January","05",{"$nulls":23},"444481",null,"30"]
["Jun","07","July","06",{"$nulls":22},"2002","0","116160","10"]
["Jul","06","June","07",{"$nulls":23},"116161","225600","15"]
["Aug","03","March","08",{"$nulls":23},"225601","335040","20"]
["Sept","05","May","09",null,"Sorted Resident Status","Resident Status","Code for Resident Status",{"$nulls":3},"Contribution Type (NSSF)","ContributionTypeSorted","ContributionTypeCode","Income Type (NSSF)","IncomeTypeSorted","IncomeTypeCode",{"$nulls":10},"335041","444480","25"]
["Oct","11","November","10",null,"Non-Resident","Resident","NONRES",{"$nulls":3},"101-Tier 1","101-Tier 1","101",null,"1-Regular Salary","1",{"$nulls":10},"444481",null,"30"]
["Nov","10","October","11",null,"Resident","Non-Resident","RES",{"$nulls":3},"102-Tier 2","102-Tier 2","102","IncType200","2-Arrears","2",{"$nulls":9},"2003","0","116160","10"]
["Dec","09","September","12",{"$nulls":7},"103-Tier 3","103-Tier 3","103","Opted out","Daily Rate","3",{"$nulls":10},"116161","225600","15"]
[{"$nulls":11},"105-Provident Fund","104-Daily Rate","104",null,"Opted out","4",{"$nulls":10},"225601","335040","20"]
["YearList","OtherYear","ValidationErrorMsgs",null,"OtherYear2",{"$nulls":6},"104-Daily Rate","105-Provident Fund","105","IncType104",{"$nulls":12},"335041","444480","25"]
[2005,"1999"," in proper format(dd/mm/yyyy).",null,"2000",null,"ReturnType","ReturnTypeSorted","ReturnTypeCode",null,null,"200-Opted Out","200-Opted Out","200","Daily Rate",{"$nulls":12},"444481",null,"30"]
[2006,"2000","Please enter Date between Return Period specified and in dd/mm/yyyy proper format.",null,"2001",null,"Original","Amended","AMENDED",{"$nulls":17},"2004","0","116160","10"]
[2007,"2001"," cannot be the current/future date.",null,"2002",null,"Amended","Appended","APPENDED",{"$nulls":5},"IncTypeOth",{"$nulls":12},"116161","225600","15"]
[2008,"2002"," can not be same as  Taxpayer's PIN.",null,"2003",null,"Supplementary","Both","BOTH",{"$nulls":5},"1-Regular Salary",{"$nulls":12},"225601","335040","20"]
[2009,"2003","Please enter numeric value only.",null,"2004",null,"Resubmission NSSF","Original","1",{"$nulls":5},"2-Arrears",{"$nulls":12},"335041","444480","25"]
[2010,"2004","Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed.",null,"2005",null,"Both (Supplementary/Amended)","Resubmission NSSF","2",{"$nulls":18},"444481",null,"30"]
[2011,"2005","Please enter alphanumeric value. Special characters  are  not allowed.",null,"2006",null,"Appended","Supplementary","3",{"$nulls":17},"2005","0","121968","10"]
[2012,"2006","Please enter alphabetic value Only.",null,"2007",{"$nulls":22},"121969","236880","15"]
[2013,"2007"," is Mandatory field.",null,"2008",{"$nulls":22},"236881","351792","20"]
[2014,"2008","Please enter numeric value greater than zero.",null,"2009",{"$nulls":22},"351793","466704","25"]
["2015","2009"," should be before Return Period in Section A.",null,"2010",{"$nulls":22},"466705",null,"30"]
["2016","2010"," should be greater than Employment Start Date.",null,"2011",{"$nulls":21},"2006","0","121968","10"]
["2017","2011"," should be before or same as Year of Income in Section A.",null,"2012",{"$nulls":22},"121969","236880","15"]
[2018,"2012"," should be same as Year of Income in Section A.",null,2013,{"$nulls":22},"236881","351792","20"]
[2019,"2013"," should be same as Return for the Month in Section A.",null,2014,{"$nulls":22},"351793","466704","25"]
[2020,"2014",null,null,"2015",{"$nulls":22},"466705",null,"30"]
[2021,"2015",null,null,"2016",{"$nulls":21},"2007","0","121968","10"]
[2022,"2016",null,null,"2017",{"$nulls":22},"121969","236880","15"]
["2023","2017",null,null,"2018",{"$nulls":22},"236881","351792","20"]
["2024","2018",null,null,2019,{"$nulls":22},"351793","466704","25"]
[2025,"2019",null,null,2020,"2",{"$nulls":21},"466705",null,"30"]
["60","2020",null,null,2021,{"$nulls":21},"2008","0","121968","10"]
["7","2021",null,null,2022,{"$nulls":22},"121969","236880","15"]
["XLS","2022",null,null,"2023",{"$nulls":22},"236881","351792","20"]
["EXCEL 1997-2003","2023",null,null,"2024",{"$nulls":22},"351793","466704","25"]
[null,"2024",null,null,2025,{"$nulls":22},"466705",null,"30"]
["Genrate Uploadeble Xml ?",2025,{"$nulls":24},"2009","0","121968","10"]
["Y",{"$nulls":26},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"2010","0","121968","10"]
[{"$nulls":27},"121969","236880","15"]
["visibleSheetsArr (List of Sheets which should be visible when macros are enabled)",{"$nulls":26},"236881","351792","20"]
["Read Me:Errors:Macros_Disabled:A_Basic_Info:B_Employees_Dtls_Simplified:C_Lump_Sum_Payments_Dtls:D_FBT_Dtls:E_Tax_Due",{"$nulls":26},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"2011","0","121968","10"]
[{"$nulls":27},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
["Social Housing (Income levels between 0-15,000 per month)","Low Cost Housing (Income levels between 15,000-49,999 per month)","LOWHOUSE",{"$nulls":24},"466705",null,"30"]
["Low Cost Housing (Income levels between 15,000-49,999 per month)","Mortgage Gap Housing (Income levels between 50,000 -100,000 per month)","MORTHOUSE",{"$nulls":23},"2012","0","121968","10"]
["Mortgage Gap Housing (Income levels between 50,000 -100,000 per month)","Social Housing (Income levels between 0-15,000 per month)","SOCHOUSE",{"$nulls":24},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"1999","0","116160","10"]
[{"$nulls":27},"116161","225600","15"]
[{"$nulls":27},"225601","335040","20"]
[{"$nulls":27},"335041","444480","25"]
[{"$nulls":27},"444481",null,"30"]
[{"$nulls":26},"1998","0","116160","10"]
[{"$nulls":27},"116161","225600","15"]
[{"$nulls":27},"225601","335040","20"]
[{"$nulls":27},"335041","444480","25"]
[{"$nulls":27},"444481",null,"30"]
[{"$nulls":26},"2013","0","121968","10"]
[{"$nulls":27},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"2014","0","121968","10"]
[{"$nulls":27},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"2015","0","121968","10"]
[{"$nulls":27},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"2016","0","121968","10"]
[{"$nulls":27},"121969","236880","15"]
[{"$nulls":27},"236881","351792","20"]
[{"$nulls":27},"351793","466704","25"]
[{"$nulls":27},"466705",null,"30"]
[{"$nulls":26},"2017","0","134164","10"]
[{"$nulls":27},"134165","260567","15"]
[{"$nulls":27},"260568","386970","20"]
[{"$nulls":27},"386971","513373","25"]
[{"$nulls":27},"513374",null,"30"]
[{"$nulls":26},"2018","0","147576","10"]
[{"$nulls":27},"147577","286620","15"]
[{"$nulls":27},"286621","425664","20"]
[{"$nulls":27},"425665","564708","25"]
[{"$nulls":27},"564709",null,"30"]
[{"$nulls":26},"2019","0","147576","10"]
[{"$nulls":27},"147577","286620","15"]
[{"$nulls":27},"286621","425664","20"]
[{"$nulls":27},"425665","564708","25"]
[{"$nulls":27},"564709",null,"30"]
[{"$nulls":26},"2020","0","147576","10"]
[{"$nulls":27},"147577","286620","15"]
[{"$nulls":27},"286621","425664","20"]
[{"$nulls":27},"425665","564708","25"]
[{"$nulls":27},"564709",null,"30"]
[{"$nulls":26},"2021","0","288000","10"]
[{"$nulls":27},"288001","388000","25"]
[{"$nulls":27},"388001",null,"30"]
[{"$nulls":26},"2022","0","288000","10"]
[{"$nulls":27},"288001","388000","25"]
[{"$nulls":27},"388001",null,"30"]
[{"$nulls":26},2023,0,288000,10]
[{"$nulls":27},288001,388000,25]
[{"$nulls":27},388001,6000000,30]
[{"$nulls":27},6000001,9600000,32.5]
[{"$nulls":27},9600001,null,35]
[{"$nulls":26},2024,0,288000,10]
[{"$nulls":27},288001,388000,25]
[{"$nulls":27},388001,6000000,30]
[{"$nulls":27},6000001,9600000,32.5]
[{"$nulls":27},9600001,null,35]
[{"$nulls":26},"2025","0","288000","10"]
[{"$nulls":27},"288001","388000","25"]
[{"$nulls":27},"388001","6000000","30"]
[{"$nulls":27},"6000001","9600000","32.5"]
[{"$nulls":27},"9600001",null,"35"]

{"sheet":"Validations","index":3,"n_rows":6,"n_cols":10,"rows_kept":6,"hidden":true}
["SectionName","Name","MaxLength","Mandatory","ValidationRule1","Error Message","ValidationRule2","Error Message",null,"Section Description"]
["A_Basic_Info","Employer's Personal Identification Number",11,"Y","isMandatory(RtnInf.TaxPayersPIN,\"Y\")",{"$f":"CONCATENATE(B2,MsgMandat)","v":"Employer's Personal Identification Number is Mandatory field."},"validatePIN(RtnInf.TaxPayersPIN,\"A\")","Please enter Personal Identification Number in proper format.",null,"Section A : Return Information"]
["A_Basic_Info","Type of Return",25,"Y","isMandatory(RtnInf.ReturnType,\"Y\")","Type of Return is Mandatory field.",{"$nulls":3},"Section A : Return Information"]
["A_Basic_Info","Entity Type",25,"Y","isMandatory(RtnInf.EntityType,\"Y\")","Entity Type is Mandatory field.",{"$nulls":3},"Section A : Return Information"]
["A_Basic_Info","Return Period From",25,"Y","isMandatory(RtnInf.RtnPrdFrom,\"Y\")","Return Period From is Mandatory field.",{"$nulls":3},"Section A : Return Information"]
["A_Basic_Info","Return Period To",4,"Y","isMandatory(RtnInf.RtnPrdTo,\"Y\")","Return Period To is Mandatory field.",{"$nulls":3},"Section A : Return Information"]

{"sheet":"Macros_Disabled","index":4,"n_rows":21,"n_cols":4,"rows_kept":21,"hidden":true,"merged":[[0,0,22,0],[0,1,2,3],[0,4,21,7],[3,1,3,3],[21,1,22,3],[22,4,22,6]]}
[null,"It has been detected that Macros are not enabled/Sheet is opened in Protected View in your System. Please follow below instructions to proceed."]
[]
[]
[null,"Help on Enable Macro:"]
[null,"FOR EXCEL 2010 :-"]
[null,null,1,"Click the File Menu (Office BackStage), and then select Options from the left sidebar."]
[null,null,2,"Click Trust Center, click Trust Center Settings, and then click Macro Settings."]
[null,null,3,"Select \"Enable all macros\". Click on 'OK'."]
[null,null,4,"Open the file again."]
[]
[null,"FOR EXCEL 2007 :-"]
[null,null,1,"Click the Microsoft Office Button                 , and then click Excel Options."]
[null,null,2,"Click Trust Center, click Trust Center Settings, and then click Macro Settings."]
[null,null,3,"Select \"Enable all macros\". Click on 'OK'."]
[null,null,4,"Open the file again."]
[]
[null,"FOR OTHER EXCEL VERSIONS :-"]
[null,null,1,"Select the Tools menu option and then select Macro and Security. In the resulting Security dialog, set the security level to Low by clicking the Low radio button."]
[null,null,2,"Close the file and any other instances of the application currently running on the computer (close all excel applications that also use the application you are currently running)."]
[null,null,3,"Open the file again."]
[null,null,4,"Click the Enable button to allow the macro to run."]

{"sheet":"A_Basic_Info","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[0,1,0,2],[1,0,1,1]]}
[null,"Simplified Unified Payroll Return"]
["Section A : Return Information",null,"Version 30.0.0"]
["Employer's Personal Identification Number *",null,"HOET"]
["Type of Return *",null,"05"]
["Entity Type *",null,{"$f":"IF(RtnInf.ReturnType = \"\",\"\",LOOKUP(RtnInf.ReturnType,ReturnTypeSorted,ReturnTypeCode))","v":""}]
["Return Period From *",null,"01/05/2025"]
["Return Period To *",null,"31/05/2025"]
["Do you have Lumpsum/Gratuity/Arrears/Fringe Benefit Tax?","No"]
[{"$f":"IF(B9<>\"\",CONCATENATE(\"01/01/\",B9),\"\")","v":"01/01/2016"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",RIGHT(RtnInf.RtnPrdFrom,4),2016)","v":2016},"01/05/2024"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",MID(RtnInf.RtnPrdFrom,4,2),1)","v":1},"May","01/05/2020"]
[{"$f":"RIGHT(C2,LEN(C2)-8)","v":"30.0.0"},{"$f":"obligationId","v":"7"}]
[{"$f":"templateType","v":"XLS"},{"$f":"officeVersion","v":"EXCEL 1997-2003"},"N"]
[{"$f":"moduleId","v":"2"},{"$f":"formId","v":"60"},""]

{"sheet":"B_Employees_Dtls_Simplified","index":6,"n_rows":7,"n_cols":29,"rows_kept":7,"merged":[[0,0,0,23],[1,0,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,9],[1,10,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,19],[1,20,2,24],[6,0,6,22]]}
["Section B : Details of Salary Paid and PAYE deducted from Employee(s)"]
[{"$nulls":7},"Non Cash Benefits (Ksh)",null,null,"Housing Benefit (Ksh)",{"$nulls":3},"Allowable Deductions (Ksh)"]
[]
["PIN of Employee","Name of Employee","Resident Status","Type of Employee","Persons With Disability (PWD)","Exemption Certificate Number","Total Cash Pay (A)","Value of Car Benefit (B)","Value of Meals(C)","Non Cash Benefits (D)","Type of Housing","Housing Benefit(F)","Other Benefits (G)","Total Gross Pay (Ksh) (H) = (A + B + C + D + F + G))","Social Health Insurance Fund(SHIF)(I)","NSSF Contribution(J)","Other Pension Contribution (K)","Post Retirement Medical Fund(L)","Mortgage Interest (M)","Affordable Housing Levy(N)","Taxable Pay (Ksh) (O) = (G- H-(I+J Max 30k)-(K Max 15k)-(L Max 30k)-N-PWD)","Monthly Personal Relief (Ksh) (P)","Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_\nInsu_Relief) (Ksh) (Q)","PAYE Tax (Ksh) (R) = \n(O - P - Q)","Self Assessed PAYE Tax (Ksh)(S)",{"$nulls":3},"Deposit on Home Ownership Saving Plan (Max 96,000 Ksh or 8,000 Ksh a month) (N)"]
[{"$nulls":5},"",{"$nulls":7},{"$f":"IF(G5=\"\",\"\", IF(G5=\"\",0,G5)+IF(H5=\"\",0,H5)+IF(I5=\"\",0,IF(I5>5000,I5-5000,0))+IF(J5=\"\",0,IF(J5>5000,J5,0))+IF(L5=\"\",0,L5)+IF(M5=\"\",0,M5))","v":""},{"$nulls":6},{"$f":" IF(N5=\"\",\"\",IF((IF(N5=\"\",0,N5)-IF(O5=\"\",0,O5)-IF((IF(P5=\"\",0,P5)+IF(Q5=\"\",0,Q5))>30000,30000,(IF(P5=\"\",0,P5)+IF(Q5=\"\",0,Q5)))-IF(R5=\"\",0,IF(R5>15000,15000,R6))\n-IF(S5=\"\",0,IF(S5>30000,30000,S5))-IF(T5=\"\",0,T5)-IF(E5=\"Yes\",150000,0))<0,0,(IF(N5=\"\",0,N5)-IF(O5=\"\",0,O5)-IF((IF(P5=\"\",0,P5)+IF(Q5=\"\",0,Q5))>30000,30000,(IF(P5=\"\",0,P5)+IF(Q5=\"\",0,Q5)))-IF(R5=\"\",0,IF(R5>15000,15000,R5))\n-IF(S5=\"\",0,IF(S5>30000,30000,S5))-IF(T5=\"\",0,T5)-IF(E5=\"Yes\",150000,0))))","v":""},null,null,{"$f":"IF(U5=\"\",\"\",IF(IF(U5=\"\",0,getTotalTaxPayble(U5,D5,RtnInf.RtnYear)-IF(V5=\"\",0,V5)-IF(W5=\"\",0,IF(W5>5000,5000,W5)))<0,0,\nIF(U5=\"\",0,getTotalTaxPayble(U5,D5,RtnInf.RtnYear)-IF(V5=\"\",0,V5)-IF(W5=\"\",0,IF(W5>5000,5000,W5)))))","v":""},null,{"$f":"IFERROR(LOOKUP(D5,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(K5,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C5,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A5=\"\",\"\",\"DTEMP\")","v":""}]
[{"$nulls":5},"",{"$nulls":7},{"$f":" IF(G6=\"\",\"\",IF(G6=\"\",0,G6)+IF(H6=\"\",0,H6)+IF(I6=\"\",0,IF(I6>5000,I6-5000,0))+IF(J6=\"\",0,IF(J6>5000,J6,0))+IF(L6=\"\",0,L6)+IF(M6=\"\",0,M6))","v":""},{"$nulls":6},{"$f":" IF(N6=\"\",\"\",IF((IF(N6=\"\",0,N6)-IF(O6=\"\",0,O6)-IF((IF(P6=\"\",0,P6)+IF(Q6=\"\",0,Q6))>30000,30000,(IF(P6=\"\",0,P6)+IF(Q6=\"\",0,Q6)))-IF(R6=\"\",0,IF(R6>15000,15000,R6))\n-IF(S6=\"\",0,IF(S6>30000,30000,S6))-IF(T6=\"\",0,T6)-IF(E6=\"Yes\",150000,0))<0,0,(IF(N6=\"\",0,N6)-IF(O6=\"\",0,O6)-IF((IF(P6=\"\",0,P6)+IF(Q6=\"\",0,Q6))>30000,30000,(IF(P6=\"\",0,P6)+IF(Q6=\"\",0,Q6)))-IF(R6=\"\",0,IF(R6>15000,15000,R6))\n-IF(S6=\"\",0,IF(S6>30000,30000,S6))-IF(T6=\"\",0,T6)-IF(E6=\"Yes\",150000,0))))","v":""},null,null,{"$f":"IF(U6=\"\",\"\",IF(IF(U6=\"\",0,getTotalTaxPayble(U6,D6,RtnInf.RtnYear)-IF(V6=\"\",0,V6)-IF(W6=\"\",0,IF(W6>5000,5000,W6)))<0,0,\nIF(U6=\"\",0,getTotalTaxPayble(U6,D6,RtnInf.RtnYear)-IF(V6=\"\",0,V6)-IF(W6=\"\",0,IF(W6>5000,5000,W6)))))","v":""},null,{"$f":"IFERROR(LOOKUP(D6,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(K6,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C6,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A6=\"\",\"\",\"DTEMP\")","v":""}]
["Total",{"$nulls":22},{"$f":"SUM(X5:OFFSET(DtlsSalPdBftsPayeDedFrmEmpListTO,-1,0))","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y5:OFFSET(DtlsSalPdBftsSelfPayTaxListTO,-1,0))","v":{"v":0,"d":"0.00"}}]

{"sheet":"C_Lump_Sum_Payments_Dtls","index":7,"n_rows":5,"n_cols":29,"rows_kept":5,"hidden":true,"merged":[[0,0,0,28],[4,0,4,26]]}
["Section C : Calculation of PAYE Tax on Lump Sum/Gratuity/Arrears Payments"]
["PIN of Employee","Name of Employee","Resident Status","Type of Employee","Persons With Disability (PWD)","Exemption Certificate Number","Type of Payment","Lumpsum Payments Option","Contract Term Years","Remaining Term Years","Lumpsum Amount","Current Annual Remuneration","Spread Years","Spread Amount per Year\n(Spread not more than Lumpsum)","Lumpsum/Gratuity/Arrears Year","Gratuity Paid/Gratuity Transferred","Gratuity Years","Spread Per Year","Taxable Pay Per Year\nExcess gratuity ","PAYE on Gratuity Spread and Taxable Pay","Tax Deducted Per Year","Year","Month","Arrears Amount\n (A)","Taxable Pay for Specific Arrears Period\n(B)","Tax Payable ('C)\n (A+B)","Tax Deducted on Taxable Pay (D)","Amount of PAYE Tax Payable  ('E) (C-D)","Self Assessed PAYE\n (F)"]
[{"$nulls":12},{"$f":"IF(H3=\"UnSpecified Term Contract with No Compensation (USTC-NOCOMP)\",3,IF(L3=\"\",IF(J3=\"\",\"\",J3),(IF(K3=\"\",\"\",ROUNDUP(K3/L3,0)))))","v":""},{"$f":"IF(H3=\"Specified Term Contract with Compensation (STC-COMP)\", IF(J3=\"\",\"\",IF(K3=\"\",\"\",(K3/J3))), IF(H3=\"UnSpecified Term Contract with No Compensation (USTC-NOCOMP)\", IF(K3=\"\",\"\",(K3/M3)),IF(L3=\"\",\"\",L3)))","v":""},null,null,1,{"$f":"IF(Q3=\"\",\"\",IF(Q3<=0,\"\",(IF(P3=\"\",0,ROUNDUP((P3/Q3),0)))))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(O3=\"\",\"\",IF(S3=\"\",\"\",IF(R3=\"\",\"\",getTaxPayableGratuity((S3+R3), O3))))","v":""},{"$nulls":5},{"$f":"IF(V3=\"\",\"\",IF(X3=\"\",\"\",IF(Y3=\"\",\"\",getTotalTaxPayble(X3+Y3, D3, V3))))","v":""},null,{"$f":"IF(G3=\"\",\"\",IF(G3=\"Lumpsum\",IF(O3=\"\",0,IF(N3=\"\",0,getTaxPayableFromYearLumpsum(O3,N3,J3,K3,H3,M3))),\nIF(G3=\"Gratuity/Severence\",IF(O3=\"\",0,IF(T3=\"\",0,IF(U3=\"\",T3,IF((T3-U3)<0,0,(T3-U3))))),\nIF(Z3=\"\",\"\",IF(AA3=\"\",\"\",IF(E3=\"\",\"\",getTaxPayableFromYearArears(E3,Z3,AA3)))))))","v":""}]
[{"$nulls":5},"",{"$nulls":6},{"$f":"IF(H4=\"UnSpecified Term Contract with No Compensation (USTC-NOCOMP)\",3,IF(L4=\"\",IF(J4=\"\",\"\",J4),(IF(K4=\"\",\"\",ROUNDUP(K4/L4,0)))))","v":""},{"$f":"IF(H4=\"Specified Term Contract with Compensation (STC-COMP)\", IF(J4=\"\",\"\",IF(K4=\"\",\"\",(K4/J4))), IF(H4=\"UnSpecified Term Contract with No Compensation (USTC-NOCOMP)\", IF(K4=\"\",\"\",(K4/M4)),IF(L4=\"\",\"\",L4)))","v":""},{"$nulls":3},{"$f":"IF(Q4=\"\",\"\",IF(Q4<=0,\"\",(IF(P4=\"\",0,ROUNDUP((P4/Q4),0)))))","v":""},null,{"$f":"IF(O4=\"\",\"\",IF(S4=\"\",\"\",IF(R4=\"\",\"\",getTaxPayableGratuity((S4+R4), O4))))","v":""},{"$nulls":5},{"$f":"IF(V4=\"\",\"\",IF(X4=\"\",\"\",IF(Y4=\"\",\"\",getTotalTaxPayble(X4+Y4, D4, V4))))","v":""},null,{"$f":"IF(G4=\"\",\"\",IF(G4=\"Lumpsum\",IF(O4=\"\",0,IF(N4=\"\",0,getTaxPayableFromYearLumpsum(O4,N4,J4,K4,H4,M4))),IF(G4=\"Gratuity/Severence\",\nIF(O4=\"\",0,IF(T4=\"\",0,IF(U4=\"\",T4,IF((T4-U4)<0,0,(T4-U4))))),\nIF(Z4=\"\",\"\",IF(AA4=\"\",\"\",IF(E4=\"\",\"\",getTaxPayableFromYearArears(E4,Z4,AA4)))))))","v":""}]
["Total",{"$nulls":26},{"$f":"SUM(AB3:OFFSET(DtlsArrSalPdBftsPayeDedFrmEmpListTO,-1,0))","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AC3:OFFSET(TaxPdOnLumpSumPdAftrTrmtnListTO,-1,0))","v":{"v":0,"d":"0.00"}}]

{"sheet":"D_FBT_Dtls","index":8,"n_rows":5,"n_cols":11,"rows_kept":5,"hidden":true,"merged":[[0,0,0,10],[4,0,4,9]]}
["Section D : Calculation of Fringe Benefit Tax Payable"]
["PIN of Employee","Name of Employee","Loan Account Number","Loan Amount (Ksh)","Amount of Loan Outstanding (Ksh) (A)","Rate of Interest on Loan (%) (B)","Interest on Loan (Ksh) (C)=(A)*(B)","Prescribed Market Interest Rate (%) (D)","Prescribed Market Interest (Ksh) (E) = (A)*(D)","Amount of Fringe Benefit (Ksh) (F) = (E - C)","Amount of Fringe Benefit Tax  (Ksh) (G) = (F) * 30%"]
[{"$nulls":6},{"$f":"IF(E3<>\"\",E3*F3/100,\"\")","v":""},null,{"$f":"IF(E3<>\"\",E3*H3/100,\"\")","v":""},{"$f":"IF(G3<>\"\",IF(I3<>\"\",IF(ROUND(I3,2)-ROUND(G3,2)<0,0,ROUND(I3,2)-ROUND(G3,2)),\"\"),\"\")","v":""},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)>\"2019\", IF(MID(RtnInf.RtnPrdFrom,7,4)=\"2020\", IF(MID(RtnInf.RtnPrdFrom,4,2)>=\"04\",IF(J3<>\"\",J3*25/100,\"\"),IF(J3<>\"\",J3*30/100,\"\")),IF(J3<>\"\",J3*30/100,\"\")),IF(J3<>\"\",J3*30/100,\"\")),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(E4<>\"\",E4*F4/100,\"\")","v":""},null,{"$f":"IF(E4<>\"\",E4*H4/100,\"\")","v":""},{"$f":"IF(G4<>\"\",IF(I4<>\"\",IF(ROUND(I4,2)-ROUND(G4,2)<0,0,ROUND(I4,2)-ROUND(G4,2)),\"\"),\"\")","v":""},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)>\"2019\", IF(MID(RtnInf.RtnPrdFrom,7,4)=\"2020\", IF(MID(RtnInf.RtnPrdFrom,4,2)>=\"04\",IF(J4<>\"\",J4*25/100,\"\"),IF(J4<>\"\",J4*30/100,\"\")),IF(J4<>\"\",J4*30/100,\"\")),IF(J4<>\"\",J4*30/100,\"\")),\"\")","v":""}]
["Total",{"$nulls":9},{"$f":"SUM(K3:OFFSET(FringeBenfTaxCalcListTO,-1,0))","v":{"v":0,"d":"0.00"}}]

{"sheet":"ValidationList","index":9,"n_rows":18,"n_cols":31,"rows_kept":18,"hidden":true}
["Category","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation",null,"Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation",null,"Section Description"]
["B_Employees_Dtls_Simplified","PIN of Employee","Name of the  Employee","Residential Status","Type of Employee","Person With Disability","Exemption Certificate Number","Total Cash Pay (A)","Value of Car Benefit (\"Value of Car Benefit\" from D_Computation_of_\nCar_Benefit)(B)","Meal Allowance","Other Non Cash Benefits (D)","Type of Housing","Housing Benefit","Total Gross Pay","Social Health Insurance Fund","NSSF Contribution","Actual Contribution","Post Retirement Medical Fund","Mortgage Interest","Affordable Housing Levy","Taxable Pay ","Monthly Personal Relief","Amount of Insurance Relief","PAYE Tax","Self Assessed PAYE Tax","Other Benefits",{"$nulls":4},"Section B : Details of Salary Paid and PAYE deducted from Employee(s)"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","N","N","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"A\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"B\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"C\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"D\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"E\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"F\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"G\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"H\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"I\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"J\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"K\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"L\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"N\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"O\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"P\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"Q\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"R\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"S\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"T\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"U\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"V\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"W\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"N\",\"X\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"Y\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"M\")"]
["Error Message",{"$f":"CONCATENATE(B2,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of the  Employee is Mandatory field.","Residential Status is Mandatory field.","Type of Employee is Mandatory field.","Person With Disability is Mandatory field.","Exemption Certificate Number is Mandatory field.","Total Cash Pay(A) is Mandatory field.","Value of Car Benefit  is Mandatory field.","Meal Allowance  is Mandatory field.","Other Non Cash Benefits (D) is Mandatory field.","Type of Housing is Mandatory field.","Housing Benefit is Mandatory field.","Total Gross Pay is Mandatory field.","Social Health Insurance Fund is Mandatory field.","NSSF Contribution is Mandatory field.",{"$f":"CONCATENATE(Q2,MsgMandat)","v":"Actual Contribution is Mandatory field."},"Post Retirement Medical Fund is Mandatory field.","Mortgage Interest is Mandatory field.","Affordable Housing Levy is Mandatory field.","Taxable Pay  is Mandatory field.",{"$f":"CONCATENATE(V2,MsgMandat)","v":"Monthly Personal Relief is Mandatory field."},"Amount of Insurance Relief is Mandatory field.","Amount of Insurance Relief is Mandatory field.","Value of Car Benefit is Mandatory field.","Other Benefits is a Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(DtlsSalPdBftsPayeDedFrmEmp.List,\"A\")","validateAlphaNumeric(DtlsSalPdBftsPayeDedFrmEmp.List,\"B\")",{"$nulls":4},"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"G\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"H\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"I\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"J\")",null,"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"L\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"N\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"O\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"P\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"Q\")",null,"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"S\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"T\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"U\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"V\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"W\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"X\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"M\")"]
["Error Message","Please enter Employee's PIN in proper format.",{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},null,{"$f":"MsgNum","v":"Please enter numeric value only."},null,"Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.",null,"Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.",{"$f":"MsgNum","v":"Please enter numeric value only."},null,{"$f":"MsgNum","v":"Please enter numeric value only."},"Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only."]
[]
["D_Lump_Sum_Payments_Dtls","PIN of Employee","Name of the  Employee","Residential Status","Type of Employee","Person With Disability","Exemption Certificate Number","Type of Payment","Lumpsum Payments Option","Contract Term Years","Remaining Term Years","Lumpsum Amount","Current Annual Remuneration","Spread Years","Spread Amount per Year\r\n(Spread not more than Lumpsum)","Lumpsum/Gratuity/Arrears Year","Gratuity Value","Gratuity Years","Spread per Year","Taxable Pay per Year\r\nExcess gratuity ","PAYE on Gratuity Spread and Taxable Pay","Tax Deducted per Year","Year","Month","Arrears Amount","Taxable Pay for Specific Arrears Period","Tax Payable\r\non Column (W,X)","Tax Deducted on Taxable Pay","Amount of PAYE Tax Payable ","Self Assessed PAYE","Section F : Calculation of PAYE Tax on Lump Sum Payments Paid after Termination"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"A\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"B\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"C\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"D\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"E\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"F\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"G\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"H\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"I\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"J\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"K\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"L\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"M\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"N\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"O\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"P\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"Q\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"R\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"S\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"T\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"U\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"V\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"W\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"X\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"Y\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"Z\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"AA\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"AB\")","isMandatory(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\",\"AC\")"]
["Error Message",{"$f":"CONCATENATE(B10,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of the  Employee is Mandatory field.","Residential Status is Mandatory field.","Type of Employee is Mandatory field.",{"$f":"CONCATENATE(F10,MsgMandat)","v":"Person With Disability is Mandatory field."},"Exemption Certificate Number is Mandatory field.","Type of Payment is Mandatory field.","Lumpsum Payments Option is Mandatory field.","Contract Term Years is Mandatory field.","Remaining Term Years is Mandatory field.","Lumpsum Amount is Mandatory field.","Current Annual Remuneration is Mandatory field.","Spread Years is Mandatory field.","Spread Amount per Year\r\n(Spread not more than Lumpsum) is Mandatory field.","Lumpsum/Gratuity/Arrears Year is Mandatory field.","Gratuity Value is Mandatory field.","Gratuity Years is Mandatory field.","Spread per Year is Mandatory field.","Taxable Pay per Year\r\nExcess gratuity  is Mandatory field.","PAYE on Gratuity Spread and Taxable Pay is Mandatory field.","Tax Deducted per Year is Mandatory field.","Year is Mandatory field.","Month is Mandatory field.","Arrears Amount is Mandatory field.","Taxable Pay for Specific Arrears Period is Mandatory field.","Tax Payable\r\non Column (W,X) is Mandatory field.","Tax Deducted on Taxable Pay is Mandatory field.","Amount of PAYE Tax Payable  is Mandatory field.","Self Assessed PAYE is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(TaxPdOnLumpSumPdAftrTrmtn.List,\"A\")","validateAlphaNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"B\")",{"$nulls":8},"validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"K\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"L\")",null,"validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"N\")",null,"validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"P\")",null,null,"validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"S\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"T\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"U\")",null,null,"validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"X\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"Y\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"Z\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"AA\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"AB\")","validateCurrencyFormat(TaxPdOnLumpSumPdAftrTrmtn.List,\"AC\")"]
["Error Message","Please enter Employee's PIN in proper format.",{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},{"$nulls":8},"Please enter numeric value only.","Please enter numeric value only.",null,"Please enter numeric value only.",null,"Please enter numeric value only.",null,null,"Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.",null,null,"Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only."]
["ValidationRule3"]
["Error Message"]

{"sheet":"ImportCsv","index":10,"n_rows":1892,"n_cols":41,"rows_kept":1892,"hidden":true}
["For Section B"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",76,"A1:B2","C"]
["crit2",80,"A5:B6","D"]
["crit3",84,"A9:B10","E"]
["crit4",88,"A13:A14","G"]
["crit5",92,"A17:A18","H"]
["crit6",96,"A21:A22","I"]
["crit7",100,"A25:A26","J"]
["crit8",104,"A29:E30","K"]
["crit9",108,"A33:A34","M"]
["crit10",112,"A37:A38","N"]
["crit11",116,"A41:A42","Q"]
["crit12",120,"A45:A46","R"]
["crit13",124,"A49:A50","S"]
["crit14",128,"A53:B54","T"]
["crit15",132,"A57:A58","W"]
["crit16",136,"A61:B62","X"]
["crit17",140,"A65:B66","L"]
["crit18",144,"A69:B70","L"]
["crit19",148,"A73:B74","O"]
["crit20",152,"A77:B78","P"]
["crit21",156,"A81:B82","U"]
["crit22",160,"A85:B86","V"]
["crit23",164,"A89:B90","O"]
["crit24",168,"A93:B94","P"]
["crit25",172,"A97:B98","U"]
["crit26",176,"A101:B102","V"]
["crit27",180,"A105:B106","F"]
["crit28",184,"A109:B110","F"]
["crit29",188,"A113:B114","M"]
{"$rows_empty":43}
["Res","Res"]
["<>Resident","<>Non-Resident"]
["Residential Status' should contain value  'Resident' or 'Non-Resident' in the following row(s): "]
[]
["Type","Type"]
["<>Primary Employee","<>Secondary Employee"]
["Type of Employee' should contain value 'Primary Employee' or 'Secondary Employee' in the following row(s): "]
[]
["Pwd","Pwd"]
["<>Yes","<>No"]
["The cell PWD' should contain value 'Yes' or 'No' in the following row(s): "]
[]
["A"]
["="]
["Total Cash Pay (A)' should not be blank in the following row(s): "]
[]
["B"]
["="]
["Value of Car Benefit (\"Value of Car Benefit\" from D_Computation_of_\nCar_Benefit)(B) should not be blank in the following row(s): "]
[]
["C"]
["="]
["Value of Meals(C)' should not be blank in the following row(s):  "]
[]
["D"]
["="]
["Other Non Cash Benefits (D)' should not be blank in the following row(s): "]
[]
["Housing","Housing","Housing","Housing","Housing"]
["<>Benefit not given","<>House to Non full time service Director","<>Employer's Owned House","<>Employer's Rented House","<>Agriculture Farm"]
["Type of Housing' should contain value 'Benefit not given' or 'House to Non full time service Director' or 'Employer's Owned House' or 'Employer's Rented House' or 'Agriculture Farm' in the following row(s): "]
[]
["H"]
["<>"]
["Total Gross Pay (Ksh) (H) = (A + B + C + D + F + G))' should be blank in the following row(s): "]
[]
["I"]
["="]
["SHIF(I)' should not be blank in the following row(s): "]
[]
["L"]
["="]
["Post Retirement Medical Fund(L)' should not be blank in the following row(s): "]
[]
["M"]
["="]
["Mortgage Interest (M)' should contain value in the following row(s): "]
[]
["N"]
["="]
["Affordable Housing Levy(N)'  should contain value in the following row(s): "]
[]
["O"]
["<>"]
["Taxable Pay (Ksh) (O)' should not have value in the following row(s): "]
[]
["R"]
["<>"]
["PAYE Tax (Ksh) (R) = (R - S - T)'  should not contain value in the following row(s): "]
[]
["S"]
["="]
["Self Assessed PAYE Tax (Ksh)('S) should contain value in the following row(s):"]
[]
["Housing","F"]
[{"$f":"\"=Benefit not given\"","v":"=Benefit not given"},"<>"]
["As 'Type of Housing' contains 'Benefit not given', 'Housing Benefit(F)'  should be blank in the following row(s): "]
[]
["Housing","F"]
[{"$f":"\"<>Benefit not given\"","v":"<>Benefit not given"},{"$f":"\"=\"","v":"="}]
["As 'Type of Housing' is not  'Benefit not given', 'Housing Benefit (F)'  should contain value in the following row(s): "]
[]
["Res","J"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},"<>"]
["As 'Resident Status' contains 'Non-Resident', 'NSSF Contribution(I)' should be blank in the following row(s): "]
[]
["Res","K"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},"<>"]
["As 'Resident Status' contains 'Non-Resident', 'Actual Contribution (J)' should be blank in following row(s): "]
[]
["Res","P"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},"<>"]
["As 'Resident Status' contains 'Non-Resident', 'Monthly Personal Relief (Ksh) (O)' should be blank in the following row(s): "]
[]
["Res","Q"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},"<>"]
["As 'Resident Status' contains 'Non-Resident', 'Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_\nInsu_Relief) (Ksh) (P)' should be blank in the following row(s): "]
[]
["Res","J"]
[{"$f":"\"=Resident\"","v":"=Resident"},"="]
["As 'Resident Status' is 'Resident', 'NSSF Contribution(I)' should have value in the following row(s): "]
[]
["Res","K"]
[{"$f":"\"=Resident\"","v":"=Resident"},"="]
["As 'Resident Status' contains 'Resident', 'Actual Contribution (J)' should not be blank in the following row(s): "]
[]
["Res","P"]
[{"$f":"\"=Resident\"","v":"=Resident"},"="]
["As 'Resident Status' contains 'Resident', 'Monthly Personal Relief (Ksh) (O)' should not be blank in the following row(s):"]
[]
["Res","Q"]
[{"$f":"\"=Resident\"","v":"=Resident"},"="]
["As 'Resident Status' contains 'Resident', 'Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_\nInsu_Relief) (Ksh) (P)' should not be blank in the following row(s): "]
[]
["Pwd","PwdCert"]
[{"$f":"\"=Yes\"","v":"=Yes"},"="]
["As 'PWD' contains 'Yes', 'Exemption Certificate Number ' should not be blank in the following row(s): "]
[]
["Pwd","PwdCert"]
[{"$f":"\"=No\"","v":"=No"},"<>"]
["As 'PWD' contains 'No', 'Exemption Certificate Number ' should be blank in the following row(s): "]
[]
["G"]
["="]
["Other Benefits (G)' should not be blank in the following row(s): "]
[]
["Pin","Name","Res","Type","Pwd","PwdCert","A","B","C","D","Housing","F","G","H","I","J","K","L","M","N","O","P","Q","R","S"]
{"$rows_empty":57}
["FOR SECTION F"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",395,"A1:B2","C"]
["crit2",399,"A5:B6","D"]
["crit3",403,"A9:B10","E"]
["crit4",407,"A13:B14","F"]
["crit5",411,"A17:B18","F"]
["crit6",415,"A21:C22","G"]
["crit7",419,"A25:B26","G"]
["crit8",423,"A29:B30","G"]
["crit9",427,"A33:B34","G"]
["crit10",431,"A37:B38","H"]
["crit11",435,"A41:B42","H"]
["crit12",439,"A45:B46","H"]
["crit13",443,"A49:B50","H"]
["crit14",447,"A53:B54","H"]
["crit15",451,"A57:B58","H"]
["crit16",455,"A61:B62","G"]
["crit17",459,"A65:B66","G"]
["crit18",463,"A69:B70","G"]
["crit19",467,"A73:B74","G"]
["crit20",471,"A77:B78","G"]
["crit21",475,"A81:B82","G"]
["crit22",479,"A85:B86","H"]
["crit23",483,"A89:B90","H"]
["crit24",487,"A93:B94","H"]
["crit25",491,"A97:B98","H"]
["crit26",495,"A101:B102","H"]
["crit27",499,"A105:B106","H"]
["crit28",503,"A109:B110","G"]
["crit29",507,"A113:B114","G"]
["crit30",511,"A117:B118","G"]
["crit31",515,"A121:B122","G"]
["crit32",519,"A125:B126","G"]
["crit33",523,"A129:B130","G"]
["crit34",527,"A133:B134","G"]
["crit35",531,"A137:B138","G"]
["crit36",535,"A141:B142","G"]
["crit37",539,"A145:B146","G"]
["crit38",543,"A149:B150","G"]
["crit39",547,"A153:B154","G"]
["crit40",551,"A157:B158","G"]
["crit41",555,"A161:B162","G"]
["crit42",559,"A165:B166","G"]
["crit43",563,"A169:B170","G"]
["crit44",567,"A173:B174","G"]
["crit45",571,"A177:B178","G"]
["crit46",575,"A181:B182","G"]
["crit47",579,"A185:B186","G"]
["crit48",583,"A189:B190","G"]
["crit49",587,"A193:B194","G"]
["crit50",591,"A197:B198","G"]
["crit51",595,"A201:B202","G"]
["crit52",599,"A205:B206","G"]
["crit53",603,"A209:B210","G"]
["crit54",607,"A213:B214","G"]
["crit55",611,"A217:B218","G"]
["crit56",615,"A221:D222","G"]
["crit57",619,"A225:C226","G"]
["crit58",623,"A229:B230","G"]
["crit59",627,"A233:B234","G"]
["crit60",631,"A237:B238","G"]
["crit61",635,"A241:B242","G"]
["crit62",639,"A245:B246","G"]
["crit63",643,"A249:B250","G"]
["crit64",647,"A253:B254","G"]
["crit65",651,"A257:B258","G"]
["crit66",655,"A261:B262","G"]
["crit67",659,"A265:B266","G"]
["crit68",663,"A269:B270","G"]
["crit69",667,"A273:B274","G"]
["crit70",671,"A277:B278","G"]
["crit71",675,"A281:B282","G"]
["crit72",679,"A285:B286","G"]
["crit73",683,"A289:B290","G"]
["crit74",687,"A293:B294","G"]
["crit75",691,"A297:B298","G"]
["crit76",695,"A301:B302","G"]
["crit77",699,"A305:B306","G"]
["crit78",703,"A309:B310","G"]
["crit79",707,"A313:B314","G"]
["crit80",711,"A317:B318","G"]
["crit81",715,"A321:B322","G"]
["crit82",719,"A325:B326","G"]
["crit83",723,"A329:B330","G"]
["crit84",727,"A333:B334","G"]
["crit85",731,"A337:B338","G"]
["crit86",735,"A341:B342","G"]
["crit87",739,"A345:B346","G"]
["crit88",743,"A349:B350","G"]
["crit89",747,"A353:B354","G"]
["crit90",751,"A357:B358","G"]
["crit91",755,"A361:B362","G"]
["crit92",759,"A365:B366","G"]
["crit93",763,"A369:B370","G"]
["crit94",767,"A373:B374","G"]
["crit95",771,"A377:B378","G"]
["crit96",775,"A381:B382","G"]
["crit97",779,"A385:B386","G"]
["crit98",783,"A389:B390","G"]
["crit99",787,"A393:B394","G"]
["crit100",791,"A397:B398","G"]
["crit101",795,"A401:B402","G"]
["crit102",799,"A405:B406","G"]
["crit103",803,"A409:B410","G"]
["crit104",807,"A413:B414","G"]
["crit105",811,"A417:B418","G"]
["crit106",815,"A421:B422","G"]
["crit107",819,"A425:B426","G"]
{"$rows_empty":36}
["Res","Res"]
["<>Resident","<>Non-Resident"]
["Residential Status' should contain value  'Resident' or 'Non-Resident' in the following row(s): "]
[]
["EmpType","EmpType"]
["<>Primary Employee","<>Secondary Employee"]
["Type of Employee' should contain value 'Primary Employee' or 'Secondary Employee' in the following row(s): "]
[]
["Pwd","Pwd"]
["<>Yes","<>No"]
["The cell PWD' should contain value 'Yes' or 'No' in the following row(s): "]
[]
["Pwd","PwdCert"]
[{"$f":"\"=Yes\"","v":"=Yes"},"="]
["As 'PWD' contains 'Yes', 'Exemption Certificate Number ' should not be blank in the following row(s): "]
[]
["Pwd","PwdCert"]
[{"$f":"\"=No\"","v":"=No"},"<>"]
["As 'PWD' contains 'No', 'Exemption Certificate Number ' should be blank in the following row(s): "]
[]
["Type","Type","Type"]
["<>Lumpsum","<>Gratuity/Severence","<>Arrears"]
["Type of Payment' should contain 'Lumpsum' or 'Gratuity/Severence' or 'Arrears' in the following row(s): "]
[]
["Type","paymentOption"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Payment Option ' should be blank in the following row(s): "]
[]
["Type","I"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell I ' should be blank in the following row(s): "]
[]
["Type","J"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell J' should be blank in the following row(s): "]
[]
["Type","K"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell K' should be blank in the following row(s): "]
[]
["Type","L"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell L ' should be blank in the following row(s): "]
[]
["Type","O"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell O' should be blank in the following row(s): "]
[]
["Type","Q"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell Q' should be blank in the following row(s): "]
[]
["Type","S"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell S' should be blank in the following row(s): "]
[]
["Type","U"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"<>"]
["As 'Type of payment' contains 'Arrears', 'Cell U' should be blank in the following row(s): "]
[]
["Type","V"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"="]
["As 'Type of payment' contains 'Arrears', 'Cell V ' should not be blank in the following row(s): "]
[]
["Type","W"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"="]
["As 'Type of payment' contains 'Arrears', 'Cell W ' should not be blank in the following row(s): "]
[]
["Type","X"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"="]
["As 'Type of payment' contains 'Arrears', 'Cell X ' should not be blank in the following row(s): "]
[]
["Type","Y"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"="]
["As 'Type of payment' contains 'Arrears', 'Cell Y ' should not be blank in the following row(s): "]
[]
["Type","AA"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"="]
["As 'Type of payment' contains 'Arrears', 'Cell AA ' should not be blank in the following row(s): "]
[]
["Type","AC"]
[{"$f":"\"=Arrears\"","v":"=Arrears"},"="]
["As 'Type of payment' contains 'Arrears', 'Cell AC ' should not be blank in the following row(s): "]
[]
["paymentOption","L"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell L ' should be blank in the following row(s): "]
[]
["paymentOption","P"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell P ' should be blank in the following row(s): "]
[]
["paymentOption","Q"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cells Q ' should be blank in the following row(s): "]
[]
["paymentOption","S"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell S ' should be blank in the following row(s): "]
[]
["paymentOption","U"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell U ' should be blank in the following row(s): "]
[]
["paymentOption","V"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell V ' should be blank in the following row(s): "]
[]
["paymentOption","W"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell W ' should be blank in the following row(s): "]
[]
["paymentOption","X"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell X ' should be blank in the following row(s): "]
[]
["paymentOption","AA"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell AA ' should be blank in the following row(s): "]
[]
["paymentOption","M"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell M ' should be blank in the following row(s): "]
[]
["paymentOption","N"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell N ' should be blank in the following row(s): "]
[]
["paymentOption","R"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell R ' should be blank in the following row(s): "]
[]
["paymentOption","T"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell T ' should be blank in the following row(s): "]
[]
["paymentOption","Z"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell Z ' should be blank in the following row(s): "]
[]
["paymentOption","AB"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell AB ' should be blank in the following row(s): "]
[]
["paymentOption","Y"]
["=Specified Term Contract with Compensation (STC-COMP)","<>"]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell Y ' should be blank in the following row(s): "]
[]
["paymentOption","I"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell I ' should be blank in the following row(s): "]
[]
["paymentOption","J"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell J ' should be blank in the following row(s): "]
[]
["paymentOption","L"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell L ' should be blank in the following row(s): "]
[]
["paymentOption","P"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell P ' should be blank in the following row(s): "]
[]
["paymentOption","Q"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell Q ' should be blank in the following row(s): "]
[]
["paymentOption","S"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell S ' should be blank in the following row(s): "]
[]
["paymentOption","U"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell U ' should be blank in the following row(s): "]
[]
["paymentOption","V"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell V ' should be blank in the following row(s): "]
[]
["paymentOption","W"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell W ' should be blank in the following row(s): "]
[]
["paymentOption","X"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell X ' should be blank in the following row(s): "]
[]
["paymentOption","Y"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell Y ' should be blank in the following row(s): "]
[]
["paymentOption","AA"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell AA ' should be blank in the following row(s): "]
[]
["paymentOption","M"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell M ' should be blank in the following row(s): "]
[]
["paymentOption","N"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell N ' should be blank in the following row(s): "]
[]
["paymentOption","R"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell R ' should be blank in the following row(s): "]
[]
["paymentOption","T"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell T ' should be blank in the following row(s): "]
[]
["paymentOption","Z"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell Z ' should be blank in the following row(s): "]
[]
["paymentOption","AB"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell AB' should be blank in the following row(s): "]
[]
["Type","paymentOption","paymentOption","paymentOption"]
[{"$f":"\"=Lumpsum\"","v":"=Lumpsum"},"<>Specified Term Contract with Compensation (STC-COMP)","<>UnSpecified Term Contract with Compensation (USTC-COMP)","<>UnSpecified Term Contract with No Compensation (USTC-NOCOMP)"]
["As 'Type of payment' contains 'Lumpsum', 'Payment Option ' should either be 'Specified Term Contract with Compensation (STC-COMP)'  or 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)' in the following row(s): "]
[]
["Type","paymentOption","paymentOption"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>Transfer of Gratuity to Registered Pension Scheme","<>Gratuity Payment to Employee"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Payment Option ' should be 'Transfer of Gratuity to Registered Pension Scheme'  or 'Gratuity Payment to Employee' in the following row(s): "]
[]
["Type","O"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"="]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell O ' should not be blank in the following row(s): "]
[]
["Type","P"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"="]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell P ' should not be blank in the following row(s): "]
[]
["Type","Q"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"="]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell  Q ' should not be blank in the following row(s): "]
[]
["Type","S"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell S ' should be blank in the following row(s): "]
[]
["Type","U"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"="]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell U ' should not be blank in the following row(s): "]
[]
["Type","AC"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"="]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell AC ' should not be blank in the following row(s): "]
[]
["Type","I"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell I ' should be blank in the following row(s): "]
[]
["Type","J"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell J ' should be blank in the following row(s): "]
[]
["Type","K"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell K ' should be blank in the following row(s): "]
[]
["Type","L"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell L ' should be blank in the following row(s): "]
[]
["Type","V"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell V ' should be blank in the following row(s): "]
[]
["Type","W"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell W ' should be blank in the following row(s): "]
[]
["Type","X"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell X ' should be blank in the following row(s): "]
[]
["Type","Y"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell Y ' should be blank in the following row(s): "]
[]
["Type","AA"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell AA ' should be blank in the following row(s): "]
[]
["Type","M"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell M ' should be blank in the following row(s): "]
[]
["Type","N"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell N ' should be blank in the following row(s): "]
[]
["Type","R"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell R ' should be blank in the following row(s): "]
[]
["Type","T"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell T ' should be blank in the following row(s): "]
[]
["Type","Z"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell Z ' should be blank in the following row(s): "]
[]
["Type","AB"]
[{"$f":"\"=Gratuity/Severence\"","v":"=Gratuity/Severence"},"<>"]
["As 'Type of payment' contains 'Gratuity/Severence', 'Cell AB' should be blank in the following row(s): "]
[]
["paymentOption","I"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell I ' should be blank in the following row(s): "]
[]
["paymentOption","J"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell J ' should be blank in the following row(s): "]
[]
["paymentOption"," P"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell P ' should be blank in the following row(s): "]
[]
["paymentOption","Q"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell Q ' should be blank in the following row(s): "]
[]
["paymentOption","U"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell U ' should be blank in the following row(s): "]
[]
["paymentOption","V"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell V ' should be blank in the following row(s): "]
[]
["paymentOption","W"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell W ' should be blank in the following row(s): "]
[]
["paymentOption","X"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell X ' should be blank in the following row(s): "]
[]
["paymentOption","Y"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell Y ' should be blank in the following row(s): "]
[]
["paymentOption","AA"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell AA ' should be blank in the following row(s): "]
[]
["paymentOption","M"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell M ' should be blank in the following row(s): "]
[]
["paymentOption","N"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell N ' should be blank in the following row(s): "]
[]
["paymentOption","R"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cells R ' should be blank in the following row(s): "]
[]
["paymentOption","T"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell T ' should be blank in the following row(s): "]
[]
["paymentOption","Z"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell Z ' should be blank in the following row(s): "]
[]
["paymentOption","AB"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","<>"]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell AB ' should be blank in the following row(s): "]
[]
["paymentOption","K"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell K' should not be blank in the following row(s): "]
[]
["paymentOption","O"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', ' O  ' should not be blank in the following row(s): "]
[]
["paymentOption","AC"]
["=UnSpecified Term Contract with No Compensation (USTC-NOCOMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with No Compensation (USTC-NOCOMP)', 'Cell AC ' should not be blank in the following row(s): "]
[]
["paymentOption","K"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell K ' should not be blank in the following row(s): "]
[]
["paymentOption","L"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell L ' should not be blank in the following row(s): "]
[]
["paymentOption","O"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell O ' should not be blank in the following row(s): "]
[]
["paymentOption","S"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell S ' should not be blank in the following row(s): "]
[]
["paymentOption","AC"]
["=UnSpecified Term Contract with Compensation (USTC-COMP)","="]
["As 'Payment Option' contains 'UnSpecified Term Contract with Compensation (USTC-COMP)', 'Cell AC ' should not be blank in the following row(s): "]
[]
["paymentOption","I"]
["=Specified Term Contract with Compensation (STC-COMP)","="]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell I ' should not be blank in the following row(s): "]
[]
["paymentOption","J"]
["=Specified Term Contract with Compensation (STC-COMP)","="]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell J ' should not be blank in the following row(s): "]
[]
["paymentOption","K"]
["=Specified Term Contract with Compensation (STC-COMP)","="]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell K ' should not be blank in the following row(s): "]
[]
["paymentOption","O"]
["=Specified Term Contract with Compensation (STC-COMP)","="]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell O ' should not be blank in the following row(s): "]
[]
["paymentOption","AC"]
["=Specified Term Contract with Compensation (STC-COMP)","="]
["As 'Payment Option' contains 'Specified Term Contract with Compensation (STC-COMP)', 'Cell AC ' should not be blank in the following row(s): "]
[]
["Pin","Name","Res","EmpType","Pwd","PwdCert","Type","paymentOption","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC"]
{"$rows_empty":67}
["crit2",835,"A5:B7","D"]
["crit3",839,"A10:B11","E"]
["crit4",843,"A14:B15","F"]
["crit5",847,"A18:A19","O"]
["crit6",851,"A22:B23","S"]
["crit7",855,"A26:B27","U"]
["crit8",859,"A30:B31","W"]
["crit9",863,"A34:B35","S"]
["crit10",867,"A38:B39","U"]
["crit11",871,"A42:B43","W"]
["crit12",875,"A46:B47","U"]
["crit13",879,"A50:B51","W"]
["crit14",883,"A54:B55","S"]
["crit15",887,"A58:B59","U"]
["crit16",891,"A62:B63","W"]
["crit17",895,"A66:B67","S"]
["crit18",899,"A70:B71","S"]
["crit19",903,"A74:B75","U"]
["crit20",907,"A78:B79","W"]
["crit21",911,"A82:B83","V"]
["crit22",915,"A86:A87","X"]
["crit23",919,"A90:A91","Y"]
["crit24",923,"A94:A95","Z"]
["crit25",927,"A98:A99","AB"]
["crit26",931,"A102:A103","AE"]
["crit27",935,"A106:A107","AF"]
["crit28",939,"A110:A111","AG"]
["crit29",943,"A114:A115","AJ"]
["crit30",947,"A118:A119","AL"]
["crit31",951,"A122:A123","AM"]
["crit32",955,"A126:C127","AA"]
["crit33",959,"A130:C131","AC"]
["crit34",963,"A134:D135","AD"]
["crit35",967,"A138:C139","AH"]
["crit36",971,"A142:E143","T"]
["crit37",975,"A146:C147","AA"]
["crit38",979,"A150:C151","AC"]
["crit39",983,"A154:C155","AD"]
["crit40",987,"A158:C159","AH"]
["crit41",991,"A162:B163","AA"]
["crit42",995,"A166:B167","AC"]
["crit43",999,"A170:B171","AD"]
["crit44",1003,"A174:B175","AH"]
["crit45",1007,"A178:B179","AI"]
["crit46",1011,"A182:B183","AI"]
["crit47",1015,"A186:A187","P"]
["crit48",1019,"A190:A191","B"]
["crit49",1023,"A194:A195","AM"]
["crit50",1027,"A198:B199","AD"]
{"$rows_empty":17}
["Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month"]
["<>January","<>February","<>March","<>April","<>May","<>June","<>July","<>August","<>September","<>October","<>November","<>December"]
["Arrears for the Month' should contain value 'January' or 'February' or ...'December' in following row(s): "]
[]
["Year","Year"]
["<2000"]
[null,{"$f":"CONCATENATE(\">\",YEAR(TODAY()))","v":">2025"}]
["'Arrears Year' should contain value in range from 2000 to current financial year in following row(s): "]
[]
["Res","Res"]
["<>Resident","<>Non-Resident"]
["'Residential Status' should contain value 'Resident' or 'Non-Resident' in following row(s): "]
[]
["Type","Type"]
["<>Primary Employee","<>Secondary Employee"]
["'Type' should contain value 'Primary Employee' or 'Secondary Employee' in following row(s): "]
[]
["A"]
["<>"]
["'Total Cash Pay (A)' should be blank in following row(s): "]
[]
["E","Housing"]
["=",{"$f":"\"=Benefit not given\"","v":"=Benefit not given"}]
["As 'Type of Housing' contains 'Benefit not given', 'Global Income (Ksh) (E)' should contain value in following row(s): "]
[]
["Housing","Rent"]
[{"$f":"\"=Benefit not given\"","v":"=Benefit not given"},"<>"]
["As 'Type of Housing' contains 'Benefit not given', 'Rent of House/Market Value' should be blank in following row(s): "]
[]
["Housing","G"]
[{"$f":"\"=Benefit not given\"","v":"=Benefit not given"},"<>"]
["As 'Type of Housing' contains 'Benefit not given', 'Rent Recovered from Employee (G)' should be blank in following row(s): "]
[]
["E","Housing"]
["=",{"$f":"\"=House to Non full time service Director\"","v":"=House to Non full time service Director"}]
["As 'Type of Housing' contains 'House to Non full time service Director', 'Global Income (Ksh) (E)' should contain value in following row(s): "]
[]
["Housing","Rent"]
[{"$f":"\"=House to Non full time service Director\"","v":"=House to Non full time service Director"},"<>"]
["As 'Type of Housing' contains 'House to Non full time service Director', 'Rent of House/Market Value' should be blank in following row(s): "]
[]
["Housing","G"]
[{"$f":"\"=House to Non full time service Director\"","v":"=House to Non full time service Director"},"<>"]
["As 'Type of Housing' contains 'House to Non full time service Director', 'Rent Recovered from Employee (G)' should be blank in following row(s): "]
[]
["Housing","Rent"]
["=Employer's Owned House","="]
["As 'Type of Housing' contains 'Employer's Owned House', 'Rent of House/Market Value' should contain value in following row(s): "]
[]
["Housing","G"]
["=Employer's Owned House","="]
["As 'Type of Housing' contains 'Employer's Owned House', 'Rent Recovered from Employee (G)' should contain value in following row(s): "]
[]
["E","Housing"]
["<>","=Employer's Owned House"]
["As 'Type of Housing' contains 'Employer's Owned House', 'Global Income (Ksh) (E)' should be blank in following row(s): "]
[]
["Housing","Rent"]
["=Employer's Rented House","="]
["As 'Type of Housing' contains 'Employer's Rented House', 'Rent of House/Market Value' should contain value in following row(s): "]
[]
["Housing","G"]
["=Employer's Rented House","="]
["As 'Type of Housing' contains 'Employer's Rented House', 'Rent Recovered from Employee (G)' should contain value in following row(s): "]
[]
["E","Housing"]
["<>","=Employer's Rented House"]
["As 'Type of Housing' contains 'Employer's Rented House', 'Global Income (Ksh) (E)' should be blank in following row(s): "]
[]
["E","Housing"]
["<>",{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"}]
["As 'Type of Housing' contains 'Agriculture Farm', 'Global Income (Ksh) (E)' should be blank in following row(s): "]
[]
["Housing","Rent"]
[{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"},"<>"]
["As 'Type of Housing' contains 'Agriculture Farm', 'Rent of House/Market Value' should be blank in following row(s): "]
[]
["Housing","G"]
[{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"},"<>"]
["As 'Type of Housing' contains 'Agriculture Farm', 'Rent Recovered from Employee (G)' should be blank in following row(s): "]
[]
["Housing","F "]
[{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"},"<>"]
["As 'Type of Housing' contains 'Agriculture Farm', 'Computed Rent of House (F)' should be blank in following row(s): "]
[]
["H"]
["<>"]
["'Value of Housing (Ksh) (H) = (F - G)' should be blank in following row(s): "]
[]
["I"]
["<>"]
["'Total Gross Pay (Ksh) (I) = (A+D+E+H)' sould be blank in following row(s): "]
[]
["J"]
["<>"]
["'30% of Cash Pay (J) = (A)*30%' should be blank in following row(s): "]
[]
["L"]
["<>"]
["'Permissible Limit (L)' should be blank in following row(s): "]
[]
["O"]
["<>"]
["'Amount of Benefit (O)' should be blank in following row(s): "]
[]
["P"]
["<>"]
["'Taxable Pay (Ksh) (P) = (I - O)' should be blank in following row(s): "]
[]
["Q"]
["<>"]
["'Tax Payable (Ksh) (Q) = (P)*Slab Rate' should be blank in following row(s): "]
[]
["T"]
["<>"]
["'PAYE Tax (Ksh) (T) = (Q - R - S)' should be blank in following row(s): "]
[]
["V"]
["<>"]
["'Final PAYE Tax (Ksh) (V) = (T - U)' should be blank in following row(s): "]
[]
["Self"]
["="]
["Self Assessed PAYE Tax (Ksh)' should contain value in following row(s): "]
[]
["Res","Type","K"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Actual Contribution (K)' should contain value in following row(s): "]
[]
["Res","Type","M"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Mortgage Interest (M)' should contain value in following row(s): "]
[]
["Res","Type","Year","N"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<2021","="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should contain value in following row(s): "]
[]
["Res","Type","R"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Monthly Personal Relief (Ksh) (R)' should contain value in following row(s): "]
[]
["Housing","Housing","Housing","Housing","Housing"]
["<>Benefit not given","<>House to Non full time service Director","<>Employer's Owned House","<>Employer's Rented House","<>Agriculture Farm"]
["'Type of Housing' should contain value 'Benefit not given' or 'House to Non full time service Director' or 'Employer's Owned House' or 'Employer's Rented House' or 'Agriculture Farm' in following row(s): "]
[]
["Res","Type","K"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<>"]
["As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Actual Contribution (K)' should be blank in following row(s): "]
[]
["Res","Type","M"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Mortgage Interest (M)' should contain value in following row(s): "]
[]
["Res","Type","N"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<>"]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): "]
[]
["Res","Type","R"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<>"]
["As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Monthly Personal Relief (Ksh) (R)' should be blank in following row(s): "]
[]
["Type","K"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Actual Contribution (K)' should be blank in following row(s): "]
[]
["Type","M"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Mortgage Interest (M)' should be blank in following row(s): "]
[]
["Type","N"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): "]
[]
["Type","R"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Monthly Personal Relief (Ksh) (R)' should be blank in following row(s): "]
[]
["Res","S"]
[{"$f":"\"=Resident\"","v":"=Resident"},"="]
["As 'Residential Status' contains 'Resident' , 'Amount of Insurance Relief (S)' should contain value in following row(s): "]
[]
["Res","S"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},"<>"]
["As 'Residential Status' contains 'Non-Resident' , 'Amount of Insurance Relief (S)' should be blank in following row(s): "]
[]
["Car"]
["="]
["Value of Car Benefit' should contain value in following row(s): "]
[]
["Name"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Name of Employee' should be of length less than or equal to 50 Characters in following row(s):"]
[]
["Self"]
["<0"]
["Self Assessed PAYE Tax (Ksh)' should contain positive number in following row(s): "]
[]
["Year","N"]
[">=2021","<>"]
["As 'Year' is greater than or equal to 2021, 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): "]
[]
["PIN of Employee","Name","Month","Year","Res","Type","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","A","Car","C","D","E","Housing","Rent","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","Self"]
{"$rows_empty":55}
["Section H"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1154,"A1:L2","C"]
["crit2",1159,"A5:B7","D"]
["crit3",1163,"A10:B11","E"]
["crit4",1167,"A14:B15","F"]
["crit5",1171,"A18:A19","P"]
["crit6",1175,"A22:B23","T"]
["crit7",1179,"A26:B27","V"]
["crit8",1183,"A30:B31","X"]
["crit9",1187,"A34:B35","T"]
["crit10",1191,"A38:B39","V"]
["crit11",1195,"A42:B43","X"]
["crit12",1199,"A46:B47","V"]
["crit13",1203,"A50:B51","X"]
["crit14",1207,"A54:B55","T"]
["crit15",1211,"A58:B59","V"]
["crit16",1215,"A62:B63","X"]
["crit17",1219,"A66:B67","T"]
["crit18",1223,"A70:B71","T"]
["crit19",1227,"A74:A75","G"]
["crit20",1231,"A78:B79","V"]
["crit21",1235,"A82:B83","X"]
["crit22",1239,"A86:B87","W"]
["crit23",1243,"A90:A91","Y"]
["crit24",1247,"A94:A95","Y"]
["crit25",1251,"A98:A99","AA"]
["crit26",1255,"A102:A103","AC"]
["crit27",1259,"A106:A107","AF"]
["crit28",1263,"A110:A111","AG"]
["crit29",1267,"A114:A115","AH"]
["crit30",1271,"A118:A119","AI"]
["crit31",1275,"A122:A123","AL"]
["crit32",1279,"A126:A127","AN"]
["crit33",1283,"A130:A131","AO"]
["crit34",1287,"A134:C135","AB"]
["crit35",1291,"A138:C139","AD"]
["crit36",1295,"A142:D143","AE"]
["crit37",1299,"A146:C147","AJ"]
["crit38",1303,"A150:E151","U"]
["crit39",1307,"A154:C155","AB"]
["crit40",1311,"A158:C159","AD"]
["crit41",1315,"A162:C163","AE"]
["crit42",1319,"A166:C167","AJ"]
["crit43",1323,"A170:B171","AB"]
["crit44",1327,"A174:B175","AD"]
["crit45",1331,"A178:B179","AE"]
["crit46",1335,"A182:B183","AJ"]
["crit47",1339,"A186:B187","AK"]
["crit48",1343,"A190:B191","AK"]
["crit49",1347,"A194:A195","Q"]
["crit50",1351,"A198:A199","B"]
["crit51",1355,"A202:A203","G"]
["crit52",1359,"A206:A207","AO"]
["crit53",1363,"A210:B211","AE"]
{"$rows_empty":12}
["Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month"]
["<>January","<>February","<>March","<>April","<>May","<>June","<>July","<>August","<>September","<>October","<>November","<>December"]
["Arrears for the Month' should contain value 'January' or 'February' or ...'December' in following row(s): "]
[]
["Year","Year"]
["<2000"]
[null,{"$f":"CONCATENATE(\">\",YEAR(TODAY()))","v":">2025"}]
["Arrears Year' should contain value in range from 2000 to current financial year in following row(s): "]
[]
["Res","Res"]
["<>Resident","<>Non-Resident"]
["Residential Status' should contain value 'Resident' or 'Non-Resident' in following row(s): "]
[]
["Type","Type"]
["<>Primary Employee","<>Secondary Employee"]
["'Type' should contain value 'Primary Employee' or 'Secondary Employee' in following row(s): "]
[]
["A"]
["<>"]
["'Total Cash Pay (A)' should be blank in following row(s): "]
[]
["E","Housing"]
["=",{"$f":"\"=Benefit not given\"","v":"=Benefit not given"}]
["As 'Type of Housing' contains 'Benefit not given', 'Global Income (Ksh) (E)' should contain value in following row(s): "]
[]
["Housing","Rent"]
[{"$f":"\"=Benefit not given\"","v":"=Benefit not given"},"<>"]
["As 'Type of Housing' contains 'Benefit not given', 'Rent of House/Market Value' should be blank in following row(s): "]
[]
["Housing","G"]
[{"$f":"\"=Benefit not given\"","v":"=Benefit not given"},"<>"]
["As 'Type of Housing' contains 'Benefit not given', 'Rent Recovered from Employee (G)' should be blank in following row(s): "]
[]
["E","Housing"]
["=",{"$f":"\"=House to Non full time service Director\"","v":"=House to Non full time service Director"}]
["As 'Type of Housing' contains 'House to Non full time service Director', 'Global Income (Ksh) (E)' should contain value in following row(s): "]
[]
["Housing","Rent"]
[{"$f":"\"=House to Non full time service Director\"","v":"=House to Non full time service Director"},"<>"]
["As 'Type of Housing' contains 'House to Non full time service Director', 'Rent of House/Market Value' should be blank in following row(s): "]
[]
["Housing","G"]
[{"$f":"\"=House to Non full time service Director\"","v":"=House to Non full time service Director"},"<>"]
["As 'Type of Housing' contains 'House to Non full time service Director', 'Rent Recovered from Employee (G)' should be blank in following row(s): "]
[]
["Housing","Rent"]
["=Employer's Owned House","="]
["As 'Type of Housing' contains 'Employer's Owned House', 'Rent of House/Market Value' should contain value in following row(s): "]
[]
["Housing","G"]
["=Employer's Owned House","="]
["As 'Type of Housing' contains 'Employer's Owned House', 'Rent Recovered from Employee (G)' should contain value in following row(s): "]
[]
["E","Housing"]
["<>","=Employer's Owned House"]
["As 'Type of Housing' contains 'Employer's Owned House', 'Global Income (Ksh) (E)' should be blank in following row(s): "]
[]
["Housing","Rent"]
["=Employer's Rented House","="]
["As 'Type of Housing' contains 'Employer's Rented House', 'Rent of House/Market Value' should contain value in following row(s): "]
[]
["Housing","G"]
["=Employer's Rented House","="]
["As 'Type of Housing' contains 'Employer's Rented House', 'Rent Recovered from Employee (G)' should contain value in following row(s): "]
[]
["E","Housing"]
["<>","=Employer's Rented House"]
["As 'Type of Housing' contains 'Employer's Rented House', 'Global Income (Ksh) (E)' should be blank in following row(s): "]
[]
["E","Housing"]
["<>",{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"}]
["As 'Type of Housing' contains 'Agriculture Farm', 'Global Income (Ksh) (E)' should be blank in following row(s): "]
[]
["ExemptCeriNo"]
["="]
["'Exemption Certificate Number' should contain value in following row(s): "]
[]
["Housing","Rent"]
[{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"},"<>"]
["As 'Type of Housing' contains 'Agriculture Farm', 'Rent of House/Market Value' should be blank in following row(s): "]
[]
["Housing","G"]
[{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"},"<>"]
["As 'Type of Housing' contains 'Agriculture Farm', 'Rent Recovered from Employee (G)' should be blank in following row(s): "]
[]
["Housing","F "]
[{"$f":"\"=Agriculture Farm\"","v":"=Agriculture Farm"},"<>"]
["As 'Type of Housing' contains 'Agriculture Farm', 'Computed Rent of House (F)' should be blank in following row(s): "]
[]
["H"]
["<>"]
["'Value of Housing (Ksh) (H) = (F - G)' should be blank in following row(s): "]
[]
["I"]
["<>"]
["'Total Gross Pay (Ksh) (I) = (A+D+E+H)' sould be blank in following row(s): "]
[]
["J"]
["<>"]
["'30% of Cash Pay (J) = (A)*30%' should be blank in following row(s): "]
[]
["L"]
["<>"]
["'Permissible Limit (L)' should be blank in following row(s): "]
[]
["O"]
["<>"]
["'Amount of Benefit (O)' should be blank in following row(s): "]
[]
["P"]
["<>"]
["'Exemption for Persons with Disability (Ksh) (P)' should be blank in following row(s): "]
[]
["Q"]
["<>"]
["'Taxable Pay (Ksh) (Q) = (I - O -P)' should be blank in following row(s): "]
[]
["R"]
["<>"]
["'Tax Payable (Ksh) (R) = (Q)*Slab Rate' should be blank in following row(s): "]
[]
["U"]
["<>"]
["'PAYE Tax (Ksh) (U) = (R-S-T)' should be blank in following row(s): "]
[]
["W"]
["<>"]
["'Final PAYE Tax (Ksh) (W) = (U - V)' should be blank in following row(s): "]
[]
["Self"]
["="]
["Self Assessed PAYE Tax (Ksh)' should contain value in following row(s): "]
[]
["Res","Type","K"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Actual Contribution (K)' should contain value in following row(s): "]
[]
["Res","Type","M"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Mortgage Interest (M)' should contain value in following row(s): "]
[]
["Res","Type","Year","N"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<2021","="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should contain value in following row(s): "]
[]
["Res","Type","S"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Monthly Personal Relief (Ksh) (S)' should contain value in following row(s): "]
[]
["Housing","Housing","Housing","Housing","Housing"]
["<>Benefit not given","<>House to Non full time service Director","<>Employer's Owned House","<>Employer's Rented House","<>Agriculture Farm"]
["'Type of Housing' should contain value 'Benefit not given' or 'House to Non full time service Director' or 'Employer's Owned House' or 'Employer's Rented House' or 'Agriculture Farm' in following row(s): "]
[]
["Res","Type","K"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<>"]
["As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Actual Contribution (K)' should be blank in following row(s): "]
[]
["Res","Type","M"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"="]
["As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Mortgage Interest (M)' should contain value in following row(s): "]
[]
["Res","Type","N"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<>"]
["As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): "]
[]
["Res","Type","S"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},"<>"]
["As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Monthly Personal Relief (Ksh) (S)' should be blank in following row(s): "]
[]
["Type","K"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Actual Contribution (K)' should be blank in following row(s): "]
[]
["Type","M"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Mortgage Interest (M)' should be blank in following row(s): "]
[]
["Type","N"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): "]
[]
["Type","S"]
[{"$f":"\"=Secondary Employee\"","v":"=Secondary Employee"},"<>"]
["As 'Type' contains 'Secondary Employee', 'Monthly Personal Relief (Ksh) (S)' should be blank in following row(s): "]
[]
["Res","T"]
[{"$f":"\"=Resident\"","v":"=Resident"},"="]
["As 'Residential Status' contains 'Resident' , 'Amount of Insurance Relief (T)' should contain value in following row(s): "]
[]
["Res","T"]
[{"$f":"\"=Non-Resident\"","v":"=Non-Resident"},"<>"]
["As 'Residential Status' contains 'Non-Resident' , 'Amount of Insurance Relief (T)' should be blank in following row(s): "]
[]
["Car"]
["="]
["Value of Car Benefit' should contain value in following row(s): "]
[]
["Name"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Name of Employee' should be of length less than or equal to 50 Characters in following row(s):"]
[]
["ExemptCeriNo"]
[{"$f":"\"=?????????????????????*\"","v":"=?????????????????????*"}]
["'Exemption Certificate Number' should be of length less than or equal to 20 characters in following row(s): "]
[]
["Self"]
["<0"]
["Self Assessed PAYE Tax (Ksh)' should contain positive number in following row(s): "]
[]
["Year","N"]
[">=2021","<>"]
["As 'Year' is greater than or equal to 2021, 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):"]
[]
["PIN of Employee","Name","Month","Year","Res","Type","ExemptCeriNo","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","A","Car","C","D","E","Housing","Rent","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","Self"]
{"$rows_empty":18}
["For Section J"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1401,"A1:A2","G"]
["crit2",1405,"A5:A6","H"]
["crit3",1409,"A9:A10","E"]
["crit4",1414,"A13:B15","F"]
["crit5",1419,"A18:B20","H"]
["crit6",1423,"A23:A24","B"]
["crit7",1427,"A27:A28","C"]
[]
[]
[]
[]
[]
[]
["C"]
["<>"]
["'Interest on Loan (Ksh) (C)=(A)*(B)' should be blank in following row(s): "]
[]
["D"]
["="]
["'Prescribed Market Interest Rate (%) (D)' should be blank in following row(s): "]
[]
["A"]
["="]
["'Amount of Loan Outstanding (Ksh) (A)' should be blank in following row(s): "]
[]
["B","B"]
["<0"]
[null,">100"]
["'Rate of Interest on Loan (%) (B)' should contain value in range from 0 to 100 in following row(s): "]
[]
["D","D"]
["<0"]
[null,">100"]
["'Prescribed Market Interest Rate (%) (D)' should contain value in range from 0 to 100 in following row(s): "]
[]
["Name"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Name of Employee' should be of length less than or equal to 50 Characters in following row(s):"]
[]
["LoanAccNum"]
[{"$f":"\"=?????????????????????*\"","v":"=?????????????????????*"}]
["'Loan Account Number' should be of length less than or equal to 20 characters in following row(s): "]
[]
["PIN of Employee","Name","LoanAccNum","Loan Amount (Ksh)","Amount of Loan Outstanding (Ksh) (A)","B","C","D"]
{"$rows_empty":61}
["For Section L"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1520,"A1:A2","A"]
["crit2",1524,"A5:A6","B"]
["crit3",1528,"A9:A10","C"]
["crit4",1532,"A13:A14","D"]
["crit5",1536,"A17:B18","E"]
["crit6",1540,"A21:F22","F"]
["crit7",1544,"A25:A26","G"]
["crit8",1548,"A29:B30","H"]
["crit9",1552,"A33:B34","H"]
["crit10",1556,"A37:D38","H"]
["crit11",1560,"A41:A42","I"]
["crit12",1564,"A45:A46","J"]
["crit13",1568,"A49:B50","K"]
["crit14",1572,"A53:B54","K"]
["crit15",1576,"A57:A58","L"]
{"$rows_empty":10}
["PayrollNum"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Payroll Number' should contain value of length 50 in following row(s): "]
[]
["PayerName"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Payer Name' should contain value of length upto 50 in following row(s): "]
[]
["IDNo"]
[{"$f":"\"=???????????????????????????????*\"","v":"=???????????????????????????????*"}]
["'Identification Number' should contain value of length upto 30 in following row(s): "]
[]
["PIN"]
[{"$f":"\"=????????????*\"","v":"=????????????*"}]
["'KRA PIN' should contain 11 digit value in following row(s): "]
[]
["NssfNo","NssfNo"]
["=","<9"]
["'NSSF Number' should contain value in following row(s): "]
[]
["ConType","ConType","ConType","ConType","ConType","ConType"]
["<>101-Tier 1","<>102-Tier 2","<>103-Tier 3","<>104-Daily Rate","<>105-Provident Fund","<>200-Opted Out"]
["'Contribution Type' contains invalid value in following row(s):"]
[]
["Income"]
["="]
["'Income (Ksh)' should contain value in following row(s):"]
[]
["ConType","IncType"]
["=200-Opted Out","<>Opted out"]
["'As Contribution Type contains '200-Opted Out', Income Type should be 'Opted Out' in following row(s):"]
[]
["ConType","IncType"]
["=104-Daily Rate","<>Daily Rate"]
["As Contribution Type contains '104-Daily Rate', Income type should contain 'Daily Rate' in following row(s):"]
[]
["ConType","ConType","IncType","IncType"]
["<>104-Daily Rate","<>200-Opted Out","<>1-Regular Salary","<>2-Arrears"]
["As Contribution Type contains value other than 104 and 200, Income Type should contain either '1-Regular Salary' or '2-Arrears' in following row(s): "]
[]
["MemCon"]
["="]
["'Member Contribution (A) (Ksh)' should contain value in following row(s): "]
[]
["EmpCon"]
["="]
["'Employer Contribution (B) (Ksh)' should contain value in following row(s): "]
[]
["ConType","WorkDy"]
["=104-Daily Rate","="]
["As Contribution type is '104-Daily Rate', Number of Working Days should contain value in following row(s): "]
[]
["ConType","WorkDy"]
["<>104-Daily Rate","<>"]
["As Contribution type is other than '104-Daily Rate', Number of Working Days should be blank in following row(s): "]
[]
["TotCon"]
["<>"]
["'Total Contribution (A+B) (Ksh)' should be blank in following row(s): "]
[]
["PayrollNum","PayerName","IDNo","PIN","NssfNo","ConType","Income","IncType","MemCon","EmpCon","WorkDy","TotCon"]
{"$rows_empty":31}
["For Section M"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1631,"A1:A2","A"]
["crit2",1635,"A5:A6","B"]
["crit3",1639,"A9:A10","C"]
["crit4",1643,"A13:A14","D"]
["crit5",1647,"A17:A18","E"]
{"$rows_empty":12}
["MemberNumber"]
[{"$f":"\"=<>||=\"","v":"=<>||="}]
[]
[]
["MemberName"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Member Name' should contain value of length upto 50 in following row(s): "]
[]
["KRAPIN"]
[{"$f":"\"<>???????????\"","v":"<>???????????"}]
["'KRA PIN' should contain 11 digit value in following row(s): "]
[]
["GrossSalary"]
["="]
["'Gross Salary (Ksh)' should contain value in following row(s):"]
[]
["BasicSalary"]
["<>"]
["'Basic Salary (Ksh)' should be blank in the following row(s):"]
[]
["MemberNumber","MemberName","KRAPIN","GrossSalary","BasicSalary"]
{"$rows_empty":31}
["For Section L1"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1701,"A1:A2","A"]
["crit2",1705,"A5:A6","B"]
["crit3",1709,"A9:A10","C"]
["crit4",1713,"A13:A14","D"]
["crit5",1717,"A17:A18","E"]
{"$rows_empty":11}
["NhifNo"]
["="]
["'NHIF Number' should contain value in following row(s): "]
[]
["PIN"]
[{"$f":"\"=????????????*\"","v":"=????????????*"}]
["'KRA PIN' should contain 11 digit value in following row(s): "]
[]
["IDNo"]
[{"$f":"\"=???????????????????????????????*\"","v":"=???????????????????????????????*"}]
["'Identification Number' should contain value of length upto 30 in following row(s): "]
[]
["PayerName"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Payer Name' should contain value of length upto 50 in following row(s): "]
[]
["Income"]
["="]
["'Income (Ksh)' should contain value in following row(s):"]
[]
[]
[]
[]
[]
["NhifNo","PIN","IDNo","PayerName","Income"]
{"$rows_empty":9}
["For Section M1"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1490,"A1:A2","A"]
["crit2",1494,"A5:A6","B"]
["crit3",1498,"A9:A10","C"]
["crit4",1502,"A13:A14","D"]
{"$rows_empty":9}
["NITA Employee Number"]
[{"$f":"\"=?????????????????????*\"","v":"=?????????????????????*"}]
["'NITA Employee Number' should contain value of length 20 in following row(s): "]
[]
["NITA Employee Name"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'NITA Employee Name' should contain value of length upto 50 in following row(s): "]
[]
["KRAPIN"]
[{"$f":"\"<>???????????\"","v":"<>???????????"}]
["'KRA PIN' should contain 11 digit value in following row(s): "]
[]
["Standard NITA Deduction"]
["="]
["'Standard NITA Deduction (Ksh)' should contain value in following row(s):"]
[]
["NITA Employee Number","NITA Employee Name","KRAPIN","Standard NITA Deduction"]

{"sheet":"E_Tax_Due","index":11,"n_rows":14,"n_cols":3,"rows_kept":14,"merged":[[0,0,0,2]]}
["Section E : Calculation of Tax Due"]
["Sr. No.","Description","Amount (Ksh)"]
[1,"Total Employees (Total records B_Employees_Dtls)",{"$f":"ROUND(ROWS(SalDedEmpPIN)-COUNTBLANK(SalDedEmpPIN),2)","v":0}]
[2,"PAYE Tax deducted from the Employee(s) (Total of \"Self Assessed PAYE Tax\" from B_Employees_Dtls)",{"$f":"ROUND(DtlsSalPdBftsSelfPayTaxListTO,2)","v":{"v":0,"d":"0.00"}}]
[3,"PAYE Tax on Lump Sum/Gratuity/Arrears Payment (Total  \"Amount of PAYE Payable\" from C_Lump_Sum_Payments_Dtls)",{"$f":"ROUND(TaxPdOnLumpSumPdAftrTrmtnListTO,2)","v":{"v":0,"d":"0.00"}}]
[4,"Fringe Benefit Tax (Total of \"Amount of Fringe Benefit Tax\" from D_FBT_Dtls)",{"$f":"ROUND(FringeBenfTaxCalcListTO,2)","v":{"v":0,"d":"0.00"}}]
[5,"PAYE Tax deducted from the Employee(s) Without PIN"]
[6,"Total PAYE Tax Payable (2+3+4+5)",{"$f":"ROUND(SUM(ClcTaxDue.EmpTO,ClcTaxDue.LumpSumTO,ClcTaxDue.FringeBenfTO,ClcTaxDue.TaxDedEmpWithoutPin),2)","v":{"v":0,"d":"0.00"}}]
[7,"Total Housing Levy Contribution (From B_Employees_Dtls)",0]
[8,"Total NITA Levy Contributing Members (From B_Employees_Dtls)",0]
[9,"Total NITA Levy Contribution (8. No. Of Members)*50)",{"v":0,"d":"0.00"}]
[10,"Total Payable (6+7+9)",{"$f":"ROUND(SUM(ClcTaxDue.TotTaxPybl,ClcTaxDue.totalHousingContribution,ClcTaxDue.totalNITAContribution),2)","v":{"v":0,"d":"0.00"}}]
[]
[null,"RetInf"]

{"sheet":"Sheet1","index":12,"n_rows":11,"n_cols":1,"rows_kept":11,"hidden":true}
[]
[]
[]
["9667e8ea35c459808d045557d91f3fa5a1ee032f776f9d4d87caaf844c97043b"]
["e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"]
[]
[]
[]
[]
["9667e8ea35c459808d045557d91f3fa5a1ee032f776f9d4d87caaf844c97043b"]
["e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"]

{"sheet":"Amendment","index":13,"n_rows":2,"n_cols":1,"rows_kept":2,"hidden":true}
[]
[""]