Skip to main content

Valuation by Department

The Valuation by Department report displays inventory quantities and values by department for the selected audit period. It compares previous and current values to help review stock movement, valuation changes, and department performance between audits.

Written by Bernard Treacy

Steps:

1. Select “Reports”

2. Select “Valuation by Department”

3. Select the relevant “Period”

4. Review the report data:

- Department Name

- Previous Quantity

- Current Quantity

- Quantity Difference

- Previous Cost

- Current Cost

- Cost Difference

- Percentage Contribution

5. Review the Department Totals

6. Review the overall Grand Total

7. Use:

- Export to PDF to download a PDF version of the report

- Export to Excel to download the report in Excel format

Note:

• The report groups inventory values by department for the selected audit period.

• Quantity and Cost Difference values highlight increases or decreases between audit periods.

• Positive values are displayed in green and negative values in red to assist with variance identification.

• The Percentage column displays each department’s contribution to the total inventory valuation.

• Large variances may indicate stock movement, counting discrepancies, transfer activity, or purchasing fluctuations.

Did this answer your question?