| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 201 |
| Technical Name |
daily_odoo_stock_ledger_report |
| License | OPL-1 |
| Website | https://www.ahex.co |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Lines of code | 201 |
| Technical Name |
daily_odoo_stock_ledger_report |
| License | OPL-1 |
| Website | https://www.ahex.co |
Your warehouse has a stock count.
Now give it a story.
A line-by-line history of every stock movement â incoming, outgoing, and running balance â giving you full, auditable warehouse visibility at any point in time.
Need Support?
Purchased this module? Our team helps with installation and setup.
Open Support TicketAt a Glance
- No configuration needed
- Works out of the box
- Zero external dependencies
- Colour-coded IN / OUT rows
- Auto opening balance calc
- Community & Enterprise
Read our complete guide on the Ahex Technologies website
Our website article covers everything in deeper detail â balance calculation formulas, industry use cases, FAQs, and a full technical breakdown.
The Problem Odoo Doesn't Solve Out of the Box
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. Odoo's standard Inventory module gives you product 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 actually need.
When your accounts team asks why the closing stock doesn't match purchase orders, or when an audit requires you to trace a discrepancy back through three months of warehouse activity, the native reports leave you piecing it together manually.
The Stock Ledger Report closes that gap. It gives every product in your inventory its own financial-style ledger: opening balance, every IN and OUT transaction with source and destination, and a live running balance after each movement â for any date range you choose.
Quick summary: If you've ever asked "where did my stock go?", "what was my opening inventory last month?", or "why doesn't my closing balance match?" â this module is exactly what you need. It works like a bank passbook for your warehouse.
Who Needs a Stock Ledger Report in Odoo?
This module solves a real pain point that comes up across industries. Here are the most common scenarios where businesses reach for a stock ledger:
Manufacturing
Track raw material consumption per production batch and reconcile theoretical vs. actual usage.
Retail & Wholesale
Audit stock movement between warehouse, shop floor, and delivery â especially for high-value SKUs.
Food & Beverage
FIFO traceability requirements â full consumption trail by product and date range for regulatory compliance.
Pharma & Healthcare
Maintain regulatory-compliant inventory records for audits, compliance inspections, and traceability requirements.
3PL & Logistics
Provide clients with transparent, transaction-level stock reports to prove fulfilment accuracy.
Odoo Implementation Partners
Clients who need ledger-style reporting as part of a wider ERP rollout â ready to deploy, no custom dev needed.
Spare Parts & MRO
Track individual component usage, ensuring critical parts are always available while minimising overstock.
Accountants & Finance
Reconcile the closing stock figure on the balance sheet with actual warehouse movements â in a format they already understand.
How the Report Looks: A Sample Ledger
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.
Balance Calculation â Transparent & Auditable
The opening balance is calculated from all stock movements prior to the selected From date â going all the way back to the product's first receipt. Even if you run the report for a single day, the opening balance correctly reflects the entire stock history. Only Done state movements are included.
Report Columns Explained
Date
Exact date and time of the stock movement as recorded in Odoo.
Product
The product being reported on and audited.
From
Source location where the stock moved from.
To
Destination location where the stock moved to.
Incoming (IN)
Quantity received into internal stock â highlighted in green.
Outgoing (OUT)
Quantity dispatched from internal stock â highlighted in red.
Type
IN or OUT label â colour-coded for rapid scanning.
Balance
Running total of stock remaining after each movement completes.
Step-by-Step Workflow
|
1
|
Open Stock Ledger from Inventory ReportingNavigate directly to the new Stock Ledger reporting menu item inside the Inventory application. |
|
2
|
Set Your Date RangeA calendar wizard opens, pre-filled with the previous full calendar month. Adjust the From and To dates and click Generate. |
|
3
|
Browse the Product ListBrowse or filter standard Odoo products. Your date range parameters are stored temporarily in the session context. |
|
4
|
Click "View Ledger"Click the View Ledger action button on any product row. This triggers the ledger calculations. |
|
5
|
Read and Export Your Full LedgerAnalyze line-by-line movements with running balances. The ledger can be exported to Excel or printed via standard Odoo actions. |
Why Choose This Over a Custom Report?
Building a custom stock ledger report in Odoo from scratch requires understanding the stock.move model, handling the opening balance calculation (aggregating all historical moves), correctly excluding draft and cancelled states, and building a usable wizard interface.
The ROI is immediate
This is typically 2â5 days of development work for an experienced Odoo developer. At $19.10 for a proven, tested module that installs in minutes â the return on investment is clear, even if you only use it once to resolve a single inventory discrepancy.
The module is maintained by Ahex Technologies, an Odoo Apps publisher 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.
Ideal For
Inventory managers
Inventory managers and warehouse controllers who need to explain stock figures to finance or management.
Businesses
Small to medium businesses wanting clean, auditable reports of stock movement without hiring dedicated IT support or SQL experts.
Operations
Logistics specialists and dispatch managers tracking stock changes, returns, adjustments, and receipts date-wise.
Odoo implementation partners
Odoo developers and consultants who need a ready-made, reliable module to satisfy their clients' financial ledger requirement.
Companies running Odoo Inventory
Enterprise teams requiring strict date-wise inventory audit trail support, stock reconciliations, and closing valuations.
Quick Setup Guide
Step 1 â Install the Module
- Copy module folder to your custom addons directory
- Go to Settings → activate Developer Mode
- Go to Apps → Update Apps List
- Search "Stock Ledger Report" → click Install
Step 2 â Start Using Immediately
- No additional configuration required
- Navigate to Inventory → Reporting → Stock Ledger
- Set your date range and generate your first ledger
Technical Details
Odoo Online ⢠Odoo.sh ⢠On Premise (Community & Enterprise Editions)
| Information | Detail |
|---|---|
| Technical Name | daily_odoo_stock_ledger_report |
| Odoo Version | 19.0 |
| Lines of Code | 201 |
| Dependencies | stock mail |
| License | OPL-1 |
| Author | Ahex Technologies |
What Users Search For â This Module Covers It All
Users searching for this kind of inventory reporting tool use a wide range of terms. This module satisfies all of them:
Support & Documentation
Committed to ensuring you get the most out of the Stock Ledger Report. For purchase support, installation assistance, or customisation enquiries, contact us through the channel where you purchased this module.
Full Website Guide
Deep-dive article - balance formulas, use cases, FAQs
Read Full GuideFrequently Asked Questions
Is this compatible with both Odoo Community and Enterprise?
Yes, the module is fully compatible with both Odoo Community and Odoo Enterprise versions. It is developed using Odoo standard ORM API rules.
Can I filter by warehouse or specific location?
The current version calculates ledger movements for the selected product date-wise across all warehouse locations, showing source and destination fields for each movement. If you need dedicated filtering by specific location, feel free to contact Ahex Technologies for a customization inquiry.
How is the opening balance calculated?
The opening balance is calculated by summing all completed (Done state) stock movements for the product from the beginning of your Odoo history up to the selected From date. Incoming quantities add to the balance, while outgoing quantities subtract from it.
What is the difference between this and Odoo's standard inventory report?
Odoo's standard reporting shows current stock valuations or stock moves lists, but lacks a running chronological ledger. Our module orders movements by date, shows exact from/to locations, color-codes IN/OUT movements, and calculates a running balance after each transactionâjust like a bank statement.
Are there any external dependencies or API calls?
No. The module is 100% self-contained and runs entirely on your local Odoo server database. There are no external dependencies, API scripts, or trackers.
Ahex Technologies
Odoo module development experts building clean, purpose-built solutions for inventory, reporting, and ERP workflows. Lightweight code, zero unnecessary dependencies â modules your team can trust and auditors can read.
Want to Dig Deeper Before Buying?
Our complete guide on the Ahex Technologies website covers the balance calculation formula, 2 industry use cases, all FAQs answered in detail, and a full technical breakdown. Same product - deeper story.
Explore our other applications
Discover other tools developed by Ahex Technologies to streamline your Odoo workspace.
AI Email Lead Parser for CRM
Convert incoming customer support and sales emails into clean CRM pipeline leads automatically.
Auto Invoice PDF Sender
Generate, attach, and email invoice PDFs to customers as soon as the invoice validation completes.
Sales Commission Manager
Set custom sales agent targets, tier models, and track commission rates dynamically from invoice states.
Connect With Us
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module