Softwiro
Free Excel template

Delivery Tracking Spreadsheet for Excel (Dispatch Tracker)

A free delivery tracking spreadsheet for Excel, built for a small courier or local delivery business that dispatches a handful of drivers. You write one row per delivery attempt: order number, date, customer, zone, driver, the delivery window and the status, from Scheduled through Out for delivery to Delivered, Failed attempt or Returned. The workbook then works out the fee, what the driver earns, whether the parcel arrived inside its window and whether a customer owes you money, and it shows today's board and the month's results on one Dashboard. It works in Excel, LibreOffice and Google Sheets and in any currency.

Excel file (.xlsx) · 201 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
As of46342Change the date, the currency and the grace minutes on Settings. Update each delivery's status as the day goes.
Scheduled for today1Delivered this month45
Out for delivery today2On-time rate (window met)75.6%
Delivered today0Late deliveries11
Failed attempts today0Delivery success rate91.8%
Open jobs from earlier days2Failed attempts3
Orders needing re-delivery1Re-deliveries completed2
Rows that need a fix0Delivery fees billed415.75
Month shown46327Driver pay (before tips)240.13
On-time target90.0%Fees minus driver pay175.63
Tips19.00
Cash collected at the door437.00
Account balances owed (all time)360.25
ZoneDeliveredFailed attemptsOn-time rateFees billedDriver payFees minus pay
Downtown8087.5%57.0028.0029.00
Midtown10270.0%82.5046.7535.75
Riverside9066.7%76.5045.0031.50
Northgate10180.0%99.7560.3839.38
Eastfield4050.0%44.0026.0018.00
Industrial Park40100.0%56.0034.0022.00
All zones453415.75240.13175.63
DriverDeliveredFailed attemptsOn-time rateSuccess rateTotal pay (with tips)Cash to hand in
Marcus Webb9088.9%100.0%42.7549.50
Priya Shah12183.3%92.3%71.6360.50
Daniel Ortiz80100.0%88.9%52.25116.00
Hannah Lee8162.5%88.9%43.3864.00
Aisha Rahman8137.5%88.9%49.13147.00
Tom Brennan000.000.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Today's board (scheduled, out for delivery, delivered, failed), then the month: deliveries, on-time rate against the target, late deliveries, delivery success rate, failed attempts, re-deliveries, fees billed, driver pay, tips, cash collected and the balances account customers owe. Tables by zone, driver, status, the last 14 days and each month, a list of the jobs that need action, and five charts.
  • Deliveries: One row per delivery attempt: order number, attempt, date, customer, address, zone, driver, window from and to, status, delivered-at time, proof-of-delivery note, cash collected, tip and an optional fee override. The sheet works out the fee, the driver pay, what is billed to an account, On time or Late, and flags rows that need a fix or action. Room for 500 rows.
  • Drivers: One row per driver with vehicle and status. For the month it shows delivered, failed and returned parcels, on-time rate, success rate, delivery pay, tips, total pay, the cash to hand in and the open jobs. Room for 20 drivers.
  • Customers: Each customer with their terms, Pay on delivery or Account. For account customers it shows fees billed, payments received and the balance due. Room for 60 customers.
  • Payments: What account customers have paid you, by date and customer. Each payment reduces the balance on Customers. Room for 200 payments.
  • Zones: Your delivery zones with the fee you charge and the pay a driver earns per delivery, plus the month's deliveries, on-time rate, fees, driver pay and what is left per zone. Room for 12 zones.
  • Lists: Your vehicle types, and the fixed lists of terms and delivery statuses behind the dropdowns.
  • Settings: Business name, currency symbol, the As of date, the grace minutes after a window ends, the share of the fee and of the driver pay for a failed attempt, and your on-time target.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free delivery spreadsheets are a log of tracking numbers. This one is built around the day of a small dispatcher: the delivery window decides whether a drop was on time, a failed attempt and its re-delivery stay linked by the order number, and the zone sets both what you charge and what the driver earns. The sample is a six-zone, five-driver business through October and November 2026.

How do I track deliveries in Excel?

Keep one table with one row per delivery attempt and a handful of columns that never change: order number, date, customer, delivery address or zone, driver, the delivery window, a status and the time it was delivered. Add a proof-of-delivery note (who signed, where the parcel was left) so a customer dispute can be answered from the sheet. Everything else, such as fees and counts, should be calculated from those columns rather than typed.

In this template the status moves from Scheduled to Out for delivery to Delivered, Failed attempt or Returned, and the Dashboard reads it. As of 16 November 2026 the sample shows 2 jobs out for delivery and 1 still scheduled for the day. It also lists 3 jobs that need action: order D-1144 failed on 13 November and has no re-delivery yet, and two jobs dated 13 and 14 November are still marked open.

How do I calculate on-time delivery rate in Excel?

Decide first what on time means. Here a delivery is on time when the delivered time is no later than the end of its window plus a few grace minutes, which you set on Settings (10 in the sample). Each Delivered row is then marked On time or Late, and the rate is on-time deliveries divided by on-time plus late. Failed attempts are not counted, because there is no delivery time to compare.

