{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","FORM 16 I T CALCULATOR"],"not_rendered":{"images":1,"macros":1,"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3],[10,2,10,3],[11,2,11,3]]}
[]
[]
[null,null,"Instructions"]
[null,null,"Developed by Gopala K R, Assistant Professor, GFGC, Magadi. To Download IT Calculator visit www.gceducity.com"]
[null,null,"SL No.","General"]
[null,null,1,"This Excel Document consist of 2 excel sheets namely \"INSTRUCTIONS\", \"FORM 16 I T CALCULATOR\". "]
[null,null,2,"If Macros are not Enabled please Enable the Macros before using the Calculator."]
[null,null,3,"All Grey & Other Colored Cells are Protected and Updates /Calculates Automatically. "]
[null,null,4,"Enter Required/Applicable Data in White Colored Cells only. (Follow the Instructions given in Each Cell) "]
[null,null,5,"Print the Area which is covered by Blue Colored Cells in \"INCOME TAX CALCULATOR\" Sheet. "]
[]
[null,null,"Entering of Details in \"FORM 16 IT CALCULATOR\" Sheet"]
[null,null,1,"Firstly Enter the Rates of Dearness Allowances, House Rent Allowances, NPS and Other Details(KGID, GPF & GIS etc.,) as Applicable in the Respective Cells."]
[null,null,2,"Then Enter Basic Salary, Other Allowances & Deductions like Income Tax, LIC & Other Deductions if any."]
[null,null,3,"Enter the Rates and Slabs of Income Tax Applicable in the Respective Cells."]
[null,null,4,"Enter the Monthly Rent Paid in the Respective Cells in the Sheet."]
[null,null,5,"Enter the Applicable Savings & Deductions in the Space Provided in White Colored Cells."]
[null,null,6,"After enteing all the details click on the save button in \"FORM 16 IT CALCULATOR\"  Sheet. Data will be saved in the next sheets. Once data is saved, rename the sheet."]
[null,null,7,"Even after saving your data you can edit the required information in the saved sheet and your FORM 16 updates automatically according to the changes made."]
[null,null,8,"For Better Printing quality please choose the printer settings as shown in the bellow image."]

