Free GST Reconciliation Tool in Google Sheets – GSTR-1, GSTR-3B, GSTR-2B + Telegram Alerts

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

Replies (9)
Quick Summary
GSTR tool in Google Sheets enables GSTR-1 JSON, auto GSTR-3B, 2B reconciliation, mismatch reports and alerts. Useful for CAs and SMEs to simplify monthly GST compliance without new software.

Excellent problem solving idea, please let me try AashokFC.Advisory @ Protonmail.com

I do every month GSTR 2B reco with books. It has about 3000 invoices per month, so it is a lengthy task every month. I would like to use your tool, so that I can check its functionality.

i do monthly reconciliations that take a lot of time can you tell me more about this tool

hi 

Please share working sheet 

manojkumar.jha185 @ gmail.com

Good tool for anyone reconciling manually. One thing worth flagging with the April 2026 IMS changes: mismatches now have to be fixed upstream in GSTR-2B by actioning your IMS records before the 20th, rather than being corrected inside GSTR-3B. The workflow is to check GSTR-2B on the 14th, accept or reject invoices in IMS, then file 3B with the clean ITC figure. For businesses spending too much time on this each month, Tax Garden handles the full [GST return filing](https://taxgarden.in/services) including 2B-to-books matching as part of the monthly service.

Sir, plz provide me also

please share a tool on ashorchid09 @ gmail.com

we need it, thanks.

Pls Share Google Sheet

@ namitpshah @ gmail.com

 

The workflow is promising, especially invoice-level 2B matching and a clear mismatch report. Before relying on the JSON export or auto-calculated 3B, validate the output against current GSTN schema and portal requirements, and test edge cases such as credit notes, amendments, reverse charge, and ITC reversals. Telegram reminders should also be checked against the applicable due dates and any extensions.

For GST compliance, a smooth Sheets workflow can reduce routine reconciliation and review time. Manual practice work is difficult; automation cuts repetitive effort while leaving validation and professional judgment in your hands. At Jir AI we provide 2,000+ AI agents and 650+ integrations to streamline your practice’s day-to-day workload. WhatsApp us to explore practical ways to improve your workflow https://wa.me/message/3HVOZ7HIY4ESC1.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details