2019年新个税计算表-工资表(公式)

6月工资表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

序号,姓名,身份证号,部门,入职时间,应发工资,,,,,,加项,,,,,应扣工资,,,,,,,收入,,,六险一金,,,,,,,,,,,,,,,,专项扣除额,,,,,,,附加扣除额,,,,,,,,,,,,,,,,累计减除费用,,应纳税所得额,税率,速算扣除数,应钠税额,税款缴纳,,,,本月实发工资

,,,,,基本工资,岗位津贴,工龄工资,全勤奖,绩效奖,合计,加班补助,通讯补贴,过节费,,合计,应出勤天数,实际出勤天数,请假扣款,迟到扣款,,,合计,本年截止前期累计收入,本期收入,本年累计收入,社保基数,养老保险,,社保基数,基本医疗保险,,工伤保险,失业保险,,生育保险,大病医疗保险,合计,,住房基数,住房公积金,,本年以前累计,,本期,,本年累计,,小计,本年截止上期累计,,,,,本月发生,,,,,本年累计,,,,,小计,减除费用,月,,,,,本年前期累计已交税款,本年应钠税款,本期缴纳税款,应补（退）税款,

,,,,,,,,,,,,,,,,,,,,,,,,,,,单位（16%）,个人（8%）,,单位（6.5%）,个人（2%）,单位(0.1%),单位（0.6%）,个人（0.4%）,单位（0.8%）,单位（1%）,单位,个人,,单位(12%),个人(12%),养老保险,住房公积金,养老保险,住房公积金,养老保险,住房公积金,,子女教育,赡养老人,住房贷款利息,住房租金,继续教育,子女教育,赡养老人,住房贷款利息,住房租金,继续教育,子女教育,赡养老人,住房贷款利息,住房租金,继续教育,,,,,,,,,,,,

,,0001,,,"6,000.00",,500.00,,,"6,500.00",,,,,-,19.00,19.00,-,,,,-,"30,000.00","6,500.00","36,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"1,664.00","1,920.00",416.00,480.00,"2,080.00","2,400.00","4,480.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,-,3%,-,-,-,-,-,-,"5,604.00"

,,0002,,,"7,000.00",,500.00,,,"7,500.00",,,,,-,19.00,19.00,-,,,,-,"34,500.00","7,500.00","42,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"1,664.00","1,920.00",416.00,480.00,"2,080.00","2,400.00","4,480.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,-,3%,-,-,-,-,-,-,"6,604.00"

,,0003,,,"8,000.00",,500.00,,,"8,500.00",,,,,-,19.00,19.00,-,,,,-,"39,000.00","8,500.00","47,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"1,664.00","1,920.00",416.00,480.00,"2,080.00","2,400.00","4,480.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"1,020.00",3%,-,30.60,-,30.60,30.60,30.60,"7,573.40"

,,0004,,,"9,000.00",,500.00,,,"9,500.00",,,,,-,19.00,19.00,-,,,,-,"43,500.00","9,500.00","53,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"6,104.00",3%,-,183.12,2.52,183.12,180.60,180.60,"8,423.40"

,,0005,,,"10,000.00",,500.00,,,"10,500.00",,,,,-,19.00,19.00,-,,,,-,"48,000.00","10,500.00","58,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"11,604.00",3%,-,348.12,17.52,348.12,330.60,330.60,"9,273.40"

,,0006,,,"11,000.00",,500.00,,,"11,500.00",,,,,-,19.00,19.00,-,,,,-,"52,500.00","11,500.00","64,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"17,104.00",3%,-,513.12,32.52,513.12,480.60,480.60,"10,123.40"

,,0007,,,"12,000.00",,500.00,,,"12,500.00",,,,,-,19.00,19.00,-,,,,-,"57,000.00","12,500.00","69,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"22,604.00",3%,-,678.12,47.52,678.12,630.60,630.60,"10,973.40"

,,0008,,,"13,000.00",,500.00,,,"13,500.00",,,,,-,19.00,19.00,-,,,,-,"61,500.00","13,500.00","75,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"28,104.00",3%,-,843.12,62.52,843.12,780.60,780.60,"11,823.40"

,,0009,,,"14,000.00",,500.00,,,"14,500.00",,,,,-,19.00,19.00,-,,,,-,"66,000.00","14,500.00","80,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"33,604.00",3%,-,"1,008.12",77.52,"1,008.12",930.60,930.60,"12,673.40"

,,0010,,,"15,000.00",,500.00,,,"15,500.00",,,,,-,19.00,19.00,-,,,,-,"70,500.00","15,500.00","86,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"39,104.00",10%,"2,520.00","1,390.40",92.52,"1,390.40","1,297.88","1,297.88","13,306.12"

,,0011,,,"16,000.00",,,,,"16,000.00",,,,,-,19.00,19.00,-,,,,-,"73,000.00","16,000.00","89,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"42,104.00",10%,"2,520.00","1,690.40",107.52,"1,690.40","1,582.88","1,582.88","13,521.12"

,,0012,,,"17,000.00",,,,,"17,000.00",,,,,-,19.00,19.00,-,,,,-,"77,500.00","17,000.00","94,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"47,604.00",10%,"2,520.00","2,240.40","2,642.52","2,240.40",-402.12,-402.12,"16,506.12"

