Multi-Location Inventory: Visibility, Transfers and Branch Accounting

A single-location business has a relatively simple inventory life. The moment you open a second godown, a branch, or a fulfilment hub, inventory becomes a distributed-systems problem — and most accounting habits do not scale into it. Here is what changes and how to handle it.

What gets harder

Three things, all at once:

• Visibility — knowing what is where, in real time, not "as of last Tuesday's stock-take"
• Transfers — moving stock between locations correctly, both physically and in the books
• Allocation — deciding which location fulfils a customer order or production demand, when more than one could

Each of these has both an operational answer and an accounting answer. Most companies get the operational part right and the accounting part wrong, or vice versa. Both have to work.

Visibility: one stock master, multiple locations

The foundation is a stock master where every item exists once, with a balance per location. Not a separate item master per godown.

Bad pattern: "Steel Sheet — Mumbai" and "Steel Sheet — Pune" as separate items. This makes consolidation a manual headache, breaks reporting, and invites duplication.

Good pattern: one "Steel Sheet" item with location-specific balances under it. Total stock = sum across locations; consolidated reports work without joining anything.

The dashboard view a manager needs:

• Item × Location matrix — current stock by item at each location
• In-transit — what is currently between two locations
• Days of inventory per location — overstock and understock at a glance

Transfers: the right way to move stock between locations

The naive way: deduct from location A and add to location B in a single instant. Done.

The reality: stock leaves A on day 1, takes some days in transit, arrives at B on day 4. During days 2–3 it is not at A or at B — it is in transit. If you account for it as "instantly at B", you have a sales window where the system says the stock is available at B but it isn't.

The right pattern is a two-step transfer:

• Step 1 (dispatch from A): stock leaves A, enters an "in-transit" pseudo-location for that route
• Step 2 (receipt at B): stock leaves in-transit, enters B's location

Both steps preserve the total stock; the in-transit step keeps an audit trail of what is moving and lets B's team know what is coming.

The GST angle: branch transfers as supply

Under GST, the transfer of goods between two locations of the same business is treated as a "supply" if the locations have different GSTINs (different states, or same state with multiple registrations). That means:

• A tax invoice (or delivery challan, depending on the case) is needed
• GST is charged on the transfer
• The receiving location claims that GST as Input Tax Credit
• Place of supply rules apply

Within a single state under a single GSTIN, transfers are not a supply — a delivery challan and a stock-movement entry are enough.

For multi-state operations, the practical setup is one GSTIN per state with proper inter-state branch transfer documentation. The cash flow is largely neutral (output GST at one end, ITC at the other) but the paperwork matters.

Allocation: which location fulfils?

When an order can be served from more than one location, the allocation rule should be deliberate, not random. Common rules:

• Nearest location — minimises shipping cost and lead time. Default for B2C operations.
• Highest stock location — balances stock across locations naturally. Useful when you want to clear overstocks.
• Source location only — items always ship from a "home" location. Simplest, but wasteful on freight.
• Specific rule per channel — e.g. all e-commerce orders from the fulfilment hub, all wholesale orders from the main godown.

Whichever you choose, the rule should be encoded in the system, not in someone's head. Manual allocation is where errors creep in.

Branch P&L vs consolidated P&L

Once you have multiple locations, you can produce a P&L at each — useful for performance measurement. Two things to handle:

• Inter-branch transfers at internal transfer prices — these net out in the consolidated P&L but inflate each branch's revenue and costs if not properly eliminated
• Allocated head-office cost — central costs (head office salaries, central marketing) often need allocating to branches to make the branch-level numbers fair

The simpler approach for most growing businesses: keep the consolidated P&L as the truth, use branch-level inventory and sales reports for operational insight, and avoid forcing a branch-level full P&L until the business is large enough to justify it.

Where this falls down without software

A spreadsheet inventory across two locations is feasible (just barely). Three locations is painful. Four is unsustainable. The reasons:

• Reconciling location balances against a consolidated view becomes a manual join
• In-transit stock has no place in a static spreadsheet
• GSTIN-aware transfer documentation needs structured records
• Real-time visibility (vs end-of-day snapshots) is impossible without a system

If you have more than two stocking locations and a single-state business, software is no longer optional.

How Booksmor helps

Booksmor handles multi-location inventory with a single item master, per-location balances, an explicit in-transit state on every transfer, GSTIN-aware inter-state branch transfers with the right documentation, and allocation rules per channel. Consolidated and branch-level views are both one click. Start a 30-day free trial and run distributed inventory without distributed chaos.