Karnataka State Government Employees Tax Calculator

Introduction

Income tax return statement for the Financial year 2018-19 [Assessement year 2019-20]
Income tax calculation in excel sheet is prepared and designed for THE KARNATAKA STATE GOVERNMENT EMPLOYEES ONLY

Download :

File info : "IT_AY_2019-20.xls" created on 15-01-2019.
"IT_AY_2019-20.xls" modified on 15-01-2019

Instructions

First download the Excel sheet and unzip "file.zip".
The password for the file is "DCEPA" (in capital letters).
If you want the previous year tax calculator visit "LINK".

How to calculate tax?

DO NOT CUT,COPY OR PASTE
The salary particulars in the statement is prepared as per HRMS salary bill
Please fill "BLUE" coloured cells only. The other cells are blocked.
If you have any other Income like Family pension, Rental Income, FD, RD etc. go through from cell address F74
In the first sheet you can get approximate tax calculation
In the second sheet you can get Form No.16A and Form No.16B
In the First sheet fill your Name, Designation, PAN. and by clicking Down Arrow you can select Employee NPS or Non NPS, Tax payer category i.e. below 60 years or between 60 to 80 years, Pay scale "STATE" OR "UGC", Group "A, B, C or D", City "A, B or C" and PH, Single child etc.
In Form 16A BLUE coloured cells are provided to fill Name and address of the employer, PAN of the Deductor and TAN of the Deductor.

Requirements

*KARNATAKA STATE GOVERNMENT EMPLOYEES ONLY
*This is for Resident "Individual" tax payer only

Previous Years

Author

Created by P.Purushotham, Department of Collegiate Education
E-mail : sppurushotham65@gmail.com

The creator of this software is not a Tax consultant
This file can be used to calculate the approximate tax payable by a salaried person
The creator will not responsible for any deficiency for the tax computed by this sheet.