To ensure your Excel sheet is accurate, follow these standard steps: : Multiply the monthly gross salary by 12.
: Subtract the employee's share of social insurance contributions (historically 11% of the insurance salary). To ensure your Excel sheet is accurate, follow
معادلة حساب ضريبة كسب العمل من 7-2020 الى 6-2023 EXCEL : Calculate tax for each portion of income
: A specialized Income Tax Calculation Template in XLSX format that identifies tax brackets and automates deductions based on gross salary. Key Calculation Steps (2020 Law Framework)
: Calculate tax for each portion of income falling within the progressive bands (e.g., 2.5%, 10%, 15%, etc., as per 2020 law). Summary of 2020 Tax Brackets (Historical Context) Annual Taxable Income (EGP) Up to 15,000 15,001 – 30,000 30,001 – 45,000 45,001 – 60,000 60,001 – 200,000 200,001 – 400,000 Over 400,000
: 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)