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

《《会计常用表格》Excel工资模板单位分级扣税自动计算工资表(含扣减社保等.xls》由会员分享，可在线阅读，更多相关《《会计常用表格》Excel工资模板单位分级扣税自动计算工资表(含扣减社保等.xls（1页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、工工资资表表编制单位： 序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资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

2、!#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#V

3、ALUE!#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!2

4、10#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!