Days Overdue Calculator

Last updated: March 26, 2026

Calculate days past due from a due date, review invoice aging and grace-period status, and estimate late fees for invoices or bills. It works for open balances and for payments that have already been recorded.

Days Overdue Inputs

Days Overdue Snapshot

Days overdue

Overdue

12 business days late

Aging bucket

1-30 Days

Low risk

As-of

Mar 29, 2026

Due Mar 11, 2026

Chargeable days

13 days

Grace ends Mar 16, 2026

Estimated late fee

$72.00

At risk $4,872.00

Detailed Breakdown

Open the full tables, formula substitution, and workflow notes.

Current-input substitution

As-of date - due date = Sun, Mar 29, 2026 - Wed, Mar 11, 2026 = 18 late days

Aging bucket: 1-30 Days

Late-fee math

Late fee = $4,800.00 x 1.50% = $72.00

Fee setting: 1.50% once

Metric	Value
Mode	Days overdue
Due date	Wed, Mar 11, 2026
As-of date	Sun, Mar 29, 2026
Calendar days late	18
Business days late	12
Days until due	0
Chargeable late-fee days	13
Grace period end date	Mon, Mar 16, 2026
Weeks late	2.6
Months late	0.6
Aging bucket	1-30 Days
Risk level	Low
Amount owed	$4,800.00
Estimated late fee	$72.00
Total balance at risk	$4,872.00

Timeline event	Date	Relation to due date
Due date	Wed, Mar 11, 2026	Baseline due date
Grace period ends	Mon, Mar 16, 2026	5 days after due date
As-of date	Sun, Mar 29, 2026	18 days after due date

Assumption notes

Calendar days drive the aging bucket by default.
Business-day count excludes weekends only and does not remove holidays automatically.
Grace periods delay fee start but do not replace the original payment deadline unless the contract says so.

Workflow note

The item is 18 days past due as of Sun, Mar 29, 2026, which places it in the 1-30 Days bucket. Send a reminder, confirm receipt, and resolve routing or approval blockers quickly. With 13 chargeable late-fee days, the current estimate is $72.00 and the balance at risk is $4,872.00.

Recommended action: Send a reminder, confirm receipt, and resolve routing or approval blockers quickly.

Related Calculators

Editorial & Review Information

Reviewed on: 2026-03-26

Published on: 2025-12-02

Author: LumoCalculator Editorial Team

What we checked: Date-count math, grace-period treatment, late-fee arithmetic, example calculations, and source accessibility.

Purpose and scope: This page supports overdue-balance review, invoice aging analysis, collections prioritization, and payment-status review. It is not legal advice and not a substitute for the contract or policy that actually governs late fees and collections steps.

How to use this review: Confirm the real payment deadline first, apply the same grace and fee rule your agreement uses, then treat the days-past-due count, aging bucket, and fee estimate as planning signals for follow-up rather than automatic enforcement instructions.

Use Scenarios

Workflow use

Collections queue review

Sort balances by days late, days past due, grace-period status, and aging bucket before reminders, calls, or escalation decisions go out.

Policy check

Fee-waiver or exception check

Use the page as a late payment calculator or late fee calculator for invoices when you need to test whether the balance is still inside a grace window or whether a fee estimate should anchor an exception discussion.

Input handoff

Due-date handoff from invoice terms

If you want an invoice overdue calculator result but still need to convert invoice terms into the real deadline, start with the Net 60 Days Calculator before treating the balance as overdue.

Formula Explanation

Step 1

Count days past due from the due date

Calendar days late = Comparison date - Due date

This is the core math behind a days overdue calculator. The comparison date is either the as-of date or the payment date, depending on the mode. A positive gap means the balance is late. A negative gap means the payment deadline is still ahead.

Step 2

Translate late days into an aging bucket

Aging bucket = Current / 1-30 / 31-60 / 61-90 / 90+

Aging buckets are planning ranges. This is what makes the page work like an invoice aging calculator, not just a simple date-difference tool. They tell you how urgent the follow-up is and make it easier to compare one overdue balance with another inside the same collections workflow.

Step 3

Separate grace days from chargeable fee days

Chargeable days = max(Calendar days late - Grace period, 0)

