Analytics in the Barcode Scan App turns the inventory and logistics data in your Exact Online administration into concrete insights. You see how much money is tied up in your warehouse, which items have not moved for months, which orders are blocked by shortages and how reliably you and your suppliers deliver. No exports or spreadsheets are needed: the analyses use the data the app already synchronises with Exact Online.
Summary
- 17 analyses: 11 inventory analyses in the groups Value, Availability, Control and Reliability, and 6 logistics analyses for purchasing, goods receipts, sales, goods deliveries, inventory and shop orders.
- Subscription: Analytics is part of the advanced subscription.
- Period: choose 1 day, 1 week, 1 month or 1 year. Analyses that show the current state, such as stock value and the ABC analysis, do not use a period.
- Per warehouse: view the inventory analyses for all warehouses together or for a single warehouse.
- Per user: see who processes how many receipts, deliveries and work orders, per day or month and per hour of the day. See activity per user.
- Explanation on every screen: each inventory analysis explains what you see, how it is calculated and what you can do with it.
- No delay while scanning: figures are kept for up to 30 minutes. Dead stock, ABC analysis, days of cover and location usage are calculated every night.
Overview of all analyses
Each analysis answers one question about your warehouse:
| Analysis | Answers the question | Period |
|---|---|---|
| Stock value | How much money is in my warehouse, and in which warehouse and item group? | Current state |
| Dead stock | Which stock has not been delivered or consumed for 90, 180 or 365 days? | Current state |
| Shelf life | Which batches have expired or will expire soon? | Current state |
| Shortages & backorders | Which sales orders can I not deliver, and which item is blocking them? | Current state |
| Reorder point & maximum | Which items are below safety stock or the reorder point, or above the maximum? | Current state |
| Days of cover | How long will my current stock last? | Current state |
| ABC analysis | Which items matter most, by value, quantity or picks? | Last 12 months |
| Count accuracy | How accurate is my inventory? | Selected period |
| Location usage | How full are my storage locations and where is picking busiest? | Selected period |
| Delivery reliability (OTIF) | Do I deliver on time and in full to my customers? | Selected period |
| Supplier performance | Do my suppliers deliver on time and in full? | Selected period |
| Purchase order, Goods receipts, Sales order, Goods deliveries, Inventory, Shop order | How many orders, receipts and deliveries were processed, by whom and with what lead time? | Selected period |
How to open Analytics
Press the Analyze button in the main menu of the Barcode Scan App.

The menu button at the top left opens the analytics menu. There you choose a logistics analysis or one of the inventory analyses, grouped into Value, Availability, Control and Reliability.
At the top right you choose the period for the analysis: 1 day (1d), 1 week (1w), 1 month (1m) or 1 year (1y). For the inventory analyses you also choose the warehouse there. When an analysis shows the current state, you see Current state – period not applicable instead of the period buttons.

