0% found this document useful (0 votes)
50 views9 pages

Salary and Tax Calculation Guide

The document appears to be a salary calculation sheet for an individual named s.p.nayak. It includes details of their basic salary, deductions, allowances, taxes, and net salary on a month-by-month basis. It also includes annual investment and income details. The summary provides tax calculations and shows a total annual gross income of Rs. 3,51,702.56, total tax deduction of Rs. 30,005.08, and allows the user to update income tax rules and limits.

Uploaded by

pratikdey
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
50 views9 pages

Salary and Tax Calculation Guide

The document appears to be a salary calculation sheet for an individual named s.p.nayak. It includes details of their basic salary, deductions, allowances, taxes, and net salary on a month-by-month basis. It also includes annual investment and income details. The summary provides tax calculations and shows a total annual gross income of Rs. 3,51,702.56, total tax deduction of Rs. 30,005.08, and allows the user to update income tax rules and limits.

Uploaded by

pratikdey
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 9

CALCULATE

NAME

SMT

SELECT CADRE
BASIC
MONTH OF INCREMENT

YOUR
INCOME
s.p.nayak

TAX
0.18

DA %

4
15305

APRIL DA SLABS
DA RISE IN MAY

372

NO
Details of APRIL salary
540
Fixed Personal Allow.
Graduation Allow
0
SPETIAL ALLOW
0
ARR OF BASIC
ENTER MONTHWISE
ARR OF DA
ENTER MONTHWISE

19
391
DA RISE IN AUG
0
391
0
391
DA RISE IN NOV
0
391
DA RISE IN FEB
YLY INVESTMENTS / EARNINGS
Insurance Prem ORD
17513
PPF
18000
SCHOOL FEES
0
HOUSING PRINCIPLE
8334
HOUSING INTEREST
11094

ARR OF HRA

NSC

TAX SAVER SIP


CASH AWARD

0
0

CITY CLASS
ASSTT /PROG / CASHIER

OTHER

5
B
1

ENTER MONTHWISE
ENTER MONTHWISE
Deduction of APRIL Salary

1000
232.9
1619
48.75
195
81.25
200
125

Add. PF
Insurance Prem
I E H S + OYHS
G S L I Term
G S L I Saving
GTIS-'97 Risk Prm
PROF TAX
GRP INS SCH. IV
Strike Basic/gr all
Strike DA

ENTER MONTHWISE
ENTER MONTHWISE

2000
0

Mediclaim Prm
HEALTH + PREM
Income Tax

ENTER MONTHWISE

CLICK HERE TO CHANGE I.T. SLABS

DONATIONS
HSG OR ANY OTHER PERK
PILLI
PL ENCASHMENT

0
1500
9998
0

JIVAN AADHAR PREM 80DD


HFL LOAN INT
Jeevan suraksha prem
Infrastructure Bonds

5000
0
0
18000

ENTER

WHITE

YOUR

DATA IN

CELLS ONLY

CLICL HERE TO ENTER OTHER SALARY DETAILS

TAX
TAX CALCULATION
GROSS SALARY
Other Income
Medical Benefit

Total Income
Prof.Tax
Transport Allow
Wage Cut

T.after D'ct Rebate


HB Loan (Int)
HFL LOAN INT
T.after HB L Rebate
Total AFTER INT REBATE
80C
Infrastructure Bonds
T. after 80C Rebate
80D
T.after 80D Rebate
TOTAL 80DD Rebate
TOTAL AFTER 80DD

TAXABLE INCOME
TAX RANGE

TOTAL TAX
SURCHARGE
TAX deducted frm salary

ACTUAL TAX DUE

351702.56
11498
2000
361200.56
2500
900
0
357800.56
11094
0
11094
346706.56
83655.8
18000
245050.76
15000
230050.76
5000
225050.76

225050.76
10.00%
3505.08
0
500

3005.08

seema.nayak@licindia.com

24000
0
15000

50000
75000

Salary Details

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

JAN

Basic

15305.00 15845.00 15845.00 15845.00 15845.00 15845.00 15845.00 15845.00 15845.00 15845.00

D.A.

10248.23 10609.81 10609.81 10609.81 10609.81 10609.81 10609.81 10609.81 10609.81 10609.81

HRA

1267.60

1310.80

1310.80

1310.80

1310.80

1310.80

1310.80

1310.80

1310.80

1310.80

CCA

340.00

340.00

340.00

340.00

340.00

340.00

340.00

340.00

340.00

340.00

Transport Allow

75.00

75.00

75.00

75.00

75.00

75.00

75.00

75.00

75.00

75.00

Functional Allow

500.00

500.00

500.00

500.00

500.00

500.00