,,0013,,,"18,000.00",,,,,"18,000.00",,,,,-,19.00,19.00,-,,,,-,"82,000.00","18,000.00","100,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"53,104.00",10%,"2,520.00","2,790.40","2,657.52","2,790.40",132.88,132.88,"16,971.12"

,,0014,,,"19,000.00",,,,,"19,000.00",,,,,-,19.00,19.00,-,,,,-,"86,500.00","19,000.00","105,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"58,604.00",10%,"2,520.00","3,340.40","5,192.52","3,340.40","-1,852.12","-1,852.12","19,956.12"

,,0015,,,"20,000.00",,,,,"20,000.00",,,,,-,19.00,19.00,-,,,,-,"91,000.00","20,000.00","111,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"64,104.00",10%,"2,520.00","3,890.40","5,207.52","3,890.40","-1,317.12","-1,317.12","20,421.12"

,,0016,,,"21,000.00",,,,,"21,000.00",,,,,-,19.00,19.00,-,,,,-,"95,500.00","21,000.00","116,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"69,604.00",10%,"2,520.00","4,440.40","5,222.52","4,440.40",-782.12,-782.12,"20,886.12"

,,0017,,,"22,000.00",,,,,"22,000.00",,,,,-,19.00,19.00,-,,,,-,"100,000.00","22,000.00","122,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"75,104.00",10%,"2,520.00","4,990.40","5,237.52","4,990.40",-247.12,-247.12,"21,351.12"

,,0018,,,"23,000.00",,,,,"23,000.00",,,,,-,19.00,19.00,-,,,,-,"104,500.00","23,000.00","127,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"80,604.00",10%,"2,520.00","5,540.40","7,772.52","5,540.40","-2,232.12","-2,232.12","24,336.12"

,,0019,,,"24,000.00",,,,,"24,000.00",,,,,-,19.00,19.00,-,,,,-,"109,000.00","24,000.00","133,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"86,104.00",10%,"2,520.00","6,090.40","7,787.52","6,090.40","-1,697.12","-1,697.12","24,801.12"

,,0020,,,"25,000.00",,,,,"25,000.00",,,,,-,19.00,19.00,-,,,,-,"113,500.00","25,000.00","138,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"91,604.00",10%,"2,520.00","6,640.40","7,802.52","6,640.40","-1,162.12","-1,162.12","25,266.12"

,,0021,,,"26,000.00",,,,,"26,000.00",,,,,-,19.00,19.00,-,,,,-,"118,000.00","26,000.00","144,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"97,104.00",10%,"2,520.00","7,190.40","7,817.52","7,190.40",-627.12,-627.12,"25,731.12"

,,0022,,,"27,000.00",,,,,"27,000.00",,,,,-,19.00,19.00,-,,,,-,"122,500.00","27,000.00","149,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"102,604.00",10%,"2,520.00","7,740.40","7,832.52","7,740.40",-92.12,-92.12,"26,196.12"

,,0023,,,"28,000.00",,,,,"28,000.00",,,,,-,19.00,19.00,-,,,,-,"127,000.00","28,000.00","155,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"108,104.00",10%,"2,520.00","8,290.40","7,847.52","8,290.40",442.88,442.88,"26,661.12"

,,0024,,,"29,000.00",,,,,"29,000.00",,,,,-,19.00,19.00,-,,,,-,"131,500.00","29,000.00","160,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"113,604.00",10%,"2,520.00","8,840.40","7,862.52","8,840.40",977.88,977.88,"27,126.12"

,,0025,,,"30,000.00",,,,,"30,000.00",,,,,-,19.00,19.00,-,,,,-,"136,000.00","30,000.00","166,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"119,104.00",10%,"2,520.00","9,390.40","7,877.52","9,390.40","1,512.88","1,512.88","27,591.12"

,,0026,,,"31,000.00",,,,,"31,000.00",,,,,-,19.00,19.00,-,,,,-,"140,500.00","31,000.00","171,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"124,604.00",10%,"2,520.00","9,940.40","7,892.52","9,940.40","2,047.88","2,047.88","28,056.12"

,,0027,,,"32,000.00",,,,,"32,000.00",,,,,-,19.00,19.00,-,,,,-,"145,000.00","32,000.00","177,000.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.00,"130,104.00",10%,"2,520.00","10,490.40","7,907.52","10,490.40","2,582.88","2,582.88","28,521.12"

,,0028,,,"33,000.00",,,,,"33,000.00",,,,,-,19.00,19.00,-,,,,-,"149,500.00","33,000.00","182,500.00","4,000.00",640.00,320.00,"4,000.00",260.00,80.00,4.00,24.00,16.00,32.00,40.00,"1,000.00",416.00,"4,000.00",480.00,480.00,"2,080.00","1,920.00",416.00,480.00,"2,496.00","2,400.00","4,896.00","2,000.00","2,000.00","4,000.00",-,"1,600.00",500.00,500.00,"1,000.00",,400.00,"2,500.00","2,500.00","5,000.00",-,"2,000.00","12,000.00","5,000.00",6.