CMV & Inventory
Cost of Goods Sold tracking and stock management
CMV This Month
—
CMV Amount
—
Revenue
—
Target CMV
35%
Industry benchmark
CMV % Trend
Last 6 months
Spend by Category (CMV)
Monthly CMV History
| Month | Opening Stock | Purchases (CMV) | Closing Stock | CMV ($) | Revenue | CMV % | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Add / Update Monthly Data
Enter your monthly inventory counts and revenue. The system automatically calculates CMV using your invoice purchases.
Physical count at month end — count/weigh each item × unit cost
How CMV is Calculated
Formula:
CMV ($) = Opening Stock
+ Purchases (is_cmv)
− Closing Stock
CMV (%) = CMV ÷ Revenue × 100
+ Purchases (is_cmv)
− Closing Stock
CMV (%) = CMV ÷ Revenue × 100
CMV Benchmarks:
< 28% — Excellent
28–35% — Healthy ← target
35–40% — Watch for waste
> 40% — Critical
Saved Monthly Entries
| Month | Opening Stock | Closing Stock | Revenue | CMV Target | |
|---|---|---|---|---|---|
| Loading… | |||||
Count stock every week (e.g. Monday morning) → the To Order column shows what to buy to reach par level.
| Item | Counted This Week | Weekly Par | To Order | Status | Last Count | Update Count |
|---|---|---|---|---|---|---|
| Loading stock levels… | ||||||