Grace periods delay when fees begin. They do not automatically move the original payment deadline. That is why a balance can be late for aging purposes while still showing zero chargeable fee days.

Step 4

Apply the selected late-fee assumption

Flat fee / one-time % / daily % / APR-style compounding

The calculator supports four common fee models so you can match the agreement more closely. That lets the same page act as both a days overdue calculator and a practical late payment calculator for invoices or bills. It also shows a business-day count as a supporting metric, but the main aging bucket remains based on calendar days unless your reporting policy says otherwise.

How to Read the Result

Status read

Not yet due or due today

The balance should stay in the normal payment queue. Use the payment deadline to stage reminders or approvals before the first overdue day appears.

Status read

In grace period

The item is already late for tracking purposes, but fee-bearing days are still zero. This is the moment to decide whether reminder language should stay soft or become more explicit.

Status read

1-90 days overdue

The balance now belongs in active follow-up. If you are using this page as an invoice aging calculator, this is the range where bucket placement, chargeable days, and fee exposure start to shape the next action.

Status read

90+ days or paid late

At this point the balance has either become a collections-risk account or already represents a documented late-payment event. That is where payment-date mode becomes useful as a late payment calculator for history review, waiver decisions, and account-management notes.

Invoice Aging Bucket Reference

Bucket	Days late	Risk level	Typical next step
Current	Not overdue	None	Monitor the due date and keep the invoice or bill in the normal payment queue.
1-30 Days	1-30	Low	Send a reminder, confirm receipt, and resolve routing or approval blockers quickly.
31-60 Days	31-60	Medium	Escalate follow-up, confirm dispute status, and set a specific payment commitment.
61-90 Days	61-90	High	Move into management review, tighten terms, or require a structured payment plan.
90+ Days	90+	Critical	Treat as a collections-risk account and document next-step decisions immediately.

Common Invoice Late Fee Structures

Context	Typical fee	Planning note
B2B invoices	1% to 2% per month	Common planning range when contracts allow interest on past-due balances.
Professional services retainer	$25 to $100 flat	Often used for smaller recurring invoices instead of daily interest.
Rent or occupancy charge	5% to 10% or flat fee	Frequently paired with a short grace period before the fee posts.
Membership or subscription arrears	$10 to $50 flat	Some businesses waive this on the first offense to preserve retention.

Grace Period Guidelines

Reference range

Commercial invoice

0 to 10 days

Often depends entirely on contract language rather than a default industry rule.

Reference range

Rent or lease payment

3 to 5 days

Used to delay the fee trigger, not necessarily to change the original due date.

Reference range

Loan installment

10 to 15 days

Late fees may wait for grace to end while interest still accrues under the contract.

Reference range

Insurance premium

Up to 30 days

Coverage and cancellation rules can differ from simple late-fee logic.

Example Cases

Example 1

Case 1: AP follow-up on a standard invoice

Inputs

Due date: March 1, 2026
As-of date: March 19, 2026
Amount: $4,800
Grace period: 5 days
Late fee: 1.5% once

Computed results

18 calendar days overdue
13 chargeable late-fee days
1-30 day aging bucket
$72 late fee and $4,872 total

Interpretation

The balance is still in an early-stage bucket, but grace has already ended and the fee estimate is now large enough to influence follow-up language.

Decision hint

Send a direct reminder, confirm invoice routing, and record the expected payment date before the account slips into the next bucket.

Example 2

Case 2: Service invoice paid after due date

Inputs

Due date: February 1, 2026
Payment date: February 12, 2026
Amount: $2,400
Grace period: 3 days
Late fee: $50 flat

Computed results

11 days paid late
8 chargeable late-fee days
1-30 day aging bucket before payment
$50 fee and $2,450 balance at risk

Interpretation

The balance has already cleared, but the payment history still counts as a late event and the fee decision should be consistent with policy.

Decision hint

Decide whether to enforce or waive the one-time fee, then use the same rule for similar accounts so exceptions do not become arbitrary.

Example 3

Case 3: 90+ day collections triage

Inputs

Due date: December 1, 2025
As-of date: March 16, 2026
Amount: $18,000
Grace period: 0 days
Late fee: 0.05% per day

