| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TS INCOME TAX SOFTWARE FOR FY 2024-25(AY2025-26) (A4 size prints)-BEFORE GOING TO ENTER,NEW EXCEL FILE DOWNLOAD FROM WWW.MEDAKBADI.IN | Prepared by (WWW.MEDAKBADI.IN) KOTA VIJAYAKUMAR, GHM Gr-II, ZPHS KOTHLAPUR, MDL&DIST:SANGAREDDY | ||||||||||||||||||||||||||||
2 | Prepared by WWW.MEDAKBADI.IN (VIJAYA KUMAR KOTA GHM Gr-II, ZPHS KOTHLAPUR, MDL&DIST:SANGAREDDY,TS | IT IS REFERENCE PURPOSE | ||||||||||||||||||||||||||||
3 | Category (Age): | General (less than 60 years) | if need,D.O.B | PAY PARTICULARS | >>> DA ARREARS >>> | DA-26.39 | ||||||||||||||||||||||||
4 | If appoint after 1-Jul-2022,Date | NA | Select Basic Pay as on | Dec-2024 | If AAS Taken ? | No | Date | Due to | Total>>>> | - | - | - | ||||||||||||||||||
5 | EMPLOYEE DETAILS | Employee Name | Sri/Smt | N Mallikarjun | Basic Pay as on Dec-2024 | 69,150 | If yes ,Date | 24.10.2024 | From | To | Basic pay | Diff-3.64 | if CPS 10% | if CPS 90% | ||||||||||||||||
6 | Employee Designation | SA Maths | Select Increment Month | Jun | if Basic pay's >1 Incre? | No | 12/30/1899 | 12/31/1899 | S/L-1 | 4461 | - | - | - | |||||||||||||||||
7 | Working Office/School | ZPHS Marepally | Select P.F Type | ZP GPF | If Yes,Select Basic Pay | 92,050 | 12/30/1899 | 12/31/1899 | S/L-1 | 4461 | - | - | - | |||||||||||||||||
8 | Employee PAN NO | XXX | T.S Incre | Promotion Taken? | No | 12/30/1899 | 12/31/1899 | S/L-1 | 4461 | - | - | - | ||||||||||||||||||
9 | Treasury ID No | XXX | FPI+PP | If yes ,Date | 24.06.2024 | 12/30/1899 | 12/31/1899 | S/L-1 | 4461 | - | - | - | ||||||||||||||||||
10 | If Know ,TSGLI NO | Spl.Pay | FIXATION TYPE | Increment date | 7/1/2022 | 7/31/2022 | 69150 | - | - | - | ||||||||||||||||||||
11 | If Know,GPF/CPS NO | Child Fee Concession | if pay fix @Mini | 78,820 | 8/1/2022 | 8/31/2022 | 69150 | - | - | - | ||||||||||||||||||||
12 | DDO DETAILS | DDO NAME | PHC Applicable? | NA | >=40% | Your PHC Allowance | 0 | UPDATED INCOME TAX SOFTWARE FY 2024-25 | 9/1/2022 | 9/30/2022 | 69150 | - | - | - | ||||||||||||||||
13 | DDO DESIGN | Allowances>Changed Dates | 01.03.2024 | 16.04.2024 | 10/1/2022 | 10/31/2022 | 69150 | - | - | - | ||||||||||||||||||||
14 | DDO OFFICE | ALLOWANCES | Select Allowances as on 01.03.2024 | Select below only changed Allowances as on above date | Enter date in above cell,if any Allowance change again | Check all values with experts | 11/1/2022 | 11/30/2022 | 69150 | - | - | - | ||||||||||||||||||
15 | DDO PAN | PANNOTREQD | TAN NO | HRA | 11 | 13 | No Change | 12/1/2022 | 12/31/2022 | 69150 | - | - | - | |||||||||||||||||
16 | Other Income Details | Other Income Details Per Annum | Rupees | CCA | Not Applicable | Not Applicable | Not Applicable | IMPORTANT SOFTWARES FROM MEDAKBADI YOU MAY DOWNLOAD THEM BY CLICKING ON BELOW LINKS | 1/1/2023 | 1/31/2023 | 69150 | - | - | - | ||||||||||||||||
17 | Interest on NSC bonds & Bank deposits | SCA | Not Applicable | Not Applicable | Not Applicable | 2/1/2023 | 2/28/2023 | 69150 | - | - | - | |||||||||||||||||||
18 | Income from house property(exclude M.Taxes&Unrealized Rent) | AHRA | No | No | No | 3/1/2023 | 3/31/2023 | 69150 | - | - | - | |||||||||||||||||||
19 | Family Pension | Income form other sources | H.M Allowance | 0 | ANNUAL GRADE INCREMENT & ALL TYPE OF LEAVE PROCEEDING SOFTWARE | 4/1/2023 | 4/30/2023 | 69150 | - | - | - | |||||||||||||||||||
20 | Sec 80C DETAILS | BELOW SELECT FOR >> SAVING UNDER CHAPTER VIA(80C,80CCC,80CCD) | Rupees | Uniform Allowance | 0 | 5/1/2023 | 5/31/2023 | 69150 | - | - | - | |||||||||||||||||||
21 | Children Tution Fee | Others | 0 | MID DAY MEALS SOFTWARE(All 12 months) for HS | 6/1/2023 | 6/30/2023 | 69150 | - | - | - | ||||||||||||||||||||
22 | Repayment of Home Loan Premium (principal component) | SALARY DEDUCTIONS | PREMIUM | IF CHANGE, Rs. | PERIOD FROM | 7/1/2023 | 7/31/2023 | 69150 | - | - | - | |||||||||||||||||||
23 | National Savings Certificate(NSC) | ZP GPF | 10000 | TS AAS (6/12/18/24 YEARS SCALES) SOFTWARE | 8/1/2023 | 8/31/2023 | 69150 | - | - | - | ||||||||||||||||||||
24 | PLI Annual Premuim | TSGLI Type | TSGLI | 3000 | 9/1/2023 | 9/30/2023 | 69150 | - | - | - | ||||||||||||||||||||
25 | LIC Annual Premiums Paid by Hand | GIS | 120 | PROMOTION FIXATION SOFTWARE ALL GOVT EMPLOYEES | 10/1/2023 | 10/31/2023 | 69150 | - | - | - | ||||||||||||||||||||
26 | Any other deductable (u/s 80C) | LIC | 11/1/2023 | 11/30/2023 | 69150 | - | - | - | ||||||||||||||||||||||
27 | OTHER SEC DEDUCTION | SELECT OTHER DEDUCTION (e.g. 80E, 80G, 80U, etc.) under Chapter VI-A | Rupees | EHS | 0 | Medical Reimbursement Proposal for working,retire & death | 12/1/2023 | 12/31/2023 | 69150 | - | - | - | ||||||||||||||||||
28 | Home loan interest(1st home,stamp value<=45 lacks,loan in Apr,2019 to Mar,2022) | Other Deduction | 1/1/2024 | 1/31/2024 | 69150 | - | - | - | ||||||||||||||||||||||
29 | 80E-Interest on Educational Loan | GPF LOAN AND PART FINAL SOFTWARE | 2/1/2024 | 2/29/2024 | 69150 | - | - | - | ||||||||||||||||||||||
30 | 80TTA-Interest on Savings account | EWF Period & Rs | Mar-2024 | 20 | 3/1/2024 | 3/31/2024 | 69150 | - | - | - | ||||||||||||||||||||
31 | 80DD-Treatment of Handicapped Dependent-above 80%disability | SWF Period & Rs | Dec-2024 | 100 | ALL TYPE OF PENSIONER's SOFTWARES-TS | 4/1/2024 | 4/15/2024 | 34575 | - | - | - | |||||||||||||||||||
32 | 80D-Medical Insurance Premium-senior citizen dependent parents | Green Fund Period & Rs | Apr-2024 | 300 | 4/16/2024 | 4/30/2024 | HRA-2 | 34575 | - | - | - | |||||||||||||||||||
33 | 80D-Medical Insurance Premium-Self ,Spouse & Children | CMRF-Period & Rs | Sep-2024 | 1 day | TDS FORM 24 Q SOFTWARE FY 2023-24 | 5/1/2024 | 5/31/2024 | 69150 | - | - | - | |||||||||||||||||||
34 | check updated softwares >WWW.MEDAKBADI.IN | Adv.Tax respective month If not paid | Advance tax paid | 6/1/2024 | 6/30/2024 | 69150 | - | - | - | |||||||||||||||||||||
35 | if any other arrears received in FY 2024-25 | If any Arrears received, Enter below | Quarter? | Salary Month | Rupees | Surrender leave Period & Days | NA | 15 | Supplementary & Leave salary Arrears bill software in RPS-2020 for TS&AP | 7/1/2024 | 7/31/2024 | 69150 | - | - | - | |||||||||||||||
36 | No.of Instals credit RPS-2020 Arrears | #REF! | Q1 | Mar-2024 | if ,Surrender leave Period & Days | NA | 15 | 8/1/2024 | 8/31/2024 | 69150 | - | - | - | |||||||||||||||||
37 | Pay Details | RPS-2020 Arrears @ one month | Other Arrears-1 | Other Arrears-2 | #REF! | Apr-2024 | if ,Surrender leave Period & Days | NA | 30 | ALL TYPE OF ENTRANCE EXAMS HALL WISE SEATING ARRANGEMENT SOFTWARE | 9/1/2024 | 9/30/2024 | 69150 | - | - | - | ||||||||||||||
38 | BASIC PAY | #REF! | May-2024 | ENTER RECEIVED -ZP GPF- DA ARREARS,IF NOT,ENTER 0 VALUE IN CELLS | 10/1/2024 | 10/31/2024 | 69150 | - | - | - | ||||||||||||||||||||
39 | DA | #REF! | Q2 | Jun-2024 | DA Rates | For reference | Enter,GPF Credit Rs. | Enter credit CPS10% | Claimed CPS-90% amount | SALARY PAY BILL AND EL SURRENDER BILL SOFTWARE WITH CIVIL LIST IN RPS-2020 | 11/1/2024 | 11/30/2024 | 69150 | - | - | - | ||||||||||||||
40 | HRA | #REF! | Jul-2024 | N.A | GPF DA:0 | 0 | 0 | 12/1/2024 | 12/31/2024 | 69150 | - | - | - | |||||||||||||||||
41 | CCA | #REF! | Aug-2024 | Other DA Arrears 1 | SSC NOMINAL ROLL SOFTWARE FOR TS | 1/1/2025 | 1/31/2025 | 69150 | - | - | - | |||||||||||||||||||
42 | Others | #REF! | Q3 | Sep-2024 | Other DA Arrears 2 | 2/1/2025 | 2/28/2025 | 69150 | - | - | - | |||||||||||||||||||
43 | CPS/GPF | #REF! | Oct-2024 | WWW.MEDAKBADI.IN (ALL OTHER SOFTWARES) | 12/31/1899 | 1547985208 | - | - | - | |||||||||||||||||||||
44 | Other Deduction | #REF! | Nov-2024 | Rent Type | Rent | To Exempt,Enter Rent @month Rs.0/ | 12/31/1899 | 1547985208 | - | - | - | |||||||||||||||||||
45 | Prepared by (WWW.MEDAKBADI.IN) KOTA VIJAYAKUMAR, GHMGr-II, ZPHS KOTHLAPUR, MDL&DIST:SANGAREDDY | #REF! | Q4 | Dec-2024 | Enter Rent@ one Month | Owner PAN No | UPDATED INCOME TAX SOFTWARE FY 2024-25 | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||
46 | #REF! | Jan-2025 | If rented,Owner Name | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||||
47 | #REF! | Feb-2025 | If rented,Address | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||||
48 | #REF! | Total | - | If change ,Rent Rs. | if changed ,select rent changed month | Aug-2023 | WWW.MEDAKBADI.IN | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||
49 | ChooseTax Slab for New Tax Regime u/s 115BAC or Old Slab ? | Auto selection | #REF! | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||||
50 | If choose "Auto selection" mode on above slab type,it will take automatically which Slab benefit for you | WWW.MEDAKBADI.IN | 12/31/1899 | 1547985208 | - | - | - | |||||||||||||||||||||||
51 | if avail, Select Leave Type | HPL's | 12/31/1899 | 1547985208 | - | - | - | |||||||||||||||||||||||
52 | Select Only Month | 01-04-2024 | WWW.MEDAKBADI.IN | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||||
53 | 15-04-2024 | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||||||
54 | Enter availed days in above period | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||||||
55 | WWW.MEDAKBADI.IN | WWW.MEDAKBADI.IN | WWW.MEDAKBADI.IN | WWW.MEDAKBADI.IN | WWW.MEDAKBADI.IN | 12/31/1899 | 1547985208 | - | - | - | ||||||||||||||||||||
56 | Relief u/s 89 ? (Form 10E) | No | ||||||||||||||||||||||||||||
57 | S.No | Relevant Financial Year | Taxable Income for Relevant FY | Arrears Received in Relevant FY | Auto DA Calculation | DA ARREARS YEAR WISE | Diff-3.64 | GPF | if CPS 10% | if CPS 90% | ||||||||||||||||||||
58 | Total DA Arrears | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
59 | 1 | FY | 2011-12 | FY 2022-23 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
60 | 2 | FY | 2012-13 | FY 2023-24 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
61 | 3 | FY | 2013-14 | FY 2024-25 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
62 | 4 | FY | 2014-15 | |||||||||||||||||||||||||||
63 | 5 | FY | 2015-16 | To get relief U/s 89 for FY 2024-25 calculation as follows | ||||||||||||||||||||||||||
64 | 6 | FY | 2016-17 | Choose your Option As Old Or New Tax Regime from F.Y.2020-21 to F.Y.2023-24 | To be retire | GPF | if CPS 10% | CPS-90% -Jan&Feb-24 | ||||||||||||||||||||||
65 | 7 | FY | 2017-18 | FY 2022-23 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
66 | 8 | FY | 2018-19 | FY 2023-24 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
67 | 9 | FY | 2019-20 | |||||||||||||||||||||||||||
68 | 10 | FY | 2020-21 | >>>> | Old Tax Regime | Total | 0 | 0 | 0 | 0 | ||||||||||||||||||||
69 | 11 | FY | 2021-22 | >>>> | Old Tax Regime | Reference DA arrears | ||||||||||||||||||||||||
70 | 12 | FY | 2022-23 | >>>> | Old Tax Regime | 2022-23 | 0 | |||||||||||||||||||||||
71 | 13 | FY | 2023-24 | >>>> | Old Tax Regime | 2023-24 | 0 | |||||||||||||||||||||||
72 | ||||||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||||||