What You Will Learn In This Guide
How to generate and interpret an Inventory Wastage Report to track lost inventory.
About Inventory Wastage Report
Running a business means keeping costs low and profits high—but sometimes, things go to waste. Whether it’s expired ingredients, damaged goods, or overstock that can’t be sold, knowing what’s going to waste is key to making better inventory decisions.
That’s where the Inventory Wastage Report comes in.
This report helps you:
Identify items frequently going to waste
Track the quantity and cost of wasted stock
Understand how much potential revenue you’ve lost
With these insights, you can take action to reduce wastage, optimise stock orders, and protect your margins.
Note: This report currently does not support serialized products.
How to Track Wasted Inventory
Before you can view data in the Wastage Report, you’ll need to record wastage using Stock Take.
Here’s how:
1. In your BackOffice, go to the Stock Management tab and then click on Stock Take.
2. Click on Start Stock Take.
3. Input the actual quantity of your items.
The system will automatically calculate the difference between your system stock vs actual stock. Any negative differences (shortages) will be reflected as wastage in the report.
Note: To learn more about performing Stock Take, visit this article.
How To Access The Wastage Report
1. Go to Stock Management in your BackOffice.
2. Click on the Wastage Report tab.
Notes:
Due to backend data synchronization, the latest data in the Wastage Report will only be refreshed every hour.
For example, if you perform a stock take at 12pm, the wastage report will reflect the updated data at 1pm. Please keep this in mind when tracking your inventory wastage.
What You’ll See In The Report
The report provides a detailed breakdown of:
Product Name
Product SKU
Product Category
Quantity Wasted
Wastage Costs
Estimated Revenue Loss
Filter Options
To help you zoom in on specific data, you can filter the report by:
Store Name
Product Attributes (as mentioned above)
Note: You can save your preferred filters to make future checks even faster!
Exporting The Report
Need to share or analyse your wastage data? Click Download to export the report as a CSV file.
The exported file name will include the selected timeframe for easy reference.
Example:
File Name: Wastage Report_2024-11-26-2024-12-02
Indication: Data exported from 26th November 2024 to 2nd December 2024.
At the top of the report, you’ll see a quick summary that includes:
Total Quantity Wasted
Total Wastage Costs
Estimated Revenue Loss
These values will update automatically based on the filters and date range you select.