01-【通用】Excel工资模板单位分级扣税自动计算工资表（含扣减社保等）

工资表编制单位：序号姓名基本工资其他签领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!假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴提成金额应付工资A扣事假D代扣保险E扣其他税前小计F=C-D-E应税所得G=F-3500税率H速算扣除I代扣个税J=G*H-I实发金额L=F-J-K工资表备注