Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have a small engineering firm, and each project we work on has a Not to Exceed value that I need to check on as I process invoices. Each project is entered as a separate customer/job in Quickbooks. I need a report that says how much I have billed against a job before sending in an invoice. The closest I have found is a report, "Company & Financial / Income by Customer Summary." However, it has a notable drawback. It always shows every customer/job I have had over the time period I select, both active and inactive. I have lots of inactive customers/jobs. The report will not remove inactive jobs, and hence is 3 times as long as it needs to be and is difficult to work with. I have many customers/jobs and manually using the filter screens to select the customers/jobs that are active will be quite tedious and error prone. Is there any alternate approach to get a report that only shows all active jobs over the time frame I select?
(Using QB 2014, Premier Professional Services Edition, Windows 7)
Solved! Go to Solution.
"I need a report that says how much I have billed against a job before sending in an invoice."
You selected that you have an Older program, and we don't know which, Pro or Premier.
Open the Income tracker, if you have it, and you see a listing of Billable time and costs. Also, other than Pro, you can enable this for Invoice From a Table of Time & Costs, in Preferences.
"The closest I have found is a report, "Company & Financial / Income by Customer Summary." "
There reports to examine Sales to date, but not the value of Pending to be Charged from Actual Time listed as tasks on Timesheets.
You can compare Qty and Item, such as Scope of work entered on an Estimate, to Timesheets: Time by Job by Item, or Time by Name by Item by Job, comparing Est qty column to Billed, Unbilled and Not Billable.
"However, it has a notable drawback. It always shows every customer/job I have had over the time period I select, both active and inactive."
In this example "Active" = Has Values in the timeframe. That is not a Status, in this example.
"I have lots of inactive customers/jobs. The report will not remove inactive jobs, and hence is 3 times as long as it needs to be and is difficult to work with."
That isn't the right report for what you are asking, anyway.
You want Job Profitability or Sales reports. Or, Estimates Vs Actuals.
"I have many customers/jobs and manually using the filter screens to select the customers/jobs that are active will be quite tedious and error prone. Is there any alternate approach to get a report that only shows all active jobs over the time frame I select?"
Are you using Job Status? If your completed jobs have Status = Complete or Closed, and In Progress have status = In Progress, you can filter on one selection = Job Status.
"I need a report that says how much I have billed against a job before sending in an invoice."
You selected that you have an Older program, and we don't know which, Pro or Premier.
Open the Income tracker, if you have it, and you see a listing of Billable time and costs. Also, other than Pro, you can enable this for Invoice From a Table of Time & Costs, in Preferences.
"The closest I have found is a report, "Company & Financial / Income by Customer Summary." "
There reports to examine Sales to date, but not the value of Pending to be Charged from Actual Time listed as tasks on Timesheets.
You can compare Qty and Item, such as Scope of work entered on an Estimate, to Timesheets: Time by Job by Item, or Time by Name by Item by Job, comparing Est qty column to Billed, Unbilled and Not Billable.
"However, it has a notable drawback. It always shows every customer/job I have had over the time period I select, both active and inactive."
In this example "Active" = Has Values in the timeframe. That is not a Status, in this example.
"I have lots of inactive customers/jobs. The report will not remove inactive jobs, and hence is 3 times as long as it needs to be and is difficult to work with."
That isn't the right report for what you are asking, anyway.
You want Job Profitability or Sales reports. Or, Estimates Vs Actuals.
"I have many customers/jobs and manually using the filter screens to select the customers/jobs that are active will be quite tedious and error prone. Is there any alternate approach to get a report that only shows all active jobs over the time frame I select?"
Are you using Job Status? If your completed jobs have Status = Complete or Closed, and In Progress have status = In Progress, you can filter on one selection = Job Status.
Hello Jack1957,
You can run the Job Profitability Summary report. To do that, please follow the steps below:
You can customize the report to show only the customers you want. Click the Customize button, then select the Filters tab. Under Filter, select Name. Click on the drop-down to select Multiple names.... From there, select the name of the customer you want to appear on the report. Please see the second attached screenshot.
Let me know if this report works out for you, or if you have any other questions. Thanks!
Hi there, @pam7.
Thanks for looping into this thread. I can help you resolve the crashing problem when searching for the contributed reports in QuickBooks.
This problem is caused by issues in the computer itself or by how QuickBooks interacts with your system. To make sure that you have the updated components, let's update your QuickBooks to the latest release:
If the error persists, please refer to this article: While working in QuickBooks, QuickBooks closes unexpectedly (crashes with or without an error). It'll ask you to enter your contact information to add you to our notification list.
And of course, I’m here to help you if you have other concerns. Also, please keep me posted on how it goes. I'd like to make sure this is taken cared of.
I have the exact same issue, and none of the responses solved the issue. I marked the estimates complete, the entire estimate is billed, and the job is closed, but still shows up on my report, which now has over 9,000+ lines and takes over an hour to populate. We use this report for monthly progress billing because it's the most accurate, but it so long because jobs with 100% progress still show up on the report. Below is a screen clip of the oldest project on my report, it goes all the way back to 2007.
Hi, @sunflower78.
I can see how much effort it would take to pick the needed transactions and exclude the unwanted ones. I'm here to make sure you'll be able to manage your reports accordingly.
To isolate the issue, you can customize your report to display only the names needed, then filter the dates to exclude the older and past entries. I'll show you how.
Moving forward, you can save the current settings of your report so you won't go through the same adjustments in the future. You can use this link as your guide: Create, access and modify memorized reports.
If you need additional assistance, you can always reach out to our Support Team. An agent can take a look into your account securely, and guide you with options on how to filter your transactions and achieve the report you need.
Moreover, here are some of our helpful articles you can read more about handling customers transactions and reports:
Please keep in touch if you need more help with your estimates and reports. I'm determined to help. Cheers for more success!
Good afternoon,
Your response did not answer my question. It was too general. The issue is that I need all names to populate which estimates progress payment is less than 100%. The Estimates Vs. Invoices report shows every job we ever created an invoice for and an option to customize based on percentage complete does not exist.
Hey there, @sunflower78.
Thanks for reaching back out to the Community. I appreciate the extra clarification.
Since the steps my colleague provided didn't work, I did some further research. However, this isn't going to be possible in your QuickBooks Desktop (QBDT) account. I'll send feedback to our Product Developers so they can consider this in one of the upcoming releases. They take the time to review every request and try to collaborate them in the next available update.
You can keep up with what's new in the system with our QuickBooks Blog.
I hope this information helps. The Community and I are here to have your back. Let me know if you need anything else. Take care!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here