Odoo Help


How do I use TAGS to allocate expenses to multiple dimensions? (Analytic Accounting)

David Taylor
on 9/1/16, 7:33 AM 1,965 views

I am trying to figure out how to allocate the same expense to different dimensions - eg. departments and projects. For departments the expense will be allocated on the basis of number of employees in each department; for projects it will be allocated on the basis of time.

I read online that this can be done with tags - but not exactly how to do it.

All suggestions and directions to related resources are welcome.

Hello David,

Would you please share the resources describing this possibility?



Keenmeng Lew
on 9/2/16, 1:33 AM


Keenmeng Lew
on 10/27/16, 7:40 AM

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 12/30/16, 9:12 PM

This is a complex (and probably not realistic) example but will explain the principles and get you started. You need Odoo 10 Enterprise Edition.

Departments A and B.

  • A has 10 employees (40%).

  • B has 25 employees (60%).

Projects: 1, 2 and 3.

  • 1 takes 50% of time.

  • 2 takes 30% of time.

  • 3 takes 20% of time.

Electricity Bill:

  • $5,000.

GL Accounts:

  • Expenses.

Analytic Accounts:

  • Electricity.


  • Dept A.

  • Dept B.

  • Prj 1.

  • Prj 2.

  • Prj 3.

In Odoo you can tag an expense with as many tags as you want, but you can't split it - you must do this by creating multiple lines on the Invoice.  Since you want 20%, 30%, 40%, 50% and 60% of the amount allocated, you can split the line into four - 20%, 30%, 20%, 30%.

  • 20% of $5,000 ($1,000) to Department A and Project 1 and Project 3

  • 30% of $5,000 ($1,500) to Department B and Project 1 and Project 2

  • 20% of $5,000 ($1,000) to Department A

  • 30% of $5,000 ($1,500) to Department B

The Invoice lines (use a product or not, as you need to) will look like this:

Then your reports will look like this:

I sometimes prefer to allocate to a group tag (e.g. corporate, project AB, ...) and you resplit amount at the end of the month based on your percentages. It's easier than splitting costs at each invoice

Fabien Pinckaers (fp)
on 12/31/16, 12:02 AM

Agreed. This may work better as often the split isn't known until month end (after sales, hours and pieces for the month are known)

Ray Carnes
on 12/31/16, 11:13 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/1/16, 7:33 AM
Seen: 1965 times
Last updated: 12/30/16, 11:59 PM