Sample made from invented data
Sample: unpaid invoice tracking for Harbor Lane Design Co. (invented business and data)
A weekly aging report, which invoices need a reminder this week and why, and a draft reminder for each.
Everything in this sample is invented: the business, the people, the numbers and the contact details. It was produced by the same code a pilot uses, then checked by the quality checks listed at the end. In a pilot, a person reviews the output before it goes to you.
What went in (all invented)
- 13 invoices in the open-invoices export, issued May 15 to Sept 25
- Terms: Net 30. A reminder is due when an invoice is past due, not disputed, and has had no reminder in the last 14 days
The sample output
Summary
Open invoices: 11, total outstanding $22,695.50.
Overdue: 8 invoices, $16,545.50.
Reminders due this week: 5.
Not chased: 5 (each with its reason below).
Counted as of Fri Oct 9, 2026; your terms are Net 30.
Aging
| Bucket | Invoices | Total |
|---|---|---|
| Current (not yet due) | 3 | $6,150.00 |
| 1 to 30 days past due | 3 | $4,040.00 |
| 31 to 60 days past due | 2 | $5,455.50 |
| 61 to 90 days past due | 2 | $4,300.00 |
| More than 90 days past due | 1 | $2,750.00 |
| Total | 11 | $22,695.50 |
Open balances only: invoices paid in full or with a credit balance are left out.
Outstanding by customer
| Customer | Open invoices | Outstanding | Most days past due |
|---|---|---|---|
| Brightwater Dental | 2 | $5,550.00 | 12 |
| Lakeview Fitness | 2 | $5,075.50 | 66 |
| Pine Hollow Cafe | 1 | $3,200.00 | 81 |
| Old Mill Hardware | 1 | $2,750.00 | 117 |
| Cedar Street Books | 2 | $2,730.00 | 46 |
| Maple & Main Bakery | 1 | $1,800.00 | not yet due |
| Northside Yoga | 1 | $950.00 | due today |
| Fernwood Florist | 1 | $640.00 | 8 |
Reminders due this week
| Invoice | Customer | Days overdue | Balance | Last reminder | Why |
|---|---|---|---|---|---|
| 1038 | Old Mill Hardware | 117 | $2,750.00 | Aug 20 | 117 days past due; last reminder 50 days ago. Tone: firm, with an offer to talk. |
| 1044 | Pine Hollow Cafe | 81 | $3,200.00 | Sept 1 | 81 days past due; last reminder 38 days ago; $2,000.00 paid of $5,200.00. Tone: firm, with an offer to talk. |
| 1049 | Cedar Street Books | 46 | $1,480.00 | Sept 10 | 46 days past due; last reminder 29 days ago; $1,000.00 paid of $2,480.00. Tone: firm and polite. |
| 1051 | Lakeview Fitness | 39 | $3,975.50 | Sept 25 | 39 days past due; last reminder 14 days ago. Tone: firm and polite. |
| 1055 | Cedar Street Books | 19 | $1,250.00 | none | 19 days past due; no reminder yet. Tone: friendly. |
Draft reminders
Drafts for you to review, edit and send yourself. Amber does not send messages.
To: walt.brennan@example.com · As: email
Subject: Invoice 1038: $2,750.00 was due June 14
Hi Walt, Invoice 1038 for $2,750.00 was due on June 14 and is now 117 days past due. Please arrange payment, or reply to let me know when it will be paid. If something is wrong with the invoice or the work, tell me and we can talk it through. Pay online at https://pay.example.com/harborlane or by check to the address on the invoice. Lena Park Harbor Lane Design Co.
117 days past due; tone: firm, with an offer to talk.
To: gina.ross@example.com · As: email
Subject: Invoice 1044: $3,200.00 balance, due July 20
Hi Gina, The remaining $3,200.00 on invoice 1044 was due on July 20 and is now 81 days past due. Thank you for the $2,000.00 you've already paid. Please arrange payment, or reply to let me know when it will be paid. If something is wrong with the invoice or the work, tell me and we can talk it through. Pay online at https://pay.example.com/harborlane or by check to the address on the invoice. Lena Park Harbor Lane Design Co.
81 days past due; tone: firm, with an offer to talk.
To: hannah.moss@example.com · As: email
Subject: Invoice 1049: $1,480.00 balance, due Aug 24
Hi Hannah, The remaining $1,480.00 on invoice 1049 was due on Aug 24 and is now 46 days past due. Thank you for the $1,000.00 you've already paid. Could you let me know when we can expect payment? If you have any questions about the invoice, just reply to this email. Pay online at https://pay.example.com/harborlane or by check to the address on the invoice. Lena Park Harbor Lane Design Co.
46 days past due; tone: firm and polite.
To: derek.shaw@example.com · As: email
Subject: Invoice 1051: $3,975.50 was due Aug 31
Hi Derek, Invoice 1051 for $3,975.50 was due on Aug 31 and is now 39 days past due. Could you let me know when we can expect payment? If you have any questions about the invoice, just reply to this email. Pay online at https://pay.example.com/harborlane or by check to the address on the invoice. Lena Park Harbor Lane Design Co.
39 days past due; tone: firm and polite.
To: hannah.moss@example.com · As: email
Subject: Invoice 1055: $1,250.00 was due Sept 20
Hi Hannah, Just a friendly reminder that invoice 1055 for $1,250.00 was due on Sept 20. If it's already on its way, thank you, and please ignore this note. Pay online at https://pay.example.com/harborlane or by check to the address on the invoice. Lena Park Harbor Lane Design Co.
19 days past due; tone: friendly.
Not chased, and why
- 1046, Lakeview Fitness: reminded on Sept 26 (13 days ago); next reminder from Oct 10.
- 1050, Maple & Main Bakery: credit balance of $50.00 ($1,250.00 paid on $1,200.00 invoiced): check with your bookkeeper.
- 1052, Northside Yoga: paid in full.
- 1057, Brightwater Dental: reminded on Sept 28 (11 days ago); next reminder from Oct 12.
- 1058, Fernwood Florist: marked disputed: settle the question with the customer before any reminder.
What this is not
A read-only review of your open-invoices export. Nothing in your accounting system is changed, and no payment is taken or recorded.
The reminders are drafts for you to review and send yourself. Amber does not contact your customers, add fees, or decide anything about an account.
It is not legal advice or advice about taxes. Disputed invoices and credit balances are flagged for you and your bookkeeper to decide.
Quality checks run on this sample
18 of 18 QA checks passed. Direct cost of producing it: $0.00 (no paid service was used).
- Passed: Aging buckets add up to the total outstanding, to the cent
- Passed: Outstanding by customer adds up to the total outstanding
- Passed: The overdue total equals the past-due aging buckets
- Passed: Reminders listed exactly for past-due, undisputed invoices not reminded in the last 14 days
- Passed: Each draft states its invoice number, balance and due date exactly as computed
- Passed: No draft for disputed, paid, credit-balance, recently reminded, not-yet-due or flagged invoices
- Passed: No draft mentions fees, interest, collections, legal action, credit reports or a final notice
- Passed: Drafts and the reminder table show what is still owed, after partial payments
- Passed: Each draft's tone fits its age: friendly, then firm and polite, then firm with an offer to talk
- Passed: Every invoice not chased is listed once with its reason, and not in the reminder table
- Passed: Every amount is written like $1,234.56
- Passed: No claims of guarantees, certification, compliance, affiliation or unmeasured results
- Passed: Nothing says a message was sent (Amber drafts; a person sends)
- Passed: Every section of messages is labelled as drafts
- Passed: No empty section without a note saying why
- Passed: Every stage of the demo completed
- Passed: No tax advice (read-only review: it flags and explains)
- Passed: Nothing says Amber posted an entry, moved money, paid, refunded or decided
Ask about the Unpaid Invoice Tracker with Draft Reminders pilot · All ten pilot services