© 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal Quick Start Guide Document Details Document #: 160_QS1000_230221 Release Version: 10.00.00.00 Version Release Date: October 2022 System Requirements • CES Version 10.00.00 or higher Be sure to grab the latest version of this document here: https://links.crunchtime.com/NCQS-IdentifyIssuesWithBookingJournal OR by scanning the QR code to the left. Related User Group Permissions % Screen Name Control Name Description 93 NC-View Reports Actual/Theoretical Cost Report Enables this report on the Inventory Reports menu. [141][83]
2 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal How to Use the Booking Journal The Booking Journal is a powerful tool for chasing down inventory variances, or any other situation where you’re questioning quantities or values for a product. This report can help you fix both Inventory and Cost problems. It shows you every transaction for an individual product, or any change in its cost, for any time period you choose. It’s like spying on every movement of that product. Let’s say you did your inventory, and during your review you find that you’re short Chicken Breast. Your counts look good, so next, you want to see if there was a mistake when reconciling an order. Just open the Booking Journal as follows: 1. Open the Reports menu. 2. Select Inventory. 3. Then select Booking Journal. (Continued) Net-Chef > Reports: Inventory > Booking Journal
3 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal (Continued) How to Use the Booking Journal (Continued) We could find our product by scrolling through our list, but there could be pages of products to look through. Using the Filters lets us find the product we want more quickly. To locate the Chicken Breast: to zero in on transactions involving chicken breast 1. Select the Filters icon. 2. Enter ‘Chicken’ in the Product Name field. 3. Then select Apply. (Continued) Net-Chef > Reports: Inventory > Booking Journal
4 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal (Continued) How to Use the Booking Journal (Continued) To zero in on transactions involving Chicken Breast: 1. Select the Product Name link. 2. Next, choose the dates you want to review. 3. Then select Retrieve. Tip: The From Date selector is a drop-down where you must select the first day of a Post period. The To Date selector is a calendar control that lets you choose that day or any day after. (Continued) Net-Chef > Reports: Inventory > Booking Journal
5 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal (Continued) How to Use the Booking Journal (Continued) • The Transaction Type column shows you what events caused inventory levels to change. Selecting one of the links will open a screen showing the following key transaction details (see example on next page): − Quantity − Inventory/Unit Price − Total Cost/Value − Storage Location − Qualitative Judgment (for Inventory & Recipe Adjustments) • The Quantity In, Quantity Out, and Cumulative Quantity columns show much inventory has gone up or down, and how that impacts the running total of the product on-hand. • You can also see the Curreny Issue & Inventory Cost values here. • A large variance could indicate an incorrect count, an incorrect or missing transaction in Net-Chef, or an operational issue such as over portioning or even theft. (Continued) Net-Chef > Reports: Inventory > Booking Journal > Product Name link
6 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal (Continued) How to Use the Booking Journal (Continued) For example: 1. Select the Vendor Order link to see the order details. • We said we received 3 cases, when we really only got 2. That made the book value too high by 1 case (36 lbs) so when we count our inventory, we’d appear to be short chicken breast. Tip: In this case we could correct the vendor order or make a quick inventory adjustment to remove 1 case, and the problem would be solved! (Continued) Net-Chef > Reports: Inventory > Booking Journal > Product Name link
7 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal (Continued) How to Use the Booking Journal (Continued) The report not only lets you trace every single movement of an individual product, you can also see any cost changes. This can be handy when your inventory says you have a high value variance, but a quantity variance that’s not so high, which suggests maybe prices went up at some point. 1. To see the cost change details, select the View Cost Changes button. • As you can see here, when the 10/6 vendor order was reconciled the cost went up from $1.0975/lb to $1.1392/lb. (Continued) Net-Chef > Reports: Inventory > Booking Journal > Product Name link
8 © 2023 CrunchTime! Information Systems, Inc. All Rights Reserved. | www.crunchtime.com Identify Inventory Issues with the Booking Journal (Continued) How to Use the Booking Journal (Continued) To sum it up, you’ll be able to see the following transactions for any product you choose, along with all of the details: • Vendor Orders • Vendor Returns • Commissary/Customer Orders • Transfers • Inventory Adjustments • Recipe Adjustments • Daily Prep • POS Depletion • Buffet Consumption • Inventory Variance Adjustments Remember: In short, when you have an inventory or cost issue with a product, the Booking Journal lets you put that product’s movement and pricing under a microscope to see what’s causing the problem.