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

1 1月月工工资资表表序号姓名身份证号部门入职时间应应发发工工资资加加项项应应扣扣工工资资基本工资岗位津贴工龄工资全勤奖绩效奖合计加班补助通讯补贴过节费合计应出勤天数实际出勤天数请假扣款迟到扣款合计00014,000.004,000.00-22.0022.00-00024,500.004,500.00-22.0022.00-00035,000.005,000.00-22.0022.00-00045,500.005,500.00-22.0022.00-00056,000.006,000.00-22.0022.00-00066,500.006,500.00-22.0022.00-00077,000.007,000.00-22.0022.00-00087,500.007,500.00-22.0022.00-00098,000.008,000.00-22.0022.00-00108,500.008,500.00-22.0022.00-00119,000.009,000.00-22.0022.00-00129,500.009,500.00-22.0022.00-001310,000.0010,000.00-22.0022.00-001410,500.0010,500.00-22.0022.00-001511,000.0011,000.00-22.0022.00-001611,500.0011,500.00-22.0022.00-001712,000.0012,000.00-22.0022.00-001812,500.0012,500.00-22.0022.00-001913,000.0013,000.00-22.0022.00-002013,500.0013,500.00-22.0022.00-002114,000.0014,000.00-22.0022.00-002214,500.0014,500.00-22.0022.00-002315,000.0015,000.00-22.0022.00-002415,500.0015,500.00-22.0022.00-002516,000.0016,000.00-22.0022.00-002616,500.0016,500.00-22.0022.00-002717,000.0017,000.00-22.0022.00-002817,500.0017,500.00-22.0022.00-002918,000.0018,000.00-22.0022.00-003018,500.0018,500.00-22.0022.00-003119,000.0019,000.00-22.0022.00-收收入入六六险险一一金金专专项项扣扣除除额额本年截止前期累计收入本期收入本年累计收入社保基数养老保险社保基数基本医疗保险工伤保险失业保险生育保险大病医疗保险合计住房基数住房公积金本年以前累计单位（16%）个人（8%）单位（6.5%）个人（2%）单位(0.1%)单位（0.6%）个人（0.4%）单位（0.8%）单位（1%）单位个人单位(12%)个人(12%)养老保险住房公积金4,000.004,000.00-4,500.004,500.00-5,000.005,000.00-5,500.005,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-6,000.006,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-6,500.006,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-7,000.007,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-7,500.007,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-8,000.008,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-8,500.008,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-9,000.009,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-9,500.009,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-10,000.0010,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-10,500.0010,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-11,000.0011,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-11,500.0011,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-12,000.0012,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-12,500.0012,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-13,000.0013,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-13,500.0013,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-14,000.0014,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-14,500.0014,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-15,000.0015,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-15,500.0015,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-16,000.0016,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-1 1月月工工资资表表16,500.0016,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-17,000.0017,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-17,500.0017,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-18,000.0018,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-18,500.0018,500.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-19,000.0019,000.004,000.00640.00320.004,000.00260.0080.004.0024.0016.0032.0040.001,000.00416.00-附附加加扣扣除除额额累计减除费用本期本年累计小计本年截止上期累计本月发生本年累计小计减除费用月养老保险住房公积金养老保险住房公积金子女教育赡养老人住房贷款利息住房租金继续教育子女教育赡养老人住房贷款利息住房租金继续教育子女教育赡养老人住房贷款利息住房租金继续教育-5,000.001.00-5,000.001.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00专专项项扣扣除除额额416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00416.00-416.00-416.00-5,000.001.00应纳税所得额税率速算扣除数应钠税额税款缴纳本月实发工资本年前期累计已交税款本年应钠税款本期缴纳税款应补（退）税款-3%-4,000.00-3%-4,500.00-3%-5,000.0084.003%-2.522.522.522.522.525,081.48584.003%-17.5217.5217.5217.5217.525,566.481,084.003%-32.5232.5232.5232.5232.526,051.481,584.003%-47.5247.5247.5247.5247.526,536.482,084.003%-62.5262.5262.5262.5262.527,021.482,584.003%-77.5277.5277.5277.5277.527,506.483,084.003%-92.5292.5292.5292.5292.527,991.483,584.003%-107.52107.52107.52107.52107.528,476.484,084.003%-122.52122.52122.52122.52122.528,961.484,584.003%-137.52137.52137.52137.52137.529,446.485,084.003%-152.52152.52152.52152.52152.529,931.485,584.003%-167.52167.52167.52167.52167.5210,416.486,084.003%-182.52182.52182.52182.52182.5210,901.486,584.003%-197.52197.52197.52197.52197.5211,386.487,084.003%-212.52212.52212.52212.52212.5211,871.487,584.003%-227.52227.52227.52227.52227.5212,356.488,084.003%-242.52242.52242.52242.52242.5212,841.488,584.003%-257.52257.52257.52257.52257.5213,326.489,084.003%-272.52272.52272.52272.52272.5213,811.489,584.003%-287.52287.52287.52287.52287.5214,296.4810,084.003%-302.52302.52302.52302.52302.5214,781.4810,584.003%-317.52317.52317.52317.52317.5215,266.4811,084.003%-332.52332.52332.52332.52332.5215,751.4811,584.003%-347.52347.52347.52347.52347.5216,236.4812,084.003%-362.52362.52362.52362.52362.5216,721.4812,584.003%-377.52377.52377.52377.52377.5217,206.4813,084.003%-392.52392.52392.52392.52392.5217,691.4813,584.003%-407.52407.52407.52407.52407.5218,176.482月月工工资资表表序号姓名身份证号 部门 入职时间应应发发工工资资加加项项基本工资岗位津贴工龄工资全勤奖绩效奖合计加班补助00016,000.00500.006,500.0000027,000.00500.007,500.0000038,000.00500.008,500.0000049,000.00500.009,500.00000510,000.00500.0010,500.00000611,000.00500.0011,500.00000712,000.00500.0012,500.00000813,000.00500.0013,500.00000914,000.00500.0014,500.00001015,000.00500.0015,500.00001116,000.0016,000.00001217,000.0017,000.00001318,000.0018,000.00001419,000.0019,000.00001520,000.0020,000.00001621,000.0021,000.00001722,000.0022,000.00001823,000.0023,000.00001924,000.0024,000.00002025,000.0025,000.00002126,000.0026,000.00002227,000.0027,000.00002328,000.0028,000.00002429,000.0029,000.00002530,000.0030,000.00002631,000.0031,000.00002732,000.0032,000.00002833,000.0033,000.00002934,000.0034,000.00003035,000.0035,000.00003136,000.0036,000.00应应扣扣工工资资通讯补贴过节费合计应出勤天数实际出勤天数请假扣款 迟到扣款合计-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-17.0017.00-加加项项-17.0017.00-17.0017.00-收收入入六六险险一一金金本年截止前期累计收入本期收入本年累计收入社保基数养老保险社保基数基本医疗保险单位（16%）个人（8%）单位（6.5%）个人（2%）4,000.006,500.0010,500.004,000.00640.00320.004,000.00260.0080.004,500.007,500.0012,000.004,000.00640.00320.004,000.00260.0080.005,000.008,500.0013,500.004,000.00640.00320.004,000.00260.0080.005,500.009,500.0015,000.004,000.00640.00320.004,000.00260.0080.006,000.0010,500.0016,500.004,000.00640.00320.004,000.00260.0080.006,500.0011,500.0018,000.004,000.00640.00320.004,000.00260.0080.007,000.0012,500.0019,500.004,000.00640.00320.004,000.00260.0080.007,500.0013,500.0021,000.004,000.00640.00320.004,000.00260.0080.008,000.0014,500.0022,500.004,000.00640.00320.004,000.00260.0080.008,500.0015,500.0024,000.004,000.00640.00320.004,000.00260.0080.009,000.0016,000.0025,000.004,000.00640.00320.004,000.00260.0080.009,500.0017,000.0026,500.004,000.00640.00320.004,000.00260.0080.0010,000.0018,000.0028,000.004,000.00640.00320.004,000.00260.0080.0010,500.0019,000.0029,500.004,000.00640.00320.004,000.00260.0080.0011,000.0020,000.0031,000.004,000.00640.00320.004,000.00260.0080.0011,500.0021,000.0032,500.004,000.00640.00320.004,000.00260.0080.0012,000.0022,000.0034,000.004,000.00640.00320.004,000.00260.0080.0012,500.0023,000.0035,500.004,000.00640.00320.004,000.00260.0080.0013,000.0024,000.0037,000.004,000.00640.00320.004,000.00260.0080.0013,500.0025,000.0038,500.004,000.00640.00320.004,000.00260.0080.0014,000.0026,000.0040,000.004,000.00640.00320.004,000.00260.0080.0014,500.0027,000.0041,500.004,000.00640.00320.004,000.00260.0080.0015,000.0028,000.0043,000.004,000.00640.00320.004,000.00260.0080.0015,500.0029,000.0044,500.004,000.00640.00320.004,000.00260.0080.0016,000.0030,000.0046,000.004,000.00640.00320.004,000.00260.0080.0016,500.0031,000.0047,500.004,000.00640.00320.004,000.00260.0080.0017,000.0032,000.0049,000.004,000.00640.00320.004,000.00260.0080.0017,500.0033,000.0050,500.004,000.00640.00320.004,000.00260.0080.0018,000.0034,000.0052,000.004,000.00640.00320.004,000.00260.0080.0018,500.0035,000.0053,500.004,000.00640.00320.004,000.00260.0080.0019,000.0036,000.0055,000.004,000.00640.00320.004,000.00260.0080.00专专项项扣扣除除额额工伤保险失业保险生育保险大病医疗保险合计住房基数住房公积金本年以前累计单位(0.1%)单位（0.6%）个人（0.4%）单位（0.8%）单位（1%）单位个人单位(12%)个人(12%)养老保险4.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00-4.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00-4.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00-4.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.002月月工工资资表表六六险险一一金金4.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.00416.00附附加加扣扣除除额额本期本年累计小计本年截止上期累计住房公积金 养老保险 住房公积金养老保险住房公积金子女教育赡养老人住房贷款利息住房租金继续教育-416.00480.00416.00480.00896.00-416.00480.00416.00480.00896.00-416.00480.00416.00480.00896.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-专专项项扣扣除除额额本年以前累计-416.00480.00832.00480.001,312.00-416.00480.00832.00480.001,312.00-本月发生本年累计小计子女教育赡养老人住房贷款利息住房租金继续教育子女教育赡养老人住房贷款利息住房租金继续教育500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00附附加加扣扣除除额额500.00500.001,000.00400.00500.00500.001,000.00-400.002,400.00500.00500.001,000.00400