Price history
CostingBrik tracks every price change for every ingredient over time. This gives you a clear record of how costs have moved and helps you make informed decisions about suppliers, menu pricing, and purchasing.
How prices are tracked
Every time an ingredient's price is updated - whether manually or through invoice processing - Brikly records a timestamped entry with:
- The new price (cost per base unit).
- The date of the change.
- Where it came from: an invoice, a supplier added with its price, or a price changed by hand.
- The supplier associated with the price.
This creates a complete audit trail. You can always see what you were paying for an ingredient last week, last month, or last year.
Entries are added rather than rewritten, with two exceptions. Correcting or reprocessing an invoice line updates that line's own entry rather than adding a second one. And when you correct the shape of a supplier's pack and tell Brikly the saved shape was wrong, the earlier prices recorded for that pack are recalculated at the corrected cost per unit, with the pack prices you paid left untouched. That covers an ingredient's pack size (see Correcting a price by hand) and a consumable's item count (see What are consumables?).
Automatic updates from invoice processing
When you process a supplier invoice through Brikly, the system:
- Extracts the price for each line item.
- Calculates the cost per base unit from the pack size and pack price.
- Compares the new price with the price it replaces: the most recent earlier price for the same supplier product, from an invoice dated before it, from an invoice of the same date that arrived first, or a price you typed. A price from an invoice with no date is only used when nothing dated is on record.
- Adds an entry to the price history, and updates the current price where the invoice's date allows. An invoice older than the one your current price came from is kept as history only.
This happens automatically - you do not need to manually update prices after processing an invoice. Over time, your price history builds itself as you process invoices week after week.
Each invoice line that is costed keeps its own price-history entry, even when its price is unchanged or another invoice recorded the same price on the same day. Correcting or reprocessing that line updates its entry rather than adding a duplicate, and removing one invoice leaves the prices the others recorded in place.
Viewing price trends
To see the price history for an ingredient:
- Go to CostingBrik > Ingredients.
- Click on the ingredient name to open its detail page.
- In its Suppliers panel, click Price history.
The Price history drawer opens with:
- A Price trends chart showing price over time, making it easy to spot trends at a glance. Click the chart to open it larger.
- Filter by supplier or SKU, to show one supplier's product on its own.
- A list of every recorded price, with the supplier, the date, the price and where it came from: View invoice for an invoice price, otherwise Supplier added, Manual price change or Measurement update.
The drawer shows up to the latest 200 entries, and says so when there are more.
Notes on a price change
Months later, a big drop or jump in an ingredient's price can be hard to explain. Was it a clearance deal, a bulk buy or a new pack size? You can add a note to any price change that came from an invoice, so the reason stays with the price.
A note has two parts, and both are optional:
- A reason, picked from a short list: Clearance or deal, Bulk buy, Supplier price rise, Pack size change or Seasonal price.
- A short note in your own words, up to 280 characters.
To add one, click the note icon at the end of the entry in the Price history drawer. The icon always shows, faintly, on a change bigger than the alert threshold for the ingredient's category (5% unless you've changed it), since those are the changes most worth explaining. On smaller changes it appears when you hover over the entry, and always on a phone or tablet. On Home, rows of Price changes in the last 30 days for prices from an invoice have the same icon. There a saved note stays hidden until you want it: the icon turns blue, click it to show the note under the row (and again to hide it), and click the pencil at the end of the note to change it.
Choose a reason, type a note, or both, then click Save. The note shows as a line under the entry, with who added it and when. To change it, click the icon again. To remove it, click Remove note, or clear both parts and save.
A few things to know:
- Notes are for prices from invoices. A price you typed in by hand doesn't take a note.
- A note never changes your costing. A clearance or deal price still costs your recipes, because that's what you paid. The note just records why.
- When you dismiss a price change as a One-off purchase and add a note, that note is saved on the price change too (see Dismissing a price change).
- Owners, admins and members can add, change and remove notes. Viewers can see them.
- A note also shows on the recipe versions the price change recosted, so a recipe's version history says why its cost moved.
- If you've connected an AI assistant to Brikly, it sees the notes in an ingredient's price history as well.
What to look for
- Steady increases - a gradual upward trend may indicate general inflation on that product. Consider finding alternative suppliers or adjusting menu prices.
- Seasonal spikes - produce items often show predictable seasonal price swings. Asparagus and soft fruits spike outside their growing season. Use this data to plan seasonal menus around what is affordable.
- Sudden jumps - a sharp increase on a single invoice might be a one-off (e.g. a short-term shortage) or could signal a permanent price rise. Check with your supplier.
A 10p increase on an ingredient you use in every dish has a far bigger impact than a £1 increase on something you use once a week. Focus your attention on the ingredients you buy the most of.
Supplier price comparison
When an ingredient is supplied by more than one supplier, the Price trends chart shows each supplier's prices on the same chart. Where one supplier sells the ingredient as more than one product (for example a 6x500g case and a 12x1kg case), each of those SKUs gets its own line, labelled with the supplier name and the product, so you can compare what each pack size works out at per kilo or litre. This makes it straightforward to see:
- Which supplier is currently cheapest.
- Whether one supplier's prices are more stable than another's.
- When it might be worth switching your preferred supplier.
The Suppliers panel on the ingredient's page lists the active suppliers cheapest first, by cost per kilo, litre or item, so the best value sits at the top. See Comparing supplier prices.
Example:
| Supplier | Pack size | Pack price | Cost per kg |
|---|---|---|---|
| Metro Foods | 16kg sack | £12.80 | £0.80 |
| Bakery Supplies Ltd | 25kg sack | £21.25 | £0.85 |
| LocalMill Direct | 16kg sack | £11.52 | £0.72 |
In this case, LocalMill Direct offers the best price per kg - but if delivery is unreliable, you might prefer Metro Foods as your primary supplier with LocalMill as a backup.
Spotting price increases
You do not have to open each ingredient to find movement. Brikly surfaces it in three places:
- On the Ingredients list, the Price change column shows the last real change in price of your preferred supplier's product in the last 90 days, red and pointing up for an increase, green and pointing down for a drop. Repeat deliveries at the same price do not hide it. Hover for the date the price moved. If the product is re-entered in a different kind of unit (for example from each to weight), earlier prices in the old unit are not compared, so no arrow shows until the price moves in the new unit. Pending review appears underneath in amber whenever a price change is waiting on you.
- On the CostingBrik dashboard, the Ingredients stat card shows how many price changes are pending review and takes you straight to the queue on the Price change review page. The Needs attention panel lists them one by one with the supplier and the percentage, grouped by severity, so a 14% rise sits above a 2% one, and its All changes link opens the same page.
- On the invoice, the line item carries a Price change detected alert. You can confirm or dismiss a change here or on the Price change review page. An unreviewed change holds the invoice back from your accounting software until you confirm or dismiss it, unless you choose to send it with a few price changes still open (see Before you can submit).
How price changes get flagged
There is no per-ingredient threshold to configure. A price change is raised when an invoice line comes in more than a set percentage away from the price it replaces for the same supplier product (see Automatic updates from invoice processing), so you are never shown one supplier's price measured against another's.
That percentage is the Alert threshold on the ingredient's category, 5% unless you have changed it. Set it under CostingBrik > Ingredients > Manage categories, higher for volatile categories like Produce and lower for stable ones. See Ingredient categories.
A few things keep the noise down:
- Changes where both the old and the new pack price are under 2p are ignored as rounding. The check uses the price of the pack you buy, so on a big pack of small items (a case of 1,000 sachets, say) a real move in the pack price still raises a review even when each item costs less than 2p.
- Purchases from suppliers you have marked as one-off are recorded without raising a review, unless that supplier is the one your recipes cost from, and are never measured against another supplier's price.
- A change in the unit the supplier billed in is not a price change. Some wholesalers price the same product per tub on one invoice and per case of six on the next. Brikly reads the billed unit from the invoice where it is printed and costs the line per your saved pack either way, so a per-tub invoice does not show up as an 83% drop. When Brikly cannot tell which unit was billed, it asks on the invoice instead of guessing. See Reviewing line items.
For what the review shows you and how to confirm or dismiss it, see Reviewing line items.
Set aside time once a month to look at your price history properly. Sort your ingredients by the Price change column, check your top 20 by spend for any trends, and open the ones that have crept up. This 15-minute habit can save you thousands over a year by catching cost creep early.
Multi-currency prices
If you receive invoices in a different currency to your base currency (for example, EUR invoices when your account is set to GBP), Brikly automatically converts the prices at the exchange rate for the invoice date. In the price history, a converted entry also shows what one item cost in the invoice's currency (for example "from €2.10 EUR per item"). Hover over it to see the exchange rate used.
For full details, see Multi-currency invoices.