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)