Need a report that shows paid invoices, including payment methods, for all customers

mary27 · ‎December 19, 2019

I need a report that shows paid invoices, including payment methods, for all customers. I need to know how each invoice was paid and when. Can anyone help?

Tori B · ‎December 19, 2019

Hey there, @mary27.

I'll be glad to help you out with this report.

I recommend creating a Transaction List by Customer report and customizing to fit your needs. You can also check out Customize reports in QuickBooks for more details on how to customize.

To create the Transaction List by Customer report:

Click Reports menu at the top.
Choose Customer's and Receivables then Transactions List by Customer.
Select Customize Report in the top left corner of the report.
Click on the Filters tab.
Search for Paid Status and choose Closed.
Click the Display tab and check off Pay Meth. Then click OK.

If you need more help with this feel free to reach back out. I'm only a post away. Have a great rest of your day.

View solution in original post

Tori B · ‎December 19, 2019

Hey there, @mary27.

I'll be glad to help you out with this report.

I recommend creating a Transaction List by Customer report and customizing to fit your needs. You can also check out Customize reports in QuickBooks for more details on how to customize.

To create the Transaction List by Customer report:

Click Reports menu at the top.
Choose Customer's and Receivables then Transactions List by Customer.
Select Customize Report in the top left corner of the report.
Click on the Filters tab.
Search for Paid Status and choose Closed.
Click the Display tab and check off Pay Meth. Then click OK.

If you need more help with this feel free to reach back out. I'm only a post away. Have a great rest of your day.

VeronicaT1

Hi ,

Don't you have a report on each invoice with their applicable payment or if you have a cheque and it itemizes the multiple invoices paid by that particular cheque?

thanks

VeronicaT1

Hi,

Don't you have a report of payments where it itemizes the invoices that were paid ?

A report that has each invoice with their corresponding payments?

Thanks

JoanaC

I'll be more than happy to assist you with your report, @VeronicaT1.

Yes, we have the report that you're looking for. Let me guide you on how to pull up the Transactions list by Customer report.

Here's how:

Go to the Reports Center.
Click Transactions List by Customer.
Select Customize and then select Transaction Type.
Choose Invoice and Payment.

I'd love to share these articles that can help you manage your reports in the future:

Let me know if you still have questions about your reports. Have a lovely day ahead, and take care.

Topics

Training

Community

Resources

Need a report that shows paid invoices, including payment methods, for all customers