Cost vs Revenue Trend: A Weekly Profitability Check
How to track the gap between your Revenue and Cost of Goods in AskBiz over time — and spot the early signs of a profitability squeeze before it reaches your bank account.
Key Takeaways
- Gross Profit = Revenue minus COGS — tracking this gap over consecutive weeks reveals your profitability trend.
- A narrowing gap (Revenue stable, Gross Profit declining) is a margin squeeze — the most dangerous slow-moving business problem.
- Compare Last 7 days to Last 30 days every Monday to spot a developing trend before it becomes a crisis.
- COGS in AskBiz is calculated from product cost prices — keep these updated for trend data to be reliable.
The gap that matters: Revenue minus COGS
Revenue and COGS (Cost of Goods Sold) should move in a consistent ratio over time. If Revenue grows at 10% per month and COGS also grows at 10%, your margin stays constant. The danger sign is when COGS grows faster than Revenue — the gap narrows, gross profit falls, and the business generates less per sale. AskBiz shows both Revenue and Gross Profit on the Reports hub, so you can calculate COGS (Revenue minus Gross Profit) and track the trend with a weekly note.
Setting up a simple weekly trend tracker
Create a simple log — a notebook or phone note works fine: Date | Revenue (Last 7 days) | Gross Profit (Last 7 days) | Margin %. Fill this in every Monday from Operations > Reports. After 4 entries you'll see a trend. After 8 entries (2 months) you'll have reliable baseline data. A margin that has drifted from 44% to 38% over 8 weeks is not visible in any single week's data — but your trend log shows it unmistakably.
Free — no card needed
See this in action for your business
AskBiz tracks these metrics automatically — just connect your data and start asking questions.
Start for free →Three scenarios and what they mean
Scenario 1: Revenue up, Gross Profit up, Margin stable — healthy growth. Scenario 2: Revenue stable, Gross Profit stable, Margin stable — steady state. Scenario 3: Revenue stable or up, Gross Profit falling, Margin declining — margin squeeze. Scenario 3 is the most dangerous because it looks like a normal trading week on Revenue alone. Only tracking the full trio reveals the problem. AskBiz shows all three numbers in one place — the discipline is in checking them together.
What causes the margin squeeze (and how to reverse it)
Supplier price increases without retail price adjustments are the most common cause — COGS rises while Revenue stays constant. Check your last 3 supplier invoices against your Inventory cost prices. If costs have risen 10–15% without a price update in AskBiz, update both the cost price and the selling price immediately. A 10% COGS increase on your top 10 products, unaddressed for 60 days, can reduce monthly Gross Profit by 15–20% depending on their revenue share.
Revenue growth that masks a margin problem
Promotional revenue growth is the most common Revenue-up, Margin-down scenario. You ran a 20% discount promotion, Revenue jumped 30%, but Gross Profit increased only 5%. The discount more than offset the volume gain. This is why the cost vs revenue trend check is more important than the revenue headline. Next time you see Revenue up sharply, immediately check Gross Profit — if it hasn't moved proportionally, something in the cost or discount structure needs correcting.