Sample data

Who to call

Four customers worth a call this week

Each one stopped, dropped part of their usual order or fell behind on paying, going by your invoices. The rows are the proof. Vhona drafts a message, and you decide whether to send it.

SampleSample books to 31 MarchCustomer names are made up
1
Marula Ridge Office Park
Monthly invoices stopped after 28 January
Last invoice 28 January. Monthly maintenance, R18 400, not billed since.
Stopped6 rows
2
Kopano Guest Lodge
Dropped from about R9 700 to about R3 150 a month since February
Linen and laundry service, about R6 550 a month, dropped from February invoices. Pool and garden, R3 150, still billed.
Dropped5 rows
Receipt
Kopano Guest Lodge
Monthly invoices, line items
Sample

Still ordering pool and garden, but linen and laundry stopped after January. That's about R6 550 a month less.

Line itemNovDecJanFebMar
Linen and laundry service R6 550 R6 550 R6 550 none none
Pool and garden R3 150 R3 150 R3 150 R3 150 R3 150
Total R9 700 R9 700 R9 700 R3 150 R3 150
MonthLinen and laundryPool and gardenTotal
NovR6 550R3 150R9 700
DecR6 550R3 150R9 700
JanR6 550R3 150R9 700
FebnoneR3 150R3 150
MarnoneR3 150R3 150

Same customer, same months. Only the linen and laundry line disappeared. Flagged from these rows only. No score.

3
Tamboti Clinic Rooms
Invoices every few weeks stopped after 19 February
Last invoice 19 February. Aircon service call outs stopped.
Stopped5 rows
4
Sondela Dental Studio
Two invoices open, oldest 47 days overdue
Oldest open INV 2295, due 12 February.
Late4 rows
Receipt
Sondela Dental Studio
Maintenance call outs, 30 day terms
Contact: Naledi Khumalo
Sample

Used to pay within 30 days. Now two invoices, R21 350 in total, are past their due dates.

InvoiceIssuedDueAmountOverdue
INV 222914 Nov14 DecR9 850
INV 22688 Dec7 JanR11 200
INV 229513 Jan12 FebR12 40047 days
INV 231810 Feb12 MarR8 95019 days
OpenR21 350

The two earlier invoices were paid before they were due. Days overdue are counted to 31 March. Flagged from these rows only. No score.

WhatsApp message
Reminder for Naledi
Draft

To Naledi Khumalo, Sondela Dental Studio

Hi Naledi, I hope you and everyone at Sondela are well.

Just a friendly reminder that two of our invoices are still open:
INV 2295 for R12 400, due 12 February
INV 2318 for R8 950, due 12 March
That comes to R21 350 in total.

If they didn't reach you, or something on them needs sorting out, just let me know and I'll gladly resend them or fix it. If payment is already on its way, please ignore this.

Thanks so much, Sipho

Not sent
Edit Open in WhatsApp

In Vhona you edit this and press send in WhatsApp yourself.