累计预扣法个税计算表（2019）.xls

《累计预扣法个税计算表（2019）.xls》由会员分享，可在线阅读，更多相关《累计预扣法个税计算表（2019）.xls（121页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、使用方法：本表仅适用于当月工资薪金计算，不适用劳务所得、稿酬所得等其他所得。当期发放奖金需注意按照奖金个税计算规则进行调整。本表灰色部分公式自动计算，不需填写。本表仅需在无底色单元格填充当月数据。本表所有员工序号需保持不变，新增员工依次向下增加，整体拖动单元格复制公式。本表需逐月依次填写。序序号号姓姓名名身身份份证证件件类类型型 身身份份证证件件号号码码纳纳税税人人识识别别号号是是否否为为非非 居居民民个个人人所所得得项项目目本本月月（次次）情情况况收收入入额额计计算算收收入入1A身份证1000000010000000否工资薪金2B身份证1000000110000001否工资薪金3C身份证10

2、00000210000002否工资薪金4A身份证1000000310000003否工资薪金5B身份证1000000410000004否工资薪金6C身份证1000000510000005否工资薪金7A身份证1000000610000006否工资薪金8B身份证1000000710000007否工资薪金9C身份证1000000810000008否工资薪金10A身份证1000000910000009否工资薪金11B身份证1000001010000010否工资薪金12C身份证1000001110000011否工资薪金13A身份证1000001210000012否工资薪金14B身份证10000013100

3、00013否工资薪金15A身份证1000001410000014否工资薪金16B身份证1000001510000015否工资薪金17A身份证1000001610000016否工资薪金18B身份证1000001710000017否工资薪金19A身份证1000001810000018否工资薪金20B身份证1000001910000019否工资薪金21A身份证1000002010000020否工资薪金22B身份证1000002110000021否工资薪金23A身份证1000002210000022否工资薪金24B身份证1000002310000023否工资薪金25A身份证10000024100000

4、24否工资薪金26B身份证1000002510000025否工资薪金27A身份证1000002610000026否工资薪金28B身份证1000002710000027否工资薪金29A身份证1000002810000028否工资薪金30B身份证1000002910000029否工资薪金31A身份证1000003010000030否工资薪金32B身份证1000003110000031否工资薪金33A身份证1000003210000032否工资薪金34B身份证1000003310000033否工资薪金35A身份证1000003410000034否工资薪金36B身份证1000003510000035否

5、工资薪金37A身份证1000003610000036否工资薪金38B身份证1000003710000037否工资薪金39A身份证1000003810000038否工资薪金40B身份证1000003910000039否工资薪金41A身份证1000004010000040否工资薪金42B身份证1000004110000041否工资薪金43A身份证1000004210000042否工资薪金44B身份证1000004310000043否工资薪金45A身份证1000004410000044否工资薪金46B身份证1000004510000045否工资薪金47A身份证1000004610000046否工资薪

6、金48B身份证1000004710000047否工资薪金49A身份证1000004810000048否工资薪金50B身份证1000004910000049否工资薪金51A身份证1000005010000050否工资薪金52B身份证1000005110000051否工资薪金53A身份证1000005210000052否工资薪金54B身份证1000005310000053否工资薪金55A身份证1000005410000054否工资薪金56B身份证1000005510000055否工资薪金57A身份证1000005610000056否工资薪金58B身份证1000005710000057否工资薪金59

7、A身份证1000005810000058否工资薪金60B身份证1000005910000059否工资薪金61A身份证1000006010000060否工资薪金62B身份证1000006110000061否工资薪金63A身份证1000006210000062否工资薪金64B身份证1000006310000063否工资薪金65A身份证1000006410000064否工资薪金66B身份证1000006510000065否工资薪金67A身份证1000006610000066否工资薪金68B身份证1000006710000067否工资薪金69A身份证1000006810000068否工资薪金70B身份

8、证1000006910000069否工资薪金71A身份证1000007010000070否工资薪金72B身份证1000007110000071否工资薪金73A身份证1000007210000072否工资薪金74B身份证1000007310000073否工资薪金75A身份证1000007410000074否工资薪金76B身份证1000007510000075否工资薪金77A身份证1000007610000076否工资薪金78B身份证1000007710000077否工资薪金79A身份证1000007810000078否工资薪金80B身份证1000007910000079否工资薪金81A身份证10

