MergeNinja

Dunning Letter Guide: The 3-Letter Sequence

Maria owes you $1,400. The invoice went out five weeks ago, it’s 32 days past due, and you’ve written the follow-up in your head at least four times without sending it. Too soft and it gets ignored. Too hard and you’ve soured a good customer over what might be an honest oversight.

The letter you keep not sending has a name: it’s a dunning letter, a written notice about an overdue payment. And the trick isn’t writing the perfect one. What gets invoices paid is a boring, predictable sequence of three letters, each a little firmer than the last, sent on a schedule whether you’re in the mood or not.

This guide covers the whole sequence: what each letter does, when to send it, and the text of all three, ready to copy.

What a dunning letter is

A dunning letter is a written notice to a customer about an overdue balance. It names the amount, points at the invoice, and asks for payment. Sent once, it’s a nudge. Sent as a series on a fixed schedule, it’s a collections process, and that’s the version that works.

A single letter is easy to ignore, and customers who pay slowly know it. A sequence teaches them something different: silence gets follow-up, and the follow-up gets firmer. In practice, most balances clear after the first or second letter. The third exists mostly so the first two are credible.

Three dunning letter examples you can copy

The sequence runs on days past due, not on how irritated you are:

If your payment terms are shorter than net 30, compress the whole timeline. The fixed intervals and the follow-through matter more than the exact day.

Letter 1: the friendly reminder (15 to 30 days)

At 30 days, an unpaid invoice usually really is an oversight, so the first letter assumes exactly that. No blame, no deadline, no consequences. It has three jobs: name the exact amount, reference the specific invoice, and make paying easy.

Our records show an overdue balance of [amount] on your account, from invoice [invoice number] dated [invoice date]. We know invoices slip through the cracks. This is just a friendly reminder.

If payment is already on its way, thank you, and please disregard this letter. If not, we’d appreciate payment at your earliest convenience. You can pay by [payment methods].

Questions about your balance? Reply to this letter or call us. We’re happy to walk through the details together.

That’s the body; your letterhead, the customer’s address block, and a signature go around it. This is the letter Maria gets, with $1,400 and her invoice number filled in, and nothing about it should embarrass either of you if she paid yesterday and the letters crossed. If you’d rather start from a file, the same letter is a free Word download: the friendly past-due reminder template.

Letter 2: the firm second notice (45 to 60 days)

By the second letter, oversight is no longer the likely explanation, and the letter says so through what it changes, not by getting rude. It calls itself a second notice. It names the overdue amount and the total balance. It sets a deadline. And it offers a way out, because you’d rather arrange a payment plan than age the account another month.

This is our second notice regarding the overdue balance of [amount] on your account. Your total account balance is [total balance].

We ask that you settle the overdue amount within 10 business days of the date of this letter. If you’re experiencing difficulties, please contact us. We would rather arrange a payment plan than let an account go further past due.

If payment has crossed this letter in the mail, thank you. No further action is needed.

James, at $890 and 52 days, gets this one. The 10-business-day deadline does the real work: it turns “sometime” into a date without threatening anything yet. The download version is the firm second-notice template.

Letter 3: the final notice (90 days)

The final notice has one rule: state only consequences you will actually follow through on. If you have no intention of sending an $890 balance to collections, don’t write that you will. Empty threats train customers to ignore you, and they weaken the letters you send everyone else. Honest consequences are usually suspending service, pausing future work, or referring the balance for collection.

Despite previous reminders, the overdue balance of [amount] on your account remains unpaid. This letter is our final notice.

If we do not receive payment or hear from you within 10 business days, we will have to consider next steps, which may include suspending service and referring the balance for collection.

We would much rather resolve this directly. Call us and we will work something out, but we do need to hear from you.

Still professional, still offering a direct way to resolve it. The download version is the final notice template. If you invoice through Stripe, there’s also an invoice-level version that merges in the hosted payment link: the past-due invoice letter for Stripe.

The rules that make the sequence work

Notice what’s hard about that list. It isn’t the writing; the three letters barely change from month to month. It’s the operating: knowing, every week, which customers are at day 25 and which are at day 50, and getting the right letter to each of them with the right numbers filled in.

Sending the sequence without running a spreadsheet

The manual version is free and genuinely works. Each month you export your open invoices, work out days overdue for each one, split customers into the three bands, and run three mail merges in Word. The QuickBooks mail merge tutorial walks through the export and cleanup step by step. And if you have a handful of customers and one goes overdue in a bad year, skip all of it: copy the letter above, fill in the numbers by hand, and you’re done in ten minutes.

The pain shows up with volume and repetition, when the export-clean-merge loop comes back every month. That’s the case MergeNinja was built for. It connects to QuickBooks Online or Stripe with read-only access (it can see invoices, it can never change them; details on the security page), and it computes days overdue for every invoice when the data syncs. Filtering to a band and merging that band’s letter becomes the whole monthly job. The dunning letters use case shows the full run.

If the monthly grind sounds familiar, you can create a MergeNinja account and try it free for seven days, no card to start.

Related articles

Stop exporting. Start merging.

Connect your data, upload your Word template, and send every customer document in one click.

Start free trial

7 days free · no card to start