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.
Autor:
Ficha actualizada:21 de octubre de 2026
Compatible con:
Sin reseñas
No hay ningún usuario
Información general
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
Información adicional
PrecioPrueba sin coste adicional con funciones de pago
Desarrollador
Asistencia
Política de privacidad
Términos del Servicio
GSTR-2B Reconciler solicitará los permisos que se indican abajo. Más información
GSTR-2B Reconciler necesitará acceder a tu cuenta de Google
Con este permiso, GSTR-2B Reconciler podrá:
Ver y administrar hojas de cálculo en las que se ha instalado esta aplicación.
Mostrar y publicar contenido web externo en las solicitudes y barras laterales de las aplicaciones de Google
Conectarse a un servicio externo.
Ver la dirección de correo electrónico principal de tu cuenta de Google.
Consultar tu información personal, incluida la que has compartido públicamente
Reseñas
Idioma:
Ordenar por:
Google no verifica las reseñas ni las valoraciones. Más información sobre las reseñas
Sin comentarios
Búsqueda
Borrar búsqueda
Cerrar búsqueda
Aplicaciones de Google
Menú principal