COGS (Cost of Goods Sold)
The COGS module forecasts your direct cost of goods sold. It works product-by-product with configurable cost categories per product — so you can model different cost components (materials, transport, packaging) separately and understand your gross margin at a granular level.
COGS is always connected to a P×Q budget version. Every cost category is a unit cost that Monitr multiplies by the P×Q quantity for each month. You cannot enter COGS values without a P×Q budget.
Use COGS for:
- Products with direct variable costs that scale with sales volume
- Gross margin modelling per product
- Breaking out cost components (goods, transport, packaging) into separate P&L lines
Creating the module
- In your Scenario, click Add a budget
- Choose Cost of Goods Sold
- Follow the 4-step setup wizard
Step 1 — Introduction
An overview screen explaining the module. No configuration here.
Step 2 — Model
Connecting to a P×Q budget
Products in COGS come from a P×Q budget version — you cannot add them manually. Two sources:
- Start from a PxQ budget — imports products and their monthly quantity/price data from a selected PxQ budget version. Three default cost categories are created for each product automatically: Goods, Transport, and Packaging (all starting at zero). You can rename, delete, and add more.
- Start from a previous COGS budget — restores a saved COGS version, including all categories and the linked PxQ version.
Budget range
The budget range is inherited from the connected PxQ version and cannot be changed. If the PxQ range is later updated, the COGS dates and budget rows update automatically.
Cost categories
Each product has one or more cost categories. A category has:
- A name (editable; must not be empty)
- A monthly unit cost grid — one value per month in your budget range
Enter the cost per unit for each month. Editing a cell fills all subsequent months with the new value — so entering a unit cost in January applies it forward for the rest of the range unless you override specific months.
Every category value is a unit cost. Monitr computes the monthly total as:
Monthly COGS = unit cost × quantity (from P×Q)
Reference rows (read-only)
Below the editable categories, four rows are shown per product for reference:
| Row | What it shows |
|---|---|
| Quantity | Units sold per month, sourced from P×Q |
| Revenue (PxQ) | Average price × quantity per month, sourced from P×Q |
| Unit Total | Sum of all category unit costs for that month |
| Gross Margin | Revenue − (Unit Total × Quantity), shown in currency and % |
These rows update live as you edit category values.
Step 3 — Mapping
Assign a P&L reporting line to each cost category within each product. Only P&L lines are shown — Balance Sheet lines are excluded.
Reuse mapping: each category row has an icon button that propagates its mapping to all categories with the same name across all products. If all your products share "Goods", "Transport", and "Packaging" categories, you can map each once and apply it everywhere in one click.
Step 4 — Result
Three charts computed from your model data:
- Category Breakdown of COGS — bar chart showing each cost category as a % of total revenue across the full budget range
- Gross Margin by Product — stacked bar chart of gross margin in currency per product, broken down by month
- Gross Margin % — line chart of GM% per product over time
This step is read-only. Click Finish to name and save the budget version.
Connection to Inventory
If you use the Inventory module, saving or updating a COGS budget automatically updates any connected Inventory budget version. Deleting a COGS budget also removes the linked Inventory budget. This cascade is handled automatically — no manual action required.
Output in reports
COGS maps to the cost-of-sales lines in your P&L based on the category mappings set in Step 3. The Revenue dashboard shows forecasted gross margin (Revenue – COGS) and gross margin %.