This tab should visually mimic the official paper or e-filing layout provided by the tax authority. It pulls data from the previous tabs to display: Accounting Net Profit Total Non-Allowable Expenses (Add-backs) Adjusted Taxable Income Calculated Business Income Tax Due Withholding Tax Deductions (to be subtracted from tax due) Net Tax Payable / Refundable Implementing ERCA Tax Formulas in Excel
: Detailed calculation of inventory and cost of manufacturing or services. Annex 4 : Itemized selling and distribution expenses. Annex 5 : Other miscellaneous deductible expenses. Digital Transition and E-Tax
A robust ERCA business income tax Excel form is more than just a copy of the paper declaration. It acts as an automated calculator. A functional template should contain the following interconnected tabs or sections: 1. Taxpayer Information Sheet
A standard business tax declaration is divided into four main functional areas:
Ideal for aggregating total revenue or specific expense categories from a master transaction ledger into the P&L tab. erca business income tax declaration form excel
Legal Business Name, Taxpayer Identification Number (TIN), Tax Year (EC / GC), Business Address, Sector/Activity Type, and Contact Information. 2. Profit and Loss (P&L) Statement / Income Statement
Salaries, rent, utilities, licenses, and logistical costs. 3. Schedule of Non-Allowable Expenses (Tax Adjustments)
Total sales generated, exclusive of Value Added Tax (VAT) or Turnover Tax (TOT).
The Ethiopian tax year runs from July 8th to July 7th of the following year. The deadline for filing the annual return is typically within four months after the end of the tax year (i.e., by early November). However, specific deadlines can vary for different tax categories, so check with ERCA or your tax consultant. This tab should visually mimic the official paper
You gain automated calculations that eliminate guesswork, a clear audit trail that stands up to scrutiny, and a dynamic financial model that helps you plan for the future. With the 2025 tax reforms simplifying categories and introducing new rules like the Minimum Alternative Tax, having this control is no longer a luxury—it's a necessity.
: Modern filing is encouraged through the eCMS project , where declarations can be uploaded as digital files (often converted from Excel-prepared data).
Total sales generated from goods or services.
The ERCA business income tax declaration form is a document that businesses are required to submit to the IRBM to declare their income, claim deductions, and calculate their tax liability. The form is available in Excel format, making it easier for businesses to compute and report their tax information. Annex 5 : Other miscellaneous deductible expenses
Using an Excel version of the ERCA form offers several practical advantages for business owners and tax preparers:
: Requires your Name, Address, and Taxpayer Identification Number (TIN) . Section II: Income Tax Declaration :
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.