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

20XX年工资表,,,,,,,,,,,,,,,,,,,,

单位名称：,,,,,,,,,,,工资月份：,20XX/9/1,,,,,,,单位:元,

序号,姓名,"出勤

天数",基本工资,"工龄

工资",奖金基数,奖金系数,"绩效

工资",补助,其他,奖金,应发工资合计,代扣,,,,代扣小计,计税工资,扣个人所得税,实发工资合计,备注

,,,,,,,,,,,,"扣9月份住房公积金

","扣9月份

医疗保险

","扣9月份

失业保险

","扣9月份

养老保险

",,,,,

1,,26,6000,260,1200,2.0,2400,1700,,,10360,600.00,166.66,41.67,666.64,1474.97,8885.03,178.50,8706.53,

2,,26,5000,260,1200,2.0,2400,1200,,,8860,500.00,222.43,60.00,853.44,1635.87,7224.13,66.72,7157.41,

3,,26,5000,260,1200,2.0,2400,1200,,,8860,,124.22,31.06,496.88,652.16,8207.84,110.78,8097.06,

4,,26,4200,250,1200,2.0,2400,1700,,,8550,420.00,91.66,22.92,366.64,901.22,7648.78,79.46,7569.32,

5,,26,4200,260,1200,2.0,2400,1200,,,8060,420.00,85.74,,342.96,848.70,7211.30,66.34,7144.96,

6,,,,,,,,,,,,,,,,,,0.00,0.00,

7,,,,,,,,,,,,,,,,,,0.00,0.00,

8,,,,,,,,,,,,,,,,,,0.00,0.00,

9,,,,,,,,,,,,,,,,,,0.00,0.00,

10,,,,,,,,,,,,,,,,,,0.00,0.00,

11,,,,,,,,,,,,,,,,,,0.00,0.00,

12,,,,,,,,,,,,,,,,,,0.00,0.00,

13,,,,,,,,,,,,,,,,,,0.00,0.00,

14,,,,,,,,,,,,,,,,,,0.00,0.00,

15,,,,,,,,,,,,,,,,,,0.00,0.00,

16,,,,,,,,,,,,,,,,,,0.00,0.00,

17,,,,,,,,,,,,,,,,,,0.00,0.00,

18,,,,,,,,,,,,,,,,,,0.00,0.00,

19,,,,,,,,,,,,,,,,,,0.00,0.00,

25,,,,,,,,,,,,,,,,,,0.00,0.00,

26,,,,,,,,,,,,,,,,,,0.00,0.00,

,合计,,24400.00,1290.00,,,12000.00,7000.00,0.00,0.00,44690.00,1940.00,690.71,155.65,2726.56,5512.92,39177.08,501.81,38675.27,

,,,,,,,,,,,,,,,,,,,,,

单位负责人：,,,,,,,公司人力资源部审核：,,,,,,财务主管：,,,,,制表：,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,