Erca Business Income Tax Declaration Form Excel ^new^ Jun 2026

Link or manually enter your trial balance data into the P&L tab. Double-check that your sales revenue matches your monthly Value Added Tax (VAT) filings submitted throughout the year. Step 3: Compute Tax Depreciation

Some ERCA sheets use simple VBA for validation. Click "Enable Content" if prompted.

The bridges the gap between complex tax proclamations and small/medium business owners. By automating calculations, enforcing deduction rules, and providing a print-ready declaration sheet, it saves time, reduces errors, and promotes voluntary tax compliance.

D) Tax_Adjustments sheet Columns: Description | Amount (Accounting sign) | AdjustmentType (Add-back/Deduct) | TaxEffect erca business income tax declaration form excel

The Excel form should automatically calculate your taxable income. If not, calculate Gross Income - Total Deductible Expenses.

The Ethiopian Ministry of Revenues uses a structured Schedule C Business Income Tax Declaration Form to report annual earnings and expenses, often processed through the e-Tax portal or via offline Excel templates. The form (commonly Form 1301) includes sections for taxpayer information, detailed income and expense breakdowns, and specific annexes for detailed financial reporting. For a representative guide on the profit declaration form, visit Addis Tax Initiative

Look at the "Tax Payable" cell. If it is negative (loss), you owe nothing, but you must still file a "nil" declaration. If positive, note the amount. Link or manually enter your trial balance data

Once upon a time in the bustling heart of Addis Ababa, there was a small but thriving tech startup named . Its founder, Elias, was a wizard with code but felt like a novice when it came to the annual dance with the Ethiopian Revenues and Customs Authority (ERCA) .

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.

: Deductions for salaries, rent, utilities, and depreciation. Click "Enable Content" if prompted

Use Excel's "Protect Sheet" feature to lock cells containing complex formulas. This prevents accidental deletion of tax logic.

Once you open the Excel workbook, you will typically see 4 to 6 sheets:

MAT is calculated as 2.5% of your total annual turnover. You would add a line in your Excel calculations that checks if your computed income tax (using the progressive brackets) is less than 2.5% of turnover. If yes, MAT applies.