个税年度汇算计算表(2019年新个税法)
- 格式:xlsx
- 大小:41.77 KB
- 文档页数:4
1、本表灰色区域一般都有公式,清除前请看好
2、申报个税为发放月份的次月,所以一个纳税年度内应纳的个人所得税应以发放时间为准
3、如要进行自我加工,可填加行或列,但尽量不要在有公式的行或列所在行点击增加,比如表中最下方的合计行
个人所得税预扣率表-2019版
(居民个人工资、薪金所得预扣预缴适用)
级数累计预扣预缴应纳税所得额预扣率(%)
1不超过36000元的部分3
2超过36000元至144000元的部分10
3超过144000元至300000元的部分20
4超过300000元至420000元的部分25
5超过420000元至660000元的部分30
6超过660000元至960000元的部分35
7超过960000元的部分45
得税应以发放时间为准
所在行点击增加,比如表中最下方的合计行。
用)
速算扣除数
2520
16920
31920
52920
85920
181920。
应发薪资序号姓名身份证号部门入职时间基本薪资岗位津贴工龄薪资全勤奖绩效奖共计加班补贴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加项应扣薪资通信补贴过节费共计应出勤天实质出勤告假扣款迟到扣款共计数天数-19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00---19.0019.00--收入今年截止先期累本期收入今年累计收社保基数计收入入30,000.006,500.0036,500.004,000.00 34,500.007,500.0042,000.004,000.00 39,000.008,500.0047,500.004,000.00 43,500.009,500.0053,000.004,000.00 48,000.0010,500.0058,500.004,000.00 52,500.0011,500.0064,000.004,000.00 57,000.0012,500.0069,500.004,000.00 61,500.0013,500.0075,000.004,000.00 66,000.0014,500.0080,500.004,000.00 70,500.0015,500.0086,000.004,000.00 73,000.0016,000.0089,000.004,000.00 77,500.0017,000.0094,500.004,000.00 82,000.0018,000.00100,000.004,000.00 86,500.0019,000.00105,500.004,000.00 91,000.0020,000.00111,000.004,000.00 95,500.0021,000.00116,500.004,000.00 100,000.0022,000.00122,000.004,000.00 104,500.0023,000.00127,500.004,000.00 109,000.0024,000.00133,000.004,000.00 113,500.0025,000.00138,500.004,000.00 118,000.0026,000.00144,000.004,000.00 122,500.0027,000.00149,500.004,000.00 127,000.0028,000.00155,000.004,000.00 131,500.0029,000.00160,500.004,000.00 136,000.0030,000.00166,000.004,000.00 140,500.0031,000.00171,500.004,000.00 145,000.0032,000.00177,000.004,000.00 149,500.0033,000.00182,500.004,000.00 154,000.0034,000.00188,000.004,000.00 158,500.0035,000.00193,500.004,000.00 163,000.0036,000.00199,000.004,000.00养老保险基本医疗保险社保基数单位单位( 16%)个人( 8%)个人( 2%)(6.5%)640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.00640.00320.004,000.00260.0080.002019版最新个人所得税计算表( 自动生成薪资表薪资条)六险一金工伤保险失业保险生育保险重病医疗保共计住宅公积金今年从前累险住宅基数单位个人单位单位(0.1%)单位( 1%)单位个人单位(12%)个人(12%)养老保险(0.6%)(0.4%)(0.8%)4.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.001,664.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.001,664.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.001,664.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.004.0024.0016.0032.0040.001,000.00416.004,000.00480.00480.002,080.00条)专项扣除额从前累计本期今年累计今年截止上期累计住宅公积养老保住宅公积小计儿女教奉养老住宅贷款住宅租养老保险住宅公积金金险金育人利息金1,920.00416.00480.002,080.002,400.004,480.002,000.002,000.004,000.00-1,920.00416.00480.002,080.002,400.004,480.002,000.002,000.004,000.00-1,920.00416.00480.002,080.002,400.004,480.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-1,920.00416.00480.002,496.002,400.004,896.002,000.002,000.004,000.00-附带扣除额本月发生今年累计持续教儿女教奉养老住宅贷款住宅租持续教儿女教奉养老住宅贷住宅租持续教育育人利息金育育人款利息金育1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00 1,600.00500.00500.001,000.00400.002,500.002,500.005,000.00-2,000.00累计减除花费税款缴纳应纳税所得额税率速算扣除应钠税数额今年先期累今年应钠本期缴纳小计减除花费月计已交税款税款税款12,000.005,000.006.00-3%-----12,000.005,000.006.00-3%-----12,000.005,000.006.001,020.003%-30.60-30.6030.60 12,000.005,000.006.006,104.003%-183.12 2.52183.12180.60 12,000.005,000.006.0011,604.003%-348.1217.52348.12330.60 12,000.005,000.006.0017,104.003%-513.1232.52513.12480.60 12,000.005,000.006.0022,604.003%-678.1247.52678.12630.60 12,000.005,000.006.0028,104.003%-843.1262.52843.12780.60 12,000.005,000.006.0033,604.003%-1,008.1277.521,008.12930.60 12,000.005,000.006.0039,104.0010%2,520.001,390.4092.521,390.401,297.88 12,000.005,000.006.0042,104.0010%2,520.001,690.40107.521,690.401,582.88 12,000.005,000.006.0047,604.0010%2,520.002,240.402,642.522,240.40-402.12 12,000.005,000.006.0053,104.0010%2,520.002,790.402,657.522,790.40132.88 12,000.005,000.006.0058,604.0010%2,520.003,340.405,192.523,340.40-1,852.12 12,000.005,000.006.0064,104.0010%2,520.003,890.405,207.523,890.40-1,317.12 12,000.005,000.006.0069,604.0010%2,520.004,440.405,222.524,440.40-782.12 12,000.005,000.006.0075,104.0010%2,520.004,990.405,237.524,990.40-247.12 12,000.005,000.006.0080,604.0010%2,520.005,540.407,772.525,540.40-2,232.12 12,000.005,000.006.0086,104.0010%2,520.006,090.407,787.526,090.40-1,697.12 12,000.005,000.006.0091,604.0010%2,520.006,640.407,802.526,640.40-1,162.12 12,000.005,000.006.0097,104.0010%2,520.007,190.407,817.527,190.40-627.12 12,000.005,000.006.00102,604.0010%2,520.007,740.407,832.527,740.40-92.12 12,000.005,000.006.00108,104.0010%2,520.008,290.407,847.528,290.40442.88 12,000.005,000.006.00113,604.0010%2,520.008,840.407,862.528,840.40977.88 12,000.005,000.006.00119,104.0010%2,520.009,390.407,877.529,390.401,512.88 12,000.005,000.006.00124,604.0010%2,520.009,940.407,892.529,940.402,047.88 12,000.005,000.006.00130,104.0010%2,520.0010,490.407,907.5210,490.402,582.88 12,000.005,000.006.00135,604.0010%2,520.0011,040.4010,442.5211,040.40597.88 12,000.005,000.006.00141,104.0010%2,520.0011,590.4010,457.5211,590.401,132.88 12,000.005,000.006.00146,604.0020%16,920.0012,400.8010,472.5212,400.801,928.28 12,000.005,000.006.00152,104.0020%16,920.0013,500.8010,487.5213,500.803,013.28本月实发工应补(退)税资款-5,604.00-6,604.0030.607,573.40180.608,423.40330.609,273.40480.6010,123.40630.6010,973.40780.6011,823.40930.6012,673.401,297.8813,306.121,582.8813,521.12-402.1216,506.12132.8816,971.12 -1,852.1219,956.12-1,317.1220,421.12-782.1220,886.12-247.1221,351.12-2,232.1224,336.12-1,697.1224,801.12-1,162.1225,266.12-627.1225,731.12-92.1226,196.12442.8826,661.12977.8827,126.121,512.8827,591.122,047.8828,056.122,582.8828,521.12597.8831,506.121,132.8831,971.121,928.2832,175.723,013.2832,090.72。
20
=ROUND(MAX(Q3*0.01*{3,10,20,25,30,35,45}-{0,2520,16920,31920,52920,85920,181920},0),2)
注释:
1)公式在R3输入;
2)Q3为扣除起征点、“五险一金”、各种税法准许的扣除项后的工资额
3){0.03;0.1;0.2;0.25;0.3;0.35;0.45}为税率数组;
4){0;105;555;1005;2755;5505;13505}为对应的速算扣除数数组。
这个公式的意思的是,工资总额减去起征点5000、“五险一金”、各种税法给予扣除项后,乘以税率,再减去速算MAX(Q3*0.01*{3,10,20,25,30,35,45}-{0,2520,16920,31920,52920,85920,181920},0)返回的也是一个数组,共有也就是说,如果得出的结果全部是负数,那么返回的最大值就是0值(免征个税)。
5920,181920},0),2)
予扣除项后,乘以税率,再减去速算扣除数。
而用大括号{}包起来的代表数组,所以
1920},0)返回的也是一个数组,共有7个数值(可能有正数和负数,可能全部为正数,还有可能全部为负数)。
但是我们知道
-4932.37
可能全部为负数)。
但是我们知道应缴税额不能为负数。
所以,最后通过MAX函数把这七个数值,额外加一个0值一起做比较,
应补交(或退税)额
0值一起做比较,取最大值。