Computed results

105 calendar days overdue
105 chargeable late-fee days
90+ day aging bucket
$945 fee and $18,945 total

Interpretation

This is no longer a routine reminder case. The fee estimate is material and the aging range now signals serious collections risk.

Decision hint

Escalate to management review, confirm dispute status, and document whether the next step is a payment plan, tightened terms, or formal collections.

Boundary Conditions

Calendar days control the main aging bucket. Business days are shown only as a supporting metric, so this is not a holiday-aware business-day calculator for past-due balances by default.

Grace periods delay when fees begin, but they do not erase the original payment deadline unless your policy explicitly rewrites that deadline.

Fee estimates do not model caps, tiered penalties, waiver policies, state-specific rent limits, attorney fees, or negotiated settlement terms.

Payment-date mode measures one payment event. It does not reconstruct partial payments, credits, split settlements, or short-paid invoices automatically.

If the payment deadline itself still depends on a recurring cycle, use the Billing Date Calculator before treating the item as overdue.

Contract disputes, approval holds, tax adjustments, and credit memos can change what should really be collected, so the result should be reviewed alongside the account record.

Sources & References

U.S. Bureau of the Fiscal Service - Prompt Payment - Official late-payment context for invoices, including why payment timing, invoice deadlines, and discount windows matter after a bill becomes due.
U.S. Bureau of the Fiscal Service - Prompt Payment: Interest Calculator - Simple daily interest formula reference for short late-payment periods and daily-rate fee modeling.
U.S. Bureau of the Fiscal Service - Prompt Payment: Monthly Compounding Interest Calculator - Monthly-compounding reference formula for longer late-payment periods and APR-style overdue balance modeling.
Zoho Billing - Late Fees - Operational examples of fixed-amount and percentage late fees applied only after an invoice becomes overdue.
U.S. Bureau of the Fiscal Service - Weekend and Holiday Guidelines - Weekend and holiday handling note used to explain why due-date policy can differ from a simple baseline day count.

Frequently Asked Questions

How do I calculate days past due on an invoice: from the invoice date or the due date?

Start from the due date, not the invoice date. Aging begins only after the real payment deadline is known. If you still need to turn terms such as Net 30 or Net 60 into that deadline, use a net-terms calculator first and then bring the final payment deadline into this page.

Why can an overdue invoice still show zero chargeable fee days?

Because this calculator keeps two clocks separate. The aging bucket starts once the payment deadline passes, but chargeable fee days start only after any grace period ends. That lets a balance appear late for follow-up while still showing no fee-bearing days.

Does this days overdue calculator use calendar days or business days?

Aging buckets use calendar days because that is the most common baseline for past-due reporting. The result also shows business days late as a supporting metric, but that count excludes weekends only and does not automatically remove holidays.

Can I use this page as a late payment calculator after an invoice is already paid?

Yes. Payment-date mode measures how late the payment actually cleared, which helps with customer-history tracking, fee-waiver review, and internal audit notes. It is especially useful when the balance is no longer open but you still need to document the lateness event.

How should I choose the late-fee method in this late fee calculator for invoices?

Match the contract or policy rule you actually use. Pick a flat fee for one-time fixed charges, one-time percentage for a single past-due percentage, daily rate for per-day penalties, and APR mode when the agreement behaves more like interest on the overdue balance.

What situations does this invoice overdue calculator not model well?

It is a weak fit for partial payments, credit memos, disputed balances, fee caps, tiered penalty clauses, state-specific rent limits, and holiday calendars. It also does not reconstruct a multi-step settlement history from one final payment date.

Does an overdue result automatically mean I should charge a fee or escalate collections?

No. Contract language, internal policy, local law, customer history, and waiver strategy all matter. The late-fee result is a planning estimate, and the aging bucket is a workflow signal, not an automatic instruction to impose a charge or move straight to formal collections.

When should I use a net-terms or billing-date calculator instead of a days overdue calculator?

Use a net-terms calculator when you still need to turn invoice terms such as Net 30 or Net 60 into the final payment deadline. Use a billing-date calculator when you are planning recurring monthly or quarterly cycles rather than reviewing one overdue balance at a time.