Creet
GSTR-2B ReconcilerGoogle Sheets add-on for India
Reconcile GSTR-2B with the purchase register, inside Google Sheets.
GSTR-2B Reconciler is a Google Sheets add-on for chartered accountants and GST practitioners. Import the GSTR-2B Excel from the GST portal and the client's purchase register into one spreadsheet, click Reconcile, and get matched, mismatched and missing invoices with claimable ITC for every supplier GSTIN. No macros, no VBA, no Windows.
| Supplier GSTIN | As per 2B | As per books | Claimable |
|---|---|---|---|
| 27AAPFU0939F1ZV | 1,24,560 | 1,24,560 | 1,24,560 |
| 29AAACX1234B1Z5 | 48,210 | 52,900 | 48,210 |
| 07AAAPZ5678C1ZQ | 0 | 18,000 | 0 |
| Total | 1,72,770 | 1,95,460 | 1,72,770 |
What the add-on does
Everything a monthly 2B reconciliation needs, written as tabs in the client's own spreadsheet.
- Exact and fuzzy matching
- Matches on supplier GSTIN, invoice number, date and taxable value. Catches what macros miss:
INV/0045/26-27=inv-45-26-27, dates within 3 days, amounts within ₹1. Both tolerances are adjustable. - Mismatches with the reason
- The same invoice with a different value, date or tax, tax under the wrong head (IGST in 2B, CGST + SGST in the books), or a GSTIN typo in the books, each with the reason spelt out.
- Missing on either side
- Missing in 2B: hold the ITC and chase the supplier. Missing in books: check receipt, then record it. Duplicate entries in the books are flagged.
- ITC summary by supplier
- Head-wise totals (IGST, CGST, SGST/UTGST, cess), ITC as per 2B and as per books, claimable ITC and ITC at risk for every supplier GSTIN.
- Notes and amendments
- Reads the portal's B2B, B2BA, B2B-CDNR and B2B-CDNRA tabs, including the two- and three-row headers. Credit notes count negative in every ITC total.
- Remembers each client
- The column mapping is saved in each client's spreadsheet, so next month is one click. Every run is logged in a Recon history tab.
How it works
Import the 2B
Download the GSTR-2B Excel from the GST portal and import it into a Google Sheet (File → Import → Insert new sheet(s)).
Add the purchase register
From Tally, Busy, Zoho or your own format, as another tab in the same spreadsheet.
Reconcile
Extensions → GSTR-2B Reconciler → Reconcile GSTR-2B. Confirm the columns in the sidebar and click Reconcile. The result tabs are written into the same spreadsheet.
The add-on writes six tabs: Summary, Matched, Mismatched, Missing in 2B, Missing in books and Recon history. Each run replaces the add-on's own result tabs; your source tabs are never changed.
Pricing
Free for a small practice. One yearly price when you need more.
Free
₹0
- Up to 200 invoices a month
- Every matching rule and every result tab
- Column mapping saved per client
- Re-running the same 2B in the same month is not counted again
Pro 14-day money-back
₹999 / year
- Unlimited invoices
- Everything in Free
- One licence key works in every spreadsheet you open with your Google account
- Email support
Payments are processed by Dodo Payments (merchant of record). You receive a licence key by email; paste it into Extensions → GSTR-2B Reconciler → Licence and plan.
How invoices are counted: each row of the result counts once. A matched or mismatched pair is one, and each unmatched invoice on either side is one. Credit and debit notes count like invoices. The count resets on the 1st of every month (Indian time). A run that would cross 200 is stopped before anything is written.
Your data and the permissions it asks for
Your client data stays in your spreadsheet. The add-on runs on Google's own Apps Script servers and has no server of its own. On first use Google asks you to allow three permissions:
| Permission | Why the add-on needs it |
|---|---|
View and manage spreadsheets that this application has been installed inspreadsheets.currentonly | To read the GSTR-2B and purchase-register tabs you pick and to write the result tabs, in the spreadsheet the add-on is opened in. It cannot open any other file in your Google Drive. |
Display and run third-party web content in prompts and sidebars inside Google applicationsscript.container.ui | To show the add-on's sidebar inside Google Sheets. |
Connect to an external servicescript.external_request | Only to activate and re-check a Pro licence key with Dodo Payments, our payment provider: once when you activate, then at most once a week, or when you click Check again. The request carries the licence key and a fixed product name, nothing from your spreadsheet. On the free plan this permission is never used. |
The add-on does not ask for your name, email address, contacts, Gmail or Drive. Full details are in the Privacy Policy.
Install
GSTR-2B Reconciler is free on the Google Workspace Marketplace. In any Google Sheet, open Extensions → Add-ons → Get add-ons, search for "GSTR-2B Reconciler" and click Install, or use the button below. Then open a spreadsheet and choose Extensions → GSTR-2B Reconciler → Reconcile GSTR-2B.
Tip: set File → Settings → Locale to India so dd-mm-yyyy dates read correctly, and untick "Convert text to numbers, dates, and formulas" when importing so invoice numbers like 00123 stay intact.
FAQ
Does my client data leave Google?
No. Invoices, GSTINs and amounts are read and written inside Google Sheets only. The single outside call is the Pro licence check, which sends your licence key to Dodo Payments and nothing else.
Can it see my other files?
No. It only has access to the spreadsheet it is opened in, and only while you use it there.
Does it log in to the GST portal or file anything?
No. You download the GSTR-2B yourself. The add-on never connects to the GST portal and never files, accepts or rejects anything in IMS.
Which 2B tabs does it reconcile?
B2B, B2BA, B2B-CDNR and B2B-CDNRA. ISD and IMPG have no supplier invoice to match, and ECO, B2B-DNR and the reversal and rejected tabs are not handled yet.
Is this affiliated with GSTN or the Government?
No. GSTR-2B Reconciler is an independent tool. It is not endorsed by or affiliated with the Goods and Services Tax Network, CBIC, the Government of India or Google.
Is the result final?
It is a working paper. Check the Mismatched and Missing tabs before you claim ITC or file a return; you remain responsible for the figures you file.
Support
Email support@creet.in with what you were doing and the exact message the sidebar showed. Pro buyers: include your order number. Please don't send client spreadsheets; if we need to see a file, we will ask for a copy with the client's details removed.