cancel
Showing results for 
Search instead for 
Did you mean: 
hanah4348
Level 1

bills and payments

I have multiple customer jobs.  Each customer bills gets paid from its own account. I would like to  ensure that all bills were paid from their  correct account. I would like to run a report filtered to a specific customer showing its bills and what bank account it was paid from.  A report of all bills with a column displaying the customer job and the bill payment account is also ok.  

1 Comment 1
AlcaeusF
Moderator

bills and payments

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:

 

  1. From the Reports menu, select Custom Reports > Transaction Detail.
  2. Click Customize Report then go to the Display tab.
  3. In the Display tab:
    1. Set the appropriate date range.
    2. In the Columns section, click to clear the checkmark next to Name, and then click to add a checkmark next to “Source Name”.
    3. Click the Total By drop-down arrow and select Customer.
  4. Go to the Filters tab and from the Filter List, select Transaction Type.
  5. Select the transaction type associated with the Vendor purchases (i.e. Bill).
  6. 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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us