SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
ktmwilson12
Level 2

Can you add paid date to Sales by Rep report?

Hello - I am trying to add paid date to Sales by Rep Detail Report.  When I customize the report to add the paid date, it leaves that data blank in the report. Does anyone know how to get this data to show?

 

Thanks,

Katie

3 Comments 3
SashaMC
Moderator

Can you add paid date to Sales by Rep report?

Thank you for reaching out to the QuickBooks Community, Katie. I am happy to help. I just wanted to confirm if these were the steps you took to add the Payment Date.

 

  1. Navigate to the report, click "Customize Report," 
  2. Go to the "Columns" tab and select "Payment Date' from the available fields to include it in the report display.

 

This will allow you to see the date each sale was paid for each sales representative. Please let me know if you are still receiving the same issue. I am looking forward to your reply. 
 

ktmwilson12
Level 2

Can you add paid date to Sales by Rep report?

Yes, but it does not bring back the data.  That field is empty on the report.

AbegailS_
QuickBooks Team

Can you add paid date to Sales by Rep report?

Thanks for the confirmation @ktmwilson12.   I'd like to clarify why you are not seeing a paid date in the Sales by Rep report.

 

While we can add the Paid Date column to the Sales by Rep report, it does not automatically populate the data. As an alternative, you can run the Average Days to Pay report separately, which will provide you with the paid dates. Here’s how to do it:

 

  1. Click on Reports from the menu bar.
  2. Choose Customers & Receivables, then select Average Days to Pay.
  3. Go to The Filters tab, then on the Choose Filter field, pick Paid Through on the Filter drop-down.
  4. Select a date range on the drop-down list or on From and To, then OK.
  5. Filter the necessary details you want to include in the report.

 

For your reference, please see the screenshot below.

avera.png

 

For additional reference, you can check this article on how to customize reports in QuickBooks Desktop.

 

In case you're working on the same reports on a daily, weekly, monthly, or quarterly basis, you can automate this task. For more details, please see this article: Set up and modify Scheduled Reports.

 

I'm here to help, so feel free to ask if you have more questions about running reports. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us