Multi-Warehouse / Godown Stock Sheet in Excel

Last updated: 27 June 2026

Tracking stock across multiple godowns or warehouses in Excel requires adding one "Location" column to your transactions sheet — then SUMIFS gives you stock by item by godown, and a pivot table gives you the cross-tab view in seconds. This guide shows you the complete setup for two to ten locations, including inter-godown stock transfers and a consolidated stock summary across all locations.

Key takeaways

Add a Location column to your existing transactions sheet — that single change enables multi-godown tracking without redesigning anything else.
SUMIFS with both Item Code and Location filters gives you the balance for any item at any godown.
A pivot table (Items × Locations) gives a real-time cross-tab view without any extra formulas.
Inter-godown transfers need two rows: an OUT from the source location and an IN to the destination, linked by a Transfer No.
Each GSTIN-registered location (additional place of business) must be added on the GST portal. Stock transferred between locations in different states requires a proper tax invoice or delivery challan — not just an internal transfer.
Keep location codes short and consistent (e.g. MUM, DEL, BLR) — long location names in every SUMIFS formula become hard to maintain.

Fact box. Under GST, if you move goods from your registered place of business to a godown or warehouse in a different state — even if it is your own godown — it is treated as a supply and requires a tax invoice. Movement within the same state to your own godown (same GSTIN, different additional place of business) can be done with a delivery challan. Confirm the exact treatment with your CA before setting up inter-state godown transfers.

How do I modify my stock register for multiple locations?

Step 1 — Add a Location column to your Transactions sheet

If you already have a transactions sheet (as described in the Stock Register guide), simply add a Location column. Place it after the Date column:

Date	Location	Document No	Item Code	Type	Qty	Rate	Value

Use short, consistent location codes. Set up a Data Validation dropdown:

Select the Location column (excluding header).
Data → Data Validation → Allow: List → Source: type your locations comma-separated, e.g. MUM,DEL,BLR,HYD.

This prevents typos that break your SUMIFS.

Step 2 — Build godown-wise balances on the Stock Summary sheet

Your stock summary sheet now needs two dimensions: Item and Location. The simplest approach is to add one column per location:

Mumbai Godown balance (for Item Code in column A):

=SUMIFS(Trans[Qty], Trans[Item Code], [@[Item Code]], Trans[Location], "MUM", Trans[Type], "IN")
-SUMIFS(Trans[Qty], Trans[Item Code], [@[Item Code]], Trans[Location], "MUM", Trans[Type], "OUT")

Repeat for each location. Add a Total column:

=[@[Mumbai]]+[@[Delhi]]+[@[Bangalore]]

Step 3 — Alternative: use a pivot table for the cross-tab view

A pivot table gives a real-time Items × Locations matrix without individual SUMIFS columns:

Click anywhere in your Transactions table.
Insert → PivotTable → New Worksheet.
Drag Item Code to Rows.
Drag Location to Columns.
Drag Qty to Values.
Right-click the Qty field → Value Field Settings → choose Sum.

You now have a cross-tab. However, to get net balance (IN minus OUT) rather than just total quantity, you need separate pivot tables for IN and OUT and subtract them, or use calculated fields — which is less clean. For most SMBs, the SUMIFS approach for stock balances and the pivot table for movement analysis work best together.

How do I record inter-godown stock transfers?

A transfer from Mumbai to Delhi is two rows in the Transactions sheet:

Date	Location	Transfer No	Item Code	Type	Qty
15-Jun-26	MUM	TRF-001	ITEM01	OUT	50
15-Jun-26	DEL	TRF-001	ITEM01	IN	50

Use "TRF" as a Type prefix or create separate Type values "TRANSFER-OUT" and "TRANSFER-IN" to distinguish transfers from purchases and sales:

Net IN per location = SUMIFS(IN) + SUMIFS(TRANSFER-IN)
Net OUT per location = SUMIFS(OUT) + SUMIFS(TRANSFER-OUT)

The Transfer No links the two rows — useful for audit and reconciliation.

Fact box. CGST Rule 55 provides for movement of goods without a tax invoice in specific cases — primarily job work, exhibitions, and movement to own branches on delivery challan. For inter-state movement to your own godown, CBIC clarifications require a tax invoice (or delivery challan for specific cases). Check the current position with your CA, especially after the IMS changes from October 2025 which affect how such movements appear in your counterparty's GSTR-2B.

How do I build a godown-wise stock report?

Option 1 — Pivot table report (fastest)

