+91 9500406111 · Mon–Sat, 9:30 am – 6:30 pm Englishதமிழ்
Free tool

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.

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.

WhatsApp