A sales tracker turns scattered orders into a single view of what you sold, to whom, and whether money has arrived. For many UK small businesses, that clarity is the difference between guessing and planning.
You do not need complex software to start. A structured spreadsheet with consistent columns is enough to monitor monthly sales and spot unpaid orders early.
Recommended columns for a sales tracker
| Column | What to capture |
|---|---|
| Date | Sale or order date |
| Order / reference | Your invoice or platform order ID |
| Customer | Name or anonymised code for privacy |
| Product or service | What was sold |
| Quantity | Units or hours |
| Sales amount | Total before or after fees — pick one and stay consistent |
| Payment method | Card, transfer, cash, platform payout |
| Payment status | Paid, pending, partial, refunded |
| Notes | Delivery status, discounts, or follow-up needed |
Recording sales consistently
Decide whether amounts are gross (what the customer paid) or net (after platform or payment fees). Mixing the two distorts monthly totals. If fees matter, add a separate column rather than adjusting silently.
Log pending payments the day the order is placed, not only when cash lands. That way your tracker reflects commitments as well as cash received.
Monthly sales and simple KPIs
Summarise sales by month with a totals row or summary tab. Useful KPIs for small businesses include total revenue, average order value, number of orders, top products or services, and outstanding unpaid amount.
A simple chart — even manually updated — helps you see seasonality. Retail and services often have predictable quiet months; seeing them on paper reduces reactive discounting.
Dashboard ideas without over-engineering
- This month vs last month revenue
- Count of orders still marked pending
- Top three products by revenue this quarter
- Sales by channel if you sell in more than one place
- Repeat customers vs new customers (if you track customer IDs)
Connecting sales data to the rest of your business
Sales trackers work best alongside expense and invoice sheets. Revenue alone does not show sustainability; pairing sales with costs gives a clearer picture.
If you sell digital products, distinguish one-off purchases from subscriptions or bundles so monthly totals reflect your actual offer structure.
Example: selling across Etsy, markets and your own site
A jewellery maker in Glasgow might receive income from three places: Etsy orders with platform fees deducted before payout, card sales at weekend markets, and full-margin sales through a Shopify site. One sales tracker with a “Channel” column keeps the picture unified.
For Etsy rows they record gross sale, fee column and net payout date — because the cash hitting the bank does not match the customer-facing price. Market rows include stall fee as a separate expense elsewhere but log gross card and cash taken on the day. Website rows note postage charged versus actual label cost if margin matters for free-delivery promotions.
Without the channel column, a strong month on Etsy looks like runaway growth while margins shrink. With it, they see which channel funds the next materials order — and whether Saturday markets still earn their early starts after travel and pitch fees.
Payment status workflow
| Status | Meaning | Typical next action |
|---|---|---|
| Pending | Order confirmed; payment not yet received | Monitor; chase if beyond expected settlement |
| Paid | Full amount received | None — archive to monthly total |
| Partial | Deposit or instalment received | Note balance due and follow-up date |
| Refunded | Full or partial refund issued | Link to original order reference; adjust totals |
| Cancelled | Order did not proceed | Exclude from revenue; release any reserved stock |
| Chargeback / dispute | Payment reversed by provider | Flag for investigation; keep notes column updated |
VAT, fees and what counts as revenue
If you are VAT registered, decide whether sales amounts are stored net or gross of VAT and mirror that choice in every row. Mixed treatment breaks both your tracker and any dashboard fed from it. Many businesses store net, VAT rate and VAT amount in separate columns once registered.
Platform fees are expenses, not negative sales — unless you prefer a net-sales column for channel comparison. Pick one convention and document it on a Settings tab. Your accountant may want gross sales and fees separate for reporting anyway.
Trade counters and B2B sales on credit belong in the tracker the day the order is placed, with payment status updated when the transfer clears. Waiting until cash arrives understates busy months and hides overdue accounts that an invoice tracker should catch.
Using customer IDs and repeat purchase patterns
Assign each customer a simple code — C001, C002 — rather than relying on names alone. “Smith” appears twice; “J. Smith” and “John Smith” look like two people in pivot tables. Privacy-conscious businesses can use codes only and keep the name map on a separate restricted tab.
Repeat purchase rate is one of the most useful metrics a small business can track without analytics software. Count distinct customer codes this quarter versus last; note how many ordered more than once. A maker seeing eighty percent one-time buyers might invest in follow-up emails; a consultant seeing seventy percent repeat might raise prices modestly.
If you offer trade or wholesale tiers, add a “Price list” column — retail, trade, staff — so monthly totals explain margin differences without guessing which rows used which rate.
Sales tracker quality checks each month
- Reconcile tracker totals to bank and platform payout statements
- Confirm no duplicate order references from manual and automated imports
- Review all rows still marked Pending older than your normal settlement window
- Check refunds are linked to original sales, not logged as unexplained negatives
- Update top-product summary or pivot if you use one for purchasing decisions
- Note any channel you forgot to log before — add a reminder for next event