Sheet 1 — Dashboard
- Dealer Profile — Business name, GSTIN, PAN, state, composition rate, turnover limit
- Annual Turnover Limit Tracker — Quarter-wise outward & exempt supplies, cumulative turnover, balance vs ₹1.5 Cr limit, % utilised, and automatic ✔/⚠ status alert
- CMP-08 Quarterly Tax Summary — CGST @0.5% + SGST @0.5% per quarter, late fee & interest columns, payment dates, filing reference numbers
- GSTR-4 Annual Return Status — Multi-year status with tax paid vs tax per return, shortfall tracking, ARN and filing dates
- Compliance Alerts & Key Dates — All 8 compliance tasks with due dates, forms, penalties, and live status flags
- Disqualification Watch List — 6 conditions that trigger exit from composition scheme with current status
- ITC Restriction Reminder — 6 key notes on what composition dealers cannot do
Sheet 2 — Monthly Sales Register
- Month-by-month Bill of Supply register for the full FY 2024-25
- Taxable sales + exempt sales → total turnover → CGST/SGST auto-calculated
- Running cumulative turnover and % of annual limit — updates as you enter data
- Yellow input cells clearly marked for easy data entry
Sheet 3 — Rate Reference & Eligibility
- Rate Card — All 6 composition categories with CGST/SGST/IGST rates and turnover limits
- Eligibility Quick Reference — 9 categories with ✔/✗ eligibility and legal provisions
- Procedural Checklist — 7 key actions (CMP-02, CMP-03, CMP-08, GSTR-4, opt-out) with forms, timelines, and consequences
To use: Replace dealer details in Sheet 1 and enter your actual monthly sales in Sheet 2 (yellow cells) — all totals, taxes, and compliance checks update automatically.
