Loaded Reports Blog

Stocktaking 101 - For bars, restaurants and cafes.

Posted by Richard McLeod on Jun 5, 2018 2:52:21 PM
We've done our best to break the art (and joy) of stocktaking into easy to follow steps to ensure you get accuracy and the results you are looking for.

Get your stock organised!

Sounds easy, well this is actually the biggest roadblock to effective stock management. Disorganised and messy stock areas are a red flag for a high cost of goods for any hospitality business.

 

Wine stack

 

Here are some tips on how to get your stock super neat and tidy.

  • Make sure that you have a specific place for each stock item that is labelled and all of the staff are aware of this. It can be extremely difficult to count things that are spread out all over your site and aren’t in the same place every week.
  • Ensure that all fridges are re stocked each night. This helps because if you know that you can fit a certain number of bottles per row in a drinks fridge it becomes much faster to count. Ie Once you are confident a fridge is being correctly stocked each night, you can simply enter the total of all stock items in the fridge, without having to count every individual bottle.
  • Ensure you have a process so that only one box of each stock item is opened at any one time. It is much easier if you have full boxes to count. If you have the space a part box shelf is a good idea, and staff should always check this before opening a new box.
  • Do the same in the kitchen don’t open containers or packages before the previous full container or packet has been used. Try and have a section in chiller or fridges where part containers or packets are kept.
  • Try not to over order stock items it just means you have to count more.

 

Ensure all stock items are setup with the correct units.

It's really important that all of your stock items are setup correctly, both so the calculated amount of each item you should use is correct and so the amount of each stock item you count is accurately reflected when you produce a cost of goods report. Watch our video on Item Setup or see our Site Item unit best practice setup article.

 

Make sure all of your stock is being received correctly

You need to make sure all of your Stock Items have been received prior to starting the stocktake. If your received goods is not correct then there is no way that you will be able to get an accurate cost of goods value for the period of your stocktake report.

steam-whistle-delivery

If you want to make sure you're doing it 100% correct watch our video on ordering and receiving stock items here. An easy way to double check this is to check that there is no outstanding orders in the outstanding orders screen of your Loaded account.

 

Print a stocktake sheet and go around and start counting.

Ok, not to point out the obvious, but to correctly complete a stocktake you need to count your stock. We recommend that you complete your stocktakes weekly. If you complete them over a longer period than this, it becomes very difficult to troubleshoot when things go wrong. You and the rest of the team have a great ability to remember the last seven days, but any longer than this becomes a blur and troubleshooting issues on individual stock items become nigh on impossible.

Screen Shot 2018-05-23 at 1.49.17 pm

 

A good idea can be to have the stocktake completed on a Sunday night after the close of business, this means that you can have a separate person complete any recounts on the Monday morning which means an audit of some of the stock items is effectively completed.

  • Hit the ‘Stock’ tab at the top of your Loaded account
  • On the left hand side hit the ‘stocktake’ tab
  • Hit ‘create new stocktake’
  • A pop up screen comes up with all the system templates, choose the one you will be using. Choose either ‘All Food’ or ‘All Beverage’
  • Hit the ‘printer friendly version’ and print a copy of the form

Now go around and count everything, now you’ll see why it’s so important to have organised stock areas once you’re done go back to Loaded and;

  1. Enter your count on your stock take form
  2. Once entered hit the ‘Complete Stock’ button.
  3. It will ask you to enter the date
  4. Then hit the ‘save and review’ button this will highlight any potential stock variances on items


New call-to-action


 

Recount any suggested re-counts

Loaded automatically pulls out any stock items with a large variance and suggests that you recount them. Especially in your first few stock takes you will make counting errors so it’s important that you do recount the suggested items and update with the correct values if you discover you have made a mistake with your original count.

View the stocktake report

There are two main goals from a stocktake, the stocktake report should help you monitor these two KPI's.

iStock-522779418-987392-edited

 

1 - To understand on a regular basis the overall margin or cost of goods you are achieving.

Screen Shot 2018-05-23 at 1.56.06 pm

2 - To be able to ascertain on an item by item basis if you are using or losing more of an item than you expected to.

Screen Shot 2018-05-23 at 1.58.30 pm

 

Trouble Shooting Variances

Firstly you need to check variances on an item by item basis, and trouble shoot what is causing the variance. There are four main setup issues that may cause variances which you will need to check so that you can be confident the variance on each item is accurate.

  1. Counting
    1. Despite counting and recounting you might still have made an error. Triple check you've got the count correct and update your "completed stocktake".
  2. Received goods
    1. As pointed out earlier on in the article without having the correct received goods, the amount of each good you have used will not be accurate, and your overall cost of goods will not be correct. The Loaded stocktake report has a received column which shows how much of each item has been received, you can click on each received item to view the purchase order and check the received goods amount is correct. You can update this and save if neccesary
  3. Calculated usage
    1. POS Links - POS Links is how your calculated usage is created, if these aren't setup correctly your calculated usage and therefore your variance won't be correct. You can click on the calculated usage link for each item and it will show you each POS link and the amount that is decrementing each time a product is being sold on the POS.
    2. Recipes - If the recipes you have created do not accurately reflect the portion sizes of the recipes you are producing and plating then they will need to be updated.

Create a list of the items that had major Variances.

You need to understand the items that are costing your business money and then create a plan for doing something about it. This plan then needs to be communicated to your team and implemented.

One of our customers who runs a large pub fills out the following table after completing a stocktake each week and then places this in their team facebook page, they also then discuss this with their managers at their weekly management meeting. It is when you do something about reducing variance at an item level that your business will start saving money.

Item
 

 Want to see how Loaded can help your business?

SCHEDULE A FREE 15 MIN CHAT 


 

Topics: Inventory

Subscribe to Email Updates

Recent Posts