cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Anonymous
Not applicable

Transaction List by Customer Report

I ran the Transaction List by Customer Report and added a column "Paid Date" - the column is empty for all invoices including the ones that were paid.

Can anyone help me with that?

Thank you

Solved
Best answer 04-02-2019

Accepted Solutions
Moderator

Re: Transaction List by Customer Report

Hello again, @Anonymous.

 

Thanks for getting back to me. I'm here to help make sure that your concern is taken care of.

 

Yes, you're right. The Define Field won't automatically populate the payment date. You need to manually enter it every time you receive a payment as a workaround. Rest assured that I'm going to pass along your suggestion regarding this. You can always check out the articles that I've provided above for future reference.

 

Thanks for your understanding and patience while we look into this. Also, let me thank you for being a part of our QuickBooks family. Please post again or leave a comment if you have any other concerns. I'm always here to answer them. Cheering you to continued success!

13 Comments
QuickBooks Team

Re: 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.

b5 invoice.PNG

b5 customer payment.PNG

b5 report.PNG

 

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.

Anonymous
Not applicable

Re: Transaction List by Customer Report

Hi

 

Thanks for your reply.

I still don't understand why the 'paid date' column is empty. 

I did add the 'date' column but it only shows that the invoice was paid (or unpaid) with no date.

In the attached screenshots you can see the report I ran and also an invoice that clearly shows a paid date.

Any help would be much appreciated.

Thank you

Anonymous
Not applicable

Re: Transaction List by Customer Report

Sorry I could find an option to add both screenshots

Anonymous
Not applicable

Re: Transaction List by Customer Report

 
QuickBooks Team

Re: Transaction List by Customer Report

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.

b6 inv. and payment.PNG

b6 paid mark.PNG

b6 tlbcreport.PNG

 

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!

Anonymous
Not applicable

Re: Transaction List by Customer Report

OK Thank you for this explanation.

What is the purpose of the field 'date paid'?

I am trying to run a report based only on invoices and not payments.

I am trying to find a report for commission calculation - the commission is only based on paid invoices and is for a specific sales rep.

Any idea how to do that?

QuickBooks Team

Re: Transaction List by Customer Report

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.

Anonymous
Not applicable

Re: Transaction List by Customer Report

Thank you.

I am familiar with this report and used it in the past.

It still doesn't help with the 'date paid'.

Looks like I'll have to add the paid date manually....   :(

Moderator

Re: Transaction List by Customer Report

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.

 

1.PNG 2.PNG

 

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.

 

3.PNG 4.PNG 5.PNG

 

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.

 

7.PNG 8.PNG

 

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.

 

6.PNG

 

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

 

 

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!

Anonymous
Not applicable

Re: Transaction List by Customer Report

Hi,

 

Thank you so much for this detailed explanation.

It is a great idea to track the paid date like this.

But...it still means I need to enter these dates manually.

If I understand correctly once I "receive payment" from a customer the date will not be populated in this new field as this is just a user defined field.

When there are 10-20 invoices that is really easy to manage, but when the invoicing volume is high it just another step to do.

I wish this new defined field could "take" the date automatically when I record a payment...

 

I really appreciate all your efforts.

Thank you

 

Moderator

Re: Transaction List by Customer Report

Hello again, @Anonymous.

 

Thanks for getting back to me. I'm here to help make sure that your concern is taken care of.

 

Yes, you're right. The Define Field won't automatically populate the payment date. You need to manually enter it every time you receive a payment as a workaround. Rest assured that I'm going to pass along your suggestion regarding this. You can always check out the articles that I've provided above for future reference.

 

Thanks for your understanding and patience while we look into this. Also, let me thank you for being a part of our QuickBooks family. Please post again or leave a comment if you have any other concerns. I'm always here to answer them. Cheering you to continued success!

Not applicable

Re: Transaction List by Customer Report

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.

Anonymous
Not applicable

Re: Transaction List by Customer Report

Hello, JJCALNUR.

 

You can run the Customer Balance Detail report. This report shows all the transactions per customer including checks paid to their invoices. This will also show their payment date and their existing balance. 


Here’s how to run the report:

  1. Click Reports at the top. 
  2. Select Customers & Receivables.
  3. Choose Customer Balance Detail. 

Please don’t hesitate to visit us again if you have further questions about QuickBooks.
 

Need to get in touch?

Contact us