Does anyone else need the rate column on Time Activities by Employee Detail to work?

Hi Tim!

Yes, I think this column is useful, especially if you want to see a report on many time activities with different rates. Example: An employee works for Customer A on Monday and for Customer B the next day at a different hourly rate.

On the other hand, you have the option to remove the RATES column if you don't need it. To do this, simply click the little Gear icon and remove the checkmark in the Rates checkbox.

You can always customize your QuickBooks reports to get the data you need.

Let me know if you have other questions about reports, Tim. Have a good one!

Thinking you are asking about employee pay rate vs. customer billing rate, but yes must see both and hours. 

We use TSheets with Quickbooks Online.  Our employees track their time under each customer/job and their time gets transferred to QB.  There are two columns, Rates and Amount that are not showing any information.  We need to know the job costs by employee's time on each job.   I attached a screenshot of what we are seeing.  How can I get this information to show up under these columns?

Thanks for becoming a part of the Community, ayoch2020.
 

When using TSheets for importing billable time, you'll want to make sure your preferences are configured properly.

There's a setting that must be turned on, otherwise employees won't have an option to indicate whether time is billable or not. If you import data into QuickBooks that isn't marked as billable, it won't show up under the Rates and Amount columns on your Time Activities by Employee Detail report.
 

Here's how to check your preferences:
1. Open TSheets.
2. Go to the QuickBooks drop-down menu.
3. Click Preferences.
4. Make sure Show billable is selected.
5. If any changes were made, save them before exiting your preferences window.
 

If Show billable wasn't turned on, that would explain why you're not seeing billable data importing into your books. Once it's activated, workers will see an option to specify whether time they're tracking is billable or not.
 

In the event your settings are set up correctly, you'll want to check with your employees to make sure their times are being entered properly.
 

I've included a detailed resource about integrating TSheets with QuickBooks Online, which may come in handy moving forward: Integrate TSheets & QBO
 

Please feel welcome to send a reply if there's any other questions. Have a good day!

Zack;  thanks for the response.  The issue is that we are a construction company so employee hours are not billable.  We bid the job and then want to track the employee detailed time costing.  We entered the employee pay rate as their hourly rate.  The employee time detail report will show the employee hours per customer project, but it will not bring over the "rate".  This is a major flaw with a supposedly QBO Pro.  There is no "Pro" there.

Thanks for the clarification, @TimFritzley.

Allow me to share some insights about the Time Activities by Employee Details Reports in your QuickBooks Online (QBO) account.

The Rates column under the report will show the rate of your employee if the time activity entered is marked billable to the customer. This way, you can easily track the per hour rate of your employee for that project.

Since you used the hourly rate of your employee as the pay rate of the project. Ensure to select the project they worked to record the wages in running your payroll. You can utilize this article in processing your payroll accurately: Process or run payroll.

Additionally, you can invite your employees to view their pay stubs online. This way, every time you run payroll they’ll be notified by email and view their paycheck. Here’s an article you can read that can walk your through the process: Invite your employees to QuickBooks Workforce to see pay stubs, W-2s and more.

You can always get back to me if you have other questions about managing your employee’s time activities. I’ll be around to answer them for you. Keep safe and stay healthy.

@TimFritzley 

FYI that being a construction company does not automatically mean you do not bill employee hours.

Type of contract determines whether actual hours/pay are billable such as for T&M or CPFF contracts.

Sounds like all your contracts are FP (Fixed Price), which is fine so you want to see your cost along with price to see how much profit you make on each project, which is totally normal to expect to see. 

@JasroV 

Tim did not say he used employee PAY rate as BILLING rate.  He said they did not bill by the hour.

Hate when people don't answer the question asked, this is not a presidential debate, lol. 

Running payroll or waiting till year-end to view W-2's is NOT even close to acceptable answer IMHO.

he showed us the report. I assume those are employees and hours, why are the dollar amounts blank?

