Hi everyone,
I've built a free GST reconciliation tool that runs entirely inside Google Sheets — no new software to install, no subscripttions, nothing to learn from scratch.
Here's what it does:
✅ GSTR-1 generation with full invoice list + JSON export (GSTN portal ready)
✅ GSTR-3B auto-calculation with all 6 tables
✅ GSTR-2B vs Purchase Register reconciliation — invoice by invoice
✅ Color-coded mismatch report — matched, tax mismatch, missing in books, missing in 2B
✅ Telegram alerts — 3 days before GSTR-1 and GSTR-3B due dates
✅ Missing invoice alerts — tells you exactly which supplier and invoice needs action
✅ One-click buttons on each sheet for quick access
Who is it for?
Small businesses, traders, and CAs managing clients who are tired of doing reconciliation manually in Excel every month.
Why Google Sheets?
Your clients already use it. Zero learning curve. Works on any device. Data stays in their own Google account — nothing goes to any third-party server.
I am currently looking for feedback from CAs and finance professionals to improve it further. If you'd like to try it, drop a comment below or DM me. Happy to share it for free in exchange for honest feedback.
Looking forward to your thoughts.
Regards,
Anurag
CAclubindia
