Excel表格通用模板：职工年终奖发放表(自动计算).xls

职工年终奖发放表序序号号部部门门员员工工姓姓名名奖奖金金基基数数入入职职日日绩绩效效系系数数应应发发金金额额应应缴缴所所得得税税实实发发金金额额1销售部*100002012/7/261.212,000.00360.0011,640.002总经办*60002011/3/101.16,600.00198.006,402.003生产部*60002011/5/231.06,000.00180.005,820.004行政部*60002013/8/261.06,000.00180.005,820.005生产副总*100002014/4/201.515,000.00450.0014,550.006采购*60002010/9/261.06,000.00180.005,820.007技术部*60002014/7/181.37,800.00234.007,566.008财务部经理*100002016/7/11.717,000.00510.0016,490.009公司副总*100002009/8/312.020,000.001,925.0018,075.0010-11-12-13-合合 计计70,000.096,400.04,217.092,183.0制制订订部部门门：行行政政人人事事部部审审核核批批准准：日日 期期：日日 期期：备注:此表只是适合年终一次性奖金发放的情况下,个税的计算方法。