NAME B. SALARY HRA 25% DA 20% TA 1500 ESI 12.5% PF 1.
75% TDS 10% TOTAL
MANISH 20000 5000 4000 1500 2500 350 2000 25650
SURESH 20000 5000 4000 1500 2500 350 2000 25650
MAHESH 25000 6250 5000 1500 3125 437.5 2500 31687.5
RAM 35000 8750 7000 1500 4375 612.5 3500 43762.5
SHYAM 18500 4625 3700 1500 2312.5 323.75 1850 23838.75
AJAY 23000 5750 4600 1500 2875 402.5 2300 29272.5
VIJAY 24000 6000 4800 1500 3000 420 2400 30480
SHIVA 19000 4750 3800 1500 2375 332.5 1900 24442.5
ITEM SHEET
ITEM Q. RATE AMOUNT DISCOUNT 10% GST 5% TOTAL AM.
BOOK 10 100 1000 100 50 950
PEN 20 25 500 50 25 475
LAPTOP 2 45000 90000 9000 4500 85500
MOBILE 1 20000 20000 2000 1000 19000
FAN 3 1650 4950 495 247.5 4702.5
MOUSE 0 0 0 0
SALARY DATABASE R
S.NO. YEAR MONTH EMP.CODE EMP.NAME FATHER NAME CONTACTS
1 2025 JUN E901 AJAY NA 1234567890
2 2025 JUL E902 VIJAY NA 1234567890
3 2025 AUG E903 RAM NA 1234567890
4 2025 SEP E904 SHYAM NA 1234567890
5 2025 OCT E905 RADHA NA 1234567890
6 2025 NOV E906 GORI NA 1234567890
7 2025 DEC E907 SUNITA NA 1234567890
8 2025 JAN E908 ANITA NA 1234567890
9 2025 FEB E909 MOHIT NA 1234567890
10 2025 MAR E910 ROHIT NA 1234567890
11 2025 APR E911 RAMESH NA 1234567890
12 2025 MAY E912 SURESH NA 1234567890
13 2025 JUN E913 HARSH NA 1234567890
14 2025 JUL E914 MEENA NA 1234567890
15 2025 AUG E915 SEEMA NA 1234567890
16 2025 SEP E916 SAPNA NA 1234567890
17 2025 OCT E917 AAHAN NA 1234567890
18 2025 NOV E918 ANIL NA 1234567890
19 2025 DEC E919 SUNIL NA 1234567890
20 2025 JAN E920 ANKIT NA 1234567890
ATABASE REPORT
B.S. DA 20% TA 2000 HRA 25% GS PF 1.75% ESI 12.5% DED NS
12500 2500 2000 3125 20125 218.75 1562.5 1781.25 18343.75
19000 3800 2000 4750 29550 332.5 2375 2707.5 26842.5
12500 2500 2000 3125 20125 218.75 1562.5 1781.25 18343.75
15000 3000 2000 3750 23750 262.5 1875 2137.5 21612.5
8000 1600 2000 2000 13600 140 1000 1140 12460
16500 3300 2000 4125 25925 288.75 2062.5 2351.25 23573.75
13800 2760 2000 3450 22010 241.5 1725 1966.5 20043.5
31000 6200 2000 7750 46950 542.5 3875 4417.5 42532.5
17500 3500 2000 4375 27375 306.25 2187.5 2493.75 24881.25
15400 3080 2000 3850 24330 269.5 1925 2194.5 22135.5
13000 2600 2000 3250 20850 227.5 1625 1852.5 18997.5
16000 3200 2000 4000 25200 280 2000 2280 22920
19500 3900 2000 4875 30275 341.25 2437.5 2778.75 27496.25
12000 2400 2000 3000 19400 210 1500 1710 17690
14000 2800 2000 3500 22300 245 1750 1995 20305
17000 3400 2000 4250 26650 297.5 2125 2422.5 24227.5
11000 2200 2000 2750 17950 192.5 1375 1567.5 16382.5
9000 1800 2000 2250 15050 157.5 1125 1282.5 13767.5
5000 1000 2000 1250 9250 87.5 625 712.5 8537.5
10000 2000 2000 2500 16500 175 1250 1425 15075