Each inventory analysis starts with an explanation in three parts: what you see, how it is calculated and what you can do with it. The Refresh button fetches the figures again immediately. Normally they are kept for 30 minutes so that scanning in the warehouse is not slowed down. Analyses with a nightly calculation show today’s changes the next day.
Inventory analyses: Value
How much money is tied up in your stock, and which part of it no longer earns anything?
Stock value
What you see: The total stock value, the number of items in stock and the number of items without a cost price. Below that the stock value per day, the value per warehouse, the value per item group (top 10) and the items with the highest stock value. The daily snapshot shows how the value develops.
How it is calculated: Stock × cost price. The app uses the cost price from Exact Online, otherwise the new cost price, otherwise the purchase price at the main supplier. Items without a cost price count with value 0. If Exact Online values stock at an average purchase price, the amount can differ from the balance sheet.
What you can do with it: See at a glance how much money is in the warehouse and where. Add missing cost prices in Exact Online and use the items with the highest value as a starting point for clearing dead stock and for cycle counts.
Dead stock
What you see: Items in stock that have not been delivered or consumed for some time, with their value. You choose the threshold: no movement for 90, 180 or 365 days.
How it is calculated: For each item the app looks at the last delivery or material issue on a shop order, across all warehouses. Items in stock without movement in the chosen period are dead stock. The analysis is calculated every night.
What you can do with it: Decide per item: discount, return to the supplier, move or write off. This frees up space and cash.
Shelf life
What you see: Batches that have expired or will expire soon, with their value, and blocked batches.
How it is calculated: Based on the batch numbers with available stock and an expiry date. Value = available quantity × cost price (cost price, new cost price or purchase price at the main supplier).
What you can do with it: Deliver batches that are about to expire first using FEFO, offer them at a discount or write off expired stock.
Inventory analyses: Availability
Can you deliver what your customers order, and for how long?
Shortages & backorders
What you see: Open sales orders that cannot be delivered, or not in full, and the items that block the most orders.
How it is calculated: With the Delivery availability check subscription the app counts order lines with pick status not or partially deliverable; stock is then fairly divided over the orders. Without that subscription it counts the lines whose open quantity is larger than the stock.
What you can do with it: Reorder the items that block the most orders first, and inform customers whose delivery date is at risk.
Reorder point & maximum
What you see: The number of items below safety stock, below the reorder point and above the maximum, the exceptions per warehouse and a list of items that need attention, with an order advice.
How it is calculated: Based on the settings per item and warehouse in Exact Online: safety stock, reorder point and maximum stock. Expected = stock + planned in − planned out.
What you can do with it: Order up to the maximum, or replenish with the Replenish screen. Stock above the maximum is money standing still.
Days of cover
What you see: How many days the current stock will last at average consumption: the number of items with less than 7 days of cover, with 7 to 30 days and without consumption, the distribution of all items over cover classes and the items with the lowest cover.
How it is calculated: Stock ÷ average consumption per day over the last 90 days. Consumption is the sum of deliveries and material issues, across all warehouses. The analysis is calculated every night.
What you can do with it: Items with less cover than your supplier’s lead time must be reordered now. Items with a very high number of days of cover may have been overbought.
Inventory analyses: Control
Where should you focus your attention in the warehouse?
ABC analysis
What you see: The classification of your items into A (the most important 80 %), B (the next 15 %) and C (the rest), with a Pareto chart of the items and their cumulative share, and the distribution of items over the classes.
How it is calculated: Over the last 12 months and across all warehouses. You choose the basis: Value (delivered value), Quantity (units delivered) or Picks (how often an item was picked). The analysis is calculated every night.
What you can do with it: Count A items more often, store them close to the packing area and manage their stock more tightly. C items can be stored further away and counted less often. The ABC analysis on picks is the basis for a shorter picking route.
Count accuracy
What you see: How accurate your inventory is: the share of count lines without a difference, the value of the differences and the items with the largest deviation.
How it is calculated: From the stock counts in the chosen period. The value of a difference = difference × cost price of the count line.
What you can do with it: Find the cause for items and locations that keep deviating: picked wrongly, not booked or the wrong unit. Count them more often. Read more about inventory discrepancies in Exact Online.
Location usage
What you see: How your storage locations are used: occupancy, the number of empty locations, items spread over more than 3 locations, and the locations with the most picks.
How it is calculated: A location is occupied when there is stock on it. Picks per location come from the delivery lines in the chosen period. A items follow from the ABC analysis on picks.
What you can do with it: Consolidate scattered stock with Move, and put A items on easily accessible locations close to the packing area.
Inventory analyses: Reliability
How reliably do you deliver, and how reliably do your suppliers deliver?
Delivery reliability (OTIF)
What you see: The percentage of sales order lines delivered on time and in full: On Time In Full (OTIF).
How it is calculated: For each order line the first delivery in the chosen period counts. On time = delivered on or before the requested delivery date. In full = the full quantity was delivered in that first delivery.
What you can do with it: For customers and items with a low score, find out where it goes wrong: stock that arrived too late (see Shortages & backorders) or orders processed too late in the warehouse.
Supplier performance
What you see: How reliably your suppliers deliver: on time, in full and with what average delay.
How it is calculated: For each purchase order line the first receipt in the chosen period, compared with the planned receipt date and the ordered quantity. Across all warehouses.
What you can do with it: Discuss the figures with suppliers who often deliver late or incomplete, or keep more safety stock for their items.
Logistics analyses
The logistics analyses show what happened in your warehouse in the chosen period: how many orders, receipts and deliveries were processed, by whom and with what lead time. Each topic starts with a statistics card and a chart with the number per day. Top 10 lists show the 10 highest values in the chosen period.
Purchase order
Press the Purchase order link in the analyze menu to analyze purchase orders.
Statistics
In the example above, 36 purchase orders were created in the selected period. Of these, 14 are still logistically open at the time of viewing. 10 of the purchase orders have already had a receipt but are not yet fully delivered. 12 orders have been fully received and completed. And in this example, no orders have been cancelled.
Most purchased products
This option shows the most ordered items over the selected period.
Purchase orders per supplier
Here you can see how many orders have been created per supplier in the selected period. This is a top 10.
Created by

