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.
| Column | What to write | Why it matters |
|---|---|---|
| Dispatch No | Next number in the series, e.g. DSP/2026-27/0001 | One running number makes gaps easy to spot |
| Date | Date the vehicle leaves | Matches the gate-out date |
| Customer | Name as printed on the invoice or challan | Lets you filter by customer |
| Order No | Your sales order or job-work order number | Links partial loads to one order |
| Invoice/Challan No | Number exactly as printed | Links 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 |
| Qty | Quantity actually loaded, as a plain number | Totals by item and order add up |
| E-way Bill | Number as generated, or "Not required" | Shows the goods moved with a valid bill |
| Transporter/LR | Transporter name and lorry receipt number, or "Own vehicle" | Who to call, and the basis for freight bills |
| Vehicle No | For example MH12AB1234, no spaces | Must match the e-way bill |
| Checked By | Name of the person who checked the load | One person owns each entry |
| Status/Remarks | Start with Open, Delivered or CANCELLED, then any note | Filter open rows every day |
How to fill a dispatch register (step by step)
- Make the entry before the vehicle leaves the gate.
- Take the next number from one running series for the financial year, such as DSP/2026-27/0001. Never reset it mid-year.
- Copy the invoice or challan number exactly as printed.
- Enter the quantity actually loaded, not the order quantity.
- Enter the e-way bill number. If none was needed, write "Not required" and give the reason in Status/Remarks.
- Add the transporter, LR number and vehicle number. Write the vehicle number without spaces or hyphens.
- The person who checked the load writes their name in Checked By.
- Set Status to Open. When the signed POD comes back, change it to Delivered with the date.
- 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 No | Document | Item and qty | Status and note |
|---|---|---|---|
| DSP/2026-27/0412 | Invoice INV/26-27/0951 | Pump shaft, 300 Nos | Delivered. 200 of 500 pending on SO-0388 |
| DSP/2026-27/0413 | Invoice INV/26-27/0952 | Pump shaft, 200 Nos | Delivered. SO-0388 complete |
| DSP/2026-27/0414 | Invoice INV/26-27/0953 | Mounting bracket, 1,000 Nos | Open. POD awaited |
| DSP/2026-27/0415 | Job-work challan DC/26-27/0112 | EN8 steel bar, 850 Kg | Sent for turning. Return due 08-11-2027 |
| DSP/2026-27/0416 | Invoice INV/26-27/0954 | Gasket kit, 40 Sets | Delivered. E-way bill not required, value below limit |
| DSP/2026-27/0417 | Invoice INV/26-27/0955 | Bracket, 0 Nos | CANCELLED. Wrong rate caught at the gate |
| DSP/2026-27/0418 | Invoice INV/26-27/0956 | Bracket, 600 Nos | Open. 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.
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.
| Option | Dispatch details typed | Stock updated | Pending on an order |
|---|---|---|---|
| Paper register | Again, by hand | No | Only by flipping pages |
| Excel register | Again, in the sheet | Not unless linked by hand | With filters, if kept up to date |
| Manufacturing software | Once, on the order | When dispatch is linked to inventory | On 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.