Erca Business Income Tax Declaration Form Excel [repack] đź“Ą đź“Ť
ERCA periodically updates its forms. It is strictly advised to use outdated templates found on random websites.
Breakdowns of local sales, export sales, and service income.
A legal declaration by the taxpayer or a representative affirming that the information provided is accurate. Advantages of Using an Excel-Based Form
The primary form used for business income tax is often referred to as (or Schedule C). It is structured into four main sections: erca business income tax declaration form excel
For corporate entities (Share Companies and PLC), the business income tax rate is a flat . For sole proprietorships, the tax is calculated using a progressive schedule (from 0% up to 35%).
: Summarizes Gross Income, Cost of Goods Sold (COGS), and total business expenses to determine Net Income/Loss.
Entertainment expenses, donations/gifts (exceeding legal limits), fines and penalties, interest expenses above the central bank's allowed rate, and unsupported expenses (lacking official cash receipts or invoices). 4. Fixed Asset and Depreciation Schedule ERCA periodically updates its forms
Excel templates typically include multiple sheets or tabs corresponding to the following annexes, which must be completed before the main declaration:
:
Once the Net Taxable Income is established, the Excel sheet applies the tax rates. A legal declaration by the taxpayer or a
If an expense is capped at a percentage of revenue (e.g., specific promotional expenses), use the MIN formula: =MIN(Actual_Expense, Gross_Revenue * Cap_Percentage) .
Where you list gross income, sales, and non-operating income. Section 3: Business Expenses:
[Import Trial Balance] âž” [Adjust Non-Deductible Expenses] âž” [Apply ERCA Depreciation] âž” [Review Auto-Calculated Tax]
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
The most critical part of an ERCA Excel template is the reconciliation section. Ethiopian tax law prohibits certain accounting expenses from reducing taxable income. Your Excel formula must automatically add back disallowed expenses to the accounting profit:
