cancel
Showing results for 
Search instead for 
Did you mean: 
NickMan1313
Level 3

Accounts Payable Detail report with customer field

Sorry Quickbooks Online but you are lazy. That info is clearly in the database and should take 10-20 man hours to add to the report to benefit tons of customers. Very sad customer 

NickMan1313
Level 3

Accounts Payable Detail report with customer field

All fields in the database should be available to us.  This is lazy IT 

NickMan1313
Level 3

Accounts Payable Detail report with customer field

We need all fields in the database to be able to be chosen on the report. Come on MAN!!!!

NickMan1313
Level 3

Accounts Payable Detail report with customer field

3 years no fix come on Quickbooks need some love for our money!!!!!

MirriamM
Moderator

Accounts Payable Detail report with customer field

I appreciate your input from every angle, @NickMan1313.

 

We recognize that each company has unique needs, and I can see how these features would benefit and empower your business. Though I don’t have a specific timeframe when the option will be made available, rest assured, I'll take note of your idea so that it's included in other customers' requests for future product enhancement of QuickBooks Online. 

 

I also encourage you to submit feedback to our Product Development Team. They look through submitted feedback for future updates and use those suggestions to develop changes for the product.

 

You may also want to visit our QuickBooks Blog. And be the first one to know about any updates that you'll find beneficial for your business. The QuickBooks Blog is our way of letting you know the latest features released and what the product team is working on. They update the site every time new information is available. 

 

If there's anything else you need help with, let me know by adding a comment. I'm more than happy to assist you. Have a great day!

sarcar925
Level 1

Accounts Payable Detail report with customer field

Our company also needs to view the customer. This is obviously a needed enhancement. Come on Quickbooks get that column added!!

NickMan1313
Level 3

Accounts Payable Detail report with customer field

This is an easy fix been 4 years if the data is in the database easy fix to add to the report.  Take my money and fix the report PLEASE

RobbinN
Level 2

Accounts Payable Detail report with customer field

I'm with Nick. Trying to find an accounts payable with customer is not available which I find ridiculous. It has been two years and this is still not available. Not very construction friendly. I want to see what I owe by customer, not by vendor. Not sure why QuickBooks cannot provide this report. Which I am not very impressed by the reports available. Also, I think there should be a report that can be printed with invoices being paid. I have had to get creative, which annoys me.

Libolt
Level 1

Accounts Payable Detail report with customer field

Hello, 

This needs to be addressed very soon. We are using Quickbooks enterprise in conjunction with Procore. We run multiple construction jobs at any given time and process vendor payments on a job by job basis. The interface between Procore and Quicbooks does not allow us to segregate bills between multiple accounts payable accounts. Therefore we need to run AP aging reports that can be filtered by the job each bill is attached to.  Please Intuit, address this asap.

Reid754
Level 1

Accounts Payable Detail report with customer field

I'm with you all on this... we absolutely need the customer to show up in the AP report, and I don't know why it has not been addressed on over 4 years! If you can create a Project Profitability Summary, you've already linked AR Invoices with AP Bills. You've done the P&L side (thank you!), but why can't you do the BS side??

NickMan1313
Level 3

Accounts Payable Detail report with customer field

Sorry Quickbooks online lazy development should be available!

NG_2020
Level 1

Accounts Payable Detail report with customer field

I need to get a report that will show me the AP Aging by customer field for QB Desktop.

KlentB
Moderator

Accounts Payable Detail report with customer field

I'll share some tips on how you can get that report data, NG_2020.
 

The Accounts Payable Aging Detail/Summary report in QuickBooks Desktop can only include the vendor names as of the moment. If you're tracking the vendor expenses and payables that are billable to a customer or job, you can pull up the Unbilled Cost by Job report instead. Here's how:

 

  1. Go to the Reports menu.
  2. Choose Customers & Receivables.
  3. Select Unbilled Cost by Job.
  4. Set the appropriate reporting date and accounting method.
  5. Sort the report according to your preferences.

I can also understand how convenient to have a column or field customers on the AP aging reports in managing your vendor transactions. Rest assured, I'll take note of your ideas and suggestions to help improve your experience in the program.

 

To ensure that you'll get the most out of QBDT's reporting capabilities, I'd recommend reading these articles:

 

As always, you can me here if you have any other concerns or further questions about how reports work in QuickBooks. 

Littlev2
Level 1

Accounts Payable Detail report with customer field

I tried getting my report following these directions. It says this report does not contain data.

Bryan_M
QuickBooks Team

Accounts Payable Detail report with customer field

Hi there, Littlev2.

 

Since the report you tried to run does not contain any data, I recommend to customize the date before running the report. This way, you can verify if that report had entries that were entered on that date.

Here's how:

1. On the left panel of your QuickBooks Online account, click Reports.
2. In the search box, type and click the specific account you want to run.

3. Below the report period, click the dropdown arrow in the box and select Custom, then change the dates you want to run a report. You can also click Customize on the right side if you want to specify other information.

      Note: Customizing reports will depend on what kind of report you will run because it's different when you run reports for vendors and customers.

4. Click the Run report.

 

 

If the error still appears,  I recommend logging in to your QuickBooks account using a private browser. 

 

