Days Past Due Calculator
Count how many days an invoice is past due. Enter the due date and the date to measure from, and see the days overdue and the aging bucket: 1 to 30, 31 to 60, 61 to 90, or over 90.
Pick both dates.
The formula
- Days past due = measurement date − due date (never below zero)
- Aging buckets: 1–30, 31–60, 61–90, and over 90 days past due
Example. An invoice due 45 days before the measurement date is 45 days past due and falls in the 31 to 60 day bucket.
Things to check
- Days past due counts from the due date, not the invoice date. An invoice that is 45 days old on Net 30 terms is only 15 days past due.
- Aging reports group unpaid invoices by these buckets to show which ones need follow-up first. The older the bucket, the lower the odds of collection.
- To work out what the delay costs, use the late payment fee or interest calculators.
Frequently asked questions
How do I calculate days past due?
Subtract the due date from today’s date. If the result is zero or negative, the invoice is not yet past due.
What are the aging buckets for receivables?
The usual ones are current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due. Some reports use different cutoffs.
Is days past due the same as days outstanding?
No. Days outstanding counts from the invoice date. Days past due counts only the time after the due date.
More free invoicing tools
- Invoice generator
- Invoice Calculator
- Sales Tax Calculator
- VAT Calculator
- Late Payment Fee Calculator
- Late Payment Interest Calculator
- Invoice Due Date Calculator
- Freelance Rate Calculator
- Accounts Receivable Turnover Calculator
- Average Collection Period Calculator
- Collection Effectiveness Index Calculator
Calculators give estimates from the numbers you enter. They are not tax, legal, or accounting advice.