List overdue customer payments and draft reminders
Who owes what, for how long, and a polite note for each.
- ForBusinesses that sell on credit and lose track of who has paid.
- HelperCollections
- ModeBerri Strawberry 1
- AttachExcel sheet
Copy the prompt
This is my outstanding list with customer, invoice date and amount. Today is [date]. Show everyone overdue by more than [number] days, oldest first, and write a short polite reminder I can send to the top three.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Collections helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Ask Berri to remind you next Monday to check who has paid.
- Say "make it firmer" for anyone past 60 days.
List overdue customer payments and draft remindersCollections
XLSoutstanding.xlsx
This is my outstanding list with customer, invoice date and amount. Today is 20 Nov. Show everyone overdue by more than 30 days, oldest first, and write a short polite reminder I can send to the top three.
Reading outstanding.xlsx
Rs 1,86,400 is overdue by more than 30 days:
| Customer | Days | Amount |
|---|---|---|
| Customer 14 | 74 | Rs 62,000 |
| Customer 3 | 58 | Rs 48,900 |
| Customer 22 | 41 | Rs 41,500 |
| Customer 9 | 33 | Rs 34,000 |
Three reminders are written below, each with the invoice number and amount.
Check overdue payments againMonday, 10:00 amReminder set
Figures here are made up to show the shape of the answer. Yours come from your own file and words.