Structure & Columns
- Supplier Details — Name, GSTIN, Place of Supply
- Invoice Details — Invoice No., Date, Type (B2B/B2C/URD), Category, Invoice Value
- Tax Values — Taxable Value, Tax Rate, Total Tax Amount
- IGST / CGST / SGST Breakup — Rate, Amount, Eligible & Ineligible splits for each
- ITC Eligibility — Status, Eligible ITC, Blocked ITC (Sec 17(5)), Ineligible ITC
- Remarks — Statutory reference notes
Key Features
- 🟢 Color-coded ITC status — Green (Eligible), Red (Blocked/Ineligible), Amber (Partial)
- 📊 Auto-calculated Totals row with SUM formulas
- 📋 ITC Summary block — shows IGST/CGST/SGST eligible ITC and Net ITC Claimable
- 🏷️ Legend explaining each ITC status
- ⚠️ Section 17(5) blocked credits correctly flagged (motor vehicle, accommodation, works contract)
- 🖨️ Print-ready (A4 landscape, frozen headers, print title rows)
