Purchased and Inventory Reports display the 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 Reports, click on the 'My Reports' Tab in the Operations module. When the main Reports screen opens, it will default to your 'Favorites', or any report that you previously starred. Hover over and click 'Purch. & Inv.' on the header; this will then display all of the Purchased and Inventory Reports.
Make one of these reports a favorite by clicking the Star icon to the left of the report name and it will be saved as a favorite in the 'Favorites' tab.
Security and Report Access
Purchased and Inventory Reports can be accessed by Users who have been given Report Roles by their system administrator.
If you aren't able to view these reports, it's most likely because you don't have security access. Speak with your system administrator to give you access to running or viewing these reports.
Reports
Actual vs Theoretical Analysis - Displays Actual vs Theoretical numbers in terms of both Quantity and Dollar Usage so that a User is able to see the details of each usage's efficiency. This report provides a well-rounded view to see how well the Actual Usage is compared to the Theoretical Usage.
Actual vs Theoretical Analysis Lite - Displays similar features to the Actual vs Theoretical Analysis, but does not include Waste Calculations, Efficiency Calculations, or the Actual Dollar Usage parameters in the final report calculations. This report provides more of a limited scope into the comparison between Actual and Theoretical Usages.
AP Invoice Distribution - Displays all purchases, which are sorted by Vendor and marked as paid or unpaid, for a selected date range.
COGS Allotment - Breaks down a Location's COGS by Operational Reporting Category for the selected period dates. This report is beneficial in comparing the COGS to a Location's budget.
COGS Analysis by Location - Runs the amounts of specified COGS Types for designated Locations over a selected date range. This report compliments the COGS Allotment Report because it provides further analysis into the COGS Types and the cost percentage of each item against its type budget amount.
COGS Analysis by Vendor - Runs the amounts of specified COGS Types for designated Vendors over a selected date range. This report compliments the COGS Allotment Report because it provides further analysis into the COGS Types and the cost of each item by specific Vendor.
Commissary On Hand - Tells a User how much product is on hand and the dollar amount associated with it. This can be beneficial in explaining how much a Location would need to prep to meet the demand of commissary orders.
Contract Violations - Displays any Vendor items outside of a Contract Price for a selected date range. This can allow the User to hold his/her Vendors accountable to the prices they are quoting.
Item Category Theoretical Variance - Shows trends of Total Variance Dollars per Category over a date range, broken down by Count-to-Count Calculations. This is helpful in pointing out high-level trends with categories due to loss (or gain) of items in that category.
Item Cost Analysis by Location - Shows total purchases over a selected date range of the report, but will break down these totals by COGS Category (from GL Accounts) per Location. This is a great report to check the total purchases on categories or individual items within those categories alongside other Locations' data.
Item Cost Percent Breakout - Shows the totals of all items purchased and the percent those items make up out 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 close eye on the top moving items.
Item Price Change Analysis - Shows the starting purchase price compared to the average purchase price over a given date range. This report will display the changes in product pricing from all Vendors connected to the selected Location, allowing a User to see the impact of the inconsistency in pricing.
Item Price Verification - 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 paying the lowest and the store paying the highest. This report is useful in holding Vendors accountable across the region that they are supplying.
Item Theoretical Cost Analysis - Displays the Count of Measure, Beginning Inventory, and the Cost Variance of a selected Purchased Item to show the Actual Cost against the Theoretical Cost. Assessing the Variance Cost and Percentage can then allow the User to pinpoint areas that needed to be analyzed further.
Item Theoretical Qty Analysis - Provides a detailed view into one specific item by displaying the Quantity and Theoretical Cost details associated with that item. This report can help a User dig into any changes in quantity of an item from one Stock Count to another.
Item Theoretical Variance - Drills into an Item Category to display individual items and total dollar variances of those items that make up the category. This report is a continuation of the Item Category Variance Report where the User is able to hone in on specific items that need to be further analyzed in the AvT Analysis Report.
Item Transfer Details - Shows all of the item transfers done over a selected period of time. This allows the User to view which stores are not ordering the right items or quantities of items.
Paid Invoice Distribution - Displays all of the invoices for a selected period of time for a specific Location. This report allows the User to view check details of paid invoices as well as the invoices that weren't paid yet.
Payables Invoice Distribution - Provides a closer look into the distribution of AP Invoices and the payments applied to them by GL Account.
Period Purchases Analysis by Vendor - Shows all of the purchases by Vendor for a specific period. This report allows the User to see which invoices are consistent and irregular to analyze the reasons for such changes.
PO to Invoice Reconciliation Report - Displays all of the purchased orders and invoices, including the items that were received. A User is able to use this report to see what items were ordered, what items were received, and what items haven't been received yet as well as the cost variance for each item listed.
Purchases by Vendor - Displays the purchases made by date range and for specific Locations. Invoices are linked to each purchase in this report to see the details associated with each purchase.
Receiving by Purchased Item - Displays all of the items received at a certain Location over a given period of time. This provides a clear idea of the buying history tied to each item.
Recipe Cost Breakout - Breaks down the cost of ingredients based on Item Category. This shows a quick representation of which Item Categories are the most costly / necessary based on the ingredients from all Recipes.
Stock Usage - Displays the Stock Usage for a particular Account and Stock Count.
Vendor Analysis - Focuses on a GL Account or range of GL Accounts to only show the distribution on AP Invoices and the Payments applied to them.
Waste Log Form - Provides a downloaded version of a Waste Log to use in keeping track of Waste during the day.