Google Workspace Marketplace
GSTR-2B reconciliation in Google Sheets for CAs. Match the 2B with the purchase register, see mismatches with reasons and claimable ITC by supplier, and chase missing invoices.
Av:
Ändrades senast:21 oktober 2026
Fungerar med:
Det finns inga recensioner
Inga användare
Översikt
Reconcile a client's GSTR-2B with their purchase register in Google Sheets. No macros, no VBA, no Windows: it runs in the browser on any computer.

How it works
1. Download the GSTR-2B Excel from the GST portal and import it into a Google Sheet.
2. Import the purchase register from Tally, Busy, Zoho or your own format.
3. Open Extensions > GSTR-2B Reconciler > Reconcile GSTR-2B, pick the tabs, check the column mapping and click Reconcile.

The sidebar shows the result at a glance: GSTR-2B against the books, ITC you can claim now and ITC on hold. The full result is written into new tabs of the same spreadsheet:
- Summary: counts and head-wise totals (IGST, CGST, SGST/UTGST, cess), ITC as per 2B and as per books, claimable ITC, and ITC by supplier GSTIN
- Matched: pairs matched exactly or within tolerance, with a note on any difference
- Mismatched: the same document with a different value, date, tax, tax head or GSTIN, with the reason
- Missing in 2B: in the books but not in 2B, so the ITC is on hold
- Missing in books: in 2B but not recorded yet
- Follow-ups: one row per supplier with the invoices to chase and a message ready to paste into email or WhatsApp
- Recon history: one row per run

Matching
- Exact match on supplier GSTIN, invoice number, invoice date and taxable value
- Fuzzy matching that macros miss: INV/0045/26-27 = inv-45-26-27, SB00123 = sb 123, dates within 3 days, amounts within ₹1 (both tolerances adjustable)
- Flags tax under the wrong head (IGST vs CGST + SGST), rate differences, GSTIN typos (checksum verified) and duplicate entries in the books
- Handles B2B, B2BA, B2B-CDNR and B2B-CDNRA, and respects 2B's ITC availability and reason columns
- Reads the portal's multi-row headers; the column mapping is remembered per client spreadsheet, so next month's run is one click

New to it? Click "Try with sample data" in the sidebar. It adds two tabs of made-up invoices, and runs on them are not counted against the free plan.

Pricing
Free: up to 200 invoices a month, with every feature. Re-running the same 2B in the same month is not counted again.
Pro: unlimited invoices for ₹999 a year. Buy it at creet.in/gstr2b; payment is handled by Dodo Payments, and you paste the licence key into Extensions > GSTR-2B Reconciler > Licence and plan. 14-day money-back guarantee.

Privacy
Your data stays in your spreadsheet. The add-on can read and write only the spreadsheet it is opened in, not any other file in your Drive. The only outside call is a licence-key check with Dodo Payments for Pro users, and it carries no spreadsheet data.

Support: support@creet.in
Ytterligare information
PriserKostnadsfritt med betalfunktioner
Utvecklare
Support
Integritetspolicy
Användarvillkor
GSTR-2B Reconciler frågar efter de behörigheter som visas nedan. Läs mer
GSTR-2B Reconciler behöver åtkomst till ditt Google-konto
Detta ger GSTR-2B Reconciler behörighet att:
Visa och hantera kalkylark som det här programmet har installerats i
Visa och kör externt webbinnehåll i meddelanden och sidofält i appar från Google
Ansluta till en extern tjänst
Se den primära e-postadressen för ditt Google-konto
Visa dina personliga uppgifter, inklusive personliga uppgifter som du har gjort offentliga
Recensioner
Språk:
Sortera efter:
Google verifierar inte recensioner eller betyg. Läs mer om recensioner
Inga kommentarer
Sök
Rensa sökning
Stäng sökrutan
Googles appar
Huvudmeny