GST Inventory Tracker

What This Tracker Covers

This inventory tracker is designed specifically for Indian SMEs who need to maintain GST-compliant stock records. Every item tracked includes the fields required for GSTR-3B filing and audit readiness.

Required Fields Per Item

• SKU / Product Code: Unique identifier for each inventory item.
• Item Name & Description: Clear, descriptive name of the product or spare part.
• HSN Code: 4-8 digit Harmonised System of Nomenclature code for GST classification.
• Unit of Measure: Pieces, metres, litres, boxes, or as applicable.
• Quantity on Hand: Current stock level after all receipts and issues.
• Unit Price (INR): Purchase price per unit in Indian Rupees.
• Total Value (INR): Quantity × Unit Price, auto-calculated.

Vendor Details to Maintain

• Vendor Name: Legal name as per GST registration.
• GSTIN: 15-digit GST Identification Number. Validate format at entry.
• PAN: Permanent Account Number for TDS compliance.
• HSN/SAC Mapping: Map each vendor's products to the correct HSN codes.
• Payment Terms: Credit period, advance requirements, and due dates.

GST-Specific Columns

• IGST / CGST / SGST Split: Tax component breakdown for inter-state vs intra-state purchases.
• Taxable Value: Price before GST addition.
• Invoice Reference: Link to purchase invoice for audit trail.
• E-Way Bill Number: Required for inter-state transfers above ₹50,000.

Monthly Reconciliation Process

At the end of each month, reconcile your tracker with GSTR-2A (auto-drafted purchases) and GSTR-3B (returns filed). Flag any mismatch between your tracked purchases and the GST portal data. Investigate and resolve before the 20th of the following month.