{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Read Me","Errors","ImportCsv","Validations","ValidationList","Macros_Disabled","A_Basic_Info","B_Employees_Dtls","C_Disabled_Employees_Dtls","D_Computation_of_Car_Benefit","Data","E_Computation_of_Insu_Relief","F_Lump_Sum_Payments_Dtls","G_Arrears_Dtls_E","H_Arrears_Dtls_DE","I_Gratuity_Dtls","J_FBT_Dtls","K_PAYE_Payment_Credits","M_Affordable Housing Levy_Dtls","M1_NITA_Levy_Dtls","N_Tax_Due","Sheet1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":186,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"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,"cut":false,"hidden":true,"merged":[]}
["Sr. No.","Section Name","Field","Error Description","Reference Cell"]

{"sheet":"ImportCsv","index":2,"n_rows":1505,"n_cols":41,"rows_kept":1505,"cut":false,"hidden":true,"merged":[]}
["For Section B"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",76,"A1:B2","C"]
["crit2",80,"A5:B6","D"]
["crit3",84,"A9:A10","M"]
["crit4",88,"A13:A14","P"]
["crit5",92,"A17:A18","T"]
["crit6",96,"A21:A22","V"]
["crit7",100,"A25:A26","W"]
["crit8",104,"A29:A30","X"]
["crit9",108,"A33:A34","Z"]
["crit10",112,"A37:A38","AC"]
["crit11",116,"A41:A42","AD"]
["crit12",120,"A45:A46","AE"]
["crit13",124,"A49:A50","AG"]
["crit14",128,"A53:A54","AI"]
["crit15",132,"A57:B58","Q"]
["crit16",136,"A61:B62","S"]
["crit17",140,"A65:B66","U"]
["crit18",144,"A69:B70","Q"]
["crit19",148,"A73:B74","S"]
["crit20",152,"A77:B78","U"]
["crit21",156,"A81:B82","S"]
["crit22",160,"A85:B86","U"]
["crit23",164,"A89:B90","Q"]
["crit24",168,"A93:B94","S"]
["crit25",172,"A97:B98","U"]
["crit26",176,"A101:B102","Q"]
["crit27",180,"A105:B106","Q"]
["crit28",184,"A109:B110","S"]
["crit29",188,"A113:B114","U"]
["crit30",192,"A117:C118","Y"]
["crit31",196,"A121:C122","AA"]
["crit32",200,"A125:C126","AB"]
["crit33",204,"A129:C130","AF"]
["crit34",208,"A133:E134","R"]
["crit35",212,"A137:C138","Y"]
["crit36",216,"A141:C142","AA"]
["crit37",220,"A145:C146","AB"]
["crit38",224,"A149:C150","AF"]
["crit39",228,"A153:B154","Y"]
["crit40",232,"A157:B158","AA"]
["crit41",236,"A161:B162","AB"]
["crit42",240,"A165:B166","AF"]
["crit43",244,"A169:B170","AG"]
["crit44",248,"A173:B174","AG"]
["crit45",252,"A177:A178","N"]
["crit46",256,"A181:A182","B"]
["crit47",260,"A185:A186","AI"]
["crit48",264,"A189:A190","AB"]
["crit49",268,"A193:A194","AB"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 of Employee' should contain value 'Primary Employee' or 'Secondary Employee' in following row(s): "]
[]
["A"]
["<>"]
["'Total Cash Pay (A)' should be blank in following row(s): "]
[]
["D"]
["<>"]
["'Total Non Cash Pay (D)=(B + C) (C if greater than 3,000)' should be blank in following row(s): "]
[]
["F"]
["<>"]
["'Computed Rent of House (F)' should be blank in following row(s):  "]
[]
["H"]
["<>"]
["'Net Value of Housing (Ksh) (H) = (F - G)' should be blank in following row(s): "]
[]
["I"]
["<>"]
["'Total Gross Pay (Ksh) (I) = (A + D + E + H))' should be blank in following row(s): "]
[]
["J"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"'SHIF (J)' should contain value in the following row(s): \",\"'30% of Cash Pay (J) = (A)*30%' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["L"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"'PRMF (L)' should contain value in the following row(s): \",\"'Permissible Limit (L)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["O"]
["<>"]
["'Amount of Benefit (O) = (Lower of J,K,L + M or N which ever is higher)' 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): "]
[]
["Self "]
["="]
["'Self Assessed PAYE Tax (Ksh)' should contain value in following row(s): "]
[]
["E",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
["=",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Benefit not given\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Benefit Not Given', 'Global Income (E)'  should contain value in the following row(s): \"),\"\")","v":""}]
[]
["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",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
["=",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=House to Non full time service Director\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'House to Non full time service Director', 'Global Income (E)'  should contain value in the following row(s):  \"),\"\")","v":""}]
[]
["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",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Employer's Owned House\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Employer's Owned House', 'Global Income (E)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["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",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Employer's Rented House\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Employer's Rented House', 'Global Income (E)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["E",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Agriculture Farm\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Agriculture Farm', 'Global Income (E)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["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): "]
[]
["Res","Type","K"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"Primary Employee\"","v":"Primary Employee"},"="]
["As 'Residential Status' contains 'Resident', '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","N"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"=\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"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): \",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):\")),\"\")","v":""}]
[]
["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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"=\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should contain value in following row(s): \",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):\")),\"\")","v":""}]
[]
["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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Type' contains 'Secondary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Type' contains 'Secondary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): \"),\"\")","v":""}]
[]
["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 be a positive number in following row(s): "]
[]
["N"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(AND(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)<\"12\")),\">9000\",IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"\"),\"\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(AND(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)<\"12\")),\"Affordable Housing Relief cannot be greater than Ksh, 9,000 in the following row(s):\",IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Affordable Housing levy cannot be blank in the following row(s):\",\"\"),\"\")),\"\")","v":""}]
[]
["N"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"<0\",\"\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Affordable Housing Relief/Levy should be a positive number in the following row(s): \",\"\"),\"\")","v":""}]
[]
["Pin","Name","Res","Type","Basic","HousingAllow","Transport","Leave","ot","Director","lumpsum","OthrAllow","A","Car","C","D","E","Housing","Rent","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","Self"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For Section C"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",370,"A1:B2","C"]
["crit2",374,"A5:B6","D"]
["crit3",378,"A9:A10","N"]
["crit4",382,"A13:A14","Q"]
["crit5",386,"A17:A18","W"]
["crit6",390,"A21:A22","X"]
["crit7",394,"A25:A26","Y"]
["crit8",398,"A29:A30","AA"]
["crit9",402,"A33:A34","AD"]
["crit10",404,"A37:A38","AE"]
["crit11",410,"A41:A42","AF"]
["crit12",414,"A45:A46","AG"]
["crit13",418,"A49:A50","AJ"]
["crit14",422,"A53:A54","AI"]
["crit15",426,"A57:B58","AK"]
["crit16",430,"A61:B62","T"]
["crit17",434,"A65:B66","V"]
["crit18",438,"A69:B70","R"]
["crit19",442,"A73:B74","T"]
["crit20",446,"A77:B78","V"]
["crit21",450,"A81:B82","T"]
["crit22",454,"A85:B86","V"]
["crit23",458,"A89:B90","R"]
["crit24",462,"A93:B94","T"]
["crit25",466,"A97:B98","V"]
["crit26",470,"A101:B102","R"]
["crit27",474,"A105:B106","R"]
["crit28",478,"A109:B110","T"]
["crit29",482,"A113:B114","U"]
["crit30",486,"A117:B118","V"]
["crit32",490,"A121:A122","F"]
["crit33",494,"A125:C126","Z"]
["crit34",498,"A129:C130","AB"]
["crit35",502,"A133:C134","AC"]
["crit36",506,"A137:C138","AH"]
["crit37",510,"A141:E142","S"]
["crit38",514,"A145:C146","Z"]
["crit39",518,"A149:C150","AB"]
["crit40",522,"A153:C154","AC"]
["crit41",526,"A157:C158","AH"]
["crit42",530,"A161:B162","Z"]
["crit43",534,"A165:B166","AB"]
["crit44",538,"A169:B170","AC"]
["crit45",542,"A173:B174","AH"]
["crit46",546,"A177:B178","AI"]
["crit47",550,"A181:B182","AI"]
["crit48",554,"A185:A186","O"]
["crit49",558,"A189:A190","B"]
["crit50",562,"A193:A194","E"]
["crit51",566,"A197:A198","AK"]
["crit52",570,"A201:A202","AC"]
["crit53",574,"A205:A206","AC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 of Employee' should contain value 'Primary Employee' or 'Secondary Employee' in following row(s): "]
[]
["A"]
["<>"]
["'Total Cash Pay (A)' should be blank in following row(s): "]
[]
["D"]
["<>"]
["'Total Non Cash Pay (D)=(B + C) (C if greater than 3,000)' should be blank in following row(s): "]
[]
["H"]
["<>"]
["'Net Value of Housing (Ksh) (H) = (F - G)' should be blank in following row(s): "]
[]
["I"]
["<>"]
["'Total Gross Pay (Ksh) (I) = (A + D + E + H))' should be blank in following row(s): "]
[]
["J"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"'SHIF (J)' should contain value in the following row(s): \",\"'30% of Cash Pay (J) = (A)*30%' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["L"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"'PRMF (L)' should contain value in the following row(s): \",\"'Permissible Limit (L)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["O"]
["<>"]
["'Amount of Benefit (O) = (Lower of J,K,L + M or N which ever is higher)' 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)' 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): "]
[]
["Self "]
["="]
["Self Assessed PAYE Tax (Ksh)' should contain value in following row(s): "]
[]
["E",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
["=",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Benefit not given\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Benefit Not Given', 'Global Income (E)'  should contain value in following row(s): \"),\"\")","v":""}]
[]
["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",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
["=",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=House to Non full time service Director\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'House to Non full time service Director', 'Global Income (E)'  should contain value in following row(s):  \"),\"\")","v":""}]
[]
["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",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Employer's Owned House\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Employer's Owned House', 'Global Income (E)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["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",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Employer's Rented House\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Employer's Rented House', 'Global Income (E)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["E",{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Housing\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"=\"),\"<>\")","v":"<>"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"=Agriculture Farm\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Value of Meals (E) should contain value in the following row(s): \",\"As 'Type of Housing' contains 'Agriculture Farm', 'Global Income (E)' should contain value in the following row(s): \"),\"\")","v":""}]
[]
["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","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): "]
[]
["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): "]
[]
["ExemptCeriNo"]
["="]
["'Exemption Certificate Number' 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","N"]
[{"$f":"\"=Resident\"","v":"=Resident"},{"$f":"\"=Primary Employee\"","v":"=Primary Employee"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"=\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"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): \",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):\")),\"\")","v":""}]
[]
["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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"=\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should contain value in following row(s): \",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):\")),\"\")","v":""}]
[]
["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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Type' contains 'Secondary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Type' contains 'Secondary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): \"),\"\")","v":""}]
[]
["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 be a positive number in following row(s): "]
[]
["N"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(AND(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)<\"12\")),\">9000\",IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"\"),\"\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(AND(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)<\"12\")),\"Affordable Housing Relief cannot be greater than Ksh, 9,000 in the following row(s):\",IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"12\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Affordable Housing levy cannot be blank in the following row(s):\",\"\"),\"\")),\"\")","v":""}]
[]
["N"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"<0\",\"\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Affordable Housing Relief/levy should be a positive number in the following row(s): \",\"\"),\"\")","v":""}]
[]
["PIN","Name","Res","Type","ExemptCeriNo","Basic","HousingAllow","Transport","Leave","ot","Director","lumpsum","OthrAllow","A","Car","C","D","E","Housing","Rent","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","Self"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For Section D"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",643,"A1:D2","B"]
["crit2",647,"A5:C6","E"]
["crit3",651,"A9:B10","G"]
["crit4",655,"A13:B14","H"]
["crit5",659,"A17:B18","I"]
["crit6",663,"A21:B22","H"]
["crit7",667,"A25:B26","I"]
["crit8",671,"A29:A30","D"]
["crit9",675,"A33:A34","C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["REFTOSec","REFTOSec","REFTOSec","REFTOSec"]
["<>B_Employees_Dtls","<>C_Disabled_Employees_Dtls","<>G_Arrears_Dtls_E","<>H_Arrears_Dtls_DE"]
["Reference to Section' should contain value 'B_Employees_Dtls' or C_Disabled_Employees_Dtls' or 'G_Arrears_Dtls_E' or 'H_Arrears_Dtls_DE'  in following row(s): "]
[]
["BodyType","BodyType","BodyType"]
["<>Saloon Hatch Backs and Estates","<>Pick Ups, Panel Vans Uncovered","<>Land Rovers/ Cruisers(excludes Range Rovers and vehicles of similar nature)"]
["'Body Type' should contain value 'Saloon Hatch Backs and Estates' or 'Pick Ups, Panel Vans Uncovered' or 'Land Rovers/Cruisers(excludes Range Rovers and vehicles of similar nature)' in following row(s): "]
[]
["TypeOfCar","TypeOfCar"]
["<>Owned","<>Hired"]
["'Type of Car Cost'  should contain value 'Owned' or 'Hired' in following row(s): "]
[]
["TypeOfCar","HiredCost"]
[{"$f":"\"=Owned\"","v":"=Owned"},"<>"]
["As 'Type of Car Cost' contains 'Owned', 'Cost of Hiring / Leasing (Ksh)' should be blank in following row(s): "]
[]
["TypeOfCar","OwnedCost"]
[{"$f":"\"=Owned\"","v":"=Owned"},"="]
["As 'Type of Car Cost' contains 'Owned', 'Cost of Owned Car (Ksh)' should contain value in following row(s): "]
[]
["TypeOfCar","HiredCost"]
[{"$f":"\"=Hired\"","v":"=Hired"},"="]
["As 'Type of Car Cost' contains 'Hired', 'Cost of Hiring / Leasing (Ksh)' should contain value in following row(s): "]
[]
["TypeOfCar","OwnedCost"]
[{"$f":"\"=Hired\"","v":"=Hired"},"<>"]
["As 'Type of Car Cost' contains 'Hired', 'Cost of Owned Car (Ksh)' should be blank in following row(s): "]
[]
["Make"]
[{"$f":"\"=???????????????????????????????????????????????????*\"","v":"=???????????????????????????????????????????????????*"}]
["'Make' should be of length less than or equal to 50 charecters in following row(s): "]
[]
["RegNo"]
[{"$f":"\"=?????????????????????*\"","v":"=?????????????????????*"}]
["'Car Registration Number' should be of length less than or equal to 20 characters in following row(s): "]
[]
["PIN","REFTOSec","RegNo","Make","BodyType","CCRating","TypeOfCar","HiredCost","OwnedCost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FOR SECTION F"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",718,"A1:B3","E"]
["crit2",723,"A6:B8","F"]
["crit3",727,"A11:A12","I"]
["crit4",731,"A15:A16","J"]
["crit5",735,"A19:A20","K"]
["crit6",739,"A23:A24","B"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DueYear","DueYear"]
["<1998"]
[null,{"$f":"CONCATENATE(\">\",YEAR(TODAY()))","v":">2025"}]
["'Lump Sum Payment Due Year' should contain value in range from 1998 to current financial year in following row(s): "]
[]
["PayYear","PayYear"]
["<1998"]
[null,{"$f":"CONCATENATE(\">\",YEAR(TODAY()))","v":">2025"}]
["'Lump Sum Payment Paid Year' should contain value in range from 1998 to current financial year in following row(s): "]
[]
["C"]
["<>"]
["'Total Revised Income (Ksh) (C)= (A+B)' should be blank in following row(s): "]
[]
["D"]
["<>"]
["'PAYE Deducted on Revised Income (Ksh) (D)' should be blank in following row(s): "]
[]
["E"]
["="]
["PAYE Paid in Lump Sum Payment Due Year (Ksh) / Lump Sum Payment Due Month (Ksh) (E)'  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):"]
[]
["PIN of Employee","Name","Employment Start Date","Employment End Date","DueYear","PayYear","Amount of Gross Lump Sum Payment (Ksh) (A)","Emoluments of Lump Sum Payment Due Year (Ksh) / Emoluments of Lump Sum Payment Due Month (Ksh) (B)","C","D","E"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Section G"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",830,"A1:L2","C"]
["crit2",835,"A5:B7","D"]
["crit3",839,"A10:B11","E"]
["crit4",843,"A14:B15","F"]
["crit5",847,"A18:A19","O"]
["crit6",851,null,"S"]
["crit7",855,"A26:B27","U"]
["crit8",859,"A30:B31","W"]
["crit9",863,null,"S"]
["crit10",867,"A38:B39","U"]
["crit11",871,"A42:B43","W"]
["crit12",875,"A46:B47","U"]
["crit13",879,"A50:B51","W"]
["crit14",883,null,"S"]
["crit15",887,"A58:B59","U"]
["crit16",891,"A62:B63","W"]
["crit17",895,null,"S"]
["crit18",899,null,"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,null,"AD"]
["crit35",967,"A138:C139","AH"]
["crit36",971,"A142:E143","T"]
["crit37",975,"A146:C147","AA"]
["crit38",979,"A150:C151","AC"]
["crit39",983,null,"AD"]
["crit40",987,"A158:C159","AH"]
["crit41",991,"A162:B163","AA"]
["crit42",995,"A166:B167","AC"]
["crit43",999,null,"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,null,"AD"]
["crit51",1031,null,"AD"]
["crit52",1035,null,"AD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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","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","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","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"]
[]
[]
[]
["E"]
[]
[]
[]
["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"]
["="]
["Column Z cannot be blank in the following row(s): "]
[]
["L"]
["="]
["Column AB cannot be blank in the 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"]
[]
[]
[]
["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"]
[]
[]
[]
["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"]
[]
[]
[]
["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","Month","Month"]
[]
[]
[]
["N"]
[]
[]
[]
["N"]
[]
[]
[]
["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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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,null,"T"]
["crit7",1179,"A26:B27","V"]
["crit8",1183,"A30:B31","X"]
["crit9",1187,null,"T"]
["crit10",1191,"A38:B39","V"]
["crit11",1195,"A42:B43","X"]
["crit12",1199,"A46:B47","V"]
["crit13",1203,"A50:B51","X"]
["crit14",1207,null,"T"]
["crit15",1211,"A58:B59","V"]
["crit16",1215,"A62:B63","X"]
["crit17",1219,null,"T"]
["crit18",1223,null,"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,null,"AE"]
["crit37",1299,"A146:C147","AJ"]
["crit38",1303,"A150:E151","U"]
["crit39",1307,"A154:C155","AB"]
["crit40",1311,"A158:C159","AD"]
["crit41",1315,null,"AE"]
["crit42",1319,"A166:C167","AJ"]
["crit43",1323,"A170:B171","AB"]
["crit44",1327,"A174:B175","AD"]
["crit45",1331,null,"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,null,"AE"]
["crit54",1367,null,"AE"]
["crit55",1371,null,"AE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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","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","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","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"]
[]
[]
[]
["E"]
[]
[]
[]
["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"]
["="]
["Column AA cannot be blank in the following row(s): "]
[]
["L"]
["="]
["Column AC cannot be blank in the 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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"\",\"<2021\"),\"\")","v":""},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"=\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"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): \",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Residential Status' contains 'Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):\")),\"\")","v":""}]
[]
["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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"=\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\")),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(MID(RtnInf.RtnPrdFrom,7,4)<\"2021\",\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should contain value in following row(s): \",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Residential Status' contains 'Non-Resident' and 'Type' contains 'Primary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s):\")),\"\")","v":""}]
[]
["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"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"As 'Type' contains 'Secondary Employee', 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"As 'Type' contains 'Secondary Employee', 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): \"),\"\")","v":""}]
[]
["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","Month","Month"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\">=2024\",\">=2021\"),\"\")","v":""},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"=\",\"<>\"),\"\")","v":""},"<>January","<>February"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"'As 'Year' is greater than or equal to 2024 March, 'Affordable Housing Relief (N)' should contain value in following row(s): \",\"'As 'Year' is greater than or equal to 2021, 'Deposit on Home Ownership Saving Plan (N)' should be blank in following row(s): \"),\"\")","v":""}]
[]
["N"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\">9000\",\"\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Affordable Housing Relief cannot be greater than Ksh, 9,000 in the following row(s): \",\"\"),\"\")","v":""}]
[]
["N"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"<0\",\"\"),\"\")","v":""}]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",IF(OR(AND(MID(RtnInf.RtnPrdFrom,7,4)=\"2024\",MID(RtnInf.RtnPrdFrom,4,2)>=\"03\"),MID(RtnInf.RtnPrdFrom,7,4)>\"2024\"),\"Affordable Housing Relief should be a positive number in the following row(s): \",\"\"),\"\")","v":""}]
[]
["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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For Section M"]
["Criteria","EndRow","CriteriaRange","Highlight Cell Column"]
["crit1",1451,"A1:A2","A"]
["crit2",1455,"A5:A6","B"]
["crit3",1459,"A9:A10","C"]
["crit4",1463,"A13:A14","D"]
["crit5",1467,"A17:A18","E"]
[]
[]
[]
["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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[]
[]
[]
["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":"Validations","index":3,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["SectionName","Name","MaxLength","Mandatory","ValidationRule1","Error Message","ValidationRule2","Error Message",null,"Section Description"]
["A_Basic_Info","Employer's Personal Identification Number",15,"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.",null,null,null,"Section A : Return Information"]
["A_Basic_Info","Entity Type",25,"Y","isMandatory(RtnInf.EntityType,\"Y\")","Entity Type is Mandatory field.",null,null,null,"Section A : Return Information"]
["A_Basic_Info","Return Period From",25,"Y","isMandatory(RtnInf.RtnPrdFrom,\"Y\")","Return Period From is Mandatory field.",null,null,null,"Section A : Return Information"]
["A_Basic_Info","Return Period To",4,"Y","isMandatory(RtnInf.RtnPrdTo,\"Y\")","Return Period To is Mandatory field.",null,null,null,"Section A : Return Information"]
["N_Tax_Due","Previous month PAYE Tax",15,"N","IF(RtnInf.EntityType=\"Head Office\",isMandatory(ClcTaxDue.PrevMonPaye,\"Y\"),\"NE\")","Previous month PAYE Tax is Mandatory field.",null,null,null,"Section N : Calculation of Tax Due"]
["K_PAYE_Payment_Credits","Section K : Details of PAYE Tax paid",15,"Y","isMandatory(DtlsPayeFinalTaxPdTO,\"N\")",{"$f":"CONCATENATE(B8,MsgMandat)","v":"Section K : Details of PAYE Tax paid is Mandatory field."},"validateAdvTax1(ClcTaxDue.TotTaxPybl,DtlsPayeFinalTaxPdTO,DtlsPayeTaxPaidAdvListTO,DtlsPayeSelfAssTaxListTO)","You do not have any net tax payable in L_Tax_Due (11) for the period. You cannot declare self assessment tax / advance payment details.",null,"Section K : Details of PAYE Tax paid"]
["K_PAYE_Payment_Credits","Section K : Details of PAYE Tax paid",15,"Y","isMandatory(DtlsPayeFinalTaxPdTO,\"N\")",{"$f":"CONCATENATE(B9,MsgMandat)","v":"Section K : Details of PAYE Tax paid is Mandatory field."},null,"You have declared the self assessment tax as well as advance payment details. The total amount declared is more than  the net tax payable  in L_Tax_Due (11). Please restrict the amount to net tax payable first adjusting through self assessment tax and then through advance payment.",null,"Section K : Details of PAYE Tax paid"]
["K_PAYE_Payment_Credits","Section K2 : Self Assessment Tax",15,"Y","isMandatory(DtlsPayeFinalTaxPdTO,\"N\")",{"$f":"CONCATENATE(B10,MsgMandat)","v":"Section K2 : Self Assessment Tax is Mandatory field."},null,"You have declared the self assessment tax payment details. The total amount declared in self assessment tax paid is more than the net tax payable in L_Tax_Due (11). Please restrict the amount to net tax payable.",null,"Section K2 : Self Assessment Tax"]
["K_PAYE_Payment_Credits","Section K1 : Advance Payment",15,"Y","isMandatory(DtlsPayeFinalTaxPdTO,\"N\")",{"$f":"CONCATENATE(B11,MsgMandat)","v":"Section K1 : Advance Payment is Mandatory field."},null,"You have declared the advance payment details. The total amount declared in advance payment paid is more than the net tax payable in L_Tax_Due (11). Please restrict the amount to net tax payable.",null,"Section K1 : Advance Payment"]
["I_Gratuity_Dtls","Calculation of PAYE Tax Payable on Gratuity for Specific PIN",0,"Y","checkUnwantedDataInSecI()","\"Emoluments of Gratuity Year\" and \"Tax Paid in Gratuity Year\" should be blank when PIN is blank.",null,null,null,"Section I : Calculation of PAYE Tax Payable on Gratuity"]
["M1_NITA_Levy_Dtls","Section M1 : Details of NITA Levy",0,"Y",null,null,null,null,null,"Section M1 : Details of NITA Levy"]

{"sheet":"ValidationList","index":4,"n_rows":130,"n_cols":32,"rows_kept":130,"cut":false,"hidden":true,"merged":[]}
["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","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation","Column Name & Validation",null,null,null,"Section Description"]
["B_Employees_Dtls","PIN of Employee","Name of the  Employee","Residential Status","Type of Employee","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Other Non cash Benefits","Global Income (In case of non full time service Director)","Type of Housing","Rent of House","Rent Recovered from Employee","Actual Contribution","Mortgage Interest","Affordable Housing Relief","Monthly Personal Relief","Self Assessed PAYE Tax","Amount of Insurance Relief","Value of Car Benefit","CX","CZ",null,null,null,null,"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","Y","N","Y","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\",\"O\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"Q\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"R\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"S\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"U\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"Y\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AA\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AB\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AF\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AI\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"N\",\"AG\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"N\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"X\")","isMandatory(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\",\"Z\")"]
["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.","Basic Salary is Mandatory field.","Housing Allowance is Mandatory field.","Transport Allowance is Mandatory field.","Leave Pay is Mandatory field.","Over Time Allowance is Mandatory field.","Director's Fee is Mandatory field.","Lump Sum Payment if any is Mandatory field.","Other Allowance is Mandatory field.","Other Non cash Benefits is Mandatory field.",{"$f":"CONCATENATE(O2,MsgMandat)","v":"Global Income (In case of non full time service Director) is Mandatory field."},"Type of Housing is Mandatory field.","Rent of House is Mandatory field.","Rent Recovered from Employee is Mandatory field.","Actual Contribution is Mandatory field.","Mortgage Interest is Mandatory field.","Affordable Housing Relief is Mandatory field.",{"$f":"CONCATENATE(V2,MsgMandat)","v":"Monthly Personal Relief is Mandatory field."},{"$f":"CONCATENATE(W2,MsgMandat)","v":"Self Assessed PAYE Tax is Mandatory field."},{"$f":"CONCATENATE(X2,MsgMandat)","v":"Amount of Insurance Relief is Mandatory field."},"Value of Car Benefit is Mandatory field.","Value of Column X is Mandatory field.","Value of Column Z is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(DtlsSalPdBftsPayeDedFrmEmp.List,\"A\")","validateAlphaNumeric(DtlsSalPdBftsPayeDedFrmEmp.List,\"B\")",null,null,"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"E\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"F\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"G\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"H\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"I\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"J\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"K\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"L\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"O\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"Q\")",null,"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"S\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"U\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"Y\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"AA\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"AB\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"AF\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"AI\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"AG\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"N\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"X\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmEmp.List,\"Z\")"]
["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."},"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.","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.","Please enter numeric value only.","Please enter numeric value only.","Please enter numeric value only","Please enter numeric value only"]
["ValidationRule3"]
["Error Message",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MsgNum","v":"Please enter numeric value only."},null,{"$f":"MsgNum","v":"Please enter numeric value only."}]
[]
["C_Disabled_Employees_Dtls","PIN of Employee","Name of the  Employee","Residential Status","Type of Employee","Exemption Certificate Number","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Other Non cash Benefits","Global Income (In case of non full time service Director)","Type of Housing","Rent of House","Rent Recovered from Employee","Actual Contribution","Mortgage Interest","Affordable Housing Relief","Monthly Personal Relief","Self Assessed PAYE Tax","Amount of Insurance Relief","Value of Car Benefit","Column Y","Column AA",null,null,null,"Section C : Details of Salary and Benefits paid and PAYE deducted from Persons with Disability"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","N","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"A\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"B\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"C\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"D\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"E\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"F\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"G\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"H\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"I\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"J\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"K\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"L\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"M\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"P\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"R\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"S\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"T\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"V\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"Z\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AB\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AC\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AH\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AK\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"N\",\"AI\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"O\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"Y\")","isMandatory(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AA\")"]
["Error Message",{"$f":"CONCATENATE(B12,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.","Exemption Certificate Number is Mandatory field.","Basic Salary is Mandatory field.","Housing Allowance is Mandatory field.","Transport Allowance is Mandatory field.","Leave Pay is Mandatory field.","Over Time Allowance is Mandatory field.","Director's Fee is Mandatory field.","Lump Sum Payment if any is Mandatory field.","Other Allowance is Mandatory field.","Other Non cash Benefits is Mandatory field.","Global Income (In case of non full time service Director) is Mandatory field.","Type of Housing is Mandatory field.","Rent of House is Mandatory field.","Rent Recovered from Employee is Mandatory field.","Actual Contribution is Mandatory field.","Mortgage Interest is Mandatory field.","Affordable Housing Relief is Mandatory field.","Monthly Personal Relief is Mandatory field.",{"$f":"CONCATENATE(X12,MsgMandat)","v":"Self Assessed PAYE Tax is Mandatory field."},{"$f":"CONCATENATE(Y12,MsgMandat)","v":"Amount of Insurance Relief is Mandatory field."},"Value of Car Benefit is Mandatory field.","Value of Column Y is Mandatory field.","Value of Column AA is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"A\")","validateAlphaNumeric(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"B\")",null,null,"validateAlphaNumeric(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"E\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"F\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"G\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"H\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"I\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"J\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"K\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"L\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"M\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"P\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"R\")",null,"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"T\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"V\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Z\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"AB\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"AC\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"AH\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"AK\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"AI\")",null,"validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"Y\")","validateCurrencyFormat(DtlsSalPdBftsPayeDedFrmDsblEmp.List,\"AA\")"]
["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,null,"Please enter alphanumeric value.Only Special characters like (space : - , / . \\n ' & (  )  ` $ % { } !  | # : ) are allowed.",{"$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.","Please enter numeric value only.",null,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.",{"$f":"MsgNum","v":"Please enter numeric value only."},null,"Please enter numeric value only","Please enter numeric value only"]
["ValidationRule3"]
["Error Message",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mortgage Interest amount exceeds the max. Amount ","Deposit on Home Ownership Saving Plan exceeds max. Amount","Monthly Personal Relief respective month exceeds max. Amount."]
[]
["D_Computation_of_Car_Benefit","PIN of Employee","Reference to Section","Car Registration Number","Make","Body Type","CC Rating","Type of Car Cost","Cost of Hiring / Leasing","Cost of Owned Car","Value of Car Benefit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section D : Computation of Value of Car Benefit"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y","Y","Y","N"]
["MaxLength"]
["ValidationRule1","isMandatory(CarBenefit.List,\"Y\",\"A\")","isMandatory(CarBenefit.List,\"Y\",\"B\")","isMandatory(CarBenefit.List,\"Y\",\"C\")","isMandatory(CarBenefit.List,\"Y\",\"D\")","isMandatory(CarBenefit.List,\"Y\",\"E\")","isMandatory(CarBenefit.List,\"Y\",\"F\")","isMandatory(CarBenefit.List,\"Y\",\"G\")","isMandatory(CarBenefit.List,\"Y\",\"H\")","isMandatory(CarBenefit.List,\"Y\",\"I\")","isMandatory(CarBenefit.List,\"N\",\"J\")"]
["Error Message",{"$f":"CONCATENATE(B22,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Reference to Section is Mandatory field.","Car Registration Number is Mandatory field.","Make is Mandatory field.","Body Type is Mandatory field.","CC Rating is Mandatory field.","Type of Car Cost is Mandatory field.","Cost of Hiring / Leasing is Mandatory field.","Cost of Owned Car is Mandatory field.","Value of Car Benefit is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(CarBenefit.List,\"A\")",null,"validateAlphaNumeric(CarBenefit.List,\"C\")","validateAlphaNumeric(CarBenefit.List,\"D\")",null,"validateCurrencyFormat(CarBenefit.List,\"F\")",null,"validateCurrencyFormat(CarBenefit.List,\"H\")","validateCurrencyFormat(CarBenefit.List,\"I\")","validateCurrencyFormat(CarBenefit.List,\"J\")"]
["Error Message",{"$f":"CONCATENATE(B22,MsgPINDup)","v":"PIN of Employee can not be same as  Taxpayer's PIN."},null,{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},null,{"$f":"MsgNum","v":"Please enter numeric value only."},null,{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."}]
[]
["E_Computation_of_Insu_Relief","PIN of Employee","Reference to Section","PIN of Insurance Company","Name of Insurance Company","Purpose of Policy","Insurance Policy Number","Policy Holder","Age of Child","Commencement Date","Maturity Date","Sum Assured","Premium paid till month (Ksh) (A)","Date of payment of premium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section E : Details of Insurance Relief"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y","N","Y","Y","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(InsReliefDtls.List,\"Y\",\"A\")","isMandatory(InsReliefDtls.List,\"Y\",\"B\")","isMandatory(InsReliefDtls.List,\"Y\",\"C\")","isMandatory(InsReliefDtls.List,\"Y\",\"D\")","isMandatory(InsReliefDtls.List,\"Y\",\"E\")","isMandatory(InsReliefDtls.List,\"Y\",\"F\")","isMandatory(InsReliefDtls.List,\"Y\",\"G\")","isMandatory(InsReliefDtls.List,\"N\",\"H\")","isMandatory(InsReliefDtls.List,\"Y\",\"I\")","isMandatory(InsReliefDtls.List,\"Y\",\"J\")","isMandatory(InsReliefDtls.List,\"Y\",\"K\")","isMandatory(InsReliefDtls.List,\"Y\",\"L\")","isMandatory(InsReliefDtls.List,\"Y\",\"M\")"]
["Error Message",{"$f":"CONCATENATE(B30,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Reference to Section is Mandatory field.","PIN of Insurance Company is Mandatory field.","Name of Insurance Company is Mandatory field.","Purpose of Policy is Mandatory field.","Insurance Policy Number is Mandatory field.","Policy Holder is Mandatory field.","Age of Child is Mandatory field.","Commencement Date is Mandatory field.","Maturity Date is Mandatory field.","Sum Assured is Mandatory field.","Premium paid till month (Ksh) (A) is Mandatory field.",{"$f":"CONCATENATE(N30,MsgMandat)","v":"Date of payment of premium is Mandatory field."}]
["ValidationRule2","validateTaxPyrPIN(InsReliefDtls.List,\"A\")",null,"validateTaxPyrPIN(InsReliefDtls.List,\"C\")","validateAlphaNumeric(InsReliefDtls.List,\"D\")",null,"validateAlphaNumeric(InsReliefDtls.List,\"F\")",null,"validateCurrencyFormat(InsReliefDtls.List,\"H\")",null,null,"validateNumeric(InsReliefDtls.List,\"K\")","validateNumeric(InsReliefDtls.List,\"L\")"]
["Error Message","Please enter Employee's PIN in proper format.",null,{"$f":"CONCATENATE(D30,MsgPINDup)","v":"PIN of Insurance Company can not be same as  Taxpayer's PIN."},{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},null,{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},null,{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"CONCATENATE(J30,MsgDateFrmt)","v":"Commencement Date in proper format(dd/mm/yyyy)."},{"$f":"CONCATENATE(K30,MsgDateFrmt)","v":"Maturity Date in proper format(dd/mm/yyyy)."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"CONCATENATE(N30,MsgDateFrmt)","v":"Date of payment of premium in proper format(dd/mm/yyyy)."}]
[]
["F_Lump_Sum_Payments_Dtls","PIN of Employee","Name of Employee","Employment Start Date","Employment End Date","Lump Sum Payment Due Year","Lump Sum Payment Paid Year","Amount of Gross Lump Sum Payment","Emoluments of Lump Sum Payment Due Year/ Emoluments of Lump Sum Payment Due Month","PAYE Paid in Lump Sum Payment Due Year/ Lump Sum Payment Due Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section F : Calculation of PAYE Tax on Lump Sum Payments Paid after Termination"]
["Mandatory","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\",\"K\")"]
["Error Message",{"$f":"CONCATENATE(B38,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of Employee is Mandatory field.","Employment Start Date is Mandatory field.","Employment End Date is Mandatory field.","Lump Sum Payment Due Year is Mandatory field.","Lump Sum Payment Paid Year is Mandatory field.","Amount of Gross Lump Sum Payment is Mandatory field.","Emoluments of Lump Sum Payment Due Year/ Emoluments of Lump Sum Payment Due Month is Mandatory field.","PAYE Paid in Lump Sum Payment Due Year/ Lump Sum Payment Due Month is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(TaxPdOnLumpSumPdAftrTrmtn.List,\"A\")","validateAlphaNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"B\")","validateDate(TaxPdOnLumpSumPdAftrTrmtn.List,\"C\")","validateDate(TaxPdOnLumpSumPdAftrTrmtn.List,\"D\")","validateNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"E\")","validateNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"F\")","validateNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"G\")","validateNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"H\")","validateNumeric(TaxPdOnLumpSumPdAftrTrmtn.List,\"K\")"]
["Error Message","Please enter Employee's PIN in proper format.",{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},"Please enter Employment Start Date in proper format (dd/mm/yyyy)","Please enter Employment End Date in proper format (dd/mm/yyyy)",{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."}]
["ValidationRule3",null,null,null,null,"checkYearFromSecA(RtnInf.RtnYear,TaxPdOnLumpSumPdAftrTrmtn.List,\"E\")","checkYearFromSecA(RtnInf.RtnYear,TaxPdOnLumpSumPdAftrTrmtn.List,\"F\")"]
["Error Message",null,null,null,null,"Lump Sum Payment Due Year should be on or before Return Period From","Lump Sum Payment Paid Year should be equals to Return Period From"]
["ValidationRule4"]
["Error Message"]
[]
["G_Arrears_Dtls_E","PIN of Employee","Name of Employee","Arrears for the Month","Arrears Year","Residential Status","Type of Employee","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Other Non cash Benefits","Global Income (In case of non full time service Director)","Type of Housing","Rent of House","Rent Recovered from Employee","Actual Contribution","Mortgage Interest","Affordable Housing Relief","Monthly Personal Relief","Amount of PAYE Already Paid ","Self Assessed PAYE Tax","Amount of Insurance Relief","Value of Car Benefit","Column Z","Colum AB",null,"Section G : Details of Arrears of Salary and  Benefits"]
["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","N","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"A\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"B\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"C\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"D\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"E\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"F\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"G\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"H\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"I\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"J\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"K\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"L\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"M\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"N\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"Q\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"S\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"T\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"U\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"W\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AA\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AC\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AD\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AH\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AK\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"AM\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"N\",\"AI\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Y\",\"P\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"N\",\"Z\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"N\",\"AB\")"]
["Error Message",{"$f":"CONCATENATE(B50,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of Employee is Mandatory field.","Arrears for the Month is Mandatory field.","Arrears Year is Mandatory field.","Residential Status is Mandatory field.","Type of Employee is Mandatory field.","Basic Salary is Mandatory field.","Housing Allowance is Mandatory field.","Transport Allowance is Mandatory field.","Leave Pay is Mandatory field.","Over Time Allowance is Mandatory field.","Director's Fee is Mandatory field.","Lump Sum Payment if any is Mandatory field.","Other Allowance is Mandatory field.","Other Non cash Benefits is Mandatory field.",{"$f":"CONCATENATE(Q50,MsgMandat)","v":"Global Income (In case of non full time service Director) is Mandatory field."},"Type of Housing is Mandatory field.","Rent of House is Mandatory field.","Rent Recovered from Employee is Mandatory field.","Actual Contribution is Mandatory field.","Mortgage Interest is Mandatory field.","Affordable Housing Relief is Mandatory field.",{"$f":"CONCATENATE(X50,MsgMandat)","v":"Monthly Personal Relief is Mandatory field."},{"$f":"CONCATENATE(Y50,MsgMandat)","v":"Amount of PAYE Already Paid  is Mandatory field."},{"$f":"CONCATENATE(Z50,MsgMandat)","v":"Self Assessed PAYE Tax is Mandatory field."},{"$f":"CONCATENATE(AA50,MsgMandat)","v":"Amount of Insurance Relief is Mandatory field."},"Value of Car Benefit is Mandatory field.","Value of Column Z is Mandatory field.","Value of Column AB is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"A\")","validateAlphaNumeric(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"B\")","validateArrearsDateDiff(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"C\",\"AP\",\"D\")",null,null,null,"validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"G\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"H\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"I\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"J\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"K\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"L\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"M\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"N\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Q\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"S\")",null,"validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"U\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"W\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AA\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AC\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AD\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AH\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AK\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AM\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AI\")",null,"validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"Z\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmEmp.List,\"AB\")"]
["Error Message","Please enter Employee's PIN in proper format.",null,"The arrears period can only be upto 60 months prior from the return period.",null,null,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.","Please enter numeric value only.","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.",{"$f":"MsgNum","v":"Please enter numeric value only."},"Please enter numeric value only.","Please enter numeric value only.",{"$f":"MsgNum","v":"Please enter numeric value only."},null,"Please enter numeric value only","Please enter numeric value only"]
["ValidationRule3"]
["Error Message",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mortgage Interest amount exceeds the max. Amount ","Deposit on Home Ownership Saving Plan exceeds max. Amount","Monthly Personal Relief respective month exceeds max. Amount."]
[]
["H_Arrears_Dtls_DE","PIN of Employee","Name of Employee","Arrears for the Month","Arrears Year","Residential Status","Type of Employee","Exemption Certificate Number","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Other Non cash Benefits","Global Income (In case of non full time service Director)","Type of Housing","Rent of House","Rent Recovered from Employee","Actual Contribution","Mortgage Interest","Affordable Housing Relief","Monthly Personal Relief","Amount of PAYE Already Paid ","Self Assessed PAYE Tax","Amount of Insurance Relief","Value of Car Benefit","Column AA","Column AC","Section H : Details of Arrears of Salary and  Benefits"]
["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","N","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"A\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"B\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"C\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"D\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"E\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"F\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"G\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"H\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"I\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"J\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"K\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"L\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"M\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"N\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"O\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"S\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"T\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"U\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"V\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"X\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AB\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AD\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AE\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AJ\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AM\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AO\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"N\",\"AK\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"Q\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AA\")","isMandatory(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"Y\",\"AC\")"]
["Error Message",{"$f":"CONCATENATE(B60,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of Employee is Mandatory field.","Arrears for the Month is Mandatory field.","Arrears Year is Mandatory field.","Residential Status is Mandatory field.","Type of Employee is Mandatory field.","Exemption Certificate Number is Mandatory field.","Basic Salary is Mandatory field.","Housing Allowance is Mandatory field.","Transport Allowance is Mandatory field.","Leave Pay is Mandatory field.","Over Time Allowance is Mandatory field.","Director's Fee is Mandatory field.","Lump Sum Payment if any is Mandatory field.","Other Allowance is Mandatory field.","Other Non cash Benefits is Mandatory field.",{"$f":"CONCATENATE(R60,MsgMandat)","v":"Global Income (In case of non full time service Director) is Mandatory field."},"Type of Housing is Mandatory field.","Rent of House is Mandatory field.","Rent Recovered from Employee is Mandatory field.","Actual Contribution is Mandatory field.","Mortgage Interest is Mandatory field.","Affordable Housing Relief is Mandatory field.",{"$f":"CONCATENATE(Y60,MsgMandat)","v":"Monthly Personal Relief is Mandatory field."},{"$f":"CONCATENATE(Z60,MsgMandat)","v":"Amount of PAYE Already Paid  is Mandatory field."},{"$f":"CONCATENATE(AA60,MsgMandat)","v":"Self Assessed PAYE Tax is Mandatory field."},{"$f":"CONCATENATE(AB60,MsgMandat)","v":"Amount of Insurance Relief is Mandatory field."},"Value of Car Benefit is Mandatory field.","Value of Column AA is Mandatory field.","Value of Column AC is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"A\")","validateAlphaNumeric(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"B\")","validateArrearsDateDiff(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"C\",\"AR\",\"D\")",null,null,null,"validateAlphaNumeric(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"G\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"H\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"I\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"J\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"K\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"L\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"M\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"N\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"O\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"S\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"T\")",null,"validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"V\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"X\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AB\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AD\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AE\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AJ\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AM\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AO\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AK\")",null,"validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.List,\"AA\")","validateCurrencyFormat(DtlsArrSalPdBftsPayeDedFrmDsblEmp.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."},"The arrears period can only be upto 60 months prior from the return period.",null,null,null,"Please enter only alphanumerics. Only special character like ( space  :  - ,  / . \\n ' & ( ) ` $ % { } ! | # :) are  allowed.",{"$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.","Please enter numeric value only.","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.",{"$f":"MsgNum","v":"Please enter numeric value only."},"Please enter numeric value only.","Please enter numeric value only.",{"$f":"MsgNum","v":"Please enter numeric value only."},null,"Please enter numeric value only","Please enter numeric value only"]
["ValidationRule3"]
["Error Message",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mortgage Interest amount exceeds the max. Amount ","Deposit on Home Ownership Saving Plan exceeds max. Amount","Monthly Personal Relief respective month exceeds max. Amount."]
[]
["J_FBT_Dtls","PIN of Employee","Name of Employee","Loan Account Number","Loan Amount","Amount of Loan Outstanding","Rate of Interest on Loan","Prescribed Market Interest Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section J : Calculation of Fringe Benefit Tax Payable"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"A\")","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"B\")","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"C\")","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"D\")","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"E\")","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"F\")","isMandatory(FringeBenf.TaxCalcList,\"Y\",\"H\")"]
["Error Message",{"$f":"CONCATENATE(B70,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of Employee is Mandatory field.","Loan Account Number is Mandatory field.","Loan Amount is Mandatory field.","Amount of Loan Outstanding is Mandatory field.","Rate of Interest on Loan is Mandatory field.","Prescribed Market Interest Rate is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(FringeBenf.TaxCalcList,\"A\")","validateAlphaNumeric(FringeBenf.TaxCalcList,\"B\")","validateAlphaNumericOnly(FringeBenf.TaxCalcList,\"C\")","validateCurrencyFormat(FringeBenf.TaxCalcList,\"D\")","validateCurrencyFormat(FringeBenf.TaxCalcList,\"E\")",null,"validateCurrencyFormat(FringeBenf.TaxCalcList,\"H\")"]
["Error Message",{"$f":"CONCATENATE(B70,MsgPINDup)","v":"PIN of Employee can not be same as  Taxpayer's PIN."},{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},{"$f":"MsgAlpNum","v":"Please enter alphanumeric value. Special characters  are  not allowed."},{"$f":"MsgNum","v":"Please enter numeric value only."},{"$f":"MsgNum","v":"Please enter numeric value only."},null,{"$f":"MsgNum","v":"Please enter numeric value only."}]
[]
["I_Gratuity_Dtls","PIN of Employee","Name of Employee","Gratuity Paid Month","Gratuity Paid Year ","Gratuity Related/ Retirement Year","Gratuity Period in Years","Gratuity Value (Ksh)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section I : Calculation of PAYE Tax Payable on Gratuity"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"A\")","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"B\")","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"C\")","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"D\")","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"E\")","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"F\")","isMandatory(CalPayeTaxPyblOnGratI.List,\"Y\",\"G\")"]
["Error Message",{"$f":"CONCATENATE(B78,MsgMandat)","v":"PIN of Employee is Mandatory field."},"Name of Employee is Mandatory field.","Gratuity Paid Month is Mandatory field.","Gratuity Paid Year  is Mandatory field.","Gratuity Related/ Retirement Year is Mandatory field.","Gratuity Period in Years is Mandatory field.","Gratuity Value (Ksh) is Mandatory field."]
["ValidationRule2","validateTaxPyrPIN(CalPayeTaxPyblOnGratI.List,\"A\")","validateAlphaNumeric(CalPayeTaxPyblOnGratI.List,\"B\")","validateEqlGivenString(CalPayeTaxPyblOnGratI.List,RtnInf.Month,\"C\")","validateEqlGivenYear(CalPayeTaxPyblOnGratI.List,RtnInf.RtnYear,\"D\")","validateBeforeGivenYear(CalPayeTaxPyblOnGratI.List,RtnInf.RtnYear,\"E\")",null,"validateCurrencyFormat(CalPayeTaxPyblOnGratI.List,\"G\")"]
["Error Message","Please enter Employee's PIN in proper format.",{"$f":"MsgAlpNumSpl","v":"Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed."},{"$f":"CONCATENATE(D78,MsgRtnMonth)","v":"Gratuity Paid Month should be same as Return for the Month in Section A."},{"$f":"CONCATENATE(E78,MsgYearVal2)","v":"Gratuity Paid Year  should be same as Year of Income in Section A."},{"$f":"CONCATENATE(F78,MsgYearVal1)","v":"Gratuity Related/ Retirement Year should be before or same as Year of Income in Section A."},null,{"$f":"MsgNum","v":"Please enter numeric value only."}]
[]
["I_Gratuity_Dtls","Taxable Amounts","Tax Deducted plus Reliefs","Amount of Tax Payable on Gratuity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section I : Calculation of PAYE Tax Payable on Gratuity for Specific PIN"]
["Mandatory","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(CalPayeTaxPyblOnGratII.List,\"Y\",\"D\")","isMandatory(CalPayeTaxPyblOnGratII.List,\"Y\",\"G\")","isMandatory(CalPayeTaxPyblOnGratII.List,\"Y\",\"H\")"]
["Error Message",{"$f":"CONCATENATE(B86,MsgMandat)","v":"Taxable Amounts is Mandatory field."},{"$f":"CONCATENATE(C86,MsgMandat)","v":"Tax Deducted plus Reliefs is Mandatory field."},"Amount of Tax Payable on Gratuity is Mandatory field where Gratuity Year is 2020"]
[]
["K_PAYE_Payment_Credits","Payment Registration Number","Date of Deposit","Amount of PAYE Tax Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section K1 : Advance Payment"]
["Mandatory","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(DtlsPaye.TaxPaidAdvList,\"Y\",\"A\")","isMandatory(DtlsPaye.TaxPaidAdvList,\"Y\",\"B\")","isMandatory(DtlsPaye.TaxPaidAdvList,\"Y\",\"C\")"]
["Error Message",{"$f":"CONCATENATE(B92,MsgMandat)","v":"Payment Registration Number is Mandatory field."},{"$f":"CONCATENATE(C92,MsgMandat)","v":"Date of Deposit is Mandatory field."},{"$f":"CONCATENATE(D92,MsgMandat)","v":"Amount of PAYE Tax Paid is Mandatory field."}]
["ValidationRule2","validatePRNNumeric(DtlsPaye.TaxPaidAdvList,\"A\")",null,"validatePrnAmount(DtlsPaye.TaxPaidAdvList,\"C\")"]
["Error Message","Please enter numeric value.Only Special characters like (-) is allowed.",{"$f":"CONCATENATE(C92,MsgDateFrmt)","v":"Date of Deposit in proper format(dd/mm/yyyy)."},{"$f":"msgPositvNum","v":"Please enter numeric value greater than zero."}]
["ValidationRule3","validatePRNAllzero(DtlsPaye.TaxPaidAdvList,\"A\")"]
["Error Message","All the digits in the Payment Registration Number cannot be '0'. Please enter Payment Registration Number in proper format."]
[]
["K_PAYE_Payment_Credits","Payment Registration Number","Date of Deposit","Amount of PAYE Tax Paid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section K2 : Self Assessment Tax"]
["Mandatory","Y","Y","Y"]
["MaxLength"]
["ValidationRule1","isMandatory(DtlsPaye.SelfAssTaxPaidList,\"Y\",\"A\")","isMandatory(DtlsPaye.SelfAssTaxPaidList,\"Y\",\"B\")","isMandatory(DtlsPaye.SelfAssTaxPaidList,\"Y\",\"C\")"]
["Error Message",{"$f":"CONCATENATE(B102,MsgMandat)","v":"Payment Registration Number is Mandatory field."},{"$f":"CONCATENATE(C102,MsgMandat)","v":"Date of Deposit is Mandatory field."},{"$f":"CONCATENATE(D102,MsgMandat)","v":"Amount of PAYE Tax Paid is Mandatory field."}]
["ValidationRule2","validatePRNNumeric(DtlsPaye.SelfAssTaxPaidList,\"A\")",null,"validatePrnAmount(DtlsPaye.SelfAssTaxPaidList,\"C\")"]
["Error Message","Please enter numeric value.Only Special characters like (-) is allowed.",{"$f":"CONCATENATE(C102,MsgDateFrmt)","v":"Date of Deposit in proper format(dd/mm/yyyy)."},{"$f":"msgPositvNum","v":"Please enter numeric value greater than zero."}]
["ValidationRule3","validatePRNAllzero(DtlsPaye.SelfAssTaxPaidList,\"A\")"]
["Error Message","All the digits in the Payment Registration Number cannot be '0'. Please enter Payment Registration Number in proper format."]
[]
["M_Housing_Levy_Dtls","Member Number (ID Number)","Member Name","KRA PIN","Gross Salary","Basic Salary","Member Contribution – Housing Levy (A)","Employer Contribution (B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section M : Details of Housing Levy"]
["Mandatory","Y","Y","Y","Y","Y","Y","Y"]
["MaxLength",50,50,11]
["ValidationRule1","isMandatory(HousingLevyDtls,\"N\",\"A\")","isMandatory(HousingLevyDtls,\"Y\",\"B\")","isMandatory(HousingLevyDtls,\"Y\",\"C\")","isMandatory(HousingLevyDtls,\"Y\",\"D\")","isMandatory(HousingLevyDtls,\"Y\",\"E\")","isMandatory(HousingLevyDtls,\"Y\",\"F\")","isMandatory(HousingLevyDtls,\"Y\",\"G\")"]
["ErrorMessage","Member Number (ID Number) is mandatory field","Member Name is mandatory field","KRA PIN is mandatory field","Gross salary is mandatory field","Basic salary is mandatory field","Member Contribution – Housing Levy (A) is mandatory field","Employer Contribution (B) is mandatory field"]
["ValidationRule2","validateLength(HousingLevyDtls,15,\"A\")","validateLength(HousingLevyDtls,50,\"B\")","validateTaxPyrPIN(HousingLevyDtls,\"C\")","validateCurrencyFormat(HousingLevyDtls,\"D\")","validateCurrencyFormat(HousingLevyDtls,\"E\")","validateCurrencyFormat(HousingLevyDtls,\"F\")","validateCurrencyFormat(HousingLevyDtls,\"G\")"]
["ErrorMessage","Please enter data of length upto 15 only","Please enter data of length upto 50 only","Please enter Individual KRA PIN in proper format.","Please enter numeric value only","Please enter numeric value only","Member Contribution should be numeric only","Employer Contribution should be numeric only"]
["ValidationRule3","validateAlphaNumericOnly(HousingLevyDtls,\"A\")","validateAlphaNumeric(HousingLevyDtls,\"B\")"]
["ErrorMessage","Please enter numeric value.","Please enter alphanumeric value. Special characters  are  not allowed."]
[]
["M1_NITA_Levy_Dtls","NITA Employee Number","NITA Employee Name","KRA PIN","Standard NITA Deduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section M1 : Details of NITA Levy"]
["Mandatory","Y","Y","Y","Y"]
["MaxLength",50,50,11]
["ValidationRule1","isMandatory(NITALevyDtls,\"Y\",\"A\")","isMandatory(NITALevyDtls,\"Y\",\"B\")","isMandatory(NITALevyDtls,\"Y\",\"C\")","isMandatory(NITALevyDtls,\"Y\",\"D\")"]
["ErrorMessage","NITA Employee Number is mandatory field","NITA Employee is mandatory field","KRA PIN is mandatory field","Standard NITA Deduction is mandatory field"]
["ValidationRule2","validateLength(NITALevyDtls,50,\"A\")","validateLength(NITALevyDtls,50,\"B\")","validateNITAPIN(NITALevyDtls,\"C\")","validateCurrencyFormat(NITALevyDtls,\"D\")"]
["ErrorMessage","Please enter data of length upto 50 only","Please enter data of length upto 50 only","Please enter Individual KRA PIN in proper format.","Please enter numeric value only"]
["ValidationRule3","validateAlphaNumericOnly(NITALevyDtls,\"A\")","validateAlphaNumeric(NITALevyDtls,\"B\")"]
["ErrorMessage","Please enter alphanumeric value. Special characters  are  not allowed.","Please enter alphanumeric value. Special characters  are  not allowed."]

{"sheet":"Macros_Disabled","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"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":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,1,0,2],[1,0,1,1]]}
[null,"PAYE Monthly Return"]
["Section A : Return Information",null,"Version 26.0.10"]
["Employer's Personal Identification Number *",null,"HOET"]
["Type of Return *",null,"12"]
["Entity Type *"]
["Return Period From *",null,"01/12/2024"]
["Return Period To *",null,"31/12/2024"]
[{"$f":"IF(B8<>\"\",CONCATENATE(\"01/01/\",B8),\"\")","v":"01/01/2016"},{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",RIGHT(RtnInf.RtnPrdFrom,4),2016)","v":2016},"01/12/2023"]
[{"$f":"IF(RtnInf.RtnPrdFrom<>\"\",MID(RtnInf.RtnPrdFrom,4,2),1)","v":1},"December","01/12/2019"]
[{"$f":"RIGHT(C2,LEN(C2)-8)","v":"26.0.10"},{"$f":"obligationId","v":"7"}]
[{"$f":"templateType","v":"XLSM"},{"$f":"officeVersion","v":"EXCEL 2010-2013"}]
[{"$f":"moduleId","v":"2"},{"$f":"formId","v":"47"},"2017"]

{"sheet":"B_Employees_Dtls","index":7,"n_rows":8,"n_cols":41,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,0,6,32],[7,0,7,32],[0,0,0,33],[1,0,2,3],[1,4,2,12],[1,13,2,15],[1,16,2,16],[1,17,2,21],[1,22,2,22],[1,23,1,28],[1,29,2,34],[2,23,2,25],[2,26,2,28]]}
["Section B : Details of Salary Paid and PAYE deducted from Employee(s)"]
[null,null,null,null,"Cash Pay (Ksh)",null,null,null,null,null,null,null,null,"Non Cash Benefits (Ksh)",null,null,null,"Housing Benefit (Ksh)",null,null,null,null,null,"Allowable Deductions (Ksh)"]
[]
["PIN of Employee","Name of Employee","Resident Status","Type of Employee","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Total Cash Pay (A)","Value of Car Benefit (\"Value of Car Benefit\" from D_Computation_of_\nCar_Benefit)(B)","Other Non Cash Benefits (C)","Total Non Cash Benefits (D)=(C+E)","Value of Meals (E)","Type of Housing","Rent of House/Market Value","Computed Rent of House (F)","Rent Recovered from Employee (G)","Net Value of Housing (Ksh) (H) = (F - G)","Total Gross Pay (Ksh) (I) = (A + D + E + H+B))","Social Health Insurance Fund (J)","Actual Contribution (K)","Post Retirement Medical Fund (L)","Mortgage Interest (M)","Affordable Housing Levy (N)","Amount of Benefit (O) = (K+M)","Taxable Pay (Kshs) (P) = (I-J-L-N-O)","Tax Payable (Ksh) (Q) = (P)*Slab Rate","Monthly Personal Relief (Ksh) ( R ) ",{"$f":"IF(OR(RtnInf.RtnYear=\"2023\",AND(RtnInf.RtnMonth<\"12\",RtnInf.RtnYear=\"2024\")),\"Amount of Insurance/PRMF Relief (Total of \"\"Amount of Insurance/PRMF Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (S)\",\"Amount of Insurance Relief (Total of \"\"Amount of Insurance Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (S)\")","v":"Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_Insu_Relief) (Ksh) (S)"},"PAYE Tax(Ksh)(T) = (Q - R - S - N)","Self Assessed PAYE Tax (Ksh)"]
["",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",SUM(E5:L5))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(O5>5000,IF(Q5>5000,(O5+Q5-5000),(O5)),IF(Q5>5000,(Q5-5000),(0))),IF(O5>3000,SUM(N5:O5),N5)))","v":""},null,null,null,{"$f":"IF(A5=\"\",\"\",IF(AK5=\"\",0,IF(AK5=\"0\",0,IF(AK5=\"3\",10*(SUM(M5,P5))/100,IF(AK5=\"4\",IF(Q5=\"\",0,15*Q5/100),IF((15*(SUM(M5,P5))/100)>S5,(15*(SUM(M5,P5))/100),S5))))))","v":""},null,{"$f":"IF(A5=\"\",\"\",IF(ROUND(T5,2)-ROUND(U5,2)<0,0,ROUND(T5,2)-ROUND(U5,2)))","v":""},{"$f":"IF(A5=\"\",\"\",IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),SUM(M5,P5,V5,N5),SUM(M5,P5,Q5,V5,N5)))","v":""},null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",IF(Y5<>\"\",IF(AN5<Y5,IF(AN5<AO5,AN5,AO5),IF(Y5<AO5,Y5,AO5)),IF(AN5<AO5,AN5,AO5))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AA5>25000,25000,AA5),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AA5>30000,30000,AA5),IF(AA5>AB5,AA5,AB5)))))","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A5=\"\",\"\",IF((ROUND(W5,2)-ROUND(AC5,2)-ROUND(X5,2)-IF(ROUND(Z5,2)>15000,15000,ROUND(Z5,2))-ROUND(AB5,2))<0,\"0\",ROUND(W5,2)-ROUND(AC5,2)-ROUND(X5,2)-IF(ROUND(Z5,2)>15000,15000,ROUND(Z5,2))-ROUND(AB5,2))),IF(A5=\"\",\"\",ROUND(W5,2)-ROUND(AC5,2)))","v":""},{"$f":"IF(AD5=\"\",\"\",getTotalTaxPayble(AD5,D5,RtnInf.RtnYear))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AE5-AF5-AG5-AB5<0,0,AE5-AF5-AG5-AB5),IF(AE5-AF5-AG5<0,0,AE5-AF5-AG5)))","v":""},null,{"$f":"IFERROR(LOOKUP(D5,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(R5,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C5,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A5=\"\",\"\",\"DTEMP\")","v":""},{"$f":"IF(M5=\"\",\"\",IF(AND(C5=\"Resident\",D5=\"Primary Employee\"),30*M5/100,\"0.00\"))","v":""},{"$f":"IF(A5=\"\",\"\",IF(AND(C5=\"Resident\",D5=\"Primary Employee\"),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),30000,20000),\"0.00\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",SUM(E6:L6))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(O6>5000,IF(Q6>5000,(O6+Q6-5000),(O6)),IF(Q6>5000,(Q6-5000),(0))),IF(O6>3000,SUM(N6:O6),N6)))","v":""},null,null,null,{"$f":"IF(A6=\"\",\"\",IF(AK6=\"\",0,IF(AK6=\"0\",0,IF(AK6=\"3\",10*(SUM(M6,P6))/100,IF(AK6=\"4\",IF(Q6=\"\",0,15*Q6/100),IF((15*(SUM(M6,P6))/100)>S6,(15*(SUM(M6,P6))/100),S6))))))","v":""},null,{"$f":"IF(A6=\"\",\"\",IF(ROUND(T6,2)-ROUND(U6,2)<0,0,ROUND(T6,2)-ROUND(U6,2)))","v":""},{"$f":"IF(A6=\"\",\"\",IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),SUM(M6,P6,V6,N6),SUM(M6,P6,Q6,V6,N6)))","v":""},null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",IF(Y6<>\"\",IF(AN6<Y6,IF(AN6<AO6,AN6,AO6),IF(Y6<AO6,Y6,AO6)),IF(AN6<AO6,AN6,AO6))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AA6>25000,25000,AA6),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AA6>30000,30000,AA6),IF(AA6>AB6,AA6,AB6)))))","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A6=\"\",\"\",IF((ROUND(W6,2)-ROUND(AC6,2)-ROUND(X6,2)-IF(ROUND(Z6,2)>15000,15000,ROUND(Z6,2))-ROUND(AB6,2))<0,\"0\",ROUND(W6,2)-ROUND(AC6,2)-ROUND(X6,2)-IF(ROUND(Z6,2)>15000,15000,ROUND(Z6,2))-ROUND(AB6,2))),IF(A6=\"\",\"\",ROUND(W6,2)-ROUND(AC6,2)))","v":""},{"$f":"IF(AD6=\"\",\"\",getTotalTaxPayble(AD6,D6,RtnInf.RtnYear))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AE6-AF6-AG6-AB6<0,0,AE6-AF6-AG6-AB6),IF(AE6-AF6-AG6<0,0,AE6-AF6-AG6)))","v":""},null,{"$f":"IFERROR(LOOKUP(D6,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(R6,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C6,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A6=\"\",\"\",\"DTEMP\")","v":""},{"$f":"IF(M6=\"\",\"\",IF(AND(C6=\"Resident\",D6=\"Primary Employee\"),30*M6/100,\"0.00\"))","v":""},{"$f":"IF(A6=\"\",\"\",IF(AND(C6=\"Resident\",D6=\"Primary Employee\"),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),30000,20000),\"0.00\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH5:OFFSET(DtlsSalPdBftsPayeDedFrmEmpListTO,-1,0))","v":0},{"$f":"SUM(AI5:OFFSET(DtlsSalPdBftsSelfPayTaxListTO,-1,0))","v":0}]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH5:OFFSET(DtlsSalPdBftsPayeDedFrmEmpListTO,-1,0))","v":0},{"$f":"SUM(AI5:OFFSET(DtlsSalPdBftsSelfPayTaxListTO,-1,0))","v":0}]

{"sheet":"C_Disabled_Employees_Dtls","index":8,"n_rows":9,"n_cols":43,"rows_kept":9,"cut":false,"hidden":true,"merged":[[7,0,7,34],[0,0,0,36],[1,0,2,4],[1,5,2,13],[1,14,2,16],[1,17,2,17],[1,18,2,22],[1,23,2,23],[1,24,1,29],[1,30,2,36],[2,24,2,26],[2,27,2,29]]}
["Section C : Details of Salary and Benefits paid and PAYE deducted from Persons with Disability"]
[null,null,null,null,null,"Cash Pay (Ksh)",null,null,null,null,null,null,null,null,"Non Cash Benefits (Ksh)",null,null,null,"Housing Benefit (Ksh)",null,null,null,null,null,"Allowable Deductions (Ksh)"]
[]
["PIN of Employee","Name of Employee","Resident Status","Type of Employee","Exemption Certificate Number","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Total Cash Pay (A)","Value of Car Benefit (\"Value of Car Benefit\" from D_Computation_\nof_Car_Benefit) (B)","Other Non Cash Benefits (C)","Total Non Cash Benefits (D)=(C+E)","Value of Meals (E)","Global Income (In case of non full time service Director) (Ksh) (E)","Rent of House/Market Value","Computed Rent of House (F)","Rent Recovered from Employee (G)","Net Value of Housing (Ksh) (H) = (F - G)","Total Gross Pay (Ksh) (I) = (A + D + E + H)","Social Health Insurance Fund (J)","30% of Cash Pay (J) = (A)*30%","Post Retirement Medical Fund (L)","Mortgage Interest(M)","Affordable Housing Levy (N)","Amount of Benefit (O) = (K+M)","Amount of Benefit (O) = (Lower of J,K,L + M)","Taxable Pay (Kshs) (P) = (I-J-L-N-O)","Tax Payable (Ksh) (R) = (Q)*Slab Rate","Monthly Personal Relief (Ksh) ( R ) ",{"$f":"IF(OR(RtnInf.RtnYear=\"2023\",AND(RtnInf.RtnMonth<\"12\",RtnInf.RtnYear=\"2024\")),\"Amount of Insurance/PRMF Relief (Total of \"\"Amount of Insurance/PRMF Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (S)\",\"Amount of Insurance Relief (Total of \"\"Amount of Insurance Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (S)\")","v":"Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_Insu_Relief) (Ksh) (S)"},"PAYE Tax (Ksh) (U) = (R-S-T-N)","Self Assessed PAYE Tax (Ksh)"]
["",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",SUM(F5:M5))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(P5>5000,IF(R5>5000,(P5+R5-5000),(P5)),IF(R5>5000,(R5-5000),(0))),IF(P5>3000,SUM(O5:P5),O5)))","v":""},null,null,null,{"$f":"IF(A5=\"\",\"\",IF(AM5=\"\",0,IF(AM5=\"0\",0,IF(AM5=\"3\",10*(SUM(N5,Q5))/100,IF(AM5=\"4\",IF(R5=\"\",0,R5*15/100),IF((15*(SUM(N5,Q5))/100)>T5,(15*(SUM(N5,Q5))/100),T5))))))","v":""},null,{"$f":"IF(A5=\"\",\"\",IF(ROUND(U5,2)-ROUND(V5,2)<0,0,ROUND(U5,2)-ROUND(V5,2)))","v":""},{"$f":"IF(A5=\"\",\"\",SUM(N5,Q5,R5,W5))","v":""},null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",IF(Z5<>\"\",IF(AP5<Z5,IF(AP5<AQ5,AP5,AQ5),IF(Z5<AQ5,Z5,AQ5)),IF(AP5<AQ5,AP5,AQ5))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AB5>25000,25000,AB5),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AB5>30000,30000,AB5),IF(AB5>AC5,AB5,AC5)))))","v":""},{"$f":"IF(A5=\"\",\"\",150000)","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A5=\"\",\"\",IF((ROUND(X5,2)-ROUND(AD5,2)-ROUND(Y5,2)-IF(ROUND(AA5,2)>15000,15000,ROUND(AA5,2))-ROUND(AC5,2))<0,\"0\",ROUND(X5,2)-ROUND(AD5,2)-ROUND(Y5,2)-IF(ROUND(AA5,2)>15000,15000,ROUND(AA5,2))-ROUND(AC5,2))),IF(A5=\"\",\"\",ROUND(X5,2)-ROUND(AD5,2)))","v":""},{"$f":"IF(AF5=\"\",\"\",getTotalTaxPayble(AF5,D5,RtnInf.RtnYear))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AG5-AH5-AI5-AC5<0,0,AG5-AH5-AI5-AC5),IF(AG5-AH5-AI5<0,0,AG5-AH5-AI5)))","v":""},null,{"$f":"IFERROR(LOOKUP(D5,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(S5,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C5,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A5=\"\",\"\",\"DTDSBEMP\")","v":""},{"$f":"IF(N5=\"\",\"\",IF(AND(C5=\"Resident\",D5=\"Primary Employee\"),30*N5/100,\"0.00\"))","v":""},{"$f":"IF(A5=\"\",\"\",IF(AND(C5=\"Resident\",D5=\"Primary Employee\"),20000,\"0.00\"))","v":""}]
["",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",SUM(F6:M6))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(P6>5000,IF(R6>5000,(P6+R6-5000),(P6)),IF(R6>5000,(R6-5000),(0))),IF(P6>3000,SUM(O6:P6),O6)))","v":""},null,null,null,{"$f":"IF(A6=\"\",\"\",IF(AM6=\"\",0,IF(AM6=\"0\",0,IF(AM6=\"3\",10*(SUM(N6,Q6))/100,IF(AM6=\"4\",IF(R6=\"\",0,R6*15/100),IF((15*(SUM(N6,Q6))/100)>T6,(15*(SUM(N6,Q6))/100),T6))))))","v":""},null,{"$f":"IF(A6=\"\",\"\",IF(ROUND(U6,2)-ROUND(V6,2)<0,0,ROUND(U6,2)-ROUND(V6,2)))","v":""},{"$f":"IF(A6=\"\",\"\",SUM(N6,Q6,R6,W6))","v":""},null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",IF(Z6<>\"\",IF(AP6<Z6,IF(AP6<AQ6,AP6,AQ6),IF(Z6<AQ6,Z6,AQ6)),IF(AP6<AQ6,AP6,AQ6))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AB6>25000,25000,AB6),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AB6>30000,30000,AB6),IF(AB6>AC6,AB6,AC6)))))","v":""},{"$f":"IF(A6=\"\",\"\",150000)","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A6=\"\",\"\",IF((ROUND(X6,2)-ROUND(AD6,2)-ROUND(Y6,2)-IF(ROUND(AA6,2)>15000,15000,ROUND(AA6,2))-ROUND(AC6,2))<0,\"0\",ROUND(X6,2)-ROUND(AD6,2)-ROUND(Y6,2)-IF(ROUND(AA6,2)>15000,15000,ROUND(AA6,2))-ROUND(AC6,2))),IF(A6=\"\",\"\",ROUND(X6,2)-ROUND(AD6,2)))","v":""},{"$f":"IF(AF6=\"\",\"\",getTotalTaxPayble(AF6,D6,RtnInf.RtnYear))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AG6-AH6-AI6-AC6<0,0,AG6-AH6-AI6-AC6),IF(AG6-AH6-AI6<0,0,AG6-AH6-AI6)))","v":""},null,{"$f":"IFERROR(LOOKUP(D6,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(S6,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C6,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A6=\"\",\"\",\"DTDSBEMP\")","v":""},{"$f":"IF(N6=\"\",\"\",IF(AND(C6=\"Resident\",D6=\"Primary Employee\"),30*N6/100,\"0.00\"))","v":""},{"$f":"IF(A6=\"\",\"\",IF(AND(C6=\"Resident\",D6=\"Primary Employee\"),20000,\"0.00\"))","v":""}]
[]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ5:OFFSET(DtlsSalPdBftsPayeDedFrmDsblEmpListTO,-1,0))","v":0},{"$f":"SUM(AK5:OFFSET(DtlsSalPdBftsSelfPayTaxDEListTO,-1,0))","v":0}]
[null,null,null,"DtlsSalPdBftsPayeDedFrmEmp_List"]

{"sheet":"D_Computation_of_Car_Benefit","index":9,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,9],[4,0,4,8]]}
["Section D : Computation of Value of Car Benefit"]
["PIN of Employee","Reference to Section","Car Registration Number","Make","Body Type","CC Rating","Type of Car Cost","Cost of Hiring / Leasing (Ksh)","Cost of Owned Car (Ksh)","Value of Car Benefit (Ksh)"]
["",null,null,null,null,null,null,null,null,{"$f":"IF(AND(I3<>\"\",I3<>0),IF(E3=\"\",\"\",ROUND(IF(E3=\"Saloon Hatch Backs and Estates\",IF(LOOKUP(F3,{0,1201,1501,1751,2001,3001},{43200,50400,69600,86400,103200,172800})/12>(I3*2%),LOOKUP(F3,{0,1201,1501,1751,2001,3001},{43200,50400,69600,86400,103200,172800})/12,I3*2%),IF(E3=\"Pick Ups, Panel Vans Uncovered\",IF(LOOKUP(F3,{0,1751},{43200,50400})/12>(I3*2%),LOOKUP(F3,{0,1751},{43200,50400})/12,I3*2%),IF(E3=\"Land Rovers/ Cruisers(excludes Range Rovers and vehicles of similar nature)\",IF(86400/12>I3*2%,86400/12,I3*2%),0))),2)),IF(H3=\"\",\"\",ROUND(H3,2)))","v":""},{"$f":"IFERROR(LOOKUP(E3,SortedBodyType,BodyTypeCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(G3,SortedCarType,CarTypeCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(B3,RefSchedules,RefSchedulesCode),\"\")","v":""},{"$f":"CONCATENATE(A3,B3)","v":""},{"$f":"CONCATENATE(A3,C3)","v":""}]
["",null,null,null,null,null,null,null,null,{"$f":"IF(AND(I4<>\"\",I4<>0),IF(E4=\"\",\"\",ROUND(IF(E4=\"Saloon Hatch Backs and Estates\",IF(LOOKUP(F4,{0,1201,1501,1751,2001,3001},{43200,50400,69600,86400,103200,172800})/12>(I4*2%),LOOKUP(F4,{0,1201,1501,1751,2001,3001},{43200,50400,69600,86400,103200,172800})/12,I4*2%),IF(E4=\"Pick Ups, Panel Vans Uncovered\",IF(LOOKUP(F4,{0,1751},{43200,50400})/12>(I4*2%),LOOKUP(F4,{0,1751},{43200,50400})/12,I4*2%),IF(E4=\"Land Rovers/ Cruisers(excludes Range Rovers and vehicles of similar nature)\",IF(86400/12>I4*2%,86400/12,I4*2%),0))),2)),IF(H4=\"\",\"\",ROUND(H4,2)))","v":""},{"$f":"IFERROR(LOOKUP(E4,SortedBodyType,BodyTypeCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(G4,SortedCarType,CarTypeCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(B4,RefSchedules,RefSchedulesCode),\"\")","v":""},{"$f":"CONCATENATE(A4,B4)","v":""},{"$f":"CONCATENATE(A4,C4)","v":""}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J3:OFFSET(CarBenefitListTO,-1,0))","v":0}]

{"sheet":"Data","index":10,"n_rows":132,"n_cols":30,"rows_kept":132,"cut":false,"hidden":true,"merged":[]}
["ReturnType","ReturnTypeCode","Boolean","TypeOfEmp","TypeOFEmpCode",null,"TypeOfHousing","TypeOfHousingCode","SortedTypeOfHousing",null,"RefSchedules","RefSchedulesCode","CarTypeCode","CarType","SortedCarType",null,"BodyType","BodyTypeCode","SortedBodyType",null,"EntityType","EntityCode","SortedEntityCode",null,null,null,"Lump Sum Payment Due Year","SlabStart","SlabEnd","Rate"]
["Original","ORIGINAL","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",null,null,null,"2000","0","116160","10"]
["Amended","AMENDED","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",null,null,null,null,"116161","225600","15"]
[null,null,null,null,null,null,"Employer's Rented House","1","Employer's Owned House",null,"G_Arrears_Dtls_E","SCH6",null,null,null,null,"Land Rovers/ Cruisers(excludes Range Rovers and vehicles of similar nature)","SLNHTCH","Saloon Hatch Backs and Estates",null,null,null,null,null,null,null,null,"225601","335040","20"]
[null,null,null,null,null,null,"Agriculture Farm","2","Employer's Rented House",null,"H_Arrears_Dtls_DE","SCH7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
["MonthsList","Month","SortedMonthList",null,"PurposeOfPolicy","PolicyCode","House to Non full time service Director","4","House to Non full time service Director",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
["January","04","April","01","Education","EDU",null,"PolicyHolder","PolicyHolderCode",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001","0","116160","10"]
["February","08","August","02","Health","HLTH",null,"Child","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116161","225600","15"]
["March","12","December","03","Life","LIFE",null,"Self","S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"225601","335040","20"]
["April","02","February","04",null,null,null,"Wife","W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
["May","01","January","05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
["June","07","July","06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2002","0","116160","10"]
["July","06","June","07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116161","225600","15"]
["August","03","March","08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"225601","335040","20"]
["September","05","May","09",null,"Sorted Resident Status","Resident Status","Code for Resident Status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
["October","11","November","10",null,"Non-Resident","Resident","NONRES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
["November","10","October","11",null,"Resident","Non-Resident","RES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2003","0","116160","10"]
["December","09","September","12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116161","225600","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"225601","335040","20"]
["YearList","OtherYear","ValidationErrorMsgs",null,"OtherYear2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
[2005,"1999"," in proper format(dd/mm/yyyy).",null,"2000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
[2006,"2000","Please enter Date between Return Period specified and in dd/mm/yyyy proper format.",null,"2001",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2004","0","116160","10"]
[2007,"2001"," cannot be the current/future date.",null,"2002",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116161","225600","15"]
[2008,"2002"," can not be same as  Taxpayer's PIN.",null,"2003",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"225601","335040","20"]
[2009,"2003","Please enter numeric value only.",null,"2004",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
[2010,"2004","Please enter alphanumeric value. Only Special characters like (space , . / - :) are allowed.",null,"2005",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
[2011,"2005","Please enter alphanumeric value. Special characters  are  not allowed.",null,"2006",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2005","0","121968","10"]
[2012,"2006","Please enter alphabetic value Only.",null,"2007",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[2013,"2007"," is Mandatory field.",null,"2008",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[2014,"2008","Please enter numeric value greater than zero.",null,"2009",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[2015,"2009"," should be before Return Period in Section A.",null,"2010",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
["2016","2010"," should be greater than Employment Start Date.",null,"2011",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2006","0","121968","10"]
["2017","2011"," should be before or same as Year of Income in Section A.",null,"2012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
["2018","2012"," should be same as Year of Income in Section A.",null,2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[2019,"2013"," should be same as Return for the Month in Section A.",null,2014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[2020,"2014",null,null,2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[2021,"2015",null,null,"2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2007","0","121968","10"]
[2022,"2016",null,null,"2017",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
["2023","2017",null,null,"2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
["2024","2018",null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[2025,"2019",null,null,2020,"2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
["47","2020",null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2008","0","121968","10"]
["7","2021",null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
["XLSM","2022",null,null,"2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
["EXCEL 2010-2013","2023",null,null,"2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,"2024",null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
["Genrate Uploadeble Xml ?",2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2009","0","121968","10"]
["Y",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
["visibleSheetsArr (List of Sheets which should be visible when macros are enabled)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
["Read Me:Errors:Macros_Disabled:A_Basic_Info:B_Employees_Dtls:C_Disabled_Employees_Dtls:D_Computation_of_Car_Benefit:E_Computation_of_Insu_Relief:F_Lump_Sum_Payments_Dtls:G_Arrears_Dtls_E:H_Arrears_Dtls_DE:I_Gratuity_Dtls:J_FBT_Dtls:K_PAYE_Payment_Credits:M_Affordable Housing Levy_Dtls:N_Tax_Due",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2011","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1999","0","116160","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116161","225600","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"225601","335040","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1998","0","116160","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116161","225600","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"225601","335040","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"335041","444480","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"444481",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016","0","121968","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"121969","236880","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"236881","351792","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"351793","466704","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"466705",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017","0","134164","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"134165","260567","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"260568","386970","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"386971","513373","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"513374",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018","0","147576","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"147577","286620","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"286621","425664","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"425665","564708","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"564709",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019","0","147576","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"147577","286620","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"286621","425664","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"425665","564708","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"564709",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020","0","147576","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"147577","286620","15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"286621","425664","20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"425665","564708","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"564709",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021","0","288000","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"288001","388000","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"388001",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022","0","288000","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"288001","388000","25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"388001",null,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,0,288000,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,288001,388000,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,388001,6000000,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6000001,9600000,32.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9600001,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,0,288000,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,288001,388000,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,388001,6000000,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6000001,9600000,32.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9600001,null,35]

{"sheet":"E_Computation_of_Insu_Relief","index":11,"n_rows":5,"n_cols":18,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,13],[4,0,4,11]]}
["Section E : Details of Insurance Relief"]
["PIN of Employee","Reference to Section","PIN of Insurance Company","Name of Insurance Company","Purpose of Policy","Insurance Policy Number","Policy Holder","Age of Child","Commencement Date","Maturity Date","Sum Assured (Ksh)","Premium paid till month (Ksh) (A)","Date of payment of premium","Amount of Insurance Relief (Ksh)(A) * 15%"]
["","","","","","","","","","","","","","",{"$f":"IFERROR(LOOKUP(E3,PurposeOfPolicy,PolicyCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(G3,HolderPolicy,HolderPolicyCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(B3,RefSchedules,RefSchedulesCode),\"\")","v":""},{"$f":"CONCATENATE(A3,B3)","v":""}]
["","","","","","","","","","","","","","",{"$f":"IFERROR(LOOKUP(E4,PurposeOfPolicy,PolicyCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(G4,HolderPolicy,HolderPolicyCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(B4,RefSchedules,RefSchedulesCode),\"\")","v":""},{"$f":"CONCATENATE(A4,B4)","v":""}]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N3:OFFSET(InsReliefDtlsListTO,-1,0))","v":0}]

{"sheet":"F_Lump_Sum_Payments_Dtls","index":12,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,11],[4,0,4,10]]}
["Section F : Calculation of PAYE Tax on Lump Sum Payments Paid after Termination"]
["PIN of Employee","Name of Employee","Employment Start Date","Employment End Date","Lump Sum Payment Due Year","Lump Sum Payment Paid Year","Amount of Gross Lump Sum Payment (Ksh) (A)","Emoluments of Lump Sum Payment Due Year (Ksh) / Emoluments of Lump Sum Payment Due Month (Ksh) (B)","Total Revised Income (Ksh) (C)= (A+B)","PAYE Deducted on Revised Income (Ksh) (D)","PAYE Paid in Lump Sum Payment Due Year (Ksh) / Lump Sum Payment Due Month (Ksh) (E)","Amount of PAYE Tax Payable (Ksh) (F) = (D - E)"]
["",null,null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"\",SUM(G3:H3))","v":""},{"$f":"IF(E3=\"\",\"\",IF(I3=\"\",0,getTaxPayableFromYear(E3,I3)))","v":""},null,{"$f":"IF(A3=\"\",\"\",IF(J3=\"\",\"\",IF(ROUND(J3,2)-ROUND(K3,2)<0,0,ROUND(J3,2)-ROUND(K3,2))))","v":""}]
["",null,null,null,null,null,null,null,{"$f":"IF(A4=\"\",\"\",SUM(G4:H4))","v":""},{"$f":"IF(E4=\"\",\"\",IF(I4=\"\",0,getTaxPayableFromYear(E4,I4)))","v":""},null,{"$f":"IF(A4=\"\",\"\",IF(J4=\"\",\"\",IF(ROUND(J4,2)-ROUND(K4,2)<0,0,ROUND(J4,2)-ROUND(K4,2))))","v":""}]
["Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L3:OFFSET(TaxPdOnLumpSumPdAftrTrmtnListTO,-1,0))","v":0}]

{"sheet":"G_Arrears_Dtls_E","index":13,"n_rows":7,"n_cols":46,"rows_kept":7,"cut":false,"hidden":true,"merged":[[6,0,6,36],[0,0,0,38],[1,0,2,5],[1,6,2,14],[1,15,2,17],[1,18,2,18],[1,19,2,23],[1,24,2,24],[1,25,1,30],[1,31,2,38],[2,25,2,27],[2,28,2,30]]}
["Section G : Details of Arrears of Salary and  Benefits paid and PAYE deducted from Employee(s)"]
[null,null,null,null,null,null,"Cash Pay (Ksh)",null,null,null,null,null,null,null,null,"Non Cash Benefits (Ksh)",null,null,null,"Housing Benefit (Ksh)",null,null,null,null,null,"Allowable Deductions (Ksh)"]
[]
["PIN of Employee","Name of Employee","Arrears for the Month","Arrears Year","Resident Status","Type of Employee","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Total Cash Pay (A)","Value of Car Benefit (\"Value of Car Benefit\" from D_Computation\n_of_Car_Benefit) (B)","Other Non Cash Benefits ( C )","Total Non Cash Benefits (D)=(C+E)","Value of Meals (E)","Type of Housing","Rent of House/Market Value","Computed Rent of House (F)","Rent Recovered from Employee (G)","Value of Housing (Ksh) (H) = (F - G)","Total Gross Pay (Ksh) (I) = (A+D+E+H)","Social Health Insurance Fund (J)","Actual Contribution (K)","Post Retirement Medical Fund (L)","Mortgage Interest (M)","Affordable Housing Levy (N)","Amount of Benefit (O) = (K+M)","Taxable Pay (Kshs) (P) = (I-J-L-N-O)","Tax Payable (Ksh) (Q) = (P)*Slab Rate","Monthly Personal Relief (Ksh) ( R ) ",{"$f":"IF(OR(RtnInf.RtnYear=\"2023\",AND(RtnInf.RtnMonth<\"12\",RtnInf.RtnYear=\"2024\")),\"Amount of Insurance/PRMF Relief (Total of \"\"Amount of Insurance/PRMF Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (S)\",\"Amount of Insurance Relief (Total of \"\"Amount of Insurance Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (S)\")","v":"Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_Insu_Relief) (Ksh) (S)"},"PAYE Tax (Ksh) (T) = (Q - R - S - N)","Amount of PAYE Already Paid (Ksh) (U)","Final PAYE Tax (Ksh) (V) = (T - U)","Self Assessed PAYE Tax (Ksh)"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",SUM(G5:N5))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(Q5>5000,IF(S5>5000,(P5+S5-5000),(Q5)),IF(S5>5000,(S5-5000),(0))),IF(Q5>3000,SUM(P5:Q5),P5)))","v":""},null,null,null,{"$f":"IF(A5=\"\",\"\",IF(AO5=\"\",0,IF(AO5=\"0\",0,IF(AO5=\"3\",10*(SUM(O5,R5))/100,IF(AO5=\"4\",IF(S5=\"\",0,S5*15/100),IF((15*(SUM(O5,R5))/100)>U5,(15*(SUM(O5,R5))/100),U5))))))","v":""},null,{"$f":"IF(A5=\"\",\"\",ROUND(V5,2)-ROUND(W5,2))","v":""},{"$f":"IF(A5=\"\",\"\",SUM(O5,R5,S5,X5))","v":""},null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",IF(AA5<>\"\",IF(AS5<AA5,IF(AS5<AT5,AS5,AT5),IF(AA5<AT5,AA5,AT5)),IF(AS5<AT5,AS5,AT5))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AC5>25000,25000,AC5),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AC5>30000,30000,AC5),IF(AC5>AD5,AC5,AD5)))))","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A5=\"\",\"\",IF((ROUND(Y5,2)-ROUND(AE5,2)-ROUND(Z5,2)-IF(ROUND(AB5,2)>15000,15000,ROUND(AB5,2))-ROUND(AD5,2))<0,\"0\",ROUND(Y5,2)-ROUND(AE5,2)-ROUND(Z5,2)-IF(ROUND(AB5,2)>15000,15000,ROUND(AB5,2))-ROUND(AD5,2))),IF(A5=\"\",\"\",ROUND(Y5,2)-ROUND(AE5,2)))","v":""},{"$f":"IF(A5=\"\",\"\",getTotalTaxPaybleSecGH(AF5,F5,AP5,D5))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(AND(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AG5-AH5-AI5-AD5<0,0,AG5-AH5-AI5-AD5),IF(AG5-AH5-AI5<0,0,AG5-AH5-AI5)))","v":""},null,{"$f":"IF(A5=\"\",\"\",IF(F5=\"\",\"\",ROUND(AJ5,2)-ROUND(AK5,2)))","v":""},null,{"$f":"IFERROR(LOOKUP(F5,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(T5,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C5,SortedMonthList,MonthCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(E5,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A5=\"\",\"\",\"ADEMP\")","v":""},{"$f":"IF(A5=\"\",\"\",IF(AND(E5=\"Resident\",F5=\"Primary Employee\"),30*O5/100,\"0.00\"))","v":""},{"$f":"IF(A5=\"\",\"\",IF(AND(E5=\"Resident\",F5=\"Primary Employee\"),20000,\"0.00\"))","v":""}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",SUM(G6:N6))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(Q6>5000,IF(S6>5000,(P6+S6-5000),(Q6)),IF(S6>5000,(S6-5000),(0))),IF(Q6>3000,SUM(P6:Q6),P6)))","v":""},null,null,null,{"$f":"IF(A6=\"\",\"\",IF(AO6=\"\",0,IF(AO6=\"0\",0,IF(AO6=\"3\",10*(SUM(O6,R6))/100,IF(AO6=\"4\",IF(S6=\"\",0,S6*15/100),IF((15*(SUM(O6,R6))/100)>U6,(15*(SUM(O6,R6))/100),U6))))))","v":""},null,{"$f":"IF(A6=\"\",\"\",ROUND(V6,2)-ROUND(W6,2))","v":""},{"$f":"IF(A6=\"\",\"\",SUM(O6,R6,S6,X6))","v":""},null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",IF(AA6<>\"\",IF(AS6<AA6,IF(AS6<AT6,AS6,AT6),IF(AA6<AT6,AA6,AT6)),IF(AS6<AT6,AS6,AT6))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AC6>25000,25000,AC6),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AC6>30000,30000,AC6),IF(AC6>AD6,AC6,AD6)))))","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A6=\"\",\"\",IF((ROUND(Y6,2)-ROUND(AE6,2)-ROUND(Z6,2)-IF(ROUND(AB6,2)>16000,16000,ROUND(AB6,2))-ROUND(AD6,2))<0,\"0\",ROUND(Y6,2)-ROUND(AE6,2)-ROUND(Z6,2)-IF(ROUND(AB6,2)>16000,16000,ROUND(AB6,2))-ROUND(AD6,2))),IF(A6=\"\",\"\",ROUND(Y6,2)-ROUND(AE6,2)))","v":""},{"$f":"IF(A6=\"\",\"\",getTotalTaxPaybleSecGH(AF6,F6,AP6,D6))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(AND(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AG6-AH6-AI6-AD6<0,0,AG6-AH6-AI6-AD6),IF(AG6-AH6-AI6<0,0,AG6-AH6-AI6)))","v":""},null,{"$f":"IF(A6=\"\",\"\",IF(F6=\"\",\"\",ROUND(AJ6,2)-ROUND(AK6,2)))","v":""},null,{"$f":"IFERROR(LOOKUP(F6,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(T6,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C6,SortedMonthList,MonthCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(E6,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(A6=\"\",\"\",\"ADEMP\")","v":""},{"$f":"IF(A6=\"\",\"\",IF(AND(E6=\"Resident\",F6=\"Primary Employee\"),30*O6/100,\"0.00\"))","v":""},{"$f":"IF(A6=\"\",\"\",IF(AND(E6=\"Resident\",F6=\"Primary Employee\"),20000,\"0.00\"))","v":""}]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AL5:OFFSET(DtlsArrSalPdBftsPayeDedFrmEmpListTO,-1,0))","v":0},{"$f":"SUM(AM5:OFFSET(DtlsSalPdArrearDEListTO,-1,0))","v":0}]

{"sheet":"H_Arrears_Dtls_DE","index":14,"n_rows":7,"n_cols":48,"rows_kept":7,"cut":false,"hidden":true,"merged":[[6,0,6,38],[0,0,0,40],[1,0,2,6],[1,7,2,15],[1,16,2,18],[1,19,2,19],[1,20,2,24],[1,25,2,25],[1,26,1,31],[1,32,2,40],[2,26,2,28],[2,29,2,31]]}
["Section H : Details of Arrears of Salary and  Benefits paid and PAYE deducted from Persons with Disability"]
[null,null,null,null,null,null,null,"Cash Pay (Ksh)",null,null,null,null,null,null,null,null,"Non Cash Benefits (Ksh)",null,null,null,"Housing Benefit (Ksh)",null,null,null,null,null,"Allowable Deductions (Ksh)"]
[]
["PIN of Employee","Name of Employee","Arrears for the Month","Arrears Year","Residential Status","Type of Employee","Exemption Certificate Number","Basic Salary","Housing Allowance","Transport Allowance","Leave Pay","Over Time Allowance","Director's Fee","Lump Sum Payment if any","Other Allowance","Total Cash Pay (A)","Value of Car Benefit (\"Value of Car Benefit\" from D_Computation\n_of_Car_Benefit) (B)","Other Non Cash Benefits (C)","Total Non Cash Benefits (D)=(C+E)","Value of Meals (E)","Type of Housing","Rent of House/Market Value","Computed Rent of House (F)","Rent Recovered from Employee (G)","Value of Housing (Ksh) (H) = (F - G)","Total Gross Pay (Ksh) (I) = (A+D+E+H)","Social Health Insurance Fund (J)","Actual Contribution (K)","Post Retirement Medical Fund (L)","Mortgage Interest (M)","Affordable Housing Levy (N)","Amount of Benefit (O) = (K+M)","Exemption for Persons with Disability (Ksh) (P)","Taxable Pay (Kshs) (P) = (I-J-L-N-O)","Tax Payable (Ksh) (R) = (Q)*Slab Rate","Monthly Personal Relief (Ksh) ( R ) ",{"$f":"IF(RtnInf.RtnYear>\"2023\",\"Amount of Insurance/PRMF Relief (Total of \"\"Amount of Insurance/PRMF Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (T)\",\"Amount of Insurance Relief (Total of \"\"Amount of Insurance Relief\"\" from E_Computation_of_Insu_Relief) (Ksh) (T)\")","v":"Amount of Insurance Relief (Total of \"Amount of Insurance Relief\" from E_Computation_of_Insu_Relief) (Ksh) (T)"},"PAYE Tax (Ksh) (U) = (R-S-T-N)","Amount of PAYE Already Paid (Ksh) (V)","Final PAYE Tax (Ksh) (W) = (U - V)","Self Assessed PAYE Tax (Ksh)"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",SUM(H5:O5))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(R5>5000,IF(T5>5000,(R5+T5-5000),(R5)),IF(T5>5000,(T5-5000),(0))),IF(R5>3000,SUM(Q5:R5),Q5)))","v":""},null,null,null,{"$f":"IF(A5=\"\",\"\",IF(AQ5=\"\",0,IF(AQ5=\"0\",0,IF(AQ5=\"3\",10*(SUM(P5,S5))/100,IF(AQ5=\"4\",IF(T5=\"\",0,T5*15/100),IF((15*(SUM(P5,S5))/100)>V5,(15*(SUM(P5,S5))/100),V5))))))","v":""},null,{"$f":"IF(A5=\"\",\"\",ROUND(W5,2)-ROUND(X5,2))","v":""},{"$f":"IF(A5=\"\",\"\",SUM(P5,S5,T5,Y5))","v":""},null,null,null,null,null,{"$f":"IF(A5=\"\",\"\",IF(AB5<>\"\",IF(AU5<AB5,IF(AU5<AV5,AU5,AV5),IF(AB5<AV5,AB5,AV5)),IF(AU5<AV5,AU5,AV5))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AD5>25000,25000,AD5),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AD5>30000,30000,AD5),IF(AD5>AE5,AD5,AE5)))))","v":""},{"$f":"IF(A5=\"\",\"\",150000)","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A5=\"\",\"\",IF((ROUND(Z5,2)-ROUND(AF5,2)-ROUND(AA5,2)-IF(ROUND(AC5,2)>15000,15000,ROUND(AC5,2))-ROUND(AE5,2))<0,\"0\",ROUND(Z5,2)-ROUND(AF5,2)-ROUND(AA5,2)-IF(ROUND(AC5,2)>15000,15000,ROUND(AC5,2))-ROUND(AE5,2))),IF(A5=\"\",\"\",ROUND(Z5,2)-ROUND(AF5,2)))","v":""},{"$f":"IF(A5=\"\",\"\",getTotalTaxPaybleSecGH(AH5,F5,AR5,D5))","v":""},null,null,{"$f":"IF(A5=\"\",\"\",IF(AND(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AI5-AJ5-AK5-AE5<0,0,AI5-AJ5-AK5-AE5),IF(AI5-AJ5-AK5<0,0,AI5-AJ5-AK5)))","v":""},null,{"$f":"IF(A5=\"\",\"\",IF(F5=\"\",\"\",ROUND(AL5,2)-ROUND(AM5,2)))","v":""},null,{"$f":"IFERROR(LOOKUP(F5,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(U5,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C5,SortedMonthList,MonthCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(E5,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(B5=\"\",\"\",\"ADDSBEMP\")","v":""},{"$f":"IF(A5=\"\",\"\",IF(AND(E5=\"Resident\",F5=\"Primary Employee\"),30*P5/100,\"0.00\"))","v":""},{"$f":"IF(A5=\"\",\"\",IF(AND(E5=\"Resident\",F5=\"Primary Employee\"),20000,\"0.00\"))","v":""}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",SUM(H6:O6))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(OR(RtnInf.RtnYear>2024,AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024)),IF(R6>5000,IF(T6>5000,(R6+T6-5000),(R6)),IF(T6>5000,(T6-5000),(0))),IF(R6>3000,SUM(Q6:R6),Q6)))","v":""},null,null,null,{"$f":"IF(A6=\"\",\"\",IF(AQ6=\"\",0,IF(AQ6=\"0\",0,IF(AQ6=\"3\",10*(SUM(P6,S6))/100,IF(AQ6=\"4\",IF(T6=\"\",0,T6*15/100),IF((15*(SUM(P6,S6))/100)>V6,(15*(SUM(P6,S6))/100),V6))))))","v":""},null,{"$f":"IF(A6=\"\",\"\",ROUND(W6,2)-ROUND(X6,2))","v":""},{"$f":"IF(A6=\"\",\"\",SUM(P6,S6,T6,Y6))","v":""},null,null,null,null,null,{"$f":"IF(A6=\"\",\"\",IF(AB6<>\"\",IF(AU6<AB6,IF(AU6<AV6,AU6,AV6),IF(AB6<AV6,AB6,AV6)),IF(AU6<AV6,AU6,AV6))+(IF(OR(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<=11,RtnInf.RtnYear=2024)),IF(AD6>25000,25000,AD6),IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(AD6>30000,30000,AD6),IF(AD6>AE6,AD6,AE6)))))","v":""},{"$f":"IF(A6=\"\",\"\",150000)","v":""},{"$f":"IF(OR(AND(RtnInf.RtnMonth>=12,RtnInf.RtnYear=2024),RtnInf.RtnYear>2024),IF(A6=\"\",\"\",IF((ROUND(Z6,2)-ROUND(AF6,2)-ROUND(AA6,2)-IF(ROUND(AC6,2)>16000,16000,ROUND(AC6,2))-ROUND(AE6,2))<0,\"0\",ROUND(Z6,2)-ROUND(AF6,2)-ROUND(AA6,2)-IF(ROUND(AC6,2)>16000,16000,ROUND(AC6,2))-ROUND(AE6,2))),IF(A6=\"\",\"\",ROUND(Z6,2)-ROUND(AF6,2)))","v":""},{"$f":"IF(A6=\"\",\"\",getTotalTaxPaybleSecGH(AH6,F6,AR6,D6))","v":""},null,null,{"$f":"IF(A6=\"\",\"\",IF(AND(AND(RtnInf.RtnMonth>=3,RtnInf.RtnYear=2024),AND(RtnInf.RtnMonth<12,RtnInf.RtnYear=2024)),IF(AI6-AJ6-AK6-AE6<0,0,AI6-AJ6-AK6-AE6),IF(AI6-AJ6-AK6<0,0,AI6-AJ6-AK6)))","v":""},null,{"$f":"IF(A6=\"\",\"\",IF(F6=\"\",\"\",ROUND(AL6,2)-ROUND(AM6,2)))","v":""},null,{"$f":"IFERROR(LOOKUP(F6,TypeOFEmp,TypeOFEmpCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(U6,SortedTypeOfHousing,TypeOfHousingCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(C6,SortedMonthList,MonthCode),\"\")","v":""},{"$f":"IFERROR(LOOKUP(E6,SortedResidentStatus,ResidentStatusCode),\"\")","v":""},{"$f":"IF(B6=\"\",\"\",\"ADDSBEMP\")","v":""},{"$f":"IF(A6=\"\",\"\",IF(AND(E6=\"Resident\",F6=\"Primary Employee\"),30*P6/100,\"0.00\"))","v":""},{"$f":"IF(A6=\"\",\"\",IF(AND(E6=\"Resident\",F6=\"Primary Employee\"),20000,\"0.00\"))","v":""}]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN5:OFFSET(DtlsArrSalPdBftsPayeDedFrmDsblEmpListTO,-1,0))","v":0},{"$f":"SUM(AO5:OFFSET(DtlsArrSalPdBftsPayeSelfPayeListTO,-1,0))","v":0}]

{"sheet":"I_Gratuity_Dtls","index":15,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,7],[4,0,4,6],[7,0,7,7]]}
["Section I : Calculation of PAYE Tax Payable on Gratuity"]
["PIN of Employee","Name of Employee","Gratuity Paid Month","Gratuity Paid Year ","Gratuity Related/ Retirement Year","Gratuity Period in Years","Gratuity Value (Ksh)","Amount of Tax Payable on Gratuity (Ksh)"]
["",null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"\",SUMIF(GratuityPIN,A3,TaxPayable))","v":""},{"$f":"IFERROR(LOOKUP(C3,SortedMonthList,MonthCode),\"\")","v":""},{"$f":"IF(OR(A3<>\"\",B3<>\"\",C3<>\"\",D3<>\"\",E3<>\"\",F3<>\"\",G3<>\"\"),ROW(A3)-2,\"\")","v":""}]
["",null,null,null,null,null,null,{"$f":"IF(A4=\"\",\"\",SUMIF(GratuityPIN,A4,TaxPayable))","v":""},{"$f":"IFERROR(LOOKUP(C4,SortedMonthList,MonthCode),\"\")","v":""},{"$f":"IF(OR(A4<>\"\",B4<>\"\",C4<>\"\",D4<>\"\",E4<>\"\",F4<>\"\",G4<>\"\"),ROW(A4)-2,\"\")","v":""}]
["Total",null,null,null,null,null,null,{"$f":"SUM(H3:OFFSET(CalPayeTaxPyblOnGratIListTO,-1,0))","v":0}]
[]
[]
["Calculation of PAYE Tax Payable on Gratuity for Specific PIN"]
["PIN of Employee","Gratuity Year","Gratuity Value (Ksh) (A)","Taxable Amounts (Ksh) (B)","Total Revised Income (Ksh)(C)=(A+B)","Tax on Revised Income (Ksh) (D)","Tax Deducted plus Reliefs (Ksh)  (E)","Amount of Tax Payable on Gratuity (Ksh) (F) = (D-E)",null,null,"Unwanted Data Entered?"]
[{"$f":"IF(I10=\"\",\"\",IFERROR(INDEX(CalPayeTaxPyblOnGratI.List,MATCH(I10,PINSrNo,0),1),0))","v":""},null,null,null,{"$f":"IF(A10=\"\",\"\",SUM(C10,D10))","v":""},{"$f":"IF(A10=\"\",\"\",getTaxPayableFromYear(B10,E10))","v":""},null,{"$f":"IF(A10=\"\",\"\",IF(F10-G10<0,0,F10-G10))","v":""},null,null,{"$f":"IF(AND(A10=\"\",OR(D10<>\"\",G10<>\"\")),IF(AND(D10<>\"\",G10<>\"\"),\"DG\",IF(D10<>\"\",\"D\",\"G\")),\"\")","v":""}]
[{"$f":"IF(I11=\"\",\"\",IFERROR(INDEX(CalPayeTaxPyblOnGratI.List,MATCH(I11,PINSrNo,0),1),0))","v":""},null,null,null,{"$f":"IF(A11=\"\",\"\",SUM(C11,D11))","v":""},{"$f":"IF(A11=\"\",\"\",getTaxPayableFromYear(B11,E11))","v":""},null,{"$f":"IF(A11=\"\",\"\",IF(F11-G11<0,0,F11-G11))","v":""},null,null,{"$f":"IF(AND(A11=\"\",OR(D11<>\"\",G11<>\"\")),IF(AND(D11<>\"\",G11<>\"\"),\"DG\",IF(D11<>\"\",\"D\",\"G\")),\"\")","v":""}]

{"sheet":"J_FBT_Dtls","index":16,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,10],[4,0,4,9]]}
["Section J : 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) * 25%"]
[null,null,null,null,null,null,{"$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":""}]
["",null,null,null,null,null,{"$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",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K3:OFFSET(FringeBenfTaxCalcListTO,-1,0))","v":0}]

{"sheet":"K_PAYE_Payment_Credits","index":17,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[[12,0,12,1],[0,0,0,2],[1,0,1,2],[5,0,5,1],[7,0,7,2],[11,0,11,1]]}
["Section K : Details of PAYE Tax paid"]
["Section K1 : Advance Payment"]
["Payment Registration Number","Date of Deposit","Amount of PAYE Tax Paid (Ksh)"]
[null,null,null,{"$f":"(IF(A4<>\"\",\"INCMADV\",\"\"))","v":""}]
[null,null,null,{"$f":"(IF(A5<>\"\",\"INCMADV\",\"\"))","v":""}]
["Total",null,{"$f":"ROUND(SUM(C4:OFFSET(DtlsPayeTaxPaidAdvListTO,-1,0)),2)","v":0}]
[]
["Section K2 : Self Assessment Tax"]
["Payment Registration Number","Date of Deposit","Amount of PAYE Tax Paid (Ksh)"]
["",null,null,{"$f":"(IF(A10<>\"\",\"SFASPMT\",\"\"))","v":""}]
[null,null,null,{"$f":"(IF(A11<>\"\",\"SFASPMT\",\"\"))","v":""}]
["Total",null,{"$f":"ROUND(SUM(C10:OFFSET(DtlsPayeSelfAssTaxListTO,-1,0)),2)","v":0}]
["Total (Section K1 Total + Section K2 Total)",null,{"$f":"ROUND(SUM(DtlsPayeTaxPaidAdvListTO,DtlsPayeSelfAssTaxListTO),2)","v":0}]

{"sheet":"M_Affordable Housing Levy_Dtls","index":18,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,7],[4,0,4,6]]}
["Section M : Details of Affordable Housing Levy"]
["Member Number (ID Number)","Member Name","KRA PIN","Gross Salary","Basic Salary","Member Contribution – Housing Levy (A)","Employer Contribution (B)","Total Contribution (A+B) (Ksh)"]
[null,null,"",null,{"$f":"IF(D3<>\"\",(0),\"\")","v":""},{"$f":"IF(D3<>\"\",(D3*1.5%),\"\")","v":""},{"$f":"F3","v":""},{"$f":"IF(AND(F3<>\"\",G3<>\"\"),SUM(F3,G3),\"\")","v":""},null,null,null,null,{"$f":"IF(A3<>\"\",1,0)","v":0}]
[null,null,"",null,{"$f":"IF(D4<>\"\",(0),\"\")","v":""},{"$f":"IF(D4<>\"\",(D4*1.5%),\"\")","v":""},{"$f":"F4","v":""},{"$f":"IF(AND(F4<>\"\",G4<>\"\"),SUM(F4,G4),\"\")","v":""},null,null,null,null,{"$f":"IF(A4<>\"\",1,0)","v":0}]
["Sum of Total Contribution",null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(H3:OFFSET(HousinglevyTo,-1,0)),0)","v":0},null,null,null,null,{"$f":"SUM(M3:OFFSET(HousinglevyTo,-1,6))","v":0}]

{"sheet":"M1_NITA_Levy_Dtls","index":19,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,0,4,2],[0,0,0,3]]}
["Section M1 : Details of NITA Levy"]
["National ID Number","Employee Name","KRA PIN","Standard NITA Deduction"]
["",null,"",null,{"$f":"IF(A3<>\"\",1,0)","v":0}]
["",null,"",null,{"$f":"IF(A4<>\"\",1,0)","v":0}]
["Total",null,null,{"$f":"SUM(D3:OFFSET(NITAlevyTo,-1,0))","v":0},{"$f":"SUM(E3:OFFSET(NITAlevyTo,-1,6))","v":0}]
[1]

{"sheet":"N_Tax_Due","index":20,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Section L : Calculation of Tax Due"]
["Sr. No.","Description","Amount (Ksh)"]
[1,"Total Employees (Total records of B_Employees_Dtls and C_Disabled_Employees_Dtls)",{"$f":"ROUND(ROWS(SalDedDsbEmpPIN)-COUNTBLANK(SalDedDsbEmpPIN)+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":0}]
[3,"PAYE Tax deducted from Persons with Disability (Total of \"Self Assessed PAYE Tax\" from C_Disabled_Employees_Dtls)",{"$f":"ROUND(DtlsSalPdBftsSelfPayTaxDEListTO,2)","v":0}]
[4,"PAYE Tax on Lump Sum Payment on Termination (Total of \"Amount of PAYE Payable\" from F_Lump_Sum_Payments_Dtls)",{"$f":"ROUND(TaxPdOnLumpSumPdAftrTrmtnListTO,2)","v":0}]
[5,"PAYE Tax deducted from Employee(s) on Arrears (Total of \"Self Assessed PAYE Tax\" from G_Arrears_Dtls_E)",{"$f":"ROUND(DtlsSalPdArrearDEListTO,2)","v":0}]
[6,"PAYE Tax deducted from Persons with Disability on Arrears (Total of \"Self Assessed PAYE Tax\" from H_Arrears_Dtls_DE)",{"$f":"ROUND(DtlsArrSalPdBftsPayeSelfPayeListTO,2)","v":0}]
[7,"PAYE Tax deducted on Gratuity (Total of \"Amount of Tax Payable on Gratuity\" from I_Gratuity_Dtls)",{"$f":"ROUND(CalPayeTaxPyblOnGratIListTO,2)","v":0}]
[8,"Fringe Benefit Tax (Total of \"Amount of Fringe Benefit Tax\" from J_FBT_Dtls)",{"$f":"ROUND(FringeBenfTaxCalcListTO,2)","v":0}]
[9,"Total PAYE Tax Payable for the Month (2+3+4+5+6+7+8)",{"$f":"ROUND(SUM(ClcTaxDue.EmpTO,ClcTaxDue.DsblEmpTO,ClcTaxDue.LumpSumTO,ClcTaxDue.ArrEmpTO,ClcTaxDue.ArrDsblEmpTO,ClcTaxDue.GratListTO,ClcTaxDue.FringeBenfTO),2)","v":0}]
[10,"Previous month PAYE Tax (If the amount was less than 100 Ksh and not paid) *",0]
[11,"Paye Tax deducted from the Employee(s) Without PIN",0]
[12,"Total PAYE Tax Payable (9+10+11)",{"$f":"ROUND(SUM(ClcTaxDue.TotPayeTaxPybl,ClcTaxDue.PrevMonPaye,ClcTaxDue.TaxDedEmpWithoutPin),2)","v":0}]
[13,"PAYE Paid in Advance (Total of \"Amount of PAYE Tax Paid\" from K_PAYE_Payment_Credits)",{"$f":"IF(ClcTaxDue.TotTaxPybl>0,ROUND(DtlsPayeFinalTaxPdTO,2),0)","v":0}]
[14,"Net PAYE Tax Payable (12-13)",{"$f":"ROUND(ClcTaxDue.TotTaxPybl,2)-ROUND(ClcTaxDue.TaxAdvPdTO,2)","v":0}]
[15,"Total Housing Levy Contributing Members (Total records of M_Housing_Levy_Dtls)",{"$f":"IF(C18>0,TotHousingMembers,0)","v":0}]
[16,"Total Housing Levy Contribution (Total of \"Total Contribution\" from M_Housing_Levy_Dtls)",{"$f":"ROUNDUP(HousinglevyTo,0)","v":0}]
[17,"Total NITA Levy Contributing Members (Total records of M1_NITA_Levy_Dtls)",0]
[18,"Total NITA Levy Contribution (Total of \"Standard NITA Deduction\" from M1_NITA_Levy_Dtls)",0]
[19,"Total Payable (14+16+18)",{"$f":"ROUND(SUM(ClcTaxDue.NetPayeTaxPybl,ClcTaxDue.totalHousingContribution,ClcTaxDue.totalNITAContribution),2)","v":0}]
[]
[null,"RetInf"]

{"sheet":"Sheet1","index":21,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["52816cfa79b3a5e6fade7bed8f5c8ab3b6c43f9036acefcc5bd68114b1ab2eba"]
["e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"]
[]
[]
[]
[]
["52816cfa79b3a5e6fade7bed8f5c8ab3b6c43f9036acefcc5bd68114b1ab2eba"]
["e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"]