Skip to main content
T
TimFritzley
May 21, 2020
Question

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

  • May 21, 2020
  • 4 replies
  • 0 views
Original commenter did not share additional details

4 replies

JessT
JessT
May 21, 2020

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!

T
Teri11_2
May 21, 2020

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

A
ayoch2020
October 13, 2020

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?

R
rvrfrf
October 13, 2020

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!

T
TimFritzleyAuthor
October 13, 2020

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.

    D
    damon7
    January 4, 2022

    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 

    C
    Carneil_C
    January 4, 2022

    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. 

     
    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!

    Terms & ConditionsAccessibility statement