IT Software

	B	C	D	E	G	I	J	L	M	N	O	P	R	S	T	U	V	X	Y	Z	AA
1
2	INCOMETAX 2023-24 (A.P.) TRIAL VERSION 1.4 (Use By : Only MS EXCEL)				SAVINGS u/s 80C		Rs. ↓	MONTH YEAR	ADV. TAX	P.H. Allow	Other Allow	Other Ded's		OLD REGIME (AGE=32)				NEW REGIME (AGE=32)

3	MARCH-2024 BP (without A.G.I.)		49790		LIC PREMIUMS (BY HAND)		150,000	Mar/2023						GROSS INCOME		→	7,79,990	GROSS INCOME		→	7,79,990
4	MARCH-2024 BP (without A.G.I.)		49790		POSTAL LIFE INSURANCE			Apr/2023						ELIGIBLE DEDUCTIONS		→	6,57,729	ELIGIBLE DEDUCTIONS		→	50,000
5	SELECT PF TYPE (G.P.F. or C.P.S.)		CPS		SUKANYA SAMRIDHI YOJANA			May/2023						NET TAXABLE INCOME		→	1,22,260	NET TAXABLE INCOME		→	7,29,990
6	SELECT PF TYPE (G.P.F. or C.P.S.)		CPS		SBI LIFE INSURANCE			Jun/2023						SLABS	INCOME	%	TAX	SLABS	INCOME	%	TAX
7	Feb Increment వాళ్ళు FEB-2024 Select చెయ్యండి.				PUBLIC PROVIDENT FUND			Jul/2023						SLAB 1	250,000	00%	-	SLAB 1	300,000	00%	-
8	A.G.I. @ 2023-2024		December/2023		TUTION FEE FOR CHILDREN			Aug/2023						SLAB 2	-	05%	-	SLAB 2	300,000	05%	15,000
9	A.A.S. Month & Date		N.A.	N.A.	HOME LOAN PRINCIPLE AMOUNT			Sep/2023						SLAB 3	-	20%	-	SLAB 3	129,990	10%	12,999
10	Surrender Leave : 2023-24		N.A.	30	STAMP DUTY & REGISTRATION			Oct/2023						SLAB 4	-	30%	-	SLAB 4	-	15%	-
11	SUGGESTED RENT ➠		(Maximum)	10900	HDFC LIFE INSURANCE			Nov/2023						SLAB 5	-	-	-	SLAB 5	-	20%	-
12	ENTER Ur RENT HERE		Own House = 0	8300	OTHERS_________________			Dec/2023						SLAB 6	-	-	-	SLAB 6	-	30%	-
13	NUMBER OF MONTHS		(Rent Paid)	12	CPS SELF CONTRIBUTION u/s 80CCD 1B			Jan/2024						TOTAL	250,000	→	-	TOTAL	729,990	→	27,999
14	ENTER Ur D.O.B. HERE		DD-MM-YYYY	12/Jul/1991	CPS DEDUCTION SPLIT :: u/s 80CCD 1B		YES	Feb/2024						LESS : Tax Rebate (87A)			-	LESS : Tax Rebate (87A)			-
15	YOUR AGE : 32 YEARS - 8 MONTH(s) - 20 DAY(s)				CPS DEDUCTION SPLIT :: u/s 80CCD 1B		YES							TAX After Tax Rebate			-	TAX After Tax Rebate			27,999
16	YOU ARE A GENERAL CITIZEN							80C SAVINGS TOTAL			150,000			ADD : SURCHARGE			-	ADD : SURCHARGE			-
17	AAS BP	AAS DA	AAS HRA	AAS CPS	OLD REGIME TAX ➠	-	OLD	YOU CAN INCREASE →			-			ADD : CESS		04%	-	ADD : CESS		04%	1,120
18	0	0	0	0	NEW REGIME TAX ➠	29,119	Regime is the BEST	80CCD SAVINGS TOTAL			50,000			TOTAL TAX LIABILITY		→	-	TOTAL TAX LIABILITY		→	29,119
19					SELECT Ur OPTION ➠	AUTO	Regime is the BEST	YOU CAN INCREASE →			-
20
21	AAS Arrears Automated Values లలో CHANGES ఉంటే వాటి కింద మీ Values Enter చెయ్యండి				➠ Would you like to add Employer's Contribution towards NPS to your GROSS		NO	YOU HAVE REACHED the Savings limit u/s 80C					మీ Tax OLD REGIME లో Prepare చెయ్యబడుతుంది. Savings & Exemptions అనుమతించబడుతాయి.					ఈ FILE ను MS EXCEL లో మాత్రమే USE చెయ్యాలి. WPS/Google Sheets లలో USE చెయ్యకూడదు.
22
23	Allowances and Deductions	AS ON MARCH 2023	IF CHANGED SELECT ↓MONTH↓	ENTER CHANGED DEDUCTION	INCOME FROM OTHER SOURCES and HOUSING & EDUCATIONAL LOANs			EMPLOYEE DETAILS					DDO (EMPLOYER) DETAILS					Owner Details for RENT RECEIPT
24	Allowances and Deductions	AS ON MARCH 2023	IF CHANGED SELECT ↓MONTH↓	ENTER CHANGED DEDUCTION	INCOME FROM OTHER SOURCES and HOUSING & EDUCATIONAL LOANs			EMPLOYEE DETAILS					DDO (EMPLOYER) DETAILS					Owner Details for RENT RECEIPT
25	HMA+FPA		Aug/2023	150	CHILD Tution FEE CONCESSION (as income)			Sri.	PERUMALLA RAMANJANEYULU				Sri.		G.SOMA SEKHAR			Sri.
26	C.C.A.		NO CHANGE		Medical REIMBURSEMENT Claims (as income)			Designation	SECONDARY GRADE TEACHER				Designation		MANDAL EDUCATIONAL OFFICER			House No.
27	H.C.A.		NO CHANGE		INCOME FROM OTHER SOURCES			TREASURY ID	1234567				DDO TAN		HYDM08185C			STREET
28	UNIFORM		NO CHANGE		INCOME FROM FAMILY PENSION			EMP PAN	MYPAN1234S				DDO PAN					TOWN
29	DHOBI		NO CHANGE		INCOME/Loss FROM HOUSE PROPERTY			EMP.OFFICE	M.P.U.P.SCHOOL				DDO Office		MANDAL RESOURCE CENTER			MANDAL
30	GPF/ZPPF	5000	NO CHANGE		Deduction for DISABLED (SELF) u/s 80U			VILLAGE	RAHIMANPURAM				VILLAGE		BETHAMCHERLA			DISTRICT
31	APGLI	7000	NO CHANGE		MEDICAL INSURANCE PREMIUM (PERSONAL)			MANDAL	ALUR				MANDAL		BETHAMCHERLA			Owner PAN
32	GIS	30	NO CHANGE		Interest on Housing Loan Advance U/s 24B			DISTRICT	NANDYALA				DISTRICT		NANDYALA			YOU SHOULD SUBMIT RENT RECEIPT WITHOUT PAN OF HOUSE OWNER
33	P.TAX	200	NO CHANGE		Interest on Educational Loan U/s 80E			APGLI No.	9963535304				This is useful only to A.P. Govt. Employees.
34	E.H.F.(E.H.S)	225	NO CHANGE		DONATIONS OF CHARITABLE TRUST u/s 80G			PRAN No.	9963535304				This is useful only to A.P. Govt. Employees.
35	S.S.S.(L.I.C.)		NO CHANGE
36	E.W.F. ►►	20	S.W.F. ►►	50	A.G.I. @ 2020	December/2021		ఇది ఆంధ్రప్రదేశ్ ప్రభుత్వ ఉద్యోగులకు 2023-24 ఆర్ధిక సంవత్సరానికి సంబంధించిన ఆదాయపు పన్నును లెక్కించుకోవడానికి ఉపయోగపడుతుంది. ఏవైన ERRORS ఉంటే Whatsapp లో నాకు NOTICE చెయ్యగలరు.					DA, HRA, INC, PROMOTION ARREARS ను ANNEXURE I లో MANUAL గా నమోదు చెయ్యండి. PERUMAL : 99 63 53 53 04					PROMOTION ; HALF PAY LEAVE మరియు LOSS OF PAY ఉపయోగించుకున్న వారికి ప్రస్తుతానికి ఇందులో అవకాశం లేదు. (త్వరలో వీటిని కూడా ADD చేస్తాం)
37	H.R.A.	10.00%	NO CHANGE		A.G.I. @ 2021	December/2022
38	Addl.HRA		NO CHANGE		Surrender Leave 1 : 2021	N.A.	00
39	H.R.A. Changed Date			01	Surrender Leave 2 : 2022	N.A.	00
40	Additional H.R.A. Changed Date			01	DA 1 Changed Month	Jul/2023							మీరు MS OFFICE 2016 కన్నా ముందు VERSION ను ఉపయోగిస్తుంటే UPDATE చేయించుకోండి.
41	Conveyance or Reader Allowance				DA 2 Changed Month	Nov/2023
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
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