In this guide
Reconciling Physical Stock to GST Returns
Three records describe the same movement of goods and they rarely agree: the stock on your floor, the books of account, and what was reported in GSTR-1 and GSTR-3B. Reconciliation is the exercise of explaining the gaps rather than closing them, because most of the gaps are legitimate. Timing accounts for a large share: goods dispatched before a period end and invoiced after it, or the reverse. Stock transfers between your own registrations move goods without a sale. Sales returns and credit notes land in one record before the others. Job work movements leave your premises without leaving your books at all. Free samples, damages and write-offs each have their own treatment. What exposure looks like is simple: an unexplained excess of physical stock over what the returns support raises a question about unrecorded purchases, and a shortfall raises one about unrecorded sales, and both invite scrutiny that is far cheaper to pre-empt.
What Each Record Actually Says
Three records describe the same goods and each answers a different question, which is why they cannot simply be compared line for line. Physical stock at a date is a statement about quantity and location at one moment: what is standing in the godown, in whatever condition it is in, whether or not anybody has invoiced it. It says nothing about ownership or about tax. GSTR-1 reports outward supplies for the period, invoice by invoice, which means it describes documents rather than movements. Goods that left without an invoice do not appear; invoices raised for goods that have not yet moved do. That distinction is the source of most reconciling items. GSTR-3B is a summary return carrying the aggregate outward supplies, the tax payable, and the input tax credit claimed for the period. It is not a transaction listing and cannot be traced to individual goods at all. Comparing it to stock therefore only works at the level of totals and inference. Understanding what each record is for prevents the common error of treating a difference between them as necessarily an error in one of them.
Where the Mismatches Arise
Most differences are legitimate and recur every period, which is why a standing schedule works better than an investigation. Timing between dispatch and invoice is the largest category: goods that physically left before a period end and were invoiced after it, or invoiced before and dispatched after. Both are ordinary, both move the physical position relative to the return, and both reverse in the following period. Goods returned and credit notes are the second. A return arrives physically before the credit note is issued, and sometimes long before, so the stock rises without any corresponding reduction in reported outward supplies until the note is raised. Where returns are received and never credited, the difference does not reverse at all. Stock transfers between registrations are the third and the least intuitive. Goods moving between two GSTINs of the same legal entity are supplies for GST purposes even though nothing has been sold and the group's total stock is unchanged. From the perspective of a single registration, stock has left and a supply has been reported; from the perspective of the entity, nothing has happened at all. Reconciling without separating these movements out will always show a gap.
Branch Transfers and Multiple Registrations
An entity registered in several states is a single legal person holding several registrations, and GST treats each registration as distinct for most purposes. Goods moving from a Maharashtra godown to a Karnataka one are therefore a supply, invoiced, reported and taxed, despite there being no customer and no sale. Anyone reconciling at the entity level without accounting for this will find outward supplies substantially exceeding actual sales, and the excess is exactly the internal movement. The e-way bill trail is the evidence that makes these movements provable rather than asserted. Each transfer above the threshold generates a bill recording the consignor, the consignee, the goods, the quantity and the vehicle, which independently corroborates that the goods physically moved between the two registrations on the dates claimed. Where a transfer is recorded in the books with no corresponding e-way bill, the movement is unsupported. Why one entity looks like several is the practical consequence for anybody reading the returns. Consolidated financial statements show one business; the GST filings show several, each with its own stock, its own supplies and its own credit position, and reconciling between the two views is a separate exercise from reconciling stock to returns within one registration.
What an Officer or Auditor Compares
The comparison runs on three axes, and a business that has run it internally is rarely troubled by it. The first is stock declared against returns filed: does the movement implied by the outward supplies reported reconcile to the movement the stock records show over the same period. Large divergences invite the question of whether supplies were made without being reported. The second is input credit against stock on hand. Credit is claimed on inward supplies, and where the goods those supplies represent are neither in stock nor accounted for in outward supplies, the credit itself is in question, because credit on goods lost, destroyed, written off or disposed of by way of gift is not admissible and has to be reversed rather than merely explained. The third is the point at which an unexplained gap turns into a demand. That happens when the difference cannot be tied to a reconciling item with a document behind it, and the amount is significant relative to the turnover. Timing differences, stock transfers, job work movements, returns and write-offs are all legitimate explanations, but each has to be evidenced individually, because an unsupported explanation carries no more weight than no explanation.
Running the Reconciliation Before Anyone Asks
Run it at a frequency that keeps the work manageable, which for most businesses means monthly rather than annually. A month's reconciling items can be identified while the people involved still remember the transactions and the documents are still to hand; a year's cannot, and the annual exercise consistently costs more in aggregate than twelve monthly ones while producing a weaker result. Document each reconciling item as it is identified, with the document reference against it, rather than maintaining a list of differences to be explained later. The categories recur: goods in transit at the period end, stock transfers between your own registrations, sales returns and credit notes, job work movements, free samples and promotional issues, and write-offs. A standing schedule with those headings turns the reconciliation into a routine rather than an investigation. An independent stock count settles the position where the physical figure itself is uncertain, where a reconciliation has not been performed for several periods, or where the difference has grown beyond what the documented items explain. Inventory Audit / Stock Audit work establishes the physical position that everything else is then reconciled against.
