Erca Business Income Tax Declaration Form Excel Fix Official

If your business had no transactions, you must still file a "Nil" return.

To optimize your sheet, use these functional Excel formulas:

Let the Excel sheet calculate the tax due.

Focuses primarily on income and expense tracking, and cost of goods sold (COGS). Category C Turnover: Less than 500,000 ETB.

Excel templates typically include multiple sheets or tabs corresponding to the following annexes, which must be completed before the main declaration: erca business income tax declaration form excel

Excel automatically calculates totals from annexed schedules (e.g., depreciation, salary, general expenses) and transfers them to the main declaration form.

Do you need help writing specific formulas for or withholding tax deductions ?

Salaries, rent, utilities, marketing, and administrative costs.

Entertainment expenses (e.g., meals, receptions) are limited to 1% of gross income. The Excel sheet often has a warning if you exceed this. If your business had no transactions, you must

=IF(Asset_Type="Building", Asset_Cost * 0.05, "Check Class") Use code with caution. Business Income Tax Rate Application

Excel versions of this form provide several advantages for business owners, though they require careful manual oversight: Cons

I can provide targeted formulas or outline exact formatting rows based on your business type. Share public link

Once the Excel form is complete:

. 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:

Total sales or service revenue generated during the fiscal year.

: Breakdown of local sales, export sales, and service income.

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. Category C Turnover: Less than 500,000 ETB