{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["BLANK CALCU NEW","BLANK CALCU OLD","STATEMENT"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"BLANK CALCU NEW","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[17,1,17,7],[0,1,0,9],[2,1,2,9],[3,2,3,6],[3,8,3,9],[4,1,4,9],[5,1,5,3],[5,4,5,6],[5,8,5,9],[1,1,1,9],[6,1,6,9],[7,2,7,6],[8,1,8,9],[9,1,9,6],[10,1,10,6],[11,1,11,6],[16,1,16,7],[14,1,14,7],[14,9,15,9],[15,1,15,7],[11,8,14,8],[13,1,13,7],[12,1,12,6],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[24,1,24,7],[25,1,25,7],[22,1,22,7],[23,1,23,7],[26,1,26,4],[26,5,26,7],[26,8,26,9],[27,1,27,7],[27,8,27,9],[28,1,28,7],[28,8,28,9],[29,1,29,7],[29,8,29,9],[30,1,30,7],[30,8,30,9],[31,1,31,7],[31,8,31,9],[32,1,32,7],[32,8,32,9],[33,1,33,7],[33,8,33,9],[34,1,34,9],[35,1,35,2],[35,3,35,7],[35,8,35,9],[36,1,36,7],[36,8,36,9],[37,1,37,7],[37,8,37,9],[38,1,38,7],[38,8,38,9],[47,1,47,7],[48,1,48,7],[39,1,39,7],[39,8,39,9],[40,1,40,7],[40,8,40,9],[41,1,41,7],[41,8,41,9],[52,6,52,9],[53,1,53,5],[53,6,53,9],[42,1,42,7],[42,8,42,9],[43,1,43,9],[44,1,44,7],[44,8,48,8],[45,1,45,7],[46,1,46,7],[54,1,54,5],[54,6,54,9],[55,1,55,5],[55,6,55,9],[56,1,56,5],[16,8,25,8],[49,1,49,9],[50,1,52,5],[50,6,50,9],[51,6,51,9]],"flags":["formulas_cached_only"]}
[null,"FINAL COMPUTATION OF INCOME TAX FOR F.Y.-2022-23 (A.Y.2023-24) (NEW)"]
[null,"GOVERNMENT MEDICAL COLLEGE, SURAT."]
[]
[null,"NAME : ",{"$nulls":5},"DEPARTMENT : "]
[]
[null,"GPF OR C.P.F. A/C No. : ",{"$nulls":5},"I.TAX PAN NO. :"]
[]
[null,"DESIG. :",{"$nulls":5},"BILL NO./SR.NO. :"]
[]
[null,"  1. GROSS SALARY FROM THIS INSTITUTE:-              =",{"$nulls":5},0]
[null,"  1A. GROSS SALARY FORM OTHER INSTITUTE:-      =",{"$nulls":5},0]
[null,"  1B. (Less) PAY RECOVERY FROM PAY BILL :-          =",{"$nulls":5},0]
[null,"  1C. (Add) CPF(GOVERNMENT'S SHARE):-                   =",{"$nulls":5},0]
[null,"  2.TOTAL SALARY = (1+1A)-(1B)+(1C) :-",{"$nulls":7},0]
[null,"  3. ANY OTHER INCOME :-"]
[null,"       (A) Bank Interest & Other Income ",{"$nulls":6},0]
[null,"  4. GROSS TOTAL INCOME ( 2 + 3 (A) ) :-",{"$nulls":7},0]
[null,"  5. DEDUCTION U/S 80CCD(2) EMPLOYER CONTRIBUTION TO NPS UPTO 14%",{"$nulls":7},0]
[null,"  6. NET TAXABLE INCOME (ROUNDED IN NEAREST OF RS.10) :-(4)-(5)",{"$nulls":7},0]
[null,"  7. TOTAL INCOME TAX ON NET TAXABLE INCOME :-",{"$nulls":7},0]
[null,"  8. Less:-12,500/- U/S 87-A (If Net Taxable Income Less than Rs.5,00,001/-):-",{"$nulls":7},0]
[null,"  9. NET INCOME TAX  (7-8) :-",{"$nulls":7},0]
[null,"  10. Surcharge 10% if taxable income exceeds Rs.50 Lakhs",{"$nulls":7},0]
[null,"  11. Total Tax plus Surcharge (9)+(10)",{"$nulls":7},0]
[null,"  12. 4% EDUCATION CESS ON NET INCOME TAX + SC +EC :-",{"$nulls":7},0]
[null,"  13. TOTAL INCOME TAX ( 11 + 12) :-",{"$nulls":7},0]
[null,"       ",null,null,null,"-: FOR MALE & FEMALE :-"]
[null,"(A) As per Col. No.10, If Net Taxable Income upto Rs.2,50,000/-",{"$nulls":6},"Nil"]
[null,"(B) Between Rs.2,50,001/- To Rs.5,00,000/-",{"$nulls":6},0.05]
[null,"(C) Between Rs.5,00,001/- To Rs.7,50,000/-",{"$nulls":6},"10 % + 12500/-"]
[null,"(D) Between Rs.7,50,001/- To Rs.10,00,000/-",{"$nulls":6},"15 % + 37500/-"]
[null,"(E) Between Rs.10,00,001/- To Rs.12,50,000/-",{"$nulls":6},"20 % + 75000/-"]
[null,"(F) Between Rs.12,50,001/- To Rs.15,00,000/-",{"$nulls":6},"25 % + 125000/-"]
[null,"(G) Above Rs.15,00,001/-",{"$nulls":6},"30 % + 187500/-"]
[]
[null,"       ",null,"-: FOR SENIOR CITIZEN :-(Age Morethan 60)"]
[null,"(A) As per Col. No.10, If Net Taxable Income upto Rs.3,00,000/-",{"$nulls":6},"Nil"]
[null,"(B) Between Rs.3,00,001/- To Rs.5,00,000/-",{"$nulls":6},0.05]
[null,"(C) Between Rs.5,00,001/- To Rs.7,50,000/-",{"$nulls":6},"10 % + 10000/-"]
[null,"(D) Between Rs.7,50,001/- To Rs.10,00,000/-",{"$nulls":6},"15 % + 35000/-"]
[null,"(E) Between Rs.10,00,001/- To Rs.12,50,000/-",{"$nulls":6},"20 % + 72500/-"]
[null,"(F) Between Rs.12,50,001/- To Rs.15,00,000/-",{"$nulls":6},"25 % + 122500/-"]
[null,"(G) Above Rs.15,00,001/-",{"$nulls":6},"30 % + 185000/-"]
[]
[null,"15. Income Tax already Ded. From Salary of  3/2022 to 01/2023 :--------->",{"$nulls":7},0]
[null,"16. Self Advance Income Tax Paid :- Challan No.       & Date  :        /         /20     ",{"$nulls":7},0]
[null,"17. Income Tax Ded. From Salary of  02/2023 :------------------------------->",{"$nulls":7},0,0]
[null,"18. Total Income Tax   (15 + 16 + 17) :----------------------------------------->",{"$nulls":7},0]
[null,"19. Tax Payable(+) OR  Refundable (-)  (13 -18) :---------------------------->",{"$nulls":7},0]
[]
[{"$nulls":6},"All above information are true and correct"]
[]
[{"$nulls":6},"(SIGNATURE OF EMPLOYEE)"]
[null,"ACCOUNTS OFFICER  "]
[null,"GOVERNMENT MEDICAL COLLEGE"]
[null,"SURAT"]
[null,"OFFICE TAN NO.:- SRTG01499B",{"$nulls":4},"Mobile No:-"]

{"sheet":"BLANK CALCU OLD","index":1,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[[5,1,5,3],[8,1,8,9],[59,1,59,7],[21,1,21,7],[50,1,50,7],[56,1,56,7],[0,1,0,9],[2,1,2,9],[3,2,3,6],[3,8,3,9],[4,1,4,9],[23,1,23,7],[5,4,5,6],[5,8,5,9],[11,1,11,7],[30,8,32,8],[10,9,11,9],[22,8,23,8],[18,8,19,8],[6,1,6,9],[7,2,7,6],[32,1,32,7],[14,8,15,8],[28,1,28,7],[23,9,29,9],[15,1,15,7],[15,9,17,9],[16,1,16,7],[17,1,17,7],[18,1,18,7],[19,1,19,7],[33,1,33,7],[34,1,34,7],[35,1,35,7],[36,1,36,7],[37,1,37,7],[24,1,24,7],[25,1,25,7],[27,1,27,7],[30,1,30,7],[31,1,31,7],[20,1,20,7],[22,1,22,7],[47,1,48,7],[38,1,38,7],[39,1,39,7],[40,1,40,7],[41,1,41,7],[42,1,42,7],[43,1,43,7],[29,1,29,7],[51,1,51,7],[52,1,52,9],[53,1,53,9],[44,1,44,7],[45,1,45,7],[46,1,46,7],[49,1,49,7],[47,9,48,9],[47,8,48,8],[32,9,45,9],[54,1,54,7],[54,8,58,8],[55,1,55,7],[57,1,57,7],[58,1,58,7],[66,1,66,2],[66,3,66,7],[66,8,66,9],[60,1,60,4],[60,5,60,7],[60,8,60,9],[61,1,61,7],[61,8,61,9],[62,1,62,7],[62,8,62,9],[67,8,67,9],[68,1,68,7],[68,8,68,9],[69,1,69,7],[69,8,69,9],[63,1,63,7],[63,8,63,9],[64,1,64,7],[64,8,64,9],[65,1,65,9],[82,1,82,5],[82,6,82,9],[70,1,70,7],[70,8,70,9],[71,1,71,9],[72,1,72,7],[72,8,76,8],[73,1,73,7],[74,1,74,7],[75,1,75,7],[12,1,12,7],[13,1,13,7],[14,1,14,7],[77,1,77,9],[78,1,81,5],[78,6,78,9],[79,6,80,9],[81,6,81,9],[76,1,76,7],[67,1,67,7],[85,6,85,7],[85,8,85,9],[1,1,1,9],[83,1,83,5],[83,6,83,9],[84,1,84,5],[84,6,84,9],[85,1,85,5],[9,1,9,7],[10,1,10,7]],"flags":["formulas_cached_only"]}
[null,"FINAL COMPUTATION OF INCOME TAX FOR F.Y.-2022-23 (A.Y.2023-24) (OLD)"]
[null,"GOVERNMENT MEDICAL COLLEGE, SURAT."]
[]
[null,"NAME : ",{"$nulls":5},"DEPARTMENT : "]
[]
[null,"GPF OR C.P.F. A/C No. : ",{"$nulls":5},"I.TAX PAN NO. :"]
[]
[null,"DESIG. :","ASS. PROF",{"$nulls":4},"BILL NO./SR.NO. :"]
[]
[null,"  1. GROSS SALARY FROM THIS INSTITUTE:-              ",{"$nulls":7},0]
[null,"  1A. GROSS SALARY FORM OTHER INSTITUTE:-      ",{"$nulls":6},0]
[null,"  1B. (-) PAY RECOVERY FROM PAY BILL :-         ",{"$nulls":6},0]
[null,"  2. TOTAL SALARY IN YEAR (1+1A-1B)",{"$nulls":7},0]
[null,"  3. CPF (Government's Share) :-                   ",{"$nulls":6},0]
[null,"  4. TOTAL (2+3)",{"$nulls":7},0]
[null,"  5.  ALLOWANCE TO THE EXTEND EXEMPTED :-"]
[null,"       (5.A) Professional Tax (U/S.16(ia)",{"$nulls":6},0]
[null,"       (5.B) Standered Deduction U/S 16(i) (Rs.50,000/-)",{"$nulls":6},0]
[null,"  6. Total (5.A+5.B)",{"$nulls":7},0]
[null,"  7.  NET SALARY INCOME (4-6) :-",{"$nulls":7},0]
[null,"  8. OTHER INCOME:"]
[null,"       (A) Bank Interest & Other Income",{"$nulls":6},0]
[null,"  9. TOTAL INCOME (7+8)",{"$nulls":7},0]
[null,"10. DEDUCTION UNDER CHAPTER – VI-A :-"]
[null,"      (1)    Permanent Disability U/S.80U (Max Rs. 75000/-)",{"$nulls":6},0]
[null,"      (2)    Mediclaim Insurance Premium U/S.80 D (Max Rs. 25000/-) + Dependent parents if not senior citizen ",{"$nulls":6},0]
[null,"            Rs. 25000/- and dependent parents is senior citizen then Max Rs.50000)"]
[null,"      (3)   HBA Interest U/S.24B (i) (iv) (Maxi.2,00,000/-) (on or after 01/04/1999)",{"$nulls":6},0]
[null,"      (4)  Higher Education Loan Interest U/S.80E ",{"$nulls":6},0]
[null,"      (5)  Medical Treatment of Handicapped dependents U/S 80-DD  (Max.Rs.75000/-) ",{"$nulls":6},0]
[null,"11. TOTAL DEDUCTION UNDER CHAPER -VI-A (1 TO 5)",{"$nulls":7},0]
[null,"12. TOTAL INCOME (9-11) :-",{"$nulls":7},0]
[null,"13. DEDUCTION U/S.80-C (Maxi.Rs.150000) (From : 4/2022 TO 3/2023) :-"]
[null,"        (1) G.P.F. ",{"$nulls":6},0]
[null,"        (2) C.P.F. (U/S. 80 CCD (1)) ",{"$nulls":6},0]
[null,"        (3) P.P.F.",{"$nulls":6},0]
[null,"        (4) LIC Premium ",{"$nulls":6},0]
[null,"        (5) N.S.C. Deposit",{"$nulls":6},0]
[null,"        (6) N.S.C. Interest re-ivested",{"$nulls":6},0]
[null,"        (7) Housing Loan Principal Amt. ",{"$nulls":6},0]
[null,"        (8) Deposit in 10 Year, 15 Year Account under P.O. Saving Band (CTD)",{"$nulls":6},0]
[null,"        (9) State Group Insurance",{"$nulls":6},0]
[null,"       (10) ULIP / Equity Link Saving Fund",{"$nulls":6},0]
[null,"       (11) Investment in Pension Fund",{"$nulls":6},0]
[null,"       (12) PLI Premium",{"$nulls":6},0]
[null,"       (13) Education Fees (Tution/Education Fee Only/Up to 2 Children)",{"$nulls":6},0]
[null,"14. TOTAL INVEST. U/S.80-C  (MAX RS.1,50,000) {1 to 13} :-",{"$nulls":7},0]
[null,"15. DEDUCTION U/S.80-CCD (1B) (Maxi.Rs.50000) (From:-4/22 to 3/23)\n      CPF (Emplyee's Share) OR Investment in NPS individual  :-",{"$nulls":6},0]
[]
[null,"16. TOTAL INVEST. U/S.80-C + CCD (1B) (MAX RS.2,00,000) {14+15} :-",{"$nulls":7},0]
[null,"17. CPF (Government's Share) U/S. 80 CCD (2) (Maximum 14% of Basic+DA)",{"$nulls":6},0]
[null,"18. NET TAXABLE INCOME (ROUNDED IN NEAREST OF RS.10) (12-16):-",{"$nulls":7},0]
[null,"GOVERNMENT MEDICAL COLLEGE, SURAT.                                                                     …2…"]
[null,"     …2…"]
[null,"19. TOTAL INCOME TAX ON NET TAXABLE INCOME :-",{"$nulls":7},0]
[null,"20. Less:-12,500/- U/S 87-A (If Net Taxable Income Less than Rs.5,00,001/-):-",{"$nulls":7},0]
[null,"21. ADD SC 10% IF TOTAL INCOME MORE THAN 50LAKS",{"$nulls":7},0]
[null,"22. TOTAL TAX (19-20+21) ",{"$nulls":7},0]
[null,"23. 4% EC ON 22",{"$nulls":7},0]
[null,"24. TOTAL INCOME TAX (22+23)",{"$nulls":7},0]
[null,"       ",null,null,null,"-: FOR MALE & FEMALE :-"]
[null,"(A) As per Col. No.11, If Net Taxable Income upto Rs.2,50,000/-",{"$nulls":6},"Nil"]
[null,"(B) Between Rs.2,50,001/- To Rs.5,00,000/-",{"$nulls":6},0.05]
[null,"(C) Between Rs.5,00,001/- To Rs.10,00,000/-",{"$nulls":6},"20 % + 12500/-"]
[null,"(D) Above Rs.10,00,001/-",{"$nulls":6},"30 % + 112500/-"]
[]
[null,"       ",null,"-: FOR SENIOR CITIZEN :-(Age Morethan 60)"]
[null,"(A) As per Col. No.11, If Net Taxable Income upto Rs.3,00,000/-",{"$nulls":6},"Nil"]
[null,"(B) Between Rs.3,00,001/- To Rs.5,00,000/-",{"$nulls":6},0.05]
[null,"(C) Between Rs.5,00,001/- To Rs.10,00,000/-",{"$nulls":6},"20 % + 10000/-"]
[null,"(D) Above Rs.10,00,001/-",{"$nulls":6},"30 % + 110000/-"]
[]
[null,"25. Income Tax already Ded. From Salary of  3/2022 to 01/2023 :-",{"$nulls":7},0]
[null,"26. Self Advance Income Tax Paid :- Challan No.               & Date :         /      /20         .",{"$nulls":7},0]
[null,"27. Income Tax Ded. From Salary of  02/2023 :-",{"$nulls":7},0,{"$error":"#REF!"}]
[null,"28. Total Income Tax   (24+25+26) :-",{"$nulls":7},0]
[null,"29. Tax Payable (+) OR  Refundable (-)  (24-28) :-",{"$nulls":7},0]
[]
[{"$nulls":6},"All above information are true and correct"]
[]
[]
[{"$nulls":6},"(SIGNATURE OF EMPLOYEE)"]
[null,"ACCOUNTS OFFICER  "]
[null,"GOVERNMENT MEDICAL COLLEGE"]
[null,"SURAT"]
[null,"OFFICE TAN NO.:- SRTG01499B",{"$nulls":4},"Mobile No:-"]

{"sheet":"STATEMENT","index":2,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,21],[2,0,2,21],[3,0,3,3],[3,11,3,14],[5,4,5,9],[30,4,30,6],[27,8,27,11],[30,14,30,19],[3,10,5,10],[3,4,3,9],[4,15,4,21],[26,17,26,19],[4,11,4,14],[4,4,4,9],[29,4,29,6],[4,0,4,3],[3,15,3,21],[26,8,26,11],[5,11,5,21],[6,0,6,21],[5,0,5,3]],"flags":["formulas_cached_only"]}
[]
["A STATEMENT OF SHOWING ANNUAL INCOME OF SALARY DURING THE YEAR 2022-23 "]
["GOVERNMENT MEDICAL COLLEGE, SURAT"]
["NAME : ",{"$nulls":10},"DESIG. :"]
["GPF OR C.P.F. A/C. NO.: ",{"$nulls":10},"I.TAX PAN CARD NO. : "]
["DEPARTMENT : ",{"$nulls":10},"OFFICE TAN NO. : SRTG01499B"]
[]
["MONTH\n/ YEAR","SP.\nPAY","PAY\nBAND","GR.PAY","NPPA","DA","HRA ","CLA","MA","BOOK\nALL.","MESS./\nW.A.","TA","GROSS\nTOTAL","INCOME\nTAX","HRR","P.TAX","SIS","GPF","CPF","PAY\nRECO.","HBA / \nHBA INT.","LIC"]
["2022-03-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-04-02",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-05-04",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-06-05",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-07-07",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-08-08",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-09-09",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-10-11",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-11-12",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2022-12-14",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2023-01-15",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2023-02-16",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL N.P.A",{"$nulls":4},0,0,{"$nulls":5},0,0]
["TOTAL D.A",{"$nulls":4},0,{"$nulls":6},0,0]
["ANY PAY\n DIFF.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ANY PAY\n DIFF.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["L.Encha\n(LTC)",null,0,{"$nulls":9},0,0]
["TOTAL",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":13},0]
[null,null,0]
[]
[{"$nulls":4},"ACCOUNTS OFFICER"]
[{"$nulls":4},"GOVERNMENT MEDICAL COLLEGE",{"$nulls":9},"(SIGNATURE OF EMPLOYEE)"]
[{"$nulls":5},"SURAT"]