《Excel模板：年终奖发放表-计税表(税收筹划).xls》由会员分享，可在线阅读，更多相关《Excel模板：年终奖发放表-计税表(税收筹划).xls（3页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、公司年终奖发放表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,85
2、0.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.
3、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.0
4、0660,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日