Free template · Excel · Worked example

Work Order Format: Free Excel Template with a Filled Example

A work order format is the one-page instruction a factory issues to make a set quantity of one product by a due date. It lists the work order number, item, quantity and BOM revision. It also lists materials to issue (scrap included), operations in order, start and due dates, and sign-offs. Get the free Excel format below: a blank sheet and a filled example for 50 steel trolleys.

Download the Excel template

What is a work order?

A work order is an internal instruction to make a fixed quantity of one item by a set date. The planning or production head raises it after a sales order or stock plan, before material leaves the store.

Most formats online are contractor forms. A factory uses three types:

TypeGoes toCovers
Production work order (this page)Shop floor and storesOne item, made from its BOM
Contractor or service work orderContractor or maintenance teamRepair, installation or building work
Job-work orderA job workerOne process, sent on a delivery challan

What each field in the work order format means

Header

  • Work order number: unique, such as WO-0118.
  • Linked to: the sales order or stock plan.
  • Item, quantity and BOM revision: what to make, how many good pieces, and which BOM version.
  • Start and due date: when work starts and goods reach the store.
  • Priority and customer: optional.

Materials to issue

  • Item, unit and per unit (BOM qty): each material, and what one piece needs.
  • Scrap %: the cutting or process loss you expect.
  • Planned qty: quantity × BOM qty × (1 + scrap %).
  • Actual issued: what the store gave out.

Operations

  • Op number: 10, 20, 30, in routing order.
  • Operation and work centre: the step, and the machine, line or job-work vendor.
  • Planned and actual hours: expected time and real time.
  • Challan number: optional, for job-work steps.

Completion and sign-off

  • Good, rejected and returned: pieces passed, pieces scrapped with the reason, and unused material.
  • Issued, approved and closed by: names and dates.

How to fill a work order, step by step

  1. Link the sales order or stock plan.
  2. Pick the item and the latest BOM revision.
  3. Enter quantity and due date.
  4. Pull material lines from your bill of materials, adding scrap.
  5. List operations in routing order, marking job-work vendors.
  6. Set planned hours and priority.
  7. Approve it. Stores issue against it on a material transfer note.
  8. Record issues, output, rejects and returns, then close.

Worked example: work order for 50 steel trolleys

Same trolley as our BOM template. Numbers are illustrative.

Table 1 (Example): header

FieldValue
Work orderWO-0118, for SO-0342
ItemST-200 steel trolley, 50 pcs, BOM Rev B
Start / due2 Dec / 12 Dec

Table 2 (Example): materials to issue

MaterialPer trolleyScrapQty to issue
MS angle 25×25×3 mm4.8 m5%252 m
MS sheet 600×900 mm (deck)1 pc2%51 pcs
Castor wheel 100 mm4 pcs0%200 pcs
M8 bolt with nut16 pcs5%840 pcs
Powder coat, grey0.4 kg10%22 kg

Angle: 50 × 4.8 × 1.05 = 252 m. Round part counts up.

Table 3 (Example): operations and output

OpOperationWhereTime
10Cut angleCutting bay4 hrs
20Weld frameWelding line10 hrs
30Powder coatJob worker, on delivery challan3 days
40Fit deck and castorsAssembly bench6 hrs
50Check and packDispatch area2 hrs

Output: 50 trolleys to finished goods by 12 Dec.

Closing the order: planned vs actual

LinePlannedActualNote
Good trolleys50491 rejected: weld crack
MS angle252 m249 m3 m returned
Powder coat22 kg21 kg1 kg returned
Welding hours1011.5Rework on 2 frames

[[IMAGE {"type":"checklist","title":"Before you close a work order","items":["Returns booked back into stock","Rejects logged with a reason","Job-work material back from vendor","Actual hours entered for each step"]}]]

Where TranZact fills it for you

In Excel, someone types every line and chases updates on WhatsApp. That breaks first when the floor gets busy.

In TranZact, work orders sit with your multi-level BOM, process routing, sub-contracting and production costing. See production management.

Material movement is logged through stock in, issue and the bin card, with AI stock alerts. See inventory management.

The MRP engine runs through your orders and BOMs, then tells you what to buy and when. See purchase management.

Accounts stay in Tally, with one-way sync and no double entry. One limit: your own printed work order layout needs custom document formats, a Dominate plan feature.

Book a demo →

TranZact work order and production facts (plans as on /pricing, checked 22 Oct 2026)

FactDetail
CategoryManufacturing AI software, used by 10,000+ manufacturers
PlansGrow ₹8,333 (4 users), Scale+ ₹16,666 (8 users), Dominate ₹30,000 (12 users), per month, billed yearly
Included from GrowMRP + indent, multi-step BOM and production, costing, routing, sub-contracting
Go-liveLive in 2–3 weeks

There is no free plan. Enterprise is custom. See the pricing page.

Work order vs purchase order, sales order and job card

DocumentIssued bySent toAsks for
Work orderPlanning or production headShop floor and storesMake one item by a date
Purchase orderPurchase team memberA supplierSupply material at a price and date
Sales orderSales team memberPlanning and storesDeliver what the customer confirmed
Job cardSupervisorOne operator or machineDo one step, log time and output

A work order asks your own team to make something. A purchase order asks a supplier to sell it to you. A job card covers one step of a work order.

Common work order mistakes

  • No work order number on issues: nobody knows which order used the material.
  • Old BOM revision: the floor builds the old design.
  • No scrap: stores issue twice, and the extra goes unrecorded.
  • Missing job-work steps: material at the vendor drops out of your stock count.
  • Many items or dates on one order: keep one item per order, split by date.
  • No planned hours: you can't see which step ran late.
  • Never closing: returns and rejects stay unrecorded, and stock stops matching.

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

Bring one of your real work orders to a demo. We'll show how it runs in TranZact, from BOM to closing.

Book a demo →

Frequently asked questions

How do I calculate the material needed for a work order?

Multiply the quantity to make by the BOM quantity per unit, then add scrap. For 50 trolleys at 4.8 m of angle each with 5% scrap: 50 × 4.8 × 1.05 = 252 m.

Should job work (sub-contracting) appear on the work order?

Yes. List it as an operation with the vendor's name, and send the material with a delivery challan. That way, stock lying at the vendor is never forgotten.

How many work orders should I raise for one sales order?

Raise one per finished item. Split it into two orders if parts of the quantity are due on different dates.

Is it necessary to use a work order for every job?

For every batch that uses BOM material, yes. Small repair or maintenance jobs can go on a simple job card instead.

Can I keep work orders in Excel and my accounts in Tally?

Yes. Excel works while order volumes are small. In TranZact, operations run in the software and accounts stay in Tally through a one-way sync, with no double entry.

What file format is the work order template in?

Excel (.xlsx). It opens in Google Sheets and prints on one A4 page, or you can save it as a PDF.

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

Book a demo

Born in India. Building for the world.