How do I get a report that shows me how often a customer is late in paying its invoices?

Greetings, @chris99!

Let's pull up and customize your Transaction List by Customer report so you can identify how many days your customers pay their invoices.

1. Go to Report's
2. Select Standard.
3. Scroll down the page to Sales and customers category of your reports.
4. Choose Transaction List by Customer.
5. Click Customise.
6. Under Filter, select Transaction Type.
7. On the Transaction Type menu, select Invoice and Payment.
8. Click Run Report.

In addition, here's a couple of screenshots for your visual reference and an article you can read to learn more about customizing your report: How to Customise Reports?

Lastly, you can also save this customized report by clicking Save customisation. This way, you can easily pull up this report when needed in the future. You can find this report in your Custom reports tab.

If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.

Thanks but this still does not easily give me how often they pay their invoices late.  Using this report you still need to go through line by line and manually workout yourself whether or not the payment is in accordance with the payment terms of the invoice.  Yes, it gives the invoice date and payment date but that is all.  I was looking for something that indicates if it is within the terms or not.  The closet I got is using the INVOICES AND RECEIVED PAYMENTS report and then exporting that to Excel and then taking away the Invoice Due Date from the Payment Due Date ate to see how many days it was paid either before or after payment term.  A bit clumsy but it works.  

What I need from a report is to list all the invoices by customer, the date the invoice was due, the date it as paid and some kind of indication if it was paid within the invoice term.  This could be a boolean response or a simple calculation where a positive number is the number of days over or a negative one which is the number of days before which is what I do in Excel.  I would just nice to be able to do something this simple in QuickBooks

Hi there, chris99.

For now, there isn't a report in QuickBooks Online to help us determine how long your customers normally take to pay their invoices. 

Exporting the Invoices and Received Payments report is one of the workarounds available that you can use at this moment. I'll take this as a feature request and pass it on to our engineers. Customer suggestions and feedback will be collected and reviewed for future updates. 

You might also want to visit our App Center and check if there's a customer-management app that can generate this type of report. Here's the link: https://appcenter.intuit.com/app/apps/home?categoryId=Manage-Customers&isViewAll=true.

The Community is always here if you have other questions. 

Has this feature been included?

Hi sam95,

Currently there is no report that will show you the frequency of a customer paying late or how long they typically take to pay their invoices. As discussed above, you can use the Invoices and Received Payments exported to Excel and sort/filter it to your needs as required. If the customer currently has overdue invoices, you can also look at using the Collections Report - this shows all overdue invoices with their due dates, how many days they are past due and the total overdue balance for each customer. You can also add a terms column to see what the original terms on the invoices were:

1. Go to the Reports tab and use the search function to locate the Collections report.
2. Select the Customise option (top right).
3. Input your required date range. Select Change columns, tick the Terms option then Run Report.

If you have insights for product improvement ideas and any product concerns to help us improve your experience while using QuickBooks Online, please feel free to go to the Settings icon in your file and click Feedback. All suggestions are welcome and reviewed for potential product enhancements.

-Kass

Hi,

Is there any update if the report was created? It would be really helpful to have that especially when having to work with a lot of data and going line by line is not an option. 

Thanks,

Gjergj

I appreciate you following up on this thread, gjergj.

I know how important it is to have this report in the system. However, we haven't added this type of report yet.

While QuickBooks aims to find new ways to make sure that your product meets your needs, I'll be sure to take note of this idea for future enhancements.

For the time being, you can visit our blog. This way, you’ll be updated about what new changes and features, and hopefully this feature would be one of them.

In case you need more ideas on how to customise and utilise your reports in QuickBooks Online, you can visit the following article: Customise reports in QuickBooks Online. Also, this will provide you a link on how to manage and share your custom reports.

If there's anything else you need, please let me know. I'd be more than happy to work with you to ensure everything in your QuickBooks is accurate. Have a good one!

It's so stupid how simple things like this are unable to be done in QuickBooks, and no one ever adds them either.

Literally a report that has columns:
Customer

Invoice number

Invoice Due Date

