Skip to main content
All CollectionsReportsInventory Reports
Stock Movement Report (in Beta)
Stock Movement Report (in Beta)

Understanding and navigating stock values

Updated over a month ago

This Report is currently in Beta and only available to a few users. Stay tuned for more news and updates - we hope to make it available for everyone shortly!

How to Use the Stock Movement Report

The stock movement report is a powerful tool that allows you to track and analyze your inventory. It provides detailed information about your stock, including opening and closing values, as well as COGS (cost of goods sold) for purchased, sold, or adjusted items.

This report helps businesses track inventory levels, understand stock movements, and make informed decisions about purchasing and stock management.

Filtering the report

The stock movement report can be filtered by multiple criteria, such as product category, AAHA codes, and date range. This allows you to narrow down the report to specific items or time periods, making it easier to analyze your stock data. You can also combine multiple filters to get even more specific results.

stock movement report filters

Report Summary

At the top of the stock movement report, you will find a summary section that provides a quick overview of important stock totals. This includes the total value of your opening and closing stock, as well as the COGS (Cost of goods) for your purchases, sales, and adjustments.

stock movement summary

Adjusting Report Columns

The report table can also be adjusted to show or hide columns.

This allows you to customize the report to your specific needs. To adjust columns, simply click on Edit columns and select the columns you want to show or hide. You can also rearrange the order of the columns by dragging and dropping them in the table. Some columns can also be sorted in ascending or descending order.


Understanding the Report Table

The report table is a powerful tool that provides you with detailed product information. This information can help you analyze your sales and purchasing behavior, as well as track your stock levels accurately.

๐Ÿ“Œ This is an extensive report. You will need to scroll right to view all the columns

Product Information

The report table contains important product information such as product name, product category, AAHA codes, supplier information, unit cost, and selling price.

This information is essential for understanding your inventory and making informed decisions about your products. By having all this information in one place, you can easily analyze your sales and purchasing behavior by product category or AAHA code, as well as by supplier.

๐Ÿ“Œ A product may be listed more than once as the movement (stock changes) of each batch is reported separately.

stock movement product information

Opening and Closing Stock Value

The table reports on all products that have a quantity on hand at the beginning or end of the selected period, as well as any products that have stock movement within the selected period.

This provides you with an accurate opening and closing stock value, which is crucial for managing your inventory effectively and for financial reporting. With this information, you can ensure that you always have enough stock on hand to meet customer demand.

opening and closing stock values

Determine your NRV (Net Realizable Value)

NRV = Total Sales Price of the Closing Stock - Total COGS of the Purchases

Purchasing and Sales Totals

The purchasing section of the report table displays the total amount spent on each product during the selected period. These totals can be aligned with the values in the Purchase Order List, allowing you to track your purchasing activity and make informed decisions about future orders.

purchases and sales values

Purchase efficiently!

Purchasing more units of a product that you are selling?

Consider reducing your order size to just slightly over the demand. This will improve cashflow and optimize shelf space.

Selling more units of a product that you are buying?

Improve your purchasing by ordering enough stock in few orders. This will meet the demand and reduce admin time.

Similarly, the sales section provides you with the total product sales for the period. This information can be used to determine the service sales for the period, giving you a complete picture of your business's performance.

Formula:

Total Service Sales = Total Sales (from Sales Report) - Sold Units Price (from Sales section)

๐Ÿ“Œ Products sold as part of a Service, will not report any Sales Value as this is attributed to the Service.

Adjustment Section

The adjustment section of the report table displays any manual stock adjustments made during the selected period. These values can be used to determine stock loss or gain for the period, helping you identify any discrepancies in your inventory.

By keeping track of these adjustments, you can ensure the accuracy of your stock levels and make necessary adjustments to your inventory management processes.

adjustments values

๐Ÿ“ŒThe ability to export the report to CSV will allow further customized analysis.

What is a CSV file?

CSV is a widely compatible data file format which can be opened directly in Excel


Financial Benefits of Proper Inventory Management

Inventory management is not just about having adequate stock available to trade but can have a massive impact on the financial health of your business. This includes:

  1. Improve Cash Flow

    • avoid having too much capital invested in unsold stock

  2. Reduced Carrying Costs

    • minimize cost of shelf and storage space

  3. Increased Profitability

    • reduced costs by not buying excessively

    • improved sales as a result of better stock availability

  4. Accurate Sales Forecasting

    • improved financial planning

Other Benefits of Proper Inventory Management

Easily tracking and analyzing your inventory movement leads to valuable insights and other benefits as well. This includes:

  1. Informed Purchasing decisions

    • optimize stock levels by knowing seasonal trends and sales patterns

  2. Minimize Stockouts and Overstocks

    • less sales lost due to stockouts

    • avoid markdowns and waste that results from overstocking

  3. Enhance Customer Satisfaction

    • available stock of the right products affects customer loyalty

    • leads to repeat business

    • positive reviews, referrals and word-of mouth

Did this answer your question?