Free Excel template

Dispatch Register Format: Free Excel Template & Example

A dispatch register is a factory's daily log of every consignment that leaves the gate. Each row records the date, customer, invoice or challan number, item and quantity, e-way bill number, transporter, vehicle number and proof of delivery. Download the free Excel format below: a blank sheet and a filled example for a small factory.

Download the Excel template

One person at the dispatch or stores desk keeps this register. Make each entry before the vehicle leaves the gate, not at the end of the day.

What is a dispatch register?

A dispatch register is your log of outgoing goods. It has one row for each item line in a consignment. Over a month, it shows what left, for whom, on which document and in which vehicle.

Incoming goods go in a separate inward log. For that side, see our GRN format.

Dispatch register vs delivery challan vs invoice

The tax invoice or delivery challan travels with the goods. The register stays with you and lists every one of them in one place. Our delivery challan guide explains when to use a challan instead of an invoice.

Is a dispatch register mandatory under GST?

There is no government-set format for a dispatch register. But GST rules require you to keep records of the goods you supply. A register ties each invoice, challan and e-way bill together, so they are easy to show. Ask your CA what your business must keep.

Goods vs letter dispatch register

Offices keep a letter dispatch register for outgoing post and courier. This page is for goods leaving a factory. Its columns cover documents, quantities, e-way bills and vehicles.

Dispatch register columns explained

The Excel has 12 columns. Fill them left to right as the vehicle is loaded.

ColumnWhat to writeWhy it matters
Dispatch NoNext number in the series, e.g. DSP/2026-27/0001One running number makes gaps easy to spot
DateDate the vehicle leavesMatches the gate-out date
CustomerName as printed on the invoice or challanLets you filter by customer
Order NoYour sales order or job-work order numberLinks partial loads to one order
Invoice/Challan NoNumber exactly as printedLinks the row to the paper that travelled
Item (Unit)Item with size and unit, e.g. Pump shaft 25 mm (Nos)Stops 500 kg reading as 500 pieces
QtyQuantity actually loaded, as a plain numberTotals by item and order add up
E-way BillNumber as generated, or "Not required"Shows the goods moved with a valid bill
Transporter/LRTransporter name and lorry receipt number, or "Own vehicle"Who to call, and the basis for freight bills
Vehicle NoFor example MH12AB1234, no spacesMust match the e-way bill
Checked ByName of the person who checked the loadOne person owns each entry
Status/RemarksStart with Open, Delivered or CANCELLED, then any noteFilter open rows every day

How to fill a dispatch register (step by step)

  1. Make the entry before the vehicle leaves the gate.
  2. Take the next number from one running series for the financial year, such as DSP/2026-27/0001. Never reset it mid-year.
  3. Copy the invoice or challan number exactly as printed.
  4. Enter the quantity actually loaded, not the order quantity.
  5. Enter the e-way bill number. If none was needed, write "Not required" and give the reason in Status/Remarks.
  6. Add the transporter, LR number and vehicle number. Write the vehicle number without spaces or hyphens.
  7. The person who checked the load writes their name in Checked By.
  8. Set Status to Open. When the signed POD comes back, change it to Delivered with the date.
  9. Review open rows every day. Match freight bills against LR numbers once a month.

If one vehicle carries three items, make three rows. Repeat the same dispatch number on each row.

[[IMAGE {"type":"checklist","title":"Set up the sheet before the first entry","items":["E-way Bill column set to Text","One master file, one person keeps it","One number series per financial year","Vehicle numbers typed without spaces","Status starts Open, Delivered or CANCELLED"]}]]

Dispatch register example (filled)

These rows come from the filled example in the download. The numbers are illustrative, for a small engineering parts maker. The Excel shows all 12 columns.

Dispatch NoDocumentItem and qtyStatus and note
DSP/2026-27/0412Invoice INV/26-27/0951Pump shaft, 300 NosDelivered. 200 of 500 pending on SO-0388
DSP/2026-27/0413Invoice INV/26-27/0952Pump shaft, 200 NosDelivered. SO-0388 complete
DSP/2026-27/0414Invoice INV/26-27/0953Mounting bracket, 1,000 NosOpen. POD awaited
DSP/2026-27/0415Job-work challan DC/26-27/0112EN8 steel bar, 850 KgSent for turning. Return due 08-11-2027
DSP/2026-27/0416Invoice INV/26-27/0954Gasket kit, 40 SetsDelivered. E-way bill not required, value below limit
DSP/2026-27/0417Invoice INV/26-27/0955Bracket, 0 NosCANCELLED. Wrong rate caught at the gate
DSP/2026-27/0418Invoice INV/26-27/0956Bracket, 600 NosOpen. Replaces 0417

