工资计算表模板表格文件下载.xls

工资计算表模板表格文件下载.xls

《工资计算表模板表格文件下载.xls》由会员分享，可在线阅读，更多相关《工资计算表模板表格文件下载.xls（2页珍藏版）》请在冰点文库上搜索。

工工资资计计算算表表编制单位：

@#@*有限责任公司序号姓名基本工资假日加班工时平时加班工资法定节假日期加班工资伙食补贴住房补贴其他提成金额应付工资A扣事假D代扣保险E扣其他税前小计F=C-D-E应税所得G=F-3500税率H速算扣除I代扣个税J=G*H-I实发金额L=F-J-K签领01500050005000.001500.003%045.004955.0002200020002000.000.000%00.002000.0003500050005000.001500.003%045.004955.0004200002000020000.0016500.0025%10053120.0016880.0005300030003000.000.000%00.003000.0006200020002000.000.000%00.002000.0007400040004000.00500.003%015.003985.0008400004000040000.0036500.0030%27558195.0031805.0009800080008000.004500.0010%105345.007655.0010400004000040000.0036500.0030%27558195.0031805.0011400004000040000.0036500.0030%27558195.0031805.0012400040004000.00500.003%015.003985.0013500005000050000.0046500.0030%275511195.0038805.0014400040004000.00500.003%015.003985.0015400004000040000.0036500.0030%27558195.0031805.0016400040004000.00500.003%015.003985.0017400040004000.00500.003%015.003985.0018200020002000.000.000%00.002000.0019400040004000.00500.003%015.003985.0020700070007000.003500.0010%105245.006755.0021700070007000.003500.0010%105245.006755.0022700070007000.003500.0010%105245.006755.0023500050005000.001500.003%045.004955.0024700070007000.003500.0010%105245.006755.0025200020002000.000.000%00.002000.0026200020002000.000.000%00.002000.0027100010001000.000.000%00.001000.0028300030003000.000.000%00.003000.0029400040004000.00500.003%015.003985.0030400040004000.00500.003%015.003985.0031200020002000.000.000%00.002000.00合计3320000332000003320002360001530548675283325备注