Invoice based on time-sheet and cost vs revenue analysis in OpenERP 7.0

It is very difficult job to calculate the cost of employees / consultant who is working on the projects and find out the margins on each invoice to the customer monthly, quarterly or half yearly or may be yearly. OpenERP is giving you a control over such situation where you can have everything in your hand to view and control over your margins.

OpenERP 7.0 made it very simple and easy to manage the costing / margin for projects through contract, it also supply automatic monthly invoicing to customer but that I will show you in future post. Here i would like to show you to manage the cost center using contract.

In order to have invoicing functionality you should enable the open “Allow invoicing based on time-sheets  under Settings/Human Resource, once you enable you should get Employee Time-sheet in Human Resource and Contract enabled under the Sales Application.

Lets create a contract or you can have the same functionalists on Project Issue or Project Task, I am taking contract as it will be easy to understand.

OpenERP Contract for Axelor - Word Plugin
OpenERP Contract for Axelor – Word Plugin

Now, allow your employee to do an entry on the contract which is Word Plugin. So employee will fill daily time-sheet and cost the related contract / project. Lets do some time-sheet entry

Employee Timesheet entry
Employee Timesheet entry

As and when required, you can review the contract and prepare an invoice based on the time spent for that contract, of course you contract should allow you to do invoicing based on the time spent. You can configure that under Invoicing section “On Timesheet” on contract.

Invoice based on timesheet entries
Invoice based on timesheet entries

In order to review your cost and margin for the contract visit contract and click on the Costs and Revenues button. You can task it as below by month by journal will give you monthly cost and revenue. Here is this case Timesheet is showing the cost and Sales is showing the Income.

Cost and Revenue analysis for contract
Cost and Revenue analysis for contract

You can go the video below to understand full flow of the configuration and cost analysis.

4 thoughts on “Invoice based on time-sheet and cost vs revenue analysis in OpenERP 7.0

  1. Hi, as you knoe, I’m following all your Blog posts, I have a simple question about a typical workflow with several steps involved like Quotation, SO, RFQ, PO, MO etc etc… Which means the process is often waiting for other steps to be finished. If different people working on the different steps, how the other user knows about a particullar step is finished? I.e. The goods are shipped, Delivery Order is printed and the Sales guy could generate an Invoice. Or auto invoice step ha genereated a new draft invoice. It would be great to use the same NEW notifications in the left side menus as used in you inbox. Do you know how this works? I can’t see this notifications for regular business Documents.

    See also: http://help.openerp.com/question/22916/how-to-inform-salesteam-of-delivery/

    Many Thanks, Holger

  2. In your example and screenshot, there is only revenue: there is no cost and so no margin.
    What is the intent of this post actually?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s