Salary Sheet Calculation

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 8

COMPANY NAME

SALARY SHEET FOR THE MONTH OF JUNE 2016


LOCATION:-BANGALORE
FIXED SALARY EARNED SALARY DEDUCTIONS
ACTUAL GROSS GROSS TOTAL
SL.N EMP W/ PAID CON. SPEC. CON. SPEC. PROF
NAME ACCOUNT NO DAYS IN O CL LOP BASIC HRA FIXED BASIC HRA EARNED PF ESI ADV. DEDUC
O. NO DAYS ALL ALL ALL ALL TAX
MONTH SALARY SALARY TIONS
1 YSH001 DR. ARCHANA P 1020101001786 30 0 0.0 0.0 30.0 15000 12000 800 3750 31550 15000 12000 800 3750 31550 1800 - 200 0 2000
2 YSH004 HEMALATHA M P 1020101001787 30 0 0.0 0.0 30.0 15000 8500 800 3750 28050 15000 8500 800 3750 28050 1800 - 200 0 2000
3 YSH005 SHANKARNARAYANA H S 1020101001788 30 0 0.0 0.0 30.0 10260 4275 800 2565 17900 10260 4275 800 2565 17900 1231 - 200 0 1431
4 YSH006 NETHRAVATHI P HANDE 1020101001789 30 0 0.0 0.0 30.0 10560 5000 800 2640 19000 10560 5000 800 2640 19000 1267 - 200 0 1467
5 YSH007 MANJULA P 1020101001790 30 0 0.0 0.0 30.0 7800 3250 800 1950 13800 7800 3250 800 1950 13800 936 242 - 0 1178
6 YSH008 NAGARATHNA P 1020101001791 30 0 0.0 0.0 30.0 8910 4713 800 2228 16651 8910 4713 800 2228 16651 1069 - 200 0 1269
7 YSH009 RAGHAVENDRA M 1020101001792 30 0 0.0 0.0 30.0 7352 1800 298 1838 11288 7352 1800 298 1838 11288 882 198 - 0 1080
8 YSH010 SADANANDA 1020101001793 30 0 0.0 0.0 30.0 7920 4000 800 1980 14700 7920 4000 800 1980 14700 950 258 - 0 1208
9 YSH015 BINIMOL D 1020101001794 30 0 0.0 0.0 30.0 14910 7213 800 3728 26651 14910 7213 800 3728 26651 1789 - 200 0 1989
10 YSH020 CHANDRAKALA B S 1020101001795 30 0 0.0 0.0 30.0 7920 3800 800 1980 14500 7920 3800 800 1980 14500 950 254 - 0 1204
11 YSH025 TULASI HEGDE 1020101001796 30 0 0.0 0.0 30.0 7920 4500 800 1980 15200 7920 4500 800 1980 15200 950 - 200 0 1150
12 YSH026 BHARATHI D 1020101001797 30 0 0.0 0.0 30.0 7352 3500 800 1838 13490 7352 3500 800 1838 13490 882 237 - 0 1119
13 YSH027 SANDHYAMOL M K 1020101001798 30 0 0.0 0.0 30.0 8700 5625 800 2175 17300 8700 5625 800 2175 17300 1044 - 200 0 1244
14 YSH031 PRIYADARSHINI 1020101001799 30 0 0.0 0.0 30.0 13200 6500 800 3300 23800 13200 6500 800 3300 23800 1584 - 200 0 1784
15 YSH033 SUNIL H C 1020101001800 30 0 0.0 0.0 30.0 10710 5463 800 2678 19651 10710 5463 800 2678 19651 1285 - 200 0 1485
16 YSH034 JAYALAXMI B AKKI 1020101001801 30 0 0.0 0.0 30.0 10890 5538 800 2723 19951 10890 5538 800 2723 19951 1307 - 200 0 1507
17 YSH036 ASHA 1020101001802 30 0 0.0 0.0 30.0 7352 2500 800 1838 12490 7352 2500 800 1838 12490 882 219 - 0 1101
18 YSH037 SUNDARAMMA 1020101001803 30 0 0.0 0.0 30.0 7352 598 0 1838 9788 7352 598 0 1838 9788 882 172 - 0 1054
19 YSH040 SARASWATHI 1020101001804 30 0 0.0 0.0 30.0 7352 600 348 1838 10138 7352 600 348 1838 10138 882 178 - 0 1060
20 YSH041 LALITHA 1020101001805 30 0 0.0 0.0 30.0 7352 598 0 1838 9788 7352 598 0 1838 9788 882 172 - 0 1054
21 YSH042 MANJULA 1020101001806 30 0 0.0 0.0 30.0 7352 1248 0 1838 10438 7352 1248 0 1838 10438 882 183 - 0 1065
22 YSH047 NAGARAJ G 1020101001807 30 0 0.0 0.0 30.0 7352 1448 600 1838 11238 7352 1448 600 1838 11238 882 197 - 0 1079
23 YSH053 PAVITHRA V 1020101001808 30 0 0.0 0.0 30.0 7352 2500 800 1838 12490 7352 2500 800 1838 12490 882 219 - 0 1101
24 YSH057 LAKSHMI G RAIKAR 1020101001809 30 0 0.0 0.0 30.0 7352 4000 800 1838 13990 7352 4000 800 1838 13990 882 245 - 0 1127
25 YSH058 BINDU K 1020101001810 30 0 0.0 0.0 30.0 12600 5250 800 3150 21800 12600 5250 800 3150 21800 1512 - 200 0 1712
26 YSH059 JINCY K JOHN 1020101001811 30 0 0.0 0.0 30.0 7352 1648 500 1838 11338 7352 1648 500 1838 11338 882 199 - 0 1081
27 YSH063 MAMATHA G 1020101001812 30 0 0.0 0.0 30.0 7352 2500 800 1838 12490 7352 2500 800 1838 12490 882 219 - 0 1101
28 YSH074 JAYAMMA V 1020101001813 30 0 0.0 0.0 30.0 7352 598 0 1838 9788 7352 598 0 1838 9788 882 172 - 0 1054
29 YSH077 RAJINI 1020101001814 30 0 0.0 0.0 30.0 7352 3500 800 1838 13490 7352 3500 800 1838 13490 882 237 - 0 1119
30 YSH079 SHAMBHAVI J 1020101001815 30 0 0.0 0.0 30.0 7352 2000 800 1838 11990 7352 2000 800 1838 11990 882 210 - 0 1092
31 YSH081 SUBHASH C K 1020101001816 30 0 0.0 0.0 30.0 7352 3500 800 1838 13490 7352 3500 800 1838 13490 882 237 - 0 1119
32 YSH082 MINIKURIAKOSE 1020101001817 30 0 0.0 0.0 30.0 9600 5000 800 2400 17800 9600 5000 800 2400 17800 1152 - 200 0 1352
33 YSH085 NANDISHA K S 1020101001818 30 0 0.0 0.0 30.0 7352 1000 648 1838 10838 7352 1000 648 1838 10838 882 190 - 0 1072
34 YSH087 TINCY 1020101001819 30 0 0.0 0.0 30.0 7352 1000 448 1838 10638 7352 1000 448 1838 10638 882 187 - 0 1069
35 YSH090 SUGUNA SUREKHA A 1020101001820 30 0 0.0 0.0 30.0 9000 4500 800 2250 16550 9000 4500 800 2250 16550 1080 - 200 0 1280
36 YSH091 ASHA N 1020101001821 30 0 0.0 0.0 30.0 7920 4300 800 1980 15000 7920 4300 800 1980 15000 950 - - 0 950
37 YSH093 NIDHINI ABRAHAM 1020101001822 30 0 0.0 0.0 30.0 7352 1000 648 1838 10838 7352 1000 648 1838 10838 882 190 - 0 1072
38 YSH094 JAYASIMHA B H 1020101001823 30 0 0.0 0.0 30.0 9030 4563 800 2258 16651 9030 4563 800 2258 16651 1084 - 200 0 1284
39 YSH097 THOKCHOM IBETHOI CHANU 1020101001824 30 0 0.0 0.0 30.0 7352 2500 800 1838 12490 7352 2500 800 1838 12490 882 219 - 0 1101
40 YSH098 LAKSHMI DEVI S 1020101001825 30 0 0.0 0.0 30.0 7800 3750 800 1950 14300 7800 3750 800 1950 14300 936 251 - 0 1187
41 YSH099 GANGAMMA 1020101001826 30 0 0.0 0.0 30.0 7352 448 0 1838 9638 7352 448 0 1838 9638 882 169 - 0 1051
42 YSH100 DR. ANJANA 1020101001827 30 0 0.0 0.0 30.0 12000 7000 800 3000 22800 12000 7000 800 3000 22800 1440 - 200 0 1640
43 YSH102 BANASODE RAM 1020101001828 30 0 0.0 0.0 30.0 7352 248 0 1838 9438 7352 248 0 1838 9438 882 166 - 0 1048
44 YSH103 RAMESH N 1020101001829 30 0 0.0 0.0 30.0 11600 4500 800 2900 19800 11600 4500 800 2900 19800 1392 - 200 0 1592
45 YSH107 BINCY BABU 1020101001830 30 0 0.0 0.0 30.0 7352 1000 448 1838 10638 7352 1000 448 1838 10638 882 187 - 0 1069
46 YSH108 ASWATHY BHUVANENDRAN 1020101001831 30 0 0.0 0.0 30.0 7352 1000 448 1838 10638 7352 1000 448 1838 10638 882 187 - 0 1069
47 YSH110 NAGARATHNA NAIK 1020101001832 30 0 0.0 0.0 30.0 7312 2500 800 1828 12440 7312 2500 800 1828 12440 877 218 - 0 1095
FIXED SALARY EARNED SALARY DEDUCTIONS
ACTUAL GROSS GROSS TOTAL
SL.N EMP NAME ACCOUNT NO W/ CL LOP PAID BASIC HRA CON. SPEC. BASIC HRA CON. SPEC. PF ESI PROF ADV.
DAYS IN FIXED EARNED DEDUC
O. NO O DAYS ALL ALL ALL ALL TAX
MONTH SALARY SALARY TIONS
48 YSH111 A P GAYATHRI 1020101001833 30 0 0.0 0.0 30.0 8400 4500 800 2100 15800 8400 4500 800 2100 15800 1008 - 200 0 1208
49 YSH112 ZAREENA B 1020101001834 30 0 0.0 0.0 30.0 7352 148 0 1838 9338 7352 148 0 1838 9338 882 164 - 0 1046
50 YSH113 MAHALAKSHMI G 1020101001835 30 0 0.0 0.0 30.0 7352 1448 0 1838 10638 7352 1448 0 1838 10638 882 187 - 0 1069
51 YSH117 SOWMYA G 1020101001836 30 0 0.0 0.0 30.0 7352 0 0 1838 9190 7352 0 0 1838 9190 882 161 - 0 1043
52 YSH120 VANISHRI 1020101001837 30 0 0.0 0.0 30.0 7360 0 0 1840 9200 7360 0 0 1840 9200 883 161 - 0 1044
53 YSH122 JAGADISH G R 1020101001838 30 0 0.0 0.0 30.0 11400 5750 800 2850 20800 11400 5750 800 2850 20800 1368 - 200 0 1568
54 YSH123 DR. ANJU ANTONY 1020101001839 30 0 0.0 0.0 30.0 9530 4263 800 2383 16976 9530 4263 800 2383 16976 1144 - 200 0 1344
55 YSH124 DR. GOWRI SHANKAR R 1020101001840 30 0 0.0 0.0 30.0 15000 6250 800 3750 25800 15000 6250 800 3750 25800 1800 - 200 0 2000
56 YSH125 RUKMINI 1020101001841 30 0 0.0 0.0 30.0 7312 688 0 1828 9828 7312 688 0 1828 9828 877 172 - 0 1049
57 YSH126 NANDINI L 1020101001842 30 0 0.0 0.0 30.0 9030 3713 800 2258 15801 9030 3713 800 2258 15801 1084 - 200 0 1284
58 YSH127 RUKMINI S 1020101001843 30 0 0.0 0.0 30.0 7360 0 0 1840 9200 7360 0 0 1840 9200 883 161 - 0 1044
59 YSH128 VASU 1020101001844 30 0 0.0 0.0 30.0 7352 1000 448 1838 10638 7352 1000 448 1838 10638 882 187 - 0 1069
60 YSH130 MALATHI 1020101001845 30 0 0.0 0.0 30.0 7352 1648 0 1838 10838 7352 1648 0 1838 10838 882 190 - 0 1072
61 YSH131 DEEPA H M 1020101001846 30 0 0.0 0.0 30.0 7352 3500 800 1838 13490 7352 3500 800 1838 13490 882 237 - 0 1119
62 YSH132 N S NEETHA 1020101001847 30 0 0.0 0.0 30.0 9030 3713 800 2258 15801 9030 3713 800 2258 15801 1084 - 200 0 1284

