模板10：2019工资表模板及个税预扣预缴统计表

格式：xlsx
大小：21.17 KB
文档页数：2

下载文档原格式

2019工资表模板及个税预扣预缴统计表

个人所得税预扣率表一
（居民个人工资、薪金所得预扣预缴适用）
级数累计预扣预缴应纳税所得额预扣率（%）速算扣除数1不超过36000元的部分30
2超过36000元至144000元的部分102520
3超过144000元至300000元的部分2016920
4超过300000元至420000元的部分2531920
5超过420000元至660000元的部分3052920
6超过660000元至960000元的部分3585920
7超过960000元的部分45181920
个人所得税预扣率表二
（居民个人劳务报酬所得预扣预缴适用）
级数预扣预缴应纳税所得额预扣率（%）速算扣除数1不超过20000元的200
2超过20000元至50000元的部分302000
3超过50000元的部分407000
个人所得税税率表三
（非居民个人工资、薪金所得，劳务报酬所得，稿酬所得，特许权使用费所得适用）
级数应纳税所得额税率（%）速算扣除数1不超过3000元的30
2超过3000元至12000元的部分10210
3超过12000元至25000元的部分201410
4超过25000元至35000元的部分252660
5超过35000元至55000元的部分304410
6超过55000元至80000元的部分357160
7超过80000元的部分4515160。

2019年工资表-带最新个税计算(累计预扣法)

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。

2019年度工资表模板(预扣缴,可累计)

ቤተ መጻሕፍቲ ባይዱ
Month 2018-12 2018-12 2018-12 2018-12 2018-12 2018-12
Rno 1076 1088 1931 3258 1021 1255
Id P011 P023 P1752 E001 F003 B004
Post职位补贴 600.00 600.00 -
ENG ENG ENG ENG FIN FIN
Salary list for Dec.,2018 公司名字
Costcenter 成本中心new Name 姓名 Basic底薪 Sean Su Pine Ye Selina Xie James Zhang Vicky Zhong Ivy Deng 张洋洋李思思王磊王小川钟婷邓欣 2,300.00 ###### 2,300.00 ###### 6,600.00 6,300.00 Yearly 年资 ### ### 1 工资部分 Post Allowan ces岗位津贴 Annual Leave Allowan ces年假 High Temper ature Allowan 福利补贴 Meal Allowan ces餐费补贴 Other Subsidi es其他补贴 Annual Bonus 年终奖 Gross应发工资 Exemption 免征额 4,497.52 ####### 4,477.52 ####### 6,600.00 6,300.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,0

工资表模板(2019新税制)

序号部门姓名基本工资其他缺勤扣款应发合计五险一金个人应税金额实发金额养老失业医疗公积金个人小计企业养老企业失业企业工伤企业生育企业医疗公积金企业小计制表人
XX有限公司工资表
序号部门姓名
基本工资
ห้องสมุดไป่ตู้
1
2
3
4
5
6
7
8
9
合计
-
交补 -
餐补 -
其他
缺勤扣款应发合计
-
-
-
-
-
-
-
-
-
-
-
-
养老 -
五险一金（个人）
失业
医疗
公积金
-
-
-
个人小计 -
五险一金（企业）企业养老企业失业企业工企业生育企业医疗
伤
-
-
-
-
-
公积金 -
企业小计 -
应税金额
代扣代缴个人所得税
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
制表人：
审核人：
付款人：
社保合计住房公积金合计
有限公司工资表
实发金额
-
-
#REF!
-
#REF!

个人所得税计算的工资表模板

个人所得税计算的工资表模板（以下为一份个人所得税计算的工资表模板，供参考使用）工资表
姓名：________________ 日期：______________
收入项目金额（元）备注
基本工资
岗位工资
绩效工资
加班工资
餐费补助
交通补贴
住房补贴
年终奖金
其他收入
合计收入
扣除项目金额（元）备注
养老保险金
医疗保险金
失业保险金
住房公积金
企业年金
税前扣款
其他扣款
合计扣款
应纳税所得额：______________ 元
个人所得税计算：
税率速算扣除数（元）0% 0
3% 0
10% 105
20% 555
25% 1,005
30% 2,755
应纳税额：______________ 元
个人所得税计算方法：
应纳税所得额 ×适用税率 - 速算扣除数 = 个人所得税
实际到手收入：______________ 元
以上所提供的模板仅供参考使用，具体税率和速算扣除数可能会根据国家法规而有所不同。

在实际计算个人所得税时，请务必按照最新法规进行核算。

2019预扣交个税计算表(1.21)

