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

What's inside

7 tabs and 4 menu actions.

Tabs in the Seller Order & Profit Tracker
TabWhat it does
Start HereVersion, setup steps and the support address.
SettingsCurrency symbol, date format and a fee profile for each sales channel.
ProductsSKU, name, unit cost, starting stock, stock adjustments and reorder level.
OrdersOne row per order: gross, fees, net profit and margin.
StockCurrent stock for each SKU, with a flag at or below the reorder level.
DashboardRevenue, fees, profit and products at or below their reorder level.
CHANGELOGWhat changed in each version.

The Sheetstead menu

  1. Add order row
  2. Mark selected as shipped
  3. Recalculate
  4. 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.

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.

The second example order on the Orders tab
ColumnValue
Gross$22.00
Channel fee$2.06
Payment fee$0.86
Shipping cost$3.50
Product cost$7.50
Net profit$8.08
Margin36.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

  1. Buy the template — Checkout is on Polar. After payment you get the setup guide PDF.
  2. Make your copy — Open the copy link in the guide and choose Make a copy.
  3. 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

Orders tab of the Seller Order & Profit Tracker with fees, net profit and margin for each example order
Orders tab: fees, net profit and margin for each order.
Dashboard tab showing revenue, fees, profit and products at or below their reorder level
Dashboard: revenue, fees, profit and low-stock products.
Stock tab listing current stock for each SKU with reorder flags
Stock tab: current stock for each SKU with reorder flags.

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

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.