完整工资表模板(带公式)

1、2015年 A月工资表单位负责人:公司人力资源部审核:财务主管:制表:单位：单位：元序号姓名出勤 天数基本工资工龄 工资奖金 基数奖金 系数绩效 工资补助其他奖金应发工资 合计代扣代扣小计计税工资扣个人所 得税实发工资 合计备注扣A月份住 房公积金扣A月份 医疗保险扣A月份 失业保险扣A月份 养老保险1A30600017007700600.00166.6641.67666.641474.976225.03167.506057.532B30500012006200500.00222.4360.00853.441635.874564.1331.924532.213A3050005000124.22

2、31.06496.88652.164347.8425.444322.404B30420025012002.0240017008550420.0091.6622.92366.64901.227648.78309.887338.905A30420026012002.024006860420.0085.74342.96848.706011.30146.135865.176B30400026012002.024006660400.0083.6020.90334.40838.905821.10127.115693.997A30400037012002.024006770400.0085.4621.373

3、41.84848.675921.33137.135784.208B30400014012002.024006540358.0071.6017.90286.40733.905806.10125.615680.499A30400013012002.024006530400.0082.2020.55328.80831.555698.45114.855583.6010B3036005012001.720405690360.0074.4018.60297.60750.604939.4043.184896.2211A3040006012002.024006460400.0073.0818.27292.32

4、783.675676.33112.635563.7012B3036005012001.720405690360.0074.4018.60297.60750.604939.4043.184896.2213A2828935012001.415684511310.0063.3415.84253.36642.543868.4611.053857.4114B3036004012001.720405680310.0063.3015.83253.20642.33 15037.6748.774988.9015A3031002012001.416804800336.0067.0616.77268.24688.0

5、74111.9318.364093.5716B30360028012001.720405920360.0049.2812.32170.72592.325327.6877.775249.9117A3031003012001.416804810310.0059.2014.80236.80620.80 14189.2020.684168.5218B3031003012001.416804810310.0059.2014.80236.80620.804189.2020.684168.5219A3028001012001.214404250280.0056.0014.00224.00574.003676

6、.005.283670.7220B3031002012001.416804800270.0058.2014.55232.80575.554224.4521.734202.7221A3031002012001.416804800285.0057.0014.25228.00584.254215.7521.474194.2822B3031003012001.416804810462.0092.4623.12369.84947.423862.5810.883851.7023A3031006012001.416804840310.0070.2017.55280.80678.554161.4519.844

7、141.612015年 A月工资表单位：单位：元序号姓名出勤 天数基本工资工龄 工资奖金 基数奖金 系数绩效 工资补助其他奖金应发工资 合计代扣代扣小计计税工资扣个人所 得税实发工资 合计备注扣A月份住 房公积金扣A月份 医疗保险扣A月份 失业保险扣A月份 养老保险24A3031002012001.416804800260.0052.0013.00208.00533.004267.0023.014243.9925B30310010012001.416804880310.0083.9620.99335.84750.794129.2118.884110.3326A3031005012001.416

8、804830310.0071.2417.81284.96684.014145.9919.384126.6127B3031003012001.416804810310.0061.9015.48247.60634.984175.0220.254154.7728A3028003012001.214404270280.0071.4817.87285.92655.273614.733.443611.2929B3031004012001.416804820280.0061.5615.39246.24603.194216.8121.504195.3130A3031002012001.416804800270

9、.0056.2614.07225.04565.374234.6322.044212.5931B1414472012001.47842251285.0057.0014.25228.00584.251666.750.001666.7532A26268732012001.414564463310.0044.4911.12170.72536.333926.6712.803913.8733B3027002700270.0054.0013.50216.00553.502146.500.002146.5034A3027002700270.0054.0013.50216.00553.502146.500.00

10、2146.5035B3027002700270.0054.0013.50216.00553.502146.500.002146.5036A3027002700270.0054.0013.50216.00553.502146.500.002146.5037B3027002700270.0054.0013.50216.00553.502146.500.002146.5038A3027002700270.0054.0013.50216.00553.502146.500.002146.5039B3027002700270.0054.0013.50216.00553.502146.500.002146.5040A3027002700270.0054.0013.50216.00553.502146.500.002146.5041B3031003012001.416804810310.0054.0013.50216.00593.