Free template · Production

Job Card Format: Free Excel Template with Worked Example

A production job card records one operation of a work order: item, machine, operator, time, and OK, rejected and rework pieces. Download the blank Excel log and a filled CNC example, with every column explained.

Download the Excel template

What is a job card?

A job card is the shop-floor record for one operation of a work order. It shows which item, how many, on which machine, by whom, and what actually came out. A good job card format has a header: job card no., work order no., item, operation, machine and planned qty. It also has a material issue table, a shift-wise time log, and OK, rejected and rework quantities with sign-offs.

This page covers the factory production job card. A job sheet is often just another name for it. MGNREGA job cards are government employment documents and are not covered here. Nor are workshop job cards, which list a vehicle, technician, labour and parts.

Job card vs work order vs job work

DocumentWhat it coversWho fills it
Work orderThe instruction to make an item in a set quantity, across all its operationsPlanner or production head
Job cardOne operation on one machine: material, time, output and rejectionOperator, QC and supervisor
Job workMaterial sent to an outside party for processing, tracked with a delivery challan and ITC-04Stores, purchase and accounts

One work order usually has several job cards. See our work order format and how to track job work and file ITC-04.

What each field in the job card format means

Header fields

  • Job card no. and date issued: One running number per operation.
  • Work order no. and customer / SO ref (optional): Links all job cards of one order.
  • Item code, description and drawing / rev no.: As in your item master and BOM. A wrong revision scraps the lot.
  • Operation no. and name, machine, planned qty and unit: For example, "20 – CNC turning" on CNC-03, from the routing.
  • Operator, supervisor, planned start and finish, std time per piece (min): Efficiency is measured against the std time.

Material issue table

  • Item code, description and unit: As listed in the bill of materials.
  • Qty issued and qty consumed: What stores handed over, and what went into processing.
  • Qty returned to store and scrap qty: Skip returns and you get a stock discrepancy.

Time and output log (one row per shift)

  • Date, shift and operator: One row per shift.
  • Start, end, break and run time (min): Run time is end minus start, minus break, minus downtime.
  • Downtime (min) and downtime reason: Unplanned stops, with a real reason like tool change or power cut. Never just "misc".
  • OK, rejected and rework qty: Good pieces, unusable pieces, and pieces that can be corrected. QC writes the last two.
  • Remarks: Anything the next shift needs to know.

Summary and sign-off

Total processed, yield %, rejection %, run time and efficiency %, worked out as in the steps below. "Moved to" names the next operation or store; pieces waiting there are work in process. Operator, supervisor, QC and stores sign it off.

[[IMAGE {"type":"steps","title":"Work out the job card summary","items":["Processed = OK + rejected + rework","Yield % = OK ÷ processed","Rejection % = rejected ÷ processed","Earned minutes = OK × std time","Efficiency % = earned ÷ run minutes"]}]]

How to create and fill a job card, step by step

  1. The planner issues it: one card per operation, from the work order, BOM and routing.
  2. Stores writes the qty issued before work starts.
  3. The operator logs each shift the same day.
  4. QC records and signs the rejected and rework quantities.
  5. The supervisor closes it once issued = OK + rejected + rework + returned.
  6. Balance material goes back to store with a material transfer note.

Where TranZact fills it for you

Paper job cards work for one machine. Across many work orders, the header gets rewritten by hand and job cost comes weeks later.

TranZact is manufacturing AI software used by 10,000+ manufacturers. It runs work orders, process routing and production costing on one system, while your accounts stay in Tally. See the production management features.

Which TranZact feature holds each job card field

Job card fieldTranZact featurePlan
Item, quantity, work order no.Work ordersGrow and above
Materials to issueMulti-level BOM and inventory issueGrow and above
Operation sequenceProcess routingGrow and above
Job costProduction costingGrow and above
MachineMachine planningDominate
Operation done outsideSub-contractingGrow and above

This list does not cover the shift-wise time log, downtime reasons or sign-offs. Keep those in the Excel log.

