GSTR-1, GSTR-2B and GSTR-3B consolidation to Excel
Combine up to 12 months of returns downloaded from the GST portal into one clean Excel workbook, with month-wise detail and live totals.
Your files never leave your computer.
GSTR-1: add the monthly files
How to download from the GST portal
GST portal → Returns → Returns Dashboard → pick the financial year and month → GSTR-1 → Download → Generate JSON file to download. Upload the JSON, or the ZIP the portal gives you, for each month.
GSTR-2B: add the monthly files
How to download from the GST portal
GST portal → Returns → Returns Dashboard → pick the month → GSTR-2B → Download → Generate Excel file to download. Upload the monthly Excel files (named like 042026_GSTIN_GSTR2B….xlsx) as downloaded; do not edit them.
The first month's file is used as the template: every sheet, heading and style stays exactly as the portal made it.
GSTR-3B: add the monthly files
How to download from the GST portal
GST portal → Returns → Returns Dashboard → pick the month → GSTR-3B → Download (filed return) → Download JSON. Upload the JSON or ZIP for each month.
GSTR-1 vs GSTR-3B vs GSTR-2B
Convert the same months in the GSTR-1, GSTR-3B and GSTR-2B tabs first. This view then compares, month by month, outward tax in GSTR-1 with GSTR-3B Table 3.1 and ITC in GSTR-2B with GSTR-3B Table 4(A)(5).
Questions
Are my files uploaded to your server?
No. The files are read and the Excel is built inside your own browser. Nothing is sent to kanaksolutions.com or anyone else, so the tool also works for confidential client data.
How many months can I combine?
Up to 12 months of one GSTIN at a time. Upload them in any order; they are arranged April to March automatically. Missing months are pointed out.
Why is the GSTR-2B output in the portal's own format?
So it reads exactly like the file you know: the first month's download is kept as it is, the other months' invoices are added below, and the summary sheets are added up.
Are the totals live formulas?
Yes. The GSTR-1 summary and the GSTR-3B form use SUMIFS on the detail and month-wise sheets, so you can filter, check or edit and the totals follow.
Is it free?
Yes, free for everyone. If you want us to reconcile books with GSTR-2B or prepare your annual return, see our services.
This tool arranges and adds up the data in your downloaded returns; it does not change or file anything. Check the output before relying on it for a return or a reconciliation.
