Beyond the Trial Balance: The Role of Supplemental Data Manager

Nadia Lodroman | Oracle EPM Consultant | Integrity in Every Insight.

21 July 2025

Listen to Tresora and Ledgeron's chatting about this blog post:

Unlocking the Hidden Power of Your EPM Cloud for Granular Data Analysis

At its core, the Supplemental Data Manager (SDM) provides a structured and auditable framework for collecting detailed information that doesn't fit neatly into your standard chart of accounts. Think of it as a bridge between your high-level financial data and the granular details required for comprehensive reporting and analysis.

SDM utilises user-friendly web forms and templates, making it easy for business users to submit, review, and approve data. This ensures data quality and governance, creating a single source of truth for your supplemental data.

Broadening the Horizon: Collecting Financial and Non-Financial Data
The true power of SDM lies in its versatility. It can be configured to capture a wide array of information, empowering organisations to go beyond traditional financial reporting.

Enhancing Financial Detail
For financial close and consolidation, SDM can provide the necessary granularity for disclosures and internal analysis. Some common use cases include:
  • Detailed Breakdown of Reserves and Provisions: Instead of a single ledger balance for warranty provisions, you can use SDM to collect a detailed breakdown by product line, geographical region, or aging.
  • IFRS to Local GAAP Reconciliations: Capture the detailed calculations and narratives behind each adjustment, creating a clear audit trail.
  • Lease Accounting (IFRS 16/ASC 842): Manage the specifics of each lease contract, such as commencement dates, lease terms, and discount rates.
  • Fixed Asset Movements: Document the details of asset additions, disposals, and revaluations.

Embracing Non-Financial and ESG Reporting
In an era of increasing demand for Environmental, Social, and Governance (ESG) reporting, SDM is an invaluable tool for collecting and managing non-financial data. Examples include:
  • Human Resources: Headcount by department, gender, or location.
  • Environmental Metrics: Greenhouse gas emissions, water consumption, and waste generation.
  • Health and Safety: Number of workplace incidents and training hours.
By centralising this information, you can seamlessly integrate it with your financial data for holistic performance reporting.

Introducing Statistical Calculations
SDM is more than just a data repository; it allows for the introduction of statistical calculations that can provide deeper insights. Within the SDM forms, you can create calculated fields to derive new metrics.
For instance, if you collect regional sales data and the number of sales representatives in each region through SDM, you can create a calculated field for "Sales per Representative" (Sales-region​/Headcount-region​). This simple statistical calculation can offer valuable insights into regional sales force productivity.

Revolutionising the Tax Provision: Bespoke Calculations in TRCS
One of the most impactful applications of SDM is its ability to feed detailed data into the tax provision calculation in Oracle TRCS. This allows for the creation of bespoke calculations that automate and add precision to what are often manual and complex processes.

How it Works:
  • Data Collection: Use SDM to gather the specific details needed for a particular tax adjustment. For example, for the meals and entertainment expense disallowance, the general ledger might only contain a total expense figure. Through SDM, you can collect a detailed breakdown of these expenses (e.g., client entertainment, staff events, travel-related meals).
  • Integration with Tax Automation: The data collected in SDM is directly accessible within TRCS. You can then write custom tax automation rules that reference these detailed figures.
  • Bespoke Calculation: Continuing the meals and entertainment example, a tax automation rule can be configured to take the total from the ledger, apply the detailed breakdown from SDM, and automatically calculate the non-deductible portion based on the relevant jurisdictional tax laws.
This approach significantly reduces manual intervention, minimises the risk of errors, and provides a clear and auditable calculation trail for tax authorities.

A Clearer Picture: Detailed Breakdowns of Financial Categories
SDM provides a powerful mechanism for creating detailed breakdowns of various financial categories, offering transparency and simplifying analysis.
  • Current Tax Provision: Use SDM to collect the details behind the current tax expense, such as the breakdown of taxable income, tax rates by jurisdiction, and the application of tax credits.
  • Deferred Tax: Capture the movements in deferred tax assets and liabilities at a granular level, detailing the temporary differences by category (e.g., fixed assets, provisions, tax losses). This allows for a more detailed and auditable deferred tax roll-forward.
  • IFRS to Local GAAP Adjustments: SDM can be used to create a detailed schedule of all adjustments, including the nature of each adjustment and its impact on the financial statements and the tax provision.
