GSTR-2B JSON to Excel Converter
Convert GSTR-2B JSON to multi-sheet Excel — free, browser-only
Upload the GSTR-2B JSON (the static monthly ITC statement from GSTN) and get a multi-sheet Excel for each section. Or upload Excel back to reconstruct JSON. All in your browser.
2B mismatches = lost ITC. We fix it.
Monthly 2B reconciliation + vendor chase emails + non-compliance reports. ₹999/mo.
What is a GSTR-2B JSON to Excel Converter?
GSTR-2B is the static auto-generated ITC statement that GSTN produces on the 14th of each month. Unlike the dynamic GSTR-2A, GSTR-2B is a fixed snapshot — once generated it does not change. From FY 2021-22, ITC claims in GSTR-3B must be based on GSTR-2B. This makes it the most important GST document for ITC computation.
The GSTR-2B JSON from the portal contains all eligible inward supplies from suppliers who filed by the 13th, grouped by section (b2b, cdnr, impg, etc.) and nested by supplier GSTIN. This converter flattens those nested structures into a clean multi-sheet Excel, one row per invoice, with all key fields as columns.
For systematic ITC reconciliation (matching GSTR-2B against your purchase register), use the GSTR-2B Reconciliation tool on this site after converting.
Why use this GSTR-2B JSON to Excel Converter
Built for Indians, by Indians. Every number, every formula, every slab — tuned to FY 2026-27 reality.
Static month snapshot
GSTR-2B represents a fixed cutoff. The converter preserves all fields exactly — no modification of the underlying data.
Multi-sheet Excel
b2b, cdnr, cdnur, impg, imps sections each get their own Excel sheet with one row per invoice.
JSON ↔ Excel
Convert GSTN JSON to Excel for review. Upload Excel back to get a reconstructed JSON for records.
Private
All processing in your browser. No upload to any server, no sign-in required.
Using the GSTR-2B JSON to Excel Converter in 4 steps
No onboarding, no signup. Answer three fields and the numbers update live.
Download GSTR-2B JSON from portal
Log in to GST portal → Returns → View GSTR-2B → Download JSON. The 2B is available from the 14th of each month.
Upload here
Drag and drop the JSON or click to browse. Upload multiple files if your return was split across parts.
Browse sections
Click section pills (b2b, cdnr, impg…) to preview invoices. Use the filter to search by supplier GSTIN or invoice number.
Download and reconcile
Download all sections as a multi-sheet Excel. Then use the GSTR-2B Reconciliation tool on this site to match against your purchase register.
Tips to get the most out of it
Download GSTR-2B on or after the 14th each month — it is not available before the cutoff date.
If your GSTN portal shows GSTR-2B in multiple parts (Part A, Part B), download all parts and upload them together here — they are merged automatically.
ITC from GSTR-2B is subject to the 105% cap rule. The converter shows raw ITC figures; apply the cap during GSTR-3B preparation.
IMPG rows in GSTR-2B come from ICEGATE (Indian Customs). Cross-check these against your Bill of Entry records to confirm IGST paid is accurately captured.
Save the multi-sheet Excel as your monthly ITC record. GSTN recommends retaining GST records for 6 years.
Real-world scenarios
How Indians actually use this converter — concrete inputs, concrete outcomes.
Monthly ITC computation
Finance team converts GSTR-2B JSON to Excel on the 14th, sums the b2b IGST and CGST+SGST columns to compute total eligible ITC for the month, then enters this in the GSTR-3B draft.
Blocked ITC identification
CA filters the GSTR-2B Excel b2b section for suppliers in restricted GST sections (Section 17(5) blocked credits) and removes those from the ITC claim before filing 3B.
Reconciling 2B against purchase register
Accounts team downloads GSTR-2B Excel and runs it through the GSTR-2B Reconciliation tool on this site, uploading the purchase register Excel on the other side, to get a color-coded match report.
Frequently Asked Questions
Still have a question? Our team replies within a business day.
GSTR-2B is generated by GSTN on the 14th of each month (or the 13th for quarterly filers). It reflects all supplier GSTR-1 filings made by the 13th.
No — from FY 2021-22, ITC in GSTR-3B is capped at 105% of the eligible ITC as per GSTR-2B. Claiming beyond GSTR-2B values will trigger notices.
GSTR-2A is dynamic and updates continuously as suppliers file. GSTR-2B is a static snapshot generated once per month and does not change after generation. Use 2B for ITC computation.
No. The converter reads the JSON and produces a flat Excel view of the same data. No values are modified — it is a display/formatting tool.
Yes. Upload all parts together — they are merged section-by-section before display. The total row count will reflect all parts combined.
Yes. Everything happens in your browser. No data is sent to any server. Close the tab and the data is gone.
Want expert help beyond the converter? Talk to our team.
Our finance team helps Indian businesses and individuals plan investments, file taxes, and build wealth — without the jargon.
Book a free consultationLet's talk about your business.
Tell us what you're working on and where you want to go. We'll put together a plan. No obligation, no sales pitch.
- Free 30-minute call
- A plan built around your goals
- No obligation, no pressure
- Your own account manager