Is this job card register format free?

Yes. The download starts at once: no form, no email and no sign-up. Use it and change it for your own business.

Does the file have macros?

No. It is a plain .xlsx file with dropdown lists, a few formulas and colour rules. There is nothing to install and nothing to switch on.

Why do the example rows show dates around today?

The five example rows carry dates that move with today, so a file opened next month still shows how a late row looks. Type over the examples or delete them before you start.

Which program do I need to open it?

It was made for Microsoft Excel on a computer and checked there. Other spreadsheet programs open .xlsx files too, but we have not checked the dropdown lists and the colours in each of them.

Can I change the columns?

Yes. Rename a column, add your own, or change the choices of a dropdown list (Data, then Data Validation). The "How to use" sheet says what each column is for.

Free Excel format

Job card format in Excel

One row per job card: party, item, quantity, promised date, stage and pieces done. A job past its date turns red, a job on hold or due in two days turns amber.

Download the Excel file.xlsx · 49 KB · 14 columns · no form, no email

What the file looks like

The heading row and the five example rows, as they open in Excel. Under them the file has empty rows that are ready: the lists, the formulas and the colours are already set.

Sheet: Job cards14 columns

	Job card no.	Date issued	Party	Item and drawing	Quantity	Promised date	Stage	Pieces done	Pending	Days left	Hold reason	Next action and who	Supervisor	Remarks
2	JC 431	11 Oct 2026	Lakshya Auto Parts	Bracket L-40, drawing B-12 rev 2	2,400	20 Oct 2026	Machining	1,500	fills itself	fills itself		Ramesh: second shift on Press 2 tomorrow	Ramesh
3	JC 428	8 Oct 2026	Trimurti Pumps	Shaft 22 mm, drawing S-22 rev 1	300	16 Oct 2026	QC	300	fills itself	fills itself		Neha: QC report by 11 am, dispatch the same day	Salim	Customer called twice
4	JC 433	13 Oct 2026	Sunrise Furniture Works	Chair frame CF-7	120	22 Oct 2026	On hold	40	fills itself	fills itself	Material short	Pooja: 25 mm pipe to reach tomorrow	Arif
5	JC 425	5 Oct 2026	Kaveri Engineering	Flange 4 inch, drawing F-4 rev 3	800	15 Oct 2026	Dispatched	800	fills itself	fills itself			Vinod	Shree Transport, LR 55821
6	JC 435	16 Oct 2026	Lakshya Auto Parts	Clamp C-12, drawing C-12 rev 1	1,500	19 Oct 2026	Material issued	0	fills itself	fills itself		Ramesh: start on Press 1 after JC 431	Ramesh

Example rows with invented names. On a phone, slide the sheet sideways to see every column.

Red row: The promised date has passed and the job has not left. Tell sales today.
Amber row: The job is on hold, or it is due within two days. Read the next action.
Green row: The job has left the factory.

The columns, and what to write in each

Job card no.
One number per job, the same number as on the paper card on the floor.
Date issued
The day the job went to the floor.
Party
The customer, spelt the same way every time.
Item and drawing
Item name, drawing number and revision.
Quantity
Pieces ordered on this job card.
Promised date
The date given to the customer for dispatch.
Stage
Where the job is now. Pick from the list. Change the list to your own stages if you need to (Data, Data Validation).
Material issuedCuttingMachiningFabricationAssemblyQCPackingDispatchedOn hold
Pieces done
Pieces finished at the current stage.
Pending
Fills itself: quantity minus pieces done at this stage.
Days left
Fills itself: days to the promised date. Below zero means the job is late.
Hold reason
Only for a job on hold. Pick from the list, so that reasons can be counted.
Material shortMachine breakdownDrawing awaitedTool or dieQuality problemCustomer changeOther
Next action and who
What will move the job, and one name.
Supervisor
The person who updates this job card.
Remarks
Anything the next person must know. After dispatch: transporter and LR number.

How to keep it

When an order goes to the floor, give it a job card number and write one row: party, item and drawing, quantity and the promised date.
Every evening the supervisor sets the stage of each open job and the pieces done at that stage. "Pending" and "Days left" fill themselves.
A job that cannot move is set to "On hold", with a reason from the list and one name in "Next action and who".
Morning: sort by "Days left" and read the red rows, then the amber ones. Tell sales the same day when a promised date will be missed.
When the goods leave, set the stage to "Dispatched" and write the transporter and LR number in "Remarks".

Also in the file: messages

The morning message to the owner

Copy the lines below into a WhatsApp message and fill them from the red and amber rows.

JOB CARDS (date)

Late: (job card, party, item), (days) days past the promised date. Stage: (stage). Next: (action, and who)

On hold: (job card), (reason). Next: (action, and who)

Due in two days: (job card, party), at (stage), (pending) pieces to go

Dispatched yesterday: (job card, party, LR number)

The message to a customer when a job will be late

Your order of clamps C-12 (our job card 435) will reach you on (new date), not (old date). Reason: (reason, in one line). We will send the LR number the day it leaves.

Take the job card register with you

Free to use and to change. No macros, nothing to install.

Download the Excel file

The guide behind this format