By leveraging SDM to provide these detailed breakdowns, finance and tax teams can move away from offline Excel schedules and create a more integrated and efficient reporting process. The ability to drill down from a high-level consolidated number to the underlying supplemental data provides unparalleled transparency for both internal management and external auditors.

Ready to transform your financial reporting? Reach out to Nadia Lodroman at www.lodroman.com to learn how Supplemental Data Manager can benefit your organization.

Turning financial complexity into operational clarity. Because in Finance, Integrity is Permanent.

General EPM Strategy FAQs

  • Why should a company use EPM Automate instead of custom scripting

    EPM Automate allows for robust, bi-directional data orchestration between Oracle EPM and source ERPs (like NetSuite or Fusion) using native capabilities. It is highly scalable, easier to maintain during Oracle's monthly updates, and avoids the fragility of heavy custom coding.

  • Can Oracle Cloud EPM integrate with multiple different ERPs simultaneously?

    Yes. Through strategic data pipeline architecture, Oracle EPM can ingest, consolidate, and even write-back finalized data to multiple disparate ERPs concurrently, acting as the single source of truth for the enterprise.

  • How does Oracle FCCS handle Minority Interest (NCI) and CTA?

    While standard FCCS provides out-of-the-box functionality, complex global enterprises often require advanced configuration to isolate and calculate Minority Interest (NCI) and Cumulative Translation Adjustments (CTA) accurately at the top consolidated hierarchy without relying on manual journals.

  • Can you bypass the out-of-the-box Goodwill calculation in Oracle FCCS?

    Yes. By utilizing advanced native configuration and custom consolidation rules, you can bypass standard Goodwill Input/Offset functionality to meet highly specific, non-standard acquisition accounting requirements.

  • How many daily transactions can Oracle ARCS process?

    Oracle ARCS is built for enterprise scale. With proper architecture in the Transaction Matching engine, ARCS can easily process and auto-match hundreds of thousands of daily banking transactions, representing billions of dollars in value.

  • What is the difference between Transaction Matching and Reconciliation Compliance in ARCS?

    Transaction Matching automates the high-volume, line-by-line matching of data (like daily bank feeds or ACH). Reconciliation Compliance is used to govern the period-end justification of broader balance sheet account balances.

  • Does Oracle TRC handle Country-by-Country Reporting (CbCR)?

    Yes. Oracle Tax Reporting Cloud (TRC) provides built-in frameworks to automate Country-by-Country Reporting, ensuring multinational organizations remain compliant with global BEPS (Base Erosion and Profit Shifting) regulations.

  • How does Oracle TRC integrate with FCCS?

    TRC and FCCS share the same platform architecture, allowing for seamless data flow. Finalized pre-tax consolidated data from FCCS feeds directly into TRC for tax provisioning, ensuring perfect alignment between the finance and tax departments.

Still have a question?

Contact me

All things Oracle EPM

A screenshot of the Oracle EPM Data Integration interface highlighting the use of Split expressions

The Evolution of Data Orchestration

by Nadia Lodroman • 7 March 2026
Discover how to overcome faulty source designs in ARCS Transaction Matching using Source and Target Expressions in the new Data Integration interface. Improve performance and reduce administrative tasks.
Pillar Two Strategy, using CbCR for GloBE compliance. Shield, globe, and gears on a block.

Leveraging CbCR as the Foundation for GloBE Compliance

by Nadia Lodroman • 5 March 2026
Is your CbCR data robust enough to trigger the Pillar Two Safe Harbour? We analyse why CbCR is the only foundation for GloBE compliance, saving you hundreds of data hours.
Architecture diagram showing how an Oracle FCCS custom consolidation rule

Bypassing the Default Goodwill Reclass with Custom Consolidation Rules in Oracle FCCS

by Nadia Lodroman • 3 March 2026
Learn how to use Configurable Consolidation Rules in Oracle FCCS to bypass the default Goodwill offset and route intercompany investments to Paid-in Capital.
Show More