Getly
A sales tracker spreadsheet small business owners can trust is a plain table with one row per order and a few columns that never change: date, channel, product, quantity, price, discount, fees, refund and net. Set it up before Black Friday on 27 November, log every order the same way, and in December you can see which product, channel and coupon actually paid. Ready-made templates on Getly cost a median of $9 for trackers with "sales" in the name, measured 4 November 2026. This guide covers what to log, which formulas matter, Excel or Google Sheets, and what to check before you buy one.
What the shelf looks like today
We measured two things on 4 November 2026. The narrow one is what this article is about: listings whose name contains "sales" inside the Excel, Google Sheets, spreadsheets and business-finance categories. The wide one is that whole shelf, which also holds budget planners, invoice templates and calculators.
| Sales trackers (name contains "sales") | Whole spreadsheet and finance shelf | |
|---|---|---|
| Active listings | 17 | 530 |
| Median price | $9 | $12 |
| Middle half of prices | $3.99 to $15 | $7.60 to $15 |
| Free listings | 0% | 2.5% |
| Commercial use allowed | 47.1% | 48.9% |
| Personal use only | 29.4% | 24.7% |
| No licence stated | 11.8% | 21.5% |
Two things follow. First, a sales tracker is a small purchase: most cost between about $4 and $15, so price is rarely the deciding factor. Second, almost half of the narrow shelf allows commercial use. For a tracker you use inside your own shop, that is the licence you want. More on that below.
You can browse the shelves directly: Excel templates, Google Sheets templates, spreadsheets and calculators and business and finance.
Why set it up before the holiday rush
From late November to Christmas, a small shop gets more orders in a few weeks than in a slow quarter. That is exactly when nobody has time to invent columns. If the tracker exists before Black Friday, each order takes a few seconds to log. If it does not, you end up in January rebuilding the season from payment emails and bank statements.
A tracker set up now also answers the questions you will ask afterwards:
- Did the Black Friday coupon bring new people, or just discount people who would have paid full price?
- Which channel (your site, a marketplace, Instagram, a market stall) kept the most money after fees?
- Which product sold out, and which one only sold with a discount?
- How much went back as refunds and returns?
The columns to log for every order
Keep one row per order line. If one customer buys two different products, that is two rows with the same order ID. This makes per-product totals trivial.
| Column | What goes in it | Why it matters |
|---|---|---|
| Date | Order date as a real date, not text | Weekly and daily totals, Black Friday vs the rest |
| Order ID | The ID from your shop or payment system | Matching refunds and spotting duplicates |
| Channel | Picked from a dropdown: site, marketplace, social, in person | Which channel earns after fees |
| Product / SKU | From a dropdown fed by a product list | Typos split one product into three |
| Quantity | Units in this line | Stock planning |
| Unit price | Price before discount | Shows the real discount depth |
| Discount / coupon | Code used and the amount off | Measures each promotion |
| Shipping charged | What the customer paid for delivery | Keeps gross revenue honest |
| Fees | Payment and platform fees for this order | The difference between busy and profitable |
| Cost of goods | What the item cost you to make or buy | Margin per product |
| Refund | Amount returned, if any, and the date | Net results after returns |
| Net | A formula, never typed by hand | The number you actually keep |
| Customer type | New or returning | Whether the season grew your base |
If you sell only digital products, drop shipping and cost of goods and keep the rest. If you sell in several currencies, add a currency column and a converted amount, and say in a note which rate you used.
Formulas that make the tracker useful
A good template does the arithmetic for you. These are the formulas worth checking for, or adding yourself. The examples assume columns F (unit price), E (quantity), G (discount), I (fees), J (cost of goods) and K (refund).
- Gross:
=E2*F2 - Net:
=E2*F2-G2-I2-J2-K2, copied down the whole column. - Total per channel:
=SUMIFS(L:L,C:C,"Marketplace"), where L is net and C is channel. - Total for one week:
=SUMIFS(L:L,A:A,">="&DATE(2026,11,23),A:A,"<="&DATE(2026,11,30)) - Average order value: net total divided by the count of unique order IDs.
- Discount share: total discount divided by total gross. If it climbs past what you planned, the coupon is too generous.
A pivot table on top of the log answers most questions in a minute: rows by product, columns by week, values as sum of net. Both Excel and Google Sheets build one from a clean table. That is why the "one row per order line, no merged cells" rule matters.
A made-up example
To show how the columns work together, here are three invented rows for an imaginary candle shop. They are not data from any real business.
| Date | Channel | Product | Qty | Price | Discount | Fees | Net |
|---|---|---|---|---|---|---|---|
| 27 Nov | Site | Pine candle | 2 | $18 | $7.20 | $1.40 | $27.40 |
| 27 Nov | Marketplace | Pine candle | 1 | $18 | $0 | $2.90 | $15.10 |
| 28 Nov | In person | Gift box | 1 | $40 | $4 | $0.90 | $35.10 |
Even this tiny example shows the point: the discounted row on the site still kept more per candle than the full-price marketplace row, because the fee was lower. You only see that if fees have their own column.
Excel or Google Sheets
| Excel (.xlsx) | Google Sheets | |
|---|---|---|
| Works offline | Yes | Limited |
| Shared with a partner or helper | Through OneDrive or by sending the file | Live, in the browser |
| Phone entry at a market stall | Possible in the app | Easy in the app |
| Pivot tables and charts | Full | Good enough for a small shop |
| Macros | VBA, may be blocked on download | Apps Script |
Many listings ship an .xlsx file that also opens in Google Sheets. Check the description: some templates use features that do not survive the import, such as VBA macros, some chart types or Excel-only functions. If you will work in Sheets, prefer a listing that says it was built or tested there, or one that ships a copy link.
What to check before you buy
- The file list. On the product page, look for an .xlsx file or a Google Sheets copy link. A PDF alone is a picture of a spreadsheet, not a tracker.
- Screenshots of real tabs. You want to see the order log, a summary or dashboard tab and the settings tab where you set products and channels.
- Formulas, not typed totals. The description should say totals and charts update by themselves.
- Dropdowns. Channel and product should come from a list, so a typo cannot split your totals.
- Fees and refunds. Many simple trackers only log revenue. For the holiday season you need both columns.
- Room to grow. Formulas should cover whole columns or a table that expands, not just the first 100 rows.
- Currency and date format. Check that you can change the currency symbol and that dates sort as dates.
- Licence. Every listing has a licence field near the buy button.
Licences, and what they mean for a tracker
For a spreadsheet you use to run your own shop, "personal use only" is often written with households in mind. "Commercial use allowed" is the clearest fit for a business. On the narrow sales tracker shelf, 47.1% of listings allow commercial use, 29.4% are personal use only and 11.8% state no licence. If a listing states no licence, Getly shows nothing rather than guessing. Ask the seller through the product page before you pay, and do not assume commercial use is allowed. Reselling or sharing the template itself with other shops is a different right: look for an extended licence or ask.
Paying, downloading and refunds
On Getly you pay by card (with Apple Pay or Google Pay where available) or with USDT or USDC. No account is needed. A card order is delivered right after payment, a crypto order once the network confirms it. The file stays in your library and you can download it again later. If the template is not what the listing described, you have a 30-day refund window: you send a refund request and the Getly team reviews it.
A short plan for the next two weeks
- Pick a template, or copy the columns above into a blank sheet.
- Fill the settings tab: your products, channels and the coupons you plan to run.
- Log last week's orders as a test. Check that net and the summary tab look right.
- Decide who logs orders and when: once a day is enough for most small shops.
- After the season, build one pivot table by channel and one by product, and write down what you will change next year.
Start with the Excel templates or Google Sheets templates, read the file list, and choose the one that logs fees and refunds, not just revenue.
