PlaniFi offers the below pre-packaged solution to get you started with Consolidations on SAC. We offer both quick start programs and small-to-medium pre-packaged managed implementations. Reach out to [email protected] for more information.
Business Requirements:
- Companies requiring standalone consolidations; companies requiring planning, consolidations, and analytics in one solution
- BPC, HFM / Essbase, One Stream replacement or end of life
- Consolidating Multiple Local Chart of Accounts
- Consolidation process and rules in the Cloud –
- Consolidations close process flow and status dashboard
- Legal and Management Intercompany Eliminations
- Automated Rollforwards and Cash Flow
- Top-side Journals, Allocations
- Currency Conversion, CTA calcs, Historical Overrides
- Constant Currency Analysis
- Consolidations controls, validation and sign off
- Print ready financial statements and book publishing
- One source of truth for Reporting, Analytics, Statistical Data (HC / Product)
Solution Goals:
- Provide end to end consolidations solution for companies requiring:
- standalone consolidations applications
- planning, consolidations and analytics in one solution
- Separate process flows to guide corporate, subconsolidations and end users through their consolidations close
- Allow for decentralization of the consolidations process including local ownership and sign off on submitted financials
- Streamlined, automated consolidation calculations
- Cash Flow, Retained Earning / Carry Forward, IC Elims, FX calculations
- Allow for simple journal entries, overrides, and top-side adjustments
- Provide print ready, drillable reports for both executive reporting and entity level review
- Financial book publication; includes commentary collection for board reporting
- Project Metrics (typical):
- Remove maintenance costs for internal infrastructure and IT resources
- Eliminate manual overhead in collection of local data
- Eliminate manual processes in the consolidations close
- Stop paying for extended maintenance
- Drive accountability and reduce risk for errors and omissions
- Industries – All
Admin Prep Includes
- Submitting FX Rates
- Open period
- Data Action to populate Beginning Balances R/E and Override Carryforwards
Entity Consolidations Includes
- Importing local data to the consolidation system, review account mappings
- Submitting Journals
- Input statistical data
- Data Action to trigger consolidation calculations (FX / RE / CTA / etc)
- Data Action to run IC Elims
- Input Rollforward data
- Data Action to trigger Cashflow calculations
- Approve / Lock data
- Reports / Controls along the way to validate the process
- Financial Reporting Summary
Corp Consolidations Includes
- Intercompany Matching report
- Submitting Topside Journals
- Override inputs
- Data Action to trigger consolidation calculations (FX / RE / CTA / etc)
- Data Action to trigger Cashflow calculations
- Reports to review Financials, including KPI’s, BS, IS, CF, and IC review.
- Final Published Book
- Finalize / Lock data
Solution Prerequisites
- SAP Analytics Cloud Planning Licenses
- Data, Connections
- HANA connector / install to broker connection between systems
What’s Included
- Model, Calculations, Templates
- Sample Data Set
How do you deploy the solution?
- Consulting Services
- Deployment, Training
- Infrastructure, Managed projects (Design, Delivery, Deployment), standard training and enablement
- Customizations
- Dimension / Templates – adjust per your structures
- Process – adjust to your business requirements
Supported Data Sources
- Any Structured General Ledger Data Source, Excel, Flat File, SAP ERP, SAP BW / HANA
- Standard Accounts and dimensionality to support consolidations, including company, profit center, cost center, flow, etc.