2019新个税工资表带公式自动计算表

工资表,单位名称：年月：43647.0制表人：,序号姓名工号基本工资绩效奖金加班福利津贴其它应发迟到扣款预支其它应扣社保公积金个税实发工资签名,1.0小敏4300.0500.0100.0300.017.555567.45,2.0小青5684.0461.0520.0515.0367.064.0233.0224.048.336562.67,3.0小红4501.0666.0624.0491.0658.099.0211.0289.027.785898.22,4.0小贾5817.0356.0639.0505.0618.064.0218.0257.059.436921.57,5.0小骨5133.0598.0534.0359.0527.051.0269.0259.034.716122.29,6.0小蓝5751.0685.0633.0368.0621.081.0231.0263.062.047005.96,7.0小花4486.0499.0567.0371.0655.060.0202.021.035679.97,8.0小童6149.0683.0502.0343.0384.057.0248.0211.063.97066.1,9.0小张5306.0611.0699.0690.0338.095.0247.0282.048.156556.85,10.0小名6175.0680.0374.0439.0502.096.0276.0270.063.397049.61,11.0小陈4835.0389.0427.0503.0689.063.0221.0227.027.515889.49,12.0小康4950.0565.0373.0322.0443.098.0300.0205.019.055615.95,13.0小华6004.0652.0493.0420.0431.065.0247.0237.061.086974.92,14.0华华5306.0578.0395.0516.0622.071.0245.0296.041.76348.3,15.0纷纷6195.0321.0588.0328.0534.072.0227.0288.058.926905.08,16.0老陈6177.0361.0569.0458.0515.081.0226.0290.062.047005.96,17.0小刘4442.0334.0636.0627.0518.083.0272.0290.014.915482.09,18.0小蔡5271.0527.0358.0449.0576.063.0222.0282.035.976163.03,用户须知,第一步：将红色框内的内容（姓名到公积金）改为自己的内容数据即可,第二步：个税、实发工资项含公式会自动计算（按新个税5000起征点执行）