Turn one or more filed GSTR-3B PDFs into a structured six-sheet Excel workbook. Extract identity, period, outward supplies, ITC, exempt or nil-rated inward supplies, and tax-payment details. Files are processed locally in your browser and are not uploaded.
or click to select one or more files from your computer
Browse Files| # | File Name | Status |
|---|
GSTR-3B is a monthly self-declaration return filed by registered GST taxpayers. It summarises outward supplies, inward supplies liable to reverse charge, eligible Input Tax Credit (ITC), and net tax payable. It must be filed by every normal taxpayer for each applicable period.
| Sheet | GSTR-3B Table | What is extracted |
|---|---|---|
| 1 — Identity & Period | Header / Filing Info | GSTIN, Legal Name, Trade Name, Period, Year, ARN, Date of ARN |
| 2 — Table 3.1 | Outward Supplies & RCM Inward | Rows (a)–(e): Taxable Value, IGST, CGST, SGST/UTGST, Cess |
| 3 — Table 3.1.1 | Supplies under Section 9(5) — ECO | Row (i) ECO pays tax & Row (ii) Registered person through ECO: Taxable Value, IGST, CGST, SGST, Cess |
| 4 — Table 4 | ITC Available, Reversed & Net | Rows A(1)–A(5), B(1)–B(2), Net C: IGST, CGST, SGST, Cess |
| 5 — Table 5 | Exempt, Nil-Rated & Non-GST Inward Supplies | Composition / Exempt / Nil rated supply and Non-GST supply: Inter-State & Intra-State values |
| 6 — Table 6.1 | Payment of Tax | Each tax head row (IGST, CGST, SGST/UTGST, Cess) for both (A) Other than RCM and (B) RCM & 9(5): Tax Payable, Net Tax Payable, ITC paid (IGST/CGST/SGST/Cess), Cash Paid, Interest Paid, Late Fee Paid |
Upload GSTR-3B PDFs from different months or different GSTINs in a single batch. Each PDF produces one row in the Identity sheet and one row per table-row in Sheets 2–5, with GSTIN + Period + Year as anchor columns throughout — making period-wise or entity-wise pivot analysis straightforward in Excel.
Table 3.2 (inter-state supply breakup by recipient type) and Table 5.1 (interest & late fee for previous period) are not extracted by this tool. These are available in the original filed PDF for reference and verification.