# Allocations tab

{% hint style="info" %}
User permissions: Budgets & Forecasts and Manage Budgets & Forecasts
{% endhint %}

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

The Allocations tab ensures each area, such as a branch or department, bears its fair share of an allocated item, such as an expense. 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.

{% hint style="success" %}
Watch this Phocas demo video: [Simple and flexible allocations](https://www.phocassoftware.com/watch-demo/simple-and-flexible-allocations?autoplay=true)
{% endhint %}

## Prerequisite <a href="#add-the-allocation-tab" id="add-the-allocation-tab"></a>

The Allocations tab works by allocating between entities in a main (top-level) [dimension](/financial-statements/getting-started/overview-of-the-link-between-financial-statements-and-dimensions.md#dimensions) that sits between the **Category** and **Account** dimension levels. Common allocation dimensions include **Branch** or **Department**.

You can't use dimension groups (also called child dimensions or sub-dimensions) as the allocation dimension.&#x20;

For example, in the images below, you can't use any of the dimensions sitting under the Account and Trading Entity dimensions. You can, however, use Trading Entity or any of the other top-level dimensions, such as Department.&#x20;

<figure><img src="/files/HDfEYc8ovjSeNEB8fEWF" alt=""><figcaption></figcaption></figure>

If you select an unsuitable dimension in the hierarchy of budget setup, the Allocations tab won't be available.&#x20;

<div align="left"><figure><img src="/files/Xj8lZFo1oSiFlcQy3Beq" alt="" width="361"><figcaption></figcaption></figure></div>

To activate the Allocations tab, complete one of these prerequisites:

* **Add an existing dimension**: If a suitable exists in the underlying database, add it as a level in the [budget workbook setup](/budgets-and-forecasts/owner-and-administrator/edit-a-budget-or-forecast-workbook-setup.md). Be aware this change is [destructive](/budgets-and-forecasts/owner-and-administrator/edit-a-budget-or-forecast-workbook-setup.md#destructive-changes).
* **Create a new dimension**: If no suitable dimension exists, create a separate parent dimension (for example, Cost Centre) and change the budget setup to use it. This change is also destructive.

## Add the Allocation tab <a href="#add-the-allocation-tab" id="add-the-allocation-tab"></a>

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. Either click the **Budget** menu > **Add tab** or click the **Add tab** button (at the bottom of the workbook), then select the **Allocations** tab type.&#x20;

{% hint style="warning" %}
If the **Allocation** tab isn't available, it means the budget workbook setup doesn't have a main (top-level) dimension between the Category and Account dimension levels. See the prerequisites section above.&#x20;
{% endhint %}

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 <a href="#set-up-a-grouped-allocation-rule" id="set-up-a-grouped-allocation-rule"></a>

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.

<figure><img src="/files/HzPI9eAzaIWuEZe6MXKn" alt=""><figcaption></figcaption></figure>

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**.

   <div align="left"><figure><img src="/files/23WB9jpVZasTOcoppZ0l" alt="" width="375"><figcaption></figcaption></figure></div>

   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.

   <div align="left"><figure><img src="/files/EXWWoOpCmUkqEQxUOUth" alt="" width="375"><figcaption></figcaption></figure></div>
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**.

   ![](/files/kthSnCCYqOBQiGee0tej)

### Set up an individual allocation rule <a href="#set-up-an-individual-allocation-rule" id="set-up-an-individual-allocation-rule"></a>

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 <a href="#explore-the-allocation-tabs" id="explore-the-allocation-tabs"></a>

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.

![](/files/lb0WTO8T2nVl2LYbcqD2)

### Allocations tab <a href="#allocations-tab" id="allocations-tab"></a>

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.

![](/files/mcbalPYCzFkRvZwRaIYf)

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 <a href="#allocations-assumptions-tab" id="allocations-assumptions-tab"></a>

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.

<details>

<summary>Example of editing allocation costs</summary>

Suppose you decide that you no longer want to allocate the costs equally between trading entities but instead allocate in proportion to their revenue.

1. Ensure the Main tab is in post-allocation mode; otherwise, the values in the **Allocations (Assumptions)** tab will be read-only.
2. Open the **Allocations (Assumptions)** tab.
3. Edit the percentages as required. In the example below, you enter a [formula](/budgets-and-forecasts/contributor/edit-values-in-a-worksheet/use-formulas.md) into the first period cell of the AUS Trading row that references the sales values in the Main tab to calculate the AUS Trading sales as a percentage of total revenue. Australia, the UK plus US plus Australia.

   ![](/files/rRLQUOsvdtAe9ABhtWqO)
4. Repeat the above step to edit the allocations for the other rows (entities).
5. Select all the edited cells (in the first period column) and copy them forward across the period.

   ![](/files/7DvizkSaubNdh6HhXhhl)

You can then see that based on a revenue allocation, AUS Trading is now going to get 45.23% of the UK Holding's remuneration.

Back on the Main tab, the changes are automatically reflected in the post-allocation values. For example, the pre-allocation remuneration value for AUS Trading is 2,717,099, but in post-allocation mode, it is 3,480,113 (the pre-allocation value plus 45% of the UK Holdings remuneration costs).\
![](/files/uyVsBVxaY54vSNusm3m4)s![](/files/lhP45E8qbElz8qmjddJq)

</details>

## View allocations on the Main tab <a href="#view-allocations-on-the-main-tab" id="view-allocations-on-the-main-tab"></a>

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.

![](/files/VDZoJIzXUo9od17Z3prJ)

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 <a href="#troubleshooting" id="troubleshooting"></a>

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.

   ![](/files/LOC0pCHueKNtLTarIehS)

   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.

   ![](/files/hFr9gTyvd9WRVnOpiBFh)
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.

   ![](/files/zQSOYzoMlALu7GxRdt2k)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/add-worksheet-tabs/allocations-tab.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
