Getting Started with the Financial Consolidation Model

2. Set Up Languages

1. Remove unnecessary languages from the model by going to Modeler → [Database Name] → Internationalization and selecting the language(s) you would like to remove and then Delete (-). Once the languages are removed from the model, attributes in the workbook using that language can be ignored. Columns that have been localized will have the attribute name followed by an @ symbol with the country code for the language in the format xx_XX. For example, attribute Label in the Version worksheet has localized columns Label@de_DE, Label@fr_FR, and Label@es_ES for translations in German, French, and Spanish respectively.
2. To add a language go to Modeler → [Database Name] → Internationalization and then New (+) to select the language you would like to add from the menu. Once the new language has been added, go to the worksheet of the dimensions and cubes you would like to update with the translations for the new language. For example, to add a new column to the worksheet for the Version dimension of the Name attribute in Portuguese (Brazil), you'd add Name@pt_BR.

Note that updating the model does not affect newly added languages, but it resets all other language settings and restores any previously deleted languages.

3. Set Up Scope of Consolidation

Legal Entity is a required dimension for the presentation of reports; it identifies a company or a group of companies within a report. You can edit it within the Legal Entity worksheet and upload it to the Legal Entity dimension with the upload wizard. Use the standard settings provided by the upload wizard to populate this dimension. Make sure that the Currency attribute is populated with local currencies. The Scope dimension contains all target elements for financial consolidation in a flat list. The Partner Entity dimension contains the elements that represent business relationships with others companies in a group. Finally, the Scope of Consolidation report shows additional parameters of the groups captured within the Scope of Conoslidation cube.

4. Adjust Time Span

The time span of the model can be adjusted to fit your organization's historical data and planning horizon in the Time Editor tab of the Month_YTD and Day dimension.

5. Maintain Versions

The elements in the Version dimension helps you to compare figures for reporting and planning. You can modify forecasts and other versions.

6. Uploading Chart of Accounts

You can upload a chart of accounts from any dimension involved in cash transaction. These may be the BS Account dimension, the CF Account dimension, or the PnL Account dimension.These dimensions contain hierarchies for ledger accounts or reporting positions. You can make calculations on these accounts within the model. You can edit accounts within the account worksheets and upload them to their respective dimension with the upload wizard. When uploading the worksheets, select Allow multiple parents within one hierarchy in order to allow individual accounts to roll up into several reporting positions.

7. Set Up Currency Conversion

1. When a company or a group of companies store accounting data, one currency like the Euro or Dollar, must be chosen. This currency which is called the Source Currency will be stated under the Currency attribute within the Legal Entity dimension. You have to update source currencies in the Currency worksheet and upload them to the Currency dimension of the model. Use the standard settings provided by the upload wizard to populate this dimension.
2. You need currency conversion when a source currency has to be converted into another currency for reporting purposes. The set of currencies available for conversion is called the Target Currency. To define target currencies you have to update and upload the Currency and Target Currency worksheets to the Currency and Target Currency dimensions.
3. You can import the actual exchange rates into the model by using the import exchange rates interfaces. All of the planning versions (Budget & forecast versions) can be set from the January average rate. You can load planning Exchange Rates_YTD via the Exchange Rates_YTD worksheet and upload them into the Exchange Rates_YTD cube.

8. Set Up Consolidation Rules

You must set up the consolidation rules according to the chart of accounts attributes in the Intercompany Account dimension, comprised of the CDIS hierarchies (Capital, Debt, Intra-group Results, and Sales).

9. Add Logo

Replace the Jedox logo within the web reports to your company logo. See Configuring Design Elements.

10. Change Cell Styles

Modify the default cell styles within the web reports to your company style. See Configuring Design Elements.

11. Initial Data Import

To import separate financial statements (e.g. historical data up to the most recent month) and the existing plans, use Upload file on the Profit and Loss cube. Alternately, you can use the Excel Workbook contained in the Sample Configuration as a basis for your own configuration. Go to Report Designer → Models → Financial Consolidation → Files/Sample Data/Financial Consolidation sample data (IFRS). Save a copy locally and replace the sample configuration and data with your own.

You can also use the interface to import manual journal entries into the posting journal.

12. Bring Balances Forward

You can bring the closing balances of the prior reporting period forward as opening balances of the current reporting period. You can do this in the Data Manager report.

13. Import Figures

You can import figures for any version (actual, budget, etc.) on a monthly basis by using Upload file on the Profit and Loss cube and the Balance Sheet cube. This is a quick way to get started, but if you want, for example, to run the consolidation on a regular basis, you can extend this functionality by using an Integrator job that connects directly to your existing accounting system and loads it automatically.

14. Review Imported Figures

Once you've imported your figures, multiple currencies may be required within the system before reviewing them. Access the Import Exchange Rates form within the Exchange Rates input screen to import the exchange rates into the system. You may use the trial balance report, as well as your separate (sep.) financial statement reports, to review the figures.

15. Run Consolidation

16. Review Consolidation

You can review the results through the created automated journal entries which are shown in the Consolidation Manager report. You may also use the Cons. Financial Statement report, as well as the following Cons. reports (Cons. Profit and Loss, Consolidated Financial Statement Report).