Submit Your Suggestions For ProContractor

Collaborate with Viewpoint and your peers by providing us with your input

Customer Average Days to Pay Report

We have used this report for years to determine our best paying customers and such... We switched to VP in 2016 and it doesn't provide this.

  • Monica Garcia
  • Dec 11 2017
  • In Review
Company Coburn and Company
Job Title / Role Accountant
I need it... 1 month
  • Attach files
  • Monica Garcia commented
    October 09, 2018 18:26

  • Monica Garcia commented
    October 09, 2018 18:17

    Average days to pay = the total number of days to pay divided by the number of closed invoices.

    For Example: Your closed invoices report shows 3 closed invoices for a customer.

    Invoice 1 was paid 5 days after the invoice date.

    Invoice 2 was paid 10 days after the invoice date.

    Invoice 3 was paid 15 days after the invoice date.

    Total days 'til paid is 30.

    Divide this figure by the number of closed invoices - 30/3 - equals 10 as the average days to pay.

    If you enter the payment while you are entering the invoice, using the 'paid today' feature, this invoice would have a 0 days 'til paid. If you combine this with an invoice that was paid 8 days after invoice date - then the average days 'til paid becomes 4. (8 total days divided by 2 closed invoices)

    Note: the Average Days to Pay on the Card file record is for the life of the card, not for any date range.

     

     

    From the date of invoice..... yes

  • Deleted User commented
    October 09, 2018 17:54

    Monica, what other information is needed on this report? Also, I assume the avg days to pay is the different between Invoice Date and Receipt date?

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.