FREE GST UTILITIES

Make your GST work easier to review.

Use these practical spreadsheet tools and checklists to organize GST records before filing, reconciling or discussing them with a professional.

Important: These tools provide general information and checklist support only. They do not access the GST portal, confirm registration status, determine tax liability or replace professional advice. Rules and deadlines can change.

01 · SPREADSHEET RECONCILIATION

GSTR-2B vs Purchase Register

Download the template, fill the two input sheets, upload the same workbook, and download an Excel reconciliation report.

Download the template first

Do not rename the GSTR2B and Purchase Register sheets. Replace the sample rows with your own data.

Fill both sheets

Use the same invoice number and supplier GSTIN in both sheets. Tax columns should contain numbers without currency symbols.

View required columns

Upload the completed template

Your workbook is processed in this browser and is not uploaded to Smart Books.

Required column names

Use these headers in both sheets. The template already contains them.

Supplier GSTIN · Supplier Name · Invoice Number · Invoice Date · Taxable Value · IGST · CGST · SGST · Cess · Total Tax · Period · Notes

02 · RETURN PREPARATION

GSTR-1 Excel to JSON preparation

Download the workbook, fill the supported GSTR-1 sheets, upload it here, and download a structured JSON draft for review.

Important limitation: GSTN changes return schemas and validations. This browser tool creates a structured GSTR-1 JSON draft; it is not the official GSTN Returns Offline Tool and cannot guarantee direct portal acceptance. Validate the file with the current official GSTN offline utility before upload.

Download the GSTR-1 workbook template

Keep the sheet names unchanged. Use the instructions sheet and fill only the sections relevant to your return.

Enter return details

Supplier GSTINReturn period

Upload the completed workbook

The workbook is processed in this browser and is not sent to Smart Books.

03 · EXPORT DOCUMENTS

Shipping Bill PDF to Excel

Select several shipping bill PDFs or a folder. The tool reads the first two pages and creates one Excel row per PDF.

Browser-only processing: PDFs stay on your device. This extractor follows the fixed-position approach of the desktop script and works best when all shipping bills use the same selectable-text layout. Scanned PDFs may not work without OCR.

Select PDF files

You can select multiple PDF files at once.

Or select the folder containing PDFs

Folder selection is supported by Chrome and Edge on desktop.

Extract and download Excel

Output columns: Port Code, SB No, SB Date, Invoice No, Invoice Date, FOB Value, Freight, Insurance and IGST Amt.

04 · EXPORT READINESS

Exporter and GST refund checklist

Select the workflow you are preparing for and organize the supporting record trail.

WorkflowPeriod being reviewed

NEED A SECOND PAIR OF EYES?

Bring your records into a clearer routine.

Smart Books Accounting provides virtual bookkeeping, GST coordination and exporter support from Tuticorin for businesses across India.

Discuss your requirements ↗WhatsApp us ↗