โฐLate payments are invoices not paid by the agreed due date. They can disrupt cash flow, affect scheduling, and add unnecessary admin work. At Enhanced Cleaning, we manage late payments with a simple Excel tracker that's updated daily. Below is a step-by-step guide, along with a short instructional video, showing exactly how to update and analyse the data.
Filter the "Days Overdue" column by colour to identify customers with payments overdue by 2 days or more.
Follow up using the template below
Analyse the filtered data carefully and follow up with regular customers using the provided draft email template. Make sure to attach the invoice/s along with their latest statement.
Standard Reminder Email Template
๐ง Email Template
Hi [Client First Name],
I just wanted to follow up as we haven't yet received payment for your last invoice, which was due on [Due Date].
When you get a chance, could you please check on this and let us know when it'll be sorted? If it's already been paid, no worries at all โ just let me know so I can update our records.
Amount:[Invoice Amount]
Invoice #:[Invoice Number]
Due Date:[Due Date]
I have attached your invoice along with your latest statement for your convenience. If you have any questions, just reply here and I'll get it sorted for you.
Thanks again for working with us!
Take note of the following
Overdue customers who have a scheduled cleaning within the next three days must be followed up. Also follow up with customers who have multiple overdue invoices.
Check NDIS and DVA clients, as their plan managers or providers may sometimes miss payments.
Commercial clients' payments generally come through even when overdue, but they can also be followed up if the overdue period is excessive.
While we can't control how customers respond to payment reminders, we must avoid sending excessive follow-ups that may come across as intrusive.
Always check the customer's communication history before following up
When was the last statement sent?
When was the overdue invoice resent?
When was the last personal email or follow-up made?
This ensures our communication remains professional, respectful, and well-timed.