Free Tool

Days Past Due (DPD) Calculator

Calculate the Days Past Due and aging bucket for any invoice. Enter the invoice date, payment terms, and report date below.

Result

Derived Due Date

2026-10-20

Days Past Due

0

30 days until due

Aging Bucket

Current

How DPD is Calculated

The Days Past Due calculation is straightforward. First, determine the due date by adding the payment terms to the invoice date:

Due Date = Invoice Date + Payment Terms (days)

Then, calculate DPD as the number of calendar days between the due date and the report date. If the report date is on or before the due date, the invoice is current (DPD = 0):

DPD = max(0, Report Date - Due Date)

The resulting DPD value determines which aging bucket the invoice falls into. Standard buckets are:

Aging BucketDPD RangeTypical Eligibility
Current0Eligible: highest advance rate (85-90%)
1-30 DPD1 - 30Eligible: standard advance rate
31-60 DPD31 - 60May be eligible at reduced rate (70-80%)
61-90 DPD61 - 90Often excluded or heavily discounted
91-120 DPD91 - 120Typically ineligible
121+ DPD121+Ineligible: usually written off

Frequently Asked Questions

What is Days Past Due (DPD)?+
Days Past Due (DPD) is the number of calendar days an invoice has remained unpaid beyond its original due date. If the due date has not yet passed, DPD is zero (the invoice is current). DPD is the primary metric used to classify receivables into aging buckets and determine eligibility in asset-backed lending facilities.
How is DPD calculated?+
DPD = max(0, Report Date - Due Date). The due date is calculated as Invoice Date + Payment Terms (e.g., Net 30, Net 60). If the report date is on or before the due date, DPD is 0 (Current). If the report date is after the due date, DPD equals the number of calendar days between the due date and the report date.
What are the standard aging buckets?+
The standard aging buckets in AR securitization are: Current (0 DPD, not yet past due), 1-30 DPD, 31-60 DPD, 61-90 DPD, 91-120 DPD, and 121+ DPD. Receivables in the 91+ or 121+ buckets are typically excluded from the borrowing base entirely. The exact cutoffs and eligibility rules vary by facility agreement.
Why does DPD matter for borrowing base calculations?+
DPD directly determines whether a receivable is eligible for inclusion in the borrowing base and at what advance rate. Current and lightly aged receivables (0-30 DPD) typically receive the highest advance rates (85-90%). As DPD increases, advance rates decrease or receivables are excluded entirely. DPD is also a key input to cross-aging rules: if a large percentage of an obligor's receivables are significantly past due, all of that obligor's receivables may become ineligible.

Automate Aging Analysis at Scale

Olycor calculates DPD, aging buckets, cross-aging flags, and eligibility for every invoice in your portfolio automatically. Upload your AR data and see results in minutes.