A practical guide to taking a foreign subsidiary out of your consolidation, from the ownership change to the folder your auditors will ask for
In short
The press release went out on the last day of April. Global Holdings, a US group that reports in dollars, has sold its 80% holding in EuroParts, its German subsidiary. The deal team is celebrating. For the consolidation team, the real work starts the next morning.
Within a week, someone in the CFO’s office (or worse, the audit senior) will want answers to four questions.
A lot of finance teams quietly assume FCCS will sort all of this out. Set the ownership to zero, consolidate, go home.
It won’t, at least not completely. FCCS is very good at the mechanics. What it can’t do is read the sale agreement. A disposal is one of the few close events where you have to be clear about which parts the application handles, which parts it hands back to you, and which entries only you can post. Miss one and it usually turns up during the audit rather than in your own review.
Disposals come up regularly on the Oracle community forums, and the answers tend to arrive in fragments: a post about ownership here, a thread about CTA there. This is my attempt to put the whole picture in one place. I’ve kept it conceptual, so you won’t find worked numbers, only what should happen, how to check it and how to fix it.
Picture a group consolidation manager at a mid-sized multinational. Call her Priya. She runs FCCS month after month without opening the manual, and she found out about the disposal three days before close. She has no time for an IFRS lecture. What she wants is a list of things to check, the fixes, and something tidy to hand the auditors. That’s the bar I’ve tried to meet.
I’ve borrowed the four-stage cycle we use on Orbrick engagements. It works just as well for one awkward close event as it does for a full program.
| Stage | What you’re trying to find out |
|---|---|
| Sense | Is something off, and how would I spot it? |
| Evaluate | How far off is it? |
| Execute | What can I fix myself, and when is outside help worth it? |
| Retrospect and refine | How do I keep it right through year end, and show the effort paid off? |
Spotting an error is far easier once you know what the finished picture should look like. So we’ll start with the target and come to the symptoms afterwards.
IFRS 10 and ASC 810 say the same thing in different words. A parent consolidates a subsidiary until the day it loses control, and stops on that day. For EuroParts, that day is April 30, and four things follow from it.
Start with the parent’s own ledger. There, EuroParts is a single investment line, carried at whatever was paid for it years ago. Nothing about that line changes from one year to the next. So, on the day of sale, the parent’s gain is the proceeds less that original cost, and all the value EuroParts added since the acquisition lands in a single month.
The group sees the same company very differently. Every year, EuroParts’ revenue, costs and profit came into the consolidated P&L and piled up in group retained earnings. Every year, the differences from translating euros into dollars built up in the currency translation reserve, the CTA. By April, the group has already reported most of the value the parent is only now recognizing.
| In the parent’s own books | In the group accounts | |
|---|---|---|
| How EuroParts appears | One investment line, held at cost | Every asset, liability, income and expense line |
| Profit since acquisition | Nothing until the sale | Booked year by year in the P&L and retained earnings |
| Currency effects | None | Accumulated in the CTA reserve within equity |
| Gain on sale | Proceeds less original cost | Proceeds less the net assets the group still carries for EuroParts (after the NCI share), plus the CTA recycled to P&L |
A fixed deposit that credits interest every year is a good way to picture it. You declare the interest as income in each year it’s credited. When the deposit matures, you don’t declare all those years of interest a second time. They’re already in your earlier returns.
Carry the parent’s gain straight into the consolidated P&L, though, and that’s exactly what happens: years of EuroParts’ earnings get counted twice. The group’s gain is normally the smaller number. Add up every year from acquisition to sale and both views reach the same total. They simply recognize it at different times.
The CTA reserve is the other moving part. It has been parked in equity for as long as the group has owned EuroParts. When a foreign operation is disposed of, IAS 21 and ASC 830 require that reserve to be reclassified to profit or loss (accountants usually say recycled), where it becomes part of the gain.
Watch the NCI’s share of the CTA
IAS 21 recycles only the parent’s share of the translation reserve through the P&L. The slice that belongs to the non-controlling interest leaves the balance sheet along with the NCI and never touches profit or loss. Under US GAAP that slice already sits inside the NCI balance, so you end up in a similar place. If your journal sends the entire CTA balance to the P&L, look at it again before posting.
Over the years, I’ve seen the same six patterns whenever a disposal hasn’t been handled properly.
A seventh symptom doesn’t live in any report. When the auditors start asking questions you can’t answer from the system, the problem has already found you.
Knowing something is wrong is a start. What you really need is to know how wrong, and to be able to prove a fix worked. My approach is the same with every client: define the target, see what FCCS is showing, and measure the distance between the two.
Take a snapshot first. Before any ownership change or journal, pull the consolidated balance sheet and P&L for the disposal month, export them, and save the file with the date in its name.
Nobody enjoys this step, and it’s the one I’d least want to skip, because every later comparison runs against that file. From it, note three figures for EuroParts: its net assets, the NCI share and its share of the CTA reserve. Those are precisely the amounts about to leave the group.
There are six checks, one for each symptom in the previous section, and each one is a plain pass or fail.
| Check | A pass looks like this | A fail looks like this |
|---|---|---|
| 1. Gain | The group gain reflects the group’s view: double count removed, CTA released | The group gain is the same as the parent’s |
| 2. CTA | EuroParts’ CTA reserve is nil, and you can trace it as a reclassification in OCI and a separate component of the gain | The reserve has simply disappeared |
| 3. YTD P&L | EuroParts’ pre-sale results are still in the YTD P&L for the disposal month, the following month and the latest period | The results vanish after the disposal month |
| 4. NCI | The equity roll-forward shows NCI leaving on a “disposal of subsidiary” line, and the NCI’s share of pre-sale profit is still in “profit attributable to non-controlling interests” | NCI just drops |
| 5. Intercompany | No unmatched balances with EuroParts in the month after the sale | Any orphaned balance at all |
| 6. Cash flow | The sale shows as one net investing line, after deducting the cash EuroParts took with it, and working capital looks normal | A working capital spike in the disposal month |
Give check three proper attention. Open the YTD P&L for each of those periods and drill into EuroParts’ contribution. Ten minutes of drilling now can save you a restatement later.
| Passes | What it usually means |
|---|---|
| 6 of 6 | Your disposal is in good shape. |
| 4 or 5 | Most likely a presentation issue. The auditors will raise it, but the bottom line is right. |
| 3 or fewer | Something structural, usually in how the application deals with entities leaving the group. Fix it before the next disposal comes along. |
Keep track of one more number: the extra hours the disposal added to your close. You’ll need it in the last stage.
A consolidation lead can do all eight steps below with the access they already have. I’ve listed them in the order they’d happen during a real close.
Control passed on April 30. EuroParts’ P&L up to that date stays in the group, and its balance sheet comes out as at April 30. When a sale falls on the last day of a month, some groups treat it as effective from the first of the next month if the difference isn’t material. That’s a policy decision, so have your auditors agree it in writing. Every later step depends on it.
Open Manage Ownership, choose the Actual scenario, the current year and the period you settled on in step 1, and find the line where the parent owns EuroParts. Next to the ownership percentage you’ll see control, consolidation method, consolidation percentage and minority interest percentage. Set ownership to zero and FCCS fills in the rest from its method ranges.
Then look at the method it has picked. In a standard application that will be Not Consolidated; if Enhanced Organization by Period is switched on, it will be Inactive. Make sure it matches your accounting policy and override it if it doesn’t. Leave the Discontinued method alone, because Oracle’s documentation says it is reserved for future use.
Check the period before you save
FCCS stores ownership by scenario, year and period. A change saved against the wrong period will quietly rewrite a month you never meant to touch.
EuroParts and its parents will show as impacted. Run the consolidation. If the month had already been consolidated or locked, find out whether anything you’ve sent to management or the auditors is now out of date.
Run check three from the health check now, before going any further. If EuroParts’ pre-sale profit disappears from later months, resist the temptation to plug it with a manual entry every month. That points to a design gap in the application, which I’ll come back to shortly.
As far as FCCS is concerned, the parent’s gain is just a balance in an account. It has no idea a subsidiary was sold. Your journal is what brings the parent’s view and the group’s view together, and it has two jobs.
Post it against the parent entity, on whichever Consolidation member your application uses for parent-level adjustments. FCCS accepts journals at Entity Input, Translated Currency Input, Parent Input and Contribution Input, the last two only if they were enabled. Write a description a stranger could follow a year from now.
If NCI has simply vanished from the equity roll-forward, reclassify it into a disposal movement so the statement explains itself.
Suppose another group company sold parts to EuroParts on credit and the invoice is still open. Until April, that receivable was intercompany and eliminated on consolidation. From May it’s an ordinary trade receivable from an outside customer, and it has to stay on the group balance sheet.
The proper fix sits upstream. Change your data integration mappings so EuroParts is treated as a third party from the disposal date onwards. If that can’t happen before this close, post a reclassification journal for the month and get the mapping changed before the next one.
When EuroParts leaves, every one of its balance sheet accounts falls. Push those decreases through ordinary movements and the cash flow statement reads them as operating cash, so a drop in receivables starts to look like money collected from customers. Capture the exit in a disposal movement instead, so it appears as one net line under investing activities: the sale proceeds less the cash EuroParts took with it.
FCCS gives you seeded acquisition and disposal movements for this. The system member FCCS_Mvmts_Disposals is reserved for FCCS’s own calculations, and anything typed into it gets cleared, so manual entries and configurable rules belong in FCCS_Mvmts_Disposals_Input. If your application doesn’t use these members, reclassification entries will do the job.
Once all eight steps are done, run the health check again. A clean score is your proof that the fix worked.
Most teams can work through those eight steps on their own. The work we tend to be asked for sits around them.
The first piece is application design. A failed year-to-date check, or CTA and NCI that don’t move the way they should, usually traces back to how the application was built to handle entities leaving the group. We help put the right consolidation method, rules, movements and journal templates in place, so FCCS carries more of the load and the monthly manual fixes stop.
The second is a dry run. We take the disposal end to end in a test environment before it happens for real, so close week isn’t the first time anyone sees the numbers.
Integration is the third. Intercompany mappings and cash flow movements often live in the gap between the ERP and FCCS, where nobody owns them. We fix them where they start. And finally we package the lot: a disposal task list, a journal template and a tie-out pack your team can pull out for every future disposal.
Orbrick’s vision is to save our clients one billion life-hours, time they can spend on decisions rather than rework and reconciliations. A disposal process that’s right the first time and reusable afterwards is a small piece of that, but a real one.
The journal is posted and every check passes. This is the point where most teams close the file. I’d ask for one more hour. That hour is what turns a one-off fix into a repeatable process, and it gives you evidence of what the effort was worth.
The disposal month isn’t the end of it. EuroParts’ pre-sale profit has to stay in the YTD figures all the way to December, and year end is where anything that slipped through tends to show itself. Three recurring checks are enough.
| When | What to look at |
|---|---|
| Every month end for the next quarter | The intercompany matching report, for anything still sitting against EuroParts |
| Every quarter end | The year-to-date P&L test |
| Year end, before fieldwork starts | The complete six-check health check |
Expect a “show me” at some point. Having the answer ready in a folder is far easier than piecing it together in February. Mine holds eight things.
This is the step almost everyone skips. A team solves something genuinely hard, then never tells anyone what it was worth.
Go back to the close hours you noted during the health check and put them alongside three other measures.
| Measure | Why it matters |
|---|---|
| Extra close hours | The number a CFO grasps in seconds |
| Audit queries raised on the disposal | Tells you how clear your evidence really was |
| Manual adjustments needed | Shows how much FCCS did for you, and how much it didn’t |
| Restatements in later months | The price of anything that slipped through |
Your first disposal becomes the baseline. In an acquisitive group there will be another one, and when it arrives you’ll be able to say: last time this took so many hours and so many audit queries, and this time it took far fewer. A CFO understands that immediately, and it makes a far better case for investment than “the system is complicated”.
Sit down with the team before anything gets archived. Three questions cover it.
Then turn the answers into something you can reuse. If you run a close task list, build a “disposal of subsidiary” template with the eight steps and the health check in it, and save the journal as a template too. If the list of things fixed by hand turned out to be long, treat that as a sign the application design needs a closer look.
Prefer to watch? See the whole disposal process in one video
The same ground as this article, from the ownership change to the evidence folder.
| Stage | What it comes down to |
|---|---|
| Sense | Know what the right answer looks like and watch for the six symptoms |
| Evaluate | Snapshot first, then run the six-check health check |
| Execute | Eight steps you can do yourself, from ownership through to cash flow |
| Retrospect and refine | Keep checking until year end, build the evidence folder, measure the value and template the process |
If I had to boil this down to a single idea: FCCS is good at ownership and consolidation mechanics, and it knows nothing about the economics of your deal. That part stays with you. Know what the answer should be, compare it with what the system shows, and adjust for the difference.
Drop this into your close task list and reuse it for every disposal.
| Done | Task | When |
|---|---|---|
| ☐ | Agree the disposal date and period treatment with the auditors | Before close |
| ☐ | Export the baseline balance sheet and P&L; note net assets, NCI share and CTA share | Before close |
| ☐ | Plan the intercompany mapping change for the sold entity | Before close |
| ☐ | Check whether the sale needs discontinued operations presentation | Before close |
| ☐ | Confirm which disposal movement members your application uses | Before close |
| ☐ | Update ownership for the agreed period and check the method FCCS assigns | During close |
| ☐ | Reconsolidate impacted entities and flag any reports already sent | During close |
| ☐ | Run the year-to-date P&L test | During close |
| ☐ | Post the disposal journal: remove the double count, release CTA with the parent and NCI split | During close |
| ☐ | Reclassify NCI to the disposal movement | During close |
| ☐ | Treat the sold entity as an external counterparty in intercompany | During close |
| ☐ | Show the sale as one net investing line in the cash flow | During close |
| ☐ | Rerun the health check and record the extra close hours | During close |
| ☐ | Build the evidence folder | After close |
| ☐ | Monthly intercompany check for one quarter; YTD test every quarter end | Through the year |
| ☐ | Full health check before year-end fieldwork | Year end |
| ☐ | Hold the retrospective and save the task list and journal as templates | After year end |
Is a disposal on the horizon?
If your health check came back with more fails than you’d like, or you’d rather rehearse the disposal in a test environment before close week, have a conversation with one of our Delivery Leaders. We’ll look at how your application treats entities leaving the group and tell you what we’d change.
This article explains concepts only. The right accounting for your disposal depends on your facts, your accounting policies and your auditors’ view.
Mohit Khatri is an Senior EPM Consultant with Orbrick. He’s passionate about customer success, and is currently running an initiative to healthify all Bricksters by running our internal Health Competitions!
Actionable insights on ERP, AI and business solutions, straight to your inbox each month.
Subscribe for InsightsPick Orbrick as a preferred source and Google is more likely to show you our insights in Top Stories and AI Mode.
January 16, 2024
January 16, 2024
Be part of our growing community. Subscribe to our monthly newsletter and get actionable insights on ERP, AI, business solutions to optimize your ongoing operations
Subscribe for InsightsBegin your Business Value Maximization journey with us. Schedule a complimentary consultation today to understand how we make it a smooth ride for you.
Contact Us