How do I create an average days to pay report for one of our clients?

Hi there, swoodrum.

Currently, the report to show the Average Days to Pay report is unavailable in QuickBooks Online. However, I can guide you to prepare a similar report as a workaround. 

You can send reports to excel to calculate. Note that you can only export a report to excel one at a time.

Here's how you ca do it:

1. From the left menu, select Reports.
2. Search for and open the report you'd like to view.
3. Select the Export icon, then choose Export to Excel.

Good evening All,

I'm not terribly surprised in QBO's deficiency -- the lack of this report is just another example, but here is my solution:

Three parts are shown: 1) the basic QBO Invoices and payments report (Col A-G), 2) the "Average" calculations (Col I-L), and 3) the formulas used in Col O.

A couple of "helper columns are used to "realign" the payment with the corresponding invoices. The formulas listed in col L, are each copied to the respective columns, then copy & pasted to the bottom of the report -- in my case row 34.

The first problem is in separating and identifying which lines are payments versus invoices.  The col I & J formulas check and transfer only the Payment number and date, but for each line/invoice to which they apply. Col K formula returns the number of days between the invoice date (Col B and payment date Col J), but only for invoices -- payments always return -1.  Finally (almost), Col L take the average of all payments with the same number (Col I),  but does not include the payment (K= -1) in the average -- this happens only when the payment numbers change [caused by the outer if()].  Finally, (for real now) the bottom of Col L  a standard "Average()" is used to obtain the average days to pay.  Not to be an over achiever (LOL) but since I was here I added Min()/Max() but only on "Invoices", too.

Part of the beauty of this report, is that it can be easily used as a template by running the base report, then copying the report to the left side of the template, there will be some minor clean-up needed on the right side (based on number of rows), but the formulas should only need to be copied/moved down.

Hopefully, this will make the formulas easier to work will

And the bottom:

Hope that helps.

I agree. As well this is a must need report. Hopefully it is added only to the "essentials " version of quick books. Please Hurry. Also had an option to put customers on hold. 

Thanks

Lisa

Another example of how awful QBO is. I migrated 3 years ago because I had an off-site employee that required access the program and there was no other reasonable way to achieve this. I won't even get into the number of deficiencies this program has compared to desktop. I have 3 pages of stuff that's missing. Intuit made it really easy to migrate to QBO but left no way to bring data back into desktop. No big surprise there.

Now I have to decide if I want to go back to desktop or a completely new program because QBO is not cutting it for me. 

3 years later.....still nothing.  But they've increased the price a few times since this question was first posted....

Yes, this previous, but currently unavailable functionality is just another feature that has been taken from us in QBO, regardless of subscription level... not that I would pay a dime more for this "unaccounting system". Many of us are looking to run for the exits at this point... Nice job Intuit!

This thread was created January 2019.  It is now almost July 2024.  5 1/2 years later and STILL NOTHING has been done to create this report that we are all screaming for. 

Seriously, who do I have to get fired to get this 1 report built?  I know a lot of PE and hedge fund guys who would love to short Intuit stock just to make a few bucks.  Customer negligence is the #1 reason companies fail.  And when Short Sellers smell blood in the water . . .