1
Pull your AR aging report and identify overdue accounts
Run your accounts receivable aging report and list every invoice that is past its due date. Enter the customer name, account number, invoice number, original due date, and outstanding balance into the checklist for each account.
π‘ Start with your 61β90 day bucket first β these accounts need faster action than newer overdue invoices and are less likely to require legal escalation than 90+ day accounts.
2
Classify each invoice into the correct aging bucket
Calculate the number of days each invoice is past due and check the appropriate aging bucket. This classification determines which follow-up script or escalation path applies.
π‘ Automate the day count in Excel with a formula β =TODAY()-[DUE DATE] β to avoid manual calculation errors when working a large portfolio.
3
Confirm the correct accounts payable contact
Before making the first contact attempt, verify you have the AP department's email and direct phone number β not just the original sales contact. Many payment delays happen because reminders go to the wrong person.
π‘ A 30-second LinkedIn search or a call to the customer's main switchboard is faster than sending three follow-up emails to an inbox that nobody in AP monitors.
4
Log each contact attempt with date and outcome
Record the date, channel (email, phone, or mail), the staff member who made contact, and the precise outcome β whether a promise to pay was given, a dispute was raised, or there was no response.
π‘ Use consistent outcome labels (e.g., 'PTP', 'Dispute', 'NR') so the log is scannable at a glance by any team member who takes over the account.
5
Record and track any promise to pay
When a customer commits to paying by a specific date, enter the promised date and amount in the PTP field. Set a calendar reminder to check whether payment arrived. If the PTP is broken, move immediately to the next escalation step.
π‘ Two broken promises to pay in succession is a reliable signal that the account needs formal escalation β do not extend a third PTP without a supervisor review.
6
Apply escalation steps in sequence
Work through escalation checkboxes in order: supervisor review, formal demand letter, credit hold, collections agency referral, or legal action. Check each step as it is completed and record the date.
π‘ Send the demand letter by traceable delivery (certified mail or email with read receipt) so you have documented proof of receipt if the account moves to legal action.
7
Close the account with a final status
Once an account is resolved β paid, written off, or referred out β mark the final status field and file the completed checklist. Remove the account from the active follow-up queue.
π‘ Archive completed checklists by customer for at least three years. They provide the documented collection history needed if a write-off is ever challenged by an auditor.