23,450.00 3%
-
48,000.00 10% 2,520
52,156.00 10% 2,520
3,767.52 3%
-
34,001.00 3%
-
3,000.00 3%
-
-
0%
-
-
0%
-
-
0%
-
-
0%
-
-
0%
-
-
0%
-
295,074.52
个税计算过程
31
个税计算过程
累计应交已预交本月应交
8,000.00
李
8,000.00
8,000.00
王五
8,000.00
8,000.00
刘六
8,000.00
8,000.00
赵七
8,000.00
8,000.00
钱八
8,000.00
8,000.00
老九
8,000.00
8,000.00
张三
8,000.00
8,000.00
李四8,000Βιβλιοθήκη 008,000.006
超过660000元至960000元的部分
7
超过960000元的部分
预扣率（%）
3 10 20 25 30 35 45
速算扣除数 2,520 16,920 31,920 52,920 85,920
181,920
累计数据，是本年度内截止到当月的累计数，它由当月数据加上一个月的累计数自动计算得来。
-
140,000.00
累计数据(自动计算)
社保
后续教育
专项附加子女教育房贷/租金

新个税工资计算表(2019年累计预扣法)

继续教育
房贷利息
住房租金
赡养老人
商业保险
年金
独生子女费工会Байду номын сангаас费 3.50
当月个人所得税 128.69
累计应发、累计扣除、累计个税（T-1）
当月实发工资累计应发工资累计免征额 9,657.58 13,142.95 5,000.00 累计养老 1,207.20 累计失业 30.18 累计医疗 304.80 累计公积金 1,811.00
87 88 89 90 91 92 93 94 95 96 97 98 99 100
5,000
技术/岗位津交通补贴医药补贴误餐补贴工龄补贴贴 200.00 30.00 220.00
倒班补贴加班费
奖金
过节费
降温/取暖费
当月扣除项目、当月个税、当月实发工资
补上月缺勤/扣款应发工资 13,142.95 免征额 5,000.00 养老 1,207.20 失业 30.18 医疗 304.80 公积金 1,811.00 子女教育 500.00
职务工资 2,000.00
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
2019年
1月工资表
当月应发项目
职务部长级别基本工资 G1 4,692.95 业绩工资 6,000.00 姓名张龙
现行免征额

2019版个人所得税计算表(自动生成工资表工资条)

应发薪资序号姓名身份证号部门入职时间基本薪资岗位津贴工龄薪资全勤奖绩效奖共计加班补贴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。

2019年新个税工资表模板(带公式)

说明：
1.表头项目可根据各司实际情况删减，但注意1—12月工资表如要增减表头项目，12张表要同时增减，避
2.个税计算公式简单易懂，可自行调整增减项。

但要切记不可删除任意月份的表格，否则将会影响应纳
3.新税法实施首年发生的大病医疗支出，要在2020年才能办理；
4.享受大病医疗专项附加扣除的纳税人，由其在次年3月1日至6月30日内，自行向汇缴地主管税务机关办
目，12张表要同时增减，避免因增列导致计算公式失效；的表格，否则将会影响应纳所得税额公式的计算；
行向汇缴地主管税务机关办理汇算清缴申报时扣除。

2019年5月xx公司员工工资表。

2019年个税工资表(可直接扣除六项自动计算结果)

200
300
9
9
8491.00
250.00 500.00 6250.00 2000 1000
200
-1950
0
0
6250.00
250.00 500.00 3750.00 2000 1000 1000
-5250
0
0
3750.00
204.70 409.40 3476.50 2000
1000
-4524
0
0
200
39300
1410
1410
月
日
实发工资
46090.00
400.00 800.00 38000.00 2000 1000
200
29800
894
894
37106.00
400.00 800.00 33000.00 2000 1000
200
24800
744
744
32256.00
350.00 700.00 28250.00 2000 1000
200
20050
602
602
27648.50
350.00 700.00 23250.00 2000 1000
200
15050
452
452
22798.50
300.00 600.00 13500.00 2000 1000
200
5300
159
159
13341.00
300.00 600.00 8500.00 2000 1000
007 G 副总监 1600 4400 400 200
200 1200 2000
10000 6000 480.00 120.00

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

2019年1月**公司员工累计预扣预缴应纳税所得
工号
部门
姓名
身份证号累计工码资收入
累计免税收入
001
研发中心
李小 410456198 二 809085214
12600
0
002
销售中心
王小 410456198 五 509085214
24000
0
累计专项扣除社保公积金
累计基本减除费用
额
已预扣预缴税
额
本期实际应预扣预缴税
额税额
3900
3%
0
117
0
117
14100
3%
0
423
0
423
<
专项扣除-累计专项附加扣除-累计依法确定的其他扣除
累计专项附加扣除
累计依法确定的其
他扣除
1000 200
5000
2500
0
2000 400
5000
2500
0
计算公式：累计预扣预缴应纳税所得额=累计收入-累计免税收入-累计减除费用-累计专项扣除-累计专项附加扣除
扣预缴应纳税所得额
累计预扣预预扣预缴税