Template
GST Tracker
Most GST trouble is not about rates — it is about reconciliation. This tracker is built for Indian small businesses filing GSTR-1 and GSTR-3B every month: it records output GST on your sales, input tax credit on your purchases, and computes the net amount payable so you know the number before you log in to the portal. It also flags which invoices are missing from GSTR-2B so you do not claim credit you cannot support. Use it to file on time, claim every rupee of legitimate input credit, and keep a clean trail if a notice ever lands.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The template gives you a monthly register that splits GST into its two halves — what you collect and what you pay. On the sales side you log each taxable invoice with its CGST, SGST, and IGST so the output liability totals automatically. On the purchase side you log supplier invoices and the input tax credit they carry, and a status column lets you tick whether each one appears in your GSTR-2B. The sheet then nets input credit against output liability to show the cash you actually owe for the month, and a filing block tracks GSTR-1 and GSTR-3B due dates so nothing slips past the 11th or 20th. The result is a reconciliation-ready record rather than a last-minute scramble through bills.
Who it’s for
- Registered traders and retailers filing monthly GSTR-1 and GSTR-3B.
- Small manufacturers claiming input tax credit on raw materials and services.
- Service providers and consultants issuing tax invoices to business clients.
- Distributors handling a mix of intra-state (CGST/SGST) and inter-state (IGST) supply.
Fields included
How to use it
- Set up the month with your GSTIN, return period, and opening input credit balance.
- Log every sales invoice with taxable value and CGST, SGST, or IGST collected.
- Log every purchase invoice with the input tax credit it carries.
- Mark each purchase as matched or unmatched against your GSTR-2B from the portal.
- Let the sheet total output GST and eligible input credit and compute net payable.
- Pay the net liability and file GSTR-3B by the 20th; record the challan and ARN.
- Carry any unmatched invoices or excess credit forward and chase the supplier to upload them.
Preview
| Particulars | Taxable value (₹) | GST (₹) | Type |
|---|---|---|---|
| Sales — May invoices | 18,00,000 | 90,000 | Output |
| Purchase — yarn | 9,80,000 | 49,000 | Input (matched) |
| Purchase — transport | 1,00,000 | 5,000 | Input (matched) |
| Purchase — packing | 1,60,000 | 8,000 | Input (unmatched) |
| Net GST payable | — | 36,000 | CGST+SGST |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Shree Textiles in Surat makes ₹18,00,000 of taxable sales in May at 5% GST, collecting ₹90,000 as output tax. Their purchases — yarn, packing, and a transport service — carry ₹62,000 of input tax credit, but one supplier invoice of ₹8,000 ITC has not yet appeared in GSTR-2B. The owner claims only the matched ₹54,000 for May, leaving net GST payable of ₹36,000, and pays it before filing GSTR-3B on the 18th. The ₹8,000 is parked in an "unmatched" row; once the supplier uploads the invoice the following month, it is claimed then. By the 11th, GSTR-1 with the sales invoices is already filed from the same sheet, so the buyers can see their credit reflected.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)