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

Accounts Payable Detail report with customer field

I have run this report but nothing shows up, even though we have unpaid bills for our vendors??

LMKetchum
Level 3

Accounts Payable Detail report with customer field

Just how many times do we have to keep submitting "requests" before anything gets fixed?

You keep pushing online as the next best thing but can't even hold up your end and have reports that we need or options that desktop offers.

This is very frustrating, almost not worth using.

JoesemM
Moderator

Accounts Payable Detail report with customer field

Hi there, @LMKetchum.

 

I'd love to help you achieve your goal, but would you mind sharing more details about it? Like adding a screenshot of your concern? It can help us get on the same page and provide accurate resolution.

 

I'll wait for your reply, or if you have any other questions, please let us know. We're always here to help. Take care.

LMKetchum
Level 3

Accounts Payable Detail report with customer field

I had just followed your steps, marked the vendor bill as BILLABLE and entered the customer, when I select run nothing shows up

LMKetchum
Level 3

Accounts Payable Detail report with customer field

Seriously, my concern have you not been reading the whole thread about addin the customer on an aged payable report, why is this so difficult????  

Rea_M
Moderator

Accounts Payable Detail report with customer field

Hello, @LMKetchum.

 

For the time being, the option to show customers (or a Customer column) on aged payable reports, like A/P Aging Detail and A/P Aging Summary reports, is unavailable in QuickBooks Online (QBO). Let's pull up the Unbilled Charges report instead to get the data you need.

 

By default, the Unbilled Charges report will only show you the list of your billable expenses. To add the customer associated with each of the charges, you'll have to set the Group by feature to the Customer option and to set the appropriate report period. Please see the screenshot below for your reference.

 

 

Also, you can opt to save your report's current customization settings to be available for future use. You may want to check out this article to learn more about this process in QBO: Memorize reports in QuickBooks Online.

 

Please don't hesitate to let me know in the comments if you have other reporting concerns in QBO. I'm always ready to help. Take care, and I wish you continued success, @LMKetchum.

Cthrn MPAcc
Level 2

Accounts Payable Detail report with customer field

This is not a solution as billable expenses are only applicable in the case of time & material contracts versus lump sum contracts. The feeble attempt to resolve does not provide the appropriate data or reflect each customer's aging data on outstanding payables and neglects sufficient amounts of data. 

 

The request is simply to add the customer to the accounts payable aging detail report's customized fields. There is not a customized report in Quickbooks offering this important information and it impacts every construction and architectural firm, as well as their contractual obligations, using QBO. 

RobbinN
Level 2

Accounts Payable Detail report with customer field

Unbilled charges don't work for me. I don't use that feature. I have found a report that works. Transaction Detail by Account. That report is under "for my accountant". Customize the report by transaction type, customer, A/P paid, which would be unpaid. You do have to change the customer each time but it works.  I have this report saved which I use. The accounting method to run report has to be accrual or nothing shows up.Good luck!

NickMan1313
Level 3

Accounts Payable Detail report with customer field

Why does everyone from Intuit make excuses for this programming failure over a 5-year period?  This data is in your database and should be an easy programming fix.  

 

A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.

 

This data is in a table and if it is in a table easy query fix to add this to a report.  Period end of excuses Intuit.

fourniercpa
Level 1

Accounts Payable Detail report with customer field

I completely agree. This is absolutely ridiculous. 7 years of NO SOLUTION to a SIMPLE FIX. I am a QuickBooks ProAdvisor and CPA. I have always stood by QuickBooks and recommended the product to clients and companies. I am just about fed up with reports and issues MANY people have complained about for years - almost a decade at this point. I am about to cancel my license and switch to a more robust software that not only listens to client's problems but ACTUALLY provides a solution - not a workaround (that is usually not suitable to most users). 

mariag18
Level 1

Accounts Payable Detail report with customer field

Anyone here have an alternative to QBO?  This is so frustrating, I cannot pull a simple accounts payable report by customer, it should be standard practice to have this function.  I'm so fed up. 

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

Need to get in touch?

Contact us