Description
For our direct client we are looking for candidates (Freelance) that fit the following profiles:
1) Check capacity for HFM architecture review - Technical
Capabilities:
- Full understanding of technical setup of HFM
- Financial background
- Understanding how to automize consolidation steps in the system
- Able to review simple solutions and use best practice with ability to advice management on improvement potential
Tasks:
- From the download I see a lot of hierarchies with different structure setup. entity tree setup - so far the current one could be used, but seems that they use several data consolidation levels with several uploads/copies per country, but let's check the right setup for the new acquisitions and if they can use adjustment levels better. Today they have 130 entity members therefore
- Setup of COA Hierarchy and members-Logic for financial accounts, they have a lot non-financial accounts, which I can not see if they are used, some of these are really nice to have. Should be checked. There are 4898 different accounts
- Setup for Intercompany accounts reconciliation including new acquisitions companies in submodule
- Review data source (trial balance Local Gaap, adjustments, Management Gaap)
- Upload of data always YTD or added monthly and check for active and non-active data
- Currency maintenance
- Review consolidation feature setup and automatic booking setup
- Review custom dimensions, the first one I do not understand, the second one looks like customer profitability analysis - check for data source recon
- Scenarios look ok (actuals, forecast, budget, plan)
- Overall review if they are not yet on the cloud version, if a transfer with only clean setup and data would make more sense
2) Check capacity for operational HFM capacity
Capabilities:
- Full consolidation process knowledge required in an multi currency environment
- Financial background with main focus on accounting
- HFM implementation and user maintenance knowledge to run HFM
Tasks:
- Check Group management accounts for information required
- Setup and review mapping of local COA to Group chart of account - align with new accounting manual and possible add on's, add accounts for one off's P&L and balance sheet - group to decide if this is a one off to be booked
- Review for input flat file including data for intercompany account reconciliation (using the intercompany module) as well data levels (input level is the local trial balance, adjustments to group Gaap, Group level accounts per country)
- Review and document efficient consolidation process in HFM
- Review and document acquisition balance sheets and PPA adjustments - use HFM functionality without excel for elimination and equity reconciliation
- Check on trial process for manual journal entries during consolidation in HFM
- Review Management reporting versus setup for statutory/fiscal consolidation at year end close - check if adjustment levels can be used
- Setup standard Management Balance sheet, P&L and Cash flow in Hyperion as well some non financial date for checking - review possibilities if formula can be added in HFM (Spread %, EBITDA% etc.)
- Review to setup cash flow module with Treasurer
3) Check capacity for closing process.
- Aim is to get back to a monthly close, including reconciliations - use as training to align accounting practise - together with Internal auditor, Spanish as additional language would be a nice to have.
Capabilities:
- Accounting background
- Financial management knowledge
- Process improvement manager - accounting processes
Tasks:
- Review new accounting manual
- Train group and local companies on group manual
- Review accounting processes and check for efficiency gaps
- Review reconciliation process to align sub ledgers to general ledgers on a a monthly basis and check suspense accounts and daily cash book reconciliation. review stock reconciliation and revaluation porcesses inventories, FX etc.
- Determine manual entries and try to eliminate as much as possible or setup approval and documentation process - separate accounts required in case of booking to sub ledger accounts
- Review again account mapping to group chart of account for HFM