One overdue invoice is a nuisance. Several piling up is a cash flow problem. Knowing your total overdue amount at any moment is the first step to addressing it systematically.
Why tracking the overdue amount matters
Freelancers who don’t track their outstanding balances often discover the problem too late — after cash flow has tightened and the oldest invoices have aged past the point where collection is realistic. Knowing your overdue total keeps you honest about who you need to chase and gives you data for business decisions, like whether to take on a new project from a client who already owes you money.
A simple spreadsheet with columns for client name, invoice number, invoice date, due date, amount, and days overdue covers the basics. Invoice tools like Waco automate this entirely, surfacing overdue amounts in a live dashboard.
Segmenting overdue amounts by age
Not all overdue invoices are equally urgent. Segment your outstanding amounts by age:
- 1-7 days overdue: Send the first reminder immediately. Most of these resolve quickly.
- 8-30 days overdue: Requires active follow-up. Client is aware but not prioritizing payment.
- 31-60 days overdue: High risk of write-off without escalation. Consider firm demand letter.
- 60+ days overdue: Difficult to collect. Time to consider small claims or collections.
The older the balance, the lower your recovery odds. That is the core reason to act on day one rather than waiting.
Invoices that hit 60 days overdue have a sharply lower collection rate than those chased in the first two weeks. Early action is the highest-ROI collection strategy.
Adding late fees to the overdue amount
If your contract includes a late fee clause, calculate the fee from the original due date. A common structure is 1.5% per month on the outstanding balance. On a $2,000 invoice, that is $30 per month — enough to motivate payment without being punitive.
Issue an updated invoice that shows the original amount, the late fee calculation, and the new total. Keep the original invoice in your records. If you end up in small claims court, having both documents strengthens your case.
Communicating about large overdue balances
When the overdue amount is significant — several thousand dollars or more — consider a phone call in addition to emails. A direct conversation allows you to understand what is actually happening on the client’s end. Some clients are dealing with their own cash flow issues and will respond well to a structured payment plan that gets the full amount paid over two to four weeks.
Offer payment plans only for clients you trust and only in writing. Get the plan terms confirmed by email before agreeing.
Using Waco to stay ahead of overdue amounts
Waco tracks every invoice from the moment you send it. You see open and view activity in real time, and overdue invoices surface automatically in your dashboard. Instead of maintaining a manual spreadsheet, you have a live picture of what is outstanding, by how much, and for how long. When you need to chase, the invoice link is right there to resend with one click.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
