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.
Ahex Technologies
Inventory Reporting
No External Dependencies
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 $ 19.02 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.
Digital Transformation of Isler India Limited with Odoo ERP
Digital Transformation of Sodahub Industrial Engineering with Odoo ERP Implementation
Digital Transformation of a UK-Based Engine Manufacturing Company with Odoo ERP
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.
What Our Clients Say About Us
Explore Our Blogs on Odoo Integration
- Abhishek Pandey
Ahex Technologies Expands Odoo 18 ERP Implementation Services for Indian SMBs
Hyderabad-based IT services company strengthens its Odoo practice to help small and mid-sized businesses migrate from legacy accounting tools to
- ajeet
How to Integrate Odoo with Shopify for Seamless Business Operations
Are you a retailer or have a running e-commerce business that uses Shopify and Odoo to manage your online sales
- ajeet
Planning Your Next ERP Upgrade? Why Odoo 20 Deserves Your Attention
Odoo is one of the most popular and user-friendly ERP solutions. It has over 28 million active users. It was
Related to Implementation
Yes. The module is compatible with both Odoo Community and Enterprise editions running version 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
