Invoice age vs. days past due: which number are you reading?

Why the distinction matters

Two people can describe the same invoice as “45 days” and mean different things. One may be measuring time since billing; the other may be describing lateness. Before using that number in a collection discussion or financing file, identify the starting date.

For the wider report context, see accounts-receivable aging explained. This article addresses only the date distinction, not the complete underwriting process.

Check what the report is actually measuring

Intuit describes its accounts-receivable aging reports as showing outstanding balances and how long they are past due. It distinguishes a summary report from transaction-level detail. This describes the cited QuickBooks help page; do not assume every accounting export uses the same settings.^[1]

• Report date: the point in time the balances and dates are measured against.
• Invoice date: the starting point if you are calculating invoice age.
• Due date: the contractual payment date used for a past-due calculation.
• Report settings: the aging basis, day bands and treatment of transactions or adjustments.

For a simple worksheet, invoice age equals report date minus invoice date. Days past due equals the greater of zero and report date minus due date. A future-due invoice is not overdue merely because it has been outstanding for several weeks. Confirm the actual due date instead of assuming that “net 30” has been entered correctly.

One invoice, two different numbers

If the agreed due date were instead September 30, the invoice would still be 45 days old on September 15 but would have zero days past due. The age does not change; the lateness does. That is why a number without its date basis is not enough for a financing or collection discussion.

What to do before sending the report

1. Save the detailed report with its as-of date and settings, not only a cropped total.
2. Choose one invoice and independently check invoice date, due date, outstanding amount and assigned bucket.
3. Reconcile credits and recorded payments with the finance team; document differences instead of silently moving balances.
4. Ask the recipient which definition of age it needs. If the agreement uses a different basis, provide a clearly labelled reconciliation.

When the answer changes

The simple formula is a check, not a replacement for the accounting system or contract. Due dates may have been revised. A payment may be recorded but not applied. A dispute can affect collectibility even when an invoice is not yet overdue. None of those issues is resolved merely by putting an invoice in a younger bucket.

Likewise, no specific advance percentage or eligibility cutoff follows from this example. Ask the proposed provider how it treats the relevant dates and exceptions. Keep its rule attached to that provider and agreement instead of presenting it as an industry-wide threshold.