Skip to main content

How is "Average Days to Pay" Calculated in Kolleno

Average Days to Pay in Kolleno shows how long, on average, it takes a customer to pay their invoices after the due date

Kolleno Support avatar
Written by Kolleno Support
Updated this week

Tracking Average Days to Pay helps you plan cash flow, spot late-paying customers, prioritise collections, and reward those who pay on time.

Where to Find It in Kolleno?

  1. Go to Customers from the left-hand navigation.

  2. Select the customer you want to review.

  3. Navigate to the Insights tab.

  4. Locate Average Days to Pay at the top of the customer profile.

In this example, Average Days to Pay = 0 days, meaning the customer, on average, pays on the due date.


How It’s Calculated

Kolleno calculates Average Days to Pay as a simple average:

Example:

If a customer has 3 invoices:

  • Invoice 1: Paid on time → 0 days late if paid on due date, otherwise negative number.

  • Invoice 2: Paid 5 days late

  • Invoice 3: Paid 10 days late

Calculation:

So, the customer’s Average Days to Pay = 5 days.


Included / Excluded Invoices

Included:

  • Fully paid invoices with a valid due date and payment date.

  • Payments that are at least partially applied.

Excluded:

  • Closed invoices

  • Voided payments

  • Prepayments

  • Overpayments

  • Unpaid or partially paid invoices

  • Invoices missing due or payment dates


How to Interpret "Average Days to Pay" Metric in Kolleno

Average Days to Pay Value

Meaning

0 days

Customer pays on time, on average.

Positive value (e.g., 10 days)

Customer pays late (10 days after due date).

Negative value (rare)

Customer pays early.

Did this answer your question?