Free Excel template

Stock Transfer Format: Free Excel Template & Example

A free stock transfer format in Excel for moving goods between your own store, godown, plant or branch. You get a blank format and two filled examples, with every column, GST rule and e-way bill trigger explained.

Download the Excel template

A stock transfer format is the document you fill when goods move between your own locations, such as a factory store, godown or branch. It records the transfer number and date, and the sending and receiving locations with their GSTINs. It also lists each item's HSN code, quantity and value, and the e-way bill number. If both locations share one GSTIN, the goods travel on a delivery challan. If they have different GSTINs, GST treats the move as a supply and you issue a tax invoice.

Download the free Excel below: a blank format plus a branch and a godown example.

Transferring company shares? That is Form SH-4 under company law. This page is for moving goods.

What is a stock transfer format?

It records goods moving between your own locations: store to godown, plant to plant, or plant to an out-of-state depot. Moving material inside one plant? Use the material transfer note format.

What is a stock transfer challan? It is the delivery challan that travels with the goods when both locations share one GSTIN. Many teams call it a stock transfer note.

What is a delivery challan? It is the document for moving goods when the move is not a supply, like a godown transfer or job work. Rule 55 of the CGST Rules lists its contents.

What is a DC format? DC means delivery challan. Its layout: number, date, sender, receiver, items, HSN, quantity, value and signature. See our delivery challan format.

Same GSTIN or different GSTIN: which document travels with the goods

SituationDocumentGST charged?E-way bill
Two godowns, one GSTINDelivery challanNoIf over ₹50,000
Branch with own GSTIN, other stateTax invoiceYes, IGSTIf over ₹50,000
Separate registration, same stateTax invoiceYes, CGST + SGSTIf over ₹50,000

More in delivery challan vs invoice and our delivery challan guide.

What each column in the stock transfer format means

The Excel has a header block for the move and item lines for what moved. This is also the format of a material delivery challan in Excel.

Header block

ColumnWhat to writeWhy it matters
Transfer no.Next in series, e.g. ST/26-27/0142Rule 55: consecutive, up to 16 characters
DateDay the goods leaveFixes the stock and GST period
Transfer typeGodown (same GSTIN) or branch (different GSTIN)Challan or tax invoice
From / to location and GSTINAddress, store and GSTIN at each endAnother state means IGST
Transport detailsTransporter, vehicle, LR no.Traces a shortage
E-way bill no.12-digit number, if generatedProves the move was declared
Prepared / received byNames and signaturesWho answers at each end

Item lines

ColumnWhat to writeWhy it matters
Item code and descriptionAs in your item masterOne item, one name
HSN codeThe item's HSNChallan and invoice need it
Batch no.Batch or lot, if trackedWhich batch went where
UnitNos, kg or m, per item masterStops kg sent, nos received
Qty sentQuantity dispatchedReduces the sending store's stock
Rate (₹, at cost)Cost per unit, or as your CA advisesValues the move
Taxable value (₹)Qty × rate (formula)Base for GST. The ₹50,000 e-way bill check uses the value including GST.
GST rate and amountRate; amount by formula; nil for same GSTINOnly when GSTINs differ
Qty receivedFilled by the receiving storeAdds stock there
Difference and remarksSent minus received (formula), with reasonCatches shortage, damage or miscount

How to fill a stock transfer format, step by step

  1. Take the next serial number. Never reuse or skip one.
  2. Pick the transfer type. Same GSTIN: delivery challan. Different GSTIN: tax invoice.
  3. Fill both locations. Address, GSTIN and store.
  4. Add items from your item master. Code, HSN, unit and batch, as in your bill of materials.
  5. Value each line at cost. Different GSTINs: IGST across states, CGST + SGST within one.
  6. Check the e-way bill. Over ₹50,000 including GST? Generate one and note its number.
  7. Record the receipt. The receiving store enters what arrived and any difference.

Filling this by hand at both ends, for every transfer, is where registers slip. TranZact logs every movement in, out and between stores the moment it happens.

Book a demo →

Worked example: fasteners and brackets from a Pune plant to a Bengaluru depot

All numbers, codes and GSTINs are illustrative. The Bengaluru depot has its own Karnataka GSTIN, so this is an inter-state supply with IGST.

Table 1 (Example): transfer note header

FieldExample
Transfer no.ST/26-27/0142
Date18-11-2026
Transfer typeBranch transfer, different GSTIN (tax invoice)
FromPune plant, Maharashtra, GSTIN 27ABCDE1234F1Z5
ToBengaluru depot, Karnataka, GSTIN 29ABCDE1234F1Z3
TransportRoad, vehicle MH12AB3456, LR 55821
E-way bill no.331012345678

Table 2 (Example): items, value and IGST

