Skip to main content
D
DanBu
March 7, 2024
Question

Customer Report showing average days "past due" (NOT average days to pay)

  • March 7, 2024
  • 1 reply
  • 0 views

We issue Invoices with variable Terms from Due upon order (Net 0) to Net 60. The Average Days to Pay report under Reports>Customers & Receiveables>Average Days to Pay will provide the # days, but this is not restricted to the # days PAST DUE. 

 

If the terms are Net 30 and a customer pays on Day 40, I would like to see the data that they paid 10 days PAST DUE. 

If the terms are Net 60 and a customer pays on Day 40, I would like this to be eliminated from the report data because it was paid early and was not PAST DUE at the time of payment. 

 

Any assistance in finding a report like this would be greatly appreciated!

Dana

1 reply

S
Shania_C
March 7, 2024

Hi there, @DanBu.

 

Allow me to share some information about your concern a customer report that will show average days "past due" (NOT average days to pay) in QuickBooks Desktop (QBDT).

 

The Average Days to Pay Report displays the data of the current total average time your customers pay you. However, the term Net 30 where a customer pays on Day 40 and the payment is 10 days past due is not yet available in QBDT.

 

Furthermore, the option to eliminate the data for the terms Net 60 where the customer pays on Day 40 and was paid early and not within the past due time of the payment is also unavailable. Nevertheless, as a workaround, you can export the data to Excel and customize it outside QuickBooks.

 

Additionally, here are some articles that you can read to help speed up the review process and personalize your reports in QBDT:

 

 

If there's anything else you need to accomplish for your customer report, please let me know by leaving a comment below. I'd be more than happy to work with you. Keep Safe!

Terms & ConditionsAccessibility statement