Calculate months overdue from a due date or days overdue, and see the aging bucket for current, recently overdue, past due, or delinquent status.
Months Overdue Formula
From a due date and an as-of date, the calculator counts whole calendar months elapsed, then adds the leftover days as a fraction of the next month:
Months Overdue = FullMonths + (RemainingDays / DaysInNextMonth)
- FullMonths = number of complete calendar months from the due date to the as-of date
- RemainingDays = days between the last monthly anchor and the as-of date
- DaysInNextMonth = days in the calendar month following the anchor (28–31)
From a raw days-overdue input, the calculator uses the average month length:
Months Overdue = DaysOverdue / 30.4375
- DaysOverdue = whole days past the due date
- 30.4375 = average days per month (365.25 / 12)
Calendar-based mode is more accurate for invoices and statements because it respects actual month lengths. The days-based mode is a quick approximation when you only know an aging count.
Aging Buckets and Reference Values
Most accounts receivable and credit reporting systems group overdue accounts into standard aging buckets. The calculator uses the same brackets:
| Days Overdue | Months (approx.) | Status |
|---|---|---|
| 0 | 0 | Current |
| 1–30 | 0–1 | Recently overdue |
| 31–60 | 1–2 | Past due |
| 61–90 | 2–3 | Seriously delinquent |
| 90+ | 3+ | Severely delinquent |
For quick mental math, common day counts convert as follows:
| Days | Months |
|---|---|
| 15 | 0.49 |
| 30 | 0.99 |
| 45 | 1.48 |
| 60 | 1.97 |
| 90 | 2.96 |
| 120 | 3.94 |
| 180 | 5.91 |
| 365 | 12.00 |
Example
An invoice was due on January 15. Today is April 28.
- Full calendar months from Jan 15 to Apr 15 = 3
- Remaining days from Apr 15 to Apr 28 = 13
- Days in the next month (Apr 15 to May 15) = 30
- Months overdue = 3 + (13 / 30) = 3.43 months (103 days, severely delinquent)
FAQ
Why don't 30 days equal exactly 1 month? Calendar months range from 28 to 31 days. The calendar-date mode tracks actual months, so 30 days lands at roughly 0.99 months, not 1.00.
Does the due date itself count as overdue? No. The first overdue day is the day after the due date.
Which mode should I use? Use From Due Date when you have the original date. It accounts for short and long months. Use From Days Overdue when an aging report only gives you a day count.
Can I check overdue status as of a past or future date? Yes. Open the "As of" toggle and pick any date.