In this top 10 you can see which people have created the most purchase orders in the selected period.
Goods receipts
Press the Goods receipts link in the analyze menu to analyze received goods from your suppliers.
Statistics
Deliveries per supplier
This shows the number of deliveries per supplier.
Most received items
These items have been received most frequently.
Created by

These people booked the most goods receipts in the selected period.
Number of receipt lines processed by

These people processed the most receipt lines.
Number of items received per person

These people received the most items.
Lead time
This overview shows the statistical data of the lead time of a purchase order. For example, what is the average lead time from the creation of a purchase order until a goods receipt is registered.
Sales order
Press the Sales order link in the analyze menu to analyze sales orders.
Statistics
In the selected period, 4 sales orders were created. Of these, no orders are still fully open. 3 sales orders have been partially fulfilled. An additional delivery is still needed to fully complete them. 1 sales order has been fully completed and no orders have been cancelled.
Best-selling products
These items have been sold the most in the selected period.
Sales orders per customer
This overview shows how many sales orders have been created per customer.
Created by

These people have created sales orders in the selected period.
Goods deliveries
Press the Goods deliveries link in the analyze menu to analyze goods delivered to your customers.
Statistics
The statistics card shows how many goods deliveries have been processed in the selected period. In this case, 10 goods deliveries were processed and they had a combined total of 10 lines.
Goods deliveries per customer

This card shows how many goods deliveries have been processed per customer.
Most delivered items
This card shows which items were delivered most often in the selected period.
Most goods deliveries created

This card shows who has completed goods deliveries in the selected period.
Most processed goods delivery lines

This card shows how many order lines have been completed per person.
Most items delivered per person

This card shows how many items have been delivered per person.
Lead time
This overview shows the statistical data of the lead time of a sales order. For example, what is the average lead time from the creation of a sales order until a goods delivery is registered.
Delivery date compared to the actual delivery
This overview shows a statistical view of the difference between the planned delivery date of a sales order line and the actual delivery of that order line. When the period is negative, the delivery was made earlier than agreed. When the period is positive, the delivery was made later than agreed.
Stock
Press the Stock link in the analyze menu to analyze the current inventory.
Statistics
The statistics card shows how the current stock is composed. The selected administration has 8 warehouses with a combined total of 815 storage locations. The number of items currently in stock is also displayed.
Number of items per warehouse
Which warehouse contains the most items.
Number of items per storage location
Which storage location contains the most items.
Number of picks per storage location
From which storage location are the most picks made when collecting sales orders. Is it convenient that the most picks happen at this location? Or would it perhaps be wise to place the stock from this location at a strategic location to reduce walking distance? This overview shows the number of picks, not the number of items.
Number of picked items per storage location
From which storage location are the most items collected when picking sales orders. Is it convenient that the most items come from this location? Or would it perhaps be wise to place the stock from this location at a strategic location to reduce walking distance? This overview shows the number of items.
Number of put-aways per storage location
Number of received items in the selected period that have been placed at these locations.
Number of placed items per storage location
This card shows the number of placed items per storage location in the selected period.
Lead time
How long does it take in the selected period for 1 item to be delivered to a customer.
Stock duration
How long can you continue with the current stock without reordering at the current sales rate.
Work order
Press the Work order link in the analyze menu to analyze work orders.
Statistics
The statistics card shows that 28 work orders were created in the selected period. Of these, 14 work orders are still open and have not yet been started. Additionally, 14 work orders are currently in progress. No work orders have had a receipt posted or have been fully completed yet.
Top 10 products with a work order
In the selected period, this card shows which items are produced the most with a work order.
Work orders created by

