Building purchase history from invoices you already have

Every restaurant sits on years of purchasing evidence without a usable record of it. The information exists — on paper invoices, in email PDFs, in supplier portals — but scattered across formats where no question harder than 'how much did we spend?' gets answered. Building history means structuring that archive once so every later decision — negotiation, consolidation, menu pricing — starts from numbers instead of impressions.

From paper pile to decision record

• Extract per line. Invoice totals answer one question; line items answer hundreds. The unit economics of your top fifty items are the real asset.
• Then normalize. One supplier sells olive oil per liter, another per case of twelve. Until units agree, comparisons mislead more than they inform.
• Never overwrite the source. Normalized values live beside originals. When a conversion rule proves wrong, everything downstream stays fixable.

A worked example

Using the record without lying to yourself

1. 1Start with your top ten by spend. History pays back fastest on high-volume items. Perfect records of minor items are procrastination.
2. 2Compare like periods. Seasonality makes June-vs-January comparisons meaningless for produce. Compare against same-month-last-year when history allows, or rolling quarters.
3. 3Watch supplier behavior over time. One price point is a snapshot; six months is behavior. Drift patterns feed directly into negotiation and scorecard reviews.
4. 4Recalibrate conversions annually. Pack sizes change silently. An annual check of normalization rules against current packaging keeps the record honest.