How the Dunning Process Works
A dunning workflow starts by reviewing open customer invoices and determining which balances have passed their due dates. Staff then group overdue accounts by factors such as days past due, balance amount, customer payment history, and any active dispute or payment arrangement. The business applies its communication policy to select the appropriate reminder and follow-up action.
A typical process includes reviewing the aged receivables report, checking invoice details, sending a payment reminder, recording the response, and scheduling the next action if the balance remains unpaid. The broader Dunning practice establishes the timing and tone of these communications, from a courteous first reminder to a more direct escalation for significantly overdue balances.
For example, a customer with an invoice due five days ago may receive a friendly reminder with the invoice number, amount, due date, and payment instructions. If the customer reports a pricing dispute, the account should be routed for investigation rather than receiving repeated reminders without review.
Setting Reminder Rules and Priorities
Useful dunning rules define when a reminder is sent, which invoices qualify, what information appears in the message, and when an account requires personal follow-up. A business might schedule an initial reminder shortly after the due date, a second notice after another defined interval, and escalation to a collections representative when the balance remains unresolved. These intervals should reflect customer agreements and internal credit policies rather than a universal schedule.
Prioritization helps staff focus on accounts with the greatest financial impact. A large overdue balance, repeated missed promises to pay, or a customer approaching a credit limit may warrant earlier attention than a small balance with a confirmed payment date. Finance teams should also exclude invoices covered by approved credits, documented disputes, or agreed payment plans when policy calls for a pause in reminders.
Accurate Customer Data Collection supports this process by keeping billing contacts, customer identifiers, payment terms, and communication preferences current. Before sending a notice, staff should verify that the recipient is authorized to receive account information and that the invoice remains open.
Tracking Results and Recording Evidence
Finance teams can evaluate dunning effectiveness by monitoring overdue balances, days sales outstanding (DSO), collection rates, promise-to-pay fulfillment, and the time between an invoice becoming overdue and payment receipt. Reviewing these measures by customer group or aging bucket helps identify whether reminders are producing responses and where additional action may be needed.
Consider a company with $24,000 in overdue invoices that receives $9,000 after its reminder campaign. Assuming no new overdue invoices, credits, or adjustments, the remaining overdue balance is $15,000. Tracking the result alongside customer responses helps the team distinguish successful reminders from balances requiring dispute resolution or direct outreach.
A reliable Dunning Audit Trail records the reminder date, recipient, communication channel, invoice references, customer response, and next action. This evidence helps colleagues coordinate follow-ups and allows managers to review whether the team followed its collection policy.
Integrating Dunning with Finance Workflows
Dunning works best when it connects with invoice review, payment posting, dispute management, and account reconciliation. When a customer pays, the team needs the payment matched to the correct invoice so that reminders stop for settled balances. Clear Cash Application Documentation Management helps preserve remittance details and supporting records when payments cover several invoices or include deductions.
Businesses extending their finance systems can review Sage Intacct Integration concepts to understand how ERP data exchange supports synchronized customer, invoice, and payment information across finance workflows. For Sage 100 users, the practical goal is to ensure the reminder process uses current receivables data and that collection outcomes are reflected in the accounting records.
The Hyperbots Platform offers company-specific configuration for ERP integration, workflows, user roles, and general ledger structures through a no-code framework. Its Process Specific Capabilities support finance workflows with AI trained for relevant tasks, while Ready to Deploy Capabilities provide pre-trained agents, ERP connectors, and configurable setup. Self Learning Capabilities allow workflows to adapt based on human actions, and Human in the Loop oversight supports exception escalation and review.
Best Practices for Sage 100 Dunning
Establish written reminder intervals and escalation rules, and align them with customer contracts and credit policies. Use consistent message templates that state the invoice number, due date, amount due, payment options, and a clear contact for questions. Review disputed invoices promptly, document promised payment dates, and update account notes after every meaningful interaction.
Teams exploring AI Copilots for Sage 300 can learn how AI copilots may improve finance workflow productivity and accuracy in a related Sage environment. For dunning specifically, How AI Transformed Finance Communication: Insights from CFO offers context on communication-led receivables collection, while Order-to-Cash Process: Complete Guide to O2C Automation explains how collections fit into the wider order-to-cash cycle. Apply any technology or workflow changes only after confirming compatibility with the Sage 100 environment and the organization's control requirements.
Summary
Sage 100 Dunning helps finance teams organize overdue-invoice reminders, customer follow-ups, and collection records. Effective practices combine accurate invoice data, consistent communication rules, clear exception handling, and measurable outcomes. When reminders are coordinated with payment application and accounting updates, businesses gain better visibility into overdue balances and can make more informed decisions about collections and working capital.