2019年新个税简便计算模板(带公式)

1、月月份份姓姓名名子子女女教教育育继继续续教教育育大大病病医医疗疗房房贷贷利利息息住住房房租租金金赡赡养养老老人人合合计计1杨庆东100040040011000200049001任继先100040012007000100043001陈尚武10004007009000200050001李光明10004007003000024001李厚辉1000400170017000048001毕淑华100040090015000100048001赵会芳100040040018000036001赖群毅10004007000800200049002杨庆东100040011008000100043002任继先1000

2、40012006000100042002张鹤翔100040004000018002王丽卿10004009001000100034002李厚辉100040019000800100051002毕淑华1000400170017000048002赵会芳10004007005000026002赖群毅1000400150016000200065003杨庆东100040080017000100049003任继先100040090018000200061003张鹤翔100040013004000200051003王丽卿100040016009000100049003李厚辉1000400180014000200

3、066003毕淑华100040090019000042003赵会芳10004009009000032003赖群毅100040015008000200057003杨庆东100040018002000200054004任继先1000400120013000200059004张鹤翔10004006003000023004王丽卿1000400130011000038004李厚辉100040010006000030004施文庆100040090011000100044004李承谦1000400190018000200071004赖群毅100040016001000100041004向建荣10004001

4、1008000033004沙志昭10004005004000200043005胡孟祥100040010007000200051005王丽卿100040007000200041005李厚辉10004002009000025005毕淑华1000400100011000035005赵会芳100040010001000100035005赖群毅100040016007000100047005陆艳菲100040013001000028005杨庆东1000400170012000100053005任继先1000400190017000200070006陈尚武1000400160017000100057006

5、李光明100040014006000034006李厚辉100040015008000200057006毕淑华100040014003000100041006赖群毅100040040015000033006陈尚武1000400190019000052006李光明100040060015000200055006李厚辉100040017009000100050006毕淑华100040003000200037007赵会芳100040012008000200054007赖群毅1000400170019000100060007李从林1000400130012000039007张鹤翔100040015009

6、000038007任继先100040050016000100045007陈尚武100040011005000200050007李光明1000400120012000038007李厚辉100040010003000200047007毕淑华1000400190010000043008赵会芳100040010011000100036008赖群毅10004003004000100031008李从林10004008009000031008向建荣100040020019000035008沙志昭1000400150016000045008胡孟祥10004001000800023008王丽卿100040070

7、010000200051008李厚辉100040018002000034008毕淑华100040019008000200061009赵会芳1000400150017000200066009赖群毅100040017001000100042009向建荣100040050014000033009沙志昭100040005000100029009胡孟祥100040080017000039009王丽卿10004002006000100032009李厚辉10004008009000200051009毕淑华10004008005000027009赵会芳10004001300120001000490010赖群毅

8、1000400300110000280010向建荣100040060040001000340010沙志昭100040080060001000380010胡孟祥100040070080000290010王丽卿100040080090000310010李厚辉10004000170000310010毕淑华10004001300100002000570010赵会芳100040060008002000480010赖群毅10004000110002000450011向建荣1000400700140000350011沙志昭10004001500180001000570011胡孟祥10004001100110

9、002000560011王丽卿10004001800160000480011李厚辉1000400200100002000460011毕淑华1000400130008000350011赵会芳100040020010000170011向建荣100040040040002000420012沙志昭100040080040002000460012胡孟祥100040020010002000370012王丽卿1000400170080000390012李厚辉10004001900160000490012毕淑华1000400500150001000440012赵会芳1000400200400010003000

10、12赖群毅10004007001300003400姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计本本月月应应缴缴杨庆东113001000490010900400.0012.0012.00任继先1500010004300103004,700.00141.00141.00陈尚武130009005000109002,100.0063.0063.00李光明120001100240085003,500.00105.00105.00李厚辉9600400480010200-600.00-毕淑华8000500480010300-

11、2,300.00-赵会芳990060036009200700.0021.0021.00赖群毅1300012004900111001,900.0057.0057.00环环宇宇集集团团2 2月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计本本月月应应缴缴杨庆东16000500430098006,600.00198.00186.00任继先123309004200101006,930.00207.9066.90张鹤翔11230900180077003,530.00105.90105.90王丽卿10580

12、400340088001,780.0053.4053.40李厚辉1342011005100112001,620.0048.6048.60毕淑华10570600480010400-2,130.00-赵会芳350050026008100-3,900.00-21.00赖群毅132509006500124002,750.0082.5025.50环环宇宇集集团团3 3月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计杨庆东16000110010300164006,200.00186.00任继先1233010

