Spend Analysis for Small Business: What You're Actually Buying

Most small business owners doing a spend analysis have never called it that. They've pulled three months of invoices into a spreadsheet, noticed that two suppliers now account for 70% of their procurement budget, and wondered whether that's a problem. It is — and the instinct to look is right. The analysis can go further.

Spend analysis is the practice of reading what your business actually bought — from whom, at what price trend, and with what concentration of risk. Closed-loop procurement — a buying workflow where purchase orders, supplier replies, receiving, and accounting handoff stay connected in one operating record — generates all five spend analysis dimensions as a byproduct of normal buying activity. Without a closed loop, the same analysis requires reconstructing purchase history from invoices, emails, and receiving logs. Either way, the five dimensions are the same.

Quick answer

An SMB spend analysis has five dimensions:

Dimension	What it reveals	Action threshold
Supplier concentration	Whether spend is overconcentrated in too few suppliers	Top-3 suppliers > 70% of total spend warrants review
Category breakdown	Where procurement budget actually goes	Categories drifting > 5 percentage points from target warrant rebalancing
Price drift	How suppliers' confirmed prices move from baseline	> 3% annual drift on a top-10 supplier warrants renegotiation
Purchase price variance	The gap between PO price and invoiced price	Aggregate PPV > ±3% signals a systematic problem
Spend velocity	How total procurement spend trends vs. revenue	Spend growing > 10% faster than revenue over two quarters signals over-ordering or price absorption failure

These five connect. Price drift feeds purchase price variance. PPV compresses gross margin. Supplier concentration amplifies every operational disruption. A spend analysis that covers all five shows whether the buying operation is drifting toward a problem the operator can't yet see.

Dimension 1: Supplier concentration

Supplier concentration measures how dependent the business is on a small number of suppliers — and how much operational risk that dependence creates.

