Allocations tab

Managing multiple entities within a single organization is crucial for accurate financial budgeting and forecasting. Whether dealing with different branches, subsidiaries, or departments, the ability to efficiently allocate resources is an important part of the budgeting process.

The Allocations tab, available in financial budgets and forecasts, allows you to split costs, revenue, and other items across different areas of your organization. This ensures each area, such as a branch or department, bears its fair share of that allocated item and as a result, you can create more accurate budgets and forecasts. The Allocations tab is particularly useful in multi-branch businesses where certain expenses, such as advertising or administrative costs, are incurred by the head office but need to be allocated to all retail branches.

Add the Allocation tab

You can create grouped allocations, where multiple accounts are allocated in the same manner, or individual allocations, where specific accounts are handled separately. To get the best allocation experience, we recommend you use grouped allocation approach.

1. Add the tab using one of these methods:

   • Click the Tab menu > Add tab > Allocations.

   • Click the Add button at the bottom of the workbook and select Allocations.

2. Click Add allocation, then select one of these allocation rule options:

   • Grouped (recommended): Allocates a group of accounts in the same way. The source account matches the destination, for example, the allocation of the Head Office Remuneration account to the remuneration accounts of each branch.

   • Individual: Allocates accounts on a case-by-case basis. This option is suitable when you want the allocation behavior of a single account to be different from all other grouped allocation rules. The source of the allocation is different from the destination, for example, the allocation of the Head Office Loan Interest account to the UK branch’s Foreign Exchange account. Typically, this option is only used in complex (tall) account structures.

Set up a grouped allocation rule

Allocation groups sit at a specific dimension level. The levels correspond to those in the workbook setup. If you have multiple hierarchy levels in the workbook, you must specify this level before adding any allocation group rules.

Open

1. In the Allocation tab setup, select the grouping level from the drop down list in the top-right corner.

2. Click Add allocation > Grouped.

3. In the Profit and Loss statement that displays, locate and select the applicable account(s) to allocate from and click Allocate from.

4. Click the Edit button in the top-right of the grid and select To. In the list that displays, select the applicable accounts, then click Allocate.

   Open

   

   
   In the grid, you'll see an allocation group with the accounts you’re allocating from, and underneath, you'll see where those accounts are being allocated to.

5. (Optional) Edit the name of the allocation group to something more descriptive. Click the group header and overwrite the name.

6. Click Save and finish.

Set up an individual allocation rule

1. In the Allocation tab setup, click Add allocation > Individual.

2. In the Profit and Loss statement that displays, locate and select the applicable account(s) to allocate from and click Allocate from.

3. Click the Edit button in the account row in the grid and select To. In the list that displays, select the applicable accounts then click Allocate.

4. Click Save and finish.

Explore the allocation tabs

After you complete the allocation setup, the two Allocations tabs appear in the workbook: Allocations and Assumptions. The purpose and use of each tab differs depending on whether you added group or individual allocation rules.

Allocations tab

The Allocations tab outlines what is happening to each account that you selected in the setup.

In group allocations, this tab might be useful for troubleshooting purposes but typically, you won't need to use it often. For example, in the image below, the group is allocating everything evenly. Taking a closer look at the first row, you can see that in July, the UK holding entity has $666,778 for salaries (100%) which will be allocated evenly to three trading entities, each one getting 33%. To see exactly how much each of the UK holding salaries entity will get, hover over the border line on the left of the Total column and click the pink Allocation button that displays. Because, in this case, the salaries are being allocated evenly, each entity will get 22,259 to add on top of their original budgeted salaries.

In individual allocations, this tab is where you edit the allocations. By default, the values in the From accounts are allocated evenly across the To accounts. When in pre-allocation mode, you can edit the percentages in the To account rows (as indicated by the yellow cells) to change the way in which the items are allocated. Your changes are automatically reflected in the Main tab when you view it in post-allocation mode.

Allocations (Assumptions) tab

The Allocations (Assumptions) tab is applicable to group allocations only. This tab is where you edit the allocations. When in pre-allocation mode, you can edit the percentages in the To account rows (as indicated by the yellow cells) to change the way in which the items are allocated. Your changes are automatically reflected in the Main tab when you view it in post-allocation mode.

View allocations on the Main tab

On the Main tab, use the Pre allocation / Post allocation button at the top to switch between viewing the pre-allocation and post-allocation values.

For example, in the image below, in pre-allocation mode, the total remuneration is $12.6 million, with $1.6 million for UK Holding. In post-allocation mode, the total remuneration remains the same but there’s nothing in for UK Holdings, as it's now sitting in equal proportions with the three trading entities.

The values in the Allocations (Assumptions) tab are not editable when you are in post-allocation mode. Switch to pre-allocation mode to activate the cells for editing.

Troubleshooting

1. Why can’t I edit the values in the Allocations tab?
   Firstly, ensure you are in pre-allocation mode. Click the Pre/Post allocation button at the top of the workbook.

   Secondly, ensure you've been assigned to the rows in the workflow.

2. I’m an administrator and I added the Allocations tab but I can’t edit any values there.
   By default the workflow sits with the budget owner, so you need to assign yourself to the row(s) to put them in edit mode.

3. Why can’t I see the allocations in the Main tab?
   Ensure you are in post-allocation mode. Click the Pre/Post allocation button at the top of the workbook.

On this page