cancel
Showing results for 
Search instead for 
Did you mean: 
userwill1
Level 1

How can I correct billable rates for employees that keep showing up as $0?

Some background: I am not a TSheets/Time Premium user - just QuickBooks Online with basic "Time."

 

1. I have set up several Projects for our client work.

 

2. I have also set up several employees via the Payroll tab, including their hourly cost and their hourly billing rates. Some employees are set as "billable by default".

 

3. I have entered time for several employees, making sure to select the relevant project and include a detail note.

 

However - when creating an invoice or viewing the labor costs for the project, the billable rate always shows as $0 for all employees and I can not manually enter anything different. Help!

Solved
Best answer June 11, 2021

Best Answers
DivinaMercy_N
QuickBooks Team

How can I correct billable rates for employees that keep showing up as $0?

Hello there, @userwill1.

 

I appreciate your detailed explanation about your issue as well as the screenshots you've attached. Making sure that you have accurate data for your projects is really necessary. To further help you with this, allow me to provide some info about the Billable Rate column. 

 

The Billable Rate column of the Time cost by employee or vendor report depends on the sales rate of the service item you've chosen on the Time entry details page. project1.PNG For instance, if the service item has no sales rate (or if you did not select an item), the report will show a 0.00 billable rate. 

 

If you need to edit the rate for the service item, here are the steps you can perform:

 

  1. Go to the Sales menu.
  2. Click Product and Services.
  3. Look for the service item you need to edit.
  4. Select the Edit button.
  5. Enter an amount on the Sale price/rate field. project2.PNG
  6. Once done, click Save and close

 

For more info about creating projects in QuickBooks, please see this article: Set up and create projects in QuickBooks Online.

 

Also, monitoring your sales and customer transactions is easy with QuickBooks. This is more possible because the program has ready-made customer reports. To access them, simply go to the Reports menu and scroll down to the Who owes you section. From there, select any reports you'd like to open. 

 

Feel free to post here anytime you have concerns about creating projects in QuickBooks. I will be happy to assist you. Have a good one.

View solution in original post

4 Comments 4
userwill1
Level 1

How can I correct billable rates for employees that keep showing up as $0?

Screenshots below of the relevant areas (test entries only).

 

1. Employee setup, showing cost rate and billable rate (also "billable by default" selected)

 

Billable Rate 3.PNG

 

 

2. But when I try to add open billing to an invoice, the entries show as $0 billable.  

Billable Rate 2.PNG

 

 

3. And when I look at project billing summaries the hours show the correct cost but $0 billable (even though the column also correctly signifies the item is billable!

Billable Rate.PNG

DivinaMercy_N
QuickBooks Team

How can I correct billable rates for employees that keep showing up as $0?

Hello there, @userwill1.

 

I appreciate your detailed explanation about your issue as well as the screenshots you've attached. Making sure that you have accurate data for your projects is really necessary. To further help you with this, allow me to provide some info about the Billable Rate column. 

 

The Billable Rate column of the Time cost by employee or vendor report depends on the sales rate of the service item you've chosen on the Time entry details page. project1.PNG For instance, if the service item has no sales rate (or if you did not select an item), the report will show a 0.00 billable rate. 

 

If you need to edit the rate for the service item, here are the steps you can perform:

 

  1. Go to the Sales menu.
  2. Click Product and Services.
  3. Look for the service item you need to edit.
  4. Select the Edit button.
  5. Enter an amount on the Sale price/rate field. project2.PNG
  6. Once done, click Save and close

 

For more info about creating projects in QuickBooks, please see this article: Set up and create projects in QuickBooks Online.

 

Also, monitoring your sales and customer transactions is easy with QuickBooks. This is more possible because the program has ready-made customer reports. To access them, simply go to the Reports menu and scroll down to the Who owes you section. From there, select any reports you'd like to open. 

 

Feel free to post here anytime you have concerns about creating projects in QuickBooks. I will be happy to assist you. Have a good one.

View solution in original post

userwill1
Level 1

How can I correct billable rates for employees that keep showing up as $0?

Hello @DivinaMercy_N, thank you for your response. Using the method you described, I was able to get billable hours into my project as expected. I did have to set up new "services" for each different employee billable rate tier, which takes some extra time, but overall the solution is great. 

 

This does bring up another question: where exactly within Quickbooks Online are the billable rates from the employee profiles actually used? Is that for reference only?

 

Thanks again!

CharleneMae_F
QuickBooks Team

How can I correct billable rates for employees that keep showing up as $0?

Yes, it's for reference only, userwill1.

 

This is the reason why you'll have to add a sales rate on your service item when adding it to sales, expenses, or payroll. Also, please note that you won't see the costs in projects until after payroll is processed.

 

Additionally, you can visit the Project Reports tab to manage your project costs and profits efficiently. These are OverviewTransactions, and Time Activity (see the screenshot below). For more details, see Step 6 through this article: Track Job Costing Features

 

Don't hesitate to leave a comment below if you have other concerns about managing projects in QuickBooks Online. The Community and I will be here to help you.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us