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.
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.
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.
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.
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.
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.
๐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:
Improve Cash Flow
avoid having too much capital invested in unsold stock
Reduced Carrying Costs
minimize cost of shelf and storage space
Increased Profitability
reduced costs by not buying excessively
improved sales as a result of better stock availability
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:
Informed Purchasing decisions
optimize stock levels by knowing seasonal trends and sales patterns
Minimize Stockouts and Overstocks
less sales lost due to stockouts
avoid markdowns and waste that results from overstocking
Enhance Customer Satisfaction
available stock of the right products affects customer loyalty
leads to repeat business
positive reviews, referrals and word-of mouth