Ana's story and her auto parts business: When the numbers don't add up
Ana runs a successful auto parts distributor. For years, her business grew organically, but lately she noticed something troubling: when reviewing her financial statements, the projected profits never matched reality. Her products had been bought multiple times at different prices over time, and when she sold, she had no clarity on which exact cost to assign to each sale. Was she really making money with that important client? Or were some sales actually losing money? Her frustration grew every month, until she discovered that the problem was not her management, but the lack of visibility into how her inventory costs were really calculated. Many companies like Ana's find in Ganemo the perfect ally to implement solutions that turn this uncertainty into absolute control.
Accessing the average cost report: Your window into financial transparency
In Odoo, the path to clarity starts in the Inventory module. From there, go to the Reporting menu, where you will find the Stock report. For each specific product, you can access this report directly from the unit cost field, which lets you see in detail how that value was exactly determined. This direct access eliminates the need to search for information in multiple places, centralizing everything you need to know about your product costs in one single point.
Applied example: Imagine Carlos, manager of a hardware store that handles 500 different products. Before implementing this solution with Ganemo's help, he spent hours cross-referencing purchase and sales data in spreadsheets. Now, when a customer asks about the profit margin on a specific hammer, Carlos simply opens the report from that product's unit cost and in seconds has the full history of transactions and calculations. This efficiency not only saves him time, but gives him confidence in his numbers during crucial meetings with investors.
Interpreting the full detail: The story behind every number
The report shows you chronologically every transaction affecting a product's inventory, automatically calculating the average cost after each movement. It starts with the opening inventory (if any), then each purchase, production or adjustment, and finally each sale or consumption. Next to each transaction you will see the quantities, unit values, total values and, most importantly, the average cost recalculated after that specific movement. This complete traceability lets you understand not only what the current cost is, but why it reached that value.
Real use case: Sofia runs a small furniture factory. Recently, the price of wood fluctuated significantly. When she reviewed the average cost report for her oak tables, she could see exactly how each wood purchase at different prices affected her average cost. When the time came to quote a large project, instead of guessing or using an error-prone manual average, Sofia relied on Odoo's automatic calculation, set up with Ganemo's expertise, to present an accurate and competitive quote that secured the project's profitability.
The step-by-step calculation: How purchases change the average cost
The mechanism is mathematically elegant: every time new units come in at a value different from the current average cost, the system recalculates. It adds the previous total value (average cost × quantity) to the value of the new purchase (new price × new quantity). Then it divides this new total value by the new total number of units. The result is the new average cost. It is crucial to understand that only receipts with different unit values modify this average, since they represent new cost information that must be incorporated into the calculation.
Illustrative story: Roberto imports electronic components from Asia. In January he bought 100 units at $10 each (average cost: $10). In March, due to exchange rate changes, he bought 200 more units at $12 each. Odoo, configured by Ganemo specialists, automatically calculated: previous total value ($10 × 100 = $1,000) + new purchase value ($12 × 200 = $2,400) = $3,400. Total quantity: 300 units. New average cost: $3,400 ÷ 300 = $11.33. This transparency allowed Roberto to adjust his selling prices in time, protecting his margins without hiring an external cost accountant.
Why sales don't affect the calculation: The stability of the outgoing cost
Here is one of the most important concepts: when you sell products, they leave at the current average cost, but this outflow does not change the average cost of the units remaining in inventory. The system simply multiplies the quantity sold by the current average cost to determine the cost of that sale, and subtracts both the value and the quantity from inventory. The average cost of the remaining units stays exactly the same, because no new cost information has come in; units have only been withdrawn at the cost already established.
Business example: Laura owns a clothing store. She sold 15 jackets from a batch whose average cost was $45 each. The system recorded a cost of sale of $675 (15 × $45) and reduced inventory by 15 units. The remaining 35 jackets kept their average cost of $45. When Laura had to present financial reports to her board of directors, this consistency in the calculation, made possible by the Odoo implementation Ganemo carried out, gave her absolute credibility. There were no surprises or mysterious adjustments: every number had a clear and verifiable origin in the average cost report.
The transformative power of total visibility
This report is not just a technical tool; it is a paradigm shift in business management. You no longer need to rely on estimates, manual averages or “financial intuition”. You have concrete evidence, transaction by transaction, of how each product's cost forms in your inventory. This visibility lets you make decisions with confidence: from setting selling prices that ensure profitability, to identifying strategic buying opportunities when supplier prices are favorable. Companies that work with Ganemo discover that this clarity not only solves accounting problems, but becomes a tangible competitive advantage.
Real-life implementation: A food manufacturer that implemented Odoo with Ganemo managed to reduce its inventory discrepancies by 92% in six months. Previously, the different calculation methods across departments caused constant disagreements between production, sales and accounting. Now, the average cost report serves as the single source of truth. When the price of sugar suddenly rose, they could see exactly how it affected the average cost of each sweet product, adjust formulas and prices strategically, and communicate the changes to customers with irrefutable data. This ability to respond based on precise data is what separates companies that survive from those that truly thrive.