Invoice Overdue Days Calculator & Aging Report
Calculate days overdue on invoices and generate professional aging reports. Track invoice aging across 0-30, 31-60, 61-90, and 90+ day buckets with recommended collection actions.
Add Invoice
Enter invoice due date to calculate aging
Enter a due date to start tracking
Get 10 More Payment Email Templates
Plus our free guide: "How to Get Paid Faster Without Being Annoying"
We respect your privacy. Unsubscribe anytime.
Understanding Invoice Aging and Days Overdue Tracking
Invoice aging analysis is a critical financial management practice that helps businesses monitor outstanding receivables and maintain healthy cash flow. By categorizing invoices based on how long they've been overdue, you can prioritize collection efforts, identify problematic clients, and make informed decisions about credit policies. An aging report provides a snapshot of your accounts receivable health, showing which payments require immediate attention and which clients consistently pay late.
The standard aging buckets—current, 0-30 days, 31-60 days, 61-90 days, and 90+ days—help you quickly assess risk levels and determine the appropriate collection strategy. Invoices in the 0-30 day bucket typically resolve with a polite reminder. Those in 31-60 days require more assertive follow-up. Invoices past 90 days often need escalation to collections or legal action. Understanding these categories allows you to implement graduated response strategies that balance relationship preservation with payment collection.
💡 Next Step: Once you know how many days an invoice is overdue, use our Invoice Follow-Up Email Generator to create the perfect payment reminder email with tone automatically matched to the aging bucket.
How to Create an Effective Invoice Aging Report
Creating a comprehensive aging report starts with accurate data collection. Gather all outstanding invoice due dates, amounts, and client information. Calculate the number of days each invoice is overdue by subtracting the due date from today's date. Categorize invoices into aging buckets based on these calculations. Include client names, invoice numbers, original amounts, and any payments received to provide complete context for collection decisions.
For maximum effectiveness, run aging reports weekly or bi-weekly. This frequency allows you to catch late payments early before they escalate into serious collection issues. Include summary statistics showing total outstanding amounts in each bucket and percentage of receivables by age category. Add notes about collection efforts, client communication history, and any payment arrangements. This documentation creates accountability and helps you track which follow-up strategies work best for different clients and industries.
Recommended Collection Actions by Aging Bucket
Not Yet Due (Pre-Due Date)
Send a friendly reminder 3-5 days before the due date. This proactive approach reduces late payments by 30-40%. The message should be warm and helpful, thanking them for their business and providing payment details. Many late payments result from clients simply forgetting or not having clear payment information readily available. Pre-due reminders set the foundation for on-time payments.
0-30 Days Overdue Invoices
Send a polite payment reminder email on day 1, 7, and 14 if payment hasn't been received. Keep the tone professional and assume good intent—delays at this stage are usually administrative oversights. Include all invoice details, payment methods, and a direct way to contact you with questions. Most invoices in this bucket resolve without escalation if you follow up promptly and consistently. Consider adding a payment link to reduce friction.
⚡ Pro Tip: When invoices hit 15+ days overdue, consider adding late fees to encourage faster payment. Use our Late Fee Calculator to determine appropriate penalties that comply with local regulations.
31-60 Days Overdue Invoices
Escalate with more formal communication. Send a professional follow-up email and make a phone call to discuss the outstanding payment. Ask if there are any issues with the invoice or reasons for the delay. This personal touch often uncovers disputes or misunderstandings that email alone misses. Suggest payment plans if the client is experiencing cash flow difficulties—receiving partial payment is better than none and maintains the business relationship.
61-90 Days Overdue Invoices
Send firm reminders mentioning late fees if specified in your payment terms. State clear consequences for continued non-payment, such as suspension of future services or escalation to collections. This is the last opportunity for amicable resolution before legal action. Document all communication attempts and the client's responses carefully. Consider requiring upfront payment or deposits for any new work with this client to protect against future non-payment.
90+ Days Overdue Invoices
Issue a final notice with a specific deadline (typically 7-14 days) before escalating to collections or legal action. At this stage, the relationship is likely damaged regardless, so prioritize payment recovery over relationship preservation. Consider engaging a collection agency or small claims court, depending on the invoice amount. Write off severely overdue invoices for tax purposes while continuing collection efforts. Use this experience to improve your client vetting process and payment term enforcement going forward.
Using Aging Reports to Improve Cash Flow Management
Aging reports reveal patterns that inform strategic business decisions. If many invoices cluster in the 30-60 day bucket, your follow-up process might be too slow or ineffective. If specific clients consistently appear in older buckets, consider implementing stricter payment terms or requiring deposits for them. High aging percentages in 60+ day categories signal the need for upfront payment, shorter payment terms (Net 15 instead of Net 30), or credit checks on new clients before accepting large projects.
Track your Days Sales Outstanding (DSO) metric using aging data. Calculate this by dividing total receivables by average daily sales. Industry averages vary, but 30-45 days is typical for B2B services. If your DSO exceeds 60 days, you're essentially providing free financing to clients, which constrains your own cash flow and limits growth. Use this metric to set goals for reducing aging invoice percentages and improving collection efficiency across your entire accounts receivable portfolio.
Invoice Overdue Calculator FAQ
How do I calculate days overdue on an invoice?
Subtract the invoice due date from today's date to get days overdue. For example, if an invoice was due on January 15, 2026, and today is February 11, 2026, the invoice is 27 days overdue (27 = Feb 11 - Jan 15). Most accounting software and our calculator handle this automatically. Always use calendar days rather than business days for consistency.
Should I count business days or calendar days for aging?
Most businesses use calendar days for consistency and simplicity. However, some industries use business days (excluding weekends and holidays). Choose one method and apply it consistently across all invoices. Clearly state your method in payment terms to avoid confusion with clients who might assume a different calculation method.
What's a healthy invoice aging distribution?
Ideally, 80-90% of receivables should be current or in the 0-30 day bucket. Less than 10% should be 31-60 days, under 5% should be 61-90 days, and minimal amounts in 90+ days. If more than 20% of your receivables are over 30 days overdue, you need to improve collection processes or tighten payment terms for chronic late payers.
How often should I run aging reports?
Weekly for active businesses with many invoices, bi-weekly for smaller operations with fewer transactions. Monthly is too infrequent—invoices can age significantly in 30 days, moving from 0-30 days to 31-60 days bucket. Regular reporting helps you catch issues early when they're easier to resolve and relationships are less strained.
Can I automate invoice aging calculations?
Yes, most accounting software (QuickBooks, Xero, FreshBooks) generates aging reports automatically. Tools like InvoiceFollowups not only track aging but also automatically send appropriate follow-up emails based on how long an invoice has been overdue, apply late fees according to your policy, and escalate collection efforts without manual intervention.
🎯 Complete Invoice Collection Workflow:
- Step 1: Use this Invoice Overdue Calculator to track days overdue and categorize aging
- Step 2: Generate payment reminders with our Email Generator (tone matches aging bucket)
- Step 3: Calculate and apply penalties using Late Fee Calculator for 15+ day invoices
- Step 4: Automate everything with InvoiceFollowups - zero manual work required