Skip to main content
All CollectionsInventory reporting
A guide to stock reconciliation investigation
A guide to stock reconciliation investigation

Here is our guide to preparing to count, best practice for counting and what to look out for in the reconciliation report.

Alex Blythe avatar
Written by Alex Blythe
Updated over 8 months ago

Inventory count preparation

Invoices

It is important that all of your orders received in the period since your last stock count have been processed in Nory. Visit the orders tab to review open orders and process them as necessary.

In the invoices tab check the received on date. The received on date will determine which stock period the stock will be marked as delivered in.

As an example, if you are counting on a Monday morning before you open then you will need all of your invoices to have a received on date no later than Sunday's date.

Review your invoices to ensure that you are happy they accurately reflect the products that were delivered. It is good practice to mark your invoices as approved when you are happy they have been received correctly.

πŸ“– Learn more about Managing your invoices in Nory

Storage areas

Set up storage areas in Nory to streamline your counting experience. Add only the items you usually find in each storage area to make counting & stock reconciliation easier.

πŸ’‘ Take some time before you start to count to ensure your stock rooms are tidy this will save you time and errors during the counting process.

Label your counting options

Your inventory comes in all shapes and sizes. Use the labelling and counting options in the item setup to make it clear what should be counted in each line. For example a 700ml bottle of gin can be set up as ml to use in recipes but counted as 1 bottle,

and viewed in the report as bottles rather than in ml.

πŸ“– Lean more about Unit labels and reporting preferences

Counting your inventory

Use the Nory IM app

Nory is designed to remove the need for manual processes. Doing a manual count will increase the chances of making a mistake and also means you will need to calculate each stock value manually.

Opening a count

When opening a count you will have the choice to do a weekly or monthly count. A weekly count will look at the last weekly count and use the closing values from that count as your opening values in the next. A monthly count will use the last monthly count as its opening value.

πŸ’‘ If you make a mistake and open a count incorrectly you can still get the results you need by comparing any 2 completed counts.

πŸ“– Learn more about Comparing Inventory counts in Nory

Day start or day end?

You have the option to complete a count using day start or day end. This means Nory will consider all sales, stock movements and invoices received up until the day starts, or the day ends.

So if you are counting on a Sunday evening and your new stock period starts on Monday you will need to select day end. If you are counting on Monday morning before you open you will need day Start.

Share the load

Nory will save all of your count entries as you go and facilitates multiple people counting at once. Using storage areas when counting will help to identify in which area counting errors were made.

Count everything

If you don’t count something Nory will estimate the count based on sales and stock movement but nothing is as accurate as an actual count!

πŸ’‘If you do not have stock of an item you will need to enter a value of 0 to avoid an estimated value being created.

πŸ“– Learn more about - Counting stock in Nory

Reconciling your inventory count

The inventory reconciliation report that is created once you finish your count shows a lot of data and it can be difficult to know where to start your investigation. Here are our tips.

Start with Inventory insights

This view shows you a snapshot of your inventory results and can help point you in the right direction in terms of where to start your investigation.

Surplus

Start by checking your surplus amount. If you have a high surplus amount this is likely to be related to your orders and received invoices.

  • Check all orders have been received correctly.

    • If you are seeing a positive variance on items from the same supplier its likely that you have missed an order.

    • πŸ“– learn more about: Managing your invoices in Nory

  • Have you received inventory from another location that you haven't accepted through Nory? Check in the transfers tab

  • Are you seeing a positive variance on an item you have wasted? It could be a mistake with the wastage entry check in the waste tab. Was a case of wine wasted instead of a bottle?

  • Under portioning, if you are routinely seeing positive variances on the same items and you are sure the recipes are correct it's likely that the recipe is not being followed correctly.

Waste

Waste that you have entered into Nory is shown as accounted waste.

  • Review your waste entries to ensure that they are correct.

  • Review waste dates to ensure they fall within the stock period.

All other waste is shown as unaccounted. Review the top waste items box in the bottom right-hand corner of the screen to see which items account for the largest variances.

Reconciliation report

You can access the reconciliation report from the inventory insights screen or from a completed count.

Use the Variance is over box to see only variances over a certain amount. This will reduce the number of lines you are looking at allowing you to focus on investigating only the highest-value lines.

.

Common investigation scenarios

Missing sales

In the screenshot below there is a variance of -3.21 cases of Diet Coke. The stock was counted correctly but there were not sale of the item connected to a recipe in Nory, this is shown in the column POS sales.

Missing deliveries

In the screenshot below Diet Coke is up 2 cases. The closing count is correct, but there are no deliveries of this product. 2 cases were delivered but the received on date was not within the stock period.

πŸ’‘The same process could be followed for missing waste entries and transfers that have not been completed.

Miscounts

In the screenshot below there is a variance of -3.84 cases of Diet Coke the closing count looks low.

When the count was reviewed it looks as though the cases were counted in the line for each creating the variance.

Incorrect Recipes

In the screenshot below there is a positive variance of 16 loaves of gluten-free bread.

The deliveries are correct and the closing count has been checked. In the POS sales column, it shows that 18 loaves have been sold in the week. The team know this is not correct as they sell very few gluten-free options.

When looking at the item setup it was found that the loaves were set up as 1 each.

❗ Permission to edit inventory items is needed to access the inventory set up.

πŸ“– Learn more about Permissions in Nory

The recipe for gluten-free bread was for 2 each, assuming 2 slices of bread would be deleted. Instead two loaves were being deducted per order.

To rectify this problem the item was updated to 10 each (10 slices of bread per loaf).

Did this answer your question?