Erca Business Income Tax Declaration Form Excel

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.

Ethiopian Business Income Tax Rates (for individuals and sole proprietors – Category "A" or "B"): erca business income tax declaration form excel

| 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% | The Ethiopian calendar year is 7–8 years behind

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 | For example, 2016 E

| Tab Name | Purpose | |----------|---------| | Instructions | Step-by-step guide to filling the form, ERCA rate tables, and deduction limits | | Revenue & COGS | Enter sales, returns, allowances, and inventory movement | | Expenses | Categorized expense entry with automatic summing | | Adjustments | Add-back non-deductible items, subtract exempt income | | Tax Computation | Main calculation engine – shows bracket rates and final tax | | Declaration Form | ERCA-style summary ready for printing/signing | | Checklist | Validation errors, missing entries, required attachments (receipts, ledgers) |