by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks 2011 – New Average Days to Pay Report

Print Friendly, PDF & Email

The Average Days to Pay report was first introduced in QuickBooks 2011, however, also available in QuickBooks 2012, 2013, and 2014 As the name implies, the Average Days to Pay Report shows you the average number of days that it took each customer to pay the invoices that you sent them.

To find this report, from the Report menu in QuickBooks Pro and Premier 2011 and Enterprise 11.0 -> choose Customers & Receivables -> Average Days to Pay.

average days to pay report

Right click on the image to enlarge it.

The report lists all paid invoices and statement charges; grouped together by customer and job.  For each invoice (transaction) the report shows the number of days that it took the customers to pay the invoice.  QuickBooks will calculate the number of days to pay as the difference between the date of the invoice or statement charge and the date that you received the payment.

By default, the report displays the transaction type, the due date (based on the terms you chose for the transactions), the transaction number, any memo that you entered at the bottom of the invoice, the account (usually Accounts Receivable), the class that you assigned to the transaction,  the Amount of the original invoice, the Date of the original transaction, Paid Date, and then the Avg Days to Pay.

how long does it take for customers to pay

Right click on the image to enlarge it.

Personally, I would modify this report to make it more meaningful.

To do this, I would begin by clicking on the Modify Report button and from the Display tab; in the Columns scroll box, I would uncheck:

  • Memo (unless I kept penitent notes in the memo field of my transactions)
  • Account (unless I had multiple Accounts Receivable accounts), and
  • Class (unless having class information is pertinent)

In addition to leaving the Type, Due Date, Num(ber), Amount, Date, Paid Date, and Avg Days to Pay columns, let’s also check Terms.

modify the report to include more meaningful information

Right click on the image to enlarge it.

To make this report even more meaningful, I would move the Date column between the Type and Terms columns.  This will show the information in a more logical and meaningful way; by Type, Original transaction Date, Terms, Due Date based on payment terms, the transaction Number, Amount, Paid Date, and then Average Days to Pay.

modified average days to pay report

Right click on the image to enlarge it.

As the last step, I would memorize the report (so I wouldn’t have to make these same modifications each time I ran the report).  To perform this final step, click on the Memorize button (located at the top of the report), which launches the Memorize Report window.  I wouldn’t change the report Name, but I would choose to Save in Memorized Report Group for Customers.

memorize the modified average days to pay report

Right click on the image to enlarge it.

From this point forward, whenever I wanted to generate this report I would do so by going to the Reports menu -> choosing Memorized Reports -> Customers -> Average Days to Pay.

memorized reports improve efficienty

Right click on the image to enlarge it.

I can see that the Average Days to Pay Report would be a useful tool in helping all businesses, not just contractors, determine their projected cash flow.

how to complete a certified payroll reportRequest our FREE 142-page “What’s New in QuickBooks 2011? eBook, by completing a simple request form.

This eBook will provide you with with all the information I’ve posted here in our blog, plus MORE!

Once you’ve completed our simple request form, you’ll have instant access to this 142-page .pdf eBook, designed to be duplex printed and put in a binder for future reference.

7 Responses to QuickBooks 2011 – New Average Days to Pay Report

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

Enter your email address:

Delivered by FeedBurner

We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!

QuickBooks Time Tracker