Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In the Analyze Data From and To fields, select the start and end dates, respectively, of the date range for selecting the cost data. Generally, it is a month.

In the Expense Items for Allocation pane (to the left), click the Fill by Accounting Data button to populate the list of expense items for allocation. Only expense items for which expenses were recorded in the selected period appear in the list; then, you can remove the unneeded expense items (by using the context menu that opens on right-click) or add other items (by using the Add button). Alternatively, you can manually create a list of expense items (whose amounts you need to allocate) by using the Add button.

...

The Factor column contains the proportion coefficients to be used to allocate the amounts to projects. By default, the sum of all allocation factors are is equal to 100 divided by a number of projects – with these factors, all the amounts will be evenly entirely allocated to the listed projects. If needed, you can edit the factors to change the proportion.

The last row shows the sum (auto-calculated) of all factors. Notice that it is not mandatory to keep the sum of factors equal to 100.

In the process of allocation, the amount to be allocated to a specific project will be calculated as the allocation source amount divided by the sum of factors and multiplied by the factor specified for the project. Note that the resulting amounts can be manually adjusted.