An accounts receivable action plan template is a repeatable, staged system your business uses to collect overdue invoices from credit customers, moving each delinquent account through a fixed sequence of communications and creating a paper trail along the way. The value is twofold: consistency, so no account slips through the cracks, and documentation, so you have evidence if you eventually refer the debt to a collection agency, sue on it, or write it off for tax purposes. What follows is how to build one and what to put in each field.
Data Every Entry in the Template Needs
Before you draft any communication, decide what each delinquent-account record will hold. At minimum, capture the customer’s full legal name, mailing address, email, and phone number, plus every invoice number tied to the outstanding balance. Record the exact amount owed, including any late fees or interest that have accrued under the original credit agreement.
Attach the original credit terms to the record. Common arrangements are Net 30 (payment due within 30 days of invoicing) and Net 60, though some businesses negotiate Net 90.1U.S. Small Business Administration. How Net 30 Accounts Help Conserve Business Cash Flow The terms set the baseline for when an account becomes delinquent and which stage of the template applies.
The other tool that drives the template is an aging report. It sorts outstanding invoices into buckets by how long they’ve been overdue: 0–30 days, 31–60 days, 61–90 days, and 90-plus days past due. Invoices in the 61–90 bucket and beyond need immediate attention because the odds of collection fall sharply the longer an invoice sits. Consolidate the aging report and account records into a single spreadsheet or accounting system so you can see, at a glance, which accounts need action and at which stage.
The Escalation Timeline
The template is organized around escalating communications, each triggered by how long an invoice is past due. Every stage should carry the same core fields: customer name, invoice number, original amount, accrued fees, and the date the communication went out. What changes stage to stage is tone, the consequences you mention, and the urgency.
15-Day Courtesy Reminder
This is a soft nudge. The invoice is barely past due and nonpayment is usually oversight or processing delay. The field for this stage should include a brief restatement of the invoice date, the balance owed, and a polite request to remit payment. No threats, no consequences. Keep it short enough that a busy accounts payable clerk can process it in under a minute.
30-Day Formal Notice
At the 30-day mark, tone shifts. This section should reference the original payment terms and note that the account is in breach of those terms. Include a firm payment deadline, typically 10 to 15 business days from the date of the notice. This is where you introduce the first mention of consequences: suspension of further credit, halting of pending orders, or a pause on services until the balance clears.
If your business is enrolled as a data furnisher with a credit bureau, this stage can mention that continued nonpayment may be reported. Becoming a data furnisher requires meeting each bureau’s specific requirements, including maintaining accurate records and committing to monthly reporting. It’s not a matter of emailing Experian, so only reference credit reporting in your template if you’ve actually set up that capability.
60-Day Demand Letter
The demand letter is the last communication before you escalate outside your organization. This field should include a hard deadline, a complete accounting of the balance (original amount plus all accrued fees and interest), and a clear statement that failure to pay by the deadline will result in referral to a collection agency, legal action, or both.
If the underlying transaction was a sale of physical goods, the demand letter can reference the Uniform Commercial Code. UCC Article 2 governs sales of goods, not services, so this only applies when the debt arose from a product sale. Under UCC Section 2-703, when a buyer fails to pay, the seller can withhold further deliveries, resell the goods, recover damages, or cancel the contract.2Legal Information Institute. UCC 2-703 Sellers Remedies in General Referencing these remedies signals that you understand your position and are prepared to act on it.
For debts arising from services rather than goods, common law breach of contract principles apply instead of the UCC. The template still carries the hard deadline and consequences; only the legal reference shifts from Article 2 to general contract law.
Legal Boundaries That Shape the Language
A common misconception is that the Fair Debt Collection Practices Act governs all collection activity. It doesn’t. The FDCPA defines “debt” as an obligation arising from a transaction primarily for personal, family, or household purposes.3Office of the Law Revision Counsel. 15 USC 1692a – Definitions Business-to-business debt sits outside that definition. The FDCPA’s restrictions on when you can call, what you can say, and how you must validate the debt do not apply when the customer is a commercial account.4Consumer Financial Protection Bureau. Fair Debt Collection Practices Act
That doesn’t make commercial collection lawless. State unfair business practices statutes can reach fraudulent or harassing conduct, so the template should keep every communication professional and factually accurate. You have more flexibility than you would with a consumer debtor, but the guardrails still exist.
Statute of Limitations
Every debt has a deadline for filing suit. For sales of goods under UCC Article 2, the statute of limitations is four years from the date of breach. The parties can agree in the original contract to shorten that window to as little as one year, but they cannot extend it beyond four.5Legal Information Institute. UCC 2-725 Statute of Limitations in Contracts for Sale For service contracts and other debts outside the UCC, the period depends on state law and typically runs three to six years, though it varies. Add a field to the template for the date the invoice first became delinquent so you can see how close each account is to the cutoff.
Executing and Documenting Each Stage
Once the template is populated, execution is about delivery and record-keeping. For the 30-day formal notice, and especially the 60-day demand letter, send by certified mail with return receipt requested. The return receipt records the date of delivery and who signed. Whether that qualifies as definitive legal proof depends on your jurisdiction and the specific statute, but it is far stronger evidence than regular mail or email alone. If the recipient refuses to sign or pick up the letter, the attempted delivery is still documented by the postal service.
For earlier reminders, email or automated notifications through your invoicing software work fine. Many accounting platforms let you schedule escalating reminders that fire automatically at 15, 30, and 60 days past due. Automation stops accounts from falling through the cracks, but someone still needs to review the aging report regularly to catch accounts where automated reminders aren’t producing a response.
Log every communication with a timestamp, delivery method, and a short note on the outcome. Did the customer respond? Did they dispute the amount? Did the certified letter come back unclaimed? This chronological record proves you made reasonable collection efforts, which matters both if you refer the account to a collection agency or court and if you later write the debt off for tax purposes.
Metrics That Tell You Whether the Plan Is Working
Running the plan without measuring it is flying blind. Two ratios give you a clear picture, and one operational habit keeps them accurate.
Days Sales Outstanding
Days Sales Outstanding is the average number of days it takes to collect payment after a sale. Divide your accounts receivable balance by credit sales for the period, then multiply by the number of days in that period. If AR is $150,000, quarterly credit sales are $450,000, and the quarter has 90 days, DSO is 30 days.
What counts as good depends on your industry and your terms. A DSO of 30 to 45 days is a reasonable target for most B2B businesses on Net 30. If your DSO runs double your payment terms, collections are lagging and the template needs tightening. Manufacturing tends to run higher DSO numbers than retail, so compare against peers rather than a universal number.
Accounts Receivable Turnover Ratio
This ratio measures how many times per period you collect your average receivables balance. Divide net credit sales by average accounts receivable. A higher number means you’re converting receivables into cash more often. A low ratio suggests either lenient credit policies or a collection process that isn’t aggressive enough. Pushing the ratio too high by pressuring customers can damage relationships and increase disputes, so treat it as a diagnostic, not a number to maximize.
Aging Report Updates
Review the aging report at least weekly, and daily when the volume of overdue accounts is high. Update the ledger each time a payment clears. Reconcile recorded payments against bank statements and original invoice amounts to catch discrepancies early. Any account still unpaid after the 60-day demand letter should be flagged for a decision: escalate to a collection agency, pursue legal action, or write off.
When to Escalate or Write Off
Not every unpaid invoice is worth pursuing to the end. The decision to refer to a collection agency, file in small claims court, or write off comes down to a cost-benefit calculation.
Small claims filing fees, staff time to prepare and attend a hearing, and the realistic probability of actually collecting on a judgment all belong in the math. A judgment in your favor doesn’t automatically put money in your account; you still have to collect on it. Filing fees and the maximum claim allowed both vary widely by state, so check your local court’s rules before filing.
Collection agencies typically charge a percentage of whatever they recover, often 25 to 50 percent for commercial debts. That’s a steep cut, but it costs nothing upfront and frees your team to work on accounts still in the early stages. For accounts that are clearly uncollectible, writing off may be the best financial move, particularly given the tax treatment.
Tax Treatment of Uncollectible Accounts
Whether you can deduct a bad debt depends on your accounting method. Businesses on accrual-basis accounting report income when it’s earned, so the revenue from an unpaid invoice was already in gross income. When that invoice becomes uncollectible, you can deduct it as a business bad debt.6Internal Revenue Service. Topic No. 453, Bad Debt Deduction
Cash-basis businesses don’t get this deduction for unpaid invoices. Under the cash method, income is reported only when payment is received, so the revenue from an unpaid invoice was never in your income to begin with. There’s nothing to deduct.6Internal Revenue Service. Topic No. 453, Bad Debt Deduction This distinction catches a lot of small business owners off guard.
To claim the deduction, you have to show the debt is genuinely worthless and that you took reasonable steps to collect. You don’t have to go to court, but you do need to show that a judgment would be uncollectible or that continued pursuit is futile. The deduction goes on Schedule C for sole proprietors and on the applicable business return for other entities. Timing matters: the deduction belongs in the tax year the debt becomes worthless, not in a later year when you get around to cleaning up the books.6Internal Revenue Service. Topic No. 453, Bad Debt Deduction If you later collect on a debt you already wrote off, the recovered amount goes back into gross income for the year received.
This is where the template’s documentation earns its keep. The dated log of reminders, demand letters, and certified mail receipts is exactly the evidence the IRS expects when you claim you took reasonable steps to collect before writing the debt off.