Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I would like to see how long it takes customers to pay. Is there a report that show age from invoiced to paid? Or is there a custom report I can create?

 
5 Comments
QuickBooks Team

I would like to see how long it takes customers to pay. Is there a report that show age from invoiced to paid? Or is there a custom report I can create?

Hi there @Anonymous,

 

I can certainly help you pull up the report you need.

 

You can view the invoices you've made and their payment dates in the Invoices and Received Payments report. 

 

For you to view the due and payment dates of the invoices, you need to customize the report.


Here's how:


1. On the left panel, click on Reports.
2. In the search box, type Invoices and Received Payments, and hit enter.
3. Select the date range you prefer.
4. On the upper right corner, click on Customize.
5. Click on Rows/Columns, and click on Change Column.
6. Tick the boxes for Invoice Date, Due Date, TermsA/R Paid.
7. Click on Run report.

 

You can as well export this report to MS Excel to be able to manually calculate the days it takes for your customer to pay.

 

Here are some articles that you can read for more information: 

If you have any other concerns, please leave a comment below. I'll be delighted to help you. Happy Holidays!

Level 1

I would like to see how long it takes customers to pay. Is there a report that show age from invoiced to paid? Or is there a custom report I can create?

Hello,

I have a question on this.

We would like to pull the same data so that we can see how long it is taking our vendors to pay our invoices from the due date until the payment date.

 

Is there a report that will include all of these fields (Date, Due date, A/R Paid AND include the payment date)?

 

Moderator

I would like to see how long it takes customers to pay. Is there a report that show age from invoiced to paid? Or is there a custom report I can create?

Thanks for joining this conversation, @rstewart1.

 

You can use the same report (Invoices and Received Payment) shared by my colleague above. All you need to do is to customize it to include the information you'd like to see.

 

Here's how to pull it up:

 

  1. In QuickBooks Online (QBO), go to the Reports menu at the left pane to get to the Standard report page.
  2. Type Invoices and Received Payment in the search field and select it in the drop-down to open.
  3. Click the Customize option at the upper right. 
  4. In the Rows/Columns section, tick Change Column.
  5. Place a checkmark on the information you'd like to see. 
  6. Hit Run report to refresh.

 

For more insights about managing reports in QBO, consider checking out these articles:

 

 

You also have the option to memorize your reports, this allows you to save it with its current customization settings. Refer to this article for further guidance: Memorize reports in QuickBooks Online.

 

Don't hesitate to leave a comment in this thread if you have any additional questions or concerns. I'll be here to help. Have a wonderful day!

Level 1

I would like to see how long it takes customers to pay. Is there a report that show age from invoiced to paid? Or is there a custom report I can create?

Thank you for your response.

For this report, I would need to add the "payment date" as that is the date we received the check/ACH payment but there is no option in the "Rows/Column" report to add the "payment date".

 

Is there a report that will show me the date, due date, AR/Paid and Payment date all in one report?

 

 

Moderator

I would like to see how long it takes customers to pay. Is there a report that show age from invoiced to paid? Or is there a custom report I can create?

Hello again, @rstewart1.

 

The option to add a Payment date Row/Column when running a report in QuickBooks Online (QBO) is unavailable. In the meantime, what you can do is to customize the columns in which you can select what columns you want to show on the report. 

 

On the other hand, upon pulling up the Invoices and Received Payment report, the payment date will show on the DATE column for the Payment transaction type. I understand how the option you're looking for is beneficial to your business. If you want to add a column named Payment Date, you can export the report to excel. From there, you can edit the report and add the information you need. 

 

To export the report, click the Export icon on the Invoices and Received Payment report page beside the print icon. Then, select Export to Excel

 

While we continue to make your experience with us even better, I recommend visiting our QuickBooks Blog to get the recent news, information about the latest features, and updates in QBO.

 

If you have specific questions please let me know. I will be more than happy to further assist you. Have a nice day.

Need to get in touch?

Contact us