Skip to main content
January 22, 2024
Question

I have few contractors. I need to enter time weekly in a batch mode. How can I batch enter these time s and use the timesheets to invoice and payments also.

  • January 22, 2024
  • 1 reply
  • 0 views
- How to enter timesheets in batch 
- How to user these timesheets in invoice
- How to use the time sheets in the payments

1 reply

January 22, 2024

You can prepare your Time Activities data in the following template

TxnDateNameTimeStartTimeEndTimeDescriptionBillableStatusCustomerServiceItemHourlyRateTaxableClassLocation
01/10/2020Mike's Traders5  Sample Time Activity using hours and decimal Janice JohnsonHours    
01/10/2020Eagle Outfitters4.5  Sample Time Activity using hours only Janice JohnsonHours    
01/10/2020Mary Smith0.5  Sample Time Activity using hours and minutesBillableJanice JohnsonENG Svs:12075FALSE  

 

then use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

You can fill the Billable Status to use it in your invoice later.

January 22, 2024

Thank you for your time, raj A. I recognize the convenience of entering timesheets through batch action, as it saves time hassle-free. With that, I'm here to drop some insights regarding this matter.

 

Since we're unable to enter timesheets via batch action, we can follow 4Gal's solution about utilizing an importer tool to achieve this. We have available third-party apps that can integrate with QuickBooks Online. You'll want to check the list within your account in the Apps tab and press Find Apps. Then look for apps in the Search bar or browse them in the Browse Categories dropdown. You can also visit directly through this link: QuickBooks Apps store.

 

Furthermore, if you're using QuickBooks Online Plus and Essentials, you can monitor billable time for specific jobs. It allows you to effectively track and bill for your billable time, and manage all billable expenses in an organized manner. You can enable direct billing to your customer from tracked time by activating the billable time setting.

 

Here's how you can do it:

 

  1. Select Settings ⚙, then Account and Settings.
  2. Select the Expenses tab.
  3. Go to the Bills and Expenses section and select it to expand it.
  4. Turn on the Make expenses and items billable switch.
  5. Select Save, then select Done to close your settings.

 

Then, refer to this article if you want to create invoices for customer projects: Invoice customers for project expenses in QuickBooks Online.

 

Let me know if you have concerns. 

raj AAuthor
January 23, 2024

Thank you. How can I use the same time sheets to (create a bill) and pay the vendor who supplied the contractor. 

 

Thank you