PlaniFi Consolidations

PlaniFi Consolidations · Pre-packaged consolidation on SAP Analytics Cloud

One platform for the close, the plan and the reporting.

PlaniFi Consolidations is a pre-packaged consolidation application that runs on SAP Analytics Cloud. Consolidation rules, eliminations, roll forwards, cash flow and top-side journals sit in the same place your team already plans and reports from.

What the application delivers

What changes for the finance team that runs the close, rather than a list of features.

The whole close sits in one place

Workflow, account reconciliation, intercompany matching, the consolidation itself and the group reporting all run on one platform. Close status lives in the same model as the numbers, so where the close stands is not a separate spreadsheet.

One set of numbers, not three

Planning, analytics and consolidation run together, so there is no shuffling data between a planning tool, a reporting tool and a consolidation tool to make them agree.

Entities and group close together, not in sequence

Group and entities work the same governed process with one audit trail, rather than group waiting for entity submissions and reconciling them at period end.

Statutory and management consolidations, with nothing bolted on

Both views come out of the same application: the statutory consolidation for the external numbers and the management consolidation for how the business is actually run. Eliminations, minority interest, constant currency, CTA, automated cash flow and the group report book are core to it. No third party product is required to produce the group numbers or the statements that come off them.

A route off an end-of-life platform

BPC, Oracle HFM, Essbase and OneStream customers move to a supported platform without rebuilding the consolidation from scratch.

The close, end to end

The group close runs in five stages. PlaniFi carries all five, which is the point: the workflow, the reconciliations, the matching, the consolidation and the reporting are one application rather than a chain of them.

1

Entity close

Local books closed: accruals, depreciation, FX valuation, GR/IR clearing and carryforward. The postings happen in the ERP; PlaniFi carries the workflow, the ownership and the status.

2

Account reconciliation

Balances substantiated against the support behind them, for any account rather than only the statutory ones.

3

Intercompany

Differences found, explained and agreed between trading entities. Mismatched charts of accounts, master data and partner identifiers are harmonized first, then matched by amount.

4

Consolidation

Group numbers produced from the entity numbers: legal, management and tax eliminations, minority interest, constant currency, CTA, automated cash flow and top-side journals.

5

Group reporting

Results published, compared and explained: statements, comparative, trended and consolidating report books, bridge and price, volume and mix, with commentary against the numbers.

Where the general ledger stops

You run the company with the ERP and manage it with EPM. The general ledger is the transactional system of record for entity-level accounting, and it can post some elimination entries, but it is not a group consolidation and reporting tool. Multiple ERPs and multiple local GAAPs have to come together somewhere, and that is this application.

Three process flows, each with its own workflow

The close is not one queue. It runs as three process flows, each supported by a workflow that carries the sequence, the ownership and the status, so every role can see where its own part stands without asking.

Setup and administration

Consolidation manager. FX rates, the close calendar, the workflow itself and beginning balance carry forward.

Supported by the AI agent. Most of this is now driven by the PlaniFi Month End Close Agent, which runs the close steps in a fixed order every month rather than someone working down a checklist.

Entity submission

Local controllers. Statistical inputs, trial balance, intercompany matching and eliminations at the common parent, validation controls, roll forwards and automated cash flow.

Group consolidation

Corporate. FX overrides, non-controlling interest, the consolidation calculation, matrix consolidation, publishing the report book and locking the period.

Where AI fits in the close

The close is one of the few finance processes where AI has somewhere obvious to land, because the steps repeat every month and the data is already governed. Two of our four AI pillars run straight through this application, and a third shapes how it gets built.

SAP Business AI, embedded in the process

The intelligence arrives with the platform the close already runs on, rather than as another product to buy, integrate and govern separately. Same data, same security model, same licensing.

Agents that run the process

The PlaniFi Month End Close Agent is the first of these in the close: it runs the steps in a fixed order every month, and the status sits with the numbers rather than in a side spreadsheet.

AI in how we deliver it

The build itself uses it. We apply AI to how we configure, test and document the application, so the project carries less manual effort than a traditional implementation and your team spends its time on the accounting rather than the tooling.

These are part of a wider picture. The four pillars, and the data foundation underneath them, are on the AI overview.

The modules that add to it

PlaniFi Consolidations is the core application. Each module below adds to it and is bought separately, so you take the ones the close actually needs.

PlaniFi Data Consolidator

Finance owns the mapping. Rule based mapping with ranges and wildcards, a coverage check that surfaces every unmapped record before the data is consumed, and drill back from any group account to the local accounts behind it.

PlaniFi Intercompany Matching and Reconciliation

