Content
You are here:
time and costs h/$
Added by Anton Grinchik 2 months ago
Hi there!
We would like to implement a functional calculation of the employee costs by a simple formula: number of tracked hours *employee hour rate. We analyzed the Spent Time and Time and Cost functions, but found a functional link of costs not to an employee, but to project phases and cost groups. Please share if there is a function in the OP and if so. how it can be configured (for example, specify employee hour rate of specific employees)
Replies (6)
Hi Anton,
the cost report allows you to display the costs per user based on the logged time for this user and their hourly rate. Just navigate to the global cost report ( [ ⁝⁝⁝ ] - button next to the search bar) and select the time and costs. There, filter for the desired user account and select all possible activities (this rules out unit costs). Then choose the rows and columns you want to see in your reports, select cash value and click on apply.
Example:
This reports displays the sum of all costs (booked time * hourly rate) per user per project and an overall sum.
Please find here more information on time & cost reporting: https://www.openproject.org/docs/user-guide/time-and-costs/reporting/#time-and-cost-reporting
Best,
Alexander
PS: The guide on how to define hourly rates can be found here: https://www.openproject.org/docs/user-guide/time-and-costs/time-tracking/#define-hourly-rate-for-labor-costs
Hello, Alexander!
Thank you for answer and sorry for our duscussion interrupting. We have read all the information you provided us-it has been very useful. The same time, we have one unanswered question.
We would like to link the hourly rate to the employee on a permanent basis, regardless of the project or issues type. Is it possible to implement this?Sincerely, Anton.
Hello Anton,
to set an hourly rate valid for all projects for a certain user, navigate to Administration -> Users and permissions -> Users. There, select a user and open the rate history tab of the user profile. You can add a default rate there. This rate will be applied for all projects as long as you do not define a different rate for a certain project in the list underneath.
Example:
This user has a default rate of 50 EUR for all projects. That is why 50 EUR is also mentioned in the projects listed underneath (projects of this user). If you add a different rate e.g. under "A new project" (see above), than the new rate will only be applied for this certain project. All other projects still apply the default hourly rate.
Further information on this can be found here: https://www.openproject.org/docs/system-admin-guide/users-permissions/users/#rate-history
Best,
Alexander
Thank you very much! You helped a lot. However, after implementing this setting, we suddenly realized that the number of hours in each month is different, please tell me if it is possible to set the employee's salary for the month so that openproject in time and costs gives the result of how much the employee's work on different projects for a given month will cost? In this case, the price of one working hour will vary depending on the number of working hours per month. It would be very convenient and would help me optimize the calculations before providing them to customers. Thank you very much.
I would also like to adjust the number of working hours in months in the calendar, but I encountered a problem that I can't install part-time job.
Hi there! Could you answer my questions?
Hi Anton!
The current way to see how much an employee's work will cost, is to use the cost report filtered by the user of this certain employee.
For example, create a cost report and use the user filter to select a certain user, then, select the columns and rows you want to see in this report and opt for a cash value calculation ⤵️
You could use further filters like date(spent) to display only costs of this employee for a certain month.
The price of a working hour currently can only be determined by the hourly rate set for a user. So you can set different hourly rates per user per project but not derive an hourly rate based on the booked hours in total yet.
If you could describe a user story and acceptance criteria for this use case, I would be glad to see your feature request submitted for this. Please find here a short guide on how to submit such a request: https://www.openproject.org/docs/development/submit-feature-idea/#submit-a-feature-idea
Best,
Alexander