The Inventory Variance by Location report shows variances over time based on a variety of Inventory Transactions and entered Waste. Run this report to see if Inventory Variances are increasing or decreasing for one or more Locations. To view variances for a specific date range, run the Above Store Actual vs Theoretical report.
Running this report is not meant to replace but rather supplement the Actual versus Theoretical report as a high-level look at totals by store. The AvT report should still be used to dig into the detail by item in one specific Location.
How Modifier Rules Affect This Report
When Modifier Rules are enabled for your account, the theoretical usage and cost figures in this report reflect rule-based recipe resolution for each modifier combination, consistent with the Theoretical vs Actual Variance Report. Accounts that do not have Modifier Rules enabled see no change in how these figures are calculated.
Navigation
The My Reports search bar can be used to search R365's entire catalog of reports.
Open the Reports app.
Navigate to My Reports.
Enter all or part of the report name in the search bar.
The Results tab will open with the list of search results.
From beneath the report name, click Run to run the report with the selected report view.
-OR-
Click Customize to adjust the report parameters and run the report.
Report Parameters
Field/Column | Description |
|---|---|
Filter By | A list of all filter categories. Filter categories will vary based by report. |
Filter | Filter - Opens the Filter menu, where filters based on column values can be applied. When filters are applied, the number of conditions is displayed next to the button.
|
Start Date | The beginning date for the report. |
End Date | The end date for the report. |
Item Category 1–3 | The item categories 1–3 that can filter for specific items in the report. |
Waste Calculations | This will either show or hide waste calculations. |
Show Unapproved | This will either show or hide unapproved inventory counts. |
Run Button | This will run the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. |
Report Columns
Field/Column | Description |
|---|---|
Location | The restaurant or commissary location name. |
Begin (+) | The total dollar amount of the beginning inventory count. The quantity comes from the approved inventory count closest to the Start Date. The report searches up to 30 days before or after that date. The report calculates the dollar amount when it runs. It uses the item's current inventory cost for that location, not the cost recorded at the time of the count. |
AP (+) | The total dollar amount of AP transactions that had an effect on inventory. |
Comm Rcv (+) | The total dollar amount of commissary orders received. |
Actual Xfer (+) | The total net dollar amount of item transfers received or sent. |
Waste (+) | The total dollar amount of items wasted. |
End (-) | The total dollar amount of the ending inventory count. The quantity comes from the approved inventory count closest to the End Date. The report calculates the dollar amount when it runs. It uses the item's current inventory cost for that location, not the cost recorded at the time of the count. |
Usage | The actual dollar usage amount resulting from the preceding columns. |
Menu Sis (+) | The total dollar amount sold via menu mix. Menu items must be connected to recipes to be considered in this total. |
Comm Sis (+) | The total dollar amount sold via commissary sales (commissary locations only). |
Theo AR (+) | The total dollar amount sold on AR transactions that had an effect on inventory. |
Catering Sis (+) | The total dollar amount sold on catering transactions that had an effect on inventory. |
Usage | The total dollar amount of the preceding theoretical columns. |
Var | The variance between the actual usage and theoretical usage. |
Var % | The variance percentage between the actual usage and theoretical usage. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to send, export, or print this report.
FAQ
How is the "Var" column actually calculated?
Var is the difference between actual Usage (Begin + AP + Comm Rcv + Actual Xfer + Waste − End) and theoretical Usage (Menu Sls + Comm Sls + Theo AR + Catering Sls). See the Theoretical vs Actual Variance Report for more on how actual and theoretical usage are derived.
Should I use this report or the Actual vs Theoretical (AvT) report?
Use this report for a high-level look at whether variance is trending up or down by location over time. For a detailed, item-by-item breakdown at a single location, run the Above Store Actual vs Theoretical report instead — this report supplements it rather than replacing it.
What happens if I turn on "Show Unapproved"?
Enabling Show Unapproved includes inventory counts that haven't been approved yet in the variance calculation. This can shift the numbers for a location mid-count, so treat variance as preliminary until all counts for the period are approved.
What happens if I turn off "Waste Calculations"?
Turning off Waste Calculations removes wasted inventory documented in Waste Logs from the Usage total, which can make actual usage look lower than what physically left inventory. Leave this on for an accurate view of true variance.
Why does the Begin column not match my inventory count total, and why does it change between runs?
Begin and End use the counted quantity from the inventory count. They value it at the item's current inventory cost for that location when the report runs. If an item's cost has changed since the count date, the report's dollar amount differs from the total shown on the count in the Inventory app. The same parameters can also return a different amount on a later run. The counted quantity does not change. The report re-prices it at the current cost.
For the as-counted dollar value, use the approved count totals on the inventory count. Learn more about maintaining and updating item costs for each location.