Company Tax Provision Working

πŸ“Š 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 […]

πŸ”„ Published Jul 2026

Trusted by 6,00,000+ CA professionals across India

⬇ Available Downloads

Excel Format (Editable) πŸ”’

XLSX Pro 20 KB ✏️ Editable

πŸ“Š 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.

Get Unlimited Access with Pro Membership

Download unlimited formats, get editable files, and access premium CA resources.

  • Unlimited downloads
  • Editable Word / Excel formats
  • Premium CA toolkit access
  • GST / ROC / Audit templates
  • Priority format updates
  • AI drafting tools (coming soon)
β‚Ή99
per month
β‚Ή1,499
lifetime
πŸ‘‘ Upgrade to Pro

What is Included in This Format?

This format includes a professionally structured template ready for immediate use. Fields are clearly labeled for easy customization.

Disclaimer: This format is provided for general information only. Please review applicable laws and professional requirements before use.