# Job Shop On-Time Delivery Tracker

> Source: https://netray.co/tools/job-shop-on-time-delivery-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable tracker that computes days late per job and the shop on-time delivery rate from promised and actual ship days.

## Category

mes-shop-floor

## Industry

Machine Shops

## Audience

- Production manager
- Shop owner
- Customer service

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Job number

**Key:** job

**Type:** text

#### Customer

**Key:** customer

**Type:** text

#### Promised date

**Key:** promised

**Type:** date

#### Ship date

**Key:** shipped

**Type:** date

#### Promise day number

**Key:** promise_day

**Type:** number

**Help:** Working day of the month the job was promised for.

#### Ship day number

**Key:** ship_day

**Type:** number

**Help:** Working day of the month the job actually shipped.

#### Days late

**Key:** late

**Type:** number

**Expr:** max(0, ship_day - promise_day)

**Format:** integer

#### On time (1 yes, 0 no)

**Key:** on_time

**Type:** number

**Expr:** if(lte(ship_day, promise_day), 1, 0)

**Format:** integer

#### Late reason

**Key:** reason

**Type:** select

**Options:**

- None
- Material
- Programming
- Machine down
- Outside processing
- Rework
- Customer change

**Rows:**

**Job:** J-24790

**Customer:** Northfield Hydraulics

**Promised:** 2026-10-09

**Shipped:** 2026-10-08

**Promise day:** 7

**Ship day:** 6

**Reason:** None

**Job:** J-24802

**Customer:** Ridge Aero

**Promised:** 2026-10-12

**Shipped:** 2026-10-15

**Promise day:** 8

**Ship day:** 11

**Reason:** Outside processing

**Job:** J-24815

**Customer:** Delta Pump

**Promised:** 2026-10-14

**Shipped:** 2026-10-14

**Promise day:** 10

**Ship day:** 10

**Reason:** None

**Job:** J-24833

**Customer:** Ridge Aero

**Promised:** 2026-10-16

**Shipped:** 2026-10-21

**Promise day:** 12

**Ship day:** 15

**Reason:** Machine down

**Totals:**

#### Total days late

**Key:** late

**Agg:** sum

**Format:** integer

#### Jobs on time

**Key:** on_time

**Agg:** sum

**Format:** integer

**Summary:**

#### On-time delivery rate

**Key:** otd

**Expr:** sum_on_time / count * 100

**Format:** percent

**Primary:** true

**Description:** Jobs shipped on or before the promise day divided by total jobs.

#### Average days late per job

**Key:** avg_late

**Expr:** sum_late / count

**Format:** decimal

**Notes:** Enter the working day number alongside the dates so the sheet can compute lateness. Count a job on time when it ships on or before the promised day.

## Content

**Intro:** On-time delivery is the number small shops are judged on, and few track it past a gut feeling. This worksheet computes days late and the on-time rate from the promised and actual ship days, with a reason code so you can see what is actually causing misses.

**Sections:**

#### How to use the tracker

**Body:** Add one row per shipped job. Enter the promised and actual dates for the record, and the working day number of each within the month for the calculation. The sheet then shows days late, flags on-time jobs and calculates the shop on-time delivery rate. Pick a late reason for every miss. After a month, sort or export to Excel and count which reason appears most often.

#### The formula

**Body:** On-time delivery percent equals jobs shipped on or before the promised date divided by total jobs shipped, multiplied by 100. Be consistent about the promise date: use the date confirmed to the customer, not the original request, or report both. Measure by job or by line and keep the method the same each month.

**Bullets:**

- Use the date acknowledged to the customer as the promise
- Count partial shipments consistently
- Report by customer if one account drives the misses
- Review late reasons monthly, not just the total

#### Reading the result

**Body:** A single percentage hides the pattern. If most late jobs share the reason Outside processing, the fix is scheduling and vendor lead time, not overtime. If the reason is Material, review how you order against the quote. The late reason column turns a score into an action list.

#### ERP notes

**Body:** JobBOSS, E2 Shop System, Global Shop Solutions and ProShop all hold promise and ship dates on the job or order line, and most offer a delivery report. Use this sheet if you want a simple view with your own reason codes, or to compare against what the ERP reports. Differences usually come from how partial shipments and changed due dates are treated.

**Cta:** If you want delivery performance and late reasons calculated straight from your ERP each week, Netray can help set that up.

**Faq:**

#### Why do I enter day numbers as well as dates?

**Answer:** The calculation engine works on numbers, so the working day of the month for each date gives a simple, consistent measure. Keep the dates for your record and use the day numbers for the math within one month.

#### What is a good on-time delivery rate?

**Answer:** It depends on the customer base and industry. Many customers expect 90 percent or better, and some aerospace and defense accounts set higher targets. Check your customer scorecards for the actual requirement.

#### How do I handle partial shipments?

**Answer:** Pick one rule and apply it every time. Common choices are to measure on the final shipment of the job or to measure each shipment line separately. The important part is consistency.

#### Can I track across several months?

**Answer:** Yes, but reset day numbers per month or export each month separately. For multi-month analysis, export to Excel and use date arithmetic there.

## Search terms

on time delivery tracker excel, otd tracking spreadsheet machine shop, job shop delivery performance, late jobs report template, on time delivery calculation manufacturing, customer delivery scorecard

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json