Excel工资模板单位分级扣税自动计算工资表(含扣减社保等.xls

Sheet2工资表编制单位：序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资A扣事假D代扣保险E扣其他税前小计F=C-D-E应税所得G=F-3500税率H速算扣除I代扣个税J=G*H-I实发金额L=F-J-K签领备注01 10000 10000 10000.00 6500.00 20%555 745.00 9255.00 02 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!03 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!04 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!05 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!06 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!07 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!08 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!09 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!10 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!11 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!12 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!13 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!14 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!15 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!16 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!17 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!18 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!19 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!20 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!21 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!22 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!23 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!24 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!25 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!26 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!27 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!28 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!29 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!30 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!31 0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!合计10000 0 10000 0 0 10000#VALUE!#VALUE!#VALUE!#VALUE!Sheet3。

这里是常见问题内容示例，可替换为实际内容。