Concentration ratio (top N) = (top N suppliers' combined spend / total spend) × 100

Run this for N = 3 and N = 5 across a 90-day window. Compare to prior periods.

What the numbers mean:

Concentration ratio (top 3)	Interpretation
< 50%	Healthy spread; no single point of failure dominates
50–70%	Moderate concentration; monitor primary supplier reliability closely
> 70%	High concentration; a disruption to any top-3 supplier creates immediate operational exposure

High concentration is not automatically bad. Deep relationships with key suppliers earn better pricing, priority allocation, and service. The risk is exposure: a supplier at 40% of spend who experiences a warehouse event, freight constraint, or pricing reset creates a problem that three diversified suppliers at 15% each do not.

The practical use of concentration analysis is supplier-priority setting. Suppliers above 20% of spend warrant explicit contingency planning — a second qualified source, a higher safety stock buffer, or a documented escalation contact. Suppliers above 40% warrant both.

The supplier scorecard covers per-supplier performance metrics. Concentration tells you which suppliers are large enough to justify that level of scrutiny in the first place.

Dimension 2: Category spend breakdown

Category breakdown answers: where is the money actually going? For a restaurant, that means produce, proteins, dry goods, beverages, and disposables. For a specialty retailer, it means the product categories that account for which share of supplier spend.

Category spend % = (spend in category / total spend) × 100

Apply ABC analysis to categories, not only to individual SKUs:

A-categories (top 70–80% of spend): review quarterly, maintain primary and backup sources, negotiate explicit price holds on fast-moving items
B-categories (next 15–20%): review semi-annually, consolidate suppliers where practical
C-categories (remaining 5–10%): review annually, focus on administrative simplification over price negotiation

The Pareto principle applies across most SMB procurement programs: roughly 80% of spend clusters in three to five categories. That 20% of categories representing 80% of spend deserves 80% of the buying discipline — negotiation attention, dual-sourcing effort, and performance tracking.

The action from category analysis is sourcing strategy. Which categories can reduce supplier count without increasing concentration risk? Which have supply diversity that isn't being used? Which are growing as a share of total spend faster than the underlying business justification explains?

Dimension 3: Price drift by supplier

Price drift tracks how each supplier's confirmed prices have moved relative to a baseline — the first confirmed price on record, an annual contract rate, or the price on the opening purchase order for the relationship.

Price drift % = ((current confirmed price / baseline price) − 1) × 100

Run this per line item, then aggregate to the supplier level by weighting each item's drift by its share of that supplier's spend. The result is a weighted average price drift per supplier.

Price drift is a distinct signal from purchase price variance. PPV captures the gap on a specific order — PO price versus invoice price. Price drift captures cumulative movement in the supplier's confirmed prices over time. A supplier can show near-zero PPV (they invoice close to what they quote) while showing 10% annual price drift if their quote prices keep rising quarter over quarter.

Action thresholds for annual price drift per supplier:

Drift range	Action
< 2%	Stable. Monitor routinely.
2–5%	Expected for most commodity categories. Review if persistent.
5–10%	Warrants conversation. Negotiate a price hold on fast-moving items, qualify a second source, or reconsider volume share.
> 10%	Urgent. At this level the supplier is repricing the relationship faster than the business can absorb in margin.

Price drift requires history. The minimum useful window is 60–90 days of receiving records with confirmed prices. Below that, the baseline period is too short to distinguish structural drift from one-time adjustments.

Dimension 4: Purchase price variance

Purchase price variance (PPV) is the most precise measure of whether the business is paying what it planned to pay. It compares the price on the purchase order to the price on the supplier's invoice or confirmation, per line item:

PPV per line = (PO price − invoice price) × quantity received

Aggregate across all orders in the period:

Aggregate PPV % = (Σ line PPV across all orders) / total planned spend × 100

Positive aggregate PPV means the business paid less than planned. Negative (unfavorable) PPV means more.

The economic consequence is specific. On a business with $600,000 in annual COGS, a −4% aggregate PPV represents $24,000 in unplanned cost. At a 30% gross margin baseline, that is a 4-percentage-point compression — not a rounding error in the context of a business trying to protect margin while navigating supplier price increases.

The ±3% threshold: Below 3%, timing differences and invoice rounding explain most of the gap. Above 3%, the cause is usually one of three things: a high-concentration supplier who systematically invoices above PO price; a category where market prices changed faster than quote updates; or a receiving process that is not capturing confirmed prices accurately. Each cause has a different response.

Per-supplier PPV tells you which relationships are drifting out of alignment. Aggregate PPV tells you whether the buying operation as a whole is landing near planned cost.

Dimension 5: Spend velocity

Spend velocity tracks how total procurement spend changes over time relative to revenue growth:

Spend velocity (period) = (spend in current period / spend in prior period) × 100 − 100
Revenue growth (same period) = (revenue in current period / revenue in prior period) × 100 − 100

Compare the two rates. Procurement spend growing 10% faster than revenue over two consecutive quarters is a diagnostic flag.

The right response depends on what is driving the divergence:

Price-driven velocity: Supplier price drift or PPV is pushing spend up, not volume. Revenue hasn't moved because prices have not yet been passed through. Action: address the supplier pricing directly, or adjust menu/retail prices if the cost increase is permanent.
Volume-driven velocity: Order quantities are growing faster than demand signals. Safety stock may be over-sized, or reorder quantities are not responding to actual consumption. Action: recalibrate order quantities using live consumption data and tighten safety stock inputs.
Mix-driven velocity: The product mix is drifting toward higher-cost SKUs without a corresponding demand signal. May be intentional (moving upmarket) or unintentional (buyers ordering premium variants that weren't specified). Action: review item-level spending versus prior-period baselines and identify which SKUs are driving the mix shift.

Spend velocity is a trailing indicator. It becomes most useful when tracked quarterly over a full year, so seasonal patterns are distinguishable from structural changes.

Running a baseline spend analysis

The minimum viable spend analysis requires three inputs: every purchase order, invoice, or receiving record from the last 90 days; the supplier name on each; and the confirmed (invoiced) unit price per line item.

Step 1 — Build the spend register. One row per line item. Columns: order date, supplier, item or SKU, category, quantity, unit price, total line cost.

Step 2 — Supplier concentration. Sum total cost per supplier. Sort descending. Calculate each supplier's percentage of total spend. Flag any supplier above 20% for monitoring; flag any top-3 combination above 70% for contingency planning.

Step 3 — Category breakdown. Assign a category to each item. Sum spend by category. Sort descending. Identify A-categories. Note whether any category's share has shifted more than 5 percentage points versus the prior 90 days.

Step 4 — Price drift. For each item, compare the earliest confirmed unit price in the register to the most recent. Calculate drift % per item. Aggregate to the supplier level weighted by item spend.

Step 5 — PPV. For each order line, compare the PO unit price (from the purchase order, if available) to the invoiced unit price. Multiply the difference by quantity received. Sum across all lines.

Step 6 — Spend velocity. Compare total spend in the current 90-day window to the prior 90-day window. Compare the growth rate to revenue growth in the same period.

A business with 15–20 suppliers can complete this baseline analysis in an afternoon. The constraint is data completeness: if PO prices are not recorded alongside receiving records, PPV is impossible to calculate without reconstructing the purchase order history from email. That reconstruction cost is exactly what a closed-loop procurement platform eliminates — every confirmed price, every receiving record, and every accounting handoff is captured in order during normal operations, making spend analysis a query rather than a project.

What to do with the findings

A spend analysis produces a ranked action list. The actions, in order of typical financial impact:

High concentration + low fill rate: The supplier you depend on most is also unreliable. Dual-source before a disruption forces the issue.
Unfavorable PPV > 3% on a top-5 supplier: Renegotiate with specific data. The invoice history supports the conversation.
Price drift > 5% on an A-category supplier: Determine whether menu or retail prices have absorbed the cost increase. If not, the margin erosion is already accumulating.
B-category over-fragmentation: Four suppliers competing for a small budget creates administrative overhead without meaningful risk diversification. Consolidating to two saves buying time.
Spend velocity outpacing revenue: Identify whether it is price-driven, volume-driven, or mix-driven before acting. Each requires a different response.

Not all findings require immediate action. The value of a recurring spend analysis is the trend — knowing that a supplier's drift is accelerating, that concentration is creeping up quarter over quarter, or that spend velocity diverged from revenue before the margin impact shows up in the P&L.

How closed-loop procurement generates spend data automatically

A closed-loop procurement platform accumulates all five spend analysis inputs as a byproduct of normal buying activity. Every purchase order records the supplier, the category, and the ordered price. Every supplier reply records the confirmed price. Every receiving record captures the actual quantity and any unit-price differences. Every accounting handoff records the invoiced amount.

The result: supplier concentration, price drift, PPV, category breakdown, and spend velocity emerge from queries against live data rather than from a 90-day spreadsheet reconstruction. The analysis stays current. Price drift alerts surface when a supplier's confirmed prices cross a defined threshold. PPV exceptions surface the moment a receiving record diverges from the purchase order. Spend velocity is visible in any reporting window, not only at quarter-end.

LineNow is a closed-loop procurement platform for SMBs with a structured-data analytics chatbot for natural-language queries against the live spend record — supplier breakdowns, price drift by supplier, aggregate and per-supplier PPV, category spend trends, and custom saved reports — at $100/month per business unit with a 90-day free trial. Start here.