A pivot table on the Transactions sheet, with:

Rows: Item Name or Item Code
Columns: Location
Values: Sum of Qty (filtered to Type = IN minus OUT via two separate pivot tables and a calculated sheet)

Option 2 — Dashboard summary sheet

Build a GodownSummary sheet with Item × Location as a structured table:

Item Code	Item Name	Mumbai	Delhi	Bangalore	Total Stock	Reorder Level	Status

Each location column uses the SUMIFS formula from Step 2. The Total Stock and Status columns use the aggregated values.

Apply conditional formatting to the Status column (REORDER NOW = orange, OUT OF STOCK = red).

Option 3 — FILTER formula for a location-specific view (Excel 365/2019+)

To show stock at a specific location only — controlled by a dropdown in cell B1 ("Select Godown"):

=FILTER(
  GodownSummary[Item Code]:GodownSummary[Status],
  GodownSummary[Location]=B1,
  "No items at this location"
)

This creates a dynamic report that changes when you select a different godown from the dropdown.

How do I handle GST for multi-location inventory?

GST compliance for multi-location businesses has several layers:

Scenario	GST requirement
Multiple locations, same state, same GSTIN	Add each location as "Additional Place of Business" on GST portal. Intra-state movement to own godown: delivery challan is sufficient
Multiple locations, same state, different GSTINs	Each GSTIN is a separate taxpayer; stock movement = supply; tax invoice required
Godown in a different state	A godown in another state that makes taxable outward supplies needs its own GSTIN in that state — inter-state supply triggers mandatory registration regardless of turnover, so the ₹40 lakh threshold does not apply. Inter-state movement to own branch: tax invoice (or delivery challan per CBIC clarification) required; IGST generally applies, though the exact treatment of branch transfers can vary — confirm with your CA
Job work or loan licence	Special treatment under CGST Rule 55; ITC of sender is not reversed; goods tracked on FORM ITC-04. ITC-04 filing frequency and applicability have changed in recent years — confirm the current requirement for your turnover with your CA

Record the GSTIN of the receiving location on the transaction row for inter-GSTIN transfers — this is needed to trace the movement in GSTR-1.

Free multi-godown stock sheet template

The free Excel template includes:

Transactions sheet with Location column and Data Validation dropdown.
Stock Summary sheet with SUMIFS for up to five locations.
Transfer rows structure for inter-godown movements.
Pivot table on a separate sheet for the cross-tab view.
Dashboard with godown-wise stock counts and reorder alerts.

Free to download, no sign-up.

Download the Multi-Godown Stock Excel Template »

How Ankeshan helps: Ankeshan tracks stock across all your godowns inside a single Excel workbook — each transaction is tagged to a location, and the dashboard shows a live godown-wise balance with reorder alerts, without any manual pivot table refresh. It's launching soon; join the waitlist.

Frequently asked questions

Do I need a separate Excel file for each godown? No — and you should not. A single file with a Location column is far easier to manage. Separate files require manual consolidation to get a total stock view and are prone to version conflicts. Use one file with location-tagged transactions.

How do I give each godown manager access only to their location's data? The simplest approach: share the master file in read-only mode (they can view but not edit). If they need to enter their own transactions, create a simple data-entry form that submits to the master file via email or a shared folder, and you consolidate. Excel is not designed for concurrent multi-user editing — use OneDrive co-authoring cautiously for this.

What if one godown uses a different unit of measure? Standardise units before consolidation. If Mumbai measures in kg and Delhi in pcs, you cannot SUMIFS across them meaningfully. Either convert to a common unit in the data or track them on separate summary rows.

Is an e-way bill required for inter-godown transfers? An e-way bill is required for movement of goods exceeding ₹50,000 in value, including inter-godown transfers. For intra-state movement, the threshold varies by state notification (₹50,000 in most states; some states have higher limits). Check the threshold for the specific states involved.

How do I reconcile godown-wise stock with the physical count? At each physical count, create a "PHYSICAL COUNT" transaction type row showing the counted quantity. Compare it against the Excel balance. Investigate discrepancies before writing off — they often reveal unrecorded transfers or entry errors.

Sources

CGST Rules 2017, Rule 55 — Transportation of goods without issue of invoice.
CGST Act 2017 — registration, additional place of business (cbic.gov.in).
E-way bill rules — threshold by state (nic.in/ewb).
CBIC GST rate notifications effective 22 September 2025 (56th GST Council).

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.