Monitor and compare orders with their deliveries to identify discrepancies and ensure seamless procurement accuracy.
The Goods Receipt Dashboard is an essential tool for procurement teams and business managers, enabling accurate tracking of the differences between what is ordered and what is received. It not only highlights discrepancies but also provides data to strengthen supplier relationships and effectively resolve delivery issues. Ensuring this accuracy is critical for maintaining an efficient procurement process.
Let’s take a moment to define these concepts and understand the meaning of the difference between:
- Ordered Value: The amount or monetary value of goods you requested from your suppliers.
- Received Value: The amount or monetary value of goods actually delivered by the supplier.
The difference between these two metrics is critical. It can be either:
- Positive: If more goods were delivered than ordered.
- Negative: If fewer goods were delivered than ordered.
Keeping track of these differences helps ensure accuracy in your procurement records and allows for better communication with suppliers about recurring issues.
To start using the Goods Receipt Dashboard, navigate to the Insights Hub and select Dashboards. From there, click on Goods Receipt in the Procurement section.
Filters
As in all Dashboards, you can set filters at the top left to customize the data displayed. You can filter by delivery or order timeframe, specify outlet(s), or focus on individual suppliers for tailored analysis.
Overview
This section helps you quickly identify discrepancies, understand their sources, and address issues that might affect your procurement efficiency.
- Ordered Value: The total monetary value of all goods that were ordered.
- Delivered Value: The total monetary value of all goods that were actually received.
- Goods Receipt Difference: The difference between the total ordered value and the delivered value, indicating any discrepancies.
- Ordered Value at Updated Prices: The total ordered value adjusted to reflect any changes in supplier pricing. For example, if you ordered 10 kilos of rice at 2€ per kilo and the supplier updated the price to 2.5€ per kilo, the total ordered value at updated prices would be 25€ instead of 20€.
- Difference from Price Updates: The monetary value variation, specifically caused by changes in supplier’s pricing. For instance, if you ordered a kilo of beef at 10€ per kilo and the price when received changed to 12€ per kilo, we will see a 2€ difference from Price Updates.
- Difference from Non-Delivered Items: The monetary value variation due to items that were ordered but not delivered (or delivered in excess). For example, if you ordered 5 cartons of milk at 3€ each, but only 3 cartons were delivered, the difference from non-delivered items would be 6€ (for the 2 missing cartons).
Graphs
The Goods Receipt Dashboard uses colour-coded bars to help you quickly see the breakdown of your deliveries. Each colour represents a specific part of the delivery performance: Green indicates the percentage of items delivered successfully (Delivered Value), Red shows the percentage of items not delivered or delivered in excess (Difference from Non-Delivered Items), and Cream represents the percentage of differences caused by price updates (Difference from Price Updates). These visualizations allow you to spot reliable suppliers and address any performance issues.
- Difference % of Ordered Value
This graph shows the breakdown of your total orders intodelivered value, missing items, excess items, and price differences.
- Difference % of Ordered Value by Supplier
This graph breaks down delivery performance for each supplier.
Exportable Tables
At the bottom of the dashboard, you’ll find the Exportable Tables section, which provides a detailed breakdown of your supplier deliveries. This is where you can dig deeper into the specifics of ordered and received values. This table enables efficient tracking and resolution of delivery issues. For instance, you can quickly spot recurring supplier errors or discrepancies that may be useful for supplier disputes or negotiations.
Delivery Value Difference Details
This table provides a detailed breakdown of all items with a difference between what was ordered and what was received. While some discrepancies may be due to items not being delivered, others could result from changes in pricing or over-deliveries. The table helps identify and understand these variances, allowing for more precise analysis and effective resolution of procurement issues.
To dive deeper, click a supplier’s name to view related purchase orders (POs). Select a specific PO to see its packages, and click on a package to view the Intake Reason (this is the "remark" you can see on the delivery page when receiving an order). This step-by-step breakdown helps you quickly identify and address delivery issues.
Tip: Like in other dashboards, graphs and tables can be exported as images or spreadsheets. This feature is especially useful for documenting data to share with your team or suppliers. You can find the export button by hovering over a chart and clicking the .