INVENTORY + RECONCILE
Identified best practices with Audits (counts) and reconciling are below.
Starting your counts:
1. Log into Craftable (App, iPad, Desktop).
2. On the left-hand side, select Inventory.
3. Click on Audits.
4. To start counting for the week, complete the below steps:
• Choose SUNDAY as the Audit Date.
• Select Start New Audit.
5. If you have already started counting and you have not closed the Audit yet, Select
Resume Audit.
6. The Historic Audit button is where you can view all closed audits.
Once you have opened a new Audit, you need to adjust your filters on the tool bar at the
top:
1. Storage: Inventory location.
2. Category: Sub-Category of storage.
• i.e) Storage could be "Bar Cooler 1" and the sub category is "Beer".
How to read an Audit:
1. Ignore the ID column.
2. Item: The item you are counting.
3. Bin: Exact location of each item.
4. The 4th column in is where you will see the location name, this is the column where
you input your counts. Click and type in your count.
5. CU Price: This is what we buy the product for.
6. Total: is the item from all locations added up.
7. Amount: is the total price of the item we have on hand.
How to close an Audit:
1. Once you are done counting and you are ready to close, select Close Audit in the top
corner.
2. A summary will pop up for you to review.
3. When closing the Audit, there is a difference between how to close it out for Beverager
vs Foodager:
• Foodager = Total
• Beverager = Category
Everything you need to know with you Audit, Counts, Reconciling, and
Troubleshooting is listed below.
After you have closed the Audit, you need to go look at two reports:
1. On the left-hand side, go to the Reports tab.
2. Click on Reports Lists.
3. Click on the Report: Cost Summary by Ops Group.
• In the tool bar at the top change from Net Sales to GROSS SALES, select Go.
• At the bottom right-hand corner is your COGS %.
• For food make sure you are in Foodager / For LBW make sure you are in
Beverager.
• If you open up the drop down arrow in the Food row under All Categories you will
see each category and your starting inventory, purchases, and ending inventory.
4. The second Report you want to view is: Actual vs. Theoretical Quantity Details:
• Change the Item Type to "Items + Prep" in the tool bar across the top.
• The entire report is filterable by selecting the title of the column that you want to
view.
• i.e) I want to view the report by Variance. Click on the Variance title in the
variance column. This will pull the report to go from largest to smallest
variance.
Troubleshooting:
1. Purchases are off: Do your packet to see if you have a missing invoice.
2. If purchases are fine, then there is something off with your starting/ending inventory.
• Look at your Actual vs. Theoretical Quantity Details report.
Pro Tip for trouble shooting:
1. Open up the Cost Summary by Ops Group report and expand All Categories.
2. Review to catch any discrepancies by category.
3. Now go to the Actual vs. Theoretical Quantity Details report.
4. Look at the category that had the discrepancy in.
5. Scroll over to the last column and select the header to filter.
6. Click on the item to dive deeper into troubleshooting.
• i.e) I saw on my Cost Summary by Ops Group that Dairy is at a 4.75% and
normally it is at a 3.75%. Going to look at my Actual vs. Theoretical Quantity
Details report, I know I can use the filter on the tool bar at the top to only look at
Dairy. Then I can look at the last column (Variance Value) and click on the title
(Variance Value) and it will filter my report to largest to smallest variance value
by item.