Latest personal tax calculator
From October 1, 2018, the new personal income tax plan will be reflected in everyone's salary sheet. We have prepared a personal tax calculation tutorial for you-new personal tax & five insurance and one gold calculator!
"The transition policy in the fourth quarter of this year includes double tax reduction measures. First, the cost reduction standard of 3500 yuan per month was raised to 5,000 yuan per month; Second, the new tax rate table was applied, as the new tax rate table increases the tax rate range of middle and low income, it reduces the tax burden of middle and low income people." -- Economic Daily, how does personal tax reform affect your "money bag"
1. How is the new personal income tax calculated?
Take a simple chestnut-Li Lei, who works in Shanghai, whose salary is 10,000 yuan/month. But this salary is not the salary Li Lei can see in the bank card, but "paid salary + five insurances and one gold (personal payment) + personal tax."
When calculating personal income tax for personnel, it is necessary to deduct Li Lei's five insurances and one gold from the total wage. According to Shanghai standards, Li Lei's five insurances and one gold pay 1750 yuan.
💗Taxable salary = salary-five insurances and one gold = 10000-1750=8250 yuan
In order to reduce the burden on residents, the country has set a threshold, which used to be 3500 and now is 5000, meaning: Li Lei 8250's salary can be divided into two parts, 5000 yuan is tax-free, the remaining 3250 participate in tax payment (I .e. taxable income), namely:
💗Taxable income = taxable salary-threshold = 8250-5000=3250 yuan
Then how to calculate the personal tax amount for the remaining 3250 yuan? The country has issued a personal income tax table, which has also changed in this reform:
The past personal income tax table:
Old personal income tax
The current personal income tax table:
New personal income tax
[Traditional calculation method] Li Lei's taxable income is 33% of the taxable income of 3250,3000, and 250 of the taxable income exceeding 3000, the comprehensive value is 3000 x 3% +250 x 10% = 115 yuan.
[Fast calculation method] the existence of deduction in quick calculation can avoid traditional troublesome calculation. Li Lei's taxable income is 3250, and the tax level is 2, calculated according to the formula [personal tax = taxable income x corresponding tax rate-quick calculation deduction], the comprehensive value is 3250 x 10%-210=115 yuan.
💗To sum up: personal tax = (total salary-five insurances and one gold-threshold) x corresponding tax rate-quick calculation deduction
2. How to use YIDA calculator?
YIDA is a flexible and easy-to-use application building platform. In order to help you quickly calculate personal tax, a YIDA version of new personal tax & five insurance and one gold calculator was built.
2.1 New Personal Tax Calculator
New personal tax calculator
[Operation instructions] after directly entering the taxable salary, you can obtain the personal income tax result.
[Note for building] YIDA IF, AND, EQ, LE, AND GT functions are mainly used here. For more information about how to write the formula, see the picture.
New personal tax payment formula
2.2 Common wage tax
Common wage tax payment
[Operating instructions] it is convenient for you to quickly browse the individual taxes of different wages (if there are special ways to calculate the taxes of the enterprise, personnel can create a quick management page, enter the common salary and corresponding tax amount of the enterprise to facilitate employees to quickly view)
2.3 five insurance and one gold calculator
Five insurance and one gold calculator
[Operation instructions] after entering the total salary directly, you can directly obtain the amount of five insurances and one gold. Because different cities and enterprises have different five insurance and one gold quotas and different upper and lower limits, no more settings are set here. You can modify the default value in the background.
[Construction note] mainly uses 「Subform API methods」, note that the unique identifier of the subform is modified.
Assign default values to Subforms
2.4 Effect demonstration
Click the form to view the effect of the new personal tax calculator:Click View
Click the form to view the effect of the five insurance and one gold calculator:Click View
Video demo
Note:
1. This calculator is built by YIDA. Only the income of residents' wages and salaries is calculated. Other income such as operation, interest, dividends and dividends are not within the calculation range. If more is needed, you can modify the calculation rules by yourself;
2. Each city and enterprise has different five insurance and one gold payment policies. Please adjust the formula according to the actual situation;
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