GRAND TOTAL 1860 0 1860 541544 199095 36034 912063 541544 199095 36034 135390 912063 64976 7632 4600 0 77208
NET
SALARY
PAYABLE
29550
26050
16469
17533
12622
15382
10208
13492
24662
13296
14050
12371
16056
22016
18166
18444
11389
8734
9078
8734
9373
10159
11389
12863
20088
10257
11389
8734
12371
10898
12371
16448
9766
9569
15270
14050
9766
15367
11389
13113
8587
21160
8390
18208
9569
9569
11345
NET
SALARY
PAYABLE
14592
8292
9569
8147
8156
19232
15632
23800
8779
14517
8156
9569
9766
12371
14517
###
###
###
###
834855
SIGNATUR
E
SIGNATUR
E
SALARY SHEET FOR THE MONTH OF JUNE 2016

SL.NO. NAME ACCOUNT NO AMOUNT


1 DR. ARCHANA P 1020101001786 2000.00
2 HEMALATHA M P 1020101001787 2000.00
3 SHANKARNARAYANA H S 1020101001788 1431.00
4 NETHRAVATHI P HANDE 1020101001789 1467.00
5 MANJULA P 1020101001790 1178.00
6 NAGARATHNA P 1020101001791 1269.00
7 RAGHAVENDRA M 1020101001792 1080.00
8 SADANANDA 1020101001793 1208.00
9 BINIMOL D 1020101001794 1989.00
10 CHANDRAKALA B S 1020101001795 1204.00
11 TULASI HEGDE 1020101001796 1150.00
12 BHARATHI D 1020101001797 1119.00
13 SANDHYAMOL M K 1020101001798 1244.00
14 PRIYADARSHINI 1020101001799 1784.00
15 SUNIL H C 1020101001800 1485.00
16 JAYALAXMI B AKKI 1020101001801 1507.00
17 ASHA 1020101001802 1101.00
18 SUNDARAMMA 1020101001803 1054.00
19 SARASWATHI 1020101001804 1060.00
20 LALITHA 1020101001805 1054.00
21 MANJULA 1020101001806 1065.00
22 NAGARAJ G 1020101001807 1079.00
23 PAVITHRA V 1020101001808 1101.00
24 LAKSHMI G RAIKAR 1020101001809 1127.00
25 BINDU K 1020101001810 1712.00
26 JINCY K JOHN 1020101001811 1081.00
27 MAMATHA G 1020101001812 1101.00
28 JAYAMMA V 1020101001813 1054.00
29 RAJINI 1020101001814 1119.00
30 SHAMBHAVI J 1020101001815 1092.00
31 SUBHASH C K 1020101001816 1119.00
32 MINIKURIAKOSE 1020101001817 1352.00
33 NANDISHA K S 1020101001818 1072.00
34 TINCY 1020101001819 1069.00
35 SUGUNA SUREKHA A 1020101001820 1280.00
36 ASHA N 1020101001821 950.00
37 NIDHINI ABRAHAM 1020101001822 1072.00
38 JAYASIMHA B H 1020101001823 1284.00
39 THOKCHOM IBETHOI CHANU 1020101001824 1101.00
40 LAKSHMI DEVI S 1020101001825 1187.00
41 GANGAMMA 1020101001826 1051.00

