Introduction: why automate payment reminders now
French small businesses lose an average of 2 to 5% of their revenue every year to late payments; for a company with €2M in revenue, that is €40,000 to €100,000 lost per year. Automating reminders (dunning) with a tool like n8n can cut days sales outstanding (DSO) by 15% to 40% depending on the scenario, while reducing the time your accounting team spends on it by 60% to 80%.
This practical guide explains how to design, deploy and measure an automated reminder system with n8n by combining business rules, ERP/CRM integrations, message templates and human escalation. Each recommendation comes with worked figures, a 9-step implementation plan and KPI templates to measure the impact on cash flow.
Concrete benefits: what you get by automating dunning
Automating reminders delivers measurable gains: lower DSO (typical target 20%–30%), a 10 to 25 point increase in the 30-day collection rate, and 60% lower administrative costs for reminders (example: 2 accounting FTEs reduced to 0.8 FTE for the same volume).
In practice, for a small business with 1,000 invoices a month and an average invoice of €2,000, automating reminders can free up €1.2M of tied-up cash within 12 months if DSO drops from 60 to 45 days (a 25% reduction). These figures are achievable by combining n8n workflows, customer segmentation and ERP/CRM integration.
A 9-step roadmap to deploy automated dunning with n8n
Here is a structured, prioritized method to go from analysis to operational automation in 6 to 10 weeks. Each step includes deliverables and target metrics.
1. Invoice audit and segmentation (1 week)
Deliverable: a 3-month sample = 3,000 invoices. Metrics: current average DSO, unpaid rate, the top 20% of customers accounting for 80% of overdue amounts. Goal: sort customers into 3 segments (0-30 days, 31-60 days, >60 days) — 100% invoice coverage.
2. Define the reminder rules (1 week)
Deliverable: a matrix of 6 rules (for example: Day 1 notification, Day 15 first email, Day 30 text message, Day 45 automated call, Day 60 pre-litigation). KPI: cut the number of human escalations by 70%.
3. Choose templates and tone (2 days)
Deliverable: 6 email templates, 3 text message scripts, 2 call scripts. Figures: 60% target open rate, +12 points target for the payment rate within 30 days after a reminder.
4. Design the n8n workflow (1 week)
Deliverable: an n8n diagram with at least 8 nodes (trigger, segmentation filter, PDF generation, email, SMS, ERP update, ticket escalation); execution SLA: < 30s per invoice for automated operations.
5. Integrations: ERP, CRM, bank (1–2 weeks)
Deliverable: live connectors to the ERP/ERP API, CRM (e.g. HubSpot) and payment solution (Stripe/banks). Goal: two-way sync every 15 minutes, targeting 99.5% reliability.
6. Sandbox testing and pilot (2 weeks)
Deliverable: a pilot on 10% of the portfolio (100 customers). Pilot KPIs: 10% lower DSO within 30 days, error rate < 1% (sends, amounts).
7. Gradual rollout (2 weeks)
Deliverable: ramp-up from 10% to 100% in 2 weeks. KPI: payment rate within 30 days up 15% at T+30.
8. Measurement and continuous optimization (monthly)
Deliverable: monthly KPI dashboard and weekly reports. Metrics: DSO, resolution rate at 30/60/90 days, number of human escalations. Continuous improvement goal: −5% DSO per quarter for 2 quarters.
9. Governance and compliance (ongoing)
Deliverable: an approved reminder policy, proof-of-sending process and consent register (GDPR). Figures: keep proof for 3 years, audits twice a year.
Essential KPIs and numeric targets
Define these KPIs from day one and track them on a dashboard (e.g. Grafana, Metabase). Here are realistic targets after 6 months:
DSO
Current → Target (e.g. 60 days → 45 days = −25%)
Payment rate within 30 days
Current 55% → Target 70% (+15 pts)
Overall collection rate
Current 92% → Target 96% (+4 pts)
Administrative time
Hours per month spent on reminders: e.g. 160h → 40h (−75%)
Cost per invoice
Reminder cost: e.g. €6 → €1.5 (−75%)
Human escalations
Escalations per month: e.g. 200 → 50 (−75%)
Measuring these KPIs lets you attribute a precise ROI: for 1,000 invoices a month and an average invoice of €2,000, a 15-day DSO reduction frees up ~€82,000 in cash (simplified calculation: revenue/360 × days saved).
Operational rules and templates (concrete examples)
01.Rule: Day 1 notification
Automatic message: a friendly reminder including the invoice and a payment link. Expected open rate: 65%. Example: an email with the subject line “Reminder – Invoice #1234 due 02/15” and a payment button. Sent to: 100% of unpaid invoices on Day 1.
02.Rule: First reminder on Day 15 (personalized email)
Content: reminder, possible payment plan, direct contact. Expected conversion: 18% of customers pay after this reminder. Include a link to the customer portal and the invoice reference.
03.Rule: Day 30 reminder (text message + email)
Content: short message + payment link + dedicated phone number. Expected text message response rate: 25%. Escalate if no reply within 7 days.
04.Rule: Day 45 (automated call + ticket)
Action: trigger an automated call or create a ticket for the collections team. Goal: an additional 12% conversion at this stage.
05.Rule: Day 60 (pre-litigation)
Action: send a registered letter, suspend services if applicable, hand over to the legal team. Expected collection through this procedure: +5% to +10% depending on the industry.
Key integrations to build with n8n
n8n excels at orchestrating multiple systems. Here are the priority connections, with quantified use cases:
-
ERP / Accounting Connect via API or database (e.g. Sage, Odoo). Sync 100% of invoices and payment statuses to trigger workflows in real time. See /solutions/data-erp for ERP orchestration.
-
CRM Add customer flags (risk, finance contact): lets you route the 20% of strategic accounts to manual handling. See /solutions/strategie-marketing-branding for customer consistency.
-
Payment platform Stripe, GoCardless or a BOFA payment link: reduce payment friction and measure post-reminder conversion (+15% on average).
-
Email & text messaging SMTP, SendGrid or Twilio for email and text messages: texts convert twice as well as email for urgent reminders (e.g. 25% vs 12%).
-
Support / ticketing Zendesk / Freshdesk: automatically create tickets for every reminder past Day 30, and cut handling time by 40%.
-
Bank & reconciliation Automatically retrieve incoming transfers via bank export or banking API (e.g. 1 statement/day). See /solutions/audit-performance-it and /solutions/cybersecurite-infrastructure for governance and security.
Comparison: Excel + manual email vs specialized SaaS vs in-house n8n
Caution: compliance and legal best practices
Before automating formal demand letters, check local rules: collection fees, late-payment penalties, mandatory notices. Practical figures: in France, the late-payment penalty rate can be set by contract; document the legal basis and keep proof of sending for at least 3 years. Make sure text messages and emails comply with GDPR (consent for 100% of marketing campaigns, more leeway for contractual reminders). See /solutions/cybersecurite-infrastructure and /solutions/google-business-profile for operational compliance and visibility.
Ready to reduce your DSO?
Schedule a free audit of your reminder process: we analyze one month of invoices (a 300-invoice sample) and present a roadmap within 7 business days. Fast integration with n8n and your existing systems.
Frequently asked questions
You can see a significant DSO improvement within 30 to 90 days; a realistic goal is −10% to −25% DSO after 3 months, depending on data quality and integrations.
Upfront cost: usually €1k to €5k for development and integration, then €50–€300/month for infrastructure and monitoring depending on volume. The cost per invoice often drops below €2 once the investment is paid back.
Yes, if the instance is hosted properly: encryption in transit, backups, access control. Aim for 99.5% availability and apply the recommendations in /solutions/cybersecurite-infrastructure.
No: target automation at 80% of cases (simple invoices). Keep 20% under human management for strategic accounts or complex disputes to maximize the collection rate.
Yes: segment by customer value and risk. For example, the top 20% of customers generate 80% of revenue; use a gentler, more personal sequence and human priority for those accounts.
Calculate ROI by comparing the cash freed up (lower DSO) with the operational savings (staff hours, cost per invoice). Example: for 1,000 invoices a month with an average invoice of €2,000, cutting DSO by 15 days frees up ~€82k in cash and saves 75% of administrative time.