bd jobs plan logo

Erca Business Income Tax Declaration Form Excel

Columns A–B:

| 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] |

This is the heart of the declaration. It is divided into specific rows that calculate the taxable income. erca business income tax declaration form excel

  • Deductible Expenses (Operating Expenses):
  • Non-Deductible Expenses:
  • Net Taxable Income: The formula subtracts total allowable deductions from Gross Profit.

    • Once the Excel form is complete:

  • Submission: Submit to the nearest Medium Taxpayers Branch Office or Large Taxpayers Branch Office depending on your registration category.

    • Ethiopian Business Income Tax Rates (for individuals and sole proprietors – Category "A" or "B"): Columns A–B:

    | Annual Taxable Income (ETB) | Rate | | :--- | :--- | | 0 – 7,200 | 0% | | 7,201 – 19,800 | 10% | | 19,801 – 38,400 | 15% | | 38,401 – 63,000 | 20% | | 63,001 – 93,600 | 25% | | 93,601 – 130,800 | 30% | | Above 130,800 | 35% |

    Excel Calculation:

    | Cell | Description | Formula | | :--- | :--- | :--- | | G1 | Annualized Taxable Income | =Sheet4!B6 (if annual) or =Sheet4!B6*12 (if monthly) | | G2 | Tax on Annual Income | =IF(G1<=7200,0, IF(G1<=19800, (G1-7200)*0.1, IF(G1<=38400, 1260 + (G1-19800)*0.15, IF(G1<=63000, 4050 + (G1-38400)*0.2, IF(G1<=93600, 8970 + (G1-63000)*0.25, IF(G1<=130800, 16620 + (G1-93600)*0.3, 27780 + (G1-130800)*0.35))))))) | | G3 | Total Annual Tax Payable | =G2 | | G4 | Tax withheld (if any – e.g., from contracts) | [User input] | | G5 | Net Tax to Pay/Refund (G3 – G4) | =G3 - G4 |