Job Profitability Reports - Accurate cross-year reporting

Hello there, jonathancw.

You can filter the job status to in progress. This way, the active jobs will show when you'll run the Job Profitability Summary/Detail report.

Here's how: 

1. Go to Reports.
2. Select Jobs, Time and Mileage and choose Job Profitability Summary.
3. Click on Customize Report.
4. Choose the Filters tab.
5. Enter Job Status in the Search field.
6. In the Job Status drop-down, choose In progress.
7. Click OK.

I'll be right here if you need anything else. Have a good one!

Joyce,

Thanks for your suggestion.  It is definitely a "work-around" and is a solution to part of the problem.  While this allows me to report on any open jobs, it does not allow me to report on jobs that have closed during the current year. 

Ideally, it would be great if I could filter against the Job End Date, but that is not a field option that is currently available as a selection in the custom filters.  Also, I could potentially re-purpose one of the Job Status choices to represent jobs that have closed in current year, but again I am limited because I cannot select more than one Job Status choice in order to show both active and closed jobs for the current year.

Thanks again for your suggestion...Jonathan

I, too, need the ability to filter on END DATE and JOB STATUS. This is such a simple feature for us that use Job Costing. It needs to be added asap.

Greetings, @Jonathan_20 and @kansas79,

While you can filter the job status one at a time, I recommend pulling up another Job Profitability Summary or Detail report. This way, you'll be able to filter the job with another status.

Then, export the report to Excel so you can combine and manually calculate the total cost of your jobs.

Here's how to export a report:

1. Open the Job Profitability Summary or Detail report.
2. Click Excel on the report toolbar.
3. Select Create New Worksheet or Update Existing Worksheet. 
4. Click Export.

For additional guidance with the steps above, please check this out: Export report from QuickBooks Desktop to Microsoft Excel.

No worries. I'll pass along your feedback to our Product team for them to see how you can filter the report with multiple job status.

Should you need anything else with your reports in QuickBooks, please let me know and I'll get back to you.

Thanks for the reply. The main reports I need are 1) income statement by job type w/ filters and 2) income statement by job w/ filters:

#1 income statement (row) and job types (column) based on a specific job status AND closed date

#2 income statement (column) and job (row) based on a specific job status AND closed date

I realize I could get these in separate reports, but one report is ideal and less time-consuming. Thanks!

Thanks for coming back, kansas79.

It would be great to run a single report for an income statement by multiple job status, job type and closed date. However, this option is unavailable in QuickBooks.

You can follow the workaround provided by my colleagues by running a separate report. Then, export them to Microsoft Excel to come up with the data you need.

I'll personally share this one to our engineers regarding with your product suggestion.

Visit the Community if you need anything else in QuickBooks.