Odoo Inventory Module · Stock Management
Stock Ledger Report
A line-by-line history of every stock movement, incoming, outgoing, and running balance, giving you full warehouse visibility at any point in time.
1 Click
To open a full product ledger
2–5 Days
Of custom development
effort saved
100%
Verified movements only
(Done state)
AUDIT-READY LEDGER
COMMUNITY & ENTERPRISE
ZERO SETUP REQUIRED
Trusted Partners
More Than 150+ Brands
In accounting, a ledger shows every transaction affecting a balance, debit, credit, and running total. A stock ledger applies the same principle to your warehouse inventory. Every goods receipt, every delivery, every internal transfer gets its own row, along with a cumulative balance that updates after each movement.
Odoo's standard inventory module gives you current stock levels and basic move reports, but it doesn't give you the full chronological, line-by-line ledger view that auditors, warehouse managers, and business owners need for real inventory control. That's the gap this module fills.
The Daily Odoo Stock Ledger Report module by Ahex Technologies adds a dedicated Inventory → Reporting → Stock Ledger menu that generates a clean, date-filtered report for any product, with opening balance, every in and OUT movement, and a running balance column throughout.
Complete Movement History
Every stock move in your date range, in chronological order.
Automatic Opening Balance
Opening stock calculated from all prior movements automatically.
Colour-Coded IN / OUT
Green for incoming, red for outgoing, scannable at a glance.
Running Balance Column
Balance recalculates after every transaction automatically.
Source & Destination Tracking
See where stock moved from and to on every single line.
Smart Date Range Wizard
Pre-filled last month. Adjust dates, hit Generate, done.
Below is an example of the Stock Ledger Report output for a single product. Each row is one completed stock movement. The balance column is cumulative, it never resets within the report period.
| Date | From | To | IN | OUT | Balance |
|---|---|---|---|---|---|
| Opening Balance | — | — | — | — | 100 units |
| 01 Apr 2025 | Suppliers | WH/Stock | +50 | — | 150 units |
| 05 Apr 2025 | WH/Stock | Customers | — | −30 | 120 units |
| 12 Apr 2025 | WH/Stock | Customers | — | −80 | 40 units |
| 28 Apr 2025 | Suppliers | WH/Stock | +20 | — | 60 units |
This format is familiar to anyone who has used a bank statement, and that familiarity is intentional. Stock reconciliation, audit preparation, and discrepancy investigation all become dramatically faster when data is presented this way.
1 of 7
Manufacturing Companies
Manufacturing companies tracking raw material consumption per production batch and reconciling theoretical vs. actual usage.
Think of it like a bank statement for your warehouse stock — each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
2 of 7
Retail and wholesale distributors
Retail and wholesale distributors needing to audit stock movement between warehouse, shop floor, and delivery, especially for high-value SKUs.
Think of it like a bank statement for your warehouse stock — each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
3 of 7
Pharma and healthcare distributors
Pharma and healthcare distributors maintaining regulatory-compliant inventory records for audits and compliance inspections.
Think of it like a bank statement for your warehouse stock — each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
4 of 7
Accountants and finance teams
Accountants and finance teams who need to reconcile the closing stock figure on the balance sheet with actual warehouse movements.
Think of it like a bank statement for your warehouse stock — each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
5 of 7
3PL and logistics businesses
3PL and logistics businesses providing clients with transparent, transaction-level stock reports to prove fulfilment accuracy.
Think of it like a bank statement for your warehouse stock — each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
6 of 7
Spare parts and MRO businesses
Spare parts and MRO businesses tracking individual component usage, ensuring critical parts are always available while minimising overstock.
Think of it like a bank statement for your warehouse stock — each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
7 of 7
Food and beverage companies
Food and beverage companies with FIFO requirements who need a full consumption trail by product and date range for traceability.
Think of it like a bank statement for your warehouse stock, each row shows one transaction, where the goods moved from, where they went, and how much stock remained after that movement.
Compatibility
- Odoo.sh
- On-Premise
- Community Edition
- Enterprise Edition
Dependencies
Discuss
Inventory
- No third-party libraries
- No external APIs
- no additional SaaS subscriptions
Installation
- Copy the module folder to your custom addons directory.
- Enable Developer Mode in Odoo settings.
- Update the apps list and search "Stock Ledger Report".
- Install — no extra configuration required.
The report is available immediately under Inventory → Reporting
Step-by-Step
Navigate to Stock Ledger
Go to Inventory → Reporting → Stock Ledger. The Date Filter Wizard opens automatically.
Set your date range
The wizard pre-fills the previous full calendar month. Adjust From and To dates as needed, then click Generate.
Browse the product list
A filtered product list opens with your date range stored in context. Search or scroll to the product you want to analyse.
Click "View Ledger"
Click the blue View Ledger button on any product row. The system calculates the opening balance and loads all completed movements.
Read and export your ledger
The report displays every stock movement with colour-coded IN/OUT indicators and a running Balance column for the full period.
The running balance uses a straightforward cumulative formula that any auditor or accountant will immediately understand:
Balance
=
Opening Balance
+
Incoming
-
Outgoing
The opening balance is calculated from all stock movements prior to the selected From date. This means even if you run the report for a single day, the opening balance will correctly reflect the entire stock history up to that point — not just the previous period's closing balance
Only movements in Done state are included. Draft transfers, cancelled moves, and pending receipts are excluded, so the ledger reflects only what physically happened in your warehouse.
Building a custom stock ledger report in Odoo from scratch requires understanding the stock.move model, handling the opening balance calculation (which involves aggregating all historical moves), correctly excluding draft and cancelled states, and building a usable wizard interface. This is typically 2–5 days of development work for an experienced Odoo developer.
At $18.25 for a proven, tested module that installs in minutes, the ROI is immediate - even if you only use it once to resolve a single inventory discrepancy.
Maintained by Ahex Technologies, with a track record of clean, lightweight modules. With just 201 lines of code it remains easy to audit and customise if your business ever needs extensions.
Ready to Track Every Stock Movement?
The current version filters by product and date range, displaying source and destination locations for every movement. Location-specific filtering can be explored as a customisation through Ahex Technologies.
Case Study
Towanto: Multi-Vendor Agriculture E-Commerce Platform
Towanto
Towanto is an agricultural products provider that partnered with AHEX Technologies to build a scalable Odoo-powered marketplace connecting multiple sellers with customers through web and mobile commerce.
- Multi-Vendor Marketplace
- Web & Mobile Commerce
- Seller Management Portal
- Integrated Payments & Notifications
Sodahub: Multi-Company Odoo ERP Transformation
Sodahub Industrial
Sodahub Industrial is a diversified beverage manufacturing company operating across flavour production, PET bottle manufacturing, and packaged drinking water. AHEX Technologies migrated its operations from TCS iON ERP to a unified Odoo platform.
- Multi-Company ERP Implementation
- Manufacturing & Supply Chain Management
- TCS iON to Odoo Migration
- Real-Time Dashboards & Reporting
Isler India: End-to-End Kitchen Appliance Manufacturing
Isler
Isler India is a design-driven kitchen appliance manufacturer producing chimneys, built-in hobs, cooktops, OTGs, microwaves, and dishwashers. AHEX Technologies implemented Odoo ERP to connect sales, manufacturing, inventory, procurement, finance, and HR.
- Automated Production Planning
- Real-Time Inventory Management
- Centralized CRM & Sales
- Integrated HR & Accounting
Vastu Company Ltd.: Smarter Construction Operations with Odoo
Vastu Company Ltd.
Vastu Company Ltd. provides mining, drilling, blasting, and light gauge steel construction solutions. Ahex Technologies implemented Odoo ERP to connect project management, field service, workforce, finance, procurement, and inventory operations.
- Project Cost & Profitability Tracking
- Automated Workforce & Payroll
- Integrated Accounting & Billing
- Real-Time Dashboards & Reporting
What Our Clients Say About Us
Explore Our Blogs on Odoo Integration
Related to Implementation
Yes. The module is compatible with both Odoo Community and Enterprise editions running versions 18 & 19. It depends only on the core Inventory module which is available in both editions.
The current version filters by product and date range, displaying source and destination locations for every movement. Location-specific filtering can be explored as a customisation through Ahex Technologies.
The report only includes movements in “Done” state. If no completed movements exist within your selected date range, the ledger will show only the opening balance with no transaction rows.
Odoo’s built-in reporting shows current quantities and summarised moves. The Stock Ledger Report shows every individual transaction in chronological order with a running balance, the equivalent of a bank statement versus just a bank balance.
Yes. The opening balance is calculated from all historical “Done” movements before your selected start date, going all the way back to the product’s first receipt in the system.
Multi-Company CRM Stage Manager
Forem ipsum dolor sit amet, consectetur adipiscing elit.
Know more âžž
Dynamic BOM from Sales Order
Forem ipsum dolor sit amet, consectetur adipiscing elit.
Know more âžž
Maximum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit.
Know more âžž
Looking for a Solution? Let's Talk
- sales@ahex.co.in
- (India) +91 - 8885564224
- (USA) +1 - 6503197394
DEVELOPERS
YEARS IN OPERATION
GLOBAL CLIENTS