Partial dispatch (rows 1–2). One sales order went out in two loads. The remark on row 1 shows what is still pending. After row 2, anyone can see the order is complete.

Job-work challan (row 4). Raw material went to a job worker on a challan, not an invoice. The remark carries the return date: one year for inputs, three for capital goods. See our ITC-04 job work guide.

Cancelled and re-issued (rows 6–7). The wrong row stays in the register, marked CANCELLED. The new entry takes the next number and refers back to it.

In TranZact, dispatch is a step in the sales flow. Each dispatch sits with its order and invoice in one system.

Book a demo →

Common dispatch register mistakes

  • Rows entered days after the vehicle left.
  • Blank invoice, challan or e-way bill numbers.
  • Order quantity typed instead of the quantity loaded.
  • Cancelled rows deleted instead of marked CANCELLED.
  • Gaps or duplicate numbers because two people keep their own copies.
  • Rows marked Delivered with no POD in hand.
  • E-way bill column left in General format, so numbers show as 3.91E+11.
  • Vehicle numbers typed with spaces, so they don't match the e-way bill.
  • Several copies of the sheet, with nobody sure which is the master.

E-way bill numbers may become 14 digits: fix your sheet now

GSTN Advisory 687, dated 4 Nov 2026, proposes moving e-way bill numbers from 12 to 14 digits from 1 Jan 2027. Set the E-way Bill column to Text format today. Widen any printed boxes that hold the number. Our 14-digit e-way bill guide covers what else to check.

When a dispatch register in Excel stops being enough

A sheet works well for a few dispatches a day. These are the signs it has stopped keeping up:

  • The same dispatch details are typed three times: invoice, e-way bill portal and register.
  • The sheet does not reduce your stock, so stock goes out of step with the floor.
  • Nobody can see what is pending on a sales order without a phone call.
  • Two people keep two copies, and the numbers don't agree.
OptionDispatch details typedStock updatedPending on an order
Paper registerAgain, by handNoOnly by flipping pages
Excel registerAgain, in the sheetNot unless linked by handWith filters, if kept up to date
Manufacturing softwareOnce, on the orderWhen dispatch is linked to inventoryOn the order itself

If you also plan production in sheets, our free bill of materials format pairs with this register.

Where TranZact fills the dispatch register for you

In TranZact, dispatch is a step in the sales flow. That flow runs enquiry, quotation, order timeline, dispatch, e-invoicing and payment. So each dispatch sits with its order and invoice in one system.

TranZact generates the e-way bill from the GST invoice, with the e-invoice (IRN) in the same flow. This is on all plans. Read more on our e-way bill software page.

Accounts stay in Tally, Busy or Zoho Books. Operations run in TranZact, with one-way sync and no double entry. TranZact also integrates with Excel and Google Sheets.

The Grow plan includes stock tracking and delivery and payment reminders. See what each plan includes on our pricing page, and the full flow on the sales management page. TranZact is live in 2–3 weeks and trusted by 10,000+ manufacturers.

Ask in the demo how your team would record proof of delivery from your transporters.

Keep using the free register while a sheet keeps up. When it stops, see your own dispatches run inside the sales flow.

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

Book a demo →

Frequently asked questions

Can I use this dispatch register for delivery challans as well as invoices?

Yes. Enter the challan number in Invoice/Challan No and write 'Delivery challan' in Status/Remarks. For job-work challans, also note the return deadline: one year for inputs, three for capital goods.

Should I make one row per item or one row per consignment?

One row per item line when a vehicle carries several items, so quantities add up by item. Repeat the same dispatch number on each line of that consignment.

Who should keep the dispatch register?

One person at the dispatch or stores desk, working in one master file. A second person checks each entry before the vehicle leaves and signs in Checked By.

How should dispatch numbers be serialised?

Use one running series per financial year, such as DSP/2026-27/0001. Never reset it mid-year, and never reuse a cancelled number.

How long should I keep dispatch records?

At least as long as the invoices and challans they refer to. Ask your CA for the period that applies to your business.

Can I print this format as a paper register?

Yes. Print the blank sheet landscape on A3, or hide columns you don't use. Keep the number series continuous and strike out cancelled rows instead of tearing pages.

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

Book a demo

Born in India. Building for the world.