Question

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

Forum|Forum|7 years ago
January 16, 2019
58 replies
184 views

No text available

QuickBooks Online

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:

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

Also, you can check if there is a third party reporting application that would create this report for you in the Appcenter.

I'll be around if you have any questions about QuickBooks. Have a good one!

M

mhwill

What kind of workaround is this? This is the laziest response that you could have possible given. "We don't have a report to show you the average amount of days it takes for your customers to pay you. But, did you know that you can export a report to Excel?" How does that help? At least tell us which report to run and how to customize it so that we get the information we are looking for, since your dumpster fire of a product doesn't actually provide a streamlined method of managing customer's accounts.

AlexV

Level 10

Agreed, Intuit this has gone on way to long. It should be easy for your team to add this. Serious concern from the above users about this missing report. Please respond why this report is not available yet? Why is low priority?

Hello jedrolfe!

Thanks for joining this thread. Let me assist you in running the report you need.

I know that QuickBooks Online doesn't have an Average Days to Pay report. Currently, this is only available in QuickBooks Desktop. You'll want to follow the workaround shared by my Giovann_G and JessT, by running the Invoices and Received Payments report.

Also, our engineers keep on updating QuickBooks Online to meet the needs of every business. You'll want to send feedback and let them know that you want the Average Days to Pay report to be added in QuickBooks Online. Go to the Gear icon and select Feedback.

Although a feature request has been sent, we're unable to determine when it'll be implemented. However, it's most likely to be prioritized if our team received more requests about it.

I added this link if you need help in running, customizing, and saving financial reports in QuickBooks Online: Run reports in QuickBooks Online.

Please know that you can always post here if you have other concerns. Stay safe!

J

jbowman1611

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

I (eye)	IF(C7="Payment",E7,I5)
J	IF(I8=I7,J7,G8)
K	IF(C7="Invoice",J6-G7,-1)
L	IF(I7=I6,"",AVERAGEIFS(K:K,I:I,I7,K:K, ">=0"))

And the bottom:

L	AVERAGE(L7:L34)
L	MINIFS(F:F,C:C,"Invoice")
L	MAXIFS(F:F,C:C,"Invoice")

Hope that helps.

IamjuViel

Level 8

I am delighted to have you here, @jbowman1611.

I appreciate the steps in generating an average day to pay report that you've shared. The steps will help a lot of customers who are also having the same concern.

Your QuickBooks Online subscription comes with the ability to track income and expenses, send invoices, run payroll and pay and file your taxes. I suggest checking out these articles for tips on how to unlock the software's full potential: QuickBooks Online Help Articles.

You can post anytime if you have questions or want to share your best practices using the product. Have a great rest of your day.

L

ldemichele

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

J

Joelo

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.

T

tstruminger

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

D

Dan P11

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!

C

ChristineJoieR

QuickBooks Team

I heard your sentiments, @Dan P11.

We are committed to providing the best possible service to our customers, and your feedback is advantageous in helping us achieve this. We are constantly working on updates and improvements to enhance the functionality and user experience of QuickBooks Online.

We appreciate your patience and understanding as we strive to make QuickBooks Online as comprehensive and user-friendly as possible, and we would like to send our heartfelt gratitude for being with us and for using QuickBooks Online.

If you are willing to submit your suggestion, check out the steps below:

Go to the Gear icon.
Under the Profile column, select Feedback.
Share your suggestion, then click Next.

You'll want to track your suggestions through this website. You can also visit our blog to keep up with our recent events and developments.

If you have other questions about managing reports, add them below. Please don't hesitate to reach out if you have suggestions or concerns. Your satisfaction is our top priority.

R

Rocker252

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

Sign up

Login with SSO

Let's get you signed in

Login with SSO