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

会员专享推荐 · 你可能也用得上更多

开通会员，畅读全站文档

本篇文档已为你保留

本篇文档价值 ~~¥35.00~~会员免费解锁

全文不限次阅读，剩余内容即刻解锁
高速下载通道，免排队、无等待
专属客服 1 对 1 答疑，优先响应
每日赠送下载券，本篇文档免费送

有 86 篇商业计划书正在上传

下载原文档

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。