Stock Overview Dashboard

 

Go to: File > Dashboard > Stock Overview

 

The Stock Overview Dashboard provides a real-time snapshot of inventory performance, stock risks, and valuation accuracy.

It allows management to immediately identify:

•Sales performance trends

•Pricing issues

•Overstock and understock risks

•Negative stock quantities

•Differences between stock valuation and the General Ledger

Key Metrics

Units Sold

Displays the number of units sold from the beginning of the current month to the current date.

Displays:

•Current Month-to-Date (MTD)

•Previous Month – same period

•Percentage increase or decrease

This helps identify changes in sales activity early in the month.

 

Average Selling Price

Displays the average selling price of stock items for the selected periods.

The dashboard shows:

•Current Month-to-Date average selling price

•Previous Month – same period

•Percentage variance

This can help identify changes in selling prices and potential pricing issues.

 

Items Sold Below Cost

Displays the number of stock items that have been sold below their cost price.

Click the Magnifier icon to view a detailed list of the affected items.

 

This can help identify:

 

•Incorrect selling prices

•Unauthorized discounts

•Margin leakage

 

Slow movers

Displays stock items where:

•Stock On Hand > 0

•More than 2 months of stock is available based on sales activity

•

Slow-moving stock ties up working capital and may require action such as:

•Discounting

•Promotions

•Purchase adjustments

 

Understocked

Displays stock items where:

•Less than 15 days of stock is available

•Average sales ≥ 0.5 units

•At least 1 unit sold last month

These items may be at risk of running out of stock, which can result in lost sales.

 

Negative Stock

Displays the total number of stock items that currently have a negative quantity on hand.

Negative stock can:

•Distort Cost of Sales

•Cause incorrect profit reporting

•Create differences between stock and General Ledger values

Best practice: If your business does not require negative stock, disable it under: Stock Items > Stock Options >General > disable Allow Negative Stock

 

Stock Value vs General Ledger Value

Compares the value of inventory in the Stock Module with the value recorded in the General Ledger.

 

The comparison is between:

•Inventory Book Value – Average Cost × QuantityInventory book value (Average Cost × Quantity)

•General Ledger Stock Control account value

 

If the two values differ, refer to the Stock Value Reconciliations Procedure to investigate and correct the difference.

 

Stock valuation discrepancies can directly affect:

•Gross Profit

•Income Statement accuracy

•Balance Sheet accuracy

 

Management Benefit

The Stock Overview Dashboard helps management to:

•Detect margin erosion early

•Identify potential stock-outs

•Reduce excess and slow-moving inventory

•Identify negative stock problems

•Protect working capital

•Maintain accurate stock and financial valuations