An accounts receivable action plan template is a structured collections plan that sets out exactly when and how to follow up on every invoice, from the day it is issued through to escalation if it goes unpaid. Instead of chasing customers ad hoc, you follow a fixed cadence: a pre-due reminder, a due-date nudge, escalating overdue reminders at day 3, 7, 14, and 30, then formal notices, credit hold, and collections.
The template below pairs that cadence with an overdue tracker so every at-risk invoice has an owner, a next action date, and a status. Working a consistent plan is what shortens days sales outstanding (DSO), because most late payments are not refusals to pay, they are invoices that simply were not followed up. It is free, works in Excel or Google Sheets, and is pre-filled with a proven 10-stage sequence you can adapt to your terms.
The difference between a business that gets paid on time and one that does not is rarely the customers; it is whether anyone follows up consistently. An action plan turns collections from a scramble into a routine.
The 10-stage collections cadence
This is the core of the template: a repeatable sequence for every invoice. Timing is measured from the due date (day 0), with negative days before it and positive days after. Adjust the intervals and tone to suit your customers.
| Stage | Timing | Channel | Action |
|---|---|---|---|
| 1. Invoice issued | Day 0 (issue) | Accurate invoice, clear due date and terms, pay-now link | |
| 2. Pre-due reminder | 3 days before due | Friendly heads-up that payment is due soon | |
| 3. Due date | Due date | Polite reminder that payment is due today | |
| 4. First overdue | +3 days | Note it is overdue; restate amount and pay link | |
| 5. Second reminder | +7 days | Email + phone | Call to confirm and request a payment date |
| 6. Statement | +14 days | Full statement of all open and overdue invoices | |
| 7. Escalation | +30 days | Phone + email | Escalate to manager; apply late fee or interest if terms allow |
| 8. Final notice | +45 days | Formal email | Final demand with a deadline before further action |
| 9. Credit hold | +60 days | Internal + email | Pause new orders until the account clears |
| 10. Collections / legal | +90 days | External | Refer to a collections agency or legal process |
Collection probability falls fast: an invoice that is 90+ days overdue has under a 30% chance of being collected, versus 95% or more when current. A consistent cadence keeps invoices moving before they reach the danger zone, which is far cheaper than writing them off later.
The overdue tracker
The second tab is a tracker so nothing slips. Each overdue invoice gets a row with its current stage, last contact, any promise-to-pay date, the next action date, an owner, and a status. Days overdue calculates automatically. Work it oldest-and-largest first, because roughly 80% of overdue value usually sits with about 20% of customers.
What should an AR action plan include?
A complete plan has three parts: a collections cadence (when and how you follow up), a tracker (every overdue invoice with an owner and next action), and clear escalation rules (when to add a late fee, place a credit hold, or refer to collections). The template includes all three.
How do I reduce days sales outstanding (DSO)?
Invoice immediately and accurately, set short clear terms, offer easy online payment, and follow up on a fixed schedule rather than waiting for invoices to age. Prioritize the oldest and largest balances. Most overdue invoices are simply un-chased, so a consistent cadence is the single biggest lever. Track your progress with the AR turnover ratio, where higher means faster collection.
When should I charge late fees or interest?
Only if your agreed payment terms allow it, and typically from the escalation stage onward (around 30 days overdue). State the late-fee or interest rate on the invoice and in your terms before you apply it. Used consistently, it signals that you take payment dates seriously; used arbitrarily, it can damage the relationship.
Who should own collections?
A named person or AR team should own day-to-day follow-up, with a manager owning escalation from the final-notice stage. Keep collections separate from the person who records payments where you can, to maintain segregation of duties. The tracker has an Owner column so every overdue invoice has a clear point of accountability.
Source: AccountingTools, separation of dutiesHow do I prioritize which customers to chase?
Use the 80/20 rule: about 80% of your overdue balance is usually owed by 20% of customers, so chase the largest balances in the oldest buckets first. Pair this plan with an aging report to see that priority order at a glance, then load the top accounts into the tracker.
Can I automate this cadence?
Yes. Accounts receivable software can send the reminder sequence automatically, apply late fees, and surface the accounts that need a human call, which removes the manual effort while keeping the cadence consistent. See our independent guide to AR software for tools that do this on Xero and QuickBooks.
Last updated June 9, 2026. This guide is general information, not accounting, tax, or financial advice.