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

序号1234567891011121314151617181920asdfghhjkqwertyyuizsdxcvgvbhrewbdpojkjyjmmyytgjkeynbgfyoiazz姓名基础工资 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 33,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假日加班工时(小时) 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其它补贴 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社保扣除 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其它扣除工资 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个人所得税12.4实发工资3900.979316.523710.882299171.486093.3360923.493612.7628745.383674.0912642.163569.84 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.188.473773.8748289.713814.0141389.43803.9793101782.3448289.093793.9444838.783783.9096555.1629.1603666.844442.84227202038.09195403472128.415705.658966164.336028.934368177.46146.611494 751.34 79,086.94合 计 - - 44,550.00 - - - 79,838.28