Erca Business Income Tax Declaration Form Excel Exclusive May 2026

Mastering the ERCA Business Income Tax Declaration Form: A Comprehensive Excel Guide

The Ethiopian Revenue and Customs Authority (ERCA) requires all businesses operating in Ethiopia to declare and pay Business Income Tax (BIT). While large corporations often rely on expensive accounting software, Small and Medium Enterprises (SMEs) and freelance accountants frequently utilize the official ERCA Excel Template for their declarations.

=Net_Income - (Loss_Carry_Forward_Previous_Period + Carry_Backward_Loss_Adjustment) Tax Liability erca business income tax declaration form excel

“The spreadsheet can represent the income tax formula... it serves as a tool to double-check tax software calculations, ensuring data entry accuracy.” Mastering the ERCA Business Income Tax Declaration Form:

Section B: Declaration of Gross Income

Here you enter your total sales/revenue before any deductions. The Excel sheet usually separates: Sales of goods

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

Section 4: Tax Calculation: Determines the net taxable income after subtracting total expenses and accounting for loss carry-forwards. Essential Annexes for Excel Filing

• Example add-back (non-deductible expense): TaxEffect formula: =IF(C2="Add-back",B2,IF(C2="Deduct",-B2,0))
• Total adjustments: =SUM(D:D)

• Sales of goods.
• Rendering of services.
• Other business income (interest, rent, etc.).