Skip to content
Toolyverse

№022 · GST tools

GSTR-3B PDFs to Excel

Turn a year of GSTR-3B returns into one workbook: outward supplies, input tax credit, interest and tax paid through ITC and in cash, month by month. Every return is checked: 4A − 4B must equal 4C, tax payable must agree with Table 3.1, and ITC used plus cash must equal the tax payable.

How to use GSTR-3B to Excel

  1. 1Download GSTR-3B PDFs from the portal: Returns dashboard → GSTR-3B → Download filed GSTR-3B.
  2. 2Drop them all here together; GSTINs, months and years are sorted automatically.
  3. 3Check the coverage grid and any notes, then download the Excel file.

Questions people ask

What is in the Excel file?

A list of the returns read, a coverage grid, all GSTINs for the year side by side, one month-wise sheet per GSTIN, the tax liability breakup printed in each return, and optionally every figure of every return.

Why does a return show "Check notes"?

Its own figures do not agree, for example net ITC is not 4A minus 4B, or tax paid does not equal tax payable. The note names the heads that differ.

Does it work for quarterly (QRMP) returns?

Yes, the tax period is read from the return; quarterly returns are placed at the last month of their quarter.