How do I allocate indirect costs?
Overhead allocation takes the cost built up in an auxiliary department or project —rent, utilities, administration— and redistributes it among the main ones. It only moves cost accounting figures: the financial accounts don’t change.
What do I need before I start?
You need three things.
- Cost accounting active in your company. It is enabled in Accounting > Dimensions. With it inactive, allocating gives a warning and does nothing.
- The period’s costs already assigned to the auxiliary value. The allocation doesn’t invent amounts: it moves what has already been built up.
- The allocation criteria defined. Without criteria, the allocation warns you and does nothing.
Everything is done from Accounting > Overhead allocation.
How do I define the allocation criteria?
On the Overhead allocation screen, the Allocation criteria card holds the rules. Each rule says where the cost comes from and among whom it is shared out.
- Click Add rule.
- Choose the Dimension: Department or Project. A rule doesn’t cross the two axes.
- In Source (auxiliary) type the code of the value whose cost has to be allocated.
- With + Add target add one row for each value that receives it, with its Target (main) and its Weight.
- Click Save criteria.
The Weight is relative: it doesn’t have to add up to 100. It can be a percentage, or a physical key such as square metres, number of employees or hours. The program allocates in proportion to each target’s weight over the total of the weights.
When allocating, the rounding cents go to the last target in the list. That way the sum of the targets is exactly the amount of the source, with no one-cent discrepancies.
Each time you save, the criteria go up a Version. The version matters: it is part of the allocation’s identity.
How do I run a month’s allocation?
- Go to Accounting > Overhead allocation.
- Choose the Financial year, and the same month in From and To.
- Look at the Period status card to see whether that month has already been allocated.
- Click Run allocation. The question Allocate period …? appears.
- Confirm with Yes, allocate.
When it finishes, a summary appears with what has been moved.
Can I allocate a quarter, a half-year or the whole year?
Yes. Choose the first month in From and the last one in To: January to March for the first quarter, January to December for the year. All the months are allocated at once, or none of them if something fails.
Each month is allocated with its own cost. As the weights are proportional, the result is the same as allocating the quarter’s total in one go, and you can still undo a single month later.
If one of the months had already been allocated with the same criteria, it is left as it is and only the missing months are allocated. The Period status card shows how many months of the range are already allocated.
Undo allocation works the same way: it undoes every allocated month between From and To.
What exactly happens when I allocate?
The cost built up in the source value is credited and that same amount is charged to the targets, according to their weights. The source is left with a zero balance, but keeps its movement: you can see what it had and what went out.
What matters is what doesn’t happen:
- **No journal entry is created. The Accounting journal** doesn’t change.
- The balance of the expense accounts doesn’t change. Account 62 still has what it had.
- The balance sheet and the profit and loss account aren’t affected.
The allocation movements do appear in the Cost journal, with the Allocation label. They don’t have a journal entry number, because they don’t come from one.
What happens if I run the allocation twice?
It depends on whether you have changed the criteria between one time and the next.
- With the same criteria: nothing happens. The program replies that that period had already been allocated and doesn’t move a single cent. Repeating is harmless.
- With changed criteria: the program refuses and asks you to undo the previous allocation before running it again. That is what stops the cost from being counted twice.
That is what the Undo allocation button is for. It reverses all the period’s movements and leaves it as if it had never been allocated. You can then run it again with the new criteria.
Undoing and allocating again with the same criteria gives exactly the same result.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| ‘Cost accounting is inactive’ | It isn’t enabled in the company | Enable it in Accounting > Dimensions |
| ‘There are no allocation criteria set up’ | The Allocation criteria card is empty | Add at least one rule and save it |
| A message that says ‘Undo’ | That month was already allocated with another version of the criteria | Click Undo allocation and run it again |
| ‘had already been allocated’ | You have run it twice with the same criteria | There is nothing to do: nothing has been duplicated |
| ‘The allocation period must be between 1 and 12’ | You have chosen the closing period | The allocation only works on real months |
| ‘The "to" month cannot be earlier than the "from" month’ | The months are the wrong way round | Put the first month in From and the last in To |
| A message that says ‘Undo’ when allocating several months | One month of the range was allocated with other criteria; none has been allocated | Undo that month and run the range again |
| The targets don’t add up to what you expected | The Weight is relative, not a percentage | Check the sum of the weights of that rule |
See also: Assign costs by department and project
More about Accounting
- How do I depreciate fixed assets?
- How do I find a journal entry and correct it?
- How do I close and open the financial year?
- How do I view an account’s general ledger?
- How do I add a ledger account?
- How do I define the line items of the balance sheet and the income statement?
- How do I make a manual journal entry?
- How do I print or export what I see in accounting?
- How do I assign costs by department and by project?
- Keeping the accounts
- How do I write the notes to the annual accounts?
- What is the accounting dashboard?