cancel
Showing results for 
Search instead for 
Did you mean: 
gsa11
Level 2

Is there any report which shows payments with invoices?

Thanks for the clarification.  I had assumed it was referring to Vendors because you enter a bill for vendors and an invoice for Customers and so I'm VERY careful about my word choice.

gsa11
Level 2

Is there any report which shows payments with invoices?

I agree.  I find QBO incredibly frustrating with limited capability and, ultimately, unreliable.  I had one client try to share his QBO with me and it took months before I could actually access it.

gsa11
Level 2

Is there any report which shows payments with invoices?

This is very detailed information, but I want a report that connect Vendor BILLS with Vendor payments applied to them. The point of this report would be to see which bill payment checks are applied to which bills so that it is easy to correct mistakes without having to manually open every single bill and bp check to figure out what happened.  Also, I need this report in QB desktop; I can't stand QBO and use it as little as possible.  

 

It's very misleading for QBO to call a customer report "bills and applied payments" when all QB products designate that bills are for vendors and invoices are for customers.  (So maybe the name of that report in QBO needs to be changed....)

Erika_K
QuickBooks Team

Is there any report which shows payments with invoices?

Thank you for participating in this thread, gsa11. I appreciate your interest in improving QuickBooks and making it more useful for your business needs. I understand you're looking for this particular financial in QuickBooks Desktop (QBDT), and I'd like to provide some information about its current availability and how we handle feature requests.

Just to confirm, the Bills and Applied Payments report is vendor - focused financial data. This means that this specific report records all vendor-related transactions and can be found in the What you owe section of the Reports center in QuickBooks Online (QBO).

Moreover, I recognize the advantages of having this financial information available in QBDT as well. Your input is crucial to us, and we always welcome ideas for enhancing our products. In this case, I encourage you to submit your feature request directly to our Product Development Team. Your insights and recommendations are vital in helping us identify areas for improvement. Once submitted, our Development Team will carefully review your recommendation for potential implementation in future updates.

I'll show you how you can send one:

 

  1. Locate the Help option.
  2. Choose the Send Feedback Online option.
  3. Select the Product Suggestion option. A pop-up window displays.
    image.png
  4. Enter your feedback recommendation on the Here is my suggestion box. 
  5. Click Send Feedback
    image.png

I value your input and the time you've taken to share your thoughts on improving our products, gsa11. Your suggestion regarding the Bills and Applied Payments report for QBDT is important to us. While I'm unable to guarantee immediate implementation, please know that every feature request is carefully considered by our Product Development Team. I encourage you to continue using QuickBooks and exploring its current features. If you have questions about existing reports or need assistance with your current setup, our support team is always here to help. Thank you for being a valued QuickBooks user and for your commitment to helping us enhance our offerings. I look forward to continuing to serve your business needs and appreciate your ongoing feedback.

territyree
Level 3

Is there any report which shows payments with invoices?

Hi  Liz, I'm on Desktop Enterprise.  I searched Bills and Applied payments, but nothing is coming up. 

By chance is there another report I can modify?    What I need is to be able to print by Vendor (I know how to filter) the Invoice # with a column to show the payment ID a column on the same row.

I have a large company that sends out their bills and payment processing and they can't seem to find a payment even though I've highlighted it on the bill payment stub.  My guess is they've applied funds to an incorrect invoice or written it off as "overpayment", yup!   Who does that, well this one does. :(?

 

  Anyway, does this help explain my dilemma?

 

gennieosg
Level 3

Is there any report which shows payments with invoices?

More than 5 years after the start of this unsolved thread we are still waiting for this basic report. Every single time a client wants a statement I have to open up WORD and create one for them manually. It's way beyond ridiculous.

territyree
Level 3

Is there any report which shows payments with invoices?

This is very close, however, I'm in APayables, not receivables.

 

I need this report for Vendor Invoices & Payments to the Vendor.

 

@QuickBooks Programmers - Please add this very simple report.  I'm sure I'm not the only payables staff needing this report when a vendor applies my payment incorrectly and they need to research their records.  Also, is it possible to have payment stubs going out with .csv's attached so they can quickly apply payments though an import?

 

Yup, progress requested. Thanks all...  and Yes I NEED this report for my Supplier who likes to write off anything they deem necessary when the payment stubs put the invoice numbers in random order.  This too is a request for a fix.  

Eman_E
QuickBooks Team

Is there any report which shows payments with invoices?

Handling vendor invoices and payments can be particularly challenging when discrepancies arise in QuickBooks Desktop (QBDT), territyree. Meanwhile, let's run the Custom Transaction Detail Report to filter the data for vendor invoices and payments to vendors.

 

Here's how:

 

  1. Sign in to your QuickBooks Desktop Company File.
  2. Navigate to the Reports menu, hover over Custom Reports, and select Transaction Detail.
  3. Customize the report, first click Customize Report. Then, select Filters and enter the Transaction Type in the search bar.
  4. Select Multiple Transaction Types from the Transaction Type dropdown menu.
  5. From there choose Bill and Bill Payment.
  6. After completing the previous steps, click OK twice.

 

 

For additional details on managing reports, please refer to this article: Understand reports

 

Additionally, you can export your report to Excel files for easier data manipulation.

 

If you have any further questions or concerns about your report data, please share the details below. We're here to assist you.

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

Need to get in touch?

Contact us