Small Business Order Tracker Spreadsheet

**Every order in one place — what it sold for, what it cost, what it made, and whether it shipped.**

One file for every channel you sell on. Etsy, Shopify, eBay, Amazon, markets, wholesale, Instagram DMs — or all of them at once.

**INSIDE THE FILE — 5 TABS**

- Orders — 300 rows with dropdowns, and profit worked out on every single order

- Monthly — twelve months of revenue, cost and profit

- Dashboard — best channel, best product, unshipped order count, average order value

- Settings — your own channels, statuses and product list

- Start here — plain-English instructions

**WHY THIS ONE**

- Refunds and cancellations drop out of the totals automatically instead of flattering your numbers

- Profit is per order, so you can see the ones that were not worth packing

- Platform fees, shipping label and cost of goods are separate columns, so you can see which one is eating the margin

- An unshipped count that tells you what is still sitting on the table

- Nothing to install and no account to make. It is one file.

**HOW YOU USE IT**

1. Set up your channels, statuses and product list on the Settings tab. Five minutes, once.

2. Log each order as it comes in — pick the channel and status from the dropdown.

3. Fill in what it cost you. The sheet works out profit and margin on that order.

4. The Monthly and Dashboard tabs total everything up as you go.

**WHAT YOU GET**

- 1 x XLSX file (opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc)

- A "Start here" tab written in plain English

- Every cell pre-filled with a worked example, so you can see how it behaves before you touch it

**HOW IT WORKS**

Cream cells are the ones you type in. Grey cells work themselves out. That is the whole rule.

No macros. No pivot tables. No add-ons. Everything is built from ordinary formulas and dropdowns, which is why it behaves the same way in Excel and in Google Sheets. Nothing to enable, nothing to trust, nothing that breaks on the other side.

**TO USE IT IN GOOGLE SHEETS**

Google Drive > New > File upload > right-click the file > Open with > Google Sheets. That is it. No add-on, no permissions request.

**DELIVERY**

Instant download. Etsy emails you the file the moment payment clears. Nothing is posted to you.

**LICENCE**

Use it in your own business as much as you like, on as many devices as you like. Please do not resell, redistribute or share the file itself.

**A NOTE ON THE EXAMPLE DATA**

The file arrives filled in with example numbers so nothing looks empty and you can see every formula working. Type straight over them with your own.

Questions before you buy? Message me — I answer the same day.