Harmonizes mismatched charts of accounts, master data and partner identifiers first, then matches by amount. The harmonizing is the hard part.

PlaniFi Account Reconciliation

Certifies that account balances are supported, in a uniform cycle every period, with the review recorded.

PlaniFi Month End Close Agent

Runs the close process itself, in a fixed order, every month.

Where it runs

The application runs on SAP Analytics Cloud, with SAP Datasphere underneath it, both inside SAP Business Data Cloud. That is the same architecture, the same interfaces and the same licensing as the rest of the PlaniFi EPM line, so the close is not a separate platform bolted to the side of your reporting.

PlaniFi Consolidations inside SAP Business Data Cloud Consolidations is one application in the PlaniFi EPM line running on SAP Analytics Cloud, alongside financial and departmental planning and analytics. The Month End Close Agent runs the close above it, and three engines work against SAP Datasphere underneath. SAP S/4HANA data arrives as data products, and other ERPs come in through custom data products or a connection. Source systems SAP S/4HANA Integral to the platform. Arrives as data products. Other ERPs NetSuite, Dynamics, Sage, Oracle and others. Custom data products or a connection. SAP Business Data Cloud SAP Analytics Cloud PlaniFi Month End Close Agent ↗ Financial and departmental planning Analytics and reporting Consolidations Engines ↗ PlaniFi Data Consolidator Mapping and transformation ↗ PlaniFi ICMR   Intercompany matching ↗ PlaniFi Account Reconciliation Balances substantiated SAP Datasphere Harmonized models and data products. One copy of the data, no replication. ↗
Consolidations is one application in the PlaniFi EPM line, sitting alongside financial and departmental planning and the analytics your team already uses, all on SAP Analytics Cloud with SAP Datasphere underneath and all inside SAP Business Data Cloud. The Month End Close Agent runs the close process above it. The three engines do the work against the data in Datasphere. SAP S/4HANA data arrives as data products with no copy to maintain, and other ERPs come in through custom data products or a connection.

Where this connects to the wider PlaniFi line

The full product line, including the planning applications that share this platform, is on the pre-packaged solutions overview.

What comes in the application

Everything below is part of the package. Nothing here is a separate purchase except where the footnote says so.

Consolidated statements and management reporting

Income statement, balance sheet and automated cash flow, at both local and group level.

Data Consolidator *

A business-owned mapping process that standardizes one common set of reporting structures, so you can report on both the consolidated and the local chart of accounts.

Journal entry module

Top-side and management journals with a governed lifecycle: create, post, unpost, lock and auto reverse, each with a unique journal ID, change history and stored comments. Drill from any figure in the statements to the journals behind it, in original and converted currency.

Eliminations and intercompany matching

Legal, management and tax eliminations, segment eliminations, and the intercompany matching report that feeds them.

Supplemental inputs and roll forwards

Statistical data such as headcount and product, roll forward schedules and cash flow adjustments.

Month end validation reporting

Checks that the balance sheet is in balance, statistical inputs are entered, roll forwards tie to the ending balance from the general ledger, and elimination accounts balance.

Consolidation calculations and configuration

FX rates, non-controlling interest, cash flow configuration and elimination configuration.

Approve and lock historical data

Periods are closed and locked, so a published number does not quietly change afterwards.

* For multi-ERP situations an extra license is needed. See PlaniFi Data Consolidator.

This is not standard content

Packaged content that ships with a platform is written once and then waits for the next release. This is not that. The content behind PlaniFi is based on more than a hundred implementations and a few hundred close cycles, and every one of them feeds back into it. It is actively maintained, improved, extended and optimized rather than frozen at the moment a template was first written.

That matters most in the places a template cannot anticipate. A chart of accounts nobody designed on purpose. An acquisition mid-year. A cash flow that has to tie three ways. Those are the cases the application has already met, because someone else met them first and the answer went back into the product rather than into one client’s custom build.

What you need in place

We can help with both.

  • SAP Analytics Cloud planning licenses
  • A connector to serve as the connection between systems

Supported data sources

Any structured general ledger data source is supported, including NetSuite, Microsoft Dynamics, Sage, Oracle and SAP, so basically any accounting system. Standard accounts and dimensionality to support consolidations, including company, profit center, cost center and flow.

Talk to us

See it against your own close

Thirty minutes, your close calendar, and an honest view of whether this fits. No deck.

Prefer email? Write to contact@simplefisolutions.com.

  • Please use your work address. We do not send to personal mailboxes.
  • Do not polish it. We would rather see the real thing.
  • This field is for validation purposes and should be left unchanged.