Erca Business Income Tax Declaration Form Excel Access
Yes. Even if your business made no profit, or had a loss, you are generally required to file a return. This demonstrates compliance and allows you to carry forward losses to offset future profits.
Enter your allowable business expenses. Common categories in the Excel form include:
In Ethiopia, business income tax is governed by the , which was recently amended by Proclamation No. 1395/2025 . This tax applies to the net profit of any business operating in the country, from a small sole proprietorship to a large corporation.
This guide explains how to complete the ERCA (Eritrean Revenue & Customs Authority) business income tax declaration using Excel: structure, required data, calculations, common pitfalls, and an example Excel layout with formulas you can copy. erca business income tax declaration form excel
You can submit your forms through one of several channels:
Businesses with an annual turnover between 500,000 and 1,000,000 ETB.
Filing your business income tax can be a complex process. In Ethiopia, the Federal Ministry of Revenues (formerly known as the Ethiopian Revenues and Customs Authority, or ERCA) requires businesses to accurately report their annual earnings, deductions, and tax liabilities. Enter your allowable business expenses
On the final sheet, Elias designed a mirror image of the official . Box 100: Gross Profit. Box 200: Total Deductions. Box 300: Net Taxable Income.
| Category | Description | Amount (ETB) | | :--- | :--- | :--- | | 1 | Raw materials and direct supplies | [User input] | | 2 | Rent (business premises) | [User input] | | 3 | Utilities (electricity, water, internet, phone) | [User input] | | 4 | Salaries & wages (after payroll tax) | [User input] | | 5 | Repair & maintenance | [User input] | | 6 | Advertising & promotion | [User input] | | 7 | Transportation & fuel (business only) | [User input] | | 8 | Bank charges & interest (business loan) | [User input] | | 9 | Depreciation (as per ERCA schedule – 25%, 20%, 10% etc.) | [Calculated] | | 10 | Insurance (business asset/liability) | [User input] | | 11 | Professional fees (legal, audit, consultancy) | [User input] | | 12 | Other allowable expenses | [User input] | | | Sum of above | =SUM(Sheet3!B2:B13) |
YouTube · Accounting Instruction, Help, & How To (Financial & Managerial) This tax applies to the net profit of
This is the core of the declaration where you calculate your taxable income.
To automate the calculation of business income tax, you can leverage built-in Excel logic. For Incorporated Businesses (Share Companies and PLC)
There are three ways to get the official Excel template:
Pre-formatted cells prevent you from entering data into the wrong columns or messing up cumulative sums.