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.
개발자:
정보 업데이트:2026년 10월 21일
호환 기기:
리뷰 없음
사용자가 없습니다.
개요
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
추가정보
가격유료 기능을 포함한 무료
개발자
지원
개인정보처리방침
서비스 약관
GSTR-2B Reconciler에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
GSTR-2B Reconciler에서 Google 계정에 액세스해야 함
이렇게 하면 GSTR-2B Reconciler에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
외부 서비스에 연결
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