Odoo Help


This community 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.


Track profit on jobs

on 2/23/14, 1:43 PM 767 views


I am loving OpenERP for sales and accounting. I was wondering what is the correct way to analyse the sales, costs and profits on each job that I do?

I often do jobs for repeat customers and often for new ones. I buy stock and resell it as well as adding services along the way. So I have purchases which I mark up and resell, as well as time spent on each job and I want to see what profit I am making per job. So the formula is Invoice value, less purchases for that job, and if possible less hours

Hope someone can advise



Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 8
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo USA

Fabrice Henrion (fhe)
On 2/23/14, 8:43 PM

Before I start, there seems to be a mistake in your calculation because invoice value and purchase are dollar amounts but hours are a number of hours, so your calculation wouldn't make a lot of sense. Therefore, I will assume that you want to track these data separately.

You should use analytic accounting. Create a parent analytic account per customer, and in that account you can have multiple ones if you want to track several different things per customer. You could also have a sub account per job/contract. It is really up to you how you want to organize this hierarchy of accounts. But the way you will want to use them is by specifying these accounts in corresponding PO lines (for what you purchase in amount), SO lines (for what you sell in amount), and contracts (for your hours and to track them). Note that a contract is an analytic account in OpenERP so it will show in your hierarchy if you decide to use them, which can be very convenient. You will then see the result (debit and credit) for each customer or for each job (depending on how you organize your hierarchy of accounts) on the parent account. You can then filter which customers are the most profitable, which ones should be dropped because not profitable, visualize this as graphs, include this in your daily dashboard,...

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 2/23/14, 1:43 PM
Seen: 767 times
Last updated: 3/16/15, 8:10 AM