How to show payment date / status to each customer invoice?

Good day, mary sakai.

I understand that you need to add the payment date on that report. Though we're unable to add the payment date, we can pull up a different report.

We have a Customer Balance Detail report that we can pull up. This will show all the invoices with their payments next to them. Simply go to the Reports menu, hover over Customers & Receivables, and select Customer Balance Detail.

I've added these links if you need more help about customizing report:

• Reports in QuickBooks Desktop
• Customize customer, job, and sales reports in QuickBooks Desktop

Please leave a comment below if you need anything else. Have a great day!

Quickbooks can show the invoice date paid on the invoice window, so the data is available. There is no reason why the same date can not be displayed on a report.

In my business, it is frequently first pay, first serve. Dancing through 10, 20, or 50 invoices to see who paid when is stupid. If I wanted a paper based accounting system, I would not be using Quickbooks.

Jon

In order toi get the report that you want, its really simple. For desktop, go to 

>reports >Sales > sales by customer detail.

Then customize by choosing the month you want the information for and BE SURE to click the CASH button for report basis. The detail report will show you the date paid under the date tab. it shows the invoice number, the amount paid, and the date it was paid. 

I found a possible solution. Change the Report Basis filter from Accrual to Cash. The Date column will change from date-invoiced to date-paid.

Show me status of subscription payment for 2023