Multi-Company Cash Flow Consolidation in Odoo

Odoo handles multi-company well at the accounting layer. It handles it badly at the forecasting layer, for the simple reason that it does not forecast. If you run three companies in one Odoo database and you want to know what the group cash position will be at the end of next month, you are building that number by hand.

This page covers what Odoo does consolidate natively, where the forecast breaks, and what intercompany transactions do to the answer if you are not careful.

How the manual version actually goes

The pattern is the same in most finance teams running several Odoo companies.

Someone exports Aged Receivable and Aged Payable per company. Each export is pasted into its own tab. Bank balances are pulled per company, in whatever currency each one operates in. Intercompany invoices are found, matched to their counterpart, and stripped out. The tabs are summed into a group view, converted to the reporting currency, and laid out by week.

By the time it is finished, two things have happened. Several days have passed, so the earliest exports are already out of date. And the number that comes out is one person's arithmetic, which means nobody else can check it quickly or rebuild it if that person is away.

What Odoo does consolidate natively

Worth being accurate here, because Odoo does more than it gets credit for.

• Multi-company records. One database can hold many companies, with users given access to more than one and a company selector at the top of the interface.
• Consolidated financial reports. Selecting several companies at once gives you a combined balance sheet and profit and loss.
• Intercompany rules. Odoo can generate the counterpart document automatically, so a sales order in one company creates the matching purchase order in another.
• Multi-currency. Rates are maintained per currency with automatic updates available, and each company can hold its own currency.

What it does not do is project any of that forward. The consolidated reports are built from posted entries. There is no group forecast, no consolidated forward cash position, and no way to ask what the combined balance looks like in nine weeks.

Why intercompany transactions distort a naive consolidation

This is the part that quietly produces wrong numbers, and it is worth understanding before you trust any consolidated cash figure.

Suppose Company A invoices Company B for 50,000 of shared services, due in 30 days. In Company A's forecast, that is a receipt of 50,000 next month. In Company B's forecast, it is a payment of 50,000 next month. Add the two forecasts together and the two cancel out correctly, and the group total is right.

Now change one thing. Company B pays late, as group companies routinely do because nobody chases an internal invoice. Company A still shows the receipt on the due date. Company B shows the payment when it expects to make it, three weeks later. The group forecast now carries 50,000 of cash that exists in neither company during those three weeks. Do this across a dozen intercompany balances and the group number can be out by a material amount in exactly the weeks you were trying to check.

The related failure is counting the same cash twice. If Company A lends Company B working capital and both sides are modelled as external movements, the group forecast shows the funding as available in two places.

Two rules follow from this. Intercompany positions have to be netted out at group level rather than summed. And where they are kept in the forecast for entity-level visibility, both sides need the same expected settlement date, not one on the due date and one on a guess.

Multi-currency, and the date that matters

Consolidating across currencies adds a question the accounting reports do not have to answer: which rate do you apply to a receipt that has not happened yet.

Historic reporting uses the rate at the transaction date, which is knowable. A forecast has no transaction date, so you are choosing between today's rate applied to everything, a forward rate, or a rate you have contracted through a hedge. For most SMB groups, today's spot rate applied consistently is the right answer, with any hedged position modelled at its contracted rate. What matters more than the choice is stating it, because a group forecast that moves 4 percent between two Mondays with no underlying change is usually a rate assumption changing quietly, and nobody trusts a number that does that.

The real cost of the spreadsheet version

Take a group of three companies with one shared services entity invoicing the other two.

Per monthly cycle, you are exporting six reports, reconciling bank balances across three entities, identifying and netting the intercompany positions, converting currencies, and rebuilding the weekly layout. Then, because the forecast matters more when it is tight, you do a lighter version of it again mid-month.

The time cost varies by group, so measure your own rather than trusting a figure from a vendor page. Count the hours across one full cycle, including the mid-month rebuild and the time spent answering questions about the number afterward. That is the figure to hold up against any alternative.

The cost that does not show up in hours is the one that matters more. A group forecast rebuilt monthly cannot answer a question asked on the 12th. When the board asks whether the group can fund an acquisition deposit in seven weeks, the honest answer from a monthly spreadsheet is that it will take a few days to find out.

The connected alternative

The other route is to connect each Odoo company to a forecasting tool and let the consolidation happen automatically.

Cash Flow Frog connects to each of your Odoo companies over the API, with no module installed in the database and nothing changed in your configuration, so it works the same on Odoo Online, Odoo.sh and on-premise. Each entity gets its own rolling forecast built from its live data, and the group view sits on top of them, updating as the underlying invoices, bills and payments change.

From there you can look at the group position or drop into a single company, drill from any point in the forecast down to the transactions behind it, and run a scenario across the group rather than across one tab. The forecast runs up to three years out, in daily and weekly views.

If you are still shortlisting, the forecasting tools that connect to Odoo is a shorter list than the general cash flow software market suggests, because most of it is built for Xero and QuickBooks only.

Questions to answer before you choose

• How many entities are in the group today, and how many will there be in two years?
• Do the companies share a currency, and if not, whose rate assumption governs the group view?
• How much of your intercompany activity settles on time, and how much drifts?
• How often does someone ask a group cash question between monthly cycles?
• If the person who built the model left next month, could anyone rebuild it?

The last one decides it more often than the cost comparison does.

Where this leaves your group cash forecast

Consolidated cash forecasting is the point where the spreadsheet stops being a reasonable tool and starts being a risk. A single-company model that is a week out of date is inconvenient. A group model that is a week out of date, with intercompany positions netted by hand, is a number people make funding decisions on without being able to check it.

Cash Flow Frog consolidates cash flow forecasts across multiple Odoo companies automatically, with scenarios and transaction-level drill-down, up to three years ahead. You can see how the Odoo integration works, compare it against native Odoo reporting, or check pricing by company count.

If you are starting with a single entity, read the three ways to forecast cash flow in Odoo.