Use these keyboard shortcuts based on the browser you're using.
 

  • Google Chrome: press Ctrl + Shift + N
  • Mozilla Firefox: press Ctrl + Shift + P
  • Safari: press Command + Shift + N
     

There are also times the cached data in QuickBooks can cause unexpected issues. A regular browser will continuously overwrite itself and won't remove history unless manually done. You can click this article to learn the steps on how to clear cache and cookies to fix issues when using QuickBooks Online.

 

If you want to learn which reports are available for your QuickBooks Online version, you can read through this article: Reports included in your QuickBooks Online subscription.

 

Feel free to reach out again if you have any clarifications on the reports. We'll be happy to help. Have a good day.

ttttt1234
Level 1

Accounts Payable Detail report with customer field

Any update here? This topic is a few years old now and you still can't link Customers/Projects with Accounts Payable reporting? There have to be a ton of customers who need this reporting.

 

Thank you

SirielJeaB
QuickBooks Team

Accounts Payable Detail report with customer field

I appreciate you for reaching out to the Community, @ttttt1234.

 

I understand how useful it is to have a column or field for customers on account payable reports when managing vendor transactions. However, the Accounts Payable Aging Detail/Summary report in QuickBooks Online can only displays the vendor names at the moment.

 

However, you can run and customize the Purchases by Vendor Detail report to show the customers. Here's how:

 

  1. Click Reports.
  2. Search for the Purchases by Vendor Detail report.
  3. Click the small Gear icon.
  4. Put a check mark on the Customer box.
  5. Update the date period.
  6. Click Run report.

 

You can use the following articles as references to handle your financial reports moving forward:

 

 

Please keep me posted if you need help with your financial reports in QuickBooks Online. I'm always here to help. Stay safe.

Disappointed User
Level 1

Accounts Payable Detail report with customer field

This example is great however it isn't helpful for what seems to be needed. I also am trying to create a custom report for AP Aging Detail where the customer/project name can be added but anything where we the company owe, doesn't allow this function. Not very user friendly.

JamesAndrewM
QuickBooks Team

Accounts Payable Detail report with customer field

I appreciate you for joining the thread.

 

I can see how the feature to add the customer's name when creating a custom report for AP Aging Detail would be helpful for you. Currently, this isn't available in QBO. 

 

In the meantime, it's best to put your suggestions and feedback regarding this option to our product developer. Here's how to send feedback:

 

  1. Click the Gear icon in the upper-right corner.
  2. Select Feedback under Profile.
  3. Share your feedback.
  4.  Click Next to submit.

 

Our product engineers may consider your suggestions, and you can always check the status of your request through this link: QuickBooks Online Customer Feedback.

 

You can visit this article to learn ways to customize your reports: Common custom reports in QuickBooks Online.

 

The Community always welcomes you for further inquiries about reports. Have a great day ahead!

NickMan1313
Level 3

Accounts Payable Detail report with customer field

5 years nothing nadda sorry but you should be speaking to the development team on our behalf!!!!!!!!!!!!!!!!!!!!!!!!

Cthrn MPAcc
Level 2

Accounts Payable Detail report with customer field

@NickMan1313   Same problem, three years later.  I called QBO yesterday to ask why they haven't added the customer option to the AP report yet for construction and architecture projects. He said he would look into it and get back me with next week. Yeah, ok, right. I feel like when I call or work with QBO, I have to tell their support team how their product works (or does not work). In the meantime, have you found a QBO resolution rather than switching over to Sage Construction & Real Estate or building your own Excel spreadsheets from exported QBO reports?  All I want to see is the AP aging report filtered by customer versus vendor (with the vendors in a column as shown on the Purchases by Vendor Detail Report).  Not rocket science, especially for an accounting software company, right?

NickMan1313
Level 3

Accounts Payable Detail report with customer field

The customer field is in QuickBooks but not on the report once again since 2018 I have been complaining. this is extremely lazy programming.  I have a computer science and accounting degree and this is just lazy lazy lazy.  I bet you could assign a single programmer and have this done in one week.  So LAZY.  I love the product but easy fixes should happen quicker than 5 years.

NickMan1313
Level 3

Accounts Payable Detail report with customer field

come on man

Cthrn MPAcc
Level 2

Accounts Payable Detail report with customer field

AGREED! How many complaints does it take to move forward? It looks like they started designing a project and just quit not knowing what to do or realizing projects have contractual obligations from an accounting perspective. I need to view AP aging on a customer level as soon as a customer sends in their payment (in our case, millions of dollars and a multitude of transactions) not compile additional reports using two different QBO reports and Excel spreadsheet design and builds. It's a simple fix - the data is there. I've been hearing for 20+ years this is in the works. Please. 

 

I sent the feedback using the gear icon so many moderators share in their free time. I'm not interested in traveling to all of the QB blogs and resource links, etc. I have &^$! to do.  All I want to see is the AP aging report filtered by customer versus vendor (with the vendors in a column as shown on the Purchases by Vendor Detail Report). That's it.

DGDW
Level 1

Accounts Payable Detail report with customer field

New to QB, only a few weeks in, and I can't believe this feature isn't available. What is the point of setting up jobs if you can't see them on your Payables Reports?

Need to get in touch?

Contact us