In November so far, 34 of 45 deliveries were on time, a rate of 75.6%, against the 90% target on Settings, and 11 were late. The Drivers sheet splits it by driver: Daniel Ortiz was on time for all 8 of his deliveries, while Aisha Rahman made 3 of 8. The Zones sheet gives the same rate per zone, so you can see whether lateness is a driver problem or a route problem.

How do I track failed deliveries and re-deliveries?

When nobody is home, set the row to Failed attempt and add a note. Then add a second row with the same order number and attempt 2 for the next try. The sheet looks across rows by order number: a failed attempt with no later Delivered or Returned row is flagged Needs re-delivery and appears on the Dashboard list, so a parcel cannot sit forgotten.

A failed attempt is not free for you, so the fee and the driver pay for it are a share you choose on Settings (50% in the sample). In November there were 3 failed attempts and 1 returned parcel, a delivery success rate of 91.8%, and 2 re-deliveries completed. How much a driver earns is handled the same way: the zone sets the pay per delivery, and the Drivers sheet adds tips on top. The month's driver pay is 240.13 on 415.75 of fees, which leaves 175.63. For customers who pay later, see also the customer ledger; for vehicles, the fleet fuel and maintenance log.

How to use it

  1. On Settings type your business name, your currency symbol and the As of date (today). The Dashboard month is the month of that date.
  2. On Zones list your delivery zones with the fee you charge and the pay a driver earns for one delivery in that zone.
  3. On Drivers add one row per driver, and on Customers one row per customer. Set each customer to Pay on delivery or Account.
  4. On Deliveries add one row per delivery attempt: order number, attempt (1 for the first try), date, customer, zone, driver, the delivery window and the status. The fee and the driver pay come from the zone.
  5. When the parcel is dropped, set the status to Delivered and type the time it was delivered and a proof-of-delivery note. If nobody is home, set Failed attempt, then add a new row with the same order number and attempt 2 for the re-delivery.
  6. Type the money you collected at the door and any tip. Log what account customers pay you on Payments.
  7. Read the Dashboard for today's board, the on-time rate, failed attempts, driver pay, zone results, balances owed and the list of jobs that need action.

Before you start:

  • Capacity: 500 delivery rows, 20 drivers, 60 customers, 12 zones, 200 payments. The Dashboard shows the first 8 zones and the first 10 drivers.
  • One row is one attempt. A parcel that fails and is tried again has two rows with the same order number (attempt 1 and attempt 2).
  • On time: the delivered time is no later than the end of the window plus the grace minutes on Settings. On-time rate = on time / (on time + late), counted on the delivery date.
  • Delivery success rate = delivered / (delivered + failed attempts + returned) in the month.
  • Fee: the zone fee for a Delivered row (or the fee override if you type one). A Failed attempt is charged the share of the fee set on Settings. A Returned row is not charged.
  • Driver pay is the zone pay for a Delivered row, the failed-attempt share for a Failed attempt, and 0 otherwise. Tips are shown separately and go to the driver.
  • Account customers are billed the fee on their account; their balance is the fees billed minus the payments on the Payments sheet. Customers who pay on delivery have no balance.
  • Needs re-delivery: a Failed attempt whose order has no later Delivered or Returned row. Past date, still open: a Scheduled or Out for delivery row dated before the As of date.
  • Use one currency in one workbook. The currency symbol on Settings is only a label.

Excel file (.xlsx) · 201 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet needs someone to type in every shipment and every collection. In Wassalni, the merchant creates their own shipments and the courier updates their status from the courier app.

In this sheetIn Wassalni — Shipping & Delivery Management Platform
Every merchant phones to ask about their shipments and collections.Each merchant has an app to create shipments and follow their collections.
The courier gets orders on paper or on WhatsApp.Each courier has an app for the day's orders, and management gets reports per merchant, on courier performance and on collections.
The customer keeps calling to ask about their order.Tracking for every status, courier location sharing via GPS, and a tracking link sent to the customer on WhatsApp.
Online store orders are transferred by hand.A ready-made WooCommerce plugin and an API, so delivery is requested automatically with every order.

See Wassalni — Shipping & Delivery Management Platform · Ask for a demo

Frequently asked questions

Is this delivery tracking spreadsheet free?

Yes. Download it, use it for your business and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

How many deliveries, drivers and customers can it hold?

500 delivery rows, 20 drivers, 60 customers, 12 zones and 200 payments. The Dashboard shows the first 8 zones and the first 10 drivers. When the log is full, save a copy and start a new file.

How does it know a delivery was on time?

It compares the Delivered at time with the end of the delivery window plus the grace minutes on Settings. Delivered rows get On time or Late, and the on-time rate counts them on the delivery date.

Can customers pay later?

Yes. Set a customer to Account and the delivery fee is billed to them; log what they pay on Payments and the balance shows on Customers and on the Dashboard. Customers set to Pay on delivery have the cash you collected recorded on the delivery row instead.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Delivery companies

More free templates

All templates · Free tools