WPS Year-End Award Tax Deduction Analysis Table

It's been a long year and it's time to get an annual bonus, but with the number of exciting year-end awards, a lot of people are going to have to pay a tax. Recently reported that 170,000 of the bonuses to pay nearly 70,000 of the tax, year-end bonus tax deduction again aroused concern. WPS Online template for the vast number of users to introduce a carefully produced "Year-End bonus tax analysis table." So you can get a bonus and deduct a tax.

WPS table

Open the Analysis table and paste your [name], [monthly salary], [year-end bonus] into the first 3 columns of the form, and the form will automatically calculate the deduction and after-tax amount. If the table has a red or orange background, it will give you the distribution of year-end bonus deduction is high, then automatically give the corresponding, can refer to the tuning recommendations. This way you can clearly see your bonus and the amount of tax deducted at a glance.

After calculation you can communicate with the financial timely, help friends to effectively avoid the personal income tax rate in the "blind spot" between the point and the balance. This will not appear rumors of the year-end award "more than a dollar, personal income tax more than 1000 yuan" situation!