Page 7 of 8
SALARY SHEET FOR THE MONTH OF JUNE 2016

SL.NO. NAME ACCOUNT NO AMOUNT


42 DR. ANJANA 1020101001827 1640.00
43 BANASODE RAM 1020101001828 1048.00
44 RAMESH N 1020101001829 1592.00
45 BINCY BABU 1020101001830 1069.00
46 ASWATHY BHUVANENDRAN 1020101001831 1069.00
47 NAGARATHNA NAIK 1020101001832 1095.00
48 A P GAYATHRI 1020101001833 1208.00
49 ZAREENA B 1020101001834 1046.00
50 MAHALAKSHMI G 1020101001835 1069.00
51 SOWMYA G 1020101001836 1043.00
52 VANISHRI 1020101001837 1044.00
53 JAGADISH G R 1020101001838 1568.00
54 DR. ANJU ANTONY 1020101001839 1344.00
55 DR. GOWRI SHANKAR R 1020101001840 2000.00
56 RUKMINI 1020101001841 1049.00
57 NANDINI L 1020101001842 1284.00
58 RUKMINI S 1020101001843 1044.00
59 VASU 1020101001844 1069.00
60 MALATHI 1020101001845 1072.00
61 DEEPA H M 1020101001846 1119.00
62 N S NEETHA 1020101001847 1284.00

TOTAL AMOUNT 77208.00

Page 8 of 8

You might also like