cancel
Showing results for 
Search instead for 
Did you mean: 
bschrader
Level 2

I need a report for unbilled time by job that includes the service rates and totals

Is there a report that would show me each month (or a date range) the billable time and the dollar amount (service rates) for all active jobs.

I need it to show:

1.  Active jobs

2.  Unbilled time (from employee timesheets) from specific date ranges

3.  The Rate associated with the Service Item.

4.  The total amount of what the invoice will be.

Any help would be greatly appreciated.

Thank you

 

Solved
Best answer February 11, 2020

Best Answers
JaneD
Moderator

I need a report for unbilled time by job that includes the service rates and totals

Hi bschrader,

 

QuickBooks Desktop offers predefined reports that you can use. However, the option that you're looking in one report is currently unavailable. 

 

You might want to export each report into an Excel file and merge it into one Excel workbook. You can visit this link for available reports you can pull up in QuickBooks. Then, click on the Customize Report button to filter the data and add or delete columns.

 

Let me also share these great resources for additional reference:

We are always looking for ways to make QuickBooks beneficial to your business and conveniently run a report with options to specify them. I'll pass your idea along to our product developers for review. From there, they may consider of having this feature in the future updates.

 

In the meantime, you might want to check our blogs to know about the upcoming QuickBooks news and announcements:

If you have any other concerns, just let us know. We're here to help.

View solution in original post

27 Comments 27
JaneD
Moderator

I need a report for unbilled time by job that includes the service rates and totals

Hi bschrader,

 

QuickBooks Desktop offers predefined reports that you can use. However, the option that you're looking in one report is currently unavailable. 

 

You might want to export each report into an Excel file and merge it into one Excel workbook. You can visit this link for available reports you can pull up in QuickBooks. Then, click on the Customize Report button to filter the data and add or delete columns.

 

Let me also share these great resources for additional reference:

We are always looking for ways to make QuickBooks beneficial to your business and conveniently run a report with options to specify them. I'll pass your idea along to our product developers for review. From there, they may consider of having this feature in the future updates.

 

In the meantime, you might want to check our blogs to know about the upcoming QuickBooks news and announcements:

If you have any other concerns, just let us know. We're here to help.

IASG
Level 3

I need a report for unbilled time by job that includes the service rates and totals

I am looking for the same exact thing. Knowing this information is extremely important to my business. I am part owner of a service based professional services business. We bill time to jobs at a couple different rates but we do not invoice every week. What I would love to see in a report is something like this:

 

By Job:

Estimate: $10,000

Billed: $5,000

Worked But Not Billed: $2,000

Remaining: $3,000

 

This information is critical so we don't "overspend" a job. Quickbooks knows the unbilled time and knows the service item, so the information is all in the system. It just needs to put a dollar amount on the unbilled time. In fact, the information by job shows up in the Income Tracker. So it's all there. I just can't get it out in a report.

 

I currently have a memorized report that uses Time by Job and filters by "Unbilled." I have to export it to Excel and then apply our rates to the services. This is quite cumbersome because we work on many jobs simultaneously. Any help getting the exact information that is in the Unbilled section of the Income Tracker into a report would be greatly appreciated.

Anna S
QuickBooks Team

I need a report for unbilled time by job that includes the service rates and totals

Good afternoon, @IASG.

 

You have some fantastic ideas to add to the report feature, and I'll make sure to pass them along to our Development Team personally. They will then decide if the function for reports will be helpful to you and other users. In the meantime, you have the right idea about exporting the memorized reports to Excel and applying the service rates there. You can also check out our blog page for any new updates for QuickBooks.

 

I'm only a comment away if you have any other questions or concerns. Take care!

OTalbot
Level 1

I need a report for unbilled time by job that includes the service rates and totals

This is a report that our company is desperately needing as well!   This would be a report we would use daily to track our progress on jobs.  We are a professional services company like the original poster.

 

We have been looking for a report that would be like the Time by Job Detail report with the ability to add columns for Service Price and Amount, where the Duration column would multiply by the Service Price column and give us a total of that in the Amount column.

Anna S
QuickBooks Team

I need a report for unbilled time by job that includes the service rates and totals

Thanks for joining the thread, @OTalbot.

 

