Skip to main content
T
tallen2
February 26, 2020
Question

I want to creat a bill based on timesheets. I have created a weekly timeseet and marked it billiable. How can I create a bill for that contractor importing the time?

  • February 26, 2020
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

K
Kendra H
February 26, 2020

Good afternoon, @tallen2.

 

Thank you for reaching out to the Community. I'd be glad to lend a hand withing billing your weekly timesheets.

 

Since you've already created a weekly timesheet, you can create an invoice if your business charges by the hour.

 

Here's how:

  1. Go to the New + icon in the left-hand corner.
  2. Enter the customer's name.
  3. Click on Add All. Tip: Repeat this as needed for others as well.

Here's a screenshot as an example:

 

For more information about billing time through timesheets, refer back to this article: Adding Employee Time to Invoice through T-Sheets

 

If you have any more questions or concerns, I'm only a few clicks away. Have a safe and productive rest of your week!

T
tallen2Author
February 27, 2020

Thanks for the response.  I get that i can create invoices to my customer using that time (Accounts Receivable).  I also need to create Bills for my contractors for this time (Account Payable).  In the desktop version, when you create a Bill and pick a vendor that has weekly timesheets already etered, it allows you to import that time based on a date range, instead of having to manually look up those hours and enter them manually.  Can I do this in the online version?

KlentB
KlentB
February 27, 2020

I'll help you with creating bills for your vendors, tallen2. 

 

Currently, the option to directly add the information from a weekly/single timesheet to a bill is unavailable in QuickBooks Online. We can only do it in QuickBooks Desktop as of now. Please know that your voice matters to us. At times, we roll out product enhancements based on our customers' requests. Rest assured, I'll take note of your suggestion and submit this to our product engineers for consideration.

 

For now, we can manually create the bill and pull up the Recent/Edited Time Activities Report for reference. We'll have to multiply the number of hours by the hourly rate you pay your vendor. If the timesheet entries are billable, the Amount column will show what you are charging to your vendor. You can follow the step that I've listed below.

 

Accessing the report:

  1. Select Reports from the sidebar menu.
  2. Enter Time Activities by Employee Detail in the search bar.
  3. Click Customize.
  4. Select a time period under Time Activity Date and adjust the dates or enter the date range in the fields.
  5. In the Filter section, from the Employee drop-down list, check the vendor name.
  6. Hit Run Report.

Creating a bill:

  1. Click the + New icon.
  2. Select Bill.
  3. From the Vendor drop-down menu, select the appropriate vendor.
  4. Enter the necessary information.
  5. When you're ready, hit Save and close.

As we assess this opportunity, I encourage visiting our blog to stay current with all the QuickBooks News.

 

If you need to create an invoice to your vendors, you can follow the steps above provided by my colleague Kendra H.

 

Please know that the Community is open 2/7 and always ready to help if you have any other concerns or questions about vendors. As always, assistance is just a post away.

P
PhilJ1
July 13, 2021

Please create this feature.  We all need it!

E
EstesBabe
April 15, 2022

Is there any update on this feature?? I NEED IT NOW!!! Not having it is creating a ton of unnecessary work!!

R
Rasa-LilaM
April 15, 2022

Thank you for joining this thread, EstesBabe.


I recognize the importance of being able to import the created timesheets to your bills. This feature saves time and lets you perform other tasks because you no longer have to manually input the information.


I’m unable to provide a definite time frame when this will be available. Rest assured, we’re looking into this one for consideration in future updates.


I still suggest you manually input the timesheet data into the bill. This is to keep track of your vendors' or contractors working hours. For more details, you can read this article: Track and manage timesheets in QuickBooks Online. It includes instructions on how to view or edit time in the program.


Also, the following resource provides information about adjusting your time tracking preferences: Turn on and set up time tracking. You’ll see the steps to add a time tracking user, ways to add time details, and so on.


Keep me posted below if you have additional concerns about tracking timesheet data. I’ll be around to get this taken care of for you. Have a great weekend ahead.

T
tallen2Author
April 26, 2023

Has this feature been added to QB Online yet.  My desktop version is about to be unsupported next month.  I raised this shortcoming of the online version like 3 years ago.  I'm hoping this has been added?  please let me know.

R
rvrfrf
April 26, 2023

Thanks for getting back with the Community, tallen2.

 

I can certainly understand how an ability to create bills automatically based on data from timesheets could be useful and have submitted a suggestion about it as of today.

 

You can also submit your own feature requests while signed in.

 

Here's how:

 

  1. Use the Gear icon, then go to Feedback.
  2. Enter your suggestion(s) in the Have feedback? window.
  3. If necessary, attach a file with your Camera icon.
  4. Select Next.

 

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.

 

For the time being, you can manually create bills using data from your timesheets.

 

If there's any additional questions, I'm just a post away. Have a great day!

G
gauravl
September 10, 2024

Is there any update on this issue, I see that people are looking for this feature for last 4 years and still no updates. This is clearly a case of dual entry one during weekly timesheet and second to create bill. Clealry this feature was available in QB Desktop, they must have thought that its worth it so why it is no available in QBO

Terms & ConditionsAccessibility statement