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
CurrentHow 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 Bucket | DPD Range | Typical Eligibility |
|---|---|---|
| Current | 0 | Eligible: highest advance rate (85-90%) |
| 1-30 DPD | 1 - 30 | Eligible: standard advance rate |
| 31-60 DPD | 31 - 60 | May be eligible at reduced rate (70-80%) |
| 61-90 DPD | 61 - 90 | Often excluded or heavily discounted |
| 91-120 DPD | 91 - 120 | Typically ineligible |
| 121+ DPD | 121+ | Ineligible: usually written off |
Frequently Asked Questions
What is Days Past Due (DPD)?+
How is DPD calculated?+
What are the standard aging buckets?+
Why does DPD matter for borrowing base calculations?+
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.