{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Income Tax"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Income Tax","index":0,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,0,3,1],[55,10,57,14],[5,0,18,0],[50,0,50,5],[49,1,49,4],[48,0,49,0],[46,0,47,0],[27,0,43,0],[51,0,58,0],[23,0,24,0],[47,1,47,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[1,0,1,5],[0,1,0,5],[2,0,2,5],[5,1,6,5],[29,1,29,2],[28,1,28,2],[20,1,20,2],[21,1,21,2],[28,5,34,5],[25,1,25,4],[22,1,22,3],[23,1,23,3],[26,1,26,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[37,1,37,2],[39,1,39,2],[27,1,27,5],[48,1,48,2],[36,1,36,3],[40,1,40,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[35,1,35,2],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[24,1,24,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3]]}
["              KANNUR UNIVERSITY","KANNUR UNIVERSITY"]
["NEW TAX REGIME"]
["Final Income Statement for the Financial Year 2025-2026(Assessment Year 2026-2027) of "]
["Smt/Sri",null,null,"Designation"]
[null,"PAN of the Employee: ",null,"PF NO: "]
[1,"GROSS SALARY"]
[]
[null,"Basic Pay "]
[null,"Dearness Allowance"]
[null,"HRA"]
[null,"Allowance  (CCA/Special Allow/etc.)"]
[null,"DA Arrears"]
[null,"Leave Surrender"]
[null,"NPS Employer Share"]
[null,"CV Camp Remuneration/ Bonus"]
[null,"Misc Bills "]
[null,"Festival Allowance"]
[null,"PF Interest"]
[null,"Others"]
[null,"DIES NON"]
[null,"Add:Value of perquisite (5.5 % for GO'S & 7.5 % for NGO'S(Attach form No.12BA)"]
[null,"Aggregate of Salary and Perquisite ",null,null,{"$f":"ROUND(E8+E9+E10+E11+E12+E13+E14+E15+E16+E17+E18+E19+E21-E20,0)","v":0}]
[null,"Add:Income from other sources (Interest accrued on NSC, Interest on deposites etc.)"]
[2,"Gross Total Income",null,null,null,{"$f":"(E22+F23)","v":0}]
[null,"(3)NPS Employer Share u/s 80CCD",null,null,{"$f":"E14","v":0}]
[null,"Standard Deduction  (75000)"]
[null,"Total Income ",null,null,null,{"$f":"(F24-E25-75000)","v":-75000}]
[3,"Income Tax on the above"]
[null,null,null,"Taxable Amount","Tax"]
[null,"(a)Upto Rs.4,00,000/- 0%",null,{"$f":"IF(F27>400000,400000,F27)","v":-75000},{"$f":"D30*0","v":0}]
[null,"(b)From Rs.400001/- to Rs.8,00,000/-(5% of the amount by which total income exceeds  Rs.4,00,000/-) -5%",null,{"$f":"IF(F27>800000,400000,(F27-D30))","v":0},{"$f":"ROUND(D31*0.05,0)","v":0}]
[null,"(c)From Rs.8,00,001/- to Rs12,00000/-(10% of the amount by which total income exceeds Rs.8,00,000/-)-10%",null,{"$f":"IF(F27>1200000,400000,(F27-D30-D31))","v":0},{"$f":"ROUND(D32*0.1,0)","v":0}]
[null,"(e)From Rs.12,00,001/- to 1600000(15% of the amount by which total income exeeds Rs.12,00,000/- )-15%",null,{"$f":"IF(F27>1600000,400000,F27-D30-D31-D32)","v":0},{"$f":"ROUND(D33*0.15,0)","v":0}]
[null,"(f)From Rs.16,00,001/- to 20,00,000(20% of the amount by which total income exeeds Rs 16,00,000/- )-20%",null,{"$f":"IF(F27>2000000,400000,(F27-D30-D31-D32-D33))","v":0},{"$f":"ROUND(D34*0.2,0)","v":0}]
[null,"(g)From Rs.20,00,001/- to 24,00,000(25% of the amount by which total income exeeds Rs 20,00,000/- )-25%",null,{"$f":"IF(F27>2400000,400000,(F27-D30-D31-D32-D33-D34))","v":0},{"$f":"ROUND(D35*0.25,0)","v":0}]
[null,"(h)From Rs.24,00,001/-and above(30% of the amount by which total income exeeds Rs 24,00,000/- )-30%",null,{"$f":"IF(F27>2400000,F27-2400000,(F27-D30-D31-D32-D33-D34-D35))","v":0},{"$f":"ROUND(D36*0.3,0)","v":0}]
[null,"Total Tax",null,null,{"$f":"SUM(E30:E36)","v":0}]
[null,"Less rebate u/s 87A  limited to Rs.60000 for individuals having total income upto Rs.12,00,000/-",null,null,{"$f":"IF(F27>1200000,0,E37)","v":0}]
[null,"Marginal Relief( if taxable amount is below 22222)",null,null,{"$f":"IF(E37<=70588,(-1200000+F27),E37)","v":-1275000}]
[null,"Marginal Relief( if taxable amount is below 70588)",null,null,{"$f":"IF(E39<0,0,E39)","v":0}]
[null,"Total Tax-Less rebate",null,null,{"$f":"IF(E39>0,0,E37-E38)","v":0}]
[null,null,null,null,{"$f":"IF(E39=0,E41,E39)","v":-1275000}]
[null,null,null,null,{"$f":"IF(E42<0,0,E42)","v":0}]
[null,"Health and Education Cess @4%",null,null,{"$f":"IF(E42<0,0,ROUNDUP(E42*4/100,0))","v":0}]
[null,"Add: Health and Education Cess @ 4%",null,null,{"$f":"E43+E44","v":0}]
[null,"Less:Relief U/S 89(1) -Attach details"]
[null,"Tax Payable",null,null,{"$f":"E45-E46","v":0}]
[null,"Less:Tax already deducted at source"]
[null,"Net Tax Payable",null,null,{"$f":"E47-E48","v":0}]
[null,"Status",null,null,null,{"$f":"IF(E49=0,\"No Tax\",IF(E49<0,\"Refund\",IF(E49>0,\"Tax Payable\")))","v":"No Tax"}]
["Certified that the details given above are true to the best of my knowledge and belief."]
[null,"Signature    "]
[null,"Name",{"$f":"C4","v":0}]
[null,"Designation",{"$f":"E4","v":0},null,null,""]
[null,"Section"]
[null,"Branch"]
[null,"Ph.No:"]