Transaction List by Customer Report

Hi there, @Anonymous.

Please allow me to help share information about the Paid Date column in the Transaction List by Customer Report in QuickBooks Desktop (QBDT).

When creating an invoice or a payment in QBDT, there isn't a Paid Date section or column, this is the reason why the column is empty in the report. If you want to see the date when was the payment created, you may check the date/s under the Date column of the report.

Please see screenshots attached for additional reference.

In addition, to learn more about running reports in QBDT, you may check this article: Understand reports.

Let me know if you have any other questions about running the Transaction List by Customer Report. I'll be right here to help you.

Thank you for getting back, @Anonymous.

I'd be delighted to help share additional information about this report.

The information (columns/fields) on the invoice or receive payment page will also be the information listed on the report.  As mentioned, since there's no Paid Date column or section on the Invoice/Receive Payment, it's the reason why the Paid Date column is empty.

Yes, the invoice shows as paid showing the date of the payment to indicate that a payment was made on that date, however, it's not a field, it's just a mark. Therefore the date of the payment will reflect under the Date column beside the Payment.

Please stay in touch if you have any other question about the Paid Date column of the report, I'd be glad to keep helping. Have a great day ahead!

Hello avisadiv,

Thank you for getting back to us here in the Community. Allow me to step in and assist you with any questions you may have concerning the report you need in QuickBooks Desktop.

You can try running the available report specifically for sales reps in the Desktop version. You have the option to filter reps and paid status in the Sales by Rep Detail report.

Here's how:

1. Go to the Reports tab at the top menu bar.
2. Select Sales.
3. Click Sales by Rep Detail report.
4. Choose a date range.
5. Click the Customize Report option.
6. Go to the Filter tab.
7. Below Search Filters, add Rep.
8. Below Account, click the drop-down arrow and select Multiple sales reps.
9. Add the sales reps you want to show in the report, then click OK.
10. Add the Paid Status filter, and choose Closed, then click OK.

For your visual reference, I'm adding the sample screenshots on this:

For your question regarding the Date paid column, right now, this option is not yet fully utilized by the system since this field is still unavailable on sales forms.

As always, please let me know if I can be of additional assistance concerning the report you need. The Community is always here for you.

Thanks for getting back to us in the Community, @Anonymous.

Allow me to chime in and share some additional information about adding a paid date in the QuickBooks Desktop (QBDT) transaction list by customer report.

As mentioned by my colleague above, the Paid Date column is not yet fully utilized by the system since this field is still unavailable on sales forms. However, I have two options that you can try as a workaround.

The first one is to create a custom field on your customer's information. Then add this field to your sales template so it'll be included sales transactions. Here's how:

1. On your QBDT company file, go to the Customers menu at the top, then Customer Center.
2. Open your customer's information by double-clicking their name.
3. Select the Additional Info tab at the left pane, then click the Define Fields option.
4. Type Paid Date or Date Paid on the Label column and put a checkmark on the Use for Cust column, then OK twice.

After that, open the paid invoice on your customer's Transaction List. Here's how:

1. Double-click the invoice on the list, then select the Formatting tab at the top.
2. Choose the Customize Data Layout, then go to the Header tab and put a checkmark on Paid Date for screen only.
3. Hit OK, then manually enter the paid date.
4. Click Save & Close.

Do the same steps for your other customers. Once done, pull up the transaction list by customer report and customize it to show the paid date. Here's how:

1. Go to Reports menu at the top, then pick Customers & Receivables and Transaction List by Customer.
2. On the Columns section, search for Paid Date and choose the new one, then OK.

The second option is to export the report to Excel and manually enter the paid date. This can be done by clicking the Excel option at the top, then Create New Worksheet.

For more information, you can also check out these articles for future reference:

• Use QuickBooks Desktop custom fields.
• Export report from QuickBooks Desktop to Microsoft Excel.

That should get you pointed in the right direction. Give this a try and please let me know how it goes in the comment section. I'm always here to help. Take care and enjoy the rest of the day!

I'm having a similar issue, I want to run a detail report that shows all the customer transactions including the date paid and also check number that the invoices were paid with. I don't really understand how is it that quickbooks can't figure out how to retrieve the paid date from the payments an cross reference this report. The old quickbooks program was able to do this.