Seems he should be able to run that report with a simple calculation that multiplies hours x pay rate to 

show dollars of COST by person.  BILLING a customer should be a totally separate function from cost.

Teri;  thanks for the response.  Even thought the bulk of our jobs are FP we do T&M and CPFF occasionally.  Even for those we would want to see the base hourly cost for the project -- that is the hourly pay for the employee against the project, not just the marked up rate.  Again, I deeply believe this is a major shortcoming of QBO Pro.  This is definitely not a Pro version even though we are charged as if it is.   Best, Tim

We may have figured this out with a QB rep last week.  We went to "Payroll Settings", clicked the edit button under "Accounting" Preferences and under "Wage Expenses" we selected "Each employee's wages are posted to their own expense account".  We then selected from the drop down menu, "Payroll Expenses:Wages" for all employees.  Once payroll was ran, wages/taxes were filtered over under the customers/jobs.  We were told to make our jobs all billable before this but that did not work and now we have open Time Charge transactions under each customer which we do not want, so we are going to remove Billable from TSheets and hopefully this will solve that issue.  This is still a somewhat fluid situation but we are going to keep an eye on how things are filtering and hopefully everything will work as we want it to!  Hopefully this helps some others as well!

ANY UPDATES/WORK AROUNDS ON THIS?

1. Go to Settings  and select Account and Settings.
2. Select the Time tab.
3. In the Timesheet section, select Edit ✎.
4. Turn on the Allow time to be billable setting. 
5. If you want your users to see their billable rate when they enter their time, select the Show billing rate to users entering time checkbox. You may want to leave this unchecked if you bill customers at a different hourly rate than you pay your employees and subcontractors.
6. Select Save.

I have read through these threads regarding Billable time and different rates.  I am actually shocked that T sheets does not easily allow for multiple billable rates per customer?  Services businesses often bill different rates for each team member or for the type of work they are doing.  The lack of easy to setup different rates renders T sheets useless for most of the service businesses I am familiar with (architects, designers, attorneys, etc).  I have been digging through the preferences and following instructions and there does not be a way to do this.  I have set up services as our different tiered billable project rates, but then the individual employee does not have an opportunity to select the service that they are providing when they enter their time.  I am missing something?  Thanks 

Hi there, @damon7. Thanks for taking the time to reach out to the Community for support. I'm happy to lend you a hand with entering billable rates rates per customer in QuickBooks Online. 

You can enter billable rate in QBO. Thus, this shows billable to your customer. 
 

Here's how: 

1. Click the New (+) icon.
2. Select Single Time Activity or Weekly Timesheet.
3. Enter the information, then check the box beside Billable (/hr) and enter the Rate in the box.
4. Once done, click Save and close.

For more details on how T Sheets works with QBO, check out this link for reference: Integrate T Sheets and QuickBooks Online.

Additionally, you can also see more information about this process in the articles I've included below. 

• How to enter billable time: Employees & Contractors.
• Track and manage timesheets in QuickBooks Online.
• What are pay rates, cost rates, and billable rates?

 
If you have any other questions about billable rates, let me know by adding a comment below. I'll be right here to provide additional assistance. Wishing you a good one!

I updated the settings so that my employees' time is billable and that the rate should appear on the Time Activities by Employee Detail report. However, it did not fix this retroactively. Is there a way for the rate to appear on this report retro to when I updated the settings? 

Hi there, @CFO Pro. 

Thanks for following the thread and sharing your concerns in great detail. 

Chaning the setting will only effect how things work going forward. Anything prior to the setting change will need to be corrected manually.

I understand how convenient it would be to have the option to choose if the setting would change all billable time instead of only going forward. That said, I wanted to mention that you can send any suggestions or concerns you have to our Product Development Team. Our developers review each request and consider them for future updates. 

You can use the link I've included below to send your feedback request. 

• Send Feedback to QuickBooks Online

Please let me know if you have any questions or concerns. Take care!