Past-Due Invoice Letter
Invoice number, amount, and days overdue, computed by MergeNinja from Stripe, in a firm-but-friendly letter.
Merge fields in this template
«CustomerName»«AddressLine1»«AddressLine2»«City»«State»«PostalCode»«Number»«AmountRemaining»«DueDate»«DaysOverdue»«HostedInvoiceUrl»
Data source: Stripe invoices
How to use it well
- Sync Stripe invoices filtered to open + past due. Days overdue is computed per invoice at sync, so the letter always states the real number.
- The payment link merges in from Stripe’s hosted invoice page, so the reader can pay the moment the letter lands.
[Your Company Name]
[Street address · City, State ZIP · phone · email]
[Date]
«CustomerName»
«AddressLine1»
«AddressLine2»
«City», «State» «PostalCode»
Dear «CustomerName»,
Our records show invoice «Number» with an open amount of «AmountRemaining» was due on «DueDate» and is now «DaysOverdue» days past due.
You can pay online at any time here: «HostedInvoiceUrl». If payment is already on its way, thank you. Please disregard this letter.
If something about this invoice doesn’t look right, reply and we’ll straighten it out quickly.
Sincerely,
[Your name]
[Title · Your company]
Sending this to more than a handful of customers? Connect QuickBooks or Stripe and MergeNinja fills this letter in for every customer automatically: amounts, dates, days overdue, all of it.
Template questions
How do I use this template?
Download the .docx, open it in Word, and replace the [bracketed] placeholders: your letterhead, dates, and any wording you want to change. The «field» codes stay: they fill in automatically when you merge. Then upload it to MergeNinja (or use Word's own mail merge) against your Stripe invoices data.
What are the «fields» in the letter?
Real Word merge fields, named to match MergeNinja's Stripe invoices dataset exactly. Connect read-only, sync, and every field fills in with live data. No renaming needed.
Can I change the wording and formatting?
Completely. It's an ordinary Word document. Fonts, logo, layout, and tone are yours to edit; the merge only fills the field codes wherever you leave them.
Is the download really free?
Yes. No email required, no watermark. If you later want the letters filled in automatically for your whole customer list, that's what MergeNinja is for.
Related templates
Stop exporting. Start merging.
Connect your data, upload your Word template, and send every customer document in one click.
7 days free · no card to start