Erca Business Income Tax Declaration Form Excel Access

Once the Net Taxable Income is established, the Excel sheet applies the tax rates.

The is a structured, user-friendly template designed to assist taxpayers (sole proprietors, partnerships, and private limited companies) in declaring their annual business income to the Ethiopian Revenue and Customs Authority (ERCA). This Excel-based solution replaces manual paper calculations, reduces arithmetic errors, and ensures compliance with current tax proclamation schedules. erca business income tax declaration form excel

This is where the magic happens. The Excel formulas will compute: Once the Net Taxable Income is established, the

This is the identification area. You must manually enter: This is where the magic happens

| Field | Description | User Input | | :--- | :--- | :--- | | Tax Year (Ethiopian Calendar) | E.g., 2017 E.C. (2024/25 G.C.) | [Dropdown: 2015-2020 EC] | | TIN (Taxpayer Identification Number) | 10-digit number | [Text] | | Business Name | As registered | [Text] | | Business License No. | | [Text] | | Tax Period | Monthly / Quarterly / Annually | [Dropdown] | | Date of Declaration | | [Date Picker] | | Declaration Type | Original / Amended | [Dropdown] |

Even with automated formulas, errors are frequent.

E) Capital_Allowances Columns: Asset | Cost | DateAcquired | Pool | StatutoryRate | AnnualAllowance AnnualAllowance formula: =Cost * StatutoryRate