Skip to content
Order Tracker cover: a sample sheet with orders logged, waiting to ship and delivered and a bar chart, beside the Dashboard and Orders tabs

Order Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This tracker is for a small shop, workshop or online seller that ships orders by post, courier or pickup. Every order line is a row on the Orders tab, with its order number, date, customer, item, quantity, unit price and status, plus the carrier and the day it must ship. The line total calculates itself. The Dashboard counts orders waiting to ship, adds up the order value and breaks the orders down by status and by carrier.

Enter an order as soon as it arrives, then update its status as it moves through packing, shipping and delivery. Set the ship-by date when you take payment. A row turns red when it is still placed and its ship-by date has passed, so you can deal with it first thing. Returned orders stay in the order value, so subtract them yourself or check the Returned figure in the status breakdown.

Useful for

  • Tracking orders from placed to delivered
  • Finding orders that are late to ship
  • Comparing carrier use and order value each month

What's included

  • 3 tabs: Dashboard, Orders, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Orders: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Orders tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I see which orders are late?

Look for red rows on the Orders tab. Rows go red if the status is still Placed after the Ship by date has passed. Packed orders are not highlighted, so check the Waiting to ship figure on the dashboard as well.

Can one order have more than one item?

Add a new row with the same order number for each item. The dashboard counts rows, so the Orders logged figure counts order lines. Use a separate list if you need the number of distinct orders.

Can I add my own carrier or status?

Yes. Extend the Carrier or Status list on the Orders tab, then give it a matching row in the dashboard breakdown with identical spelling, otherwise its count stays at zero.

  • #sales-tracker
  • #order-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More sales tracker templates

See all 8

Also in Sales

All sales templates
Get this template

Preparing your template…