Stock Value Vs Sales Report
The Stock Value vs Sales Report is used to review Sales, Gross Profit, Purchases, Inventory Values or Stock Turns. This report is split into three sections (Sales, Stock Value and Purchase Orders) and includes:
- Purchase Orders (PO)
- Sales and Stock Value information
- Current Stock Value
- Value of Sales
- Value of Purchase Orders
Note: Data presented in the Stock Value vs Sales report is current at the time of running the report. This report is unable to provide data from a historical point in time.
The Report can be grouped by Product Type or Outlet and is designed to provide summary information. It can be used in conjunction with the Sales Report to review detailed transaction information.
Using the Stock Value vs Sales Report
To use the report:
- Navigate to Reports > Stock Reports > Stock Value vs Sales Report
- Update the Filters as required (see below for detailed information)
Click to view full size - Click Search
- The report results will be displayed, broken up into different sections indicated by the headings at the top (Sales etc)
- To export the report click the Excel or CSV icons in the top right-hand corner of the table
Tip: You may need to scroll across to view these buttons
Filters
Most of the filters are self-explanatory, however, see the detailed information below for the more advanced filtering explanations.
| Filter | Details |
| Group By | Used to select how the report results should be grouped, either by Product Type, Outlet or Supplier |
| Exclude below zero stock units |
Used to exclude products that are in a negative stock quantity e.g. if using miscellaneous products, or have products dedicated for services (these types of products are typically sold into negatives). Important: Products with a negative quantity will detract from your inventory valuation when included in this report. |
| Sales Dates and PO Dates |
Used to filter the Sales and Purchase Orders Made Available section of the report only. These fields do not impact Current Stock results and can be ignored if you only wish to review the Current Stock Inventory Valuation. |
| Outlet |
Used to filter the results to specific Outlets only. Tip: this is useful for reviewing how much stock is held in each location, and can be combined with the Group Results By Outlet option. |
Reconciling Values
The Stock Value Vs Sales report can be reconciled against the Item Detail Export should you need to see the item-by-item breakdown.
As with many reports, it’s important to be consistent with the inventory statuses used to calculate the stock value. Some reports, including the Stock Value vs Sales report, allow you to select which status, or provide a breakdown of each within the report so you can provide your own manual calculations.
Default Stock Value fields in the Stock Value vs Sales Report
Break down of the individual status within Item Detail Export
Frequently Asked Questions
The sales values reported in the Stock Value vs Sales Report won't necessarily equal the sales values of the Sales Report. The results of these reports cannot be compared to each other, as the filtering works differently when applied to each report.
Example:
- You sold 1 x T-Shirt for $20, and 1 x Chair for $100 on a single invoice.
- The Order total equals $120.
In the Sales Report, an applied filter of 'Chairs' will display a sales value of $120 - because the total order contains a chair.
In the Stock Value vs Sales Report, an applied filter of 'Chairs' will display a sales value of $100 - because it exclusively shows the sales values of chairs, and NOT other products included on the same invoice.
The columns in the Current Stock section of the report use the following data:
| Column | Details |
| Current Value POS Ex Price | Current stock value calculated from your POS sell price, Ex GST |
| Current Value Buy Ex | Current stock value calculated from your Buy Price, Ex GST |
| Current Value Direct Costs | Current value of direct costs |
| Current Value COGS | Current stock value calculated from Buy Price Ex + Direct Costs (COGS is Cost of Goods Sold) |
| COGS % of Total | % value of COGS (Cost of Goods Sold) compared with other Product Types/Outlets |
| Current units | Current Units for each Product Type/Outlet |
| Current Avg Unit Value | Average unit value for each Product Type/Outlet |