Hi @hanah4348,
Thank you for posting here in the Community space. I can help you run the report you need for the bills and payments in QuickBooks Desktop.
You can run a Transaction Detail report to display detailed vendor expenses totaled by Customer:job. There's an option to add the Source Name column to show the job linked to transactions.
Here's how:
- From the Reports menu, select Custom Reports > Transaction Detail.
- Click Customize Report then go to the Display tab.
- In the Display tab:
- Set the appropriate date range.
- In the Columns section, click to clear the checkmark next to Name, and then click to add a checkmark next to “Source Name”.
- Click the Total By drop-down arrow and select Customer.
- Go to the Filters tab and from the Filter List, select Transaction Type.
- Select the transaction type associated with the Vendor purchases (i.e. Bill).
- Click OK to display the report.
Alternatively, you can try the Transaction Detail by Account report. It brings up every single transaction in your chart of accounts.
Then you do some filtering to get this report to only show what you need. You can change the display to show "Multiple Accounts" and check off whatever accounts you put Customer: Job Transactions.
Then changed the Total By at the top to Vendor. In this report, when a transaction has a Customer:Job, it populates that under "Name" instead of the Vendor Name. You'll see all transactions for a vendor that shows the Job Name.
Available columns and filters differ for each report/group of reports. For more information about how to personalize data by making changes to the display and filters, you can visit this article: Customize reports in QuickBooks Desktop.
Don't hesitate to post again or leave a comment below if you have any additional questions about running reports. I'm always here to assist. Have a good one.