Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
DRAFT: Use the Allocations tab to split costs, revenue, and other items across locations or departments in your organization. For example, you might have head office costs such as marketing and advertising that you want to divide up amongst your retail branches.
For example, suppose your head office has a cost pool of 1 million dollars to spend on Marketing expenses but each of the individual branches pays their share of that cost. The proportion each branch pays could be a percentage, or it could be based on their revenue, margin, or headcount value.
The Allocations feature allows you to view the raw data from ERP alongside the refined data in Phocas. The allocations you set up in Budget and Forecasts are available in Financial StatementsTo get the best allocation experience, we recommend you use grouped allocation rules.
Add the Allocation tab
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, select the Allocations tab type, then click Add.
Click Add allocation, then select one of these allocation rule options:
Grouped: Allocates a group of costs in the same way. The source cost matches the destination, for example, the allocation of the Head Office Remuneration account to the remuneration accounts of each branch.
Individual: Allocates costs 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 cost is different from the destination, for example, the allocation of the Head Office Loan Interest account to the UK branch’s Foreign Exchange account. Grouped: Allocates a group of costs in the same way. The source cost matches the destination, for example, the allocation of the Head Office Remuneration account to the remuneration accounts of each branchTypically, this option is only used in complex (tall) account structures.
Set up a grouped allocation rule
In the Allocation tab setup, click Add allocation > Grouped.
In the Profit and Loss statement that displays, locate and select the applicable cost account(s) to allocate from and click Allocate From.
Click the Edit button in the top-right of the grid and select To. In the list that displays (trading entities), select the applicable items, then click Allocate.
Image Added
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. You can edit the accounts that you're allocating to or delete individual allocations as required (see below).(Optional) Edit the name of the allocation group to something more descriptive. Click the group header and overwrite the name.
Click Save and finish.
Set up an individual allocation rule
In the Allocation tab setup, click Add allocation > Individual.
In the Profit and Loss statement that displays, locate and select the applicable cost account(s) to allocate from and click Allocate From.
Click the Edit button in the account row in the grid and select To. In the list that displays (trading entities), select the applicable items, then click Allocate.
NOT FINISHED
Explore the allocation tabs
After you complete the allocation setup, two worksheet tabs are automatically generated for you.
Allocations tab
The Allocations tab outlines what is happening to each account that you selected in the setup. This might be useful for troubleshooting purposes but typically, you won't need to use this tab 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.
Allocations (Assumptions) tab
The Allocations (Assumptions) tab outlines how you want to allocate your costsgroups. You can edit the values in this tab (when in pre-allocation mode) to change the way in which the costs items are allocated. Your changes are automatically reflected in the Main tab , (when in post-allocation mode).
Expand | ||
---|---|---|
| ||
After you set up the allocations, you can For example, you might decide that you no longer want to allocate the costs equally between trading entities but instead allocate in proportion to their revenue.
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,). |
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.
ManageEdit or delete allocations
You can return to the Allocation tab setup to add more costs to your allocation groupsedit a rule, add more groups, or edit or delete mappings.
Click the Tab menu or right-click the Allocations tab name, then select Edit tab setup.
In the following example, three allocation rules were created.
Add or remove items to be allocated (From)
Add or remove destinations, such as regions or business entities (To)
Create new rules
On this page
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|