500.00

500.00

500.00

500.00

Fixed P Allow

540.00

540.00

540.00

540.00

540.00

540.00

540.00

540.00

540.00

540.00

Graduation Allow

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

SPETIAL ALLOW

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

ARR OF BASIC

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

ARR OF DA

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

ARR OF HRA

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

OTHER

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Medical Benefit

0.00

2000.00

SRGROSS SALARY

28275.83 29220.61 29220.61 29220.61 29220.61 29220.61 29220.61 29220.61 29220.61 31220.61

PF

1585.00

1639.00

1639.00

1639.00

1639.00

1639.00

1639.00

1639.00

1639.00

1639.00

Add. PF

1000.00

1000.00

1000.00

1000.00

1000.00

1000.00

1000.00

1000.00

1000.00

1000.00

Insurance Prem

232.90

232.90

232.90

232.90

232.90

232.90

232.90

232.90

232.90

232.90

I E H S + OYHS

1619.00

1619.00

1619.00

1619.00

1619.00

1619.00

1619.00

1619.00

1619.00

1619.00

G S L I Term
G S L I Saving
GTIS-'97 Risk Prm

48.75

48.75

48.75

48.75

48.75

48.75

48.75

48.75

48.75

48.75

195.00

195.00

195.00

195.00

195.00

195.00

195.00

195.00

195.00

195.00

81.25

81.25

81.25

81.25

81.25

81.25

81.25

81.25

81.25

81.25

PROF TAX

200.00

200.00

200.00

200.00

200.00

200.00

200.00

200.00

200.00

200.00

GRP INS SCH. IV

125.00

125.00

125.00

125.00

125.00

125.00

125.00

125.00

125.00

125.00

CO-OP Society

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Festival Adv

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Computer Adv

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Computer Adv(Int)

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

MC/CAR Adv

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

MC/CAR Adv(Int)

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

PF Loan

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

PF Loan(Int)

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

L W Fund

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2000.00

2000.00

2000.00

2000.00

2000.00

2000.00

2000.00

2000.00

2000.00

2000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Strike Basic/gr all

0.00

Strike DA

0.00

Strike HRA

Mediclaim Prm

HEALTH + PREM
L & License Fee
Income Tax

200.00

300.00

Water Charges

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Other Deduction

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

SRTOT.DEDUCTION

7286.90

7440.90

7140.90

7140.90

7140.90

7140.90

7140.90

7140.90

7140.90

7140.90

NET SALARY

20988.93 21779.71 22079.71 22079.71 22079.71 22079.71 22079.71 22079.71 22079.71 24079.71

FEB

MAR

15845.00 15845.00
10609.81 10609.81
1310.80

1310.80

340.00

340.00

75.00

75.00

500.00

500.00

540.00

540.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

29220.61 29220.61
1639.00

1639.00

1000.00

1000.00

232.90

232.90

1619.00

1619.00

48.75

48.75

195.00

195.00

81.25

81.25

200.00

200.00

125.00

125.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2000.00

2000.00

GRO0SS
189600.00
126956.16
15686.40
4080.00
900.00
6000.00
6480.00
0.00
0.00
2000.00
0.00
0.00
0.00
0.00
0.00
351702.56
19614.00
12000.00
2794.80
19428.00
585.00
2340.00
975.00
2400.00
1500.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
24000.00

BACK TO
NO SHEET1
ENTER MONTHWISE
ENTER MONTHWISE
ENTER MONTHWISE
ENTER MONTHWISE

0.00

BACK TO
0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

7140.90

7140.90

0.00 SHEET1
0.00
500.00
0.00
0.00

0.00
86136.80

22079.71 22079.71

265565.76

Please Change Figure according to Income Tax Rules for the Assessment Y

Enter Year of Calculation

2010-2011
190000

Enter Income Tax Limit for (Female Category)

160000

Enter Income Tax Limit for (Male Category)


Enter Income Tax Range for (Female Category)
Enter Income Tax Range for (Male Category)
Enter Maximum Limit of 80C Rebate

Up
500001
800001
Up
500001
800001
Male
Category

Enter Maximum Limit of Housing Loan Interest


Enter Maximum Limit of 80D
Enter the PC of Education Cess
Enter the PC of Surcharge 1000000
20000
Infrastructure Bonds
Limit of 80DD(Jeevan Aadhar)
Lower

150000
150000

0%

BACK TO

for the Assessment Year

SHEET 1

2010-2011
190000
160000
To
To
&
To
To
&

500000
800000
above
500000
800000
above

100000

Female
Category

10%
20%
30%
10%
20%
30%
100000

150000
150000

0%
&

Above

10%

50000

Upper

75000

You might also like