这是一个页数为16页的Excel表格格式的工资表管理系统表,下载后可编辑可打印,其他薪酬管理工资管理系统职工工资表可以在本网站搜索下载。
,按照姓名查询,月 份:全年姓 名:张三,应发工资102600.0个税807.84实发工资91019.16,工号1001.0部门高层固定工资69600.0,绩效工资27600.0餐补3600.0奖励3000.0,罚款1200.0养老保险8208.0医疗险2052.0,失业险513.0公积金7182.0个税基数84645.0,按照工号查询,月 份:1月工 号:1002.0,应发工资7550.0个税36.86实发工资6720.39,工号1002.0部门企业管理部固定工资5400.0,绩效工资2500.0餐补150.0奖励0.0,罚款500.0养老保险604.0医疗险151.0,失业险37.75公积金528.5个税基数6228.75,员工全年工资明细输出表,按照姓名查询,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1月,2月2500.08750.0700.0175.043.75612.57218.7566.567764.69,3月3000.09250.0740.0185.046.25647.57631.2578.948199.81,4月4500.010750.0860.0215.053.75752.58868.75176.889444.37,5月8250.0660.0165.041.25577.56806.2554.197329.56,6月-500.05750.0460.0115.028.75402.54743.755146.25,7月,8月,9月,10月,11月,12月,全年69600.027600.03600.03000.01200.0102600.08208.02052.0513.07182.084645.0807.8491019.16,按照工号查询,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1月2500.07550.0604.0151.037.75528.56228.7536.866720.39,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,全年64800.024500.01800.06000.085100.06808.01702.0425.55957.070207.5306.2575858.25,使用说明,序号部门,1.0高层,2.0总经办,3.0人力资源部,4.0企业管理部,5.0信息中心,6.0审计监察部,7.0财务部,8.0生产部,9.0质量部,10.0服务部,11.0销售部,12.0安全处,13.0后勤部,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,1月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02500.0500.07550.0604.0151.037.75528.56228.7536.866720.39,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.010200.0750.0750.02100.033600.02688.0672.0168.02352.027720.0231.629840.4,2月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02500.0300.0250.0100.08750.0700.0175.043.75612.57218.7566.567764.69,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六财务部7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09900.0750.0750.02100.033300.02664.0666.0166.52331.027472.5224.1829579.32,3月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.03000.0300.0250.0100.09250.0740.0185.046.25647.57631.2578.948199.81,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.010400.0750.0750.02100.033800.02704.0676.0169.02366.027885.0236.5630014.44,4月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.04500.0300.0250.0100.010750.0860.0215.053.75752.58868.75176.889444.37,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.011900.0750.0750.02100.035300.02824.0706.0176.52471.029122.5334.531259.0,5月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02000.0300.0250.0100.08250.0660.0165.041.25577.56806.2554.197329.56,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09400.0750.0750.02100.032800.02624.0656.0164.02296.027060.0211.8129144.19,6月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.0-500.0300.0250.0100.05750.0460.0115.028.75402.54743.755146.25,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.06900.0750.0750.02100.030300.02424.0606.0151.52121.024997.5157.6226960.88,7月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09700.0750.0750.02100.033100.02648.0662.0165.52317.027307.5219.2329405.27,8月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09700.0750.0750.02100.033100.02648.0662.0165.52317.027307.5219.2329405.27,9月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09700.0750.0750.02100.033100.02648.0662.0165.52317.027307.5219.2329405.27,10月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09700.0750.0750.02100.033100.02648.0662.0165.52317.027307.5219.2329405.27,11月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09700.0750.0750.02100.033100.02648.0662.0165.52317.027307.5219.2329405.27,12月工资表,工号姓名部门固定工资绩效工资餐补奖励罚款应发工资养老保险医疗险失业险公积金个税基数个税实发金额,1001.0张三高层5800.02300.0300.0250.0100.08550.0684.0171.042.75598.57053.7561.617590.64,1002.0李四企业管理部5400.02000.0500.07050.0564.0141.035.25493.55816.2524.496285.26,1003.0王五人力资源部5800.02400.0500.08850.0708.0177.044.25619.57301.2569.047851.71,1004.0晋六办公室7000.03000.01500.08650.0692.0173.043.25605.57136.2564.097677.66,合计24000.09700.0750.0750.02100.033100.02648.0662.0165.52317.027307.5219.2329405.27
提示:预览文档经过压缩,下载后原文档超清晰!有任何问题联系客服QQ:43570874 微信:niutuwen 备注:牛图文