13、006100121007,160.00214.80张鹤翔1123010005100111003,660.00109.80王丽卿105809004900108001,560.0046.80李厚辉134206006600122002,840.0085.20毕淑华105701200420010400-1,960.00-赵会芳1122050032008700-1,380.00-赖群毅132509005700116004,400.00132.00本本月月应应缴缴-12.006.903.90-6.6036.60-49.50环环宇宇集集团团3 3月月份份工工资资表表环环宇宇集集团团4 4月月份份工工资资表表

14、姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计杨庆东1600011000610016,100.00483.00任继先1233010005900119007,590.00227.70张鹤翔112301000230083006,590.00197.70王丽卿10580900380097002,440.0073.20李厚辉13420600300086007,660.00229.80施文庆105701200440010600-30.00-李承谦11220500710012600-1,380.00-赖群毅132509004

15、100100007,650.00229.50本本月月应应缴缴297.0012.9087.9026.40144.60-97.50环环宇宇集集团团4 4月月份份工工资资表表环环宇宇集集团团5 5月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计向建荣160009000590010,100.00303.00沙志昭12330700057006,630.00198.90胡孟祥11230800510010900330.009.90王丽卿1058012004100103002,720.0081.60李厚辉134

16、204002500790013,180.00395.40毕淑华10570110035009600970.0029.10赵会芳600120035009700-9,100.00-赖群毅13250120047001090010,000.00300.00本本月月应应缴缴303.00198.909.908.40165.6029.10-70.50环环宇宇集集团团5 5月月份份工工资资表表环环宇宇集集团团6 6月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计陆艳菲160001200062009,800.002

17、94.00杨庆东12330400054006,930.00207.90任继先11230600056005,630.00168.90陈尚武105809001090016800-6,220.00-李光明134201100890015000-1,580.00-李厚辉10570120010700169006,850.00205.50毕淑华11220700780013500-1,310.00-赖群毅1325011003300940013,850.00415.50本本月月应应缴缴294.00207.90168.90-189.90-29.10115.50环环宇宇集集团团6 6月月份份工工资资表表环环宇宇集集

18、团团7 7月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计陈尚武160001100500011100-1,320.00-李光明12330100038009800950.0028.50李厚辉1123012004700109007,180.00215.40毕淑华10580900430010200-930.00-赵会芳134204005400108002,620.0078.60赖群毅1057080060001180012,620.00378.60李从林11220700390096001,620.004

19、8.60张鹤翔13250500380093003,950.00118.50本本月月应应缴缴-28.509.90-78.60-36.9048.60118.50环环宇宇集集团团7 7月月份份工工资资表表环环宇宇集集团团8 8月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计任继先1600010000600010,000.00300.00陈尚武12330500055005,510.00165.30李光明112301000060006,180.00185.40李厚辉10580800340092008,56

20、0.00256.80毕淑华134201000610012100390.0011.70赵会芳105701000360096003,590.00107.70赖群毅150006003100870018,920.00567.60李从林13250700310088006,070.00182.10本本月月应应缴缴300.00165.30156.9041.4011.7029.10189.00133.50环环宇宇集集团团8 8月月份份工工资资表表环环宇宇集集团团9 9月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累

21、计计向建荣16000800330091006,900.00207.00沙志昭12330400290083004,030.00120.90胡孟祥11230500390094001,830.0054.90王丽卿105801000320092001,380.0041.40李厚辉1342090051001100010,980.00329.40毕淑华105701200270089002,060.0061.80赵会芳113006001150017100-2,210.00-赖群毅1325080042001000022,170.00665.10本本月月应应缴缴207.00120.9054.9041.4072.

22、6050.10-107.7097.50环环宇宇集集团团9 9月月份份工工资资表表环环宇宇集集团团1010月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累累计计向建荣160008003400920013,700.00411.00沙志昭12330400380092007,160.00214.80胡孟祥11230500290084004,660.00139.80王丽卿105801000310091002,860.0085.80李厚辉134209003100900015,400.00462.00毕淑华105701200570011900730.0021.90赵会芳9500600480010400-3,110.00-赖群毅1325080073001310022,320.00669.60本本月月应应缴缴204.0093.9084.9044.40132.60-39.90-4.50环环宇宇集集团团1010月月份份工工资资表表环环宇宇集集团团1111月月份份工工资资表表姓姓名名应应发发工工资资三三险险一一金金专专项项扣扣除除合合计计扣扣除除本本年年应应税税工工资资累累计计本本年年个个税税累