员工工资自动计算表表格文件下载.xls
- 文档编号:14465421
- 上传时间:2022-10-23
- 格式:XLS
- 页数:2
- 大小:42.50KB
员工工资自动计算表表格文件下载.xls
《员工工资自动计算表表格文件下载.xls》由会员分享,可在线阅读,更多相关《员工工资自动计算表表格文件下载.xls(2页珍藏版)》请在冰豆网上搜索。
2018年1月份员工工资表序号部门姓名出勤工资结构补助罚款应发合计扣除项岗位工资加班工资绩效工资通讯补助工龄补助其他请假迟到/早退其他户口社保(五险)起征点应纳税所得额1行政李先生全勤3500.01000.050.04550.0农业342.043500707.962邓姐全勤4000.050.04050.0城镇348.23500201.83张经理全勤4500.0200.0100.04800.0农业342.043500957.964商务杜小姐全勤5000.0100.01800.050.050.0-50.06950.0城镇348.235003101.85陈小姐全勤6000.0300.050.0100.06450.0农业342.0435002607.966朱先生全勤8300.050.08350.0农业342.0435004507.967财务王姐假2天8500.0300.0500.050.0-772.78577.3农业342.0435004735.268邢会计全勤11000.0100.080.011180.0城镇348.235007331.89袁经理全勤12500.0100.012600.0农业342.0435008757.9610工程高主任假1天35000.0100.0-1591.033509.0城镇348.2350029660.811秦经理全勤30000.0100.030100.0农业342.0435002625812白主管全勤20000.0100.020100.0农业342.0435001625813业务刘经理全勤28000.09981.0100.038081.0城镇348.2350034232.814业务1全勤3000.02295.0100.05395.0农业342.0435001552.9615业务2全勤3000.01800.0100.0-20.04880.0农业342.0435001037.9616业务3全勤3000.04276.0100.07376.0农业342.0435003533.9617业务4假3天3000.05122.0100.0-409.0-60.07753.0农业342.0435003910.9618业务5假15天3000.03648.0100.0-1500.05248.0农业342.0435001405.9619业务6全勤3000.01194.0100.04294.0农业342.043500451.9620业务7全勤3000.02236.0100.0-30.05306.0农业342.0435001463.96实发工资比例速算扣除数应缴纳个税金额3%021.244186.723%06.053695.753%028.744429.2210%105205.186396.6210%105155.805952.1610%105345.807662.1620%555392.057843.2120%555911.369920.4420%5551196.5911061.3725%10056410.2026750.6025%10055559.4924198.4725%10053059.4916698.4725%10057553.2030179.6010%10550.305002.663%031.144506.8210%105248.406785.5610%105286.107124.863%042.184863.783%013.563938.403%043.924920.04
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 员工工资 自动 计算