cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
stepping-stone
Level 1

Aggregate time entries in invoice

When I import time entries from a project into an invoice for a certain month, all the entries for the month come in. Is there a way to aggregate the time entries by employee in the invoice?

 

For example, let's say I have:

EmployeeRateEntry 1Entry 2
Employee A$100/hrSomething - 1 hrSomething else - 2 hr
Employee B$150/hrSomething further - 3 hrSomething even further - 4 hr

 

On the invoice, entries show up something like this:

RateQuantityDescription
1001Something
1002Something else
1503Something further
1504

Something even further

 

We want something like this:

 

EmployeeRateQuantity
Employee A1003
Employee B1507

 

Thank you in advance!

4 Comments 4
JamesM4
QuickBooks Team

Aggregate time entries in invoice

Hi there, 

 

Glad to have you reach out to us here. QuickBooks is a versatile program that's designed to help you streamline your work. I'll be happy to share more info so you're on the right track.

 

The import function in QuickBooks is designed to upload all the info available for importing. While the option to automatically aggregate the time entries by employee during the import process, I recommend looking into third-party data migrations apps. These apps can be found on our site www.apps.com

 

In the meantime, feel free to ask other questions. I'm here to help. 

stepping-stone
Level 1

Aggregate time entries in invoice

Thank you, James.

 

I forgot to mention that we are using QB Time to create the time logs. Would we still need the third-party migration app?

Trish_T
QuickBooks Team

Aggregate time entries in invoice

Hi stepping-stone,

 

If you use QuickBooks Time, you can simply track time to the project, and then approve and export the time to QuickBooks Online. Follow this link to Learn how to add your employees' timesheets to the project

 

If you have additional questions, I feel you would benefit more by contacting our Customer Care team at 1-855-253-1536 from Monday to Friday between the hours of 9 AM and 8 PM EST.  They will be able to work with you in real time, and assist you with accomplishing your QuickBooks goals without delay!


 If you have any other questions, reach out again.  We're here to help!

stepping-stone
Level 1

Aggregate time entries in invoice

Hi Trish,

 

Yes, we're aware of that. But when we put the time in the invoice, we get every single time log entry for a certain period of time for that subcustomer/project. We want to have the invoices show the total amount of time for each employee in a certain month. Not every single thing they did in that month. Please see the example in the original post for clarity. 

Need to get in touch?

Contact us