I'll do my best to keep up with your request. I'll personally make sure our Development Team gets your feature request ideas. This way they'll consider adding your ideas for a Time by Job Detail report and customization columns to future QuickBooks updates. In the meantime, you can submit feedback yourself by going to the gear icon and selecting Feedback. As I mentioned above, you can also check out our blog page for any new added features or updates in QuickBooks.

 

Feel free to comment below if you have any other questions. Wishing you continued business success now and in the future!

IASG
Level 3

I need a report for unbilled time by job that includes the service rates and totals

Since others seemed interested I will post what I came up with. This type of job costing report is critical to my business. Since this type of report was not available directly from Quickbooks, I went hunting for 3rd party software. I decided to download a trial version of Clearify QQube. I was able to produce this report with Excel/QQube with relative ease by modifying a built in job costing pivot table report. It looks something this:

 

QQube Example.PNG

 

The "Sales (Unbilled)" is the one we are all after. This value sums the unbilled time x service item.

 

QQube is not free and it requires configuration and setup to get the data from the Quickbooks company file. I am not affiliated with QQube in any way. I am still in my 15 day evaluation period but this looks very promising.

zmtiger1
Level 1

I need a report for unbilled time by job that includes the service rates and totals

Yes! Yes!

 

Add one more user from the services industry (engineering) wanting a built in report for unbilled hours as dollars.

 

 

KCCPA
Level 2

I need a report for unbilled time by job that includes the service rates and totals

Anyone who bills within QuickBooks would need this report to stay on top of billing.  This is a BIG issue for us users.  I recently converted from Sage50 and they have a great report---please don't make me go back to them!  I would be happy to provide development a sample report from my "old" software, but I'm sure you would have access to the competition.   

Please beg for us users!  This is Very Important!

 

JasroV
QuickBooks Team

I need a report for unbilled time by job that includes the service rates and totals

I see the importance of having this report in your business, @KCCPA.

 

I'd personally like to have a report that shows the data I need as this could make my work effortless. Rest assured, our engineering team is aware of this request and are looking for ways to have this in the future.

 

As a way around, you'll want to export any available reports to excel and combine it to show the data you need. You can refer to this link to guide you in customizing customer, job, and sales reports in QuickBooks Desktop.

 

While we don't have a particular time frame as to when this report will be available in QuickBooks Desktop (QBDT). I encourage checking our Product Updates page regularly to stay updated of the latest news and updates in QuickBooks.

 

Let me know if you have other queries with your QBDT software. I'll be around to help you anytime.

SILLIWKC
Level 1

I need a report for unbilled time by job that includes the service rates and totals

Put me down too. Very Very Very important!!! 

Melodie Jackson
Level 2

I need a report for unbilled time by job that includes the service rates and totals

Pull a "time by job summary" report then customize it on the filters tab.  Choose "billing status" then choose "unbilled".  Pull the range of dates you are looking for and it shows all jobs with time marked "billable" that has not been billed.

Invalid
Level 1

I need a report for unbilled time by job that includes the service rates and totals

I'm in desperate need for this report. With many custom rates set up per job, running a report for unbilled time by job to excel and manually entering each job's custom rates schedule is too cumbersome.

 

Generating individual invoices for unbilled time and then clearing the invoice before saving would probably end up being faster. But we're talking about 40+ active jobs with unbilled time.

ks341624
Level 1

I need a report for unbilled time by job that includes the service rates and totals

Please create this report! It would be a huge help!!!

stulk
Level 2

I need a report for unbilled time by job that includes the service rates and totals

Piling on here.  It's ridiculous that the "Professional Services" Edition doesn't have these kinds of basic reports.  

 

Attached is one kind of report I'd like to see.  Just adding a column to the Billed/Unbilled Hours report that shows the income would be helpful.

 

Would also like to see this by Job.

Kristine Mae
Moderator

I need a report for unbilled time by job that includes the service rates and totals

I've also checked, Stulk. We're unable to add the income column in the Billed/Unbilled hours report.

 

I know it's beneficial to your business. For now, you can continue manually adding the info in the Excel report.

 

