How do I make a report of all the invoices paid with a single customer payment

Montgomery Minds · ‎March 14, 2019

I have a large payment that paid 20 invoices. They show up fine in the "Receive Payments" window. Of course, I can only see 8 of the invoices at any one time, because of the space available to list invoices.

I would like to export this to a .CSV. Perhaps I need a report (since reports are exportable).

I have found reports that list payments--I just want this one payment.

I have found reports that list invoices, but I want just the ones paid by this one payment.

I have found reports that list each item within each invoice--I just want one line per invoice. So I can see the total for each invoice.

I feel like I'm missing something obvious. Can you help?

Catherine_B · ‎March 14, 2019

Let's get that report pulled-up, Montgomery Minds.

You can get that report in the Receive Payment transaction you created to pay multiple invoices.

Here's how:

In the Employee menu, click Customer Center.
Locate the customer's name to show the list of transactions.
Double-click on the Payment transaction.
In the Receive Payments window, click on the Reports tab.
From there you can open and export the Transaction Journal report.
You'll also want to print the payment's Transaction History.

Both ways would do for your desired report.

The Community is always around to help you if you have other concerns. Have a great day!

View solution in original post

Catherine_B · ‎March 14, 2019

Let's get that report pulled-up, Montgomery Minds.

You can get that report in the Receive Payment transaction you created to pay multiple invoices.

Here's how:

In the Employee menu, click Customer Center.
Locate the customer's name to show the list of transactions.
Double-click on the Payment transaction.
In the Receive Payments window, click on the Reports tab.
From there you can open and export the Transaction Journal report.
You'll also want to print the payment's Transaction History.

Both ways would do for your desired report.

The Community is always around to help you if you have other concerns. Have a great day!

Montgomery Minds · ‎March 15, 2019

Thanks so much @Catherine_B I did not see the Reports tab!

I have an old version (2013) but I found buttons for "Transaction History" and "Transaction Journal" as you suggested.

"Transaction History" doesn't generate a "report" per se, but a popup containing the same information. But from here I can select "Print" and then "Print to:" - "File:" and in the drop down, change "ASCII text file" to "Comma delimited file" and it prints to a .CSV file. This format contains the invoice numbers (but not the customer:job names).

"Transaction Journal" did generate a report containing customer:job names (but no invoice numbers). I can extract that to .CSV file in the usual way, using the "Excel" button.

Thanks again!

JanyRoseB · ‎March 15, 2019

Thanks for getting back to the QuickBooks Community, Montgomery Minds.

Allow me to join this thread and help provide you the invoice report you need in QuickBooks Desktop.

Since there's no option to show the invoice item and the payments on a single report, you'll need to pull up the Sales by Customer Detail report (to show the line items) and Transaction List by Customer report (to show the invoices list and payments applied against it).

To pull up the Sales by Customer Detail report, here's how:

At the top menu bar, click Reports.
Choose Sales.
Select Sales by Customer Detail.
Change the date range.

For Transaction List by Customer report, here's how:

At the top menu bar, click Reports.
Choose Customers and Receivables.
Select Transaction List by Customer.

If you'd like to customize the reports, you can check this article for the detailed steps: Customize reports in QuickBooks Desktop.

For additional reference, you can follow the steps in this article on how to export report from QuickBooks Desktop to Microsoft Excel.

This will get you on the right track. Please know that I'm just a post away if you have additional questions about the Invoice transaction. Wishing you and your business continued success.

Edlyn A · ‎November 02, 2020

Do we have any update regarding this?

Charies_M · ‎November 03, 2020

Thanks for checking this with us, Edlyn A.

As per this writing, the report that shows the invoice item and payments is still unavailable in QuickBooks Desktop. You'll want to use the workaround share by my colleague

While we continue making improvements with the software, you'll want to use the workaround share by my colleague.

Moreover, I want you to be updated with the newly added features in the product by following the steps below:

Here's how:

Go to the Help icon.
Click New Features.
Choose either New Feature Tour or What's New.

Another way to be updated to the latest future release in QuickBooks Desktop is by visiting this website: QuickBooks Updates: New QuickBooks Accounting Software Updates.

Let me know if you have any follow-ups or other questions. I'm always here to help. Wishing you a good one.

Topics

Training

Community

Resources

How do I make a report of all the invoices paid with a single customer payment