: Subtract the employee's share of social insurance contributions (historically 11% of the insurance salary).
: Official Payroll Declaration Forms are available, including "Form No. 2" and "Form No. 3" in XLSX for annual and monthly settlements.
: Offers an Online Calculator and Excel Formula focused on the July 2020 to June 2023 legislative period. Key Calculation Steps (2020 Law Framework) : Subtract the employee's share of social insurance
To ensure your Excel sheet is accurate, follow these standard steps: : Multiply the monthly gross salary by 12.
: A specialized Income Tax Calculation Template in XLSX format that identifies tax brackets and automates deductions based on gross salary. 3" in XLSX for annual and monthly settlements
: The remaining amount is the "Taxable Income" used to determine which progressive brackets apply.
: A community-shared 2020 Payroll Calculation File explicitly matching the 2020 law is available for download as an XLSX. : A specialized Income Tax Calculation Template in
: Subtract the standard personal exemption amount specified in the 2020 law.