Spend analysis helps a small business answer a practical question: what should we change about the next purchase? A supplier total alone cannot tell you whether rising spend came from higher prices, more stock, a different product mix, or opening another location.
For a retailer, caterer or hospitality operator, start with supplier invoices and connect them to purchase orders and receipts. Your POS supplies sales context; purchasing records explain what you ordered, what changed and what arrived. Keep those different events distinguishable.
Quick answer
To run a procurement spend analysis, choose a consistent period and cost basis, clean supplier and item records, then review five questions:
| Review | Question | Useful next action |
|---|---|---|
| Supplier concentration | Which suppliers matter most to spend and continuity? | Check alternatives for critical items |
| Category spend | What are we buying more of? | Explain changes in quantity, mix and location |
| Price drift | Has the same item become more expensive? | Compare equivalent packs and agreed terms |
| Price variance | Did the invoice match the chosen price baseline? | Investigate the specific order line |
| Spend growth | Why are purchases changing relative to sales or usage? | Review stock, demand and timing before reordering |
These are review questions, not universal percentage targets. A low-spend supplier can provide an irreplaceable item; a large supplier can be dependable and economical. Set review priorities around the consequences for your business.
Build a register you can trust
Choose what “spend” means for this analysis. An invoice-based register measures invoiced purchases. An order-based register measures commitments. A payments report measures cash leaving the business. Adding all three counts the same purchase more than once.
For an initial invoice-based review, use one row per invoice line, with these fields:
- Supplier, invoice number and line identifier
- Invoice date, item, category and receiving location
- Quantity, purchase unit and units per pack
- Net unit price and line amount, with credits linked to the original purchase
- Currency and a consistent treatment of discounts, freight and tax
- Matching PO and receipt references, where available
Use a period that covers your buying cycle, then compare it with a period of similar length and trading conditions. A recent quarter can be a starting point, but seasonal businesses also need the corresponding season. Mark incomplete history rather than presenting it as a full period.
Normalize supplier aliases and item packs before calculating trends. A case of six and a case of twelve are different quantities even if both are called “one case.” Do not interpret a product substitution as a price change for the original item. Reconcile totals to the chosen source and keep missing matches visible.
1. Review supplier concentration alongside critical items
Calculate each supplier’s share of comparable spend:
Supplier share = supplier spend / total spend × 100
You can also sum the largest three or five suppliers. State the period, scope and denominator beside the result. If total spend is zero, the percentage is undefined.
In a fictional example, a business invoices $20,000 of purchases in a month and $8,000 comes from one supplier. That supplier represents 40% of the measured spend. This establishes concentration; it does not establish whether the business needs another supplier.
Check which items would interrupt trading if unavailable, how quickly an alternative could deliver, and whether apparent alternatives share the same upstream source. Review supplier performance with a supplier scorecard. Prioritize a contingency for a critical item even when its supplier represents little spend.
2. Explain changes in category spend
Group purchases into categories that support a decision. A food business might use produce, proteins, beverages and packaging. A specialist retailer might separate resale stock, consumables and equipment.
Category share = category spend / total spend × 100
When a category’s share grows, compare both the amount spent and the quantities bought. A larger share can result from another category shrinking. It can also reflect a planned event, a new store, a bulk purchase or a change in product mix.
Use ABC analysis to organize attention, then add operational criticality. Low-cost packaging can still prevent an order from shipping. There is no universal rule that a fixed number of categories must account for most of your spend.
3. Measure price drift on equivalent items
Compare the same specification, pack, currency and cost basis against a documented baseline, such as an agreed contract price or a prior comparable purchase:
Price drift = (current unit price / baseline unit price − 1) × 100
A positive, nonzero baseline is needed for that percentage. Record the actual dollar change as well.
Fictional example: a twelve-bottle case moves from $36 to $38, with no other change in terms. The increase is $2 per case, or approximately 5.56%. For eight cases, the proposed increase is $16 before freight and tax. If the new case contains fewer bottles, normalize the unit cost before comparing.
An agreed price increase may be legitimate. Ask whether the contract allows it, whether an equivalent alternative is available, and whether changing suppliers would introduce freight, minimum-order or service costs.
For a supplier-level index, document the basket and weights. Changing the mix of items can change average purchase cost even when individual prices remain unchanged. Keep new items and unmatched products separate from like-for-like price trends.
4. Separate price variance from quantity differences
Accounting purchase price variance compares actual purchase price with a standard or expected price. A PO-to-invoice comparison uses the order price as its baseline; that is useful for checking an agreement, but the PO price is not automatically the accounting standard. OpenStax explains the standard-versus-actual materials price comparison.
For this operational review, use:
Price variance = (invoice unit price − baseline unit price) × matched quantity
Here a positive result means the invoiced price is higher than the baseline: an unfavorable cost variance. Some reports reverse the subtraction, so always label the convention.
Using the fictional case above, eight invoiced cases at $38 against a $36 baseline produce a $16 unfavorable price variance. If only six cases are invoiced, compare six equivalent cases: $12 unfavorable. Separately investigate any mismatch between invoiced and received quantities. Do not multiply an invoice price by the full original order quantity when those quantities do not match.
Keep supplier proposals, accepted revisions and invoiced prices separate. A proposed increase is not yet an actual purchase cost. Preserve the original baseline if you want to measure cumulative drift; overwriting it after each confirmation can hide the change.
Review both favorable and unfavorable lines. Offsetting variances can make a total look normal while individual orders still need attention. A lower purchase price also does not prove a saving after extra inventory, waste or delivery costs.
5. Compare spend growth with sales, usage and stock
Calculate growth over comparable periods:
Spend growth = (current-period spend / prior-period spend − 1) × 100
If the prior period is zero, report the dollar change instead of a percentage. State whether your measure covers invoices, commitments or payments.
Purchases and sales occur at different times. Buying ahead for an event increases stock before revenue arrives; delaying a delivery can temporarily reduce purchases without improving efficiency. A POS sales report therefore needs purchasing and inventory context.
Investigate changes in:
- Price: equivalent items cost more per unit.
- Quantity: more stock was purchased, whether for demand, buffers or an unintended duplicate order.
- Mix: different products, locations or business activities account for more of the spend.
- Timing: receipts, invoices, credits or seasonal buying shifted between periods.
If spend grows 20% and revenue grows 10%, the difference is ten percentage points. It is a prompt to investigate, not proof of over-ordering. Confirm stock on hand, open orders and expected consumption before reducing a reorder.
Turn the review into the next buying decision
Keep an action list with the evidence, responsible person and follow-up date. For example:
| Finding | Check before acting | Possible action |
|---|---|---|
| The same item costs more | Pack, specification, freight and accepted terms | Ask the supplier to explain or correct the price |
| Purchases rose while usage stayed flat | Stock count, open POs and upcoming demand | Adjust the next order after checking coverage |
| A critical item depends on one supplier | Alternatives, qualification and lead time | Test a backup supply route |
| Invoice quantity exceeds the receipt | Partial deliveries and invoice coverage | Resolve the exception with the supplier |
Track what happened after the action. Negotiated savings are not the same as realized savings. Buying at a lower unit price can still increase cash tied up in stock, and purchases are not automatically cost of goods sold in the same period.
Where LineNow fits
LineNow connects purchasing activity with supplier conversations and receiving, so the next review can start from the order’s history. The usefulness of the analysis depends on the records available, their completeness and your item mappings. Revenue, consumption and accounting data may require a separate source or supported connection.
When evaluating the software, bring one item with a price change, one partial receipt and one unmatched invoice. Ask the team to demonstrate how you would retrieve the relevant records, compare equivalent units and trace a result back to its source. Verify any required report, export or AI query against those examples rather than assuming every metric is preconfigured.
Explore supplier order tracking, see inventory replenishment workflows, or book a purchasing demo. For current commercial terms, see pricing.