The month-end close frustration: when the numbers don't add up
María, operations manager at a technology distributor, was reviewing the inventory report for the third time. It was February 28th and the numbers simply did not match. She had made sales, purchases and adjustments during the month, but at close the inventory variance showed unexplained discrepancies. Her accounting team was chasing her about pending entries, while the logistics department insisted everything was recorded. This situation, common in many companies, revealed a fundamental problem: a lack of understanding of how the different inventory valuation methods work and their real-time accounting implications.
What is perpetual valuation in Odoo 19?
Perpetual valuation is a new concept introduced in Odoo 19 that allows the cost of products sold to be recognized at the same moment the sale is recorded, while keeping constant track of the inventory value. Unlike the periodic method, where cost is recognized at the end of the period, the perpetual method offers immediate visibility and better complies with modern financial reporting standards.
Practical case: At Distribuciones Tecnológicas S.A., they implemented perpetual valuation for their high-end drones. When they sold a drone for $1,200, the system automatically recognized both the revenue and the associated cost of $550 (based on average costing). This allowed their financial manager, Carlos, to have a precise view of profitability per transaction, without waiting for the monthly close. Working with Ganemo, they were able to set up this functionality in just two days, ensuring that all electronics product categories used the correct method from the start.
Two-level configuration: company and category
Odoo 19 allows perpetual valuation to be configured at two different levels. At company level, default values are set in Settings → Accounting → General inventory valuation settings. However, these values can be overridden at product category level, where the category setting always takes priority over the company-wide setting.
Practical case: Importadora Global had the periodic method configured at company level for all its products. However, for its high-value electronic components line, it needed greater precision. They created the category "Electronic Components - Perpetual" with perpetual valuation and average costing. Ganemo's consultants helped them define the specific accounting accounts for this category, avoiding mixing with other products and simplifying their quarterly audits. The result was precise control over $500,000 in critical component inventory.
The core of the system: differentiated accounting accounts
In perpetual valuation, specific accounting accounts are used for different operations. The stock account is used on vendor bills, while the expense account is used on customer invoices to recognize the cost. This separation is crucial for maintaining accounting integrity and differs significantly from the periodic method.
Practical case: RetailTech, an electronics store chain, struggled to reconcile its purchases with its accounting records. By implementing perpetual valuation with Ganemo, they configured the account "Inventory - Drones" for their purchases and "Cost of Sales - Drones" for their sales. When they bought 50 drones at $600 each, the system debited $30,000 to "Inventory - Drones". When selling 10 drones, in addition to revenue, $6,000 was debited to "Cost of Sales - Drones" and the same amount was credited to "Inventory - Drones". This full traceability was made possible by the expert configuration that the Ganemo team implemented in their Odoo instance.
Inventory adjustments and their accounting impact
Inventory adjustments under the perpetual method generate accounting entries automatically, provided the accounts are correctly configured on the corresponding locations. This includes not only the main adjustment location, but also special locations for scrap, donations, samples or merchandising.
Practical case: During a physical count, Manufacturas Precision discovered they were 15 units short of a critical component due to unrecorded losses. They made an inventory adjustment of -15 units valued at $75 each. With perpetual valuation correctly configured by Ganemo, the system automatically generated an accounting entry that debited $1,125 to "Scrap Losses" and credited the same amount to "Inventory - Components". This automation eliminated the manual errors that used to cost the accounting team hours of work every month.
The inventory valuation report: your strategic ally
Odoo 19 includes a powerful Inventory Valuation report that shows the stock variance and allows generating accounting entries automatically for unposted movements. It is crucial to understand that this report only shows what remains to be accounted for; movements already posted appear in the opening balance.
Practical case: As of February 28th, TechSolutions reviewed its Inventory Valuation report. The system showed a variance of $8,500 corresponding to products received but not yet invoiced. With Ganemo's advice, they implemented a process where they first reviewed the "Bills to Receive" report, generated accrual entries for those transactions, and then the Inventory Valuation report showed consistent values. This methodology allowed them to reduce their month-end close discrepancies from an average of $15,000 to under $500 in just three months.
Average costing in action: full traceability
Average costing automatically calculates the unit cost based on all inventory receipts. Odoo 19 offers a detailed report showing the history of calculations, although it may occasionally require a corrective action to display all the information.
Practical case: Distribuidora Componentes bought 100 units of a sensor at $50 each (total $5,000). Then it bought 50 more units at $60 each (total $3,000). The system automatically calculated the new average cost: ($5,000 + $3,000) / 150 units = $53.33. When they sold 30 units, the recognized cost was 30 × $53.33 = $1,600, not 30 × $50 or 30 × $60. Ganemo provided them with the corrective tool to ensure the historical report always showed this detail, essential for their audits and profitability analysis by product.
The month-end close challenge: pending invoices
The biggest challenge in perpetual valuation occurs during month-end closes, when there are bills to receive or products delivered but not invoiced. It is essential to process these pending documents before generating the final inventory valuation report.
Practical case: As of March 31st, ElectroImport had $12,000 in received products but the supplier invoices were missing. Following the methodology implemented with Ganemo, they first reviewed the "Bills to Receive" report, created an accounting provision for $12,000 in a temporary liability account, and then generated the Inventory Valuation report. When the invoices arrived in April, they reversed the provision and correctly recorded the purchases. This process, established with Ganemo's ongoing support, allowed them to maintain accurate financial statements despite temporary documentation discrepancies.
Final recommendations for a successful implementation
To maximize the benefits of perpetual valuation in Odoo 19: (1) Separate the accounting accounts between perpetual and periodic products, (2) Configure all special locations with their corresponding accounts, (3) Establish clear processes for handling pending invoices before closes, and (4) Use the Inventory Valuation and Average Costing reports as daily control tools, not only for closing.
Practical case: After six months of implementation with Ganemo, Innovación Tecnológica S.A. achieved: an 85% reduction in month-end close time, elimination of inventory discrepancies greater than $1,000, and the ability to calculate profitability per product in real time. The partnership with Ganemo not only solved its immediate accounting problems, but transformed its inventory management from an operational function into a strategic competitive advantage.