Erca Business Income Tax Declaration Form Excel ✰
Simplifying Your ERCA Business Income Tax Declaration Filing your business income tax with the Ethiopian Revenues and Customs Authority (ERCA) —now under the Ministry of Revenues
. These taxpayers may be subject to presumptive tax based on their annual gross sales unless they elect to maintain full books. 2. Key Components of the Declaration Form The standard declaration form (often referred to as ) consists of several critical sections and annexes: Annex 1 (Revenue): Reports local sales, export sales, and service income. Annex 2 (Cost of Goods Sold): Calculates the direct cost of services or goods sold. Business Expenses: erca business income tax declaration form excel
Scenario Testing: Allows businesses to model different expense scenarios to see their impact on final tax payable. Simplifying Your ERCA Business Income Tax Declaration Filing
- Partnership/PLC tax calculation (separate rate of 30% flat)
- Monthly VAT & withholding declaration combined with income tax
- Amortization of startup costs
Section C: Cost of Goods Sold (COGS) – For Merchandise Businesses
This is the most audited section. You will enter: Partnership/PLC tax calculation (separate rate of 30% flat)
Sheet 2: Income Statement (Taxable Business Income)
| Line | Item (in ETB) | Amount |
| :--- | :--- | :--- |
| 1 | Gross Sales/Receipts (Turnover) | [User input] |
| 2 | Sales Returns & Allowances | [User input] |
| 3 | Net Sales (1-2) | =Sheet2!B1-B2 |
| 4 | Cost of Goods Sold (Opening stock + Purchases - Closing stock) | [User input or calculation] |
| 5 | Gross Profit (3-4) | =Sheet2!B3-B4 |
| 6 | Other Business Income (Commission, Fees, etc.) | [User input] |
| 7 | Total Gross Income (5+6) | =Sheet2!B5+B6 |
7. Security & Data Handling
- No external data connection – all calculations remain within the Excel file.
- Optional password protection for sensitive cells (e.g., formulas, TIN field).
- Recommended to store on a secure local drive or encrypted cloud folder.