Inventory valuation, any date, any warehouse
Reconstruct the exact value of your stock at month-end, year-end, or audit date, filtered by warehouse, location, category, and lot, then export straight to PDF or Excel.
The problem
Odoo's native stock valuation only shows today's number. Accountants and controllers closing the books need to know what inventory was worth on a specific past date, sliced by warehouse, location, category, and lot, with clean PDF and Excel evidence for auditors. Rebuilding that by hand from move history is slow and error-prone.
The solution
Generate a valuation snapshot for any date, in seconds. Filter by warehouse, location, category, lot/serial, and ownership, compare two dates side by side, then pivot, graph, and export the exact figures your auditors and management expect.
Everything a stock valuation report needs
Every capability below is implemented in the module.
Valuation On Any Date
Reconstruct the exact inventory value at any past date from done stock moves, valued at standard cost — built for month-end, year-end, and audit closing.
Multi-Date Comparison
Set a second comparison date on the same report to see quantity, value, and the difference side by side, without running two separate reports.
Full Filter Set
Filter by warehouse, stock location, product category, and product in a single report form, so every dimension you need is one screen, not scattered across apps.
Lot & Serial Valuation
Optionally group valuation lines by lot or serial number, with lot-specific standard cost applied automatically for lot-valuated products.
Owned vs. Non-Owned Goods
Exclude consignment and other third-party-owned stock from booked valuation with a single toggle, so reported value matches what your company actually owns.
On-Screen Pivot & Graph Analysis
Explore valuation lines in a pivot table or bar graph, grouped by category and date, before you export — no need to regenerate the report to change a view.
PDF & Excel Export
Print an audit-ready PDF or export a full Excel workbook of the same filtered data, including comparison columns when a second date is set.
Scheduled Monthly Generation
Enable a monthly scheduled action to generate valuation reports automatically, so month-end snapshots are ready without manual work.
Role-Based Access
Restrict who can view and generate valuation reports with dedicated User and Manager permission groups, keeping sensitive inventory value data controlled.
How it works
Set your date
Pick the valuation date (and an optional comparison date), then choose warehouses, locations, and categories to include.
Generate
Click Generate to build valuation lines from done stock moves as of that date, grouped by product, lot, or location as needed.
Analyze
Switch to the pivot or graph view to slice value by category, date, or location before deciding what to export.
Export
Print the PDF or download the Excel workbook, matching exactly what you see on screen.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
Yes. Set any valuation date and the report reconstructs value from done stock moves as of that date, not just the current live figure.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Stock Inventory Valuation Report
Generate point-in-time and historical stock valuation reports for any past date, filtered by warehouse, location, category, and lot/serial, then compare two dates side by side and export to PDF or Excel. Built for accountants, controllers, and warehouse managers who need audit-ready inventory valuation with on-screen pivot and graph analysis, consignment exclusion, and scheduled monthly generation.
Buy on Odoo App StoreMore Odoo inventory apps
Stock Variation Report
Opening, closing and variation by location alongside customer and sales variation under one filter panel — zero-variance rows suppressed, exported in several formats or emailed on a schedule.
Advanced Inventory Reports
Real-time inventory dashboards with a full stock-card ledger, aging analysis, and dead-stock detection — every KPI drills down to the moves behind it.
Advanced Scrap Move Report
Odoo's raw scrap ledger turned into a costed, filterable analytics dashboard with cost-by-category pivots, root-cause reason tags, and PDF/Excel/CSV export.
Average Landed Cost
A weighted-average landed cost per product, shown where you already work and broken down by vendor and PO, with an AVCO-versus-FIFO comparison, an analysis dashboard and a batch recompute wizard.
Catalog Pricelist Report
PDF and XLSX price catalogs built from real pricelist rules, with side-by-side pricelist comparison, quantity tiers, stock levels, barcodes and full transparency on which rule set each price.
Inventory ABC / XYZ / FSN Analysis
Three-axis ABC/XYZ/FSN classification resolved into a 9-cell guidance matrix, a per-SKU action plan, transparent risk scoring and dead-stock and overstock detection, with reclassification alerts and a KPI dashboard.