By the end of this guide, you will have a working system for tracking overdue client invoices: a single view of what is owed, an aging schedule that shows how late each balance is, and a repeatable follow-up routine. Late payments at most agencies come from a missed email or a stalled approval rather than bad intent, but they pile up fast when invoices live in several places. Before you start, gather your list of active clients, access to your invoicing tool or spreadsheet, and the payment terms from each contract.
Step 1: Gather every invoice and payment term into one place
Start by pulling every invoice you have issued into one list. Check each source where money can be requested or received: your accounting tool, Stripe, PayPal, bank transfers, and any spreadsheets or documents you used for one-off billing. An invoice that lives in a separate system is the one that goes unchased.
Record the same fields for every invoice so the list can be sorted and filtered later:
- Client name
- Invoice number
- Amount
- Issue date
- Due date
- Payment method
- Status (you will define the labels in the next step)
Next, capture each client's actual terms. Open the contract or statement of work and note whether the client is on Net 7, Net 15, or Net 30 (payment due that many days after the invoice date), or on a retainer billed in advance. Do not rely on memory. It is common to find that a client you assumed was on Net 30 signed for Net 15, or that a verbal extension never made it into writing.
One mistake is especially common among ad agencies: tracking ad spend billed through the agency separately from management fees. If a client owes a $1,500 fee and $6,000 in pass-through ad spend, the real exposure is $7,500, and splitting them across two lists hides that. Keep both as line items on the same client record, or at least add them together in your total owed.
When you finish, you should be able to answer "who owes me money right now?" by looking at one list. If your records are scattered, a client data organization system makes that single list much easier to maintain.
Step 2: Define what "overdue" means for your agency
Without a written definition, every late invoice becomes a judgment call, and judgment calls lead to inconsistent and awkward follow-up. Set the rule once.
The simplest trigger is that an invoice becomes overdue the day after its due date. Some agencies add a grace period of two to three days to absorb bank transfer delays. If you use one, apply it to everyone and write it down, rather than deciding case by case.
Then create status labels so each invoice has exactly one state:
- Draft: created but not sent
- Sent: delivered to the client
- Viewed: opened by the client, if your tool shows this
- Due soon: within a few days of the due date
- Overdue: past the due date and any grace period
- Partially paid: some money received, balance outstanding
- Disputed: the client has raised a question about the invoice
- Paid: settled in full
Keep "disputed" separate from "overdue." If a client asks why a line item looks higher than expected, an automated "your payment is late" message will sour the conversation. Moving the invoice to Disputed pauses reminders and tells you to resolve the question first, then restore the due date or issue a corrected invoice.
Finally, set different rules for retainers billed in advance and invoices billed in arrears. If a retainer invoice is overdue, you have not yet delivered the month's work, so pausing is low-risk. If an invoice for last month's work is overdue, you may already be producing this month's work for free. Arrears invoices, and anything involving ad spend, deserve a shorter fuse. Agencies that struggle with this often find the root cause is losing track of client billing cycles.
Step 3: Build an aging report to see how late each invoice is
Accounts receivable aging groups unpaid invoices by how long they have been outstanding or overdue. It turns a flat list into a picture of risk: a pile of invoices one week late is a very different situation from the same total sitting 60 days late.
Use buckets such as Current (not yet due), 1-15 days late, 16-30, 31-60, and 60+. Add a "days overdue" column calculated as today's date minus the due date, and a total for each bucket. In a spreadsheet, a formula like =TODAY()-DueDate does the calculation, and a filter or pivot table does the grouping.
Here is an illustration with made-up numbers, assuming today is October 29:
- Invoice 1041, Client A, $2,000, due October 31: not yet due, so it falls in Current.
- Invoice 1038, Client B, $3,500, due October 17: 12 days overdue, so it falls in 1-15.
- Invoice 1029, Client C, $1,200, due September 20: 39 days overdue, so it falls in 31-60.
The bucket totals would be $2,000 current, $3,500 in 1-15, and $1,200 in 31-60. The largest balance is not the most worrying one. Client C's smaller invoice has been outstanding longest, and the likelihood of collecting generally drops the longer an invoice sits.
Once the report exists, look at who keeps appearing in the older buckets. A single late payment is usually noise. A client who lands in the 16-30 bucket three months running has a pattern, and that pattern should drive decisions about their terms, which you will address in Step 7. For a broader look at how agencies handle this, see our guide to tracking overdue client payments.
Step 4: Set up automatic reminders before and after the due date
One reminder is rarely enough, and reminders sent only when you happen to remember are inconsistent, which makes each one feel like a confrontation. A fixed schedule makes follow-up routine and impersonal, which protects the relationship.
A workable sequence looks like this:
- 3 days before the due date: a friendly heads-up that the invoice is coming due.
- On the due date: a short note confirming payment is due today.
- 3 days overdue: a polite check that nothing is blocking payment.
- 7 days overdue: a firmer follow-up asking for a payment date.
- 14 days overdue: a final written notice that references the relevant clause in your contract.
Put the same four details in every message: invoice number, amount, due date, and a direct payment link. Every extra step between the email and the payment is a reason for delay, and many "late" invoices are simply buried in someone's inbox or waiting on a colleague to find the bank details.
Escalate the tone gradually. Early messages assume an oversight. The last one can reference the work-pause or late-fee clause in your agreement, stated plainly and without threats. Note that rules on late fees vary by jurisdiction, so check local requirements and have your contract language reviewed before you rely on it.
You can run this sequence through your invoicing software's reminder feature, a scheduled set of email templates, or a tool that supports automated payment tracking alongside client data. Whatever you choose, confirm that reminders stop automatically when an invoice is marked Paid or Disputed, so a client never gets a nudge for something already resolved.
Step 5: Assign ownership and a weekly review routine
Automation handles the routine nudges. It does not handle the exceptions, and exceptions need a person. Name one individual responsible for receivables. If you are a solo freelancer, that is you, but writing it down still helps. In a larger agency, shared responsibility usually means nobody follows up.
Block 20 to 30 minutes each week at a fixed time, such as Monday morning. In that slot:
- Refresh your aging report.
- Go through every overdue invoice and make sure it has a next action and a date.
- Check whether any promised payment dates have passed.
- Move any invoice with a raised question to Disputed and assign someone to answer it.
Log every contact attempt: the date, the channel, who you spoke to, and any payment date they promised. A short note such as "Spoke with finance contact October 22, payment promised by October 28" turns the next follow-up into "Following up on the October 28 date we discussed," which is far more effective than a generic reminder.
Set one escalation rule: when an invoice is more than 30 days late, stop emailing and pick up the phone. A call lets you find out whether the problem is a lost invoice, a change of contact, an internal approval, or a cash flow issue, and each of those needs a different response. It also signals that the matter is being taken seriously without a formal letter. If deadlines keep slipping through the cracks, our piece on missing client payment deadlines explains why it happens and how to stop it.
Step 6: Tie overdue invoices to your campaign and service decisions
This step is where ad agencies differ from other service businesses. You are often managing live spend, and late payment can turn into real financial exposure if you keep working as though nothing is wrong.
Decide in advance when you will pause campaign management or reporting, and put that threshold in your contract, for example a set number of days past due after written notice. Pausing work without a contractual basis invites disputes. Pausing with one is simply following the agreement.
Build a quick check into your workflow: before approving a budget increase or starting a new deliverable for a client, look at their overdue status. Scaling spend for a client who is already 30 days behind increases your risk at the worst moment.
Be most careful where the agency fronts ad spend on its own card. A late client in that situation means you are financing their advertising, and the balance can grow daily. Set a lower tolerance for these accounts, and consider prepayment or a funded ad account balance so the platform spend is covered before it happens.
This is easier when payment status sits next to performance data. A unified dashboard such as ClientPlug, which as of this writing is built to sync payments, campaigns, and client data in one place, lets you see an overdue balance beside that client's Meta or Google Ads results. Confirm the current payment-tracking and reminder capabilities in the product before you build a process around them. You can also read how to sync client payment data across your tools.
Whatever tool you use, do not pause ads abruptly. Give written warning as your contract requires, state the amount owed and the date by which you need payment, and confirm in writing when work resumes. Switching off live campaigns without notice can damage the client's results and the relationship, and it may breach your own terms.
Step 7: Measure the system and tighten it over time
A tracking system should get better with use. Review three numbers each month:
- Total overdue amount: the sum of everything past due.
- Average days late: across overdue invoices, how long they have been outstanding.
- Percentage of invoices paid on time: paid by the due date, out of all invoices that came due.
Add days sales outstanding (DSO) if you want a single efficiency figure. The formula is accounts receivable divided by total credit sales, multiplied by the number of days in the period. For example, imagine you have $12,000 outstanding, $36,000 in invoiced sales over a 30-day month: 12,000 divided by 36,000, times 30, gives a DSO of 10 days. A DSO that keeps climbing while your sales stay flat means collections are slipping, even if no single invoice looks alarming.
Use the aging report from Step 3 to find chronic late payers, then change the terms rather than just sending more reminders. Options include:
- Shortening terms, for instance from Net 30 to Net 15
- Billing retainers in advance instead of in arrears
- Requiring auto-pay or a card on file
- Taking a deposit before work starts
Raise these changes at renewal or with reasonable notice, and explain them as a standard process update. Track your own numbers for a few months before drawing conclusions, since your agency's pattern matters more than any general benchmark. For more ideas on keeping receivables healthy, see these invoice tracking strategies for digital agencies.
Your first aging report and what keeps it running
Run your first aging report this week. Confirm that every overdue invoice has a next action and a date, then let the reminder schedule and the weekly review keep the picture current. After a month or two, the numbers from Step 7 will show you where to tighten terms and which clients need a different arrangement.
If you would rather see payments, campaigns, and client data in one dashboard than maintain separate lists, Learn more about our services.