{"sheet":"FORM 16 I T CALCULATOR","index":1,"n_rows":1953,"n_cols":688,"rows_kept":1953,"merged":[[6,2,6,3],[6,4,6,7],[6,8,6,9],[6,10,6,13],[6,14,6,15],[6,16,6,18],[7,2,7,3],[7,4,7,7],[7,8,7,9],[7,10,7,13],[7,14,7,15],[7,16,7,18],[8,2,8,3],[8,4,8,7],[8,8,8,9],[8,10,8,13],[8,14,8,15],[8,16,8,18],[9,2,9,18],[10,2,10,18],[32,6,32,15],[33,6,34,6],[33,7,34,7],[33,8,34,8],[33,9,33,10],[33,11,34,11],[33,12,34,12],[33,13,34,13],[33,14,34,14],[33,15,34,15],[177,245,177,251],[177,252,250,252],[178,245,250,245],[178,246,178,251],[179,246,179,251],[180,246,180,247],[180,249,180,251],[181,246,181,247],[181,249,181,251],[182,246,183,247],[182,248,183,248],[182,249,183,251],[184,246,184,251],[185,246,185,247],[185,249,185,251],[186,246,186,247],[186,249,186,251],[187,246,187,247],[187,249,187,251],[188,246,188,247],[188,249,188,251],[189,246,189,251],[190,246,190,248],[191,247,191,250],[192,247,192,248],[193,247,193,248],[194,247,194,248],[195,247,195,249],[196,247,196,249],[197,247,197,249],[198,247,198,248],[199,247,199,248],[200,247,200,248],[201,247,201,248],[202,247,202,248],[203,247,203,248],[204,247,204,248],[205,247,205,248],[206,247,206,249],[207,247,207,248],[208,247,208,248],[209,247,209,248],[210,247,210,248],[211,247,211,249],[212,247,212,249],[213,247,213,248],[214,247,214,248],[215,247,215,248],[216,247,216,249],[217,247,217,249],[218,247,218,248],[218,250,220,250],[219,247,219,248],[220,247,220,248],[221,247,221,248],[222,247,222,248],[223,247,223,248],[224,247,224,248],[225,247,225,248],[226,247,226,248],[227,247,227,248],[228,247,228,248],[229,247,229,248],[230,247,230,249],[231,247,231,248],[232,247,232,248],[233,247,233,248],[234,247,234,248],[235,247,235,248],[236,247,236,248],[237,247,237,248],[238,247,238,248],[239,247,239,248],[240,246,240,251],[241,249,241,251],[242,246,243,251],[244,246,245,251],[246,246,246,247],[246,249,247,251],[247,246,247,247],[248,246,249,248],[248,249,249,251],[1170,671,1170,689],[1171,682,1171,684],[1173,674,1173,681],[1174,674,1174,681],[1174,684,1174,687],[1175,674,1175,681],[1176,675,1176,677],[1177,675,1177,677],[1178,675,1178,677],[1179,674,1179,681],[1180,684,1180,686],[1181,676,1181,679],[1181,684,1181,686],[1182,676,1195,676],[1182,677,1182,679],[1182,684,1182,686],[1183,677,1183,679],[1183,684,1183,685],[1183,686,1183,687],[1184,677,1184,679],[1185,677,1185,679],[1186,677,1186,679],[1187,677,1187,679],[1188,677,1188,679],[1189,677,1189,679],[1190,677,1190,679],[1191,677,1191,679],[1192,677,1192,679],[1195,677,1195,679],[1196,676,1196,679],[1197,676,1197,679],[1197,680,1198,680],[1198,676,1198,679],[1198,684,1198,685],[1198,686,1198,687],[1199,676,1199,679],[1199,680,1201,680],[1200,676,1200,679],[1200,684,1200,685],[1201,674,1202,674],[1201,675,1202,675],[1201,676,1201,679],[1201,684,1201,685],[1202,676,1202,679],[1203,676,1203,679],[1204,676,1205,676],[1204,677,1204,679],[1205,677,1205,679],[1206,676,1206,679],[1207,676,1207,679],[1208,675,1209,675],[1208,676,1208,679],[1210,674,1211,674],[1210,675,1211,675],[1213,674,1213,675],[1214,676,1214,679],[1215,676,1215,679],[1216,676,1217,676],[1218,676,1218,679],[1219,676,1219,679],[1220,676,1220,679],[1221,676,1221,679],[1222,676,1222,679],[1224,677,1224,678],[1225,677,1226,678],[1225,679,1226,679],[1227,682,1241,682],[1229,674,1229,675],[1229,678,1229,681],[1230,678,1230,680],[1231,678,1231,680],[1232,678,1232,680],[1233,678,1233,680],[1234,674,1236,681],[1239,674,1239,675],[1240,673,1241,673],[1240,674,1240,675],[1829,672,1829,674],[1830,664,1830,671],[1831,664,1831,671],[1832,664,1832,671],[1833,665,1833,667],[1834,665,1834,667],[1835,665,1835,667],[1836,664,1836,671],[1838,666,1838,669],[1840,667,1840,669],[1840,674,1840,675],[1840,676,1840,677],[1841,667,1841,669],[1842,667,1842,669],[1843,667,1843,669],[1844,667,1844,669],[1845,667,1845,669],[1846,667,1846,669],[1847,667,1847,669],[1852,667,1852,669],[1853,666,1853,669],[1854,666,1854,669],[1854,670,1855,670],[1855,666,1855,669],[1855,674,1855,675],[1855,676,1855,677],[1856,666,1856,669],[1856,670,1858,670],[1857,666,1857,669],[1857,674,1857,675],[1858,664,1859,664],[1858,665,1859,665],[1858,666,1858,669],[1858,674,1858,675],[1859,666,1859,669],[1860,666,1860,669],[1861,666,1862,666],[1861,667,1861,669],[1862,667,1862,669],[1863,666,1863,669],[1864,666,1864,669],[1865,665,1866,665],[1865,666,1865,669],[1867,664,1868,664],[1867,665,1868,665],[1870,664,1870,665],[1871,666,1871,669],[1872,666,1872,669],[1873,666,1873,669],[1874,666,1874,669],[1875,666,1875,669],[1876,666,1876,669],[1877,666,1877,669],[1881,667,1881,668],[1882,667,1883,668],[1882,669,1883,669],[1884,672,1898,672],[1886,664,1886,665],[1886,668,1886,671],[1887,668,1887,670],[1888,668,1888,670],[1889,668,1889,670],[1890,668,1890,670],[1891,664,1893,671],[1896,664,1896,665],[1897,663,1898,663],[1897,664,1897,665]]}
[]
[]
[]
[]
[]
[]
[null,null,"EMPLOYEE NAME",{"$nulls":5},"EMPLOYEE PAN",{"$nulls":5},"A. YEAR"]
[null,null,"EMPLOYEE DESIGNATION",{"$nulls":5},"EMPLOYEE KGID",{"$nulls":5},"P. YEAR"]
[null,null,"DEDUCTOR NAME",{"$nulls":5},"DEDUCTOR PAN",{"$nulls":5},"DEDUCTOR TAN"]
[null,null,"Developed by Gopala K R, Assistant Professor, GFGC, Magadi. To Download the IT Calculator & Form 16 visit www.gceducity.com"]
[null,null,"Note: Enter the Salary Details of Employees/ Officers"]
[null,null,"Month","Basic Pay ","DA","HRA","CCA","Others","Gross Total"," NPS","KGID","GPF","GIS","Income Tax","LIC","PT","Others","Total Deductions","Net Total"]
[null,null,"March",null,{"$f":"ROUND((D13)*H36/100,0)","v":0},{"$f":"ROUND((D13)*I36/100,0)","v":0},{"$f":"IF(D13>0,L36,0)","v":0},null,{"$f":"SUM(D13:H13)","v":0},{"$f":"ROUND((D13+E13)*K36/100,0)","v":0},{"$f":"IF(D13>0,N36,0)","v":0},{"$f":"IF(D13>0,O36,0)","v":0},{"$f":"IF(D13>0,P36,0)","v":0},null,null,{"$f":"IF(D13>0,M36,0)","v":0},null,{"$f":"SUM(J13:Q13)","v":0},{"$f":"ROUND((I13-R13),0)","v":0}]
[null,null,"April",null,0,0,0,null,{"$f":"SUM(D14:H14)","v":0},0,0,0,0,null,null,0,null,{"$f":"SUM(J14:Q14)","v":0},{"$f":"ROUND((I14-R14),0)","v":0}]
[null,null,"May",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"June",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"July",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"August",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"September",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"October",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"November",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"December",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"January",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,{"$f":"ROUND((I23-R23),0)","v":0}]
[null,null,"February",null,0,0,0,null,0,0,0,0,0,null,null,0,null,0,0]
[null,null,"DA Arrears 1",{"$nulls":5},0,{"$f":"E25*K36/100","v":0},{"$nulls":7},{"$f":"SUM(J25:Q25)","v":0},0]
[null,null,"DA Arrears 2",{"$nulls":5},{"$f":"SUM(D26:H26)","v":0},{"$f":"E26*K37/100","v":0},{"$nulls":7},{"$f":"SUM(J26:Q26)","v":0},{"$f":"ROUND((I26-R26),0)","v":0}]
[null,null,"Other arrears",{"$nulls":5},0,{"$nulls":8},{"$f":"SUM(J27:Q27)","v":0},{"$f":"ROUND((I27-R27),0)","v":0}]
[null,null,"Other arrears",{"$nulls":5},0,{"$nulls":8},{"$f":"SUM(J28:Q28)","v":0},{"$f":"ROUND((I28-R28),0)","v":0}]
[null,null,"Other arrears",{"$nulls":5},0,{"$nulls":8},{"$f":"SUM(J29:Q29)","v":0},{"$f":"ROUND((I29-R29),0)","v":0}]
[null,null,"Total",{"$f":"SUM(D13:D29)","v":0},{"$f":"SUM(E13:E29)","v":0},{"$f":"SUM(F13:F29)","v":0},{"$f":"SUM(G13:G29)","v":0},{"$f":"SUM(H13:H29)","v":0},{"$f":"D30+E30+F30+G30+H30","v":0},{"$f":"SUM(J13:J29)","v":0},{"$f":"SUM(K13:K29)","v":0},0,0,0,0,0,0,{"$f":"SUM(R13:R29)","v":0},{"$f":"SUM(S13:S29)","v":0}]
[]
[]
[{"$nulls":6},"Enter the following Details"]
[{"$nulls":6},"Month","DA Rates","HRA Rate","NPS Rate",null,"CCA","PT","KGID","GPF","GIS"]
[{"$nulls":9},"Employer","Employee"]
[{"$nulls":6},"March",148,10,10,10,0,200,null,null,180]
[{"$nulls":6},"April",148,10,14,10,0,200,null,null,180]
[{"$nulls":6},"May",154,10,14,10,0,200,null,null,180]
[{"$nulls":6},"June",154,10,14,10,0,200,null,null,180]
[{"$nulls":6},"July",154,10,14,10,0,200,null,null,180]
[{"$nulls":6},"August",154,10,14,10,0,200,null,null,180]
[{"$nulls":6},"September",154,10,14,10,0,200,null,null,180]
[{"$nulls":6},"October",154,10,14,10,0,200,null,null,180]
[{"$nulls":6},"November",17,8,14,10,0,200,null,null,180]
[{"$nulls":6},"December",17,8,14,10,0,200,null,null,180]
[{"$nulls":6},"January",17,8,14,10,0,200,null,null,180]
[{"$nulls":6},"February",17,8,14,10,0,200,null,null,180]
{"$rows_empty":131}
[{"$nulls":246},"Form 16"]
[{"$nulls":246},"Part B"]
[{"$nulls":246},"Name and Address of the Employee",null,"Designation of the Employee","Name, Designation and Address of the employer"]
[{"$nulls":246},{"$f":"YZ1177","v":0},null,{"$f":"YZ1178","v":0},{"$f":"YZ1179","v":0}]
[]
[]
[{"$nulls":246},"Developed by Gopala K R, Assistant Professor, GFGC, Magadi. For any Feedback Visit  www.gceducity.com"]
[{"$nulls":246},"PAN of the Employee",null,"TAN of the Deductor","PAN of the Deductor"]
[{"$nulls":246},{"$f":"ZD1177","v":0},null,{"$f":"ZF1179","v":0},{"$f":"ZD1179","v":0}]
[{"$nulls":246},"KGID",null,"Assessment Year","Previous Year"]
[{"$nulls":246},{"$f":"ZD1178","v":0},null,{"$f":"ZF1177","v":0},{"$f":"ZF1178","v":0}]
[{"$nulls":246},"To Download the IT Calculator & Form 16 Creator visit www.gceducity.com"]
[{"$nulls":246},"Details of Salary paid and any other income and tax deducted",null,null,"Claimed ","Allowed","Rs."]
[{"$nulls":246},1," Gross Salary"]
[{"$nulls":246},"a","Salary as per provisions contained in sec.17(1)",null,{"$f":"YZ1201","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"b","Value of perquisites u/s 17(2)     (as per Form No.12BA, wherever applicable)",null,{"$f":"YZ1204","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"c","Profits in lieu of salary u/s 17(3) (as per Form No.12BA, wherever applicable)",null,{"$f":"YZ1205","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"d"," Total ",null,null,{"$f":"SUM(IP193+IP194+IP195)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"e","Reported total amount of salary received from other employer(s)",null,null,{"$f":"YZ1202","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},2,"Less: Allowance to the extent exempt u/s 10 "]
[{"$nulls":246},"a","Travel concession allowance u/s10(5)",null,{"$f":"ZE1189","v":{"v":0,"d":"0.00"}},{"$f":"IP199","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"b","Death cum retirement gratuity u/s 10 (10)",null,{"$f":"ZE1186","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":246},"c","Commuted value of the pension u/s 10(10A)",null,{"$f":"ZE1187","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":246},"d","Cash equivalent of leave salary encashment u/s 10(10AA)",null,{"$f":"ZE1188","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":246},"e","   House Rent allowance u/s 10(13A)",null,{"$f":"ZE1184","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$nulls":246},"f","Amount of any other Exemption u/s 10",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":246},"g","Total Amount of Exemption claimed u/s 10",null,{"$f":"SUM(IP199:IP204)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(IQ199:IQ204)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},3,"Total Amount of salary received from current employer [1d-2g]",null,null,{"$f":"IQ196-IQ205","v":{"v":0,"d":"0.00"}},{"$f":"IQ206","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},4,"Less Deductions u/s 16"]
[{"$nulls":246},"a","Standard deduction u/s 16(ia)",null,{"$f":"IF(IQ206>50000,50000,IQ206)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"b","Entertainment allowance u/s 16(ii)",null,{"$f":"ZE1185","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"c","Tax on employment (PT) u/s 16(iii)",null,{"$f":"ZE1183","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},5,"Total Amount of Deduction u/s 16",null,{"$f":"SUM(IP208:IP210)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(IP208:IP210)","v":{"v":0,"d":"0.00"}},{"$f":"IQ211","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},6,"Income chargeable under the head 'salaries' [3+1e-5]",null,null,{"$f":"IQ206+IQ197-IQ211","v":{"v":0,"d":"0.00"}},{"$f":"IR206-IR211","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},7,"Add: Any other income reported by the employee u/s 192 (2B)"]
[{"$nulls":246},"a","Income (or admissible loss) from house property reported by the employee offered for the TDS"]
[{"$nulls":246},"b","Income under other sources offered for TDS",null,{"$f":"YZ1211","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},8,"Total of amount of other income reported by the employee [7a+7b]",null,{"$f":"SUM(IP214:IP215)","v":{"v":0,"d":"0.00"}},{"$f":"IP216","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},9,"Gross total income (6+8) ",null,null,{"$f":"SUM(IQ212+IQ216)","v":{"v":0,"d":"0.00"}},{"$f":"IR212+IR213","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},10,"Deductions under chapter VI-A "]
[{"$nulls":246},"a","Deduction in respect of life insurance premia, contribution to provident fund KGID etc. u/s 80 C",null,{"$f":"YZ1227","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"b","Deduction in respect of contribution to certain pension funds u/s 80CCC ",null,{"$f":"ZE1190","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"c","Deduction in respect of contribution by the taxpayer to National pension scheme u/s 80CCD(1) ",null,{"$f":"ZE1194","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"d","Total Deduction u/s 80C, 80CCC, 80CCD(1)",null,{"$f":"SUM(IP219:IP221)","v":{"v":0,"d":"0.00"}},{"$f":"IF(IP222>ZL1182,ZL1182,IP222)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"e","Deduction in respect of amount paid / deposited to notified pension scheme u/s 80CCD(1B)",null,{"$f":"ZE1196","v":{"v":0,"d":"0.00"}},{"$f":"IF(IP223>ZL1183,ZL1183,IP223)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"f","Deduction in respect of contribution by the Employer to National pension scheme u/s 80CCD(2) ",null,{"$f":"ZK1199","v":{"v":0,"d":"0.00"}},{"$f":"IF(IP224>ZE1195,ZE1195,IP224)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"g","Deduction in respect of health insurance premia u/s 80D",null,{"$f":"ZE1193","v":{"v":0,"d":"0.00"}},{"$f":"IF(IP225>25000,25000,IP225)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"h","Deduction in respect of interest loan taken for higher education u/s 80E",null,{"$f":"ZE1191","v":{"v":0,"d":"0.00"}},{"$f":"IP226","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"g","Total deduction in respect of donations to charitable institutions, certain funds etc., u/s 80G",null,{"$f":"ZF1206","v":{"v":0,"d":"0.00"}},{"$f":"IP227","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"h","Deduction in respect of interest on deposits in savings bank account u/s 80TTA",null,{"$f":"YZ1207","v":{"v":0,"d":"0.00"}},{"$f":"IF(IP228>10000,10000,IP228)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},"k","Amount deductible under any other provision of chapter VI-A",null,null,{"$f":"IP229","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},11,"Aggregate deductible amount under chapter VI-A",null,{"$f":"SUM(IP219:IP229)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(IQ222:IQ229)","v":{"v":0,"d":"0.00"}},{"$f":"IQ230","v":0}]
[{"$nulls":246},12,"Total Taxable Income 9-11",null,null,{"$f":"IQ217-IQ230","v":{"v":0,"d":"0.00"}},{"$f":"ROUND(IR217-IR230,-1)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},13,"Tax on total income ",{"$nulls":3},{"$f":"ZF1214","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},14,"Less: rebate u/s 87A (If Applicable)",{"$nulls":3},{"$f":"ZF1215","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},15,"Surcharge where ever applicable",{"$nulls":3},{"$f":"ZF1218","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},16,"Health and education cess",{"$nulls":3},{"$f":"ZF1217","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},17,"Tax payable (13+15+16-14) ",{"$nulls":3},{"$f":"IR232+IR234+IR235-IR233","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},18,"Less relief u/s 89",{"$nulls":3},{"$f":"ZF1220","v":{"v":0,"d":"0.00"}}]
[{"$nulls":246},19,"Net Tax payable",{"$nulls":3},{"$f":"IR236-IR237","v":0}]
[{"$nulls":246},20,"Less Tax paid",{"$nulls":3},{"$f":"ZF1222","v":0}]
[{"$nulls":246},21,"Tax Pay Payable / Refund of Excess Tax Paid",{"$nulls":3},{"$f":"IR238-IR239","v":0}]
[{"$nulls":246},"Verification"]
[{"$nulls":246},"I,",null,"son / daughter of"]
[{"$nulls":246},"working in the capacity of  PRINCIPAL do hereby certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statements, and other available records."]
[]
[{"$nulls":246}," This Document is for educative purpose only. Efforts Have Been Made for Accurate Calculation of Income Tax. However, Finalization of the Same is subject to the Provisions of Income Tax Act of 1961 And time to time Amendments. Please contact the professional before finalizing it. Developer will not be responsible for any Damages and/or Errors and Omissions."]
[]
[{"$nulls":246},"Place :",null,null,"Signature"]
[{"$nulls":246},"Date :"]
[{"$nulls":246},"FULL NAME",null,null,{"$f":"IN242&\" son/daugher of \"&IP242","v":" son/daugher of "}]
{"$rows_empty":925}
[{"$nulls":684},"Enter the Income Tax Rates and Details"]
[{"$nulls":674},"STATEMENT SHOWING THE DETAILS OF INCOME AND INCOME TAX PAYABLE ",{"$nulls":9},"From","Up To",null,"Rate"]
[{"$nulls":674},"NAME",{"$f":"E7","v":0},null,null,"PAN NO",{"$f":"K7","v":0},"A. YEAR",{"$f":"Q7","v":0},null,null,0,250000,null,0]
[{"$nulls":674},"DESIGNATION",{"$f":"E8","v":0},null,null,"KGID NO.",{"$f":"K8","v":0},"P. YEAR",{"$f":"Q8","v":0},null,null,{"$f":"ZJ1177+1","v":250001},500000,null,5]
[{"$nulls":674},"DEDUCTOR NAME",{"$f":"E9","v":0},null,null,"DEDUCTOR PAN",{"$f":"K9","v":0},"TAN",{"$f":"Q9","v":0},null,null,{"$f":"ZJ1178+1","v":500001},1000000,null,20]
[{"$nulls":674},"Developed by Gopala K R, Assistant Professor, GFGC, Magadi. To Download the IT Calculator Visit  www.gceducity.com",{"$nulls":9},{"$f":"ZJ1179+1","v":1000001},"Above",null,30]
[{"$nulls":674},"Salary","Amount","CALCULATION OF INCOME TAX",{"$nulls":7},"Education Cess",null,null,4]
[{"$nulls":674},"March",{"$f":"I13","v":0},"Gross Salary income",{"$nulls":4},{"$f":"SUM(YZ1201:YZ1205)","v":0},null,null,"Maximum Deduction U/S 80C",null,null,150000]
[{"$nulls":674},"April",{"$f":"I14","v":0},"LESS:","Tax on employment U/S 16(iii)",null,null,{"$f":"P30","v":0},{"$nulls":3},"Maximum Deduction U/S 80CCD(1B)",null,null,50000]
[{"$nulls":674},"May",0,null,"HRA under Sec.10(13a)",null,null,{"$f":"ZF1234","v":0},{"$nulls":3},"NPS (Employee)",null,"NPS (Employer)"]
[{"$nulls":674},"June",0,null,"Entertainment allowance u/s 16(ii)",{"$nulls":6},"Salary","DA","Salary ","DA"]
[{"$nulls":674},"July",0,null,"Death cum retirement gratuity u/s 10 (10)",{"$nulls":6},{"$f":"J13","v":0},{"$f":"ROUND(E25*K38/100,0)","v":0},{"$f":"ROUND((D13+E13)*J36/100,0)","v":0},{"$f":"ROUND(E25*J38/100,0)","v":0}]
[{"$nulls":674},"August",0,null,"Commuted value of the pension u/s 10(10A)",{"$nulls":6},{"$f":"J14","v":0},null,{"$f":"ROUND((D14+E14)*J37/100,0)","v":0}]
[{"$nulls":674},"September",0,null,"leave salary encashment u/s 10(10AA)",{"$nulls":6},0,null,0]
[{"$nulls":674},"October",0,null,"Travel concession allowance u/s10(5)",{"$nulls":6},0,null,0]
[{"$nulls":674},"November",0,null,"Deduction under section 80CCC",{"$nulls":6},0,null,0]
[{"$nulls":674},"December",0,null,"Interest on education, loan 80 E",{"$nulls":6},0,null,0]
[{"$nulls":674},"January",0,null,"HBA Interest under Sec.24B",{"$nulls":6},0,null,0]
[{"$nulls":674},"February",0,null,"Health Insurance 80D",{"$nulls":6},0,{"$f":"ROUND(E26*K44/100,0)","v":0},0,{"$f":"ROUND(E26*J44/100,0)","v":0}]
[{"$nulls":674},"NPS Employer Contrn",{"$f":"ZK1199","v":0},null,"NPS Contribution Employee 80CCD(1)",null,null,{"$f":"IF(YZ1227>ZL1182,0,(MIN(ZL1182-YZ1227,ZI1199)))","v":{"v":0,"d":"0.00"}},{"$nulls":3},0,null,0]
[{"$nulls":674},"DA-1 Arrears",{"$f":"E25","v":0},null,"NPS Contribution Employer 80CCD(2)",null,null,{"$f":"ZI1199","v":0},{"$nulls":3},0,null,0]
[{"$nulls":674},"DA-2 Arrears",{"$f":"E26","v":0},null,"NPS Contribution Employee 80CCD(1B)",null,null,{"$f":"MIN((ZI1199-ZE1194),ZL1183)","v":0},{"$f":"SUM(ZE1183:ZE1196)","v":0},null,null,0,null,0]
[{"$nulls":674},"Other Arrears",null,"Gross Income from Salary",{"$nulls":4},{"$f":"IF(ZF1182-ZF1196<0,0,ZF1182-ZF1196)","v":0},null,null,0,null,0]
[{"$nulls":674},"Ex-gratia/Bonus",null,"Standard deduction u/s 16(ia)",{"$nulls":4},{"$f":"IF(ZF1197>50000,50000,ZF1197)","v":0},null,null,{"$f":"SUM(ZI1186:ZI1197)","v":0},{"$f":"SUM(ZJ1186:ZJ1197)","v":0},{"$f":"SUM(ZK1186:ZK1197)","v":0},{"$f":"SUM(ZL1186:ZL1197)","v":0}]
[{"$nulls":674},"Leave Surrender",null,"1. Net Income from Salary",{"$nulls":4},{"$f":"ZF1197-ZF1198","v":0},null,null,{"$f":"ZI1198+ZJ1198","v":0},null,{"$f":"ZK1198+ZL1198","v":0}]
[{"$nulls":674},"Free Lighting / C A",null,"2. Income from House Property"]
[{"$nulls":674},"TOTAL SALARY",{"$f":"SUM(YZ1182:YZ1200)","v":0},"3. Income from Business / Profession",{"$nulls":7},"Total check",null,{"$f":"ZF1182-ZF1196","v":0}]
[{"$nulls":674},"Self reported salary from other employer",null,"4. Income from Other Sources",{"$nulls":4},{"$f":"YZ1211","v":0},null,null,"NPS Deduction Claimed",null,{"$f":"ZE1196+ZE1194","v":0}]
[{"$nulls":676},"Total",{"$nulls":4},{"$f":"ZF1199+ZF1200+ZF1201+ZF1202","v":0}]
[{"$nulls":674},"Value of perquisites17(2)",null,"GROSS TOTAL INCOME:",{"$nulls":4},{"$f":"ZF1203","v":0}]
[{"$nulls":674},"Profits in lieu of salary17(3)",null,"Less:","Tax rebate Under Section 80C ",{"$nulls":3},{"$f":"IF(YZ1227>ZL1182,ZL1182,YZ1227)","v":0}]
[{"$nulls":674},"Other income:-",null,null,"Donation under section 80G"]
[{"$nulls":674},"Interest from SB A/c",null,"TAXABLE/TOTAL   INCOME ",{"$nulls":4},{"$f":"ZF1203-ZF1205-ZF1206","v":0}]
[{"$nulls":674},"Any other",null,"NET TAXABLE INCOME  (in multiple of Rs.10/-)",{"$nulls":4},{"$f":"ROUND(ZF1207,-1)","v":0}]
[{"$nulls":674},"Interest on N.S.C",null,"INCOME TAX CALCULATION:"]
[{"$nulls":674},"matured",{"$nulls":3},{"$f":"ZI1177","v":0},{"$f":"ZJ1177","v":250000},{"$f":"IF(ZF1208>ZJ1177,ZJ1177,ZF1208)","v":{"v":0,"d":"0.00"}},{"$f":"ZE1210*$ZL$1177/100","v":0}]
[{"$nulls":674},"TOTAL OF OTHER INCOME",{"$f":"SUM(YZ1206:YZ1210)","v":{"v":0,"d":"0.00"}},null,null,250001,500000,{"$f":"IF(ZF1208<ZJ1177,0,IF(ZF1208<ZJ1178,ZF1208-ZJ1177,IF(ZF1208>(ZJ1178-1),(ZJ1178-ZJ1177))))","v":{"v":0,"d":"0.00"}},{"$f":"ZE1211*$ZL$1178/100","v":0}]
[{"$nulls":678},500001,1000000,{"$f":"IF(ZF1208<ZJ1178,0,IF(ZF1208<ZJ1179,ZF1208-ZJ1178,IF(ZF1208>ZJ1179,(ZJ1179-ZJ1178))))","v":{"v":0,"d":"0.00"}},{"$f":"ZE1212*$ZL$1179/100","v":0}]
[{"$nulls":678},1000001,"Above",{"$f":"IF(ZF1208>ZJ1179,ZF1208-ZJ1179,0)","v":{"v":0,"d":"0.00"}},{"$f":"ZE1213*$ZL$11180/100","v":0}]
[{"$nulls":674},"Savings details under section 80C",null,"TAXABLE INCOME AND GROSS I. T.",{"$nulls":3},{"$f":"SUM(ZE1210:ZE1213)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(ZF1210:ZF1213)","v":0}]
[{"$nulls":674},"1. LIC (Salary)",{"$f":"O30","v":{"v":0,"d":"0.00"}},"LESS: Rebate U/S 87A",{"$nulls":4},{"$f":"IF(ZF1208<500000,ZF1214,0)","v":0}]
[{"$nulls":674},"2. L.I.C.(Other)",null," Income Tax",{"$nulls":4},{"$f":"ZF1214-ZF1215","v":0}]
[{"$nulls":674},"3. KGID",{"$f":"K30","v":{"v":0,"d":"0.00"}},"Add:","1.  Cess on Tax",{"$nulls":3},{"$f":"ZF1216*$ZL$1181/100","v":0}]
[{"$nulls":674},"4. P.L.I",null,null,"2. Surcharge (if Applicable)"]
[{"$nulls":674},"5. FBF",null,"TOTAL TAX AMOUNT",{"$nulls":4},{"$f":"ZF1216+ZF1217+ZF1218","v":0}]
[{"$nulls":674},"6. GPF",{"$f":"L30","v":{"v":0,"d":"0.00"}},"LESS: Relief U/s 89"]
[{"$nulls":674},"7. Education fee",null,"NET INCOME TAX PAYABLE",{"$nulls":4},{"$f":"ZF1219-ZF1220","v":0}]
[{"$nulls":674},"8. NSC Purchased",null,"LESS:- INCOME TAX DEDUCTED AT SOURCE ",{"$nulls":4},{"$f":"N30","v":0}]
[{"$nulls":674},"9. HBA Principal",null,"BALANCE INCOME TAX PAYABLE/REFUNDABLE",{"$nulls":4},{"$f":"ZF1221-ZF1222","v":0}]
[{"$nulls":674},"10. Insurance"]
[{"$nulls":674},"11. Group Insurance",{"$f":"M30","v":{"v":0,"d":"0.00"}},null,"TOTAL TAX",null,"PER MONTH"]
[{"$nulls":674},"12. Any other",null,null,{"$f":"ZF1223","v":0},null,{"$f":"ZB1226/12","v":0}]
[{"$nulls":674},"TS other than NPS",{"$f":"SUM(YZ1215:YZ1226)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":674},"Total Savings",{"$f":"SUM(YZ1215:YZ1226)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":674},"Calculation of HRA Exemption",{"$nulls":3},"Least of the following will be HRA Exemption"]
[{"$nulls":674},"10% of BP+DP+DA",{"$f":"ROUND((ZB1261*10/100),0)","v":0},null,null,"1) Actual HRA Received ",null,null,{"$f":"YZ1234","v":0}]
[{"$nulls":674},"Rent paid - 10% of Salary",{"$f":"ROUND((ZD1259-YZ1231),0)","v":0},null,null,"2) Rent Paid in Excess of 10% of Salary      ",null,null,{"$f":"YZ1232","v":0}]
[{"$nulls":674},"40% salary",{"$f":"ROUND((ZB1261*40/100),0)","v":0},null,null,"3) 40% of Salary in Non Metro Cities ",null,null,{"$f":"YZ1233","v":0}]
[{"$nulls":674},"HRA Received",{"$f":"ZC1259","v":0},null,null,"LEAST",null,null,{"$f":"MIN(IF(ZF1231<0,0,ZF1231),IF(ZF1232<0,0,ZF1232),IF(ZF1233<0,0,ZF1233))","v":0}]
[{"$nulls":674}," This Document is  for educative purpose only. Efforts Have Been Made for Accurate Calculation of Income Tax. However, Finalization of the Same is subject to the Provisions of Income Tax Act of 1961 And time to time Amendments. Developer will not be responsible for any Damages and/or Errors and Omissions."]
[]
[]
[]
[]
[{"$nulls":674},"Signature",{"$nulls":4},"Signature"]
[]
[]
[]
[]
[]
[{"$nulls":675},"Month","Basic","DA","HRA","Rent Paid"]
[{"$nulls":675},"March",{"$f":"D13","v":0},{"$f":"E13","v":0},{"$f":"F13","v":0}]
[{"$nulls":675},"April",{"$f":"D14","v":0},{"$f":"E14","v":0},{"$f":"F14","v":0}]
[{"$nulls":675},"May",0,0,0]
[{"$nulls":675},"June",0,0,0]
[{"$nulls":675},"July",0,0,0]
[{"$nulls":675},"August",0,0,0]
[{"$nulls":675},"September",0,0,0]
[{"$nulls":675},"October",0,0,0]
[{"$nulls":675},"November",0,0,0]
[{"$nulls":675},"December",0,0,0]
[{"$nulls":675},"January",0,0,0]
[{"$nulls":675},"February",0,0,0]
[{"$nulls":675},"Total",{"$f":"SUM(ZA1247:ZA1258)","v":0},{"$f":"SUM(ZB1247:ZB1258)","v":0},{"$f":"F30","v":0},{"$f":"SUM(ZD1247:ZD1258)","v":0}]
[]
[{"$nulls":676},"BP+DP+DA",{"$f":"ZA1259+ZB1259","v":0}]
{"$rows_empty":570}
[{"$nulls":674},"Enter the Income Tax Rates and Details"]
[{"$nulls":664},"STATEMENT SHOWING THE DETAILS OF INCOME AND INCOME TAX PAYABLE ",{"$nulls":9},"From","Up To",null,"Rate"]
[{"$nulls":664},"NAME",{"$nulls":3},"PAN NO",null,"A. YEAR",{"$nulls":3},0,250000,null,0]
[{"$nulls":664},"DESIGNATION",{"$nulls":3},"KGID NO.",null,"P. YEAR",{"$nulls":3},{"$f":"YZ1834+1","v":250001},500000,null,5]
[{"$nulls":664},"DEDUCTOR PAN",{"$nulls":3},"TAN",{"$nulls":5},{"$f":"YZ1835+1","v":500001},1000000,null,20]
[{"$nulls":664},"Developed by Gopala K R, Assistant Professor, GFGC, Magadi. For any Feedback Contact gopalrajkr@gmail.com",{"$nulls":9},{"$f":"YZ1836+1","v":1000001},"Above",null,30]
[{"$nulls":664},"Salary","Amount","CALCULATION OF INCOME TAX",{"$nulls":7},"Education Cess",null,null,4]
[{"$nulls":664},"March",{"$f":"#REF!","v":{"$error":"#REF!"}},"Gross Salary income",{"$nulls":4},{"$f":"SUM(YP1858:YP1862)","v":{"$error":"#REF!"}},null,null,"Maximum Deduction U/S 80C",null,null,150000]
[{"$nulls":664},"April",{"$f":"#REF!","v":{"$error":"#REF!"}},"LESS:","Tax on employment U/S 16(iii)",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":3},"Maximum Deduction U/S 80CCD(1B)",null,null,50000]
[{"$nulls":664},"May",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"HRA under Sec.10(13a)",null,null,{"$f":"YV1891","v":{"$error":"#REF!"}},{"$nulls":3},"NPS (Employee)",null,"NPS (Employer)"]
[{"$nulls":664},"June",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Entertainment allowance u/s 16(ii)",{"$nulls":6},"Salary","DA","Salary ","DA"]
[{"$nulls":664},"July",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Death cum retirement gratuity u/s 10 (10)",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*YP1852/100,0)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*YP1852/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"August",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Commuted value of the pension u/s 10(10A)",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"September",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"leave salary encashment u/s 10(10AA)",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"October",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Travel concession allowance u/s10(5)",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"November",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Deduction under section 80CCC",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"December",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Interest on education, loan 80 E",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"January",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"HBA Interest under Sec.24B",null,null,{"v":5000,"d":"5000.00"},{"$nulls":3},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"February",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Health Insurance 80D",{"$nulls":6},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*$F$33/100,0)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*$F$33/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"NPS Empr Contrn",{"$f":"ZA1856","v":{"$error":"#REF!"}},null,"NPS Contribution Employee 80CCD(1)",null,null,{"$f":"IF(YP1884>ZB1839,0,(MIN(ZB1839-YP1884,YY1856)))","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"DA-1 Arrears",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"NPS Contribution Employer 80CCD(2)",null,null,{"$f":"YY1856","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"DA-2 Arrears",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"NPS Contribution Employee 80CCD(1B)",null,null,{"$f":"MIN((YY1856-YU1851),$R$20)","v":{"$error":"#REF!"}},{"$f":"SUM(YU1840:YU1853)","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Other Arrears",null,"Gross Income from Salary",{"$nulls":4},{"$f":"YV1839-YV1853","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"ROUND((#REF!+#REF!)*#REF!/100,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Ex-gratia/Bonus",null,"Standard deduction u/s 16(ia)",{"$nulls":4},{"$f":"IF(YV1854>50000,50000,YV1854)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(YY1843:YY1854)","v":{"$error":"#REF!"}},{"$f":"YZ1850+YZ1843","v":{"$error":"#REF!"}},{"$f":"SUM(ZA1843:ZA1854)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Leave Surrender",null,"1. Net Income from Salary",{"$nulls":4},{"$f":"YV1854-YV1855","v":{"$error":"#REF!"}},null,null,{"$f":"YY1855+YZ1855","v":{"$error":"#REF!"}},null,{"$f":"ZA1855+ZB1855","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Free Lighting / C A",null,"2. Income from House Property"]
[{"$nulls":664},"TOTAL SALARY",{"$f":"SUM(YP1839:YP1857)","v":{"$error":"#REF!"}},"3. Income from Business / Profession",{"$nulls":7},"Total check",null,{"$f":"YV1839-YV1841-YV1853","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Self reported salary from other employer",null,"4. Income from Other Sources",{"$nulls":4},{"$f":"YP1868","v":0},null,null,"NPS Deduction Claimed",null,{"$f":"YU1853+YU1851","v":{"$error":"#REF!"}}]
[{"$nulls":666},"Total",{"$nulls":4},{"$f":"YV1856+YV1857+YV1858+YV1859","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Value of perquisites17(2)",null,"GROSS TOTAL INCOME:",{"$nulls":4},{"$f":"YV1860","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Profits in lieu of salary17(3)",null,"Less:","Tax rebate Under Section 80C ",{"$nulls":3},{"$f":"IF(YP1885>ZB1839,ZB1839,YP1885)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Other income:-",null,null,"Donation under section 80G"]
[{"$nulls":664},"Interest from SB A/c",null,"TAXABLE/TOTAL   INCOME ",{"$nulls":4},{"$f":"YV1860-YV1862-YV1863","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Any other",null,"NET TAXABLE INCOME  (in multiple of Rs.10/-)",{"$nulls":4},{"$f":"ROUND(YV1864,-1)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Interest on N.S.C",null,"INCOME TAX CALCULATION:"]
[{"$nulls":664},"matured",{"$nulls":3},{"$f":"YY1834","v":0},{"$f":"YZ1834","v":250000},{"$f":"IF(YV1865>YZ1834,YZ1834,YV1865)","v":{"$error":"#REF!"}},{"$f":"YU1867*$R$14","v":{"$error":"#REF!"}}]
[{"$nulls":664},"TOTAL OF OTHER INCOME",{"$f":"SUM(YP1863:YP1867)","v":{"v":0,"d":"0.00"}},null,null,250001,500000,{"$f":"IF(YV1865<YZ1834,0,IF(YV1865<YZ1835,YV1865-YZ1834,IF(YV1865>(YZ1835-1),(YZ1835-YZ1834))))","v":{"$error":"#REF!"}},{"$f":"YU1868*$R$15/100","v":{"$error":"#REF!"}}]
[{"$nulls":668},500001,1000000,{"$f":"IF(YV1865<YZ1835,0,IF(YV1865<YZ1836,YV1865-YZ1835,IF(YV1865>YZ1836,(YZ1836-YZ1835))))","v":{"$error":"#REF!"}},{"$f":"YU1869*$R$16/100","v":{"$error":"#REF!"}}]
[{"$nulls":668},1000001,"Above",{"$f":"IF(YV1865>YZ1836,YV1865-YZ1836,0)","v":{"$error":"#REF!"}},{"$f":"YU1870*$R$17/100","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Savings details under section 80C",null,"TAXABLE INCOME AND GROSS I. T.",{"$nulls":3},{"$f":"SUM(YU1867:YU1870)","v":{"$error":"#REF!"}},{"$f":"SUM(YV1867:YV1870)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"1. LIC (Salary)",null,"LESS: Rebate U/S 87A",{"$nulls":4},{"$f":"IF(YV1865<500000,YV1871,0)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"2. L.I.C.(Other)",null,"NET Income Tax",{"$nulls":4},{"$f":"YV1871-YV1872","v":{"$error":"#REF!"}}]
[{"$nulls":664},"3. KGID",{"$f":"#REF!","v":{"$error":"#REF!"}},"Add: Cess on Tax",{"$nulls":4},{"$f":"YV1873*$R$18/100","v":{"$error":"#REF!"}}]
[{"$nulls":664},"4. P.L.I",null,"TOTAL TAX AMOUNT",{"$nulls":4},{"$f":"YV1873+YV1874","v":{"$error":"#REF!"}}]
[{"$nulls":664},"5. FBF",null,"LESS:- INCOME TAX DEDUCTED AT SOURCE ",{"$nulls":4},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":664},"6. GPF",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":664},"7. Education fee",null,"BALANCE INCOME TAX PAYABLE/REFUNDABLE",{"$nulls":4},{"$f":"YV1875-YV1876","v":{"$error":"#REF!"}}]
[{"$nulls":664},"8. NSC Purchased"]
[{"$nulls":664},"9. HBA Principal"]
[{"$nulls":664},"10. Insurance"]
[{"$nulls":664},"11. Group Insurance",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"TOTAL TAX",null,"PER MONTH"]
[{"$nulls":664},"12. Any other",null,null,{"$f":"YV1878","v":{"$error":"#REF!"}},null,{"$f":"YR1883/12","v":{"$error":"#REF!"}}]
[{"$nulls":664},"TS other than NPS",{"$f":"SUM(YP1872:YP1883)","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Total Savings",{"$f":"IF(YP1884>ZB1839,ZB1839,SUM(YP1884+YU1851))","v":{"$error":"#REF!"}}]
[]
[{"$nulls":664},"Calculation of HRA Exemption",{"$nulls":3},"Least of the following will be HRA Exemption"]
[{"$nulls":664},"10% of BP+DP+DA",{"$f":"ROUND((YR1918*10/100),0)","v":{"$error":"#REF!"}},null,null,"1) Actual HRA Received ",null,null,{"$f":"YP1891","v":{"$error":"#REF!"}}]
[{"$nulls":664},"Rent paid - 10% of Salary",{"$f":"ROUND((YT1916-YP1888),0)","v":{"$error":"#REF!"}},null,null,"2) Rent Paid in Excess of 10% of Salary      ",null,null,{"$f":"YP1889","v":{"$error":"#REF!"}}]
[{"$nulls":664},"40% salary",{"$f":"ROUND((YR1918*40/100),0)","v":{"$error":"#REF!"}},null,null,"3) 40% of Salary in Non Metro Cities ",null,null,{"$f":"YP1890","v":{"$error":"#REF!"}}]
[{"$nulls":664},"HRA Received",{"$f":"YS1916","v":{"$error":"#REF!"}},null,null,"LEAST",null,null,{"$f":"MIN(IF(YV1888<0,0,YV1888),IF(YV1889<0,0,YV1889),IF(YV1890<0,0,YV1890))","v":{"$error":"#REF!"}}]
[{"$nulls":664}," This Document only for educative purpose. Reasonable Efforts Have Been Made for Accurate Calculation of Income Tax. However, Finalization of the Same is subject to the Provisions of Income Tax Act of 1961 And time to time Amendments. Developer will not be responsible for any Errors and Omissions."]
[]
[]
[]
[]
[{"$nulls":664},"Signature",{"$nulls":4},"Signature"]
[]
[]
[]
[]
[]
[{"$nulls":665},"Month","Basic","DA","HRA","Rent Paid"]
[{"$nulls":665},"March",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"April",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"May",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"June",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"July",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"August",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"September",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"October",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"November",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"December",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"January",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"February",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":665},"Total",{"$f":"SUM(YQ1904:YQ1915)","v":{"$error":"#REF!"}},{"$f":"SUM(YR1904:YR1915)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(YT1904:YT1915)","v":0}]
[]
[{"$nulls":666},"BP+DP+DA",{"$f":"YQ1916+YR1916","v":{"$error":"#REF!"}}]
{"$rows_empty":34}
[{"$nulls":7},"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "]