Allocations

With the allocation functionality, you can allocate values from a source, based on a weight factor, and then add the new values to a target.

For example, you can take all costs for one administrative unit in a group, and distribute that cost proportionally to a key factor to a specific account for either all or some subsidiaries.

You can use allocations between companies and accounts, and between extended dimensions.

You can include allocations in the consolidation process and schedule them as batch jobs.

The allocation definition, including the job definition, is imported or exported as part of the structures in Maintain > Transfer > Export Structures and Maintain > Transfer > Import Structures.

  • You can only use account type I, C and the equivalent statistical accounts (T, U).
  • All allocations will get a unique journal number between 1-99.
  • You can export and import allocation definitions. For more information, see Export Structures and Import Structures.
  • Allocations are always executed before intercompany eliminations and acquisition calculations.
  • An allocation can not be the basis for automatic journal type 70 (Transfer of untaxed reserves), as both automatic journals are on ID level 0.
  • Allocations on cross-owned companies will succeed (on the top level) if the company has method P on the level where the ownerships meet. Allocating to companies within an E or S group from a higher level will result in offset problems and likely also incorrect net income.
  • Historical rates are currently not supported.
  • For allocations, the companies are defined in the allocation definition. This differs from the other consolidation steps, where, at runtime, the companies involved in the consolidation are selected by defining the Group and Consolidation Type. To successfully book an allocation, both the source and the target companies must exist within the consolidated group.

Special considerations when using allocations for companies consolidated with the equity and proportional method

Having allocations as the base for AJT 60, the equity method, is not recommended, since it will result in a rest value on the allocation offset account on the group level.

Having allocations as the base for AJT 40, the S method, is not recommended, since it will result in a rest value on the allocation offset account on the group level.