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
| As of | 46342 | Change the date, the currency and the grace minutes on Settings. Update each delivery's status as the day goes. | ||||
|---|---|---|---|---|---|---|
| Scheduled for today | 1 | Delivered this month | 45 | |||
| Out for delivery today | 2 | On-time rate (window met) | 75.6% | |||
| Delivered today | 0 | Late deliveries | 11 | |||
| Failed attempts today | 0 | Delivery success rate | 91.8% | |||
| Open jobs from earlier days | 2 | Failed attempts | 3 | |||
| Orders needing re-delivery | 1 | Re-deliveries completed | 2 | |||
| Rows that need a fix | 0 | Delivery fees billed | 415.75 | |||
| Month shown | 46327 | Driver pay (before tips) | 240.13 | |||
| On-time target | 90.0% | Fees minus driver pay | 175.63 | |||
| Tips | 19.00 | |||||
| Cash collected at the door | 437.00 | |||||
| Account balances owed (all time) | 360.25 | |||||
| Zone | Delivered | Failed attempts | On-time rate | Fees billed | Driver pay | Fees minus pay |
| Downtown | 8 | 0 | 87.5% | 57.00 | 28.00 | 29.00 |
| Midtown | 10 | 2 | 70.0% | 82.50 | 46.75 | 35.75 |
| Riverside | 9 | 0 | 66.7% | 76.50 | 45.00 | 31.50 |
| Northgate | 10 | 1 | 80.0% | 99.75 | 60.38 | 39.38 |
| Eastfield | 4 | 0 | 50.0% | 44.00 | 26.00 | 18.00 |
| Industrial Park | 4 | 0 | 100.0% | 56.00 | 34.00 | 22.00 |
| All zones | 45 | 3 | 415.75 | 240.13 | 175.63 | |
| Driver | Delivered | Failed attempts | On-time rate | Success rate | Total pay (with tips) | Cash to hand in |
| Marcus Webb | 9 | 0 | 88.9% | 100.0% | 42.75 | 49.50 |
| Priya Shah | 12 | 1 | 83.3% | 92.3% | 71.63 | 60.50 |
| Daniel Ortiz | 8 | 0 | 100.0% | 88.9% | 52.25 | 116.00 |
| Hannah Lee | 8 | 1 | 62.5% | 88.9% | 43.38 | 64.00 |
| Aisha Rahman | 8 | 1 | 37.5% | 88.9% | 49.13 | 147.00 |
| Tom Brennan | 0 | 0 | 0.00 | 0.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
- On Settings type your business name, your currency symbol and the As of date (today). The Dashboard month is the month of that date.
- On Zones list your delivery zones with the fee you charge and the pay a driver earns for one delivery in that zone.
- On Drivers add one row per driver, and on Customers one row per customer. Set each customer to Pay on delivery or Account.
- 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.
- 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.
- Type the money you collected at the door and any tip. Log what account customers pay you on Payments.
- 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.
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 sheet | In 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
- Real Estate Lead Tracking Spreadsheet (Excel)
- Production Tracking Spreadsheet for Excel
- Piece Rate Payroll Calculator for Excel
- Garment Costing Sheet for Excel
- Poultry Flock Tracker for Excel: Eggs, Feed, Mortality and Profit
- Dental Practice Treatment Plan Tracker for Excel
- Travel Agency Booking Tracker for Excel
- Generator Maintenance Log Template for Excel