The new individual income tax has been implemented at the beginning of this year. Under the new individual income tax system, the algorithm of individual income tax is different from before. From this year, the calculation method of withholding and prepayment and statistics of the next year is adopted. However, there are still many people who don't know how to calculate individual income tax. This article brings you a list of specific individual income tax rates, as well as algorithm examples and algorithm formulas. Let's see how to calculate it.
Under the new individual income tax system, the individual income tax algorithm is really different from before. In the past, the individual income tax was calculated separately every month, but the calculation method of monthly withholding and prepayment and unified calculation of excess refund and Deficiency Compensation in the next year has been adopted since 2019. In other words, it is calculated and paid once a month. The difference is that the algorithm is changed from single month data to cumulative data. The specific formula is:
Withholding tax payable in this month = (accumulated withholding tax income in this month * withholding tax rate - quick calculation deduction) - accumulated tax deduction - accumulated withholding tax
Accumulated taxable income to be withheld in this month = accumulated income - accumulated tax exempt income - accumulated expenses deducted - accumulated special deductions - accumulated special additional deductions - accumulated other deductions determined according to law
Including: accumulated expenses deducted = 5000 * months
Withholding tax rate table:
Are you dizzy? Or examples are clearer.
02 calculation example
1. Zhang San's salary in January 2019 is 30000 yuan, and all deductions are 3000 yuan in total
Withholding tax of this month
=(30000-5000-3000)*3% - 0
=22000 * 3%
=660
Note: the total income after deducting expenses and deductions is 22000. It can be seen from the above withholding tax rate table that the applicable tax rate is 3%
2. Zhang San's salary in February 2019 is 32000 yuan, and all deductions are 4000 yuan in total
Accumulated withholding tax in this month
=(32000-5000-4000+22000)*10%-2520
=45000*10%-2520
=1980
Total withholding tax payable in February = accumulated in this month - accumulated in last month
=1980 - 660=1320
3. Zhang San's salary in March 2019 was 35000, and all deductions totaled 6000 yuan
Accumulated withholding tax in March
=(35000-5000-6000+45000)*10% - 2520
=69000*10%-2520
=4380
Note: total accumulated withholding tax in March = accumulated in this month - accumulated in last month
= 4380-1980 =2400
See here is not in the heart to say: so complex, so complex! Everyone does it this way. If hundreds of people in the company do it, don't be tired... Of course, there are simple methods. Next, combined with the payroll, let's introduce the setting method of the withholding tax formula for each month in 2019.
03 excel formula for individual income tax calculation
Setting steps:
1. Payroll adjustment
The original individual income tax column of the payroll is changed to 3 columns, which are cumulative withholding income payable, cumulative tax amount and withholding tax payable in this month. (please name the column title by yourself)
2. Formula setting
Payroll formula of January:
D2 (accumulated income)
=B2-C2-5000
E2 (accumulated tax amount of this month)
=5*MAX(0,D2*{0.6;2;4;5;6;7;9}%-{0;504;3384;6384;10584;17184;36384})
F2 (amount to be withheld in this month)
=E2
Payroll formula of February:
D2 (accumulated income)
=B2-5000-c2 + iferror (vlookup (A2, \'january payroll \ '! A: D, 4,0), 0)
Note: use vlookup to find the accumulated withholding and payable income of the previous month
E2 (accumulated tax amount of this month)
=5*MAX(0,D2*{0.6;2;4;5;6;7;9}%-{0;504;3384;6384;10584;17184;36384})
Note: the formula is the same as that of last month
F2 (amount to be withheld in this month)
=E2-iferror (vlookup (A2, \'january payroll \ '! A: F, 5,0), 0)
Note: deduction in this month = accumulated individual income tax payable in this month - accumulated amount in last month
The payroll of other months is the same as that of February. You only need to change the worksheet referenced in the formula to the previous month. If the payroll for April is made, the February in the formula can be changed to March.