Erca Business Income Tax Declaration Form Excel

You might wonder: Why not just use the online portal or a paper form?

The Excel format offers specific advantages:

A) Company_Info (named range Company)

B) Trial_Balance

C) Profit & Loss (summary)

D) Tax_Adjustments sheet Columns: Description | Amount (Accounting sign) | AdjustmentType (Add-back/Deduct) | TaxEffect

E) Capital_Allowances Columns: Asset | Cost | DateAcquired | Pool | StatutoryRate | AnnualAllowance AnnualAllowance formula: =Cost * StatutoryRate erca business income tax declaration form excel

F) TaxableProfit calculation (Tax_Calculation sheet)

G) Tax due & payments

H) Validation checks / reconciliations

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

Pro Tip: Ensure this matches your monthly VAT or turnover tax returns. ERCA will cross-check.

This is the identification area. You must manually enter: You might wonder: Why not just use the

Only business expenses are deductible. If you used a company vehicle for personal errands, you must apportion the fuel cost. The Excel sheet has no "fudge factor" — be honest.