Export to Excel Customer Payment Detail

This isn't the kind of situation we want you to experience when running the report you need, Teresa Smags.

We can run the Transaction List by Customer report to display all the transactions and subtotals of income and expenses per customer. Then customize the report to show the invoice date, invoice number, and amount paid.

I'll be glad to guide you in customizing it. Here's how:

1. On the top menu bar, select Reports.
2. Click Customers & Receivables and click Transaction List by Customer.
3. Hit the Customize Report button.
4. Tap the Display ta, choose Num, Date, and Amount Paid. 
5. In the Filters tab, search for Transaction Type.
6. In the Transaction Type drop-down, click Multiple Transaction Types.
7. Select Invoice and Payment and tick OK.
8. Search for Paid Status in the Filters tab and choose Either.
9. Hit OK to complete the process.

Also, I'd recommend memorizing this report to save its current customization settings. For future reference, I've added this article to help you track how your business is doing: Customize company and financial reports.

Please let me know how it goes. You can always go back here if you have other concerns about QuickBooks. Take care always. 

Nope. Already tried that. I know how to filter. You're not understanding...the DETAIL I need and also need to be able to EXPORT IT INTO EXCEL. This just shows the SUMMARY of their payments. Then, if I drill into one of the payments, it just brings me to the Customer Payment screen where it lists all the invoice dates/numbers/amounts I need, but there's no way to EXPORT IT!!?? I want one report showing the DETAIL of all payments so I don't have to drill in/out of each payment! The columns/fields also need to show payment date, payment method (check), invoice amount, and then amount applied so I can manipulate the data in Excel.

I even tried creating a template for the payment receipt to see if I could export and be able to manipulate the data, but I only have PDF option, which then I converted to Excel, but it put all the invoice data in ONE CELL. And, I also need the payment information (payment date, payment method, payment amount) on each invoice line paid so I can manipulate the data.

Also, while we're at it, the RECEIVED FROM field does not pull data. I tried deleting it and re-adding it somewhere else and it's empty. This needs to be fixed as well!

This is sooooooo unbelievable that it's not available!?

I appreciate the screenshot you've shared and for following the steps provided by my colleague. Allow me to chime in on this thread and provide additional details.

The closest report you can run to get these details is the Customer Balance report. This shows the invoices and the payments along with it. However, if the payments are associated with multiple invoices, you'll have to manually open the payment to view the invoices.

As for the template you've created, please ensure that you use all of the necessary box for the details to populate.

Additionally, you can refer to these articles for guidance with your reports:

• Customize company and financial reports
• Create, access and modify memorized reports

I'm always here to help you whenever you require further assistance with your reports in QuickBooks.