Track your open invoices, calculate due dates and aging buckets, and view a prioritized collections follow-up queue. Keep your cash flowing without standard accounting software logins.
| Client | Invoice # | Amount | Issued | Due Date | Age | Overdue | Bucket | Action / Controls |
|---|
| Invoice / Client | Amount | Urgency |
|---|
| Client | Outstanding | % Total |
|---|
Aging reports categorize outstanding invoices by time. Knowing these divisions helps you plan collections outreach.
Most businesses classify unpaid receivables into five time-based categories relative to their due dates:
Invoice Age Formula: Invoice Age = Report Date − Invoice Date (in days)
Days Overdue Formula: Days Overdue = max(0, Report Date − Due Date) (in days)
Practical outreach recommendations to recover balances while preserving business relationships.
Keep the tone helpful. For Current invoices, focus on confirming that the client received the invoice and that no questions or disputes remain. For invoices 1–30 days late, send a friendly payment reminder email within 3 to 5 days of the due date, attaching a copy of the original invoice and clear payment link details.
Escalate to direct communication. Send a second, firmer invoice reminder noting the exact number of days overdue. If email yields no response, have your accounts team or manager make a polite check-in phone call. Verify if the client has a dispute, a payment processing bottleneck, or requires a brief payment schedule adjustment.
Formally request payment. Send a formal demand letter stating that payment is overdue and outlining next steps (such as late interest application or service suspension). For accounts past 90 days, run a cost-benefit review to decide if you will write off the balance, file in small claims court, or assign the account to an external collections agency.
Compare how different invoice dates and credit terms place outstanding items in different categories.
Let's look at how six typical invoices would sit in an aging report ran on July 13, 2026:
Answers to common questions about managing business receivables and collection logs.
For most freelance operators and small businesses, running an aging report weekly or bi-weekly is ideal. This ensures you spot late payments quickly, send timely reminders, and maintain a steady cash flow without letting invoices slip past critical 60 or 90-day marks.
The most common payment term is Net 30, meaning payment is due within 30 days of the invoice issue date. Other common terms include Net 15, Net 60, or Due on Receipt. Offering shorter terms (like Net 15) or discount incentives for early payment (like 2/10 Net 30) can help accelerate incoming payments.
Client concentration measures the percentage of your total outstanding receivables tied to a single customer. If one customer represents 50% or more of your receivables and they delay payment or default, it creates a serious cash flow bottleneck. Spreading risk across multiple customers is safer.
Yes, provided your customer agreed to late fees in writing (e.g. in your contract or signed proposal) before the invoice was issued. If late fee terms are agreed to, you can use our Invoice Late Fee Calculator to calculate the exact interest or flat administrative charges to apply.
Use these calculators to estimate late charges and manage cash cushions.