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

Is there any report which shows payments with invoices?

"If you need to know what's new and coming in QuickBooks, you can always visit our Firm of the Future website. This is where the latest improvements and features are posted."

 

It's worth noting the feature we're requesting in this thread are not available in QB2022. And they want $1100/year for it. :)

AccountantDave
Level 4

Is there any report which shows payments with invoices?

Lol, I get the idea for wanting this report, but I don't understand why a professional would need it for double-entry accounts, that maintain a running balance, and reconcile to a bank. What auditor has to link all invoice numbers to all payment numbers in a system where applying a payment zeroes out the invoice and the payment? There are so many other measures for reconciling account balances and totals that I imagine QB is not going to restructure their data for a bunch of people that can't figure out accounting. If you need to see what payment applied to an invoice, open the payment and see. This should be done on a sample basis, not a draw a line connecting every transaction, for every customer basis. When a payment applies to two invoices, and those same invoices involve a payment from another source (which may itself apply to even further invoices) reporting structure breaks down for the all encompassing format you guys want. Sure, it may work for examples of data on the simpler side. i.e. invoice X paid by check Y. But throw in a mix of transactions, unapplied amounts, over payments, etc and the report becomes moot. And for goodness sakes people, act like adults.

rsaunar
Level 3

Is there any report which shows payments with invoices?

Wow. You don't understand it, therefore it isn't needed.

 

Seriously?

 

Let me explain something to you: There are many of us trying to get paid in ways you may not imagine, and based on your post, that imagination includes insulting anyone that doesn't think like you. 

 

By the way, the "new features" are finding ways to get us to pay more for the same crap software you believe works perfectly.

roqfsh
Level 2

Is there any report which shows payments with invoices?

No progress on this? I can't go any deeper in the replies. I'm still in 2019, and I don't see resolution. In the meantime, Quickbooks tries to upsell me thru the product or run at ads at me. I mean, I pay a subscription fee. Why do I have to see this garbage? Why is so hard to provide a report with invoice numbers and payment numbers? It's essential. Pitiful.

roqfsh
Level 2

Is there any report which shows payments with invoices?

You're right. I'm in software development. This is pathetic.

roqfsh
Level 2

Is there any report which shows payments with invoices?

It must be very frustrating to work for Quickbooks when your dev team cannot resolve a simply, essential report in 2 years time.

Shar132
Level 2

Is there any report which shows payments with invoices?

found this method:

  1. From the Reports menu, choose Banking then click Check Detail.
  2. Click Customize Report.
  3. On the Display tab, choose the appropriate date range.
  4. From the Filters tab, remove all selected filters under the Current Filter Choices.
  5. Select the filter for Transaction Type then choose Payment.
  6. Select the filter for Detail Level and choose All Except Summary.
    Note: If the Detail Level filter is selected as Summary Only, it will only show linked deposits. You can filter this report for specific customers by choosing the Name filter and narrowing down to a single name or type of name.
  7. Select OK.
Shar132
Level 2

Is there any report which shows payments with invoices?

this method worked for me Payment and corresponding invoices:

  1. From the Reports menu, choose Banking then click Check Detail.
  2. Click Customize Report.
  3. On the Display tab, choose the appropriate date range.
  4. From the Filters tab, remove all selected filters under the Current Filter Choices.
  5. Select the filter for Transaction Type then choose Payment.
  6. Select the filter for Detail Level and choose All Except Summary.
    Note: If the Detail Level filter is selected as Summary Only, it will only show linked deposits. You can filter this report for specific customers by choosing the Name filter and narrowing down to a single name or type of name.
  7. Select OK.
Shar132
Level 2

Is there any report which shows payments with invoices?

perhaps this will help: From the Reports menu, choose Banking then click Check Detail. Click Customize Report. On the Display tab, choose the appropriate date range. From the Filters tab, remove all selected filters under the Current Filter Choices. Select the filter for Transaction Type then choose Payment. Select the filter for Detail Level and choose All Except Summary. Note: If the Detail Level filter is selected as Summary Only, it will only show linked deposits. You can filter this report for specific customers by choosing the Name filter and narrowing down to a single name or type of name. Select OK.
QuickSometimes
Level 2

Is there any report which shows payments with invoices?

It truly is ridiculous that the user community has to rally for this basic functionality. Does anyone inside QBO appreciate the need for this basic need that would help us immensely or do you not really care?

Christine_Laing
Level 2

Is there any report which shows payments with invoices?

We have payments which apply to hundreds of invoices.

gennieosg
Level 3

Is there any report which shows payments with invoices?

