Create a Customized Profit & Loss by Job report in QuickBooks Online

This article addresses how to create a customized Profit & Loss by Job report in QuickBooks Online.

This report is simply a clear and convenient way to view the profitability of all of your customers/jobs, separated out (and displayed) per column of information, but, of course, all on one report. This report, perhaps, would be convenient for industries such as custom home building and home rentals, but can be useful for anyone that is especially interested in tracking all (non-capitalized) expenses associated with each customer/job.

So, to begin:

1. Go to the Reports section in your QuickBooks Online company file.
2. In the search bar, type in “Custom Summary Report” and tab to let the report process.
3. At the top of the report you will need to specify some options:
   1. Set your dates (perhaps include all dates so nothing gets left out accidentally)
   2. Set the “Display rows by” to Income Statement.
   3. Set the “Display columns by” to Customers
   4. Choose your accounting method to either Cash or Accrual (Cash is good for knowing exactly what costs have been incurred by your bank or credit cards).
4. Click on Run Report on the right side.
5. To save the report, click on “Save customization” on the right side.
6. For a better detailed analysis of your report, scroll to the far right side of the report and click to download to a spreadsheet.

To obtain a more detailed analysis of some particular total on this report, just click on that total and the detailed view will open up. Once you are finished looking at this detailed view of this particular total, you can then click on “Back to report summary” at the top left to go back to your original customized Profit & Loss report. Be sure your options are still set at the top once you are taken back to the custom summary report.

Note: AccuraBooks is a bookkeeping firm only, so please consult with your C.P.A. for verification and clarification about the contents of this article.