Download Щ…щ„щѓ Ш§щѓшіщ„ Щ„шшіш§шё Ш§щ„щ…ш±шєшёш§шє Ш·шёщ‚ш§ Щ„ш¶ш±щљшёш© Щѓшішё Ш§щ„ш№щ…щ„ Ш§щ„ш¬шїщљшїш© 2020 Xlsx -
: A specialized Income Tax Calculation Template in XLSX format that identifies tax brackets and automates deductions based on gross salary.
معادلة حساب ضريبة كسب العمل من 7-2020 الى 6-2023 EXCEL
: The remaining amount is the "Taxable Income" used to determine which progressive brackets apply.
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
: 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
: Official Payroll Declaration Forms are available, including "Form No. 2" and "Form No. 3" in XLSX for annual and monthly settlements.
: 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).
