Inventory Analysis - Period End Adjustments

Entering Inventory Adjustments for day to day things like waste and spoilage is a vital task to keeping your FlexiBake inventory numbers accurate, but it's also a good idea to do regular cycle counts to make sure that nothing is being missed. We recommend doing these cycle counts roughly once a month, and marking the IA slip for these counts as a Period-End adjustment. Doing so will allow you to take advantage of the Inventory Analysis tool, where you can compare inventory levels and values for multiple counts against each other to quickly find trends and issues.

To ensure the proper items and adjustment records are present in Inventory Analysis, please check your Products and Recipes are marked as Inventory Items, and the IA Slips you are considering have been checked off as Period End Adjustment Slips.

1. To begin, navigate to the Inventory Centre, and click into Inventory Analysis.
   
   
   
   
2. You'll be taken to the Inventory Analysis interface! The first order of business here is to select your Inventory Type from the Type dropdown.
   
   
   
   
3. Next, you'll want to select your desired Period-End Inventory Adjustments from the various dropdowns labelled Period. You can compare up to 3 different Period-Ends at once. For the grid area to populate, you'll need to specify at least 2.
   
   
   
   
4. Once your relevant Period-Ends are selected, you'll be able to compare the Quantity, Unit Cost, and Value of each Inventory Item listed between the two periods. You can compare by examining the columns of each kind between both selected Periods, or reading off of the Differences column, furthest to the right.
   
   
   
   
   • Checking off Display Price Detail includes columns which break down Ingredient, Packaging and Labour costs in each Period.
     
     
     
     
   • Checking Hide Zero Value Items will cause the grid to hide Inventory items not included / altered in any of the selected Period-Ends.
     
     
     
     
5. You have the option to Print or Export the grid area as it appears by clicking the relevant buttons in the top-left of the interface.