This article shows you how to use the "Prices report" in tspoonlab to monitor how your purchase prices evolve: find which ingredients have changed price most, for which ingredients a Cost Centre buys at a better or worse price than your other Cost Centres, which ones you receive at non-negotiated prices and on which delivery notes a discount hasn’t been applied, and compare the current price of each ingredient with each supplier. You’ll also see how to filter it and how to export each block to Excel.

This article is for managers and purchasing or cost control managers who negotiate with suppliers and review their prices in tspoonlab. You need a user profile with the "Reports" permission.

The "Prices report" in tspoonlab uses the prices on the delivery notes you receive. It helps you spot significant variations before they reach your recipe costings, find reception errors and discover room for improvement in your negotiations with suppliers.

To open the "Prices report" in tspoonlab:

The period of the "Prices report" in tspoonlab is chosen with the month and year, with "Show by week" or "Show by day" to group the data, and with the orange arrows to move to the previous or next period. This report doesn’t have the option to compare with another period.

Below the period dropdowns, the "Prices report" in tspoonlab has a row of filters. To choose the Cost Centres for the report:

As well as the Cost Centre, you can filter the "Prices report" by "Category..." and "Suppliers...".

The "Ingredients that have changed price most (purchases)" block of the "Prices report" in tspoonlab sorts ingredients by how much their purchase price has varied in the period. For each ingredient it shows the maximum, minimum and average prices, the initial and final prices, the quantity bought and the variation.

The variation compares the highest price with the lowest price of the period: (maximum price − minimum price) ÷ minimum price. Example:

To download the "Ingredients that have changed price most (purchases)" report, click the three dots at the top right of the block and select "Export report (XLSX)". This report shows Ingredient, Category, Maximum, minimum, average, initial and final prices, Quantity, Unit and Variation.

The "Ingredients bought at a better price" block of the "Prices report" in tspoonlab shows the ingredients that this Cost Centre has bought more cheaply than other Cost Centres in your account.

To download the "Ingredients bought at a better price" report, click the three dots at the top right of the block and select "Export report (XLSX)". This report shows Ingredient, Cost 1, Unit, Cost Centre, Cost 2, Percentage %.

The "Ingredients bought at a worse price" block of the "Prices report" in tspoonlab shows the ingredients that this Cost Centre has bought at a higher price than other Cost Centres in your account. It may point to a deviation or to the need to renegotiate this Cost Centre’s terms with the supplier.

To download the "Ingredients bought at a worse price" report, click the three dots at the top right of the block and select "Export report (XLSX)". This report shows Ingredient, Cost 1, Unit, Cost Centre, Cost 2, Percentage %.

The "Ingredients received at non-negotiated prices" block of the "Prices report"in tspoonlab shows the ingredients received at a price different from the one negotiated with the supplier. This block only includes suppliers with "Editable negotiated price": with "Negotiated price", tspoonlab forces the negotiated price on the delivery note and doesn’t accept any other price.

When you receive a purchase from a supplier with an editable negotiated price (blue tick) and the price doesn’t match, tspoonlab automatically generates an incident called "Ingredients received at non-negotiated prices".

To download the "Ingredients received at non-negotiated prices" report, click the three dots at the top right of the block and select "Export report (XLSX)". This report shows Ingredient, Cost Centre, Delivery note date, Supplier, Delivery note number, Incident, Theoretical cost and Price received.

The "Delivery notes where the discount hasn’t been applied" block of the "Prices report" in tspoonlab lists the delivery notes for the period on which a discount hasn’t been applied. This block only includes suppliers with a fixed discount on their Supplier Page, on delivery notes received without that discount.

When you receive a purchase without its discount from a supplier that has a fixed discount on the Supplier Page, tspoonlab automatically generates an incident called "Discounts not applied".

To download the "Delivery notes where the discount hasn’t been applied" report, click the three dots at the top right of the block and select "Export report (XLSX)". This report shows Delivery note number, Cost Centre, Delivery note date, Supplier, Incident and Amount.

The "Current supplier purchase prices" block of the "Prices report" in tspoonlabshows, for each item, the Cost Centre, the supplier that sells it, the date of its latest price and the "Cost" per unit. If an ingredient has several suppliers, they appear one below the other, so you can compare which supplier sells it to you most cheaply. You can click "More data..." to see the full list of ingredients and materials.

To download the "Current supplier purchase prices" report, click the three dots at the top right of the block and select "Export report (XLSX)". This report shows the ingredient, the Cost Centre, the supplier, the date, the unit and the cost.