Erca Business Income Tax Declaration Form Excel May 2026

Unlike VAT or withholding tax returns (usually monthly), the Business Income Tax Declaration is typically filed annually, usually within four months after the end of the Ethiopian fiscal year (which runs from Hamle 1 to Sene 30; i.e., July 8 – July 7).

Step 1: Gather your source documents.

Step 2: Open the Excel template and enable macros (if any). Some ERCA sheets use simple VBA for validation. Click "Enable Content" if prompted.

Step 3: Fill the "General Information" tab first. Do not skip this. Your TIN and tax year must match exactly with ERCA’s database.

Step 4: Input revenue data. Double-check that you haven’t included VAT or Turnover Tax (which is collected on behalf of the government). Only net sales. erca business income tax declaration form excel

Step 5: Enter COGS and expenses carefully. If an expense exceeds Birr 10,000, ensure you have a bank transfer or a valid receipt (a wesib). ERCA auditors target large cash payments.

Step 6: Let Excel calculate depreciation. Use the dropdown to select asset categories. If you manually overwrite the formula cell, the template will break.

Step 7: Review the Summary Tab. Look at the "Tax Payable" cell. If it is negative (loss), you owe nothing, but you must still file a "nil" declaration. If positive, note the amount.

Step 8: Perform a cross-check. Calculate your net profit margin manually. If your margin deviates wildly from industry norms (e.g., a restaurant showing 2% margin), the Excel sheet may flag a yellow warning. ERCA may audit you. Unlike VAT or withholding tax returns (usually monthly),

This is where the magic happens. The Excel formulas will compute:

Business Income Tax Rates (Proclamation 979/2016): | Taxable Income (Birr) | Rate | | :--- | :--- | | 0 – 7,200 | 0% | | 7,201 – 16,800 | 10% | | 16,801 – 28,800 | 15% | | 28,801 – 42,000 | 20% | | 42,001 – 60,000 | 25% | | 60,001 – 84,000 | 30% | | Over 84,000 | 35% |

Note: For companies (PLC/Share Co), the flat rate is 30%. For individuals (sole proprietors), the progressive table above applies.

ERCA is rapidly digitizing. The Excel form may eventually be phased out for a full online portal. To stay ahead: Step 1: Gather your source documents

The Ethiopian calendar year is 7–8 years behind the Gregorian calendar. Always confirm the E.C. year. For example, 2016 E.C. ended on July 7, 2024.

| Manual Paper | Excel Template | |--------------|----------------| | Prone to arithmetic errors | Built-in formulas eliminate mistakes | | Difficult to apply correct tax rate | Automatic bracket selection | | No audit trail | Formula-driven logic, easy to trace | | Cannot recalculate quickly | Update one number → entire form recalculates | | Hard to spot missing deductions | Expense checklist and warnings |

When using the Excel declaration form, auditors frequently flag the following errors: