个人所得税计算公式

个人所得税计算公式

应纳税所得额 = 工资收入金额 - 各项社会保险费 - 起征点(3500元)

应纳税额 = 应纳税所得额 x 税率 - 速算扣除数

说明:如果计算的是外籍人士(包括港、澳、台),则个税起征点应设为4800元。

Excel计算公式

1.税前计算税后:

个税=ROUND(MAX((工资减去应扣减的五金之后的余额-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2) 税后收入=税前工资-个税

2.税后计算税前

=IF(3500<(ROUND(MAX((A5-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.4}))+3500,2)),(ROUND(MAX((A5-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.4}))+3500,2)),税后工资)