Skip to main content
•7 min read•By Nathan Ibgui, fractional CIO

Automate Payment Reminders (Dunning) with n8n to Reduce DSO

A practical guide to automating dunning with n8n: templates, KPIs, integrations and a roadmap to cut DSO by 15 to 40%.

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

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

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

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

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

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

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

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

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

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

Criterion
Excel + manual
Specialized SaaS
n8n (in-house)
Upfront cost
€0–€5k (internal time)
€1k–€6k/month
€1k–€5k build + infrastructure (one-time)
Cost per invoice
€6–€15
€1–€4
€0.5–€2 (after deployment)
Customization
Low (manual)
Medium (templates)
Very high (custom workflows)
Time to implement
1–4 weeks (slow)
1–2 weeks
2–8 weeks (depending on integrations)
Data control
High, locally
Depends on the vendor
High (hosting of your choice), GDPR under control
Scalability
Low
High
High (infrastructure scalability)

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.

Request an audit

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.

Nathan Ibgui, IT & AI consultant

Written by

Nathan Ibgui

Independent consultant and fractional CIO, I help small and mid-sized businesses with IT strategy, artificial intelligence, automation and cybersecurity — from assessment to execution.

Ready to transform your business?

Describe your needs in a few lines: I reply within 24 hours with an initial analysis and concrete recommendations.