Invantive EstateThis section contains information about the functions which can normally be found under the menu item ‘Management Information’. This chapter contains information about the reports for financial management and control. These functions are normally used by the project developers and the financial department.
Aggregation levels
Invantive Estate offers you reports on four different levels of aggregation. Level four provides the most detailed information, while level one is the most summarized version.
Calculation Deviation
The main function of Invantive Estate is determining the prognosis of the result of a project. The difference between the prognosis and the budget is called ‘deviation’.
A project has several sides when looking from a financial point of view:
•The initial prognosis of the result (the budget).
•The actual outcome of the result (the result).
•The interim estimate of the ultimate outcome (prognosis and its deviation from the budget).
The initial prognosis is usually determined by a project developer as an exposé which becomes a project after being approved. In the end, you can read from your general ledger what the final result has been. However, projects can take years and large fluctuations between the prognosis and the final outcome are not unusual if project results are not placed under tight control. Invantive Estate support you in managing and controlling project results based on the information known at reporting time.
Prognosis End of Work
The financial results (the so called ‘Prognosis End of Work’) of a project consists of:
The expected revenues
-
The expected costs
For finance, an other financial result is determined, namely taking into account the amount already processed in the results of the organization while the project is still running. This is, for example, important with an administration following the IFRS rules. In that case the result consists of:
The expected revenues
-
The expected costs
-
The already taken result
The expected revenues are the sum of the expected revenues registered on all costs types in the master roll ups of the type ‘Revenues’.
The expected costs are the sum of the expected costs registered on all costs types in the master roll ups of the type ‘Costs’.
The already taken result consists of the sum of all invoice lines registered on costs types in the master roll ups of the type ‘Results’.
Deviation from a Cost Category
The deviation of a cost category is determined by the following calculation rules:
Depending of the project settings for the ‘release of deviations’ (see Projects) only negative or also positive balances are included in the calculation of the deviation of a cost category:
•Displaying is turned on for the entire project: for all cost categories negative and positive remainders are included.
•Display is turned on for ‘Cost Category’ for the entire project. If display for cost category is turned on or revenues are involved, then positive and negative remainders are included. If display for cost category is turned off and no revenues are involved, then positive and negative remainders are replaced by 0.
The remainder before the settings regarding displaying are executed, is calculated as follows:
Cost category budget
-
Approved budgets on specific contracts
-
Spend budget outside the contracts with specific budgets
+
Deviation contract with specific budgets
The deviation for contracts with specific budgets, is calculated as follows:
contract budget
-
Spend budget
The budget spent on contracts are calculated as follows:
The largest of:
•Latest estimate, if present.
•If the absolute amount on invoices with orders is greater than the absolute amount of orders, contracted revenues or budgeted revenues: then take the amount of invoices with order.
•If the revenue is not bound to a contract yet (only budgeted), there are invoices attached and the revenue has the attribute ‘1 period’: take then the amount of invoices with order.
•If not, take the amount for orders, contractual revenues or budgeted revenues. Plus the amount for invoices without order.
Merging Subprojects
Master projects consist of several subprojects, with each subproject having its own financial administration. Within the master project no financial numbers can be registered. Usually subprojects are separately financially reported. However, if in My Preferences the option ‘Merge Subprojects’ is turned on, then only master projects and independent projects are reported. The deviation of a master project is calculated as follows:
•Take a subproject.
•Make the cost category unique by assigning a unique prefix.
•Calculate the deviation like normal.
•Do the same for all subprojects.
•Offset all deviations.
