Skip to main content
H
hanah4348
September 15, 2022
Question

bills and payments

  • September 15, 2022
  • 1 reply
  • 0 views

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 reply

AlcaeusF
AlcaeusF
September 15, 2022

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.

Terms & ConditionsAccessibility statement