工资表(EXCEL表格带计算公式-个人所得税自动计算)

假日加班 工时(小时) 16.00 4.00 4.00 4.00 4.00
假日加班 加班费 202.30 50.57 50.57 50.57 50.57 -
请假工时 (小时) 8.00 4.00 3.00 16.00 31.00
请假扣除 50.57 25.29 20.69 183.91 280.46
迟到/早退 扣除
违规扣除
岗位补贴 2,500.00 2,500.00 5,000.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 500.00 2,500.00 2,500.00 2,500.00 2,500.00 300.00 250.00 1,500.00 2,000.00 2,500.00 2,500.00
平时加班 工时（小时） 20.00 10.00 15.00 2.00 6.00 8.00 12.00 11.00 10.00 10.00 9.00 8.00 6.00 5.00 132.00
平时加班 加班费 189.66 94.83 142.24 18.97 56.90 82.76 124.14 113.79 103.45 103.45 93.10 241.38 181.03 150.86 1,696.55
序号 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 asd fgh hjk qwe rty yui zsd xcv gvb hre wbd poj kjy jmm yyt gjk eyn bgf yoi azz
姓名
基础工资 1,100.00 1,100.00 1,100.00 1,100.00 1,100.00 1,100.00 1,200.00 1,200.00 1,200.00 1,200.00 1,200.00 1,200.00 1,200.00 2,000.00 2,000.00 2,000.00 2,000.00 3,500.00 3,500.00 3,500.00
社保扣除 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 128.00 2,560.00
其它补贴 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 2,000.00
2.00 2.00 2.00 2.00 2.00 2.00 3.00 1.00 5.00 53.00
27.59 27.59 27.59 27.59 27.59 27.59 120.69 40.23 201.15 932.18
128.41 5705.658966 164.33 6028.934368 177.4 751.34 6146.611494 79,086.94
个人所得税 12.4 6.52
实发工资 3900.97931 3710.882299
171.48 6093.336092 3.49 5.38 2.16 8.47 9.71 9.4 0 9.09 8.78 5.16 29.16 0 0 0 3612.762874 3674.091264 3569.84 3773.874828 3814.014138 3803.97931 1782.344828 3793.944483 3783.909655 3666.84 4442.84 2272 2038.091954 3472
合
计
33,500.00
-
-
44,550.00
-wenku.baidu.com
-
-
79,838.28
其它扣除
工资 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