How to pull up expenses by job in QuickBooks Desktop

Tracking receipts against specific jobs is a core strength of QuickBooks Desktop, but actually viewing a compiled list of those expenses can feel hidden. If you are scanning receipts, matching them to bank transactions, and assigning them to a Customer:Job, you have already done the hard part. The software records the data correctly—you just need to use the right report to pull it back up.

Run a Job Profitability Detail report

The most direct way to see a list of expenses tied to a specific job is the Job Profitability Detail report.

1. Go to Reports, hover over Jobs, Time & Mileage, and select Job Profitability Detail.
2. In the report window, click the Filters tab.
3. Set the Item Filter to Multiple items and select all relevant expense items, or simply filter by Transaction Type to include checks, bills, and credit card charges.
4. Set the Date range to cover the period you are reviewing.
5. Click OK or Display.

This generates a line-by-line breakdown of every cost assigned to that specific job, which you can easily compare against your offline records.

Use the Transaction List by Customer

If you want to look at expenses across several different jobs at once, the Transaction List by Customer report is highly effective.

Navigate to Reports, choose Customers & Receivables, and select Transaction List by Customer. This report groups every transaction—including bills, checks, and credit card charges—by the customer and job assigned to them. You can further filter this list by transaction type to exclude invoices or estimates, leaving you with a clean list of purely outgoing money.

Export to Excel for reconciliation

If you keep a separate spreadsheet of job costs, reading directly off the QuickBooks screen can be tedious. Once you have generated either of the reports above, click the Excel dropdown at the top of the report window and select Create New Worksheet. Exporting the data allows you to sort, filter, and cross-reference your scanned receipt logs side-by-side with what has officially posted to your company file.

Verify your expense tagging

If you run these reports and a specific expense is missing, the transaction likely was not tagged to a job during the matching process. When matching downloaded banking transactions, you must ensure the Customer:Job column is filled in on the transaction screen before hitting Add or Match. If an expense was already added without a job assignment, you will need to open that specific transaction, assign the job, and save it before it will appear on your job reports.