Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI have details on the availability of the Average Days to Pay report, PBJ10. I can also show you a workaround to obtain a copy of this financial data.
The Average Days to Pay report is unavailable in QuickBooks Online (QBO). As a workaround, you can pull up either the Transaction List by Customer or the Invoices and Received Payments or any report you can use to determine how long your customers generally take to pay their invoices. After that, export it into an Excel file to allow for the creation of formulas to calculate the variance between the invoice dates and their corresponding payments. Then, you can calculate the mean of these variances to find the average number of days it takes for each customer to make payments.
Let me show you how:
Additionally, you can also explore other third-party applications to help you generate this type of report. You can directly find one on the QuickBooks App Store or through the QBO Apps menu.
Drop by again if you have more questions or follow-up concerns about the different financial reports in QBO or other related tasks, PBJ10, and I'll be sure to offer a helping hand. Just leave a comment below. Stay safe, and don't hesitate to seek our assistance whenever necessary.