Getting Started with the Profit Center Model
Return to Profit Center Model Overview.
To get familiar with the Profit Center model you can install it with a sample configuration which includes sample data. Please note that you need to install the Jedox platform and the Demo content before installing models with sample data. You can find directions on how to configure the model with sample data in Setting Up the Profit Center Model. The model can also be set up without sample data. Follow the steps below to configure the model and populate it with your company's data.
The steps below explain how to configure the model and populate it with your own data.
Note that the instructions below are based on using an Excel workbook to collect relevant data and figures into worksheets and uploading them into the Jedox database. Jedox offers you a variety of ways to achieve the same goal, e.g. editing elements manually in the Modeler, defining a job in the Integrator to connect to your ERP. In the context of this article, we'll stick to using the Excel workbook - feel free to use the most appropriate method for your needs.
The Profit Center model comes with an Excel Workbook containing a sample configuration as well as sample data. You will find this in Jedox Web > Report Designer > Models
> Profit Center/Files/Sample Data/Profit Center sample data (IFRS)
. Save a copy of this workbook (using Export from the context menu) locally, edit it to replace the sample configuration and data with your own.
You can configure dimensions, as well as cubes by uploading your modified Excel workbook into the model you're working with via the steps below:
- Open Modeler > [Database Name] > Dimensions or Cubes > [Dimension's or Cube's name] and choose
Upload file
from the context menu. - The Dimension/Cube Upload Wizard opens which guides you through the steps.
- Select the modified copy of the workbook from your local file system. For details, see Uploading and Downloading Dimensions and Cubes.
Use the essential steps below for configuring the model and modifying individual worksheets in the Excel workbook:
1. Set up Model |
Install the model without sample data. For directions, see Setting Up the Profit Center Model. |
2. Set up Languages |
|
3. Add Legal Entities |
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 |
4. Adjust TimeSpan |
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 dimension. |
5. Change Forecast Versions |
|
6. Uploading Chart of Accounts |
The PC Account dimension contains the hierarchy for ledger accounts or reporting positions. You can do calculations on these accounts within the model as well as connecting/integrating accounts between models. You can edit accounts within the PC Account worksheet and upload them to the PC Account dimension with the upload wizard. When uploading the PC Account worksheet, check Allow multiple parents within one hierarchy in order to allow individual accounts to roll up into several reporting positions. |
7. Set Up Currency Conversion |
|
8. Set Up Allocation |
Organizations use allocation procedures to move amounts between profit centers or cost objects (aka cost units). You can update as well as execute the configuration of the allocation procedures using the Profit Center Allocation Configuration report. |
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. |
At this point basic configuration is complete! Follow the steps below to use the models:
11. Initial Data Import |
To import actual figures (e.g. historical data up to the most recent month) and the existing plans, use Upload file on the Profit Center cube. |
12. Import Actual Figures |
To import actual figures on a monthly basis you can use Upload file on the Profit Center cube. This is a quick way to get started, but if you want, for example, to enable daily reporting, you can extend this functionality by using an Integrator job that connects directly to your finance system or ERP and loads in automatically. |
13. Review the Actual Figures |
If you've imported actuals, multiple currencies may be required within the system before reviewing the figures. Access the Import Exchange Rates form within the Exchange Rates input screen to import the exchange rates into the system. You can then go to the Allocation Configuration report to run the batch procedures. Once that is completed, use the Profit Center Actual report to review current reporting positions in both local and target currencies. |
14. Do Mid-Term Planning |
If you need to do the mid-term planning, you'll have to prepare the system to receive data. Use the Exchange Rates input screen to update the currencies in your mid-term plan. Once that is completed, use the Profit Center Mid-Term Planning input screen to create and adjust the plan across multiple years. |
15. Create your Budget |
If you need to prepare your budget, you'll have to prepare the system to receive data. Use the Exchange Rates input screen to update the currencies in your budget. You can then go to the Allocation Configuration report to run the batch procedures. Once the updates are complete, use the Profit Center Budget report to prepare your company budget. |
16. Make your Forecast |
If you need to create a forecast, you'll have to prepare the system to receive data. Use the Exchange Rates input screen to update the currencies in your forecast. You can then go to the Allocation Configuration report to run the batch procedures. Then use the Profit Center Forecast Initialization form to populate the forecast version. Once you've populated the forecast version, use the Profit Center Forecast report to make updates. |
Updated March 19, 2024