Sheet 1 – Credit Note Tracker (dark red theme) Tracks 8 sample CNs with full GST breakdown (IGST/CGST/SGST), original invoice reference, reason for issuance, GSTR-1 reflection status, and accounting entry status. Pending items auto-highlight in red. Includes a Quick Summary box with live counts.
Sheet 2 – Debit Note Tracker (dark green theme) Same structure for DNs — covers under-billing, price revisions, interest charges, and additional cost recoveries, all with party GSTIN and place of supply.
Sheet 3 – Combined Register Single view of all CN + DN entries side-by-side with colour coding (pink = CN, green = DN), plus a CN vs DN comparative summary showing net taxable value and GST impact.
Sheet 4 – GST Return Impact Maps notes to GSTR-1 Table 9B and calculates the GSTR-3B net output tax adjustment (DN additions minus CN reductions) — ready to use for return filing.
Sheet 5 – Summary Dashboard Executive view pulling live totals from all sheets, with net impact in red and a full colour legend & user guide.