I also suggest sending us feedback. Our engineers will receive it directly. It will help us know our customers' ideas and insights about our software. Here's how:

  1. Click Help inside QuickBooks.
  2. Go to Send Feedback Online.
  3. Select Product Suggestion.

Once received, they will evaluate your feedback. The more request it has, the more it's likely to be added in future updates. 

 

If there's anything else that you need, please don't hesitate to let us know. We'll reply as soon as we can.

TDREAD
Level 1

I need a report for unbilled time by job that includes the service rates and totals

Checking in on this thread.  Looks like it has been active for almost a year at this point.  The capability that other users have outlined in this thread is capability I was expecting to be already built-in and available when I purchased the "Professional Services" edition of Quickbooks Desktop.  Unfortunately, managing everything via Excel is very time-consuming and can be prone to user-entry errors, especially across a large number of projects and billing rates. 

 

Please, please, add this reporting functionality.  All of the information is already in quickbooks (unbilled time, and bill-rate for that time).  Please just multiply them together. 

Angelyn_T
QuickBooks Team

I need a report for unbilled time by job that includes the service rates and totals

Hi, @TDREAD.

 

I understand that exporting each report to Excel will consume time and extra effort. I want to ensure you'll be able to get the report you need. 

 

I'll also personally pass along the information to our product developers about the feature needed. Rest assured they're working nonstop to deliver the best experiences for all QuickBooks users. Usually, new updates with QuickBooks are considered bases on the number of requests.

 

At this time, I recommend visiting our blog to stay tuned to the latest QuickBooks new and feature enhancements. Here's the link: The QuickBooks Blog.

 

Moreover, here's an article you can read more about running and customizing reports in QuickBooks Desktop.

 

If you have any other QuickBooks questions, please let me know by adding a comment below. I'm always here to help. Have a good one!

gsroxanne
Level 1

I need a report for unbilled time by job that includes the service rates and totals

Our company is also needing this report. Has QB made any process on making this happen?

 

It's unfortunate that the demand for this report is not being met. 

JessT
Moderator

I need a report for unbilled time by job that includes the service rates and totals

Hi there, gsroxanne.

 

Thanks for jumping in. I understand how much your company needs this report. I'll share the status.

 

Currently, there isn't any update about this. Just keep on sending feedback. You can check out our blog page to see if there is a new blog about changes in the QuickBooks programs.

 

If you have other concerns, feel free to go back to this thread.

bschrader
Level 2

I need a report for unbilled time by job that includes the service rates and totals

I still need this report also.  I can't understand why it would be hard to create when hours and rates are there.

Simple multiplication.....  ??  It is very time consuming to save the information to an excel spreadsheet and enter my own calculations.  It seems this report is needed by a lot people.

KCCPA
Level 2

I need a report for unbilled time by job that includes the service rates and totals

All I get is a response that you don't have any updates about this problem-- It has been over a year and still no solutions to a simple report  that other need as well---why does Intuit make this so difficult??

pkblauser
Level 1

I need a report for unbilled time by job that includes the service rates and totals

This answer actually solves the inquiry...Good job Melody!

QAI
Level 1

I need a report for unbilled time by job that includes the service rates and totals

Has this report been created yet?

BettyJaneB
QuickBooks Team

I need a report for unbilled time by job that includes the service rates and totals

Hello there, @QAI.

 

I hear you and realize the importance of being able to pull up a report for an unbilled time by job that includes the service rates and totals. This option is currently unavailable in QuickBooks Desktop.

 

To get your work done, you may consider exporting separate reports to Excel and create a single report from there. This way, you can gather the data that you need for the report.

 

I know that pulling your desired report can help you run your business easier. I'd encourage you to send this preference to our developers. They are continuously considering new features to be added to the system and help improve your customer experience.

 

To do that:

  1. Click on Help at the top. 
  2. Select on Send Feedback Online.
  3. Choose Product Suggestion
  4. Enter your request.
  5. Click on Send Feedback

For your reference, I'm also adding here an article that will give you more details about how QuickBooks generates report and what are the reports that you can pull up in QBDT: How QuickBooks generates reports.

 

I'd be pleased to assist you if there's anything else you need with reports or any QuickBooks-related thing. Keep safe!

Need to get in touch?

Contact us