员工工资核算表

员工工资核算表,,,,,,,,,,,,,,,,,,,,,,,,,,,

核算期间：2026年08月制表日期：2026-08-27单位：元,,,,,,,,,,,,,,,,,,,,,,,,,,,

员工基本信息,,,,,,考勤信息,,,,收入项目,,,,,,,,,"应发工资

合计",扣款项目（个人承担部分）,,,,,,扣款合计,实发工资

序号,工号,姓名,部门,岗位,入职日期,"应出勤

天数","实出勤

天数","请假

天数","加班

小时",基本工资,岗位工资,绩效工资,工龄工资,加班费,交通补贴,餐饮补贴,通讯补贴,其他补贴,,"养老保险

(个人8%)","医疗保险

(个人2%)","失业保险

(个人0.5%)","住房公积金

(个人12%)",个人所得税,其他扣款,,

1,EMP001,张伟,技术研发部,高级工程师,2021-03-15,22,22,0,10.0,"12,000.00","3,000.00","6,000.00",250.00,"1,034.48",500.00,600.00,200.00,0.00,"23,584.48",960.00,240.00,60.00,"1,440.00","1,766.90",0.00,"4,466.90","19,117.58"

2,EMP002,李娜,技术研发部,工程师,2022-07-01,22,21,1,8.0,"9,000.00","2,000.00","3,500.00",200.00,620.69,500.00,600.00,200.00,0.00,"16,620.69",720.00,180.00,45.00,"1,080.00",749.57,0.00,"2,774.57","13,846.12"

3,EMP003,王强,技术研发部,工程师,2023-02-20,22,22,0,15.0,"8,500.00","2,000.00","3,300.00",150.00,"1,099.14",500.00,600.00,200.00,0.00,"16,349.14",680.00,170.00,42.50,"1,020.00",733.66,0.00,"2,646.16","13,702.98"

4,EMP004,刘洋,技术研发部,助理工程师,2024-06-10,22,20,2,5.0,"6,500.00","1,500.00","1,800.00",100.00,280.17,500.00,600.00,200.00,0.00,"11,480.17",520.00,130.00,32.50,780.00,291.77,0.00,"1,754.27","9,725.90"

5,EMP005,陈静,产品设计部,产品经理,2020-11-08,22,22,0,12.0,"13,000.00","3,500.00","7,150.00",300.00,"1,344.83",500.00,600.00,200.00,0.00,"26,594.83","1,040.00",260.00,65.00,"1,560.00","2,323.97",0.00,"5,248.97","21,345.86"

6,EMP006,杨帆,产品设计部,UI设计师,2022-03-22,22,22,0,6.0,"8,000.00","1,800.00","3,000.00",200.00,413.79,500.00,600.00,200.00,0.00,"14,713.79",640.00,160.00,40.00,960.00,581.38,0.00,"2,381.38","12,332.41"

7,EMP007,赵敏,产品设计部,交互设计师,2023-08-15,22,21,1,4.0,"7,500.00","1,800.00","2,375.00",150.00,258.62,500.00,600.00,200.00,0.00,"13,383.62",600.00,150.00,37.50,900.00,459.61,0.00,"2,147.11","11,236.51"

8,EMP008,孙磊,市场营销部,市场总监,2019-05-20,22,22,0,20.0,"15,000.00","5,000.00","11,200.00",350.00,"2,586.21",500.00,600.00,200.00,0.00,"35,436.21","1,200.00",300.00,75.00,"1,800.00","4,105.30",0.00,"7,480.30","27,955.91"

9,EMP009,周婷,市场营销部,市场经理,2021-09-12,22,22,0,10.0,"10,000.00","2,500.00","5,175.00",250.00,862.07,500.00,600.00,200.00,0.00,"20,087.07",800.00,200.00,50.00,"1,200.00","1,157.41",0.00,"3,407.41","16,679.66"

10,EMP010,吴昊,市场营销部,市场专员,2023-04-18,22,19,3,0.0,"6,000.00","1,200.00","1,700.00",150.00,0.00,500.00,600.00,200.00,0.00,"10,350.00",480.00,120.00,30.00,720.00,190.00,0.00,"1,540.00","8,810.00"

11,EMP011,郑雪,财务部,财务经理,2020-02-28,22,22,0,8.0,"11,000.00","3,000.00","4,400.00",300.00,758.62,500.00,600.00,200.00,0.00,"20,758.62",880.00,220.00,55.00,"1,320.00","1,246.72",0.00,"3,721.72","17,036.90"

12,EMP012,冯涛,财务部,会计,2022-11-05,22,22,0,5.0,"7,000.00","1,500.00","2,500.00",200.00,301.72,500.00,600.00,200.00,0.00,"12,801.72",560.00,140.00,35.00,840.00,412.67,0.00,"1,987.67","10,814.05"

13,EMP013,何琳,人力资源部,HR经理,2021-06-30,22,22,0,6.0,"10,500.00","2,800.00","4,600.00",250.00,543.10,500.00,600.00,200.00,0.00,"19,993.10",840.00,210.00,52.50,"1,260.00","1,116.12",0.00,"3,478.62","16,514.48"

14,EMP014,马超,人力资源部,招聘专员,2023-10-08,22,21,1,3.0,"6,200.00","1,300.00","1,980.00",150.00,160.34,500.00,600.00,200.00,0.00,"11,090.34",496.00,124.00,31.00,744.00,259.53,0.00,"1,654.53","9,435.81"

15,EMP015,林芳,行政部,行政主管,2022-01-15,22,22,0,4.0,"7,500.00","1,800.00","2,500.00",200.00,258.62,500.00,600.00,200.00,0.00,"13,558.62",600.00,150.00,37.50,900.00,477.11,0.00,"2,164.61","11,394.01"

16,EMP016,黄鹏,行政部,行政专员,2024-03-01,22,22,0,2.0,"5,500.00","1,000.00","1,710.00",100.00,94.83,500.00,600.00,200.00,0.00,"9,704.83",440.00,110.00,27.50,660.00,136.73,0.00,"1,374.23","8,330.60"

合计,,,,,,352.0,344.0,8.0,118.0,"143,200.00","35,700.00","62,890.00","3,300.00","10,617.23","8,000.00","9,600.00","3,200.00",0.00,"276,507.23","11,456.00","2,864.00",716.00,"17,184.00","16,008.45",0.00,"48,228.45","228