To ensure your Excel sheet is accurate, follow these standard steps: : Multiply the monthly gross salary by 12.
: A community-shared 2020 Payroll Calculation File explicitly matching the 2020 law is available for download as an XLSX.
معادلة حساب ضريبة كسب العمل من 7-2020 الى 6-2023 EXCEL To ensure your Excel sheet is accurate, follow
: Subtract the standard personal exemption amount specified in the 2020 law.
: Subtract the employee's share of social insurance contributions (historically 11% of the insurance salary). : Subtract the employee's share of social insurance
: The remaining amount is the "Taxable Income" used to determine which progressive brackets apply.
: Offers an Online Calculator and Excel Formula focused on the July 2020 to June 2023 legislative period. Key Calculation Steps (2020 Law Framework) Key Calculation Steps (2020 Law Framework) Several resources
Several resources and official platforms provide Excel (XLSX) templates and tools specifically designed for calculating salaries based on the 2020 Egyptian tax law and its subsequent updates. Downloadable Excel Templates