You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

This tab of the document contains the following two panes:

  • Costs Before Allocation (upper pane): You can use this pane to create a list of GL accounts to be used as allocation sources.
  • Allocation Results (lower pane): For the GL account selected in the upper pane, you can compile a list of other GL accounts to be used as allocation targets.


The "Manual Cost Allocation (Create)" form. The Expenses tab

The Costs Before Allocation pane

Use the Add button on the pane's toolbar to add a new row to the table. Each row defines an source amount to be manually allocated.

In the GL Account column, select an account that will be used as an allocation source.

Note. The accounts listed in this document will not be involved in automatic allocation performed by the Month-End Closing service.

In the Department column, specify a department associated with the allocation source.

Notice in the Expense Analytics column, a number of bracket pairs (< >, < >, < >) designating the number of dimensions for the selected GL account. There can be one, two, or three dimensions depending on the selected GL account. Click in the Expense Analytics column, to open the Dimensions dialog box. Use this dialog box to select the dimensions that  precisely define the allocation source.

For example, the balance of the COS: Raw Materials account consists of the records structured as follows: Expense Item / Item / Business Activity / Amount.  If specific values for each dimension is specified, only records strictly matching the template will be used as the source. If, for instance, no specific business activity is selected, the records with all different   business activities and with no business activity will be used as the allocation source.

Click OK to close the dialog box.

In the Amount column, enter the amount to be allocated from the selected account with specified dimensions.

Add more GL accounts if needed for the allocation.

The Allocation Results pane

For each account in the upper pane, specify a list of accounts to which the source amount (specified in the Costs Before Allocation pane) will be allocated.

Use the Add button on the pane's toolbar to add a new row to the table.

The GL Account, Department, Expense Analytics columns show the information about the allocation source.

In the New GL Account column, select an account that will be used as a target for this allocation.

In the New Department column, specify a department associated with the allocation target.

Notice in the New Expense Analytics column, a number of bracket pairs (< >, < >, < >) designating the number of dimensions for the selected GL account. There can be one, two, or three dimensions depending on the selected target GL account. Click in the Expense Analytics column, to open the Dimensions dialog box.

Use this dialog box to select the dimensions that define the allocation target.

Click OK to close the dialog box.

In the Amount column, enter the amount to be allocated to the selected account with specified dimensions.

Add more target GL accounts if needed for the allocation.

Make sure that the source amount (in a row in the upper pane) is equal to the sum of target amounts in the lower pane.

The Allocation Results pane toolbar

Use the Arrow Up button to move the selected line up. Use the arrow down button to move the selected line one position down.

Click the Show All button to show target accounts for all source accounts in the same list.



  • No labels