9、00008010000080否工资薪金82B身份证1000008110000081否工资薪金83A身份证1000008210000082否工资薪金84B身份证1000008310000083否工资薪金85A身份证1000008410000084否工资薪金86B身份证1000008510000085否工资薪金87A身份证1000008610000086否工资薪金88B身份证1000008710000087否工资薪金89A身份证1000008810000088否工资薪金90B身份证1000008910000089否工资薪金91A身份证1000009010000090否工资薪金92B身份证10000

10、09110000091否工资薪金93A身份证1000009210000092否工资薪金94B身份证1000009310000093否工资薪金95A身份证1000009410000094否工资薪金96B身份证1000009510000095否工资薪金97A身份证1000009610000096否工资薪金98B身份证1000009710000097否工资薪金99A身份证1000009810000098否工资薪金100B身份证1000009910000099否工资薪金101A身份证1000010010000100否工资薪金102B身份证1000010110000101否工资薪金103A身份证1000

11、010210000102否工资薪金104B身份证1000010310000103否工资薪金105A身份证1000010410000104否工资薪金106B身份证1000010510000105否工资薪金107A身份证1000010610000106否工资薪金108B身份证1000010710000107否工资薪金109A身份证1000010810000108否工资薪金110B身份证1000010910000109否工资薪金111A身份证1000011010000110否工资薪金112B身份证1000011110000111否工资薪金113A身份证1000011210000112否工资薪金114

12、B身份证1000011310000113否工资薪金115A身份证1000011410000114否工资薪金116B身份证1000011510000115否工资薪金117A身份证1000011610000116否工资薪金118B身份证1000011710000117否工资薪金119A身份证1000011810000118否工资薪金120B身份证1000011910000119否工资薪金121A身份证1000012010000120否工资薪金122B身份证1000012110000121否工资薪金123A身份证1000012210000122否工资薪金124B身份证1000012310000123

13、否工资薪金125A身份证1000012410000124否工资薪金126B身份证1000012510000125否工资薪金127A身份证1000012610000126否工资薪金128B身份证1000012710000127否工资薪金129A身份证1000012810000128否工资薪金130B身份证1000012910000129否工资薪金131A身份证1000013010000130否工资薪金132B身份证1000013110000131否工资薪金133A身份证1000013210000132否工资薪金134B身份证1000013310000133否工资薪金135A身份证10000134

14、10000134否工资薪金136B身份证1000013510000135否工资薪金137A身份证1000013610000136否工资薪金138B身份证1000013710000137否工资薪金139A身份证1000013810000138否工资薪金140B身份证1000013910000139否工资薪金141A身份证1000014010000140否工资薪金142B身份证1000014110000141否工资薪金143A身份证1000014210000142否工资薪金144B身份证1000014310000143否工资薪金145A身份证1000014410000144否工资薪金146B身份证

15、1000014510000145否工资薪金147A身份证1000014610000146否工资薪金148B身份证1000014710000147否工资薪金149A身份证1000014810000148否工资薪金150B身份证1000014910000149否工资薪金151A身份证1000015010000150否工资薪金152B身份证1000015110000151否工资薪金153A身份证1000015210000152否工资薪金154B身份证1000015310000153否工资薪金155A身份证1000015410000154否工资薪金156B身份证1000015510000155否工资薪

16、金157A身份证1000015610000156否工资薪金158B身份证1000015710000157否工资薪金159A身份证1000015810000158否工资薪金160B身份证1000015910000159否工资薪金161A身份证1000016010000160否工资薪金162B身份证1000016110000161否工资薪金163A身份证1000016210000162否工资薪金164B身份证1000016310000163否工资薪金165A身份证1000016410000164否工资薪金166B身份证1000016510000165否工资薪金167A身份证100001661000

17、0166否工资薪金168B身份证1000016710000167否工资薪金169A身份证1000016810000168否工资薪金170B身份证1000016910000169否工资薪金171A身份证1000017010000170否工资薪金172B身份证1000017110000171否工资薪金173A身份证1000017210000172否工资薪金174B身份证1000017310000173否工资薪金175A身份证1000017410000174否工资薪金176B身份证1000017510000175否工资薪金177A身份证1000017610000176否工资薪金178B身份证1000

18、017710000177否工资薪金179A身份证1000017810000178否工资薪金180B身份证1000017910000179否工资薪金181A身份证1000018010000180否工资薪金182B身份证1000018110000181否工资薪金183A身份证1000018210000182否工资薪金184B身份证1000018310000183否工资薪金185A身份证1000018410000184否工资薪金186B身份证1000018510000185否工资薪金187A身份证1000018610000186否工资薪金188B身份证1000018710000187否工资薪金189

