Erca Business Income Tax Declaration Form Excel -

| Step | Calculation | Formula/Amount (ETB) | | :--- | :--- | :--- | | A | Total Gross Income (from Sheet 2) | =Sheet2!B7 | | B | Total Deductions (from Sheet 3) | =Sheet3!B14 | | C | | =Sheet4!B1 - Sheet4!B2 | | D | Non-taxable income (if any, per ERCA) | [User input] | | E | Exempt income (e.g., certain dividends) | [User input] | | F | Taxable Business Income (C – D – E) | =Sheet4!B3 - Sheet4!B4 - Sheet4!B5 |

The proposed Excel template will consist of the following sheets: erca business income tax declaration form excel

| Line | Item (in ETB) | Amount | | :--- | :--- | :--- | | 1 | Gross Sales/Receipts (Turnover) | [User input] | | 2 | Sales Returns & Allowances | [User input] | | 3 | | =Sheet2!B1-B2 | | 4 | Cost of Goods Sold (Opening stock + Purchases - Closing stock) | [User input or calculation] | | 5 | Gross Profit (3-4) | =Sheet2!B3-B4 | | 6 | Other Business Income (Commission, Fees, etc.) | [User input] | | 7 | Total Gross Income (5+6) | =Sheet2!B5+B6 | | Step | Calculation | Formula/Amount (ETB) |

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