Date Paid

A SIMPLE report with those columns are all we need to see to calculate a nice list of how late people have paid. I can't believe you can't even do simple things like this in QuickBooks. The data is there, all it needs is to be properly presented in an exportable format.

The invoices and received payments report is super clunky because the payments and invoices are on separate lines. Just put the invoice and payment on the same line and have the dates so we can easily move across and calculate the difference between the dates.

Hi chris17, 

Outside of the work arounds given above by my colleague Kass, at this point in time we do not have a report to show you the frequency of a customer paying late. Your feedback helps push demand for improved features and for them to be implemented in future product updates. I would encourage you to follow the below steps to send your words directly to our product engineers. All suggestions are welcome and reviewed for potential product enhancements.

1. Select the Gear icon at the top, then Feedback.
2. Enter your comments or product suggestions then select Next.
3. You'll be provided a list of suggested Help articles related to your comment. You can read through them or select Skip and send message.
4. From the drop-down, choose the appropriate category, then select Send message.

-Steven

If we would be allowed direct access to the database some of us could create a simple SQL query that would provide the exact report that we're needing.

For what it's worth, I need to be able to run this report as well :)

Update: The average days to pay report was helpful

We should be able to see how many days late a customer is. The frequency in which they're late helps apply late charges and finance fees. 

Hi marcomiranda, 

Thanks for joining the thread. 

I understand how important it is to be able to pull up a report that will show you the frequency of a customer paying late or how long they typically take to pay their invoices. On the other hand, you can run an Invoices and Receive Payments report and export it in Excel file to be able to manually calculate the days it takes for your customer to pay. 

Feel free to send your valuable feedback by going to Gear icon and select Feedback to have this feature be added on the future releases of QuickBooks Online.  

Just letting you know that we're still needing this simple report. Client, INV#, DUE DATE, PAYMENT DATE

This thread is 4 years old and this seems like a reasonable request. I spent almost 2hrs yesterday trying to figure out within QBO and by possibly exporting into excel but I'm not any closer. We just need PAYMENT DATE as one of the options to include in the report. 

Thanks

Jesse

I also am needing this report!!

Hello peakind,

I can understand the need to be able to run a report showing the frequency of how often a customer is late in paying an invoice in QuickBooks Online. However, we haven't added this type of report yet. Please continue using the workaround provided by my colleagues above.

I recommend sending your product feedback directly to our product engineers. All suggestions are welcome and reviewed for potential product enhancements. To send product feedback, click on the Settings icon in QBO and choose Feedback.

Post again in the Community if you have further concerns about QuickBooks Online. I'll be around to help you.

5 year old thread and no updates. Typical and pathetic.
Only reason this company exists is because it has a monopoly over it's product market and every company just defaults to QBs.

Go out of business please

Your work around does not give the information we are looking for.
It just lists the Due date, not the date paid. Or how long it took to pay

This only shows open invoices, not past

Allow me to share an update about this report, @peakind.

Please know that we still don't have a report that allows you to customize the columns you mentioned. With this, I highly recommend giving our engineers direct feedback.

Here's how you can share your feedback with us:

1. Go to the Gear icon, located at the top right corner.
2. Select Feedback.
3. Enter your suggestions/comments, then click Submit.

If you want to keep track of the status of your feedback, please refer to this link: Customer Feedback for QuickBooks Online.

Moreover, you can always visit our QuickBooks Blog for the latest innovations and product news.

In the meantime, let's run Invoices and Received Payments report:

1. Navigate to Reports, then search Invoices and Received Payments.
2. Click Customise.
3. On the Rows/Columns drop-down, select Invoice Date and Due Date.
4. If you want to show the past Invoices, click the General drop-down.
5. On the Report Period, choose All Dates.
6. Click Run report.

You can also see open invoices by running the Open Invoices Report.

Additionally, these articles can help you personalize and memorize your reports: 

• Customise reports in QuickBooks Online
• Memorise reports in QuickBooks Online

Let me know if you have further queries about changing the size of the custom field of your invoice. Keep safe.