For Google Sheets™
Seller Order & Profit Tracker
See fees, net profit and margin for every order, and know when stock runs low — in a spreadsheet you own.
Want both trackers? The Sheetstead Template Bundle has the Invoice Tracker, the Order Tracker and the free log for $14.99 USD, one-time. Bought separately: $19.98 USD. See the bundle
What it fixes
- Marketplace and payment fees hide your real profit per order.
- Stock counts drift as orders and refunds add up.
- You find out a product is running low after it's too late to reorder.
What's inside
7 tabs and 4 menu actions.
| Tab | What it does |
|---|---|
| Start Here | Version, setup steps and the support address. |
| Settings | Currency symbol, date format and a fee profile for each sales channel. |
| Products | SKU, name, unit cost, starting stock, stock adjustments and reorder level. |
| Orders | One row per order: gross, fees, net profit and margin. |
| Stock | Current stock for each SKU, with a flag at or below the reorder level. |
| Dashboard | Revenue, fees, profit and products at or below their reorder level. |
| CHANGELOG | What changed in each version. |
The Sheetstead menu
- Add order row
- Mark selected as shipped
- Recalculate
- Clear example data
Note: No platform rates are built in. You enter the fee rates for each channel you sell on, so they match what you actually pay.
How each order's profit is worked out
You type the order: date, order ref, channel, SKU, quantity, unit price, any shipping you charged, any discount, what the shipping cost you and its status. The Orders tab works out gross, both fees, product cost, net profit and margin.
- Gross is quantity × unit price, plus shipping charged, minus the discount.
- Channel fee and payment fee are each a percentage of gross plus a fixed amount, from the fee profile of the order's channel.
- Product cost is quantity × the unit cost on the Products tab.
- Net profit is gross minus both fees, your shipping cost and the product cost.
- Margin is net profit as a share of gross.
Add one fee profile row on the Settings tab for each place you sell, such as a marketplace, your own online shop or a craft fair. Each order picks up the rates of the channel you choose for it.
A worked example from your copy
Your copy opens with three example orders and one example fee profile: a channel fee of 8% + $0.30 and a payment fee of 3% + $0.20. These are placeholder rates, not any platform's fees. The second example order sells one soy candle at $24.00 with a $2.00 discount, and shipping it cost $3.50.
| Column | Value |
|---|---|
| Gross | $22.00 |
| Channel fee | $2.06 |
| Payment fee | $0.86 |
| Shipping cost | $3.50 |
| Product cost | $7.50 |
| Net profit | $8.08 |
| Margin | 36.73% |
When you're ready for your own data, Clear example data removes the example orders and products. Then change the example fee profile to your first real channel.
How low-stock flags work
For each SKU, the Stock tab starts from the starting stock, takes away units sold on orders that aren't refunded and adds any stock adjustment you enter. When the result is at or below the reorder level you set, Low stock shows Yes for that SKU and the Dashboard lists it.
Each order is Open, Shipped or Refunded. A refunded order drops out of the Dashboard totals, and its units no longer count as sold.
How it works
- Buy the template — Checkout is on Polar. After payment you get the setup guide PDF.
- Make your copy — Open the copy link in the guide and choose Make a copy.
- Allow the script and start — The first time you use the Sheetstead menu, confirm the permission request. Then add a fee profile on the Settings tab.
Screenshots
The script can only access this one spreadsheet
The template's script asks for one permission: to see and edit the spreadsheet it's attached to. It doesn't send email, connect to outside services, or open other files. If a warning says the app isn't verified, the setup guide shows what to select.
What you need
- A Google account
- A desktop browser: Chrome, Edge, Firefox or Safari
- On phones and tablets you can enter data, but menus don't run
60-day refund
Ask within 60 days of purchase and you'll get a full refund, no questions asked. Refund policy
Note: Template only — no custom work. Support is by email at support@sheetstead.com.
Related
- Guide: calculate profit per order with formulas you can copy
- Invoicing clients instead? See the Freelancer Invoice & Payment Tracker
- Only need to log invoices? See the Free Invoice Log
- Want both trackers and the free log? See the Sheetstead Template Bundle