Most sellers do not fail because they made one large mistake. They fail because small ones stacked up over months before anyone noticed. A thin margin on one product. An ad campaign that quietly costs more than it returns. A rising return rate that was visible in the numbers weeks before it hit the bank account.
The weekly profit review exists to catch those small problems early. It takes fifteen minutes. It is not accounting — it is a check-in with the business's actual performance.
Multi-Channel Profit Tracker Margin & Markup Calculator Cashflow Forecaster Refund Impact Calculator Ad Spend Optimizer
Why weekly, not monthly
Monthly feels like enough. A seller runs a report at the end of the month, sees the numbers, and makes adjustments. The problem is that by then, four weeks of orders have already happened — with whatever pricing, ad spend, or return rate was in place during those weeks.
Weekly catches the same information while there is still time to change the outcome for the coming weeks. A margin problem discovered on day 7 costs a week. Discovered on day 30, it costs a month.
The routine does not replace bookkeeping or tax preparation. It is an operational check that keeps the business pointed in the right direction between those larger reviews.
The 15-minute structure
Five steps. Ten or fifteen minutes total once the setup is done.
The final step matters as much as the others. A review without a decision is just reading.
What to measure each week
The exact metrics depend on the channels you sell through. The core list is small.
| Metric | Why it matters |
|---|---|
| Total revenue (gross) | Baseline — everything else is calculated from it |
| Total orders | Volume signal; large changes often come from traffic shifts |
| Average order value | Revenue ÷ orders; catches basket-size changes early |
| Total fees paid | Platform, processing, and shipping, together |
| Ad spend | Often the largest variable cost after product |
| Net profit (before tax) | The number that actually matters |
| Net profit per order | Net profit ÷ orders; the most useful single number |
| Return count and rate | Returns ÷ orders; catches quality or expectation issues |
Eight numbers. Most platforms and payment processors show the raw data in dashboards that take a few clicks to read.
The math behind "net profit per order"
This is the metric that matters most week to week because it removes the distortion of volume. A week with more sales and lower profit per order is not necessarily better than a week with fewer sales and higher profit per order.
The calculation:
Formula
Net profit per order = (Revenue − All costs) ÷ Orders
Where "all costs" includes platform fees, payment processing, product cost, shipping, packaging, ad spend, and an amortized allocation for returns.
Worked example on a week with 40 orders:
| Line | Amount |
|---|---|
| Revenue | $1,240 |
| Platform fees | –$135 |
| Payment processing | –$45 |
| Product cost (COGS) | –$480 |
| Shipping and packaging | –$180 |
| Ad spend | –$210 |
| Return allowance (5%) | –$62 |
| Net profit | $128 |
| Net profit per order | $3.20 |
$3.20 net per order is the number to track. It should be consistent week to week unless something has changed. If it drops from $3.20 to $2.40 in a week, the cause is visible somewhere in the numbers above — ad spend rose, returns increased, average order value fell, or a supplier cost changed.
Spotting margin leaks early
The review is designed to surface four common leaks before they show up at month end.
1. Ad spend creeping up
Ad platforms tend to raise effective cost per click over time in competitive categories. A campaign that cost $0.60 per click last month may cost $0.85 this month without any change on the seller's side. Tracking ad spend against revenue week over week shows this as it happens.
2. Return rate drifting upward
Returns are the most common source of unexpected margin loss. A return rate that moves from 3% to 8% over a month silently removes profit without any visible change in orders. Reviewing returns weekly catches the shift while the cause is still identifiable.
3. Average order value slipping
An AOV drop of $3 on a product with a $4 net margin is a material problem. It often happens because customers are choosing cheaper variants, adding fewer items to the cart, or arriving from a different traffic source. Weekly tracking shows the change before the profit line does.
4. Product cost increasing quietly
Suppliers adjust pricing, freight rates change, and duty rates shift. A landed cost that rose by $0.40 per unit on a $3.20 net margin product is a 12% reduction in profit that no dashboard flags — unless the seller is recalculating cost per order.
How leaks compound
Week 1: $3.20 net per order.
Week 4: ad cost up slightly, return rate up 2%, AOV down $1. New net: $2.10.
Week 8: freight cost up 10%, another small AOV drop. New net: $1.40.
Nothing dramatic happened. But by week 8, the business is producing less than half the profit it did at the start — and no single week felt like a crisis.
Doing the review in a spreadsheet
The simplest setup is a single spreadsheet. Twelve columns for metrics, one row per week. Update once a week.
A minimal layout:
| Column | Content |
|---|---|
| A | Week ending date |
| B | Revenue |
| C | Orders |
| D | Average order value (B ÷ C) |
| E | Platform and processing fees |
| F | Product cost |
| G | Shipping and packaging |
| H | Ad spend |
| I | Return allowance |
| J | Net profit (B − E − F − G − H − I) |
| K | Net profit per order (J ÷ C) |
| L | Notes — what changed this week |
After four weeks, the spreadsheet shows trend lines that are invisible in any single week. Formulas do the arithmetic — the seller only enters the raw numbers.
What to do with the result
At the end of each review, write one thing. Not five. One.
Examples of well-formed weekly decisions:
- "Cut ad spend on the two listings that spent more than they returned this week."
- "Add a size table to the listing with the highest return rate."
- "Raise the price on the product with the worst net margin by $1 and measure conversion for two weeks."
- "Email the supplier about the freight increase and ask for a quote on a larger reorder."
The decision is the point of the review. Without it, the routine becomes note-taking.
Common mistakes with the review
- Doing it monthly instead of weekly. By the time the numbers are visible at month end, four weeks of orders have already happened with whatever problem was present.
- Tracking revenue only. Revenue looks good even when profit is falling. The net profit per order is the number that matters.
- Skipping the ad spend line. Ad spend is often the largest variable cost after product. Excluding it produces a profit number that is not real.
- Reacting to single-week swings. One bad week is noise. Look for three-week trends before making big changes.
- Not writing the decision down. The review produces a number. The decision turns the number into a change.
- Rebuilding the spreadsheet every week. Set it up once. Enter numbers. Let formulas do the rest.
What to do next
Set up the spreadsheet with the twelve columns above. Pick a fixed day of the week — Friday afternoon and Monday morning are common — and commit to 15 minutes.
After four weeks, the trends will be visible. After eight, the routine will be automatic and the small problems will be caught while they are still small.
The weekly review is not glamorous work. It is the work that keeps the business alive.
Multi-Channel Profit Tracker Margin & Markup Calculator Cashflow Forecaster Refund Impact Calculator Ad Spend Optimizer Break-Even Calculator
Frequently asked questions
Do I really need to do this weekly?
Weekly is the recommended cadence because problems are small and cheap to fix within a week. Monthly reviews catch issues after they have compounded. If weekly feels like too much, bi-weekly is better than monthly.
What if I only sell on one platform?
Still do the review, but simplify it. You skip the channel comparison and focus on the profit per order, return rate, and ad cost trends for that single channel.
How do I know what my net profit per order actually is?
Take the sale price, subtract platform fees, payment processing, product cost, shipping, and an allocation for returns and ads. That is the net profit for that order. Averaged across a week's orders, it gives you a usable number.
Should I include ad spend in the weekly review?
Yes. Ad spend is usually the largest variable cost after product cost. Excluding it produces a profit number that is not realistic. Include the exact spend for the week, even if it is a rough number.
What if my profit per order changes a lot week to week?
That is normal at low volume. A single return or a bad ad week can swing the average. Look for trends over four to six weeks rather than reacting to one data point.