员工工资表模板范本(含有最新个税计算公式,起征点5000)

-
79,838.28
12.4 3900.97931
6.52 3710.882299
171.48 6093.336092
3.49 3612.762874
5.38 3674.091264
2.16
3569.84
0 3782.344828
0 3823.724138
0 3813.37931
0 1782.344828
0 3803.034483
0 3792.689655
0
3672
0
4472
0
2272
0 2038.091954
0
Leabharlann Baidu
3472
25.02 5809.048966
35.8 6157.464368
39.72 6284.291494
301.97 79,536.31
-
-
-
-
-
-
2,500.00
100.00
128.00
14 jmm
2,000.00
-
-
-
-
-
-
2,500.00
100.00
128.00
15 yyt
2,000.00
-
-
-
-
-
-
300.00
100.00
128.00
16 gjk
2,000.00
-
-
-
-
16.00
183.91
250.00
100.00
128.00
2 fgh
1,100.00
10.00
94.83
4.00
50.57
-
-
2,500.00
100.00
128.00
3 hjk
1,100.00
15.00
142.24
4.00
50.57
-
-
5,000.00
100.00
128.00
4 qwe
1,100.00
2.00
18.97
4.00
50.57
4.00
25.29
2,500.00
100.00
128.00
5 rty
1,100.00
6.00
56.90
4.00
50.57
-
-
2,500.00
100.00
128.00
6 yui
1,100.00
-
-
-
-
-
2,500.00
100.00
128.00
7 zsd
1,200.00
8.00
82.76
2.00
27.59
-
-
2,500.00
100.00
17 eyn
2,000.00
-
-
-
-
-
-
1,500.00
100.00
128.00
18 bgf
3,500.00
8.00
241.38
3.00
120.69
-
-
2,000.00
100.00
128.00
19 yoi
3,500.00
6.00
181.03
1.00
40.23
-
-
2,500.00
100.00
128.00
序号 姓名
基础工资
平时加班 工时（小时）
平时加班 加班费
假日加班 工时(小时)
假日加班 加班费
请假工时 (小时)
请假扣除
迟到/早退 扣除
违规扣除
岗位补贴
其它补贴 社保扣除 其它扣除
1 asd
1,100.00
20.00
189.66
16.00
202.30
8.00
50.57
2,500.00
100.00
128.00
3.00
20.69
500.00
100.00
128.00
11 wbd
1,200.00
10.00
103.45
2.00
27.59
-
-
2,500.00
100.00
128.00
12 poj
1,200.00
9.00
93.10
2.00
27.59
-
-
2,500.00
100.00
128.00
13 kjy
1,200.00
20 azz
3,500.00
5.00
150.86
5.00
201.15
-
-
2,500.00
100.00
128.00
合 计 33,500.00
132.00 1,696.55
53.00
932.18
31.00
280.46
-
-
44,550.00
2,000.00 2,560.00
-
-
工资
个人所得税 实发工资
3,913.38
3,717.40
6,264.82
3,616.25
3,679.47
3,572.00
3,782.34
3,823.72
3,813.38
1,782.34
3,803.03
3,792.69
3,672.00
4,472.00
2,272.00
2,038.09
3,472.00
5,834.07
6,193.26
6,324.01
128.00
8 xcv
1,200.00
12.00
124.14
2.00
27.59
-
-
2,500.00
100.00
128.00
9 gvb
1,200.00
11.00
113.79
2.00
27.59
-
-
2,500.00
100.00
128.00
10 hre
1,200.00
10.00
103.45
2.00
27.59