Simple but perhaps obvious question... (not a feature request)

126 views
Skip to first unread message

Tim

unread,
Jan 17, 2013, 6:22:57 PM1/17/13
to erpnext-u...@googlegroups.com
Hello-
In the ongoing effort to move all of our business processes into ERPNext, we're at the point where we've gotten staff to start entering their hours in the system daily - requisite for the type of contracts we have. But I think I'm missing a piece that someone with an accounting background would know instinctively; how do I connect hours billed against an ongoing task's budget?  Basically, employee X works 25 hours for client Y with a ceiling of $25,000.. how do I map (and deduct) those hours from a project, assuming I've set it up correctly?

I have to define an hourly rate for each employee, and be able to run some sort of weekly report that shows a breakdown of hours vs. tasks.  

Apologies if the answer is obvious, but I'm a software guy not an accountant. I've read and re-read the help file and snooped around the forum as well, and I'm still stuck.  

Thanks for reading all this..

Tim


Rushabh Mehta

unread,
Jan 17, 2013, 9:19:13 PM1/17/13
to erpnext-u...@googlegroups.com
Tim,

You are right about the missing link. We would be happy to take this opportunity for completing the project-time sheet-billing link.

I have some questions:

1. Do you bill per task or based on timeheet?
2. In the sales invoice do you show how much each person has worked or you show the task. Or do you bill for the entire project?
3. In the timesheet, do you capture both billable and non billable hours.
4. Do you submit timesheets to the customer?

We will update the hours and cost to the project. Will post you as soon as its done. Probably next week.

Thanks!

best,
Rushabh

Sent from mobile

Timothy Baker

unread,
Jan 18, 2013, 3:33:22 AM1/18/13
to erpnext-u...@googlegroups.com
Rushabh,

To answer your questions:
1. We bill per task; an employee's day can either be split among multiple tasks or devoted to one.
2. Sales; we invoice monthly but only bill aggregate hours worked across the company. We do, however, have to keep a record of who worked what task and for how long to be compliant with legal obligations.
3. Yes, both billable and non-billable.
4. No, but we do have to store them for several years in the event of an audit. It's common in our field (gov't contracting) to have our timekeeping practices audited regularly. 

Thank you very much!!

Tim


Rushabh Mehta

unread,
Jan 20, 2013, 11:37:46 AM1/20/13
to erpnext-u...@googlegroups.com
Tim,

Thanks for this insight.

Will update the feature this week.

thanks,
Rushabh



W: https://erpnext.com
T: @rushabh_mehta

Timothy Baker

unread,
Jan 20, 2013, 1:45:11 PM1/20/13
to erpnext-u...@googlegroups.com
No, thank you Rushabh.. our end users are very happy.  This was our final obstacle..

Tim

Rajesh Sadashiven

unread,
Feb 11, 2014, 8:09:56 AM2/11/14
to erpnext-u...@googlegroups.com
Hi Rushab

Could you please do let me know whether it is possible to maintain  OT Hrs entry for my  Workers at factory to calculate the month end payment. I know that it is not available in your attendance app.

Please comment

Rajesh

Umair Sayyed

unread,
Feb 11, 2014, 8:40:27 AM2/11/14
to ERPNext User's Forum
Hello Rajesh,

You can track employee's working hours in Time Log. A report can be made on Time Log to see total hours employee worked for in a month.

http://erpnext.org/time-log

If total hours worked is more than standard, then Earning Type of Over Time should be added manually in the employee's salary Slip.


--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/f9cfbfc4-4329-403a-883a-09ecd15d8be9%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
Thanks and Regards,
Umair Sayyed
www.erpnext.com
Reply all
Reply to author
Forward
0 new messages