It's end of quarter. The portfolio is reconciled, the positions look right, but the accountant is still cross-referencing every trade against the general ledger, hunting for the one booking that didn't make it over or landed on the wrong account. This is the reality for most investment vehicles and holding companies today. Portfolio management lives in one tool, or an Excel, while accounting runs in another. Every purchase, sale or dividend has to be entered twice, by hand, often by different people. The reconciliation at the end is not a safety net, it's a symptom.
For a holding company managing over €40M in assets, we built a solution to close that gap. The Investment Management module connects asset management directly to Odoo's accounting engine. Purchase values on the balance sheet. Quantities, unit prices and fx rate in the built-in portfolio. No separate administration alongside Odoo, no exports that have to be re-imported later.
Valuation method FIFO or AVCO? Positions in EUR or USD? Separating the stock price gain from the FX rate gain? You define the rules once and the module applies them consistently across every transaction.
How it works
Everything starts by importing your bank statements and reconciling bank transactions to the correct (investment) accounts. Just like any other regular bank reconciliation, no unnecessary complexity.
For any purchase or sale transaction, Odoo will ask you to enter the transaction details such as quantity, unit price and currency. Based on this, your portfolio will be updated. In case of the sale of an asset, you can generate the gain or loss booking with one push of a button. Built-in checks prevent mismatches between accounting and portfolio value, and prevent forgotten transaction details. At any time, your accounting and portfolio are perfectly in sync.
What it delivers
One version of the truth
Accounting and portfolio live on the same data, in the same system. Quarterly reconciliation turns from a hunt into a formality.
Consistent rules, automatically applied
Valuation method, currency handling, separation of stock price gain from FX gain; set once, applied correctly to every transaction. No interpretation gaps between whoever books and whoever analyses.
Built-in checks, no forgotten entries
The module flags mismatches between accounting and portfolio value, and blocks transactions from being posted without complete details. The error is caught when it's made, not three months later.
For holdings and investment vehicles, this means significantly simpler management of a complex matter. The portfolio and the accounting automatically tell the same story and the time that used to go into manual postings and reconciliation can go to actual analysis and decision-making.