Free GST Return Consolidator for GSTR-1 and GSTR-3B filings.
Upload multiple GSTR-1 and GSTR-3B portal files. The tool extracts financial metrics, maps them to their respective months, and generates a unified monthly comparison sheet that you can download as Excel.
Private and browser-based by design.
Your uploaded spreadsheets and draft project data are processed entirely in your browser using local Javascript. Absolutely none of your files, values, or financial figures are uploaded to our servers.
Open the GST Return Consolidator below.
Select your files to begin. You can save the project configuration locally as a draft or discard it.
When to use it
Use this when compiling multiple monthly filings into a consolidated annual or quarterly workbook, validating values across months, or reviewing values side-by-side.
When not to use it
Do not use this tool to replace professional audits or GST filing reconciliations. For full double-entry accounting audit logs, row-level verification, and smart GST matches, use Lejur Books.
Common questions about this free consolidator.
What does the GST Return Consolidator do?
It allows you to upload multiple GSTR-1 and GSTR-3B files (Excel, JSON, or PDF), extracts the financial metrics and tax amounts, auto-detects the return period/month, and aggregates them into a clean, monthly side-by-side consolidated view.
Can I export the consolidated data?
Yes. You can export the consolidated monthly worksheets directly to a structured Excel workbook (.xlsx) or save the draft project as a JSON file to resume later.
Is my uploaded data stored on Lejur One servers?
No. This tool is completely client-side and runs entirely within your browser. None of your files or financial numbers are uploaded to our servers, keeping your business data private and secure.
What file formats are supported?
The tool supports Excel (.xlsx, .xls), CSV, JSON, and PDF files exported from the official GST portal.
Move from working papers to controlled GST accounting.
Lejur Books connects GST vouchers, ledgers, reports, approvals, inventory, attachments, and audit trails in the live app.