π Tax Provision Summary β The core working with sections A through K:
- A Book Profit (P&L linkage)
- B Disallowances (depreciation, provisions, cash payments, 43B items, etc.)
- C Allowances (IT depreciation, additional depreciation, bad debts, etc.)
- D Gross Total Income
- E Chapter VI-A deductions (80C, 80D, 80G, 80JJAA, etc.)
- F Total Taxable Income
- G Tax computation (base rate, surcharge, H&E cess β all input-driven)
- H MAT computation u/s 115JB with automatic higher-of comparison
- I Tax credits (TDS, Advance Tax, MAT credit, DTAA relief)
- J Net Tax Payable / (Refund)
- K Accounting provision (current + deferred tax movements) + Effective Tax Rate
π Deferred Tax (DTA-DTL) β Temporary difference schedule per Ind AS 12 / AS 22, with book vs. tax base comparison and net DTA/(DTL) position.
π³ Advance Tax Tracker β All 4 instalments with % due, amount required, amount paid, shortfall/excess, linked to estimated tax liability.
β TDS Reconciliation β Section-wise TDS (194A, 194C, 194I, 194J, 194H) reconciled between books and Form 26AS, with automatic mismatch flagging.
π Assumptions & Notes β 12 key notes covering tax regime, MAT, surcharge, ICDS, transfer pricing, carry-forward losses, and Form 3CD.
Color coding follows industry standard: blue = input cells, black = formulas, with yellow highlights on rate assumptions.