TranZact production facts (as of 17 Nov 2026)

  • Grow: ₹8,333/month billed yearly, 4 users. Includes routing, production costing and sub-contracting.
  • Scale+: ₹16,666/month billed yearly, 8 users.
  • Dominate: ₹30,000/month billed yearly, 12 users. Adds machine planning, quality control and custom document formats.
  • Live in 2–3 weeks.
  • Accounts stay in Tally, with one-way sync and no double entry.

Full plan details are on the pricing page.

Book a demo →

Worked example: CNC turning of a steel flange

All numbers are illustrative. The Excel example uses the same numbers.

Table 1 (Example): job card header

FieldValue
Job card / work orderJC-0412 / WO-0187
ItemFL-080-EN8, steel flange 80 mm, Rev C
Planned qty480 Nos
Operation20 – CNC turning (face, OD, bore)
MachineCNC-03
Std time per piece2.5 min

Table 2 (Example): material issued and consumed

FieldForged blank BL-080-EN8
UnitNos
Qty issued490
Qty consumed480
Qty returned to store10
Scrap qty9 (rejected pieces)

Table 3 (Example): shift-wise time and output log

Field10-Nov, Shift A10-Nov, Shift B11-Nov, Shift A
OperatorOperator 1Operator 2Operator 1
Start – end07:00 – 15:0015:00 – 23:0007:00 – 15:00
Break (min)303030
Downtime (min)402565
Downtime reasonInsert breakage, tool changePower cutChuck jaw repair
Run time (min)410425385
OK qty158162146
Rejected qty342
Rework qty212

Table 4 (Example): summary, yield and efficiency

MeasureWorkingResult
Total processed466 + 9 + 5480
Yield %466 ÷ 480 × 10097.1%
Rejection %9 ÷ 480 × 1001.9%
Run time410 + 425 + 3851,220 min
Efficiency %466 × 2.5 ÷ 1,220 × 10095.5%
Material check466 + 9 + 5 + 10490 = qty issued

The card balances, so the supervisor closes it. It is 14 OK pieces short of plan. The 65-minute chuck jaw repair is the first downtime to fix.

Common job card mistakes

  1. One card for the whole work order. You can't see which operation lost pieces.
  2. Filling the log at week's end. Counts from memory are guesses.
  3. Vague downtime reasons. "Misc" shows nothing to fix.
  4. Mixing rework with rejected. Rejection % looks worse than it is, and pieces that could be saved get scrapped.
  5. No entry for returned material. The system shows it consumed.
  6. Missing drawing revision. The lot gets made to an old drawing.
  7. Closing without the material check. Missing pieces go unnoticed.
  8. Using a job card for job work. That needs a delivery challan and ITC-04.

Job card PDF and Word questions

How to download a job card PDF?

Download the Excel file, then print it or save it as a PDF.

Is there a job card template in Word?

The format is in Excel because the log needs calculations. Copy it into Word to print.

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

Bring one of your job cards to the call. We'll show where your work order, BOM, routing and costing would sit in TranZact.

Book a demo →

Frequently asked questions

Who should fill the job card, the operator or the supervisor?

The operator writes the time and output for each shift. QC writes the rejected and rework quantities. The supervisor checks the totals and closes the card.

Should I make one job card per operation or one per work order?

One per operation. That way you can see which operation, machine or shift is losing pieces or time.

How do I calculate yield and efficiency from a job card?

Yield % = OK qty ÷ processed qty × 100. Efficiency % = OK qty × standard minutes per piece ÷ actual run minutes × 100. In the example on this page, that gives 97.1% yield and 95.5% efficiency.

Can I use this job card for material sent to a job worker?

No. Material sent to an outside job worker is tracked with a delivery challan and ITC-04. See our job work tracking guide.

Is the Excel job card format free?

Yes. It's a free .xlsx with a blank shift-wise job card log and a filled CNC turning example.

Can I keep job cards in Excel and my accounts in Tally?

Yes, many factories start that way. When orders grow, TranZact runs work orders, routing and production costing. Your accounts stay in Tally, with one-way sync and no double entry.

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

Book a demo

Born in India. Building for the world.