tutorialsFebruary 28, 2026

How to Automate Accounts Receivable: A Step-by-Step Guide for B2B Teams

83% of businesses haven't automated AR. Here's exactly how to change that - from invoice delivery to cash application - without ripping out your existing stack.

R

RevExOS Team

RevExOS Team

You've asked ChatGPT how to automate accounts receivable. You've Googled it. You've read the vendor comparison posts.

And yet your finance team is still spending Monday mornings chasing last Friday's payments.

This guide is different. It's not a feature list. It's a working model for how AR automation actually gets built - what to automate first, what tools fit where, and what most teams get wrong.

Why Most AR Is Still Manual (And Why That's Expensive)

Before we get to the how, here's the uncomfortable truth:

83% of firms haven't fully automated AR.

Not because the technology doesn't exist. Because AR automation is harder than it looks. It touches invoicing software, payment gateways, CRM, email, accounting systems, and sometimes ERP - and most tools only solve one part of that chain.

The cost of doing nothing is real:

  • AR teams spend 40–60% of their time on manual cash application - matching payments to invoices
  • Finance teams spend 3–10 hours per month manually chasing overdue invoices
  • Every day of delay in collections on a $2M/month business costs roughly $67,000 in trapped working capital

AR automation isn't about replacing your finance team. It's about removing the work that shouldn't require a human at all.

The Four Layers of AR Automation

Think of AR automation as four distinct problems, each requiring a different approach:

Layer 1: Invoice Delivery and Tracking

The moment a service is delivered or a product ships, an invoice should go out. Not at the end of the month. Not when someone remembers.

What to automate here:

  • Invoice generation triggered by CRM deal close, contract signature, or delivery event
  • Automatic delivery via email (or customer portal if you have one)
  • Read-receipt tracking so you know the invoice landed

Tools that fit: Stripe, Xero, QuickBooks, or a custom invoicing engine built on top of your CRM data

Common failure point: Invoices created manually at month-end, often with errors or missing PO numbers that cause disputes downstream.


Layer 2: Dunning - Systematic Follow-Up

Dunning is the process of following up on unpaid invoices. Most businesses either don't do it at all, or do it reactively when cash gets tight.

A proper dunning sequence looks like this:

DayAction
Invoice sentConfirmation + copy of invoice
Day -3 (before due)Friendly payment reminder
Day 0 (due date)Payment due reminder
Day +7First overdue notice (polite)
Day +14Second overdue notice (firm)
Day +30Escalation to account manager or collections

What to automate here:

  • All of the above sequence, triggered by invoice status
  • Personalisation by account size and relationship history (a $200K client should not get the same email as a $500 one)
  • Escalation routing to human when needed

Tools that fit: n8n, Make, or Zapier workflows triggered by unpaid invoice status in your accounting system

What most teams miss: Static templates. A dunning sequence that doesn't adapt to customer behaviour - late payer, first-time miss, long-term loyal account - will damage relationships at the top end and underperform at the bottom.


Layer 3: Cash Application

This is the biggest time sink in AR, and the least visible to anyone outside finance.

When a payment arrives, someone has to figure out which invoice(s) it belongs to. Customers pay partial amounts. They combine three invoices into one transfer. They reference an outdated PO number. They don't reference anything.

Manual cash application is why your AR team looks busy even when collections are "on track."

What to automate here:

  • Matching incoming payments to open invoices by amount, date, reference number, and customer history
  • Auto-closing matched invoices
  • Surfacing exceptions - partial payments, unidentified payments, overpayments - for human review

Tools that fit: This requires code-level logic and access to your bank transaction data, accounting API, and invoice records. Zapier can't do this reliably. It needs a proper backend - Python, Node, or a specialist AR platform.

What good looks like: 85–90% of payments matched automatically. Your team reviews the 10–15% that are genuinely ambiguous.


Layer 4: Collections Intelligence and Reporting

Once the tactical automation is running, the strategic layer matters.

What to automate here:

  • Live AR aging dashboard - who owes what, how old, risk-weighted
  • Customer credit risk scoring based on payment history
  • Cash flow forecasting based on expected collection dates
  • Automatic escalation flags for accounts moving into a risk tier

Tools that fit: Airtable, Supabase, or a data warehouse connected to a BI tool (Metabase, Retool, or a custom dashboard)

Why this matters: When your CFO can see the full picture in five minutes - rather than waiting for a finance team member to build a report - decisions improve. You know which accounts need attention before they miss a payment, not after.


What to Automate First

If you're starting from scratch, here's the priority order:

  1. Invoice delivery - fastest to implement, immediate impact on payment timing
  2. Dunning sequences - high leverage, can be built in a week, often recovers 10–15% of overdue AR in the first month
  3. Cash application - harder to build, but frees the most time
  4. Reporting and intelligence - last, because it requires clean data from the first three layers

Don't try to do all four at once. AR automation built too fast becomes AR automation that breaks in production.


The Stack That Actually Works

For B2B businesses running on Stripe, HubSpot/Salesforce, and QuickBooks or Xero:

  • Invoice trigger: CRM deal close → Stripe invoice generated → delivered via email
  • Dunning: n8n or Make workflow listening to Stripe invoice.payment_failed or aging webhooks
  • Cash application: Custom backend matching Stripe payment events to open AR ledger
  • Reporting: Airtable or Supabase with a live dashboard synced to invoice and payment data

For businesses on more complex billing models - usage-based, subscription tiers, professional services with milestones - the stack needs to be designed around the billing logic first, automation second.


What AR Automation Is Not

It's not a SaaS tool you plug in and forget.

The most common mistake we see: buying a point solution (Gaviti, Invoiced, Chaser) that automates email follow-ups but doesn't connect to the actual systems of record. The tool fires emails. The payments don't flow back into the accounting system correctly. The AR aging report is still wrong.

Real AR automation means every layer of the process - invoice creation, delivery, follow-up, payment matching, reconciliation - is connected and accurate. Not just the visible communication layer.


The Result When It's Done Right

When all four layers are automated and integrated:

  • DSO drops by 20–40% - invoices go out faster, reminders fire on time, payments come in sooner
  • Finance team time on AR admin drops by 60–80% - cash application and dunning run without manual input
  • Bad debt shrinks - because problems are flagged before they compound, not after
  • Cash flow becomes predictable - because you know, with reasonable confidence, when each open invoice will close

AR automation isn't about being efficient. It's about having a business that runs on systems instead of spreadsheets.


If you want to map out exactly what your AR automation should look like - based on your billing model, your stack, and your team - let's talk. We'll diagnose where the leakage is and define what to build first.

Tags

accounts receivable automationAR automationinvoice automationdunningcash flow

Stop losing revenue between quote and cash.

Get a free Q2C audit and see exactly where your AR, invoicing, and collections process is leaking money.

Get a free audit