| Cell | Description | Formula | | :--- | :--- | :--- | | G1 | Annualized Taxable Income | =Sheet4!B6 (if annual) or =Sheet4!B6*12 (if monthly) | | G2 | Tax on Annual Income | =IF(G1<=7200,0, IF(G1<=19800, (G1-7200)*0.1, IF(G1<=38400, 1260 + (G1-19800)*0.15, IF(G1<=63000, 4050 + (G1-38400)*0.2, IF(G1<=93600, 8970 + (G1-63000)*0.25, IF(G1<=130800, 16620 + (G1-93600)*0.3, 27780 + (G1-130800)*0.35))))))) | | G3 | | =G2 | | G4 | Tax withheld (if any – e.g., from contracts) | [User input] | | G5 | Net Tax to Pay/Refund (G3 – G4) | =G3 - G4 |
Do you need help writing specific formulas for or withholding tax deductions ?
The primary declaration form for most businesses, especially those with an annual turnover over 100,000 Birr, is the . This form requires you to report your total income, claim allowable deductions, and calculate your final tax liability.
Store your annual tax Excel files in secure, encrypted cloud storage alongside scanned copies of supporting invoices. erca business income tax declaration form excel
Built-in formulas instantly compute gross profit, taxable income, and final tax liabilities.
The ERCA declaration typically consists of four main sections that ensure comprehensive reporting of a business's financial health:
Always protect your workbook structure. Lock cells containing calculations and formulas so that users can only modify data entry cells. This prevents accidental deletions that distort tax calculations. | Cell | Description | Formula | |
: Helps businesses meeting the 500,000 Birr turnover threshold manage the more detailed financial records required by law. User Perspectives
: Detailed worksheets for accounts receivable, inventories, and fixed assets.
Calculation of tax depreciation according to ERCA-approved asset categories and rates (e.g., buildings, computers, vehicles) rather than book depreciation. 4. Tax Liability Computation Sheet Store your annual tax Excel files in secure,
The Excel file is usually locked for formulas but open for data entry. Check the Net Taxable Income cell. If it shows #REF! or #VALUE! , you may have entered text in a numeric field. unless you are an advanced user, as altering formulas can invalidate the declaration.
Use your completed Excel sheet as a source document to fill in the official PDF form. Your Excel sheet acts as your final working paper, providing the exact figures for total income, deductions, tax credits, and final tax due.
The Excel form should automatically calculate your taxable income. If not, calculate Gross Income - Total Deductible Expenses.