My boss is upset with me for not being able to provide this report, along with an estimates report that shows each estimate with it's invoices and payments. We have TENS of thousands of estimates and I have to MANUALLY export this report of ALL of them, sift through it to find what he wants, and put it into a report myself. I am beyond angry and shocked that this report was a staple in your desktop version but unavailable in the UPGRADED online version. And this is year 3 or so that I have been on your message boards, with this same old tired rant. QBO has been the worst "upgrade" I have ever dealt with.

LetSync
Level 2

Is there any report which shows payments with invoices?

Hello 

Using LetSync Desktop. You can get that export it automaticly :

https://www.letsyncsolution.com/docs/report-payments-with-invoices/

 

Regards,

Christine_Laing
Level 2

Is there any report which shows payments with invoices?

Thank you! We may very well buy your product.

LetSync Desktop
Level 1

Is there any report which shows payments with invoices?

You will get 30 days trial for testing without any risk. Looking forward to hearing from you.

gennieosg
Level 3

Is there any report which shows payments with invoices?

So QB solution is to purchase a $400 3rd party add on application to perform this function (a simple accounting report showing estimates invoices and payments by job), that was free in the desktop version and available to us before we spent thousands of dollars on the upgraded? 

NylesC
Level 1

Is there any report which shows payments with invoices?

I had the same issue a year ago during an audit, where the credit memo and what invoices they were applied to was information needed and I couldn't find a report. 

 

I then found an answer on these message boards, it works and the instructions, which I saved, also work for payments. below is what I saved from last year. I was just able to do this report to give me all the payments by customers and the invoices they were applied to. 

 

"I think I may have found the answer to your question:

 

1.  Go to Reports>Banking>Check Detail

2.  Select Customize Report

3.  Click on Filter Tab

4.  Modify Report as follows:

     Account:  All Accounts

     Date:  Specify the date you desire

     Detail Level:  All

     Transaction Type:  Credit Memo

5.  Select OK

 

This should show you the Credit Memos for the date specified and the invoices and items it applied to.  You can also run this for PAYMENTS.  Just change the Transaction Type to PAYMENT. "

mjkahn
Level 1

Is there any report which shows payments with invoices?

I was taught to put the check number in the "Reference Number" field when entering payments against an invoice. We want to print a Customer transaction report showing all invoices open and closed and the "Reference Number" for those that were paid. How can we accomplish this? 

 

Thank you. 

JenoP
Moderator

Is there any report which shows payments with invoices?

I'd be glad to join you here and help you get all the details that you need, mjkahn.

 

You can run the Invoice List report. This will give you a list of all invoices whether paid or not. Then, customize it to include the payments that were applied to the transactions. 

 

Here's how: 

 

  1. Go to the Reports menu and select Invoice List.
  2. Click Customize in the upper-right hand corner of the report.
  3. Scroll-down to the Filter section and check the box for Transaction Type.
  4. Click the drop-down list beside it and check the boxes for Invoice and Payment.
  5. Select Run report. 

 

 

Please note that the reference number is shown under the Num column. 

 

 

 

I'll be sharing these references as well in case you need more guidance when running reports in QBO:

 

 

Feel free to join us again in the Community if you have other questions for us. We'll make sure to answer them for you. 

Linkasink
Level 3

Is there any report which shows payments with invoices?

yes you can get this easily. Go to Reports > Sales > Sales by customer detail. Then when the customize box opens, you choose the dates you need, and mark the little bubble under report basis to CASH, then the report will show you the the items paid for, the customer name, the invoice number and the date paid. The date paid is under the column heading date. screenshot quickbooks.png

LetSync
Level 2

Is there any report which shows payments with invoices?

Hello

 

yes, you can query report using LetSync: https://www.letsyncsolution.com/docs/report-payments-with-invoices/

 

I hope this helps

 

Regards,

LetSync

SB719
Level 3

Is there any report which shows payments with invoices?

THANK YOU!!! All of the reading, searching, etc.,etc. that I have spent on this and your suggestion provides EXACTLY what the original poster requested! Intuit couldn't resolve this or provide a report in over 2 years and what you have detailed is exactly what is needed!

LetSync Desktop
Level 1

Is there any report which shows payments with invoices?

Hello 

 

You can use LetSync Desktop to pull that report from QuickBooks to your database: https://www.letsyncsolution.com/docs/report-payments-with-invoices/

 

I hope it helps

 

LetSync

territyree
Level 3

Is there any report which shows payments with invoices?

Thank you!!!!!!!!! I appreciate your response and appreciate that you listened to the request for the Vendor invoice and check report. 

 

 

territyree
Level 3

Is there any report which shows payments with invoices?

Well, I was happy too soon.  My report cut off in Late November 22 but I have payments (the same type) going through to Feb 2023.  My date was through current date.  So Strange, but very disappointing.

Need to get in touch?

Contact us