This card shows who has created work orders in the selected period.
Most issued items on a work order
This card shows the most issued items on a work order in the selected period.
Lead time of a work order
This is a statistical view of the lead time of a work order. How long does it take from the moment a work order is created until it is completed in the selected period. The selected period filters on the creation date of the work order.
Activity per user
The logistics analyses show per user how much work was processed and when. This shows you how busy the day is, who does which process and whether staffing matches the workload.
Goods receipts, Goods deliveries and Work order have two charts with a colour per user:
- Processed orders per user per day (for the period of a year: per month). Days without activity are also shown in the chart, so quiet days stand out.
- Processed orders per user by hour of the day (0 to 23, in local time). Here you see the peak hours in the warehouse.
Work order also has the top 10 cards Work orders: materials issued by and Work orders: finished by. If there are many users, the smaller ones are combined under Other users.
Frequently asked questions about Analytics
What can I analyse with the Barcode Scan App for Exact Online?
Analytics contains 17 analyses. Eleven inventory analyses: stock value, dead stock, shelf life, shortages & backorders, reorder point & maximum, days of cover, ABC analysis, count accuracy, location usage, delivery reliability (OTIF) and supplier performance. And six logistics analyses: purchase orders, goods receipts, sales orders, goods deliveries, inventory and shop orders.
Which subscription do I need for Analytics?
Analytics is part of the advanced subscription of the Barcode Scan App. You open it with the Analyze button in the main menu.
How do I make an ABC analysis of my inventory in Exact Online?
Open Analytics and choose ABC analysis in the Control group. The app classifies your items into A (the most important 80 %), B (the next 15 %) and C (the rest) over the last 12 months. You choose the basis: delivered value, quantity or number of picks. The analysis is calculated every night, so you do not need to export anything.
How do I find dead stock in Exact Online?
Choose the Dead stock analysis and set after how many days without movement an item counts as dead stock: 90, 180 or 365 days. You see the items in stock that were not delivered or consumed in that period, with their value.
How is the stock value calculated?
Stock value = stock × cost price. The app uses the cost price from Exact Online, otherwise the new cost price, otherwise the purchase price at the main supplier. Items without a cost price count with value 0. If Exact Online values stock at an average purchase price, the amount can differ from the balance sheet.
What are days of cover?
Days of cover is the number of days the current stock will last at average consumption. The app divides the stock by the average consumption per day over the last 90 days (deliveries and material issues). If the cover is shorter than your supplier’s lead time, you need to reorder now.
What does OTIF mean and how does the app measure it?
OTIF stands for On Time In Full: the percentage of order lines delivered on time and complete. The app looks at the first delivery of each sales order line. On time means delivered on or before the requested delivery date, in full means the complete quantity was delivered in that delivery.
Can I view the analyses per warehouse?
Yes. For the inventory analyses you choose All warehouses or one specific warehouse at the top right.
Why can I not choose a period for some analyses?
Analyses such as stock value, dead stock, reorder point & maximum, days of cover and the ABC analysis show the current state. They show Current state – period not applicable instead of the period buttons. For the other analyses you choose 1 day, 1 week, 1 month or 1 year.
Why do I not see today’s changes yet?
Figures are kept for up to 30 minutes so that scanning in the warehouse is not slowed down; the Refresh button fetches them again immediately. Dead stock, ABC analysis, days of cover and location usage use a nightly calculation: today’s changes appear there tomorrow.
Can I see how many orders each employee processes?
Yes. For Goods receipts, Goods deliveries and Work order you see the processed orders per user per day (or per month) and per hour of the day. For Work order you also see who issued materials and who finished work orders.