Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • Ask Berri to remind you next Monday to check who has paid.
  • Say "make it firmer" for anyone past 60 days.
What Berri sends back
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:

CustomerDaysAmount
Customer 1474Rs 62,000
Customer 358Rs 48,900
Customer 2241Rs 41,500
Customer 933Rs 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.

Your own job, in your own words.

Try Berri