10 salary register
TRANSCRIPT
-
8/13/2019 10 Salary Register
1/15
Co. Name
Salary Tds Calculation for F.Y. 2009-10
Sr
No
NAME OF
EMPLOYEEApr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09
1 Name of Employee 125,011 122,480 124,049 125,069 124,651 114,193 160,483
2 Name of Employee 114,562 149,220 90,000 135,180 125,266 92,137 144,932
3 Name of Employee 74,924 83,800 - 82,929 83,368 100,610 91,996
4 Name of Employee 55,610 40,200 30,800 50,880 57,249 30,800 57,092
5 Name of Employee 39,886 30,640 25,000 35,040 32,837 28,798 39,085
6 Name of Employee 23,300 35,520 32,020 37,595 24,573 23,917 38,559
7 Name of Employee 25,968 27,722 23,300 23,300 29,663 27,129 27,717
8 Name of Employee 34,482 19,570 31,078 22,447 32,325 22,898 31,777
9 Name of Employee 25,000 38,630 27,875 35,996 26,959 33,546 25,470
10 Name of Employee 25,000 34,400 39,852 29,781 25,000 25,000 34,390
11 Name of Employee - - - 14,000 20,000 14,000 23,000
12 Name of Employee - - - - - - 11,650
-
8/13/2019 10 Salary Register
2/15
Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 TotalTds
Deducted.P Tax
138,860 134838 119,900 135,000 135,000 1,559,534 316,197 2,500
140,112 113062 127,309 127,000 127,000 1,485,780 315,601 2,500
78,340 78978 79,970 79,000 79,000 912,915 134,403 2,300
- 58754 39,091 40,000 40,000 500,476 32,334 2,300
31,032 25000 33,291 33,000 33,000 386,609 22,606 2,500
32,348 41470 26,294 35,000 35,000 385,596 18,019 2,500
28,081 23300 27,014 27,000 27,000 317,194 12,270 2,500
29,772 24691 24,167 29,000 29,000 331,207 17,511 2,500
38,920 25000 33,291 33,000 33,000 376,687 16,791 2,500
33,816 38977 31,218 35,000 35,000 387,434 19,605 2,500
23,300 23000 23,300 23,300 23,300 187,200 5,186 1,900
13,150 13000 10,450 13,000 13,000 74,250 1,267 1,300
-
8/13/2019 10 Salary Register
3/15
Ded.
U/ s 80C
Ded.
U/ s 80D
100,000 -
- -
87,096 -
100,000 -
- -
29,720 -
70,000 -
33,200 -
- -
- -
- -
- -
-
8/13/2019 10 Salary Register
4/15
Individual-Male
1 Gross Salary Recd 74,250
2 Less.: Profession Tax 1,300
3 Less.: Deduction U/s 80 C -
4 Less.: Deduction U/s 80 D -
72,950.00
1 Basic Tax due 0.00
2 Education cess @ 2% 0.00
3 Secondary & Higher Edu. Cess @ 1 0.00
Total Tax Liability 0.00
4 Less.: Tds Already Deducted 1,267.005 Balance Tax Payable -1,267.00
6 Balance Tds Payable 0.00
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
5/15
Individual-Male
1 Gross Salary Recd 187,200
2 Less.: Profession Tax 1,900
3 Less.: Deduction U/s 80 C -
4 Less.: Deduction U/s 80 D -
185,300.00
1 Basic Tax due 2,530
2 Education cess @ 2% 51
3 Secondary & Higher Edu. Cess @ 1 25
Total Tax Liability 2,606
4 Less.: Tds Already Deducted 5,1865 Balance Tax Payable -2,580
6 Balance Tds Payable 0.00
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
6/15
Individual-Male
1 Gross Salary Recd 387,434
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C -
4 Less.: Deduction U/s 80 D -
384,934.00
1 Basic Tax due 30,987
2 Education cess @ 2% 620
3 Secondary & Higher Edu. Cess @ 1 310
Total Tax Liability 31,916
4 Less.: Tds Already Deducted 19,6055 Balance Tax Payable 12,311
6 Balance Tds Payable 12,311
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
7/15
Individual-Male
1 Gross Salary Recd 376,687
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C -
4 Less.: Deduction U/s 80 D -
374,187.00
1 Basic Tax due 28,837
2 Education cess @ 2% 577
3 Secondary & Higher Edu. Cess @ 1 288
Total Tax Liability 29,703
4 Less.: Tds Already Deducted 16,7915 Balance Tax Payable 12,912
6 Balance Tds Payable 12,912
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
8/15
Individual-Male
1 Gross Salary Recd 331,207
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C 33,200
4 Less.: Deduction U/s 80 D -
295,507.00
1 Basic Tax due 13,551
2 Education cess @ 2% 271
3 Secondary & Higher Edu. Cess @ 1 136
Total Tax Liability 13,957
4 Less.: Tds Already Deducted 17,5115 Balance Tax Payable -3,554
6 Balance Tds Payable -3,554
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
9/15
Individual-Male
1 Gross Salary Recd 317,194
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C 70,000
4 Less.: Deduction U/s 80 D -
244,694.00
1 Basic Tax due 8,469
2 Education cess @ 2% 169
3 Secondary & Higher Edu. Cess @ 1 85
Total Tax Liability 8,723
4 Less.: Tds Already Deducted 12,2705 Balance Tax Payable -3,547
6 Balance Tds Payable -3,547
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
10/15
Individual- Female
1 Gross Salary Recd 385,596
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C 29,720
4 Less.: Deduction U/s 80 D -
353,376.00
1 Basic Tax due 21,675
2 Education cess @ 2% 434
3 Secondary & Higher Edu. Cess @ 1 217
Total Tax Liability 22,325
4 Less.: Tds Already Deducted 18,0195 Balance Tax Payable 4,306
6 Balance Tds Payable 4,306
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
11/15
Individual-Male
1 Gross Salary Recd 386,609
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C -
4 Less.: Deduction U/s 80 D -
384,109
1 Basic Tax due 30,822
2 Education cess @ 2% 616
3 Secondary & Higher Edu. Cess @ 1 308
Total Tax Liability 31,746
4 Less.: Tds Already Deducted 22,6065 Balance Tax Payable 9,140
6 Balance Tds Payable 9,140
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
12/15
Individual-Male
1 Gross Salary Recd 500,476
2 Less.: Profession Tax 2,300
3 Less.: Int on borrowed capital U/s 24(b) 141,488
4 Less.: Deduction U/s 80 C 100,000
5 Less.: Deduction U/s 80 D -
256,688.00
1 Basic Tax due 9,669
2 Education cess @ 2% 193
3 Secondary & Higher Edu. Cess @ 1 97
Total Tax Liability 9,9594 Less.: Tds Already Deducted 32,334
5 Balance Tax Payable -22,375
6 Balance Tds Payable -22,375
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
13/15
Individual-Male
1 Gross Salary Recd 912,915
2 Less.: Profession Tax 2,300
3 Less.: Int on borrowed capital U/s 24(b) 34,338
3 Less.: Donation Paid U/s 80 G 11,000
4 Less.: Deduction U/s 80 C 87,096
5 Less.: Deduction U/s 80 D -
778,181.00
1 Basic Tax due 137,454
2 Education cess @ 2% 2,749
3 Secondary & Higher Edu. Cess @ 1 1,375Total Tax Liability 141,578
4 Less.: Tds Already Deducted 134,403
5 Balance Tax Payable 7,175
6 Balance Tds Payable 7,175
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
14/15
Individual-Male
1 Gross Salary Recd 1,485,780
2 Less.: Profession Tax 2,500
3 Less.: Deduction U/s 80 C -
4 Less.: Deduction U/s 80 D -
1,483,280.00
1 Basic Tax due 348,984
2 Education cess @ 2% 6,980
3 Secondary & Higher Edu. Cess @ 1 3,490
Total Tax Liability 359,454
4 Less.: Tds Already Deducted 315,6015 Balance Tax Payable 43,853
6 Balance Tds Payable 43,853
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .
-
8/13/2019 10 Salary Register
15/15
Individual-Male
1 Gross Salary Recd 1559534
2 Less.: Profession Tax 2500
3 Less.: Deduction U/s 80 C 100000
4 Less.: Deduction U/s 80 D 10000
1,447,034
1 Basic Tax due 338,110
2 Education cess @ 2% 6,762
3 Secondary & Higher Edu. Cess @ 1 3,381
Total Tax Liability 348,254
4 Less.: Tds Already Deducted 316,197
5 Balance Tax Payable 32,057
6 Balance Tds Payable 32,057
Calculation of Tax On Income From Salary
Taxable salary
CO. NAMETDS CALCULATION F.Y. 2009-10
NAME OF EMPLOYEE .