Item (HSN)Qty × rateTaxable value (₹)IGST at 18% (₹)
Hex bolt M10 x 50 (7318)5,000 nos × ₹6.5032,5005,850
Hex nut M10 (7318)5,000 nos × ₹1.809,0001,620
MS mounting bracket 3 mm (7326)400 nos × ₹48.0019,2003,456
Total60,70010,926

The invoice total is ₹71,626, over ₹50,000, so the e-way bill is generated before dispatch. Check the GST rate for your HSN.

Table 3 (Example): what arrived

ItemSentReceivedDifference
Hex bolt M10 x 505,0005,0000
Hex nut M105,0004,900100 short
MS mounting bracket 3 mm4004000

One box of 100 nuts did not arrive. The depot noted it on the LR. The ₹180 shortage stays open until the transporter settles it.

The Excel's second example is a godown move on one GSTIN, worth ₹32,900. It goes on a delivery challan with no GST and no e-way bill.

[[IMAGE {"type":"compare","title":"The two worked examples side by side","columns":["Godown move, one GSTIN","Branch move, two GSTINs"],"rows":[["Document","Delivery challan","Tax invoice"],["GST","None","IGST at 18%"],["Value","₹32,900","₹71,626 with IGST"],["E-way bill","Not needed","Needed"]]}]]

GST and e-way bill rules for stock transfers

Is GST applicable on delivery challan? Not when the move is not a supply. A challan between two godowns on one GSTIN carries no GST.

  • Different GSTINs are distinct persons. Per CBIC's GST FAQs, a transfer between them is a supply even without payment. IGST applies across states; CGST + SGST within one.
  • Delivery challan (Rule 55). Serial number up to 16 characters, date, both parties, HSN, description, quantity, value and signature. Three copies: receiver, transporter and you.
  • E-way bill (Rule 138). Needed when the consignment value is over ₹50,000, even if no sale is involved. Inter-state goods to a job worker need one at any value. Some states set a different intra-state limit. See our e-way bill format.
  • Branch transfer value (Rule 28). Open market value applies. If the receiving branch can take full input tax credit, the invoice value counts as that value.

Rules change; confirm your case with your CA.

Common stock transfer mistakes

  • Reused or skipped numbers. Rule 55 needs a consecutive serial.
  • A challan for a different-GSTIN branch. That move needs a tax invoice with GST.
  • Value blank or zero. GST and the e-way bill both need it.
  • Over ₹50,000 without an e-way bill.
  • Receipt not recorded. Stock seems to vanish in transit.
  • Posted out of one store, never into the other.
  • Missing HSN or batch. The lot can't be traced.
  • Unit mismatch. Kg sent, nos received.

Where TranZact fills it for you

A transfer register is only right if both ends are updated every time. On a busy day, one side gets skipped. In TranZact, Multi-Store and warehouse-wise tracking log every movement in, out and between stores as it happens. See TranZact inventory management. The GST document still follows the rules above.

TranZact inventory facts (as of 19 Nov 2026)

  • Manufacturing AI software used by 10,000+ manufacturers.
  • Inventory features: Stock in, Bin Card, Issue, Batch Tracking (batch-wise stock tracking from Scale+), Multi-Store and warehouse-wise tracking.
  • Generates the e-way bill from the GST invoice, with e-invoice (IRN) in the same flow, on all plans. More in e-way bill software for manufacturers.
  • Stock tracking and inventory ageing & valuation are in Grow, ₹8,333/month billed yearly for 4 users. Store-level permissions are in Dominate. No Free plan; see pricing.
  • Accounting stays in Tally, with one-way sync and no double entry. Busy, Zoho Books and Excel / Google Sheets also connect.
  • Live in 2–3 weeks.

Don't be the bottleneck. Become the AI-Run Factory.

Bring a real transfer to a demo and watch it logged at both ends.

Book a demo →

Frequently asked questions

Do I need a stock transfer note between two godowns in the same city?

Yes. If both godowns are under one GSTIN, the goods move on a delivery challan. You also need an e-way bill if the value is over ₹50,000, unless an exemption applies.

What value should I put on a branch transfer?

Use the value GST valuation rules give. If the receiving branch can take full input tax credit, the invoice value is treated as the open market value. Confirm with your CA.

Can the receiving branch claim the IGST paid on a stock transfer?

Usually yes, as input tax credit. It must hold the tax invoice, have received the goods and meet the normal ITC conditions.

Is a stock transfer format the same as a material transfer note?

They overlap. A material transfer note records material moving inside the business, for example between sections of a plant. A stock transfer format records goods moving between locations, with GST and e-way bill details.

Is the Excel template free?

Yes. It has a blank format and two filled examples, a branch transfer and a godown transfer. Totals and tax are worked out by formula.

Can software keep stock transfers for me?

Yes. In TranZact, Multi-Store and warehouse-wise tracking log every movement in, out and between stores as it happens. So each store's stock stays right without a separate register.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.