GST Margin Scheme Calculator

Sheet 1 — Calculator (6 Sections): Section 1 – Property & transaction details (address, parties, dates, GST registration) Section 2 – Acquisition cost (purchase price + GST paid on acquisition + other costs) Section 3 – Sale price (contract price + adjustments) Section 4 – Margin calculation using the correct ATO formula: Margin × Rate […]

🔄 Published Jul 2026

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

⬇ Available Downloads

Excel Format (Editable) 🔒

XLSX Pro 11 KB ✏️ Editable

Sheet 1 — Calculator (6 Sections):

  • Section 1 – Property & transaction details (address, parties, dates, GST registration)
  • Section 2 – Acquisition cost (purchase price + GST paid on acquisition + other costs)
  • Section 3 – Sale price (contract price + adjustments)
  • Section 4 – Margin calculation using the correct ATO formula: Margin × Rate ÷ (1 + Rate)
  • Section 5 – Results summary showing GST payable, net margin, and effective GST rate as %
  • Section 6 – Eligibility checklist (pre-2000 acquisition, written agreement, GST registration, etc.)

Sheet 2 — Notes & Guide: Explains what the scheme is, who qualifies, how to use the calculator, and key formula references.

Colour coding follows industry standards:

  • 🔵 Blue = input cells (user-editable)
  • ⚫ Black = formula cells (auto-calculated)
  • 🔵 Light blue = summary result rows

Just fill in the blue cells with your transaction values and all GST calculations update automatically.

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.