Excel表格通用模板：年终奖发放表-计税表(税收筹划).xlsx

公司年终奖发放表2017年1月20日序序号号姓姓名名年年终终奖奖金金额额月月纳纳税税收收入入年年终终奖奖计计税税金金额额代代扣扣税税金金年年终终奖奖实实发发金金额额签签字字1张三18,000.003,500.0018,000.00540.0017,460.002李四18,001.003,500.0018,001.001,695.1016,305.903王五19,283.333,500.0019,283.331,823.3317,460.004马六5,000.003,900.005,000.00150.004,850.005赵七5,000.003,500.005,000.00150.004,850.006刘麻子5,000.002,800.004,300.00129.004,871.007-8-9-10-11-12-13-14-15-16-17-18-合合 计计70,284.3369,584.334,487.4365,796.90年终奖发放方案筹划2017年1月20日序序号号姓姓名名年年终终奖奖金金额额月月纳纳税税收收入入年年终终奖奖计计税税金金额额代代扣扣税税金金年年终终奖奖实实发发金金额额1A18,000.003,500.0018,000.00540.0017,460.002A218,001.003,500.0018,001.001,695.1016,305.903B54,000.003,500.0054,000.005,295.0048,705.004B254,001.003,500.0054,001.0010,245.2043,755.805C108,000.003,500.00108,000.0021,045.0086,955.006C2108,001.003,500.00108,001.0025,995.2582,005.757D420,000.003,500.00420,000.00103,995.00316,005.008D2420,001.003,500.00420,001.00123,245.30296,755.709E660,000.003,500.00660,000.00195,245.00464,755.0010E2660,001.003,500.00660,001.00225,495.35434,505.6511F960,000.003,500.00960,000.00330,495.00629,505.0012F2960,001.003,500.00960,001.00418,495.45541,505.55多多发发一一元元少少得得奖奖金金额额1,154.101,154.104,949.204,949.204,949.254,949.2519,249.3019,249.3030,249.3530,249.3587,999.4587,999.452017年1月20日