Discrepancy reports within Inventory allow you to compare your theoretical stock with the actual stock levels, reflecting your most recent stock counts. This report lets you see the amount and approximate value of each item you've purchased, used in recipes, wasted, or transferred during the selected time period.
Accessing Discrepancy reports
- Log in to Inventory with your Lightspeed credentials.
- From the navigation menu, select Reports > Discrepancy report.
- Select the start date and time for the period you wish to download.
- Select the end date and time for the period you wish to download.
- Click Download report.
Understanding Discrepancy reports
Discrepancy reports contain information on each item in your inventory. They allow you to dig into your stock and identify any potential issues. See the table below for a breakdown of each column.
| Column | Description |
| Item | The name of the Item as entered in Inventory. |
| Format | Size and container of the item. |
| Last Counted Date |
The date of the last time this item was counted in a stock count. |
| Accounting Group | Filter the information in this report based on your Accounting groups. |
| Statistic Group | Filter the information in this report based on your Statistic groups. |
| Opening Stock Level |
The stock level for the item closest to the opening time and date. |
| Opening Stock Value |
The estimated value for the item closest to the opening time and date. |
| Theoretical Stock Level | The stock level after all stock movements recorded for this item have been applied to the opening stock level. |
| Theoretical Stock Value | The estimated value after all stock movements recorded for this item have been applied to the opening stock level. |
| Last Counted |
The stock level for the item closest to the closing time and date. |
| Last Counted Value | The estimated value for the item closest to the closing time and date. |
| Variance Qty | The discrepancy in quantity for the item when comparing theoretical stock level and last counted estimated value. |
| Variance Value |
The discrepancy in estimated value for the item when comparing theoretical stock level and last counted estimated value. |
| Purchased Qty |
The total quantity of the item that was purchased within the selected time period. |
| Purchased Value | The total estimated value of the item that was purchased within the selected time period. |
| Consumed Qty | The total quantity of the item that was consumed in recipes during the selected time period, including batched and Made to order, and/or voided via the POS. |
| Consumed Value |
The total estimated value of the item that was consumed in recipes during the selected time period, including batched and Made to order, and/or voided via the POS. |
| Batch Yield Qty | The total quantity of the item that was produced from a batch during the selected time period. |
| Batch Yield Value | The total estimated value of the item that was produced from a batch during the selected time period. |
| Wasted Qty |
The total quantity of the item that was wasted during the selected time period. |
| Wasted Value |
The total estimated value of the item that was wasted during the selected time period. |
| Transferred Qty |
The total quantity of the item that was transferred to the selected location. |
| Transferred Value | The total estimated value of the item that was transferred to the selected location. |
| Transfers Received Qty | The total quantity of the item that was transferred to the selected location. |
| Transfers Received Value |
The total estimated value of the item that was transferred to the selected location. |
What's next?
Statistic Groups
Learn more about Statistic groups in Back Office, and how to use them.
Statistic groupsPurchase Reports
Learn more about Purchase reports in Inventory, and how they can help you track product and suppliers.
Purchase reports