How to show how much the employee was paid for the job

Our employees track time spent on different jobs for customers. They are paid a salary. If we break out the hours spent on each job in their paycheck, do we have to put in an hourly rate? What if they work more than 40 billable hours and then some admin time on top of that? If I populate thepaycheck from the timecard, it puts in a total number of hours. I can split the hours per job but I have to associate a dollar amount to the rate. This will calculate in the paycheck. I want a way to show how much the employee was paid for the job when I look at what the job cost. How can I do this?

Report Abuse

3 Replies

Accountant Man

Accountant Community AllStar

12/02/09 8:03pm PST

I am a CPA who records my time and my employees' time per client. So the timesheet has multiple lines it in, one per client worked on each day. When I bill the client, the time shows up in the invoice, which is then totaled and the total fee is charged.

When I receive the payment from the client it is recorded as income, and when I pay the employee the payroll expense is recorded. Then I look at a P&L and I can filter the P&L to show one client, which has income and payroll expenses.

But I pay hourly, and each hour has a charge associated with it. I am not sure about salaried employees.

If you use Pro Series Basic I might not be able to help you. If you use Turbo Tax I might refuse to help you. All others, watch out! ;-)

Report Abuse

Lsimms

New Member

12/03/09 12:26pm PST

In our case, we have the employees rate of pay and also their billing rate. They normally work over 40 hours so if we import the timesheet into the paycheck, it shows total hours per company but it is calculated and sill exceed their salary. Since the client only pays the billable rate, we are trying to figure out a way that we can show what we actually paid the employee for each job. e.g.

20 hours companya

30 hours companyb

the employee is actually only paid for 40 hours and if we import this information from the timesheets into their paycheck, it will try to calculate 50 total hours. We are hoping that we can put both their billable rate (which would reflect in the invoice) and their hourly rate. Thank you for responding.

Report Abuse

NLevy

Contributor

12/03/09 1:50pm PST

Latest post

Best Answer - Chosen by the Community

You may be able to use this QB add-on - excel time sheet program. You will use these time sheets for employees to create their hours but not use it to actually pay the salaried employees. You can use a workbook page to total by job, and then apply a percentage allocation by hand entering the job income total, or exporting a quick books report to a consolidation page in the workbook. I considered using this for similar task because of its low cost but never actually implemented the system that way. It is available as a trial, so you can see if it can do what you want. I have not found any efficient tool to solve this issue - there are time sheet programs that are very expensive that can handle it separately, or build your own excel workbook. www.bigredconsulting.com/

NanseaLevy
- If we knew what it was we're doing, it would not be called Research. - Albert Einstein

Report Abuse

RSS