Collections Prioritization: Who to Contact First Each Day
The biggest lever in collections isn't effort. It's sequencing.
Most AR teams do not have a motivation problem. They have an ordering problem. Invoices get worked in whatever order they appear: the top of the aging report, the most recent email, whichever customer called last. A $500 invoice 10 days late and a $12,000 invoice 45 days late end up looking like the same task on a spreadsheet. They are not.
Sorting the aging report by balance is not much better. The largest balance is not always the most urgent one, and some of your biggest accounts are on agreed payment plans that do not need a call this week at all.
A practical order for the daily list:
- Invoices that just crossed 30 days past due. They are still easy to fix, the person who approved the purchase usually still remembers it, and they get harder to collect every week they sit.
- Reliable payers who are suddenly late. A customer who has paid on time for two years and is now 15 days late is telling you something changed on their side: a new AP contact, a lost invoice, or an early sign of cash trouble. That is worth a call today.
- Accounts where a promised payment date has passed. If someone told you "it goes out on the 15th" and it is now the 18th, follow up on their date, not on your generic schedule. Broken promises are the clearest signal you have.
- Overdue accounts with no contact in two weeks or more. Silence is a bigger risk than age. An account you talked to last week is in better shape than one nobody has touched in a month, even if its balance is older.
- Everything else past due, worked from the highest dollar amount down.
Two groups belong on a separate list entirely:
- Customers on an agreed payment plan. They need a check-in a few days before each installment, not a past-due reminder.
- Customers with an open dispute. They need someone who can resolve the issue, not another nudge from collections. Sending reminders during a dispute is one of the fastest ways to lose a customer.
Why this works: collections time is limited, and each call has a different expected payoff. A call that confirms a lost invoice and gets it paid this week is worth far more than a third reminder to an account that is already on a plan. Sequencing is just a way of spending the same hours on the conversations most likely to move cash.
How to make it stick:
- Rebuild the list every day, not every month. A 29-day invoice and a 31-day invoice look identical until the day the line gets crossed.
- Write down a dated next step on every account you touch. Tomorrow's list should start from those dates.
- Keep the list short enough to finish. Twelve accounts you actually reach beat forty you skim.
- Review the order once a week with whoever owns cash flow, so the priorities match what the business actually needs.
If your team does this by hand, it usually lives in a spreadsheet that one person maintains and nobody else trusts. That is fine to start with, as long as the rules above are written down and applied the same way every day.
Building the list from your accounting system
- QuickBooks Online: start from the A/R Aging Detail or the Collections Report, filtered to past due, and add your own column for the last contact date.
- NetSuite: a saved search of open invoices with days past due, customer, amount and last note date, sorted by your rules, can be scheduled to arrive each morning.
- Xero: the Aged Receivables Detail report filtered to overdue, combined with invoice history for the last contact.
- Sage: the aged receivables report exported to a spreadsheet, with a column for promised dates and last contact.
- Microsoft Dynamics 365 Business Central: the Aged Accounts Receivable report plus the customer's interaction log.
The reports give you the raw list. The ordering rules above are what turn it into a plan.
In Nectivo.ai, Amber, the built-in AI assistant, reads every account's balance, days overdue, note history and hardship signals each day and builds this list automatically, with a suggested next step for each account. Every email Amber drafts is clearly labeled as AI-generated before it reaches a customer. Nectivo.ai syncs directly with QuickBooks Online. Teams on NetSuite, Xero, Sage, Microsoft Dynamics or another accounting system can upload an AR aging report export as a CSV or Excel file and work from the same daily list.
Related: QuickBooks collections software · Free DSO calculator · Pricing