Skip to content

How do I assign costs by department and by project?

Cost accounting splits expenses and income across cost accounting dimensions: departments and projects. It is for knowing what margin each job or each section makes, without touching the financial accounts.

What do I need before I start?

You need cost accounting enabled in your company. It comes switched off by default. With it switched off, everything works the same but nothing is built up by department or by project.

To enable it, go to Accounting > Dimensions. At the top there is a panel that says Cost accounting inactive. Flip the switch and it changes to Cost accounting active.

Next to the switch there is a Require dimension checkbox. If you tick it, no expense or income journal line can be saved without a department or a project. It is the way to make sure nothing slips through.

You also need at least one department or one project set up.

How do I add a department or a project?

Go to Accounting > Dimensions. At the top there are two tabs: Departments and Projects. Each one has its own list of codes, independent of the other.

  1. Click New department or New project, at the top right. A window opens and the list switches by itself to the right tab.
  2. Type the Code and the Name.
  3. Click Save. If something doesn’t add up, the window stays open with what you typed and tells you the reason; Cancel closes it without creating anything.

The code accepts letters, digits, hyphen and underscore. It is turned into capitals by itself: if you type ventas, it becomes VENTAS.

The dot creates a hierarchy. If you add OBRA.123, the program also creates the group OBRA and hangs the new value from it. That way you can view all the jobs together by their group. Groups don’t receive direct assignments: they only aggregate.

How do I assign a department or a project to a journal line?

With cost accounting active, the Accounting journal has two more columns, after Description: Department and Project.

  1. Open or create the journal entry and type its lines as usual.
  2. On the line with the expense or income account, type the code in Department or in Project. With F2 or the magnifying glass you pick it from the list.
  3. Click Save.

Only expense and income accounts are assigned, that is, those in groups 6 and 7. On a line that has both halves, the columns belong to the half that is assigned: in a sale with the bank on the debit side and 705 on the credit side, the department goes to 705. On a line with no expense or income (bank, customer, VAT) both columns stay empty and accept nothing.

Once saved, the journal list shows in those columns which department and project each line went to.

If you have just switched cost accounting on with the journal open, leave the journal and come back in for the columns to appear.

How do I split a journal line across several departments?

At the end of the line, next to Suggest contra account, there is a button with an arrow that splits in two: Split account … across several departments or projects. It only appears on expense or income lines.

  1. Click it. A panel opens below with one row that already carries the whole amount of the journal line.
  2. Click Add line for each extra combination, and give each one its Department, its Project and its Amount.
  3. Click Apply breakdown and then Save the journal entry.

The split goes by amount, not by percentage. The lines must add up to exactly the amount of the journal line. If it doesn’t add up, the program rejects it when you apply it, and checks it again when you save the journal entry.

A split journal line shows Split in the columns; clicking it takes you back to the split. To leave it without a department or project, click Remove breakdown.

Which costs are NOT assigned?

There are three cases in which an amount doesn’t reach cost accounting, even if you have it active.

This last case is the one that causes most confusion. If your profit and loss by department doesn’t add up to the same as the profit and loss account, it almost always means there are unassigned expenses.

How do I see what has been assigned to a department or a project?

There are three places, depending on what you are looking for.

The value’s record. In Accounting > Dimensions, click the row. The record has the tabs Details, Cost accounting ledger and Profit and loss. The Cost accounting ledger gives the cumulative figure month by month. Profit and loss gives the income, the expenses and the Margin (income − expenses).

The cost journal. In Accounting > Cost journal. It is the list of cost accounting movements, with filters for From, To, Department, Project and Account. The Group by drop-down groups them by department, by project or by account. Clicking a line takes you to the journal entry that created it.

The profit and loss account. In Accounting > Profit and loss account. You choose the Dimension and the Value and click View. It gives income, expenses and margin, and for projects it adds the Breakdown by department.

In the cost accounting ledger and in the profit and loss, a group adds up all the values that hang from it: asking for OBRA adds up OBRA.1, OBRA.2 and the rest.

If something goes wrong

What you seeWhat has happenedWhat to do
The Department and Project columns don’t appear in the journalCost accounting is inactive, or it was switched on with the journal openEnable it in Dimensions and go back into the journal
‘Account … is neither an expense nor an income account’You put the department on a bank, customer or VAT linePut it on the line with the group 6 or 7 account
‘Enter the account of the journal line first’The line has no account yetType the account and then the department
‘Account … requires a cost accounting dimension’Require dimension is ticked and the detail is missingEnter a department or project on that journal line
The breakdown isn’t acceptedThe lines don’t add up to the amount of the journal lineAdjust the amounts until they add up
The journal entry isn’t saved and mentions the breakdownYou changed the amount of the journal line after splitting itOpen the breakdown again and adjust it
The Cost journal comes out emptyThere are no expense journal lines with a dimension in that rangeCheck the dates and that the journal lines have a dimension
The profit and loss doesn’t match the profit and loss accountThere are expenses with no department or projectFind them and assign them

See also: Allocate indirect costs · Make a manual journal entry

More about Accounting