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

编制单位：序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资A扣事假D代扣保险E扣其他税前小计F=C-D-E应税所得G=F-3500税率H速算扣除I代扣个税J=G*H-I实发金额L=F-J-K签领01100001000010000.006500.0020%555745.009255.00020#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!030#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!040#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!050#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!060#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!070#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!080#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!090#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!100#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!110#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!120#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!130#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!140#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!150#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!160#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!170#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!180#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!190#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!200#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!210#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!220#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!230#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!240#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!250#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!260#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!270#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!280#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!290#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!300#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!310#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!合计100000100000010000#VALUE!#VALUE!#VALUE!#VALUE!工资表备注工资表