Skip to main content

How to Use “Days Due” and “Invoice Days Overdue” Filters in the Invoice Table

Track invoice due dates and overdue status.

Kolleno Support avatar
Written by Kolleno Support
Updated this week

This article explains how to view invoice due dates, use the Days Due and Invoice Days Overdue fields, and create dynamic filters to track invoices that are approaching or past their due date.

When managing invoices, it is often useful to see whether an invoice is overdue or still upcoming. Kolleno provides two key tools to support this:

How to Use:

  1. Using Dynamic Filters

    • Navigate to the invoice list and open Filters.

    • Select Inv. Days overdue as the filter condition.

    • Enter a negative value to represent the number of days before the invoice becomes due.

      • Example: -2 means the invoice is due in 2 days.

    • Apply the filter to view only invoices that match this condition.

  2. Displaying the “Days Due” Column

    1. Navigate to "Columns" and enable it by clicking on the eye icon with a slash.

    2. Apply it to update the invoice table.

Difference between "Days Due" and "Days Late"

Both Days Due and Days Late are based on the invoice's Due Date, but they display the information differently:

  • Days Due

    • Shows how many days remain before the invoice is due (Negative Numbers) or how many days it is overdue (Positive Numbers).

    • This column always shows a number, even if the invoice is not yet overdue.

    • Example:

      • -2 means the invoice is due in 2 days, while 12 means the invoice is 12 days overdue.

  • Days Late

    • Shows how many days the invoice is overdue, but does not show negative values.

    • If the invoice is not overdue yet, this column remains blank (--).

    • Example:

      • If an invoice is due in 6 days, "Days Late" will show -- (As it is not late). Once the Due Date passes, it will show a positive number of days overdue (e.g., 171 Days Late).

      • If the invoice is due today for example it will be "Days Late" 0

In summary:
Use Days Due if you want to track both upcoming and overdue invoices in one place. Use Days Late if you only want to focus on invoices that are already overdue.

Did this answer your question?