Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
New Member
July 11, 2026
Question

How to create report that lists all expenses and income for customer/job. (But not a profit/loss.) More like a check register that lists transactions chronologically.

  • July 11, 2026
  • 1 reply
  • 5 views

We are general contractors.  In order to invoice a customer for a construction draw, we need to know all the current expenses and income for a specific customer (job).  (We have the “jobs” under customers and subcustomers not projects.)  We have tried the Profit and Loss Detail by Customer report but this takes materials (cost of goods sold) and does all the fancy accounting stuff and applies invoices to them.   We just want a simple report that will show a list of current expenses (materials, subcontractors, etc.) and any payments that the customer has made.  We would not be using it for tax purposes, just simply to see the status of a job at a specific time.  It could be like a check register, listed chronologically, and a running balance on the side.  Or it could be similar to the profit loss statement but without the cost of goods stuff going on.  We have also tried the Troansaction List by Customer but it also splits the cost of goods sold up.  Might be doing something wrong.  Any help would be appreciated.

1 reply

QuickBooks Team
July 11, 2026

To create a report that acts like a check register for your sub-customers and tracks your construction draws, you can run and customize the Transaction Detail by Account report.

 

Here is how to set it up:

 

  1. Go to Reports and open Transaction Detail by Account.
  2. Click Customize (top right) and set the date to All Dates.
  3. Under Filter, choose Customer and select the specific job (or "is not empty").
  4. Under Rows/Columns, change the Group by dropdown to Customer.
  5. Adjust Columns to add or hide unneeded details.
  6. Click Apply changes to view your chronological list of transactions.

 

If you have any additional questions about managing your construction draws or sub-customers, please reach out to us again. We’re always here to help.