2018新个税扣税自动生成工资表--扣社保、扣个税

社保基数养老金8%医疗金2%失业金0.5%公积金7%1A2012-06-0625005001000000003100031002B2012-06-0725005001000000003100031003C2012-06-0825005001000000003100031004567891011121314151617181920合75001500300000000930009300社保基数养老金8%医疗金2%失业金0.5%公积金7%工资代扣应发小计代扣个人所得税出差补助工资代扣应发小计2018年员工工资表（单位：人民币元）工号姓名底薪岗位工资综合补贴出差补助实发工资工资条：工号姓名底薪岗位工资综合补贴入职日期代扣个人所得税实发工资1A2500500100000000310003100社保基数养老金8%医疗金2%失业金0.5%公积金7%2B2500500100000000310003100出差补助工资代扣应发小计代扣个人所得税实发工资工号姓名底薪岗位工资综合补贴社保基数养老金8%1A2012-06-06250050010003286.3262.92B250050010005477.17438.173C25005001000004567891011121314151617181920合计7500150030008763.47701.07社保下3286.360%社保上5477.17100%综合补贴出差补助工资代扣2018年员工工资表（单位：人民币元）入职日期工号姓名底薪岗位工资医疗金2%失业金0.5%公积金7%65.7316.43230.042524.902524.9109.5427.39383.42141.502141.5-74.25000310003100175.2743.82613.447766.407766.4工资代扣应发小计代扣个人所得税实发工资2018年员工工资表（单位：人民币元）编制单位：序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资A扣事假D代扣保险E扣其他011000010000025000500003800080000460006000050060070080090100110120130140150160170180190200合计2900002900000税前小计F=C-D-E应税所得G=F-3500税率H速算扣除I代扣个税J=G*H-I实发金额L=F-J-K签领备注10000.006500.0020%555745.009255.005000.001500.003%045.004955.008000.004500.0010%105345.007655.006000.002500.0010%105145.005855.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!29000#VALUE!#VALUE!#VALUE!#VALUE!