Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
Sal_Tax_09-10
by
navtejpvs
228 views
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
SALARY & INCOME TAX - F.Y. 2009-10
NAME:
MALE
Below 65 Years
USER TO PUT NECESSARY DATA IN YELLOW CELLS ONLY
IN CASE OF PROMOTION, USER TO PUT REVISED BAND PAY & GRADE PAY IN RESPECTIVE CELLS.
For Transportation Allowance -- 1-For A1 /A Class cities , 2- For other cities.
1
For HRA - Are you allotted a Rly accommodation- If YES-0,If NO- 1 for X(A1)class, 2 for Y(A,B1,B2) class & 3 for Z(C/other) class cities,
2
SEX - FOR INDIVIDUAL : 1 For MALE, 2 For FEMALE
1
Are you a Teaching Faculty- REGULAR
If NO 0 , If YES - 1 for Centralised Institute, 2 for other Institute
2
Are you a Medical Officer
If NO - 0 , If YES - 1
1
SALARY
MAR'09
APR'09
MAY'09
JUN'09
JUL'09
AUG'09
SEP'09
OCT'09
NOV'09
DEC'09
JAN'10
FEB'10
TOTAL
Band Pay
0
0
0
0
0
0
0
0
0
0
0
0
0
Grade Pay
0
0
0
0
0
0
0
0
0
0
0
0
0
Personal Pay.
0
0
0
0
0
0
0
0
0
0
0
0
0
D.A.(%)
0.22
0.22
0.22
0.22
0.22
0.22
0.22
0.27
0.27
0.27
0.27
0.27
D.A.(amount)
0
0
0
0
0
0
0
0
0
0
0
0
0
HRA
0
0
0
0
0
0
0
0
0
0
0
0
0
Children Edu Allow
0
0
0
0
0
0
0
0
0
0
0
0
0
Arrears / Bonus
0
0
0
0
0
0
0
0
0
0
0
0
0
Non Practice All
0
0
0
0
0
0
0
0
0
0
0
0
0
Running Allowance
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
T'BLE INCOME
0
0
0
0
0
0
0
0
0
0
0
0
0
Transport.Allowance
0
0
0
0
0
0
0
0
0
0
0
0
0
T.A./D.A.
0
0
0
0
0
0
0
0
0
0
0
0
0
Teaching Allowance
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NON T'BLE INCOME.
0
0
0
0
0
0
0
0
0
0
0
0
0
GROSS PAY
0
0
0
0
0
0
0
0
0
0
0
0
0
DEDUCTIONS
PF
0
0
0
0
0
0
0
0
0
0
0
0
0
VPF
0
0
0
0
0
0
0
0
0
0
0
0
0
CGEIS
0
0
0
0
0
0
0
0
0
0
0
0
0
INCOME TAX
0
0
0
0
0
0
0
0
0
0
0
0
0
Profession Tax.
0
0
0
0
0
0
0
0
0
0
0
0
0
Welfare
0
0
0
0
0
0
0
0
0
0
0
0
0
HBA-PRINCIPAL
0
0
0
0
0
0
0
0
0
0
0
0
0
HBA-INTEREST
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOT DED.
0
0
0
0
0
0
0
0
0
0
0
0
0
NET PAY
0
0
0
0
0
0
0
0
0
0
0
0
0
INCOME
ADMISSIBLE DEDUCTIONS
TAXABLE INCOME
0
SCH-VI
Amount
Eligible Amt
SCH-VI
AMOUNT
Taxable Tran. All
0
SEC 80D
0
0
Sec 80C - PPF
0
OTHER INCOME
0
SEC 80DD
0
0
LIC
0
GROS TAX INCOME
0
SEC 80DDB
0
0
TUITION FEES
0
Ded80C-From Salary
0
SEC 80E
0
0
NSS
0
Ded80C-Other
0
SEC 80G
0
0
HBA(Other than SALARY)
0
Ded-Admissible 80C
0
SEC 80 GG
0
0
Equity Linked Saving Sch.
0
Profession Tax.
0
SEC 80 GGA
0
0
Bank FD
0
HBA Int-other Loan
0
SEC 80GGC
0
0
Post Office Term Deposit
0
HBA Int.on Deptt.Loan
0
SEC 80 U
0
0
UTI/ULIP/PLI
0
Ded-Chapter VI
0
0
0
0
NET TAX.INCOME
0
0
0
SEC 80CCC
0
INCOME TAX
0
0
SEC 80CCD
0
UP TO Rs 300000
0
TOTAL
0
0
TOTAL
0
Rs 300001-Rs 5L
0
Above Rs 500000
0
HBA LOAN INTEREST
OTHER INCOME
TOTAL TAX
0
LOAN from Deptt.
0
0
INTEREST
0
EDU. CESS-3%
0
LOAN from elsewhere
0
0
OTHER INCOME
0
TAX PAYABLE
0
0
TAX DEDUCTED
0
0
BALANCE TAX
0
0
PF
TOTAL
0
PF
YEAR
Bal'09
MAR'09
APR'09
MAY'09
JUN'09
JUL'09
AUG'09
SEP'09
OCT'09
NOV'09
DEC'09
JAN'10
FEB'10
Sub'09-10
INT. 09-10
Bal 2-10
2009-10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
PPF
PPF
YEAR
Bal'09
APR'09
MAY'09
JUN'09
JUL'09
AUG'09
SEP'09
OCT'09
NOV'09
DEC'09
JAN'10
FEB'10
MAR'10
Sub'09-10
INT. 09-10
Bal 3-10
2009-10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Developed by : Lalit Khandelwal e-mail ID: lalit_kh@rediffmil.com
2009_10
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More
