Purchased and Inventory Reports

Purchased and Inventory Reports display a breakdown of item costs, cost percentages, and much more. These reports can help a user analyze cost variances to help minimize inconsistencies and maximize item usage. Navigation To access My Report...

The Above-Store Actual vs. Theoretical Analysis compares the theoretical cost of certain inventory items or categories against actual data. The report pulls data for selected dates to provide an overall view of the category or item's actual vs....

The Actual vs Theoretical Analysis compares the theoretical cost of certain inventory items or categories against actual data, in terms of both quantities and dollar amounts. The user can drill down into the transactions that make up the num...

The AP Invoice Distribution Report displays all purchases, which are sorted by vendor and marked as paid or unpaid, for the selected date range. This report will display the payment details made for each invoice, including the posting date, accou...

The COGS Allotment Report breaks down a Location's COGS by Operational Reports Category for the dates in a specified calendar period. This report is beneficial to analyze the details of one period's COGS in comparison to that Location's budget al...

The COGS Analysis by Location Report runs the amounts of specified COGS types for designated Locations over a selected period of time. This report compliments the COGS Allotment Report because it provides further analysis into the COGS Types and ...

The COGS Analysis by Vendor Report runs the amounts of specified COGS types for designated Vendors over a selected period of time. This report compliments the COGS Allotment Report because it provides further analysis into the COGS Types and the ...

The Contract Violations Report will show any items outside of the Contract Price for the selected date range. Contract Prices can be maintained via the Vendor Item by either direct edit or import template. Vendors are listed separately and any it...

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 vari...

The Item Cost Analysis by Location Report shows total purchases over the date range of the report that are broken out by COGS Category per Location. Hyperlinked items enable a User to drill into the report to review the current cost and recent tr...

The Item Cost Percent Breakout Report shows the totals of all items purchased and the percent that item makes up of total COGS in a selected date range. This report is used primarily to identify which items to flag as key items and to keep a clos...

The Item Price Change Analysis Report shows the purchase price as of the start date of the report versus the average purchase price over the date range of the report. It also shows the COGS Usage over the same date range and the COGS impact the h...

The Item Price Verification Report runs the average price paid for each item in a selected date range per store and then aggregates those averages into lows and highs across all stores to show the variance between the store that is paying the l...

The Item Transfer Details Report allows the User to see all the item transfers done over a specific period of time. This report is extremely beneficial in drilling into an item transfer to see relevant details including the restaurant Locations t...

The Paid Invoice Distribution Report allows the User to see all invoices for a specific period of time for a chosen Location. This report is broken down by GL Account and shows check details, including the check number and date. If an accoun...

The Payables Invoice Distribution focuses on the distribution of specified GL accounts within AP invoices and the payments applied to them. Since payments in R365 are applied at the invoice level, they will be distributed on a weighted average ...

The Period Purchases Analysis by Vendor shows all of the purchases by Vendor for a particular period. This report allows the User to see which invoices are consistent and irregular to aid in analyzing the reasons for such changes. Navigat...

The PO to Invoice Reconciliation Report shows all the purchased orders and invoices and the items that were received. This report also notes the POS that hasn't been received yet as well as the cost variance for each item listed. Viewing this c...

The Purchased by Vendor Report shows the purchases made by date and for specified Location(s). This report allows a User to drill into the report by having all invoices linked to each purchase. Navigation To navigate to the Purchases ...

The Receiving by Purchased Item Report displays all the items received by a certain Location over a period of time. This report can be helpful in seeing the information tied to a Purchased Item sorted by Item Categories. To learn more about the ...

The Stock Usage Report displays the inventory usage for a particular account and Inventory Count. This can be beneficial in comparing Inventory Counts to see a trend and help forecast future item orders. Navigation To navigate to the S...

The Theoretical On Hand Report tells a User how much product is on hand as of the selected date. The report will pull the most recent count up to 90 days before the provided date and will calculate the changes in Inventory based off Sales, Purc...

The Vendor Analysis report primarily focuses on a GL Account or range of GL Accounts to only show the distribution on AP Invoices and the Payments applied to them. Since payments in R365 are applied at the invoice level, the payment will need t...

The Waste History report lists all Waste Logs and Donations that were approved within a selected date range. This can be a helpful reference to see the impact of wasted and donated items in Inventory for one or more Locations. Nav...

The Waste Log Form allows Users to download a Waste Log for their restaurant Location. This form is beneficial in keeping track of waste that can then be imported by a Manager later on. Navigation To navigate to the Waste Log Form, cli...

The Weighted Average is an optional Costing Method that can be chosen on the Above-Store Actual vs Theoretical Analysis report and is a more advanced Costing Method used for calculating Inventory Costs due to the fact that it considers quantity...

The Donations Form allows Users to download a Donations Log for their restaurant Location. This form is beneficial in keeping track of Donations that can then be imported by a Manager later on. Navigation To navigate to the Donations F...

The Inventory Stock Count Detail generates inventory counts for the selected locations and dates, based on the configured Inventory Template . Navigation In the Reports section of the left navigation pane, select My Reports . The My Report...

Similar to the Actual vs Theoretical Analysis, the Food Variance Report shows actual vs theoretical numbers in terms of both quantities and dollars. In addition to the actual vs. theoretical variance, the Food Variance Report also features additi...

The  Profit and Loss  statement and the  Actual vs Theoretical Analysis  report are not intended to tie back to each other, but even further, the amounts on these reports may have a bigger variance due to the following reasons:&n...

The actual vs theoretical analysis report can be used as several reports in one to troubleshoot why variances are happening with raw ingredients. Before diving into specifics, it’s best to cover the basics as to why variances happen in the first pla...