Project Settings

Click a cog wheel icon on the Navigation Menu to open application and project settings.  

General tab

On the general tab, you can enter the name of the business or legal entity, currency settings for financial information presented on reports.

Currency settings encompass the currency symbol and the currency multiple. For instance, if you plan to represent an amount of 1,234,567 EUR as 1,235 EUR on your reports, select x1000. This setting is independent of the internal currency symbol and multiple, which you specify on the New Project Screen.

If you intend to present information on generated reports in a different currency, make sure you provide an FX rate and set the appropriate currency symbol beforehand on this tab. BizController will use the same FX rate for all periods to express the figures on reports in that currency.

It is important that the currency settings for internally stored data (system currency) match the currency unit used in your Excel calculations which will be used as the assumptions layer for your financial plans.

Similarly, historical data figures entered into the system must be expressed in the system currency. When the Import wizard is used, however, to import data from a file, it is possible to adjust the multiple during the import process.

·         The FX rate and currency settings for reports can be changed at any time.

·         The system currency settings can be adjusted when a new database set is being created. These settings will not be available for change after that.

Period tab

On this tab, the user can set the period type (month or quarter) and the number of calendar month or quarter in which the financial year is supposed to end. If the entity’s financial year coincides with the calendar year, then the user should choose 12 or 4 for a monthly or quarterly setup, respectively.

Period type and financial year settings can be adjusted when a new database set is being created. These settings will not be available anymore afterwards.

The Time Horizon (Planning Horizon or Analysis Time Span) settings allow the user to define the maximum time span that will be used in reports. These settings can be changed at any time.

·         The Time Horizon settings affect the system performance. Shortening the time horizon will make the application work faster.

·         The Time Horizon can be set to the maximum of 72 periods, i.e. 6 years for the monthly planning setup and 18 years for the quarterly planning setup.

·         Unless BizController is used for a newly established entity, the Time Horizon should include at least one historical period (containing actuals) to ensure continuity of balance sheet data.  Use the Historical Info module to enter or import actuals and the opening balance figures.

The Plan Start Period determines which source of information is relevant for a given period within the Time Horizon.

For historical periods, only the data from the Historical Info Module (containing actuals) are taken into calculations. Beginning with the Plan Start Period indicated by the User, the system uses prospective information based on Excel assumptions as defined by the user.  

There is no risk of planned transactions being added on top of historical ones, even if they are “overlapping”. For any given period, the system either takes actuals from the Historical Info module, or prospective information from other modules, and never both. This makes updating financial plans easier because the user does not need to replace the planned figures which have become outdated with actual figures in their Excel spreadsheets, as it is often done by financial analysts and accountants.

The Plan Start Period setting can be changed at any time. Make sure that actuals are available for all relevant past periods to avoid information “gaps” between historical and planned data.


Click a cog wheel icon on the Navigation Menu to open application and project settings window. Some changes made to these settings are stored in the program and affect all databases used with it, while others are project-specific.

Click OK to store the new settings.

Some changes will require the program to restart.

General tab

Specify a name to show on top of published reports and a presentation currency. If the presentation currency is different from the internal currency, you need to specify a common exchange rate. The presentation currency will then become available for selection on the Parameters Pane. See the next section for further details.

Period tab

Specify the time horizon for your calculations, including any historical periods you wish to keep on your reports. Indicate the first period based on planned data.

You can change these values as time passes and new historical data or planning data become available. See the next section for further details.

xlSync tab

Header labels:

BizController employs a technology that relies on tags to identify data for synchronisation.

First, it scans the registered spreadsheets and tries to find the cell containing the workbook tag (<3e> by default, but it can be changed to any text value) The workbook tag tells the program that the worksheet may potentially contain data to fetch and that it should look for column headers in the same row. Next, BizController tries to find column headers. The default names of columns can be changed or reset on this tab.

Default folder:

The default folder is one that is displayed when the Add Sheets window shows. (xlSheet > Add Sheets).

Controlling Thresholds tab

Controlling thresholds are used to generate controlling reports. There are two types of controlling reports – Two Column Comparison and Controlling Dashboard. They are used to compute variances between two sets of data which are presented either as figures in separate columns (column by column) or as colours overlaid on base figures, respectively.

Controlling thresholds (two upper levels and two lower levels) define value ranges represented by a specific colour and are compared against computed variances in a report. If a variance falls in a given range it will be marked with the respective colour.

The Controlling thresholds set in Settings are default values assigned to newly created lines in the Template Editor and are expressed as percentages. Nevertheless, the Templates Editor allows the user to adjust these values individually for each reporting line.

Click the default percentages to change them. There are separate settings for each type of account/reporting line. Click on an arrow on the right to change the selected colour.

Reporting Lines tab

The tab defines default colours for each level of aggregation on report templates that are built using the Template Editor (0 to 9). A line receives the default colour when it is added to the template for the first time, or every time when its level of aggregation changes. At the same time, it is possible to customise line colours individually in the Templates Editor.

Reporting line colours are used in the following types of report:

  • Simple

  • Two Column Comparison

Publishing to Excel tab

The tab contains settings that affect the way BizController works with Excel spreadsheets.

Select .xls format if your published reports are to be opened in Microsoft Excel XP, 2002, 2003

Select .xlsx format if your published reports are to be opened in Microsoft Excel 2007,2010

Select  Apply outlining if you want your reports in Excel to include grouping functionality.

Microsoft Excel supports up to 7 levels for grouping purposes. If you design templates which contain levels 8 and/or 9, then these levels will not be available for grouping after publishing to Excel.

This tab lets the User specify a folder location and auto-naming options for published reports when they are created.

GUI tab

The tab allows the user to change the interface language.

After changes are made, the application will be restarted automatically.

Advanced tab

Force Database Recalculation causes the program to recalculate all data.

·         The system automatically recalculates its database when it is necessary. Forcing recalculation is not normally required.

·         The recalculation engine is paused when you are not on the Reports Desk (Reports module). Switch to Reports Desk and wait a few moments for the system to recalculate.