Create a Customized Balance Sheet by Job report in QuickBooks Online

This report is simply a convenient way to view the capitalized costs (non-expensed) associated with each customer/job, 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 speculative home building but can be useful for anyone that is especially interested in tracking costs per job that have not made it to the Income Statement yet (most likely because the job is long-term).

 

So, to begin:

 

  1. Go to the Reports section in your QuickBooks Online company file.
  2. In the search bar, type in “Balance Sheet” and select this report.
  3. At the top of the Balance Sheet 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 columns by” to Customers
    3. 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.
  7. Note: Perhaps the most useful rows in this massive report will only be the ones that have all of the Works In Progress or Construction In Progress data. You can probably ignore the banking, credit cards and equity stuff here.
  8. Note: A Balance Sheet by Job report is very useful in ensuring your closed jobs are really closed in your bookkeeping as well.

 

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 Balance Sheet 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.

Share This Post: