Monday email of overdue Xero invoices

Late payers are easy to forget until the cash runs short. Every Monday at 8:00 this emails you the Xero sales invoices that are still unpaid and past their due date, oldest first, as a table with the customer, the due date and the amount owed.

The email opens with the total owed. Bills you owe to suppliers are left out, and when nothing is overdue, nothing is sent.

Run every Monday at 08:00.Run every Monday at 08:00.

Who gets the emailSet me to blank.

Overdue sales invoicesList invoices. Save it as overdue.Xero

If overdue.count is greater than 0If overdue.count is greater than 0

Yes

Table of overdue invoicesMake a table of overdue.invoices Save it as table.

Email the listSend an email to me. Save it as digest. Subject: Overdue Xero invoices<p>Total owed: overdue.total_amount_due_display</p>table.htmlGmail

No

No steps