How to Track Grocery Prices from Receipts

A receipt records what you paid on one trip. It becomes useful for budgeting only after you make the product, quantity, unit, store, date, and promotion status comparable. Keep your personal purchase history separate from official inflation statistics: they answer related but different questions.

The practical goal is not a perfect index. It is a small, repeatable record that tells you whether the same basket is becoming more expensive, whether pack sizes changed, and which substitutions are driving your total.

Start with a product definition

“Milk” is not one product for comparison. Record brand or type, fat level, package size, number of units, and whether the receipt shows a discount. Use a stable product name such as “semi-skimmed milk, 1 litre, store brand” rather than the abbreviated till code.

Normalize every line before comparing prices

1. Copy the date and store. Keep the purchase context.
2. Record quantity and package size. A two-pack is not one unit.
3. Calculate the unit price. Divide the final line amount by grams, litres, or each item.
4. Label the price state. Keep shelf price, loyalty discount, coupon, and final paid amount as separate fields.
5. Note substitutions. A cheaper brand or smaller pack is a choice, not evidence that the same product fell in price.

Use a unit-price table

The 18 May ticket looks cheaper than €1.95, but its normalized price is higher because the pack is smaller. Mark the 25 May promotion separately so it does not become your assumed everyday price.

Separate promotions from the underlying price

Record at least three values when the receipt allows it: regular or shelf price, discount amount, and final amount paid. For a household budget, final paid amount matters. For a price history, regular and promotional prices answer different questions. Never average them together without a label.

• Use “regular” for an ordinary shelf price.
• Use “loyalty” for a discount that requires a membership.
• Use “coupon” for a targeted or clipped discount.
• Use “clearance” for a price unlikely to repeat.

Review four weeks without overclaiming

At the end of four weeks, count comparable observations, calculate the median unit price, and write down substitutions and promotions. Four observations can reveal a pattern worth checking; they cannot describe national inflation or forecast next month’s bill.

• Compare like with like before comparing stores.
• Keep missing observations visible instead of filling them with a guess.
• Review the basket when the product, package, or recipe changes.

Personal receipts are not CPI or HICP

The U.S. Bureau of Labor Statistics publishes average prices for selected items, the USDA Food Price Outlook explains its forecasting framework, and Eurostat documents the HICP methodology. These official measures use defined samples and methods. Your receipts show your household’s choices, stores, quantities, and timing.

Your next step: log the next four receipts

Choose ten repeat products, create five fields for each line (date, normalized name, quantity, unit price, promotion), and enter the next four receipts. At the end, circle one price change you can explain and one that needs another observation.