● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Order Tracker
Order Tracker spreadsheet, hero view of the small business order tracker
BOOKKEEPING & BUSINESS FINANCE

Order Tracker

A customer asks where their order is, and the answer is scattered across inboxes and a notebook. This order tracker spreadsheet gives every order one line and one home, with its status, promised ship date and balance due always in front of you.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Answer 'where is my order?' in seconds, not searches

Every small shop knows the moment a customer messages to ask about an order, and the answer turns out to live in three inboxes, a notebook and somebody's memory, none of them agreeing. This tracker ends that scramble by giving every order one line and one home: what was ordered, what it came to, what has been paid, where it has got to, and the date you promised it would ship.

The Order Log carries the working detail, including payment status, amount paid, balance due and the tracking number once it exists. Beside it, the Order Pipeline mirrors the whole board by stage, so you can see what needs making, packing or posting today without reading every line. The Payment Status tab keeps the money honest on its own page: totals per order, what actually landed, what is still owed and the running total left to chase.

Two quiet features do the heavy lifting. The days-left countdown runs from the ship-by date you promised, and the attention flag calls out orders that are overdue, shipping today or due soon, before a customer has to ask. Then the Customer List counts orders, total spend and last order date per buyer, and the Monthly Summary closes the month with orders placed, gross sales, collected, outstanding and average order value.

Inside the workbook: 7 tabs

What you receive

  • Google Sheets Access PDF with a 1-click link that copies the tracker into your own Google Drive
  • BLANK Excel workbook, your clean fresh start
  • EXAMPLE Excel workbook filled with a realistic sample shop's month of orders at every stage
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files, no ZIP to unpack

Good to know

  • Works in Google Sheets with a free Google account
  • Works in Excel 2021 or Microsoft 365, and the files also import into Sheets
  • Runs happily on computer, tablet and phone
  • Any currency works, because amounts are plain numbers
  • Website, market, wholesale and repeat orders all log on the same lines

Questions about this template

The things buyers ask us most.

How is this different from an invoice tracker?

An invoice tracker follows the bill. This tracker follows the order itself: what was ordered, whether it is being made, packed, shipped or delivered, and whether it has been paid for. Most shops run both side by side, one for the paperwork of the sale and one for the work of fulfilling it, and the two are built to sit comfortably together.

How do the deadline flags work?

You type the ship-by date you promised on each order line. The Days Left column counts down on its own as that date approaches, and the Attention column flags the orders that need you: Overdue, Ship Today or Due Soon. A quick look at the log or pipeline each morning shows exactly which orders cannot wait another day.

I take deposits on bigger orders. Can it handle that?

Yes. Set the payment status on the order to Deposit Paid and type the amount that landed under Amount Paid. The balance due works itself out from the order total, and the Payment Status tab keeps every part-paid order and the overall total still owed in front of you, so deposits never turn into forgotten final balances.

Do I need Google Sheets or Excel?

Either one. The Access PDF gives you a Google Sheets copy in one click, needing only a free Google account, and the BLANK workbook opens in Excel 2021 or Microsoft 365. Both versions have the same seven tabs and the same working formulas, and the Excel files can also be imported into Google Sheets in a few clicks if you change your mind.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Inventory Tracker

Stock levels, reorder alerts and profit per item, kept up to date as you log.

$7.50 $3.00
View on Etsy
Sales Tracker

Log each sale once and see revenue after fees, top products and your best channels clearly.

$7.50 $3.00
View on Etsy
Small Business Petty Cash Tracker

Log petty cash in and out, record top-ups, and check counted cash against the expected balance.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00