Upload one or more GSTR-3B filed return PDFs and instantly extract GSTIN, period, outward supply details (Tables 3.1 & 3.1.1), ITC details (Table 4), exempt / nil-rated inward supply values (Table 5), and tax payment details including ITC utilisation and cash paid (Table 6.1) into a structured multi-sheet Excel workbook. Supports multiple periods in a single upload. Processed entirely in your browser — no data is uploaded to any server. Free tool by CA Jatin Karda & Co., Nagpur.
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.