Order tracker template: where every piece is, without asking
Track every order from deposit to install: acknowledgement, quoted and actual ship dates, carrier, receiving, damage and delivery. The template that answers "where is the sofa" without an email. Free CSV.
By Idan Mann, founder of NYA
The short answer
An order tracker follows each purchase order from deposit to installation — acknowledgement, quoted ship date, actual ship date, receiving, damage and delivery. It exists because a schedule tells you what was bought and a tracker tells you where it is, which is the question clients actually ask.
Download the CSVNo email, no account. Opens in Excel, Numbers or Google Sheets.
The most expensive hour in a design office is the one spent working out where something is. A tracker is not project management theatre — it is the difference between answering a client in ten seconds and emailing three vendors to find out what you should already know.
The column that matters most is deposit cleared, because that is when the lead time clock actually starts. An approval sitting three weeks before a PO goes out has already spent three weeks of the client's patience on your admin, and the factory will get the blame.
What each column carries
| Column | What goes in it | Example |
|---|---|---|
| PO # | The order this line belongs to. Ties back to the purchase order and forward to the invoice. | PO-2026-0148 |
| Item # / room | So the tracker and the schedule can be read side by side. | LR-04 / Living Room |
| Vendor | Who to chase, and who owes the acknowledgement. | Vitra USA |
| Order date | When you issued it, which is not when the lead time starts. That is the deposit clearing. | 2026-07-31 |
| Deposit cleared | The date production can actually start. Every quoted lead time should be counted from here, not from the order date. | 2026-08-01 |
| Ack. received | Date the vendor confirmed the order, and whether it was checked against the spec. Unchecked means unplaced. | 2026-08-04 ✓ |
| Quoted ship | The date the acknowledgement promised — the commitment, as distinct from the estimate you had at specification. | 2026-10-23 |
| Actual ship | When it really left. The gap between quoted and actual is the number that tells you which vendors to trust next project. | 2026-10-29 |
| Carrier / tracking | Who has it and the reference, so a chase does not start with 'which trucking company was that'. | Sunbelt Frt — SB4471902 |
| Received | Date your warehouse logged it in against the sidemark. | 2026-11-06 |
| Damage / claim | Whether damage was noted at receiving and any claim reference. Concealed-damage windows are short — this column is what stops one closing unnoticed. | None — inspected, photos on file |
| Delivery / install | The scheduled date on site, which is what the client actually wants to know. | 2026-11-20 |
| Status | One value from a fixed list: Ordered, Acknowledged, In production, Shipped, Received, Delivered, Installed. | Received |
| Notes | Anything that would otherwise live in an email thread nobody else can see. | Base ships separately, ETA 11-13 |
Read it by exception
- Sort by quoted ship and look at the top of the list weekly. Anything whose date has passed without an actual ship date is a call you should be making, not one you should be receiving.
- Filter for blank acknowledgements older than a week. That is not a slow vendor; that is usually an order that never got entered.
- Filter for blank deposit cleared. Every day in that state is a day the lead time has not started and nobody knows it.
- The longest lead item per room sets the install date — not the average, and not the one the client asks about most.
Common questions
- Is a tracker not just the schedule with more columns?
- They answer different questions and change at different rates. The schedule answers what was specified and approved and settles down once a project is bought; the tracker answers where things are and changes weekly. Keeping them separate keeps the schedule stable enough to be a record.
- How often should it be updated?
- Whenever a document arrives — an acknowledgement, a shipping notice, a receiving report. Updating on document arrival rather than on a schedule is what keeps it worth trusting; a tracker updated weekly from memory is a tracker that is wrong for six days at a time.