19、A身份证1000018810000188否工资薪金190B身份证1000018910000189否工资薪金191A身份证1000019010000190否工资薪金192B身份证1000019110000191否工资薪金193A身份证1000019210000192否工资薪金194B身份证1000019310000193否工资薪金195A身份证1000019410000194否工资薪金196B身份证1000019510000195否工资薪金197A身份证1000019610000196否工资薪金198B身份证1000019710000197否工资薪金199A身份证1000019810000198

20、否工资薪金200B身份证1000019910000199否工资薪金201A身份证1000020010000200否工资薪金202B身份证1000020110000201否工资薪金203A身份证1000020210000202否工资薪金204B身份证1000020310000203否工资薪金205A身份证1000020410000204否工资薪金206B身份证1000020510000205否工资薪金207A身份证1000020610000206否工资薪金208B身份证1000020710000207否工资薪金209A身份证1000020810000208否工资薪金210B身份证10000209

21、10000209否工资薪金211A身份证1000021010000210否工资薪金212B身份证1000021110000211否工资薪金213A身份证1000021210000212否工资薪金214B身份证1000021310000213否工资薪金215A身份证1000021410000214否工资薪金216B身份证1000021510000215否工资薪金217A身份证1000021610000216否工资薪金218B身份证1000021710000217否工资薪金219A身份证1000021810000218否工资薪金220B身份证1000021910000219否工资薪金221A身份证

22、1000022010000220否工资薪金222B身份证1000022110000221否工资薪金223A身份证1000022210000222否工资薪金224B身份证1000022310000223否工资薪金225A身份证1000022410000224否工资薪金226B身份证1000022510000225否工资薪金227A身份证1000022610000226否工资薪金228B身份证1000022710000227否工资薪金229A身份证1000022810000228否工资薪金230B身份证1000022910000229否工资薪金231A身份证1000023010000230否工资薪

23、金232B身份证1000023110000231否工资薪金233A身份证1000023210000232否工资薪金234B身份证1000023310000233否工资薪金235A身份证1000023410000234否工资薪金236B身份证1000023510000235否工资薪金237A身份证1000023610000236否工资薪金238B身份证1000023710000237否工资薪金239A身份证1000023810000238否工资薪金240B身份证1000023910000239否工资薪金241A身份证1000024010000240否工资薪金242B身份证100002411000

24、0241否工资薪金243A身份证1000024210000242否工资薪金244B身份证1000024310000243否工资薪金245A身份证1000024410000244否工资薪金246B身份证1000024510000245否工资薪金247A身份证1000024610000246否工资薪金248B身份证1000024710000247否工资薪金249A身份证1000024810000248否工资薪金250B身份证1000024910000249否工资薪金251A身份证1000025010000250否工资薪金252B身份证1000025110000251否工资薪金253A身份证1000

25、025210000252否工资薪金254B身份证1000025310000253否工资薪金255A身份证1000025410000254否工资薪金256B身份证1000025510000255否工资薪金减减除除费费用用专专项项扣扣除除其其他他扣扣除除费费用用免免税税收收入入基基本本养养老老保保 险险费费基基本本医医疗疗保保 险险费费失失业业保保险险费费 住住房房公公积积金金年年金金商商业业健健康康保保 险险 5,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.

26、005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.00本表仅适用于当月工资薪金计算，不适用劳务所得、稿酬所得等其他所得。当期发放奖金需注意按照奖金个税计算规则进行调整。本本月月（次次）情情况况收收入入额额计计算算5,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,0

27、00.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.0

28、05,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,0

29、00.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.0

30、05,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,0

31、00.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.0

32、05,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.00累累计计情情况况（工工资资、薪薪金金）累累计计收收入入额额累累计计减减除除费费用用累累计计专专项项扣扣 除除累累计计专专项项附附加加扣

33、扣除除税税延延养养老老保保 险险财财产产原原值值允允许许扣扣除除的的 税税费费其其他他子子女女教教育育-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-本本月月（次次）情情况况其其他他扣扣除除-5,000.00-5,000.00-5,000.00-5,

34、000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000

35、.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00

36、-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,

37、000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000

38、.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00

39、-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,

40、000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-5,000.00-减减按按计计税税比比 例例准准予予扣扣除除的的

41、 捐捐赠赠额额税税款款计计算算累累计计其其他他扣扣除除应应纳纳税税所所得得额额 赡赡养养老老人人住住房房贷贷款款利利息息住住房房租租金金继继续续教教育育-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-累累计计情情况况（工工资资、薪薪金金）累累计计专专项项附附加加扣扣除除-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.

42、00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.

43、00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-1.00-