AP Model School Teachers Income Tax Excel Softwares. Income Tax Excel Software prepared by Ch V Ramana Murty, PGT-Mathematics, APMS-L.Kota for AP Model School Teachers is available to download. This Excel Program helps AP Model School Teachers in preparing their Income Tax returns to be submitted at the Financial Year ending. If any modifications or doubts on this APMS Income Tax Software, kindly contact the developer of this Model Schools IT Excel Software developer. 2019-20 Financial Year (2020-21 AY) Software is available to download below.
DISCLAIMER
AP Model School Teachers Income Tax Excel Softwares
- 1. This program is prepared for IT-calculation and Form-16 of APMS employees for the financial year 2019-20. It is augmented with 10E calculations for needy employees. It is useful as long as the Taxable Income does not exceed Rs. 50,00,000. It is useful for APMS employees paying tax with TAN of the DDO.
- This program is prepared based on the Tax Slabs & Tax Rebate as declared in Budget of 2019 for the financial year 2019-2020.
STEPS TO USE
- 1. Confirm with the office whether all the Salary Bills (except Feb2019) and all Arrear Bills claimable in the FY:2019-2020 are finalised and get a copy of them available for reference. Get a copy of Arrear Split Statement of all the arrears received/receiving from the office. If you are claiming tax relief then you will additionally need ITR1/Revised-ITR1 of AYs to which the Arrears belong. Now go to the Data Sheet.
- 2. Enter the Dates of generating forms 12BB, Tax-Relief and Form-16.
- 3. Fill the "Details of the Employee".
- 4. Fill the "Details of the Employer (DDO)".
- 5. In the "Details of House Rent & Residing Address", fill "I live in" by selecting "Rented House" or "Own House". If "Rented House" is selected then fill "Annual Rent (Rs.)", "Owner's Name", "Rented Address" and "Owner's PAN"(if Annual Rent > Rs.1L). If "Own House" is selected then fill the "Residing Address".
- 6. Fill in the "SALARY INCOME PARTICULARS" with Salaries and Arrears of Mar-2019 to Feb-2020, and Arrears of Past FYs as per the references mentioned in Step-1. If there is any TAX(TDS) deducted from your salaries of Mar-2019 to Jan-2020 then such amounts have to be entered in the yellow cells. The balance TDS deductible with salary of Feb-2020 will automatically reflect. Note :- Care has to be taken while filling Arrear Amounts. For example if DA(27.248%) arrear for Jan2018 to Mar2019 totals to Rs.9150 then it has to be split into two parts as per the references mentioned in the Step-1 as follows :
- a. Total Arrear Amount for Mar2019 to Mar2019 say Rs.615 is to be entered in Current FY Arrears and
- b. Total Arrear Amount for Jan2018 to Feb2019 say Rs.8535 is to be entered in Past FYs Arrears.
- 7. Fill in the "INCOME/LOSS FROM HOUSE PROPERTY" with appropriate information. ITD has made it mandatory to furnish the details. Also, this year the Govt is allowing upto 2 self occupied houses without rental income, So multiple home owners may take its advantage.
- 8. Fill in "Add Income" particulars (optional).
- 9. Fill in the DEDUCTIONS under CHAPTER-VIA which are permitted by your DDO.
- 10. Tax Relief:- If you are claiming tax relief on the Past FYs Arrears, then Select "Yes" and fill in the appeared Orange Cells with reference to ITR1/RevisedITR1 of past FYs and edit the appeared Blue Cells with reference to Arrear-Split-Statement as mentioned in Step-1. If you are not claiming, then Select "No" and edit all the following cells as 0. Note :- Please make sure that your DDO permits tax relief before claiming. If your DDO do not permit it then you may have to claim it while filing ITR.
- 11. Finally, take A4 prints of - Form-12BB,Annexure-I, Annexure-II, Annexure-III-RentReceipt (if claiming HRA), Annexure-IV (if claiming Loss from House Property) and Tax-Relief-Statements (if claiming). Sign on the sheets whereever necessary. Also attach the self attested copies of - PAN of self, Receipts/Evidences/Declaration of Deductions under Chapter VIA, Bank Certificates of Home Loan Principal & Interest separately (if claiming), PAN of house owner (if annual rent > Rs.1L) & previous ITR's (if claiming tax relief) etc. Bunch the documents together and submit to the office.
- 12. The DDO has to disburse the TDS amounts to ITD within stipulated dates and file TDS returns within stipulated dates and issue the Form-16 generated from TRACES website to individual (The Form-16 pg1 and pg2 generated with this Excel-Program are temporary and not valid as per ITD guidelines).
- 13. Every employee has to file ITR after receiving Form-16 and before the deadline notified by CBDT (tentatively 31st Jul 2020).
- The developer of this program does not hold any responsibility for errors that may arise. The responsibility of correctness is solely held with the Assessee(Employee) and the concerned Head of the Institution / DDO. Hence, it is advised to verify the Generated Statements by the individual and the Head of the Institution / DDO before submission.
- CH VENKAT RAMANA MURTY, PGT-MATHEMATICS, APMS-L.KOTA-VZM. Mobile – 9247248544 , 9492928188 . Email: chvrmy@gmail.com
Last Year Softwares:
