The Product Margin Analysis Report provides a product-level profitability and inventory margin analysis view within TUHUND.

The report is designed to help organisations evaluate inventory profitability by comparing opening stock, inward movement, outward movement and closing stock values against calculated margin and profit metrics.

The report supports configurable valuation methods, inventory filtering and profitability-based sorting to enable operational and financial inventory analysis.

The report can be accessed through:

Inventory → Reports → Margin Analysis

---

 

Purpose of the Report

The report is used to analyse product profitability, monitor inventory margins and evaluate stock movement performance using cost, value and selling-price-based calculations.

It is commonly used by inventory teams, finance teams, warehouse managers and management personnel for profitability analysis and inventory valuation review.

---

 

Report Interface

The report interface contains the following sections:

The ENTIRE ORGANIZATION selector functions similarly to other reports and allows users to generate profitability reports across accessible organisations, companies or branches.

---

 

Filtering and Calculation Options

The Show selector supports:

• Show All

• Changed Products

• Sold Products

• Unsold Products

The record selector supports:

• All Records

• Only Products

• Only Spares & Accessories

The Base Calculation selector controls how valuation calculations are performed and supports:

• Higher Of The Two

• Financial Value

• Actual Cost

The system may calculate values using the higher value between actual inventory cost and financial valuation depending on the selected configuration.

The Store selector allows users to filter inventory records across operational locations such as sales stores, warehouses, internal reserves, bonded warehouses and stock-in-transit locations.

---

 

Sorting Options

The Sort By selector supports multiple profitability, valuation and inventory movement parameters such as margin, profit, product details, opening and closing values, stock movement quantities and sold price.

These options allow users to analyse inventory profitability and stock performance using different operational and financial perspectives.

---

 

Report Structure

The report is displayed as a structured profitability and inventory valuation analysis grid where each row represents a product or inventory item.

Depending on the selected configuration, the report may display product details, inventory movement quantities, opening and closing balances, valuation figures, margin values and profitability percentages. Opening, input, output and closing values are dynamically calculated using the selected valuation method and inventory movement records.

The report also supports page-level profitability totals and consolidated valuation summaries.

---

 

Inventory Valuation and Costing Information

Inventory reports within the system may support multiple valuation and costing representations depending on the report type and configuration.

Value represents the exact inventory transaction value associated with the item movement.

Cost represents the inventory value along with additional operational expenses such as delivery charges, repair expenses, commissions or related operational costs.

Selling price represents the potential selling value calculated using configured costing structures and pricing sheets.

---

 

Store and Warehouse Visibility

The report supports inventory analysis across multiple operational storage structures including Sales Stores, Local Stores, Warehouses / Godowns, Internal Consumption Reserve, Bonded Warehouse, Overseas Stock In Transit, Domestic Stock In Transit

This enables organisations to analyse profitability across different inventory holding locations and operational stock categories.

---

 

Export Functionality

The Export button exports the currently displayed profitability analysis data in Microsoft Excel (.xlsx) format.

The exported report reflects the selected filters, valuation configuration, store visibility and reporting period.

---

 

Drilldown Behaviour

The report supports product-level drilldown functionality.

Product names displayed within the report are clickable and open a detailed margin analysis view for the selected product. The detailed view displays input and output transaction information, quantity movement, cost price, total cost, selling price, amount, margin values and profit percentages for the selected inventory item.

Input and output transaction references such as record IDs are also displayed within the drilldown view. Clicking these IDs copies the corresponding record reference to the clipboard.

---

 

Data Representation

The report supports inventory profitability analysis, stock valuation visibility, inventory movement tracking and margin-based product performance analysis across products, brands and operational stores.

Displayed information varies depending on the selected filters, calculation basis, store configuration and reporting period. Where no data exists, corresponding fields may remain empty, display zero values or show NA indicators.

---

 

Summary

The Product Margin Analysis Report provides a consolidated inventory profitability and valuation analysis view within TUHUND.

By combining inventory movement visibility, configurable valuation structures, profitability calculations, margin analysis and operational store-level filtering, the report enables organisations to evaluate product profitability, monitor inventory performance and analyse stock valuation trends across products, vendors and inventory locations.