Author: Mubarak Kolawole, EPM Practice Lead – Consolidation, Namos Solutions
Introduction
Month end is always a pressured window for finance and admin teams especially when it comes to managing intercompany activity across multiple entities. Consolidation reports play a key role in confirming whether intercompany receivables and payables line up, yet the process often involves more manual effort than necessary.
A recent update from Oracle changes that. Substitution variables can now be applied directly within intercompany matching reports. This important improvement removes manual steps whilst reducing risk and helps teams move through month end with more confidence and less administration.
What Intercompany Matching Reports Do
Intercompany Matching Reports help teams review whether two entities agree on the balances they hold against each other. For example, if one entity records a receivable of 100, and the partner entity records a payable of 80, the report highlights a difference of 20.
These reports make it possible to spot mismatches quickly, understand whether they are timing issues or genuine errors, and decide what needs correcting before consolidation takes place. They act as a simple, reliable point of reference during month end and guide users to the areas that need investigation. Month end is already packed with fixed deadlines and tight turnaround times. Any friction in this process slows everything down.
The Pain Points for Admin Teams
Before this update one of the biggest frustrations for finance teams was the amount of manual effort involved in keeping intercompany matching reports up to date. Each report had a fixed period set inside its configuration, which meant that every time the month changed, the admin team had to open each report and update the period manually.
For organisations with several versions of the report this became repetitive and time-consuming. It could easily take an hour during a month end window where every minute matters. There was also a real risk of missing a report, which meant users might open it and unknowingly view data for the wrong period.
It was a small task but it added unnecessary pressure at a time when teams already have limited time to complete their month end responsibilities.
Substitution Variables (SubVars)
Substitution Variables, often called SubVars, act as a global placeholder inside an EPM application. Instead of hard-coding a date such as “September”, into every report, a SubVar can be created to represent that date.
Once that variable is set, any reports linked to it will automatically pick up the correct date. When the month changes, the admin team only needs to update the variable in one place. Every connected report updates instantly in the background.
This functionality already exists across other areas of the EPM suite, where it is widely used to reduce manual work and improve consistency. Until now, the intercompany matching reports were one of the few areas that did not support it.
What This Means for Organisations
The introduction of SubVars into intercompany matching reports removes a regular source of friction at month’s end. Instead of updating each report one by one, admins can adjust a single variable and know every linked report is immediately aligned with the correct date.
This reduces the amount of manual work, cuts down on the chance of mistakes, and frees up time for more meaningful tasks. It also gives end users greater confidence that what they are viewing reflects the right date without depending on behind the scenes adjustments.
Across busy month end cycles, even saving an hour can make an impactful difference. This update helps teams work faster, avoid errors, and maintain a smoother reporting process overall.
How We Can Help
If you want support configuring SubVars, reviewing your consolidation setup, or streamlining your wider month end processes, our team can help. We work with organisations across all stages of their EPM journey, From small configuration updates to full process reviews.
If you would like to discuss how this update could benefit your environment, get in touch with us and we’ll be happy to guide you.
