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?

 
11 Comments 11
Alessandra_B
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!

rstewart1
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)?

 

FritzF
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!

rstewart1
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?

 

 

MirriamM
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.

IECElevator
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?

Quick Books desktop used to have a report of Average days to pay by Customer.  This report would list all customers and would calculate the average for each customer.  That was an excellent report and Quickbooks on line should make an effort to put that report back into their software.

JonpriL
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 @IECElevator,

 

As of the moment, there isn't an integrated way to pull up a single report based on the columns you described. Instead, you customize and add the columns after exporting the report into an Excel file.

 

With this, let's consider letting our product developers know about your request by following the steps below:

  1. Go to the Gear icon.
  2. Under PROFILE, select Feedback.
  3. Describe your request in a few words. Say - A transaction report showing the average days of  payment.
  4. Click Next.

On top of that, I've also included this reference for a compilation of articles you can use while working with us: The QuickBooks Blog.

 

If you have any other questions, please let me know by leaving any comments below. I'll be here to lend a hand.

Wonzran
Level 2

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 are literally dozens if not hundreds of threads requesting this very basic report over many years.   Why is this an issue and why isn't Intuit more responsive.  The data exists in QBO (ex: I can go into each individual invoice to identify what payment was applied to the invoice, including the date paid), but cannot get this very basic report.

RandyC1
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?

Has anybody figured out the best way to get Average days to pay on QBO?

 

I agree with Wonzran, its ridiculous this is not an built in easy report in QBO. 

generalalex5050
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?

I am so perplexed that even after 100's of people requesting the option to see the amount of days it takes a customer to pay be put in QBO - IT STILL ISN'T DONE.  Isn't this a simple part of bookkeeping.  If I have a customer that is hobitually late we put them on Credit card up front. Simple.  Why can't this be added in this computer age world.... there has got to be a better system out there then.

OSP2018
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?

SOLVED(ish)

 

1.Run the Invoices and Received Payment Report

2. In Column D type the following formula...example is for cell D5

             =if(C5="Invoice",if(C4="Payment",C4,D4))

This will look to see if the line item is an invoice, if so it will look at the previous line item to see if there was a payment, if there was it will populate the date. If not if will cascade up until it finds a date

3. In Column F, calculate the delta between Invoice Date (column B) and calculation in column D

4. Fill in the customer name on all rows in Column A - I'm doing this manually but I'm sure there is an automated way.

5. Pivot table with Customer Name, Average of Column G with a filter for only Invoices

 

BOOM!!!

 

Need to get in touch?

Contact us