Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Dear All,
I am using QB Premier Desktop 2018. Is there any report which shows payment (check) numbers and corresponding invoice numbers, as follows.
Payment Invoice
282123 812343
282123 812567
212313 821456
Solved! Go to Solution.
Hi there, BenTam.
QuickBooks can only generate the numbers per transaction type. If you've entered the payment number on the Memo field, then we can add the Memo column on any sales report. Otherwise, you'd have to open each transaction to get the data you need.
You can run the Transaction List by Customer report to get the invoice numbers.
Here's how:
You can also export this report to Excel, edit the columns there, and then add the payment numbers. To do this, click the Excel button at the top of the report and select Create New Worksheet.
You can always get back to me if you need anything else. Thanks for dropping by.
Hi there, BenTam.
QuickBooks can only generate the numbers per transaction type. If you've entered the payment number on the Memo field, then we can add the Memo column on any sales report. Otherwise, you'd have to open each transaction to get the data you need.
You can run the Transaction List by Customer report to get the invoice numbers.
Here's how:
You can also export this report to Excel, edit the columns there, and then add the payment numbers. To do this, click the Excel button at the top of the report and select Create New Worksheet.
You can always get back to me if you need anything else. Thanks for dropping by.
After multiple decades, why is this software incapable of listing all invoices by date with payments listed under each invoice?
How is it possible Intuit can not make this happen?
Ridiculous.
Hi rsaunar,
We've been gathering product suggestions from our customers that will be useful to all users. I'll personally send this feedback to our Product Developers Team for review.
We appreciate you sharing this with us. If you have any other questions, please let us know. We are here to help.
Interesting. I was actually just searching for this very same report.
The payment transactions display the check number in the 'Num' field, but I'd also like to see which invoices the payment was applied to.
Hi wdi,
You can temporarily use the Transaction List by Customer report to view the invoice and payments. However, it won't show which invoices the payments were paid for. Another way would be going through each customer profile to view the transactions list.
This request has been sent to our Product Developers Team. We'll reach out to you if there are any updates.
If you've got more questions, please post them here.
Hi There
I am also looking for a similar report which shows the details of the vendor bill details, our payment date and check no. I tried to add columns like "Paycheck Date" and "Check #" to Transaction List by Vendor or Job Cost Report unfortunately these columns are blank. Now I am doing it in a very stupid way which is to export the data to an excel file first, then go back to Quickbook to retrieve the payment date and check no. by clicking "transaction history", and then paste these in the excel spreadsheet..........
It would be much appreciated with the development team could allow data flow between bill payment and payment details.
Cheers
Hi Sophia,
Thanks for your reply. I don't see any invoice number. I only see check# in the 'Num' column.
Hello there, BenTam,
As per my colleague Sophia mentioned, QB generate the numbers per transaction type.
There's a possibility that the report is filtered to only show payment transactions. If that's the case, the check number will show on the Num column.
Let's click the Customize Report button to check the filters. Then, run the report again. You can also create a memorized report to save it for future use.
I'll be here if you need more help.
Hi Mary,
Thanks for your reply. It really helps.
i must add my voice to those of my compatriots here in this channel. i echo their frustration and confusion - it should be relatively easy to create a report which shows all invoices and then the payments made against those invoices. this isn't exactly rocket science - it's pretty basic stuff. why isn't this a standard report made available to all who use the QB platform?
Same problem here. Why can't QB allow be to add a column to list the respective invoice in the same line of the payment?
This lack of functionality is one of the reasons why so many of us are changing to Netsuite.
One would think that for the price we are paying for this software you would be able to pull any report you needed. Not so here. They just want you to purchase more apps to perform the duties that the program does not provide.
Actually I figured this out, but it's non intuitive. Go to a transaction list and then click a bill payment -- any bill payment, it doesn't matter. Once in a bill payment go to the reports tab and hit check detail. That will bring up check detail on all checks for a given date range. Next, customize the report by selecting a Name filter and choosing the vendor you want to isolate. Then you can change the date range as needed. You end up with a list of checks and each bill underneath that the checks paid.
This is not responsive to the questions. You are describing payments to vendors, not from customers.
We need this for customers, especially customers relying on a 3rd party or partial payments.
It's been months since I posted this. Is there an update from the Product Developers Team to this?
I run a check detail report which will show the date the check was dated as well as the invoice numbers associated with the check.
I filter the report by Vendor name and multiple transaction types as well as dates. It’s perfect.
You can also go to File, Print Forms and choose Bill Payment Stubs, select the date range, select the Vendor and it will print the check stub listing all the invoices paid by that check or in my case the EFT payment.
Hope that helps y’all.
Here are the reports I create to achieve this.
Hi tstjuste,
You can run the Transaction List by Customer report to show the invoices and its' payment. Let me guide you with the steps.
Once done, you can open the payment transactions to view more details.
I have attached screenshots for your visual guide.
I have also included this link for your future references: Reports.
Keep me posted if there's anything else you need. I'm right here to help.
This is not what we are looking for. We need a report, for auditing purposes, that shows all payments for a particular period that lists all of the invoices that the payment was applied to, that could be printed out.
Or, a report that lists all invoices for a period that shows the payment number, that can be printed out.
We appreciate you for coming back and providing details on what report you need, Thinojosa.
The option to show the lists of invoices with payments linked from it is unavailable. However, you can run the Transaction List by Customer report to show the list of invoices and payments. Then, customize the columns to show the transaction type, date, and transaction number.
Here's how:
You can also export the report to Excel to come up wth the data you need. Just click the Excel button at the top of the report and select Create New Worksheet.
I'll personally share your product suggestion to our engineers regarding this one.
For more details about customizing reports, you can check out these articles:
Visit the Community again if you need anything else with running reports in QuickBooks. I'm here to help.
Hi RCV
Thanks for your detailed steps.
Again, these answers "solved" by Quickbooks employees are not anything close to being solved.
We need the software to report invoices with all payments listed by invoice in a report.
Having to enter each individual invoice record before clicking payment details DOES NOT CUT IT. We can't even print this information, which we go to great lengths to enter this information accurately
We need this report and this functionality to help us get paid!
For this software not to support reports with invoice payment details is no longer acceptable. It's been forever. Thousands have been spent by individual customers over many years, and it's time for Intuit to step up.
Please step up, Intuit.
Stop with this "solved" nonsense.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here