1、 年终奖扣税分析表姓名当月工资年终奖(税前)扣税顾小白¥6,500.00¥46,000.00¥4,495.00罗书全¥3,400.00¥38,000.00¥3,685.00左永邦¥11,500.00¥112,000.00¥26,995.00莫小闵¥3,600.00¥18,500.00¥1,745.00艾米¥4,000.00¥32,000.00¥3,095.00米琪¥5,500.00¥62,000.00¥11,845.00凯莉¥21,000.00¥150,000.00¥36,495.00黄小仙¥3,300.00¥18,900.00¥1,765.00王小贱¥5,600.00¥28,000.00¥2
2、,695.00¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥
3、-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥
4、-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥
5、-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-¥-年终奖(税后)提醒¥41,505.00 正常¥34,315.00 正常¥85,005.00 亏大了哟(帮忙调整一下吧)¥16,755.00 亏大了哟(帮忙调整一下吧)¥28,905.00 正常¥50,155.00 正常¥113,505.00 正常¥17,135.00 亏大了哟(帮忙调整一下吧)¥25,305.00 正常¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/
6、A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A 年终奖扣税分析表¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
7、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
8、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
9、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
10、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
11、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
12、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
13、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
14、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-
15、#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A¥-#N/A【小技巧:快速插入个税计算公式】http:/ 21 11 13 32 2此公式已在新春版中提供。http:/第2步:定位到待输入公式的单元格(例如:E6单元格)打开函数对话框(参见下图),输入对应的参数后,点击【插入公式】1 13 32 2此公式已在新春版中提供。http:/以以下下是是参参考考数数据据,在在sheet:sheet:年年终终奖奖扣扣税税计计算算中中被被使使用用到到。税前金额 税率速算扣除数 税后金额00001800030174605400010105487051080002055586955420000251005316005660000302755464755960000355055629055