{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Control Centre","INDIVIDUAL-AOP (1 of 2)","INDIVIDUAL-AOP (2 of 2)","Annex-A","Annex-B","Annex-C","Annex-D","Annex-E","Annex-F","ANNEX-G","Annex-H","Annex-J"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":14,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Control Centre","index":1,"n_rows":14,"n_cols":58,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,6,7,21],[1,5,1,22],[1,23,2,26],[2,6,2,21],[3,2,3,5],[3,6,3,21],[3,23,3,26],[4,2,4,5],[4,6,4,21],[5,2,5,5],[9,2,9,5],[9,6,9,15],[9,16,9,17],[9,18,9,21],[5,6,5,21],[5,23,5,26],[6,2,6,5],[6,6,6,21],[6,23,6,26],[7,2,7,5],[9,23,9,26],[10,2,10,5],[10,7,10,10],[10,12,10,21],[10,23,10,26],[12,2,12,5],[12,7,12,10],[12,12,12,21],[11,23,11,26],[12,22,12,26],[13,2,13,5],[13,7,13,10],[13,12,13,21],[3,0,13,0],[11,2,11,5],[11,6,11,21],[8,2,8,5],[8,6,8,15],[8,16,8,17],[8,18,8,21]]}
[]
[null,null,null,null,null," RETURN OF TOTAL INCOME/STATEMENT OF FINAL TAXATION ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Centre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",1]
[null,null,null,null,null,null,"           UNDER THE INCOME TAX ORDINANCE, 2001 (FOR INDIVIDUAL / AOP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," N° ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source","Turbo Tax Assistant"]
["Registration (*)",null,"Taxpayer's Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NTN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wealth Statement Filled",0]
[null,null,"CNIC  (for Individual)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gender","Male",{"$f":"IF(+AC5=1,\"ü\",\"\")","v":"ü"},"Female",{"$f":"IF(+AC5=2,\"ü\",\"\")","v":""},null,1,"Enter 1 for Male or 2 for Female"]
[null,null,"Business Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year Ending","30.06.2013"]
[null,null,"Business Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax Year",2013]
[null,null,"Res. Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person","IND",{"$f":"IF(AC8=1,\"ü\",\"\")","v":"ü"},"AOP",{"$f":"IF(+AC8=2,\"ü\",\"\")","v":""},null,1,"Enter 1 for IND or 2 for AOP"]
[null,null,"E-Mail Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone",null,null,null,null,null,"Res. Status","Non-Res.",{"$f":"IF(+AC9=2,\"ü\",\"\")","v":""},"Resident",{"$f":"IF(+AC9=1,\"ü\",\"\")","v":"ü"},null,1,"Enter 1 for Resident or 2 for Non-Resident"]
[null,null,"Principal Activity",null,null,null,null,null,null,null,null,null,null,null,null,null,"Code",null,null,null,null,null,"Birth Date"]
[null,null,"Employer",null,null,null,"NTN",null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,"Filing Section"]
[null,null,"Employee/PA Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTO/LTU"]
[null,null,"Representative",null,null,null,"NTN",null,null,null,null,"Name"]
[null,null,"Authorized Rep.",null,null,null,"NTN",null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,"Is authorized Rep. applicable?",null,null,"Yes/No",{"$f":"IF(+AC14=1,\"ü\",\"x\")","v":"x"},null,2,"Enter 1 for YES 2 for NO"]

{"sheet":"INDIVIDUAL-AOP (1 of 2)","index":2,"n_rows":83,"n_cols":249,"rows_kept":83,"cut":false,"hidden":false,"merged":[[76,2,76,23],[72,33,72,35],[3,0,13,0],[3,6,3,23],[78,0,83,0],[14,1,19,1],[14,0,19,0],[20,0,32,0],[33,0,36,0],[37,0,58,0],[59,0,76,0],[4,6,4,23],[39,27,39,31],[27,27,27,31],[46,27,46,31],[14,24,14,26],[42,3,42,23],[44,3,44,23],[43,3,43,23],[37,27,37,31],[28,27,28,31],[14,2,14,5],[19,2,19,23],[13,7,13,11],[3,24,3,26],[17,2,17,5],[6,24,6,26],[7,6,7,23],[5,6,5,23],[8,20,8,23],[25,24,25,26],[1,27,1,31],[15,6,15,23],[1,3,1,26],[2,4,2,23],[2,24,2,26],[4,24,4,26],[16,2,16,5],[5,27,5,31],[3,27,3,31],[16,27,16,31],[16,24,16,26],[10,13,10,23],[23,24,23,26],[24,24,24,26],[23,27,23,31],[21,2,21,16],[18,2,18,23],[15,2,15,5],[11,27,11,31],[10,27,10,31],[11,6,11,23],[12,13,12,23],[14,27,14,31],[15,27,15,31],[13,13,13,23],[15,24,15,26],[17,27,17,31],[16,6,16,23],[6,6,6,23],[12,7,12,11],[17,6,17,23],[8,6,8,16],[17,24,17,26],[9,6,9,16],[10,7,10,11],[9,20,9,23],[22,27,22,31],[18,27,18,31],[19,27,19,31],[19,24,19,26],[22,24,22,26],[21,24,21,26],[20,27,20,31],[21,27,21,31],[18,24,18,26],[32,27,32,31],[33,27,33,31],[35,27,35,31],[36,27,36,31],[6,27,6,31],[9,27,9,31],[29,27,29,31],[25,27,25,31],[26,27,26,31],[24,27,24,31],[42,27,42,31],[43,27,43,31],[61,27,61,31],[39,3,39,23],[73,2,73,23],[70,21,70,23],[40,27,40,31],[60,27,60,31],[61,2,61,23],[61,24,61,26],[80,5,80,11],[52,2,58,2],[51,27,51,31],[60,2,60,23],[57,27,57,31],[45,27,45,31],[77,2,77,23],[68,27,70,31],[72,27,72,31],[73,27,73,31],[82,12,82,14],[77,27,77,31],[76,27,76,31],[74,27,74,31],[71,2,71,23],[82,5,82,11],[82,15,82,23],[71,27,71,31],[72,2,72,23],[82,24,82,31],[77,24,77,26],[71,24,71,26],[72,24,72,26],[73,24,73,26],[74,24,74,26],[76,24,76,26],[66,27,66,31],[67,27,67,31],[67,2,67,23],[70,8,70,10],[66,21,66,23],[68,2,68,23],[67,24,67,26],[68,24,70,26],[69,18,69,19],[69,21,69,23],[59,21,59,23],[53,27,53,31],[48,27,48,31],[49,27,49,31],[59,27,59,31],[57,24,57,26],[58,24,58,26],[53,24,53,26],[54,24,54,26],[50,27,50,31],[58,27,58,31],[55,27,55,31],[34,27,34,31],[38,27,38,31],[51,24,51,26],[52,24,52,26],[37,24,37,26],[56,27,56,31],[41,27,41,31],[47,27,47,31],[0,0,0,31],[54,27,54,31],[52,27,52,31],[31,27,31,31],[30,27,30,31],[41,3,41,23],[40,3,40,23],[44,27,44,31],[39,24,39,26],[40,24,40,26],[43,24,43,26],[33,24,33,26],[34,24,34,26],[38,24,38,26],[28,24,28,26],[42,24,42,26],[41,24,41,26],[44,24,44,26],[55,24,55,26],[56,24,56,26],[45,24,45,26],[48,24,48,26],[49,24,49,26],[50,24,50,26],[69,8,69,10],[31,24,31,26],[32,24,32,26],[59,16,59,20],[60,24,60,26],[66,24,66,26],[36,24,36,26],[59,24,59,26],[46,24,46,26],[47,24,47,26],[4,29,4,30],[8,29,8,30],[13,29,13,30],[63,2,63,7],[63,13,63,18],[64,2,64,22],[29,24,29,26],[30,24,30,26],[20,24,20,26],[27,24,27,26],[17,247,18,247],[17,248,18,248],[59,33,59,38],[2,244,3,244],[2,245,2,246],[2,247,3,247],[2,248,3,248],[75,27,75,31],[75,24,75,26],[64,33,65,40],[60,33,60,34],[60,35,60,38],[16,244,16,245],[17,244,18,244],[17,245,17,246],[26,24,26,26],[35,24,35,26]]}
[]
[null,null,null," RETURN OF TOTAL INCOME/STATEMENT OF FINAL TAXATION ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT-2 (Page 1 of 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxable Amount:",null,{"$f":"AB51","v":0},"Total Tax:",{"$f":"MAX(IO5:IO10)","v":0}]
[null,null,null,null,"           UNDER THE INCOME TAX ORDINANCE, 2001 (FOR INDIVIDUAL / AOP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," N° ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sr. No.","Amount",null,"Rate","Flat Tax"]
["Registration",null,"Taxpayer's Name",null,null,null,{"$f":"'Control Centre'!$G$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NTN",null,null,{"$f":"'Control Centre'!$X$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From","To"]
[null,null,"CNIC  (for Individual)",null,null,null,{"$f":"'Control Centre'!$G$5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Gender",null,null,"Male",{"$f":"'Control Centre'!$Y$5","v":"ü"},"Female",null,{"$f":"'Control Centre'!$AA$5","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,400000,0,0]
[null,null,"Business Name",null,null,null,{"$f":"'Control Centre'!$G$6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Year Ending",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,400000,750000,5,{"$f":"IF(AND($IM$2 > IL6,$IM$2<=IM6),(($IM$2-IM5)*IN6/100) + II6,0)","v":0}]
[null,null,"Business Address",null,null,null,{"$f":"'Control Centre'!$G$7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Tax Year",null,null,2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17500,null,3,750000,1500000,10,{"$f":"IF(AND($IM$2 > IL7,$IM$2<=IM7),(($IM$2-IM6)*IN7/100) + II7,0)","v":0}]
[null,null,"Res. Address",null,null,null,{"$f":"'Control Centre'!$G$8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Person",null,null,"IND",{"$f":"'Control Centre'!$Y$8","v":"ü"},"AOP",null,{"$f":"'Control Centre'!$AA$8","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95000,null,4,1500000,2000000,15,{"$f":"IF(AND($IM$2 > IL8,$IM$2<=IM8),(($IM$2-IM7)*IN8/100) + II8,0)","v":0}]
[null,null,"E-Mail Address",null,null,null,{"$f":"'Control Centre'!$G$9","v":0},null,null,null,null,null,null,null,null,null,null," Phone",null,null,{"$f":"'Control Centre'!$S$9","v":0},null,null,null," Res. Status",null,null,"Non-Res.",{"$f":"'Control Centre'!$Y$9","v":""},"Resident",null,{"$f":"'Control Centre'!$AA$9","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175000,null,5,2000000,2500000,17.5,{"$f":"IF(AND($IM$2 > IL9,$IM$2<=IM9),(($IM$2-IM8)*IN9/100) + II9,0)","v":0}]
[null,null,"Principal Activity",null,null,null,{"$f":"'Control Centre'!$G$10","v":0},null,null,null,null,null,null,null,null,null,null,"Code",null,null,{"$f":"'Control Centre'!$S$10","v":0},null,null,null," Birth Date",null,null,{"$f":"'Control Centre'!X10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,420000,null,6,2500000,999999999999999,20,{"$f":"IF(AND($IM$2 > IL10,$IM$2<=IM10),(($IM$2-IM9)*IN10/100) + II10,0)","v":0}]
[null,null,"Employer's",null,null,null,"NTN",{"$f":"'Control Centre'!$H$11","v":0},null,null,null,null,"Name",{"$f":"'Control Centre'!$M$11","v":0},null,null,null,null,null,null,null,null,null,null," Filing Section",null,null,{"$f":"'Control Centre'!X11","v":0}]
[null,null,"Employee/PA Number",null,null,null,{"$f":"'Control Centre'!$G$12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," RTO/LTU",null,null,{"$f":"'Control Centre'!X12","v":0}]
[null,null,"Representative",null,null,null,"NTN",{"$f":"'Control Centre'!H13","v":0},null,null,null,null,"Name",{"$f":"'Control Centre'!M13","v":0}]
[null,null,"Authorized Rep.'s",null,null,null,"NTN",{"$f":"'Control Centre'!H14","v":0},null,null,null,null,"Name",{"$f":"'Control Centre'!M14","v":0},null,null,null,null,null,null,null,null,null,null,"Is authorized Rep. applicable?",null,null,null,null,"Yes/No",null,{"$f":"'Control Centre'!$AA$14","v":"x"}]
["Ownership",null,"NTN",null,null,null,"Proprietor/Member/Partners' Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% in Capital",null,null,"Capital Amount"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxable Amount:",null,{"$f":"AB51","v":0},"Total Tax:",{"$f":"MAX(IO20:IO24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sr. No.","Amount",null,"Rate","Flat Tax"]
[null,null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From","To"]
[null,null,"Total  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,400000,0,{"$f":"IF(AND($IM$18 > IL20,$IM$18<=IM20),$IM$18*IN20/100,0)","v":0}]
["Manufacturing/ Trading, Profit & Loss Account ( including Final/Fixed Tax)",null,"Items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code",null,null,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,400000,750000,10,{"$f":"IF(AND($IM$17 > IL21,$IM$17<=IM21),(($IM$17-IM20)*IN21/100) + II21,0)","v":0}]
[null,1,"Net Sales (excluding Sales Tax/ Federal Excise Duty)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[to be reconciled with Annex-C]",null,null,null,null,null,3103,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35000,null,3,750000,1500000,15,{"$f":"IF(AND($IM$17 > IL22,$IM$17<=IM22),(($IM$17-IM21)*IN22/100) + II22,0)","v":0}]
[null,2,"Cost of Sales  [3 + 4 + 5 - 6]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[to be reconciled with Annex-C]",null,null,null,null,null,3116,null,null,{"$f":"SUM(AB24:AF26) - AB27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147500,null,4,1500000,2500000,20,{"$f":"IF(AND($IM$17 > IL23,$IM$17<=IM23),(($IM$17-IM22)*IN23/100) + II23,0)","v":0}]
[null,3,null,"Opening Stock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3117,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,347500,null,5,2500000,999999999999999,25,{"$f":"IF(AND($IM$17 > IL24,$IM$17<=IM24),(($IM$17-IM23)*IN24/100) + II24,0)","v":0}]
[null,4,null,"Net Purchases (excluding Sales Tax/ Federal Excise Duty)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3106]
[null,5,null,"Other Manufacturing/ Trading Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[ Transfer from Sr-7 of Annex-G]",null,null,null,null,null,3111,null,null,{"$f":"'ANNEX-G'!$S$15","v":0}]
[null,6,"Closing Stock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3118]
[null,7,"Gross Profit/ (Loss) [1-2]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[ to be reconciled with Annex-C ]",null,null,null,null,null,3119,null,null,{"$f":"AB22 - AB23","v":0}]
[null,8,"Transport Services U/S 153(1)(b) (Transferred from Row 1 Column 5 of Annex H)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3121,null,null,{"$f":"'Annex-H'!$T$9","v":0}]
[null,9,"Other Services U/S 153(1)(b) (Transferred from  Row 1 Column 6 of Annex H)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3122,null,null,{"$f":"'Annex-H'!$W$9","v":0}]
[null,10,"Other Revenues/ Fee/ Charges for Professional and Other Services/ Commission",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3131]
[null,11,"Profit & Loss Expenses ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Transfer from Sr-25 of Annex-G]",null,null,null,null,null,3189,null,null,{"$f":"'ANNEX-G'!$S$33","v":0}]
[null,12,"Net Profit/ (Loss) [(7 + 8 + 9 + 10) - 11]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3190,null,null,{"$f":"SUM(AB28:AF31) - AB32","v":0}]
["Adjustments",13,"Inadmissible Deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," [Transfer from Sr-22 of Annex-E]",null,null,null,null,null,3191,null,null,{"$f":"'Annex-E'!$AQ$32","v":0}]
[null,14,"Admissible Deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," [Transfer from Sr-5 of Annex-E]",null,null,null,null,null,3192,null,null,{"$f":"'Annex-E'!$AQ$10","v":0}]
[null,15,"Unadjusted Loss from business for previous year(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," [Transfer from Sr. 31 of Annex-A]",null,null,null,null,null,3902,null,null,{"$f":"'Annex-A'!$J$42","v":0}]
[null,16,"Un-absorbed Tax Depreciation for previous/ current year(s) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," [Transfer from Sr. 31 of Annex-A]",null,null,null,null,null,3988,null,null,{"$f":"'Annex-A'!$S$42","v":0}]
["Total / Taxable Income Computation",17,"Total Income (18+31)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9000,null,null,{"$f":"AB39+AB52","v":0}]
[null,18,"Total Income u/s 10(a) [Sum of 19 to 24]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9099,null,null,{"$f":"SUM(AB40:AF45)","v":0}]
[null,19,null,"Salary Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[null,20,null,"Business Income/ (Loss) [ (12 + 13) - 14 - 15 - 16 ]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3999,null,null,{"$f":"AB33+AB34-AB35-AB36-AB37","v":0}]
[null,21,null,"Share from AOP [Income/(Loss)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312021]
[null,22,null,"Capital Gains/(Loss) u/s 37",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4999]
[null,23,null,"Other Sources Income/ (Loss)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5999]
[null,24,null,"Foreign Income/ (Loss)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6399]
[null,25,"Deductible Allowances [Sum of 26 to 29]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9139,null,null,{"$f":"SUM(AB47:AF50)","v":0}]
[null,26,null,"Zakat ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9121]
[null,27,null,"Workers Welfare Fund (WWF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9122]
[null,28,null,"Workers Profit Participation Fund (WPPF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9123]
[null,29,null,"Charitable donations admissible as straight deduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9124]
[null,30,"Taxable Income/ (Loss) [18 - 25]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9199,null,null,{"$f":"AB39 - AB46","v":0}]
[null,31,"Exempt Income/ (Loss) u/s 10(b)  [Sum of 32 to 38]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6199,null,null,{"$f":"SUM(AB53:AF59)","v":0}]
[null,32,null,"Salary Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6101]
[null,33,null,"Property Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6102]
[null,34,null,"Business Income/ (Loss) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6103]
[null,35,null,"Capital Gains/(Loss)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6104]
[null,36,null,"Agriculture Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6106]
[null,37,null,"Foreign Remittances (Attach Evidence)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6107]
[null,38,null,"Other Sources Income/ (Loss)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6105]
["Tax Computation",39,"Tax Payable on Taxable Income",null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Rate of Tax  (%):   ",null,null,null,null,{"$f":"AB60*100/AB51","v":{"$error":"#DIV/0!"}},null,null,9201,null,null,{"$f":"IF(AJ61=0,AH60,AJ61)","v":0},null,null,null,null,null,{"$f":" IF(AB51/2 >= AB40,IO17,IO2)","v":0}]
[null,40,"Tax Reductions/Credits/Averaging other than Teacher/Researcher Rebate (including rebate on Bahbood Certificates, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9249,null,null,null,null,null,null,null,null,"Overwrite",null,0]
[null,41,"Difference of minimum Tax Payable on business transactions  Annex - H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9303,null,null,{"$f":"'Annex-H'!$Z$19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do you fall under PTR Regime"]
[null,42,"a)   Do you fall under PTR Regime",null,null,null,null,null,"Yes",{"$f":"IF(AH64=1,\"Yes\",\"\")","v":"Yes"},"  No",{"$f":"IF(AH64<>1,\"No\",\"\")","v":""},null,"If, Yes, Do you want to avail Normal Tax Regime",null,null,null,null,null,"Yes",{"$f":"IF(AND(J64=\"Yes\",AH67=1),\"Yes\",\"\")","v":"Yes"},"  No",{"$f":"IF(AND(J64=\"Yes\",AH67<>1),\"No\",\"\")","v":""},null,null,{"$f":"IF(AND('Annex-J'!$Z$17=\"Yes\",AH64=1,AH67=1),\"ü\",\"\")","v":"ü"}," Eligible",null,{"$f":"IF(AND(Z64=\"\",AC65=\"\",AH64=1,AH67=1),\"ü\",\"\")","v":""},"Partially Eligible",null,null,null,1,"Enter 1 for Yes or 2 for No"]
[null,null,"b) In order to Determine your eligibility for availing Normal Tax Regime, Click Annex-J",null,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":"IF(AND('Annex-J'!$N$17=\"No\",'Annex-J'!$R$17=\"No\",'Annex-J'!$V$17=\"No\"),\"ü\",\"\")","v":""},"Not Eligible",null,null,null,"If, Yes, Do you want to avail Normal Tax Regime"]
[]
[null,43,"Minimum tax on electricity consumption ( where monthly bill amount is up to Rs. 30,000) u/s 235 (4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9304,null,null,null,null,null,null,null,null,1,"Enter 1 for Yes or 2 for No"]
[null,44,"Balance tax chargeable [ (39 minus 40 plus 41) or 43, whichever is higher",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9305,null,null,{"$f":"IF(AB60-AB61+AB62 > AB67,AB60-AB61+AB62,AB67)","v":0}]
[null,45,"Minimum Tax Payable U/S 113 [if 45(iv) minus 44 > zero then Amount equals to 45(iv) minus 44, else zero]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9306,null,null,{"$f":"IF(V71-AB68>0, V71-AB68,0)","v":0}]
[null,null,"(i)","Total Turnover",null,null,null,null,null,null,null,null,null,null,"(iii)","Reduction @ ",null,null,0.2,null,null,{"$f":"ROUND(I71*S70,0)","v":0}]
[null,null,"(ii)","Minimum tax @ 0.5%",null,null,null,null,{"$f":"ROUND(I70*0.5%,0)","v":0},null,null,null,null,null,"(iv)","Net Minimum tax",null,null,null,null,null,{"$f":"I71-V70","v":0}]
[null,46,"Full Time Teacher/Researcher's Rebate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9309]
[null,47,"Net tax payable [44 + 45 - 46 + 97]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9307,null,null,{"$f":"AB68 + AB69 - AB72 + 'INDIVIDUAL-AOP (2 of 2)'!$P$53","v":0}]
[null,48,"Total Tax Payments  (Transfer from Sr. 31 of Annex-B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9499,null,null,{"$f":"'Annex-B'!$AP$71","v":0}]
[null,49,"Tax Payable/ Refundable [47 - 48 + WWF Payable from Sr. 32 of Annex-B]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9999,null,null,{"$f":"AB73 - AB74 + 'Annex-B'!$AP$72","v":0}]
[null,50,"Refund Available (Current plus prior years)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9991]
[null,51,"Refund Adjustments (not exceeding current year's tax payable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9998]
[null,52,"Annual personal expenses for individual only (transfer from Sr. 12 of Annex-D) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6109,null,null,{"$f":"'Annex-D'!$AE$17","v":0}]
["Refund",null,"Net Tax Refundable, may be credited to my bank account as under:"]
[]
[null,null,null,"A/C No."]
[]
[null,null,null,"Bank ",null,null,null,null,null,null,null,null,"Branch Name & Code",null,null,null,null,null,null,null,null,null,null,null,"Signature"]

{"sheet":"INDIVIDUAL-AOP (2 of 2)","index":3,"n_rows":73,"n_cols":28,"rows_kept":73,"cut":false,"hidden":false,"merged":[[70,10,70,11],[48,14,49,14],[52,15,52,18],[61,13,71,13],[62,5,62,9],[64,1,64,11],[51,9,51,12],[50,9,50,10],[50,11,50,12],[50,2,50,7],[1,3,1,14],[1,15,1,18],[2,4,2,13],[2,15,2,18],[7,9,7,12],[3,1,3,3],[3,4,3,13],[3,15,3,18],[4,4,4,13],[4,1,4,3],[4,15,4,18],[10,9,10,12],[10,15,10,18],[8,9,8,12],[8,15,8,18],[9,2,9,7],[11,9,11,12],[11,15,11,18],[6,15,6,18],[5,15,5,18],[9,9,9,12],[6,9,6,12],[7,15,7,18],[9,15,9,18],[5,4,5,13],[12,9,12,12],[12,15,12,18],[13,9,13,12],[13,15,13,18],[14,9,14,12],[14,15,14,18],[15,9,15,12],[15,15,15,18],[16,9,16,12],[16,15,16,18],[17,9,17,12],[17,15,17,18],[18,9,18,12],[18,15,18,18],[19,9,19,12],[19,15,19,18],[20,9,20,12],[20,15,20,18],[21,9,21,12],[21,15,21,18],[22,9,22,12],[22,15,22,18],[24,9,24,12],[24,15,24,18],[25,2,25,7],[25,9,25,12],[23,9,23,12],[23,15,23,18],[26,9,26,12],[26,15,26,18],[25,15,25,18],[24,2,24,7],[26,2,26,7],[27,9,27,12],[27,15,27,18],[34,9,34,12],[28,2,28,7],[28,9,28,12],[28,15,28,18],[29,9,29,12],[29,15,29,18],[30,9,30,12],[30,15,30,18],[38,9,38,12],[38,15,38,18],[31,9,31,12],[31,15,31,18],[32,9,32,12],[33,9,33,12],[37,9,37,12],[32,15,32,18],[34,15,34,18],[72,0,72,18],[47,9,47,12],[35,9,35,12],[35,15,35,18],[36,9,36,12],[36,15,36,18],[61,0,71,0],[61,2,61,11],[37,0,51,0],[39,15,39,18],[41,15,41,18],[33,15,33,18],[51,15,51,18],[43,15,43,18],[37,15,37,18],[50,15,50,18],[48,15,49,18],[44,15,44,18],[46,15,46,18],[45,15,45,18],[40,9,40,12],[42,9,42,12],[69,14,69,18],[70,1,70,2],[70,3,70,6],[65,1,69,12],[70,8,70,9],[48,8,49,8],[48,1,49,1],[48,13,49,13],[3,0,5,0],[6,0,36,0],[70,14,70,18],[42,15,42,18],[40,15,40,18],[13,2,13,7],[47,15,47,18],[41,9,41,12],[39,9,39,12],[42,2,42,7],[45,2,45,7],[43,9,43,12],[44,9,44,12],[41,2,41,7],[48,9,49,12],[43,2,43,7],[44,2,44,7],[45,9,45,12],[46,9,46,12],[49,21,49,26],[7,2,7,7],[8,2,8,7],[10,2,10,7],[11,2,11,7],[12,2,12,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,2,22,7],[23,2,23,7],[39,2,39,7],[48,2,49,7],[27,2,27,7],[29,2,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[40,2,40,7],[47,2,47,7],[53,0,59,0],[55,2,57,13],[59,2,59,17],[46,2,46,7],[51,2,51,7],[34,2,34,7],[35,2,35,7],[36,2,36,7],[37,2,37,7],[38,2,38,7]]}
[]
[null,null,null,"RETURN OF TOTAL INCOME/STATEMENT OF FINAL TAXATION ",null,null,null,null,null,null,null,null,null,null,null,"IT-2 (Page 2 of 2)"]
[null,null,null,null,"      UNDER THE INCOME TAX ORDINANCE, 2001 (FOR INDIVIDUAL / AOP)",null,null,null,null,null,null,null,null,null,"N° "]
[null,"Taxpayer's Name",null,null,{"$f":"'Control Centre'!$G$4","v":0},null,null,null,null,null,null,null,null,null,"NTN",{"$f":"'Control Centre'!$X$4","v":0}]
[null,"CNIC  (for Individual)",null,null,{"$f":"'Control Centre'!$G$5","v":0},null,null,null,null,null,null,null,null,null,"Tax Year",2013]
[null,"Business Name",null,null,{"$f":"'Control Centre'!$G$6","v":0},null,null,null,null,null,null,null,null,null,"RTO/LTU",{"$f":"'Control Centre'!X12","v":0}]
["Final Tax",null,"Source",null,null,null,null,null,"Code","Receipts/Value",null,null,null,"Rate (%)","Code","Tax Chargeable"]
[null,53,"Imports",null,null,null,null,null,"64013",null,null,null,null,5,"92013",{"$f":"ROUND(J8*N8/100,0)","v":0}]
[null,54,null,null,null,null,null,null,"64011",null,null,null,null,2,"92011",{"$f":"ROUND(J9*N9/100,0)","v":0}]
[null,55,null,null,null,null,null,null,"64012",null,null,null,null,1,"92012",{"$f":"ROUND(J10*N10/100,0)","v":0}]
[null,56,null,null,null,null,null,null,"64015",null,null,null,null,3,"92015",0]
[null,57,"Dividend",null,null,null,null,null,"64032",null,null,null,null,10,"92032",0]
[null,58,null,null,null,null,null,null,"64033",null,null,null,null,7.5,"92033",0]
[null,59,"Profit on Debt",null,null,null,null,null,"64041",null,null,null,null,10,"92041",0]
[null,60,"Royalties/Fees (Non-Resident)",null,null,null,null,null,"640511",null,null,null,null,15,"920511",0]
[null,61,null,null,null,null,null,null,"640512",null,null,null,null,null,"920512",0]
[null,62,"Contracts (Non-Resident)",null,null,null,null,null,"640521",null,null,null,null,6,"920521",0]
[null,63,"Insurance Premium (Non-Resident)",null,null,null,null,null,"640524",null,null,null,null,5,"920524",0]
[null,64,"Advertisement Services (Non-Resident)",null,null,null,null,null,"640525",null,null,null,null,10,"920525",0]
[null,65,"Supply of Goods",null,null,null,null,null,"640611",null,null,null,null,3.5,"920611",0]
[null,66,null,null,null,null,null,null,"640612",null,null,null,null,1.5,"920612",0]
[null,67,null,null,null,null,null,null,"640613",null,null,null,null,null,"920613",0]
[null,68,"Payments to Ginners",null,null,null,null,null,"640614",null,null,null,null,1,"920614",0]
[null,69,"Contracts (Resident)",null,null,null,null,null,"640631",null,null,null,null,6,"920631",0]
[null,70,null,null,null,null,null,null,640632,null,null,null,null,1,920632,0]
[null,71,"Exports/related Commission/Service",null,null,null,null,null,"640641",null,null,null,null,0.5,"920641",0]
[null,72,null,null,null,null,null,null,"64072",null,null,null,null,1,"92072",0]
[null,73,"Foreign Indenting Commission",null,null,null,null,null,"64075",null,null,null,null,5,"92075",0]
[null,74,"Prizes/Winnings of cross word puzzles",null,null,null,null,null,"64091",null,null,null,null,10,"92091",0]
[null,75,"Winnings - Others",null,null,null,null,null,"64092",null,null,null,null,20,"92092",0]
[null,76,"Petroleum Commission",null,null,null,null,null,"64101",null,null,null,null,10,"92101",0]
[null,77,"Brokerage/Commission",null,null,null,null,null,"64121",null,null,null,null,10,"92121",0]
[null,78,"Advertising Commission",null,null,null,null,null,"64122",null,null,null,null,5,"92122",0]
[null,79,"Services to Exporters u/s 153(2)",null,null,null,null,null,64123,null,null,null,null,1,92123,0]
[null,80,"Goods Transport Vehicles",null,null,null,null,null,"",null,null,null,null,null,"92141"]
[null,81,"Gas consumption by CNG Station ",null,null,null,null,null,"64142",null,null,null,null,4,"92142",{"$f":"ROUND(J36*N36/100,0)","v":0}]
[null,82,"Distribution of cigarette and pharmaceutical products",null,null,null,null,null,"64143",null,null,null,null,1,"92143",0]
["Fixed Tax",83,"Retail Turnover upto 5 million",null,null,null,null,null,"310102",null,null,null,null,1,"920202",0]
[null,84,"Retail Turnover above 5 million",null,null,null,null,null,"310103",null,null,null,null,null,"920203",0]
[null,85,"Property Income",null,null,null,null,null,"210101",null,null,null,null,null,"920235",{"$f":"IF(AND(J40>150000,J40<=400000),ROUND((J40-150000)*5/100,0),IF(AND(J40>400000,J40<=1000000),12500+ROUND((J40-400000)*7.5/100,0),IF(J40 > 1000000,57500+ROUND((J40-1000000)*10/100,0),0)))","v":0}]
[null,86,"Capital gains on Securities held for < 6 months",null,null,null,null,null,"610401",null,null,null,null,10,"961041",0]
[null,87,"Capital gains on Securities held for >= 6 months and < 12 months",null,null,null,null,null,"610402",null,null,null,null,8,"961042",0]
[null,88,"Capital gains on Securities held for >=12 months",null,null,null,null,null,610403,null,null,null,null,0,"961043",0]
[null,89,"Capital gains arising on disposal of immovable property held upto 1 year",null,null,null,null,null,610404,null,null,null,null,10,961044,0]
[null,90,"Capital gains arising on disposal of immovable property held for > 1 year and upto 2 year",null,null,null,null,null,610405,null,null,null,null,5,961045,0]
[null,91,"Purchase of locally produced edible oil",null,null,null,null,null,"310431",null,null,null,null,2,"920208",0]
[null,92,"Flying/Submarine Allowance",null,null,null,null,null,"112001",null,null,null,null,2.5,920234,0]
[null,93,"Monetization of Transport Facility For Civil Servants",null,null,null,null,null,112002,null,null,null,null,5,920237,0,null,null,null,null,null,"Imports  u/s 148(7)",null,null,null,null,null,{"$f":"IF(OR('Annex-J'!$N$17=\"No\",'INDIVIDUAL-AOP (1 of 2)'!AH64=2,'INDIVIDUAL-AOP (1 of 2)'!AH67=2),SUM(P8:S11),0)","v":0}]
[null,94,"Services rendered / contracts executed outside Pakistan",null,null,null,null,null,63311,null,null,null,null,1,920236,{"$f":"ROUND(J49*N49/100,0)","v":0},null,null,null,null,null,"Exports   u/s 154(4)",null,null,null,null,null,{"$f":"IF(OR('Annex-J'!$R$17=\"No\",'INDIVIDUAL-AOP (1 of 2)'!AH64=2,'INDIVIDUAL-AOP (1 of 2)'!AH67=2),SUM(P26:S28),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales/ Payments u/s 153(1) & u/s 169(1)b",null,null,null,null,null,{"$f":"IF(OR('Annex-J'!$V$17=\"No\",'INDIVIDUAL-AOP (1 of 2)'!AH64=2,'INDIVIDUAL-AOP (1 of 2)'!AH67=2),SUM(P20:S22),0)","v":0}]
[null,95,"Number of persons sent for Hajj & Tax payable under Clause (72A)",null,null,null,null,null,63312,"Number",null,null,null,3500,"92144",{"$f":"L51*N51","v":0}]
[null,96,"Employment Termination Benefits",null,null,null,null,null,118301,null,null,null,null,null,920211]
[null,97,"Final/Fixed Tax Chargeable (53 to 96)",null,null,null,null,null,null,null,null,null,null,null,9202,{"$f":"IF(AND('INDIVIDUAL-AOP (1 of 2)'!AH64=1,'INDIVIDUAL-AOP (1 of 2)'!AH67=1),SUM(P12:S19)+SUM(P23:S25)+SUM(P29:S52)+SUM(AB48:AB50),SUM('INDIVIDUAL-AOP (2 of 2)'!P8:S52))","v":0}]
["Documents Required"]
[null,null,"1. Wealth Statement (For Individuals and Members of AOP only)",null,null,null,null,null,null,null,null,null,null,null,"Attached"]
[null,null,"2. Balance Sheet in case of income from business (in case declared/assessed turnover for the tax year 2012 or any subsequent year is Rs. 5 million or more)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attached"]
[]
[null,null,"(Above documents are mandatory)"]
[]
["Note",null,"Under Income Support Levy Act, 2013, levy is to be deposited along with wealth statement"]
["Verification"," I, ",null,null,null,null,null,null,null,null,null,null,null,"Acknowledgement"]
[null,"holder of CNIC No. ",null,null,null,null,null,null,null,null,", in my capacity as"]
[]
[]
[null,"Self/ Partner or Member of Association of Persons/ Representative (as defined in section 172 of the Income Tax Ordinance, 2001)  of  Taxpayer  named  above,  do  solemnly  declare  that  to  the best of my knowledge and belief the information  given in this Return/Statement u/s 115(4) and the attached Annex(es), Statement(s), Document(s) or Detail(s) is/are correct and complete in accordance with the provisions of the Income Tax Ordinance, 2001 and Income Tax Rules, 2002 (The alternative in the verification, which is not applicable, should be scored out)."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signatures & Stamp"]
[null," Date : ",null,null,null,null,null,null,"Signatures:",null,null,null,null,null,"of Receiving Officer with Date "]
[]
[" Note-1 : Grey blank fields are for official use           "]

{"sheet":"Annex-A","index":4,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[37,11,37,16],[38,11,38,16],[35,0,41,0],[5,13,5,15],[6,13,6,14],[6,15,7,15],[6,10,7,10],[6,11,7,11],[26,2,26,7],[26,15,26,18],[42,2,44,19],[41,2,41,8],[34,2,34,7],[35,2,40,7],[31,17,33,17],[42,0,44,1],[33,15,33,16],[34,11,34,16],[35,11,35,16],[36,11,36,16],[5,16,7,16],[5,17,7,17],[5,18,7,18],[5,19,7,19],[28,19,33,19],[27,15,27,18],[26,9,27,12],[5,8,7,8],[18,2,18,7],[11,2,11,7],[12,2,12,7],[5,10,5,11],[5,12,7,12],[10,2,10,7],[15,2,15,7],[8,2,8,7],[9,2,9,7],[25,2,25,7],[0,18,0,19],[1,18,1,19],[1,0,1,17],[0,0,0,17],[19,2,19,7],[24,2,24,7],[5,0,7,0],[5,1,7,1],[5,2,7,7],[33,2,33,7],[3,18,3,19],[29,0,31,0],[32,2,32,7],[8,0,25,0],[17,2,17,7],[21,2,21,7],[28,2,28,7],[13,2,13,7],[31,8,31,10],[14,2,14,7],[32,9,32,10],[20,2,20,7],[3,3,3,5],[3,15,3,17],[32,15,32,16],[5,9,7,9],[16,2,16,7],[29,2,29,7],[27,2,27,7],[41,11,41,17],[31,2,31,7],[39,11,40,17],[22,2,22,7],[23,2,23,7],[25,13,33,14],[28,12,33,12],[28,15,31,16],[25,16,25,17]]}
["Annex - A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
["Depreciation, Initial Allowance and Amortization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[]
[null,"NTN",null,{"$f":"'Control Centre'!$X$4","v":0},null,null,null,null,null,null,null,null,null,null,null,"           CNIC for Individual",null,null,{"$f":"'Control Centre'!$G$5","v":0}]
[]
["Type","Sr. #","Description",null,null,null,null,null,"Code","WDV (BF)","Additions",null,"Deletions","Initial Allowance",null,null,"Rate (%)","Extent (%)","Depreciation","WDV (CF)"]
[null,null,null,null,null,null,null,null,null,null,"New","Previously used in Pakistan",null,"Rate (%)",null,"Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"New","Old"]
["Depreciable Assets",1,"Building (all types)",null,null,null,null,null,3202,null,null,null,null,0.25,0,{"$f":"ROUND(K9*N9,0)","v":0},0.1,null,{"$f":"ROUND((J9+K9+L9-M9-P9)*Q9*R9,0)","v":0},{"$f":"ROUND((J9+K9+L9-M9-P9)-(J9+K9+L9-M9-P9)*Q9,0)","v":0}]
[null,2,"Machinery and plant (not otherwise specified)",null,null,null,null,null,320301,null,null,null,null,0.5,0,{"$f":"ROUND(K10*N10,0)","v":0},0.15,null,{"$f":"ROUND((J10+K10+L10-M10-P10)*Q10*R10,0)","v":0},{"$f":"ROUND((J10+K10+L10-M10-P10)-(J10+K10+L10-M10-P10)*Q10,0)","v":0}]
[null,3,"Computer hardware (including allied items)",null,null,null,null,null,320302,null,null,null,null,0.5,0,0,0.3,null,0,0]
[null,4,"Furniture (including fittings)",null,null,null,null,null,320303,null,null,null,null,0,0,0,0.15,null,0,0]
[null,5,"Technical and professional books",null,null,null,null,null,320304,null,null,null,null,0.5,0,0,0.15,null,0,0]
[null,6,"Below ground installations of mineral oil concerns",null,null,null,null,null,320306,null,null,null,null,0.5,0,0,1,null,0,0]
[null,7,"Off shore installations of mineral oil concerns",null,null,null,null,null,320307,null,null,null,null,0.5,0,0,0.2,null,0,0]
[null,8,"Machinery and equipment used in manufacture of IT products",null,null,null,null,null,320308,null,null,null,null,0.5,0,0,0.3,null,0,0]
[null,9,"Motor vehicles (not plying for hire)",null,null,null,null,null,32041,null,null,null,null,0,0,0,0.15,null,0,0]
[null,10,"Motor vehicles (plying for hire)",null,null,null,null,null,32042,null,null,null,null,0.5,0,0,0.15,null,0,0]
[null,11,"Ships",null,null,null,null,null,32043,null,null,null,null,0.5,0,0,0.15,null,0,0]
[null,12,"Air crafts and aero engines",null,null,null,null,null,32044,null,null,null,null,0.5,0,0,0.3,null,0,0]
[null,13,"Machinery and equipment Qualifying for 1st year Allowance",null,null,null,null,null,320309,null,null,null,null,0.9,0,0,0.15,1,0,0]
[null,14,"Computer hardware including printer, monitor and allied items, that have been used previously in Pakistan",null,null,null,null,null,320312,null,null,null,null,0,0,0,0.5,null,0,0]
[null,15,"Any plant or machinery that has been used previously in Pakistan",null,null,null,null,null,320310,null,null,null,null,0,0,0,0.15,null,0,0]
[null,16,"Any plant or machinery in relation to which a deduction has been allowed under another section for the entire cost of the asset in the tax year in which the asset is acquired.",null,null,null,null,null,320311,null,null,null,null,0,0,0,0.15,null,0,0]
[null,17,"Ramp for Disabled Persons",null,null,null,null,null,320312,0,null,null,null,1,0,0,1,1,0,0]
[null,18,"Total",null,null,null,null,null,null,{"$f":"SUM(J9:J25)","v":0},{"$f":"SUM(K9:K25)","v":0},{"$f":"SUM(L9:L25)","v":0},{"$f":"SUM(M9:M25)","v":0},".",null,{"$f":"SUM(P9:P25)","v":0},null,null,{"$f":"SUM(S9:S25)","v":0},{"$f":"SUM(T9:T25)","v":0}]
[null,19,"Total Depreciation (Initial plus Normal) ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P26+S26","v":0}]
[null,20,"Proportionate Depreciation in case of transitional tax year "]
[null,null,"Description",null,null,null,null,null,"Code","Acquisition Date","Useful Life(Years)","Original Cost",null,null,null,null,null,"Extent (%)","Amortization"]
["Intangibles",21,"Intangibles",null,null,null,null,null,3205]
[null,22,"Expenditure providing long term advantage/benefit",null,null,null,null,null,3207]
[null,23,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L31)","v":0},null,null,null,null,null,null,{"$f":"SUM(S30:S31)","v":0}]
[null,null,"Description",null,null,null,null,null,"Code",null,null,"Original Expenditure",null,null,null,"Rate (%)",null,null,"Amortization"]
[null,24,"Pre commencement expenditure",null,null,null,null,null,3206,null,null,null,null,null,null,0.2]
[null,null,"Description",null,null,null,null,null,"Code","Amount","Tax Year","Description",null,null,null,null,null,"Code","Amount","Tax Year"]
["Brought Forward Adjustments",25,"Unadjusted Business loss for previous year (s) adjusted against Business income for current year",null,null,null,null,null,3902,null,2007,"Unabsorbed Amortization of intangibles / expenditure providing long term advantage/benefit for previous year(s) adjusted against Business Income for current year",null,null,null,null,null,3987,null,"upto 2012"]
[null,26,null,null,null,null,null,null,3902,null,2008,"Amortization of intangibles / expenditure providing long term advantage/benefit for current year adjusted against Business Income for current year",null,null,null,null,null,3987,null,2013]
[null,27,null,null,null,null,null,null,3902,null,2009,"Unabsorbed tax depreciation/initial allowance of fixed assets for previous year(s) adjusted against Business Income for current year",null,null,null,null,null,3988,null,"upto 2012"]
[null,28,null,null,null,null,null,null,3902,null,2010,"Depreciation/initial allowance of fixed assets for current year adjusted against Business Income for current year",null,null,null,null,null,3988,null,2013]
[null,29,null,null,null,null,null,null,3902,null,2011]
[null,30,null,null,null,null,null,null,3902,null,2012]
[null,31,"Total (Not exceeding the amount of Business Income available for adjustment) (transfer to Sr. 15 of Main Return)",null,null,null,null,null,null,{"$f":"SUM(J36:J41)","v":0},null,"Total (Not exceeding the amount of Business Income available for adjustment) (transfer to Sr. 16 of Main Return)",null,null,null,null,null,null,{"$f":"SUM(S36:S39)","v":0}]
[null,null,"Signature    ____________________\n"]

{"sheet":"Annex-B","index":5,"n_rows":72,"n_cols":59,"rows_kept":72,"cut":false,"hidden":false,"merged":[[9,4,9,37],[9,38,9,40],[59,2,59,3],[59,38,59,40],[60,17,60,37],[0,8,1,40],[57,38,57,40],[56,2,56,3],[55,2,55,3],[55,4,55,37],[71,4,71,37],[67,38,67,40],[62,38,62,40],[63,38,63,40],[48,34,48,37],[60,38,60,40],[56,38,56,40],[63,4,63,12],[58,38,58,40],[58,4,58,37],[60,4,60,12],[61,13,61,16],[61,4,61,12],[58,2,58,3],[57,2,57,3],[60,2,63,3],[62,13,62,16],[51,2,54,3],[54,34,54,37],[52,12,52,19],[52,20,52,33],[54,12,54,19],[8,41,8,47],[33,4,33,37],[11,38,11,40],[20,41,20,47],[29,34,29,37],[10,41,10,47],[29,4,29,11],[11,41,11,47],[12,41,12,47],[38,41,38,47],[30,41,30,47],[23,41,23,47],[29,41,29,47],[26,41,26,47],[33,41,34,47],[27,41,28,47],[32,41,32,47],[37,41,37,47],[53,41,53,47],[35,41,35,47],[48,41,48,47],[47,41,47,47],[40,41,41,47],[42,41,42,47],[43,41,43,47],[19,38,19,40],[24,41,24,47],[21,41,21,47],[19,41,19,47],[22,41,22,47],[39,41,39,47],[26,38,26,40],[27,38,28,40],[24,38,24,40],[35,38,35,40],[32,38,32,40],[34,10,34,17],[29,12,29,19],[30,38,30,40],[31,38,31,40],[28,4,28,11],[31,20,31,33],[31,34,31,37],[28,34,28,37],[39,2,39,3],[41,20,41,33],[43,20,43,33],[42,4,42,11],[40,2,40,3],[43,12,43,19],[41,12,41,19],[39,4,39,37],[42,12,42,19],[40,4,40,37],[33,2,33,3],[8,38,8,40],[6,2,7,37],[10,2,10,3],[11,4,11,37],[11,2,11,3],[10,4,10,37],[10,38,10,40],[29,38,29,40],[25,38,25,40],[6,41,7,47],[25,2,25,3],[8,2,8,3],[12,2,12,3],[12,38,12,40],[12,4,12,37],[25,41,25,47],[21,38,21,40],[22,38,22,40],[23,38,23,40],[0,41,0,47],[3,34,3,47],[3,6,3,13],[5,2,5,47],[16,2,16,3],[14,4,14,37],[3,2,3,4],[1,41,1,47],[3,25,3,33],[6,38,7,40],[8,4,8,37],[16,4,16,37],[27,4,27,37],[34,4,34,9],[25,4,25,37],[23,4,23,37],[31,12,31,19],[30,34,30,37],[31,4,31,11],[30,20,30,33],[20,38,20,40],[18,4,18,11],[18,12,18,19],[19,20,19,33],[20,20,20,33],[20,34,20,37],[19,34,19,37],[20,4,20,11],[18,34,18,37],[18,20,18,33],[22,2,22,3],[26,2,26,3],[20,12,20,19],[21,2,21,3],[19,4,19,11],[23,2,23,3],[21,4,21,37],[24,4,24,37],[22,4,22,37],[19,12,19,19],[38,4,38,37],[35,4,35,9],[35,10,35,17],[36,4,36,9],[28,20,28,33],[29,20,29,33],[28,12,28,19],[38,2,38,3],[24,2,24,3],[32,2,32,3],[32,4,32,37],[38,38,38,40],[27,2,27,3],[30,4,30,11],[30,12,30,19],[26,4,26,37],[33,38,34,40],[45,2,45,3],[45,4,45,37],[42,34,42,37],[44,34,44,37],[47,4,47,11],[46,4,46,11],[46,34,46,37],[44,20,44,33],[43,4,43,11],[42,20,42,33],[50,2,50,3],[48,20,48,33],[48,4,48,11],[48,12,48,19],[49,4,49,11],[49,12,49,19],[49,20,49,33],[53,38,53,40],[65,41,65,47],[50,38,51,40],[64,38,64,40],[59,41,59,47],[57,41,57,47],[54,38,54,40],[62,41,62,47],[50,41,51,47],[61,38,61,40],[63,41,63,47],[56,41,56,47],[49,41,49,47],[58,41,58,47],[60,41,60,47],[55,41,55,47],[61,41,61,47],[52,41,52,47],[44,41,44,47],[45,41,46,47],[40,38,41,40],[44,38,44,40],[42,38,42,40],[45,38,46,40],[43,38,43,40],[67,41,67,47],[49,34,49,37],[49,38,49,40],[54,41,54,47],[66,38,66,40],[65,38,65,40],[55,38,55,40],[52,38,52,40],[53,34,53,37],[62,17,62,37],[64,41,64,47],[66,41,66,47],[47,34,47,37],[43,34,43,37],[48,38,48,40],[56,4,56,37],[47,38,47,40],[50,4,50,37],[51,4,51,11],[47,12,47,19],[6,0,57,1],[16,38,17,40],[16,41,17,47],[17,4,17,11],[17,12,17,19],[17,20,17,33],[17,34,17,37],[18,38,18,40],[18,41,18,47],[31,41,31,47],[36,38,36,40],[36,10,36,17],[36,18,36,27],[35,18,35,27],[35,28,35,37],[34,18,34,27],[34,28,34,37],[36,28,36,37],[39,38,39,40],[51,12,51,19],[51,20,51,33],[47,20,47,33],[46,12,46,19],[51,34,51,37],[46,20,46,33],[44,12,44,19],[44,4,44,11],[41,34,41,37],[41,4,41,11],[52,34,52,37],[36,41,36,47],[37,4,37,9],[37,10,37,17],[37,18,37,27],[37,28,37,37],[37,38,37,40],[53,4,53,11],[53,12,53,19],[53,20,53,33],[63,13,63,16],[63,17,63,37],[60,13,60,16],[59,4,59,37],[57,4,57,37],[54,20,54,33],[61,17,61,37],[66,17,66,37],[66,4,66,12],[65,17,65,37],[65,4,65,12],[65,13,65,16],[62,4,62,12],[66,13,66,16],[71,0,71,1],[15,38,15,40],[71,38,71,40],[59,0,70,1],[68,38,68,40],[64,2,64,3],[64,4,64,37],[69,2,69,3],[69,17,69,37],[69,38,69,40],[71,2,71,3],[70,4,70,37],[69,41,69,47],[71,41,71,47],[67,4,67,12],[67,13,67,16],[67,17,67,37],[68,41,68,47],[68,4,68,12],[68,13,68,16],[14,38,14,40],[14,41,14,47],[15,4,15,37],[70,2,70,3],[70,38,70,40],[70,41,70,47],[68,17,68,37],[65,2,68,3],[52,4,52,11],[54,4,54,11],[3,0,3,1],[46,2,49,3],[9,2,9,3],[15,41,15,47],[13,2,13,3],[14,2,14,3],[15,2,15,3],[13,4,13,37],[13,38,13,40],[13,41,13,47],[8,50,8,56],[9,50,9,56],[9,41,9,47],[22,49,22,55],[58,0,58,1],[0,0,1,7],[41,2,44,3],[34,2,37,3],[28,2,31,3],[17,2,20,3]]}
[null,null,null,null,null,null,null,null,"Annex-B\nTax Already 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,null,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[]
[null,null,"NTN ",null,null,null,{"$f":"'Control Centre'!$X$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CNIC (for individual) ",null,null,null,null,null,null,null,null,{"$f":"'Control Centre'!$G$5","v":0}]
[]
[]
["Tax Collected/Deducted at Source (Adjustable Tax only)",null,"Particulars",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code",null,null,"Amount of Tax deducted (Rs.)"]
[]
[null,null,1,null,"On import of goods (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94019,null,null,{"$f":"IF('Annex-J'!N17=\"Yes\",'Annex-B'!AY9+SUM('INDIVIDUAL-AOP (2 of 2)'!P8:S11),'Annex-B'!AY9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax paid against Sr.# 1"]
[null,null,2,null,"On Realization of Export proceeds (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94020,null,null,{"$f":"IF('Annex-J'!R17=\"Yes\",SUM('INDIVIDUAL-AOP (2 of 2)'!P26:S28)+'Annex-B'!AY10,'Annex-B'!AY10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax paid against Sr.# 2"]
[null,null,3,null,"From salary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94029]
[null,null,4,null,"On dividend Income (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94039]
[null,null,5,null,"On Government securities ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94043]
[null,null,6,null,"On sale or Transfer of Immovable Property @ 0.5% u/s 236C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94040]
[null,null,7,null,"On Sale to traders and distributors u/s 153A @ 0.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,null,null,null,null,null,null,94041]
[null,null,8,null,"On disposal of listed securities u/s 100B (Collected by NCCPL)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94042]
[null,null,9,null,"On profit on debt (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94049,null,null,{"$f":"SUM(AP19:AV21)","v":0}]
[null,null,null,null,"Certificate/Account No. etc.",null,null,null,null,null,null,null,"Bank",null,null,null,null,null,null,null,"Branch",null,null,null,null,null,null,null,null,null,null,null,null,null,"Share%"]
[]
[]
[]
[null,null,10,null,"On payments received by non-resident (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,940539]
[null,null,11,null,"On payments for goods (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+AP23<>0,\"ü\",\"\")","v":""},null,940619,null,null,{"$f":"IF('Annex-J'!V17=\"Yes\",SUM('INDIVIDUAL-AOP (2 of 2)'!P20:S22)+'Annex-B'!AX23,AX23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax paid against Sr.# 11"]
[null,null,12,null,"On payments for services (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+AP24<>0,\"ü\",\"\")","v":""},null,940629]
[null,null,13,null,"On payments for execution of contracts (other than tax deduction treated as final tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,null,null,940639]
[null,null,14,null,"On property income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,null,null,940640]
[null,null,15,null,"On withdrawal from pension fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94028]
[null,null,16,null,"On cash withdrawal from bank ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AP30:AP32)<>0,\"ü\",\"\")","v":""},null,94119,null,null,{"$f":"SUM(AP30:AV32)","v":0}]
[null,null,null,null,"Certificate/Account No. etc.",null,null,null,null,null,null,null,"Bank",null,null,null,null,null,null,null,"Branch",null,null,null,null,null,null,null,null,null,null,null,null,null,"Share%"]
[]
[]
[]
[null,null,17,null,"On certain transactions in bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+AP33<>0,\"ü\",\"\")","v":""},null,94120,null,null,null,null,null,null,null,null,null,"`"]
[null,null,18,null,"With Motor Vehicle Registration Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AP36:AP38)<>0,\"ü\",\"\")","v":""},null,94179,null,null,{"$f":"SUM(AP36:AV38)","v":0}]
[null,null,null,null,"Registration No.",null,null,null,null,null,"Engine / Seating Capacity",null,null,null,null,null,null,null,"Owner's Name",null,null,null,null,null,null,null,null,null,"Manufacturer Particulars"]
[]
[]
[]
[null,null,19,null,"On sale/purchase/trading of shares through a Member of Stock Exchange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+AP39<>0,\"ü\",\"\")","v":""},null,94131]
[null,null,20,null,"On financing of carry over trade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+AP40<>0,\"ü\",\"\")","v":""},null,94139]
[null,null,21,null,"With motor vehicle token tax  (Other than goods transport vehicles)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AP43:AP45)<>0,\"ü\",\"\")","v":""},null,94149,null,null,{"$f":"SUM(AP43:AV45)","v":0}]
[null,null,null,null,"Registration No.",null,null,null,null,null,null,null,"Engine / Seating Capacity",null,null,null,null,null,null,null,"Owner's Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Share%"]
[]
[]
[]
[null,null,22,null,"With bill for electricity consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AP48:AP50)<>0,\"ü\",\"\")","v":""},null,94159,null,null,{"$f":"SUM(AP48:AV50)","v":0}]
[null,null,null,null,"Consumer No.",null,null,null,null,null,null,null,"Subscriber's CNIC",null,null,null,null,null,null,null,"Subscriber's Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Share%"]
[]
[]
[]
[null,null,23,null,"With telephone bills, mobile phone and pre-paid cards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AP53:AP55)<>0,\"ü\",\"\")","v":""},null,94169,null,null,{"$f":"SUM(AP53:AV55)","v":0}]
[null,null,null,null,"Number",null,null,null,null,null,null,null,"Subscriber's CNIC",null,null,null,null,null,null,null,"Subscriber's Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Share%"]
[]
[]
[]
[null,null,24,null,"On Sale by Auction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AP59:AP61)<>0,\"ü\",\"\")","v":""},null,94180]
[null,null,25,null,"On purchase of domestic air travel ticket",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence of payment attached",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+AP57<>0,\"ü\",\"\")","v":""},null,94121]
[null,null,26,null,"Total Tax Deductions at source (Adjustable Tax) [Sum of 1 to 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,null,null,null,null,null,null,94599,null,null,{"$f":"SUM(AP9:AV18)+SUM(AP22:AV29)+SUM(AP33:AV35)+SUM(AP39:AV42)+AP46+AP51+AP56+AP57","v":0}]
[null,null,27,null,"Total Tax Deductions at source (Final Tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94591]
["Tax Payments",null,28,null,"Advance Tax U/S 147(1) [ a + b + c + d]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9461,null,null,{"$f":"SUM(AP61:AV64)","v":0}]
[null,null,null,null,"a. First installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,null,null,"b. Second installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,null,null,"c. Third installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,null,null,"d. Fourth installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,29,null,"Advance Tax U/S 147(5B) [ a + b + c + d]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9461,null,null,{"$f":"SUM(AP66:AV69)","v":0}]
[null,null,null,null,"a. First installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,null,null,"b. Second installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,null,null,"c. Third installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,null,null,"d. Fourth installment",null,null,null,null,null,null,null,null,"CPR No."]
[null,null,30,null,"Admitted Tax Paid U/S 137(1) CPR No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9471]
[null,null,31,null,"Total Tax Payments [26 + 27 + 28 + 29+30]  (Transfer to Sr. 48 of Main Return)",null,null,null,null,null,null,null,null,null,null,null,null,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(AP58:AV60)+AP65+AP70","v":0}]
[null,null,32,null,"WWF Payable with Return (WWF payable will be adjusted against the excess payments made during the current year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9308]

{"sheet":"Annex-C","index":6,"n_rows":67,"n_cols":49,"rows_kept":67,"cut":false,"hidden":false,"merged":[[14,1,15,1],[14,6,14,30],[14,31,15,38],[14,39,15,47],[14,48,15,55],[15,6,15,30],[1,48,1,55],[10,1,11,1],[10,6,10,30],[10,31,11,38],[7,2,7,30],[7,31,7,38],[7,39,7,47],[7,48,7,55],[2,48,2,55],[5,43,5,47],[3,0,5,0],[3,1,3,3],[3,4,3,42],[3,43,3,47],[3,48,3,55],[4,1,4,3],[4,4,4,42],[4,43,4,47],[4,48,4,55],[5,4,5,42],[5,48,5,55],[6,0,20,0],[6,1,7,1],[6,2,6,30],[6,31,6,38],[6,39,6,47],[6,48,6,55],[8,1,9,1],[8,6,8,30],[8,31,9,38],[8,39,9,47],[8,48,9,55],[9,6,9,30],[10,39,11,47],[10,48,11,55],[11,6,11,30],[12,1,13,1],[12,6,12,30],[12,31,13,38],[12,39,13,47],[12,48,13,55],[13,6,13,30],[21,0,21,55],[16,1,17,1],[16,6,16,30],[16,31,17,38],[16,39,17,47],[16,48,17,55],[17,6,17,30],[23,0,23,3],[23,36,23,55],[2,3,2,47],[1,3,1,47],[1,0,2,2],[18,1,18,30],[18,31,18,38],[18,39,18,47],[18,48,18,55],[19,1,20,55]]}
[]
[null,null,null,"Annex C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,"Breakup of Sales in case of Multiple Businesses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,"Taxpayer Name",null,null,{"$f":"'Control Centre'!$G$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NTN",null,null,null,null,{"$f":"'Control Centre'!$X$4","v":0}]
[null,"CNIC/Reg.No.",null,null,{"$f":"'Control Centre'!$G$5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax Year",null,null,null,null,2013]
[null,"Business Name",null,null,{"$f":"'Control Centre'!$G$6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTO/LTU",null,null,null,null,{"$f":"'Control Centre'!X12","v":0}]
["BUSINESS WISE BREAKUP OF SALES","Sr."," Business Name & Business Activity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales",null,null,null,null,null,null,null,"Cost of Sales",null,null,null,null,null,null,null,null,"Gross Profit/Loss"]
[null,null,"(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2)",null,null,null,null,null,null,null,"(3)",null,null,null,null,null,null,null,null,"(4) = (2) - (3)"]
[null,1," Business Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AF9-AN9","v":0}]
[null,null," Business Activity"]
[null,2," Business Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AF11-AN11","v":0}]
[null,null," Business Activity"]
[null,3," Business Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AF13-AN13","v":0}]
[null,null," Business Activity"]
[null,4," Business Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AF15-AN15","v":0}]
[null,null," Business Activity"]
[null,5," Business Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AF17-AN17","v":0}]
[null,null," Business Activity"]
[null,"Total (to be reconciled with Sr. 1, 2 & 7 of Main Return)",null,null,null,null,null,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(AF9:AM18)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AN9:AV18)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AW9:BD18)","v":0}]
[null,"Signature: "]
[]
["Note : Grey blank fields are for official use "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,41]
[null,42,"Tax Payable/ Refundable [38 + 39 - 40 - 41 + WWF Payable from Sr. 27 of Annex-B]"]
[null,43]

{"sheet":"Annex-D","index":7,"n_rows":20,"n_cols":34,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,5,0,29],[0,30,0,35],[1,5,1,29],[1,30,1,35],[2,3,2,8],[2,9,2,29],[2,30,2,35],[17,2,18,2],[4,1,16,1],[17,1,18,1],[15,3,15,29],[15,30,15,35],[8,3,8,29],[5,3,5,29],[5,30,5,35],[6,3,6,29],[6,30,6,35],[3,3,3,8],[3,9,3,19],[3,20,3,29],[3,30,3,35],[4,3,4,29],[4,30,4,35],[7,3,7,29],[7,30,7,35],[8,30,8,35],[9,3,9,29],[9,30,9,35],[10,3,10,29],[10,30,10,35],[11,3,11,29],[11,30,11,35],[18,33,18,35],[12,3,12,29],[12,30,12,35],[13,3,13,29],[13,30,13,35],[14,3,14,29],[14,30,14,35],[19,1,23,35],[24,1,24,35],[0,1,1,4],[2,1,3,2],[16,3,16,29],[16,30,16,35],[17,3,18,29],[17,30,17,32],[17,33,17,35],[18,30,18,32]]}
[null,null,null,null,null,"Annex - D",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]
[null,null,null,null,null,"Details of Personal Expenses (for individual)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,null,null,"Taxpayer Name",null,null,null,null,null,{"$f":"'Control Centre'!$G$4","v":0}]
[null,null,null,"NTN",null,null,null,null,null,{"$f":"'Control Centre'!$X$4","v":0},null,null,null,null,null,null,null,null,null,null,"CNIC (for individual) ",null,null,null,null,null,null,null,null,null,{"$f":"'Control Centre'!$G$5","v":0}]
[null,"PERSONAL EXPENSES","Sr"," Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenses"]
[null,null,1," Residence electricity bills"]
[null,null,2," Residence telephone/mobile/internet bills"]
[null,null,3," Residence gas bills"]
[null,null,4,"Residence rent/ground rent/property tax/fire insurance/security services/water bills"]
[null,null,5,"Education of children/ spouse/ self (Optional, it can be included in Sr-9)"]
[null,null,6,"Travelling (foreign and local) (Optional, it can be included in Sr-9)"]
[null,null,7," Running and maintenance expenses of Motor vehicle(s)"]
[null,null,8,"Club membership fees/bills"]
[null,null,9,"Other personal and household expenses"]
[null,null,10," Total personal expenses (Sum of 1 to 9) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Total personal expenses",null,null,{"$f":"SUM(AE6:AJ14)","v":0}]
[null,null,11," (Less) Contribution by family members ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Total personal expenses"]
[null,null,12," Net Personal Expenses (10 - 11) transfer to Sr-52 of Main Return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Total personal expenses",null,null,{"$f":"AE15-AE16","v":0}]
[null,null,13,"Number of family members/dependents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adults",null,null,"Minor"]
[]
[null,"Signature: _____________________     "]

{"sheet":"Annex-E","index":8,"n_rows":79,"n_cols":43,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,6,0,37],[1,6,1,37],[2,6,2,37],[3,0,3,5],[3,6,3,29],[6,4,6,37],[0,0,1,5],[8,42,8,48],[9,2,9,3],[9,4,9,37],[9,38,9,41],[9,42,9,48],[8,4,8,37],[7,42,7,48],[4,4,4,37],[4,38,4,41],[4,42,4,48],[5,2,5,3],[5,4,5,37],[7,4,7,37],[29,2,29,3],[30,2,30,3],[31,2,31,3],[10,0,31,1],[4,0,9,1],[4,2,4,3],[6,2,6,3],[8,2,8,3],[7,2,7,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[5,38,5,41],[8,38,8,41],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[0,38,0,48],[1,38,1,48],[2,38,2,48],[3,38,3,48],[10,38,10,41],[21,42,21,48],[5,42,5,48],[6,38,6,41],[6,42,6,48],[7,38,7,41],[10,42,10,48],[11,38,11,41],[11,42,11,48],[14,42,14,48],[15,42,15,48],[16,42,16,48],[15,38,15,41],[19,42,19,48],[24,42,24,48],[25,42,25,48],[23,4,23,37],[23,38,23,41],[24,4,24,37],[24,38,24,41],[20,42,20,48],[22,42,22,48],[26,42,26,48],[27,42,27,48],[28,42,28,48],[29,42,29,48],[30,42,30,48],[12,42,12,48],[13,42,13,48],[23,42,23,48],[17,42,17,48],[18,42,18,48],[31,42,31,48],[31,4,31,37],[31,38,31,41],[29,4,29,37],[15,2,15,3],[29,38,29,41],[30,4,30,37],[30,38,30,41],[27,4,27,37],[27,38,27,41],[28,4,28,37],[28,38,28,41],[25,4,25,37],[25,38,25,41],[26,4,26,37],[26,38,26,41],[15,4,15,37],[21,4,21,37],[21,38,21,41],[22,4,22,37],[22,38,22,41],[20,4,20,37],[20,38,20,41],[19,4,19,37],[19,38,19,41],[10,4,10,37],[11,4,11,37],[12,4,12,37],[13,4,13,37],[13,38,13,41],[14,4,14,37],[12,38,12,41],[14,38,14,41],[32,0,34,48],[35,0,35,48],[16,4,16,37],[16,38,16,41],[16,2,16,3],[17,4,17,37],[17,38,17,41],[17,2,17,3],[18,4,18,37],[18,38,18,41]]}
[null,null,null,null,null,null,"Annex - E",null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,"Deductions (Admissible & Inadmissible)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E"]
["Taxpayer Name",null,null,null,null,null,{"$f":"'Control Centre'!$G$4","v":0}]
["NTN",null,null,null,null,null,{"$f":"'Control Centre'!$X$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," CNIC (for individual) ",null,null,null,null,null,null,null,{"$f":"'Control Centre'!$G$5","v":0}]
["Admissible Deductions",null,"Sr.",null,"Particulars",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code",null,null,null,"Amount (Rs.)"]
[null,null,1,null,"Tax Amortization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319287]
[null,null,2,null,"Tax Depreciation (If Sr. 20 of Annex-A > 0, then Sr. 20 else Sr. 19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319288,null,null,null,{"$f":"IF('Annex-A'!P28>0,'Annex-A'!P28,'Annex-A'!P27)","v":0}]
[null,null,3,null,"Income/(Loss) relating to Final and Fixed tax ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319289]
[null,null,4,null,"Other Admissible Deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319298]
[null,null,5,null,"Total [Add 1 to 4] to be transferred  to Sr-14 of main return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3192,null,null,null,{"$f":"SUM(AQ6:AW9)","v":0}]
["Deductions not allowed / inadmissible",null,1,null,"Cess, rate or tax that is levied on the profits or gains or assessed as a percentage or otherwise on the basis of profits or gains",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319101]
[null,null,2,null,"Salary, rent, brokerage or commission, profit on debt, payment to non-resident, payment for services or fee from which the company was liable to deduct tax at source unless the company has deducted and paid the tax as required by the Income Tax Ordinance, 2001",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319102]
[null,null,3,null,"Entertainment expenditure in excess of prescribed limits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319104]
[null,null,4,null,"Contribution to an un-recognized provident fund, pension fund, superannuation fund or gratuity fund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319105]
[null,null,5,null,"Contribution to a provident fund or other fund established for the benefit of the employees, unless effective arrangements have been made to deduct tax at source in respect of which the recipient is chargeable to tax under the head \"salary\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319106]
[null,null,6,null,"Fine or penalty for the violation of any law, rule or regulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319107]
[null,null,7,null,"Personal expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319108]
[null,null,8,null,"Provisions or amounts carried to reserves or funds etc. or capitalised in any way",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319109]
[null,null,9,null,"Profit on debt, brokerage, commission, salary or other remuneration paid by an AOP to its members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319110]
[null,null,10,null,"Any salary, rent, brokerage or commission, profit ondebt, payment to non-resident or payment for services or fee on which tax was required to be deducted and paid but was not deducted and 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,null,null,null,null,null,null,319111]
[null,null,11,null,"Expenditure under a single account head which, in aggregate, exceeds Rs. 50,000 paid otherwise than by a crossed bank cheque or crossed bank draft (excluding expenditures not exceeding Rs. 10,000 or on account of freight charges, travel fare, postage, utilities or payment of taxes, duties, fees, fines or any other statutory obligation)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319112]
[null,null,12,null,"Salary exceeding Rs. 15,000 per month paid otherwise than by a crossed cheque or direct transfer of the funds to the employee's bank account",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319113]
[null,null,13,null,"Capital expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319114]
[null,null,14,null,"Provisions for bad debts, obsolete stocks, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319115]
[null,null,15,null,"Apportionment of expenditure including profit on debt, financial cost and lease payments relatable or attributable to non-business activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319116]
[null,null,16,null,"Mark-up on lease financing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319118]
[null,null,17,null,"Accounting pre-commencement expenditure written off",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319120]
[null,null,18,null,"Accounting loss on disposal of depreciable assets / intangibles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319121]
[null,null,19,null,"Accounting amortization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319123]
[null,null,20,null,"Accounting depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319124]
[null,null,21,null,"Any other (please specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319125]
[null,null,22,null,"Total [Add 1 to 21] to be transferred  to Sr-13 of main return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3191,null,null,null,{"$f":"SUM(AQ11:AQ31)","v":0}]
["Signature   _______________________  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Tax Payments  (Transfer from Sr. 28 of Annex-B)"]

{"sheet":"Annex-F","index":9,"n_rows":63,"n_cols":47,"rows_kept":63,"cut":false,"hidden":false,"merged":[[33,24,33,29],[34,30,34,32],[48,33,48,39],[48,21,48,23],[28,21,28,23],[29,24,29,29],[40,24,40,29],[40,30,40,32],[40,33,40,39],[31,24,31,29],[45,40,45,46],[43,33,43,39],[43,40,43,46],[45,30,45,32],[43,5,43,20],[48,3,48,20],[45,21,45,23],[44,40,44,46],[43,24,43,29],[43,30,43,32],[44,24,44,29],[45,33,45,39],[45,24,45,29],[44,30,44,32],[44,33,44,39],[50,1,50,4],[49,5,49,20],[45,1,45,4],[46,1,46,4],[46,5,46,20],[32,1,32,4],[33,1,33,4],[23,5,23,20],[51,5,51,20],[47,1,47,2],[48,1,48,2],[49,1,49,4],[50,5,50,20],[39,1,39,2],[51,1,51,4],[29,1,29,2],[28,3,28,20],[20,3,20,20],[21,5,21,20],[30,5,30,20],[24,5,24,20],[28,1,28,2],[29,3,29,20],[27,30,27,32],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[35,1,35,2],[24,1,24,4],[25,1,25,2],[26,1,26,2],[23,1,23,4],[20,24,20,29],[27,21,27,23],[27,24,27,29],[22,5,22,20],[19,3,19,20],[22,24,22,29],[21,21,21,23],[21,24,21,29],[20,21,20,23],[21,1,21,4],[27,33,27,39],[27,40,27,46],[25,21,25,23],[25,30,25,32],[26,24,26,29],[26,30,26,32],[26,33,26,39],[26,40,26,46],[25,40,25,46],[25,24,25,29],[20,40,20,46],[20,30,20,32],[20,33,20,39],[9,30,9,32],[9,33,9,39],[19,40,19,46],[13,40,13,46],[10,30,10,32],[10,33,10,39],[10,40,10,46],[55,1,55,2],[52,5,52,20],[52,1,52,4],[56,1,56,20],[35,3,35,20],[36,1,36,20],[37,3,37,20],[38,0,38,20],[40,3,40,20],[47,3,47,20],[8,3,8,20],[44,5,44,20],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[39,3,39,20],[8,1,8,2],[18,0,18,23],[37,1,37,2],[33,21,33,23],[31,21,31,23],[34,21,34,23],[25,3,25,20],[19,21,19,23],[17,3,17,20],[30,1,30,4],[19,1,19,2],[20,1,20,2],[22,1,22,4],[26,21,26,23],[14,3,14,20],[0,0,1,5],[4,0,6,20],[4,21,6,23],[0,6,0,36],[10,3,10,20],[11,3,11,20],[9,21,9,23],[9,24,9,29],[3,10,3,29],[9,3,9,20],[3,0,3,9],[8,21,8,23],[8,24,8,29],[7,40,7,46],[7,1,7,20],[7,24,7,29],[7,30,7,32],[7,33,7,39],[3,30,3,36],[7,21,7,23],[4,24,6,29],[8,30,8,32],[8,33,8,39],[56,21,56,23],[56,24,56,29],[53,21,53,23],[53,24,53,29],[30,21,30,23],[29,21,29,23],[22,21,22,23],[55,21,55,23],[56,30,56,32],[56,33,56,39],[56,40,56,46],[54,24,54,29],[54,30,54,32],[54,33,54,39],[54,40,54,46],[55,24,55,29],[55,30,55,32],[55,33,55,39],[31,1,31,4],[34,1,34,4],[40,1,40,2],[31,5,31,20],[32,5,32,20],[55,3,55,20],[53,1,53,4],[54,1,54,2],[33,5,33,20],[34,5,34,20],[55,40,55,46],[53,30,53,32],[53,33,53,39],[53,40,53,46],[54,21,54,23],[52,21,52,23],[45,5,45,20],[43,21,43,23],[44,21,44,23],[40,21,40,23],[41,5,41,20],[41,21,41,23],[54,3,54,20],[42,5,42,20],[49,21,49,23],[53,5,53,20],[52,24,52,29],[52,30,52,32],[52,33,52,39],[52,40,52,46],[50,21,50,23],[50,24,50,29],[50,30,50,32],[50,33,50,39],[50,40,50,46],[51,21,51,23],[51,24,51,29],[51,30,51,32],[51,33,51,39],[51,40,51,46],[47,30,47,32],[47,33,47,39],[47,40,47,46],[49,40,49,46],[49,33,49,39],[49,30,49,32],[49,24,49,29],[46,21,46,23],[46,24,46,29],[46,30,46,32],[46,33,46,39],[46,40,46,46],[48,24,48,29],[48,30,48,32],[48,40,48,46],[47,21,47,23],[47,24,47,29],[41,24,41,29],[41,30,41,32],[41,33,41,39],[41,40,41,46],[42,21,42,23],[42,24,42,29],[42,30,42,32],[42,33,42,39],[42,40,42,46],[35,21,35,23],[35,24,35,29],[35,30,35,32],[35,33,35,39],[35,40,35,46],[39,24,39,29],[39,30,39,32],[38,45,38,46],[36,24,36,29],[39,33,39,39],[34,33,34,39],[34,40,34,46],[37,21,38,23],[36,21,36,23],[38,26,38,44],[33,30,33,32],[33,33,33,39],[33,40,33,46],[34,24,34,29],[37,24,37,25],[39,40,39,46],[39,21,39,23],[38,24,38,25],[37,26,37,44],[36,30,36,32],[36,33,36,39],[36,40,36,46],[40,40,40,46],[31,30,31,32],[31,33,31,39],[31,40,31,46],[32,21,32,23],[32,24,32,29],[32,30,32,32],[32,33,32,39],[32,40,32,46],[37,45,37,46],[30,24,30,29],[30,30,30,32],[30,33,30,39],[30,40,30,46],[29,33,29,39],[29,40,29,46],[29,30,29,32],[28,33,28,39],[28,40,28,46],[28,30,28,32],[28,24,28,29],[24,21,24,23],[24,24,24,29],[24,30,24,32],[24,33,24,39],[24,40,24,46],[25,33,25,39],[22,30,22,32],[22,33,22,39],[22,40,22,46],[23,21,23,23],[23,24,23,29],[23,30,23,32],[23,33,23,39],[23,40,23,46],[19,24,19,29],[19,30,19,32],[19,33,19,39],[16,21,16,23],[17,21,17,23],[14,40,14,46],[15,30,15,32],[15,33,15,39],[15,40,15,46],[15,24,15,29],[21,30,21,32],[21,33,21,39],[21,40,21,46],[14,33,14,39],[18,45,18,46],[12,30,12,32],[12,33,12,39],[12,40,12,46],[13,30,13,32],[13,33,13,39],[11,30,11,32],[11,33,11,39],[11,40,11,46],[15,21,15,23],[15,1,15,2],[16,1,16,20],[16,30,16,32],[16,33,16,39],[14,1,14,2],[12,3,12,20],[10,21,10,23],[10,24,10,29],[11,21,11,23],[11,24,11,29],[12,24,12,29],[14,24,14,29],[14,21,14,23],[12,21,12,23],[17,1,17,2],[13,1,13,2],[14,30,14,32],[13,3,13,20],[13,21,13,23],[13,24,13,29],[17,24,17,25],[16,24,16,29],[15,3,15,20],[1,6,1,36],[0,37,0,46],[1,37,1,46],[2,0,2,9],[9,40,9,46],[4,33,6,39],[4,30,6,32],[4,40,6,46],[3,37,3,46],[2,10,2,46],[8,40,8,46],[57,0,60,46],[61,0,61,46],[27,1,27,20],[16,40,16,46],[17,26,17,44],[18,26,18,44],[17,45,17,46],[26,3,26,20],[18,24,18,25]]}
[null,null,null,null,null,null,"Annex - F",null,null,null,null,null,null,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]
[null,null,null,null,null,null,"Bifurcation of Income/(Loss) from business attributable to\nSales/Receipts etc. subject to Final Taxation",null,null,null,null,null,null,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"]
["Taxpayer Name",null,null,null,null,null,null,null,null,null,{"$f":"'Control Centre'!$G$4","v":0}]
["NTN",null,null,null,null,null,null,null,null,null,{"$f":"'Control Centre'!$X$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CNIC (for individual) ",null,null,null,null,null,null,{"$f":"'Control Centre'!$G$5","v":0}]
["Particulars",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code",null,null,"Total\nAmount (Rs.)",null,null,null,null,null,"Code",null,null,"Subject to Final Taxation\nAmount (Rs.)",null,null,null,null,null,null,"Subject to Normal Taxation\nAmount (Rs.)"]
[]
[]
["1.","Sales (net of brokerage, commission and discount) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3010,null,null,null,null,null,null,null,null,"3010F"]
[null,"(a)",null,"Local sales/supplies - Out of imports (Trading)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30101,null,null,null,null,null,null,null,null,"30101F",null,null,null,null,null,null,null,null,null,{"$f":"+Y9-AH9","v":0}]
[null,"(b)",null,"Local sales/supplies - Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30102,null,null,null,null,null,null,null,null,"30102F",null,null,null,null,null,null,null,null,null,{"$f":"+Y10-AH10","v":0}]
[null,"(c)",null,"Execution of contracts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30103,null,null,null,null,null,null,null,null,"30103F",null,null,null,null,null,null,null,null,null,{"$f":"+Y11-AH11","v":0}]
[null,"(d)",null,"Export sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30104,null,null,null,null,null,null,null,null,"30104F",null,null,null,null,null,null,null,null,null,{"$f":"+Y12-AH12","v":0}]
[null,"(e)",null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30105,null,null,null,null,null,null,null,null,"30105F",null,null,null,null,null,null,null,null,null,{"$f":"+Y13-AH13","v":0}]
[null,"(f)",null,"Sub-total [ Add 1(a) to 1(e)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30106,null,null,{"$f":"SUM(Y9:AD13)","v":0},null,null,null,null,null,"30106F",null,null,{"$f":"SUM(AH9:AN13)","v":0},null,null,null,null,null,null,{"$f":"SUM(AO9:AU13)","v":0}]
[null,"(g)",null,"Selling expenses (Freight outward, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30107,null,null,null,null,null,null,null,null,"30107F",null,null,null,null,null,null,null,null,null,{"$f":"+Y15-AH15","v":0}]
[null,"(h)",null,"Net ex-factory or F.O.B. sales [ 1(f) minus 1(h)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30108,null,null,{"$f":"+Y14-Y15","v":0},null,null,null,null,null,"30108F",null,null,{"$f":"+AH14-AH15","v":0},null,null,null,null,null,null,{"$f":"+AO14-AO15","v":0}]
["2.","Cost of sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3011,null,null,null,null,null,null,null,null,"3011F"]
[null,"(a)",null,"Apportioned on the basis of:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(i)",null,"Actual / identifiable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ii)",null,"Average / proportionate to sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,"(b)",null,"As per income statement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30111,null,null,null,null,null,null,null,null,"30111F",null,null,{"$f":"IF($Y$16>0,ROUND(Y20/$Y$16*$AH$16,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y20-AH20","v":0}]
[null,"(c)",null,"Adjustment of inadmissible costs etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30112,null,null,null,null,null,null,null,null,"30112F"]
[null,"(i)",null,null,null,"Accounting depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301121,null,null,null,null,null,null,null,null,"301121F",null,null,{"$f":"IF($Y$16>0,ROUND(Y22/$Y$16*$AH$16,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y22-AH22","v":0}]
[null,"(ii)",null,"(ii)",null,"Accounting amortization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301122,null,null,null,null,null,null,null,null,"301122F",null,null,{"$f":"IF($Y$16>0,ROUND(Y23/$Y$16*$AH$16,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y23-AH23","v":0}]
[null,"(iii)",null,"(iii)",null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301123,null,null,null,null,null,null,null,null,"301123F",null,null,{"$f":"IF($Y$16>0,ROUND(Y24/$Y$16*$AH$16,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y24-AH24","v":0}]
[null,"(iv)",null,"(iv)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301124,null,null,null,null,null,null,null,null,"301124F",null,null,{"$f":"IF($Y$16>0,ROUND(Y25/$Y$16*$AH$16,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y25-AH25","v":0}]
[null,"(d)",null,"Sub-total [Add c(i) to c(iv)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30113,null,null,{"$f":"SUM(Y22:Y25)","v":0},null,null,null,null,null,"30113F",null,null,{"$f":"SUM(AH22:AH25)","v":0},null,null,null,null,null,null,{"$f":"SUM(AO22:AO25)","v":0}]
[null,"(e)",null,"Revised cost of sales [2(b) minus 2(d)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30114,null,null,{"$f":"+Y20-Y26","v":0},null,null,null,null,null,"30114F",null,null,{"$f":"+AH20-AH26","v":0},null,null,null,null,null,null,{"$f":"+AO20-AO26","v":0}]
["3.","Gross profit/(loss) / other business revenues/receipts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3012,null,null,null,null,null,null,null,null,"3012F"]
[null,"(a)",null,"Gross profit [ 1(h) minus 2(e)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30121,null,null,{"$f":"+Y16-Y27","v":0},null,null,null,null,null,"30121F",null,null,{"$f":"+AH16-AH27","v":0},null,null,null,null,null,null,{"$f":"+AO16-AO27","v":0}]
[null,"(b)",null,"Other business revenues/receipts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30122,null,null,null,null,null,null,null,null,"30122F"]
[null,"(i)",null,null,null,"Brokerage and commission",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301221,null,null,null,null,null,null,null,null,"301221F",null,null,null,null,null,null,null,null,null,{"$f":"+Y31-AH31","v":0}]
[null,"(ii)",null,"(ii)",null,"Transport services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301222,null,null,null,null,null,null,null,null,"301222F",null,null,null,null,null,null,null,null,null,{"$f":"+Y32-AH32","v":0}]
[null,"(iii)",null,"(iii)",null,"Royalty & fee for technical services (non-residents)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301223,null,null,null,null,null,null,null,null,"301223F",null,null,null,null,null,null,null,null,null,{"$f":"+Y33-AH33","v":0}]
[null,"(iv)",null,"(iv)",null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301224,null,null,null,null,null,null,null,null,"301224F",null,null,null,null,null,null,null,null,null,{"$f":"+Y34-AH34","v":0}]
[null,"(v)",null,"(v)",null,"Other inclusions/exclusions in income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301225,null,null,null,null,null,null,null,null,"301225F",null,null,null,null,null,null,null,null,null,{"$f":"+Y35-AH35","v":0}]
[null,"(c)",null,"Total gross income [ Add 3(a) to 3(b)(v)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30123,null,null,{"$f":"SUM(Y29:Y35)","v":0},null,null,null,null,null,"30123F",null,null,{"$f":"SUM(AH29:AH35)","v":0},null,null,null,null,null,null,{"$f":"SUM(AO29:AO35)","v":0}]
["4.","Administrative, selling, financial expenses etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3013,null,null,null,null,null,null,null,null,"3013F"]
[null,"(a)",null,"Apportioned on the basis of:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(i)",null,"Actual / identifiable "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ii)",null,"Average / proportionate to gross income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,"(b)",null,"As per income statement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30131,null,null,null,null,null,null,null,null,"30131F",null,null,{"$f":"IF($Y$36>0,ROUND(Y40/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y40-AH40","v":0}]
[null,"(c)",null,"Adjustment of inadmissible expenditures etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30132,null,null,null,null,null,null,null,null,"30132F"]
[null,"(i)",null,null,null,"Accounting depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301321,null,null,null,null,null,null,null,null,"301321F",null,null,{"$f":"IF($Y$36>0,ROUND(Y42/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y42-AH42","v":0}]
[null,"(ii)",null,"(ii)",null,"Accounting amortization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301322,null,null,null,null,null,null,null,null,"301322F",null,null,0,null,null,null,null,null,null,0]
[null,"(iii)",null,"(iii)",null,"Markup lease financing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301323,null,null,null,null,null,null,null,null,"301323F",null,null,0,null,null,null,null,null,null,0]
[null,"(iv)",null,"(iv)",null,"Selling expenses (Freight outward, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301324,null,null,null,null,null,null,null,null,"301324F",null,null,0,null,null,null,null,null,null,0]
[null,"(v)",null,"(v)",null,"Other inadmissible deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301325,null,null,null,null,null,null,null,null,"301325F",null,null,0,null,null,null,null,null,null,0]
[null,"(vi)",null,null,null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301326,null,null,null,null,null,null,null,null,"301326F",null,null,0,null,null,null,null,null,null,0]
[null,"(d)",null,"Sub-total [Add c(i) to c(vi)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30133,null,null,{"$f":"SUM(Y42:Y47)","v":0},null,null,null,null,null,"30133F",null,null,{"$f":"SUM(AH42:AH47)","v":0},null,null,null,null,null,null,{"$f":"SUM(AO42:AO47)","v":0}]
[null,"(e)",null,"Adjustment of admissible expenditures etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30134,null,null,null,null,null,null,null,null,"30134F"]
[null,"(i)",null,null,null,"Tax depreciation (Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301341,null,null,null,null,null,null,null,null,"301341F",null,null,{"$f":"IF($Y$36>0,ROUND(Y50/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y50-AH50","v":0}]
[null,"(ii)",null,"(ii)",null,"Tax amortization (Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301342,null,null,null,null,null,null,null,null,"301342F",null,null,{"$f":"IF($Y$36>0,ROUND(Y51/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y51-AH51","v":0}]
[null,"(iii)",null,"(iii)",null,"Lease rentals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301343,null,null,null,null,null,null,null,null,"301343F",null,null,{"$f":"IF($Y$36>0,ROUND(Y52/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y52-AH52","v":0}]
[null,"(iv)",null,"(iv)",null,"Other admissible deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301344,null,null,null,null,null,null,null,null,"301344F",null,null,{"$f":"IF($Y$36>0,ROUND(Y53/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y53-AH53","v":0}]
[null,"(v)",null,"(v)",null,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301345,null,null,null,null,null,null,null,null,"301345F",null,null,{"$f":"IF($Y$36>0,ROUND(Y54/$Y$36*$AH$36,0),0)","v":0},null,null,null,null,null,null,{"$f":"+Y54-AH54","v":0}]
[null,"(f)",null,"Sub-total [Add e(i) to e(v)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30135,null,null,{"$f":"SUM(Y50:Y54)","v":0},null,null,null,null,null,"30135F",null,null,{"$f":"SUM(AH50:AH54)","v":0},null,null,null,null,null,null,{"$f":"SUM(AO50:AO54)","v":0}]
[null,"(g)",null,"Net expenditure [ 4(b) minus to 4(d) plus 4(f)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30136,null,null,{"$f":"+Y40-Y48+Y55","v":0},null,null,null,null,null,"30136F",null,null,{"$f":"+AH40-AH48+AH55","v":0},null,null,null,null,null,null,{"$f":"+AO40-AO48+AO55","v":0}]
["5.","Net profit/loss from business [3(c) minus 4(g)]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3014,null,null,{"$f":"+Y36-Y56","v":0},null,null,null,null,null,"3014F",null,null,{"$f":"+AH36-AH56","v":0},null,null,null,null,null,null,{"$f":"+AO36-AO56","v":0}]
["Signature    ___________________    "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\""]

{"sheet":"ANNEX-G","index":10,"n_rows":80,"n_cols":19,"rows_kept":80,"cut":false,"hidden":false,"merged":[[7,0,14,1],[15,3,15,15],[31,16,31,17],[14,16,14,17],[18,16,18,17],[23,16,23,17],[9,16,9,17],[10,3,10,15],[29,3,29,15],[7,16,7,17],[13,3,13,15],[13,16,13,17],[17,16,17,17],[20,16,20,17],[21,16,21,17],[28,3,28,15],[10,16,10,17],[3,15,3,17],[5,6,5,14],[8,3,8,15],[8,16,8,17],[9,3,9,15],[4,15,4,17],[5,15,5,17],[6,15,6,17],[6,6,6,14],[7,3,7,15],[0,4,0,17],[24,16,24,17],[25,16,25,17],[26,16,26,17],[19,16,19,17],[1,4,1,17],[2,4,2,17],[15,16,15,17],[16,16,16,17],[1,18,2,18],[11,16,11,17],[12,3,12,15],[12,16,12,17],[3,0,6,1],[3,2,3,5],[4,2,4,5],[5,2,5,5],[3,6,3,14],[4,6,4,14],[11,3,11,15],[17,3,17,15],[27,3,27,15],[22,3,22,15],[18,3,18,15],[19,3,19,15],[20,3,20,15],[21,3,21,15],[14,3,14,15],[23,3,23,15],[29,16,29,17],[32,16,32,17],[15,0,32,1],[24,3,24,15],[25,3,25,15],[26,3,26,15],[22,16,22,17],[27,16,27,17],[28,16,28,17],[16,3,16,15],[30,3,30,15],[30,16,30,17],[33,0,37,18],[38,0,38,18],[31,3,31,15],[32,3,32,15]]}
[null,null,null,null,"ANNEX-G",null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,null,"Breakup of Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,"(Separate form should be filled for each business)"]
["Registry",null," Taxpayer Name",null,null,null,{"$f":"'Control Centre'!$G$4","v":0},null,null,null,null,null,null,null,null," NTN",null,null,{"$f":"'Control Centre'!$X$4","v":0}]
[null,null," CNIC",null,null,null,{"$f":"'Control Centre'!$G$5","v":0},null,null,null,null,null,null,null,null," Tax Year",null,null,2013]
[null,null," Business Name",null,null,null,{"$f":"'Control Centre'!$G$6","v":0},null,null,null,null,null,null,null,null," RTO/LTU",null,null,{"$f":"'Control Centre'!$X$12","v":0}]
[null,null," Business Address",null,null,null,{"$f":"'Control Centre'!$G$7","v":0},null,null,null,null,null,null,null,null,"Business City"]
["Manufacturing & Trading Expenses",null,"Sr.","Description",null,null,null,null,null,null,null,null,null,null,null,null,"Code",null,"Amount"]
[null,null,1," Salaries,Wages",null,null,null,null,null,null,null,null,null,null,null,null,311101]
[null,null,2," Electricity",null,null,null,null,null,null,null,null,null,null,null,null,311102]
[null,null,3," Gas",null,null,null,null,null,null,null,null,null,null,null,null,311103]
[null,null,4," Stores/Spares",null,null,null,null,null,null,null,null,null,null,null,null,311106]
[null,null,5," Repair & Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,311108]
[null,null,6," Other Expenses",null,null,null,null,null,null,null,null,null,null,null,null,311118]
[null,null,7," Total    [ Add 1 to 6]                     [Transfer to Sr. 5 of main Return]",null,null,null,null,null,null,null,null,null,null,null,null,31100,null,{"$f":"SUM(S9:S14)","v":0}]
["Profit & Loss Account Expenses",null,8," Rent/ Rates/ Taxes",null,null,null,null,null,null,null,null,null,null,null,null,3141]
[null,null,9," Salaries & Wages",null,null,null,null,null,null,null,null,null,null,null,null,3144]
[null,null,10," Travelling/ Conveyance",null,null,null,null,null,null,null,null,null,null,null,null,3145]
[null,null,11," Electricity/ Water/ Gas",null,null,null,null,null,null,null,null,null,null,null,null,3148]
[null,null,12," Communication Charges",null,null,null,null,null,null,null,null,null,null,null,null,3154]
[null,null,13," Repairs & Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,3153]
[null,null,14," Stationery/ Office Supplies",null,null,null,null,null,null,null,null,null,null,null,null,3155]
[null,null,15," Advertisement/ Publicity/ Promotion",null,null,null,null,null,null,null,null,null,null,null,null,3157]
[null,null,16," Insurance",null,null,null,null,null,null,null,null,null,null,null,null,3159]
[null,null,17," Professional Charges",null,null,null,null,null,null,null,null,null,null,null,null,3160]
[null,null,18," Profit on Debt (Markup/Interest)",null,null,null,null,null,null,null,null,null,null,null,null,3161]
[null,null,19," Donations",null,null,null,null,null,null,null,null,null,null,null,null,3163]
[null,null,20," Bad Debts Written Off",null,null,null,null,null,null,null,null,null,null,null,null,31821]
[null,null,21," Obsolete Stocks/Stores/Spares Written Off",null,null,null,null,null,null,null,null,null,null,null,null,31822]
[null,null,22," Selling expenses(Freight outwards)",null,null,null,null,null,null,null,null,null,null,null,null,31080]
[null,null,23," Commission/Brokerage on sales",null,null,null,null,null,null,null,null,null,null,null,null,31081]
[null,null,24," Others",null,null,null,null,null,null,null,null,null,null,null,null,31090]
[null,null,25," Total   [ Add 8 to 24]                        [Transfer to Sr. 11 of main Return]",null,null,null,null,null,null,null,null,null,null,null,null,3170,null,{"$f":"SUM(S16:S32)","v":0}]
["Signature   _______________________ "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Tax Payments  (Transfer from Sr. 28 of Annex-B)"]

{"sheet":"Annex-H","index":11,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,22,17,24],[17,25,17,28],[16,1,16,12],[16,13,16,15],[16,16,16,18],[16,19,16,21],[16,22,16,24],[16,25,16,28],[13,22,13,24],[14,19,14,21],[14,22,14,24],[15,13,15,15],[15,16,15,18],[15,19,15,21],[15,22,15,24],[7,19,7,21],[7,22,7,24],[5,13,6,15],[5,16,6,18],[5,19,6,21],[5,22,6,24],[15,25,15,28],[7,1,7,12],[7,25,7,28],[8,19,8,21],[18,25,18,28],[14,13,14,15],[14,16,14,18],[10,25,10,28],[10,13,10,15],[10,16,10,18],[10,22,10,24],[13,13,13,15],[13,16,13,18],[1,24,1,28],[0,24,0,28],[2,24,2,28],[3,24,3,28],[4,24,4,28],[1,3,1,23],[0,3,0,23],[10,1,10,12],[13,1,13,12],[14,1,14,12],[15,1,15,12],[17,1,17,12],[10,19,10,21],[17,13,17,15],[17,16,17,18],[13,19,13,21],[17,19,17,21],[5,25,6,28],[5,0,6,0],[8,1,8,12],[8,25,8,28],[8,22,8,24],[5,1,6,12],[8,13,8,15],[8,16,8,18],[7,13,7,15],[7,16,7,18],[2,3,2,19],[3,3,3,19],[4,3,4,19],[2,20,2,23],[3,20,3,23],[4,20,4,23],[9,1,9,12],[9,13,9,15],[9,16,9,18],[9,19,9,21],[9,22,9,24],[9,25,9,28],[11,1,11,12],[12,1,12,12],[11,13,11,15],[11,16,11,18],[11,19,11,21],[11,22,11,24],[21,18,21,27],[11,25,11,28],[12,13,12,15],[12,16,12,18],[12,19,12,21],[12,22,12,24],[12,25,12,28],[13,25,13,28],[18,1,18,24],[14,25,14,28]]}
[null,null,null,"Annex H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,"Determination of minimum Tax Payable on certain transactions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
["Taxpayer Name",null,null,{"$f":"'Control Centre'!$G$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NTN",null,null,null,{"$f":"'Control Centre'!$X$4","v":0}]
["CNIC/Reg.No.",null,null,{"$f":"'Control Centre'!$G$5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Tax Year",null,null,null,2013]
["Business Name",null,null,{"$f":"'Control Centre'!$G$6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," RTO/LTU",null,null,null,{"$f":"'Control Centre'!X12","v":0}]
["Sr."," Description",null,null,null,null,null,null,null,null,null,null,null,"Import of Edible Oil U/S 148(8)",null,null,"Import of Packing Material U/S 148(8)",null,null,"Transport Services U/S 153(1)(b)",null,null,"Other Services U/S 153(1)(b)",null,null,"Total"]
[]
["(1)","(2)",null,null,null,null,null,null,null,null,null,null,null,"(3)",null,null,"(4)",null,null,"(5)",null,null,"(6)",null,null,"(7) = (3 + 4 + 5 + 6)"]
[1,"Import Value/Services receipts subject to collection or deduction of tax at source",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N9+Q9+T9+W9","v":0}]
[2," Taxable Income [Transferred from Sr-30 ]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INDIVIDUAL-AOP (1 of 2)'!$AB$51","v":0},null,null,{"$f":"'INDIVIDUAL-AOP (1 of 2)'!$AB$51","v":0},null,null,{"$f":"'INDIVIDUAL-AOP (1 of 2)'!$AB$51","v":0},null,null,{"$f":"'INDIVIDUAL-AOP (1 of 2)'!$AB$51","v":0}]
[3," Income relateable to the transcations subject to payment of minimum tax "]
[null," a. Calculated on actual basis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N12+Q12+T12+W12","v":0}]
[null," b. Calculated on proportionate basis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N13+Q13+T13+W13","v":0}]
[4," Proportionate  tax",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10<>0,ROUND(('INDIVIDUAL-AOP (1 of 2)'!$AB$60 - 'INDIVIDUAL-AOP (1 of 2)'!$AB$61)/'Annex-H'!N10*'Annex-H'!N13,0),0)","v":0},null,null,{"$f":"IF(Q10<>0,ROUND(('INDIVIDUAL-AOP (1 of 2)'!$AB$60 - 'INDIVIDUAL-AOP (1 of 2)'!$AB$61)/'Annex-H'!Q10*'Annex-H'!Q13,0),0)","v":0},null,null,{"$f":"IF(T10<>0,ROUND(('INDIVIDUAL-AOP (1 of 2)'!$AB$60 - 'INDIVIDUAL-AOP (1 of 2)'!$AB$61)/'Annex-H'!T10*'Annex-H'!T13,0),0)","v":0},null,null,{"$f":"IF(W10<>0,ROUND(('INDIVIDUAL-AOP (1 of 2)'!$AB$60 - 'INDIVIDUAL-AOP (1 of 2)'!$AB$61)/'Annex-H'!W10*'Annex-H'!W13,0),0)","v":0},null,null,{"$f":"N14+Q14+T14+W14","v":0}]
[5," Minimum Tax "]
[null,"    a) Rate of Minimum Tax",null,null,null,null,null,null,null,null,null,null,null,0.03,null,null,0.05,null,null,0.02,null,null,0.06]
[null,"    b) Minimum Tax [ 5(a) * (1) ]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N16*N9","v":0},null,null,{"$f":"Q16*Q9","v":0},null,null,{"$f":"T16*T9","v":0},null,null,{"$f":"W16*W9","v":0},null,null,{"$f":"N17+Q17+T17+W17","v":0}]
[6," Higher of (4) and 5(b)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N14>N17,N14,N17)","v":0},null,null,{"$f":"IF(Q14>Q17,Q14,Q17)","v":0},null,null,{"$f":"IF(T14>T17,T14,T17)","v":0},null,null,{"$f":"IF(W14>W17,W14,W17)","v":0},null,null,{"$f":"N18+Q18+T18+W18","v":0}]
[7," Difference of minimum Tax Payable on business transactions (Transfer to Sr. 41 of Main Return)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z18-Z14","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature  ______________________"]

{"sheet":"Annex-J","index":12,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,1,10,12],[10,13,10,16],[10,17,10,20],[14,1,14,12],[14,13,14,16],[14,17,14,20],[11,1,11,12],[11,13,11,16],[13,17,13,20],[11,17,11,20],[11,21,11,24],[18,3,20,27],[15,1,15,12],[15,13,15,16],[15,17,15,20],[15,21,15,24],[15,25,15,28],[16,1,16,12],[18,1,18,2],[16,13,16,16],[16,25,16,28],[16,17,16,20],[16,21,16,24],[10,21,10,24],[14,25,14,28],[12,1,12,12],[12,13,12,16],[12,17,12,20],[12,21,12,24],[12,25,12,28],[13,1,13,12],[14,21,14,24],[13,13,13,16],[4,20,4,23],[13,25,13,28],[7,1,7,12],[7,13,7,16],[7,17,7,20],[7,21,7,24],[7,25,7,28],[13,21,13,24],[9,1,9,24],[11,25,11,28],[3,20,3,23],[10,25,10,28],[4,24,4,28],[4,3,4,19],[8,1,8,12],[8,13,8,16],[8,17,8,20],[8,21,8,24],[8,25,8,28],[9,25,9,28],[5,0,6,0],[5,1,6,12],[5,13,6,16],[5,17,6,20],[5,21,6,24],[5,25,6,28],[22,21,22,27],[0,0,0,23],[0,24,0,28],[1,0,1,23],[1,24,1,28],[2,24,2,28],[3,24,3,28],[2,3,2,19],[2,20,2,23],[3,3,3,19]]}
["Annex J",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
["                   Request of Taxpayers falling under PTR Regime for  availing Normal Tax Regime (NTR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J"]
["Taxpayer Name",null,null,{"$f":"'Control Centre'!$G$4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," NTN",null,null,null,{"$f":"'Control Centre'!$X$4","v":0}]
["CNIC/Reg.No.",null,null,{"$f":"'Control Centre'!$G$5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Tax Year",null,null,null,2013]
["Business Name",null,null,{"$f":"'Control Centre'!$G$6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," RTO/LTU",null,null,null,{"$f":"'Control Centre'!X12","v":0}]
["Sr."," Description",null,null,null,null,null,null,null,null,null,null,null,"Imports  u/s 148(7)",null,null,null,"Exports   u/s 154(4)",null,null,null,"Sales/ Payments u/s 153(1) & u/s 169(1)b",null,null,null,"TOTAL"]
[]
["(1)","(2)",null,null,null,null,null,null,null,null,null,null,null,"(3)",null,null,null,"(4)",null,null,null,"(5)",null,null,null,"(6) = (3 + 4 + 5)"]
[1," Net Sales (Transferred from Sr-1 of Main Return)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INDIVIDUAL-AOP (1 of 2)'!$AB$22","v":0}]
[2," Total Tax Payable (Sr. 44 plus Sr. 45 minus Sr.- 46) of Main Return)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INDIVIDUAL-AOP (1 of 2)'!$AB$68 + 'INDIVIDUAL-AOP (1 of 2)'!$AB$69 - 'INDIVIDUAL-AOP (1 of 2)'!$AB$72","v":0}]
[3," Value of Import/Export & Indent Comm/Sale of Goods subject to collection/deduction of tax at source",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('INDIVIDUAL-AOP (2 of 2)'!J8:M11)","v":0},null,null,null,{"$f":"SUM('INDIVIDUAL-AOP (2 of 2)'!J26:M27)+'INDIVIDUAL-AOP (2 of 2)'!$J$28","v":0},null,null,null,{"$f":"SUM('INDIVIDUAL-AOP (2 of 2)'!J20:M22)","v":0},null,null,null,{"$f":"SUM(N11:Y11)","v":0}]
[4," Actual value of Sales/Exports",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(N12:Y12)","v":0}]
[5," Tax Collected/Collectable/Deducted /Deductible at Source",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('INDIVIDUAL-AOP (2 of 2)'!P8:S11)","v":0},null,null,null,{"$f":"SUM('INDIVIDUAL-AOP (2 of 2)'!P26:S27)+'INDIVIDUAL-AOP (2 of 2)'!P28","v":0},null,null,null,{"$f":"SUM('INDIVIDUAL-AOP (2 of 2)'!P20:S22)","v":0},null,null,null,{"$f":"SUM(N13:Y13)","v":0}]
[6," Proportionate Tax Payable [ (4 / 1) * 2 ]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z9>0,ROUND(N12*Z10/Z9,0),0)","v":0},null,null,null,{"$f":"IF(Z9>0,ROUND(R12*Z10/Z9,0),0)","v":0},null,null,null,{"$f":"IF(Z9>0,ROUND(V12*Z10/Z9,0),0)","v":0},null,null,null,{"$f":"SUM(N14:Y14)","v":0}]
[7," %age of Tax Deducted at Source for Qulaifying for NTR",null,null,null,null,null,null,null,null,null,null,null,0.6,null,null,null,0.5,null,null,null,0.7]
[8," Minimum Tax required for eligiblity for NTR (8 = 5 * 7)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(N13*N15,0)","v":0},null,null,null,{"$f":"ROUND(R13*R15,0)","v":0},null,null,null,{"$f":"ROUND(V13*V15,0)","v":0}]
[9,"If (8) Less than or equlas to (6)  then  Qualified for NTR (Yes); (Transfer to Sr. 42 of Main Return)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N16<=N14,\"Yes\",\"No\")","v":"Yes"},null,null,null,{"$f":"IF(R16<=R14,\"Yes\",\"No\")","v":"Yes"},null,null,null,{"$f":"IF(V16<=V14,\"Yes\",\"No\")","v":"Yes"},null,null,null,{"$f":"IF(AND(N17=\"Yes\",R17=\"Yes\",V17=\"Yes\"),\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Note :",null,"Based on the Qulaification under Normal Tax Regime (NTR), the respective Columns of PTR Portion will be disbaled in the e-Filing System. However, the persons filing paper returns, should strike out the relevant columns of PTR Portion (Imports, Exports, Sales/ Purchases) of the IT-2 Return Form on the basis of their eligibility for NTR."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature  _______________________"]