Provides list of invoices past due more than usual based on customer's payment history
Jump to Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
Letting a customer who is having cash flow issues get deeper in the hole is not doing any favors for either company. They may end up being forced to move service to a competitor when they can no longer pay your bill. This alert will warn when a customer's payments are later than normal, perhaps they normally pay 40 days late and now the average is 60.
It might make sense to also have this alert go to the sales person on the account. Could a customer with new cash flow issues be a prospect for a contract rewrite or a cost saving measure such as adding printers?
Run Schedule: Weekday Mornings
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable 1: Enter Customer Types (Bill To Customer) to exclude. Gives you the ability to exclude certain Customer Types, this is not a recommended practice UNLESS you are not responsible for collecting on those invoices and have no ability to encourage payment. Even then we can make a strong argument for wanting to know about changes to those payment habits...
Variable W: Enter number of days past payments should be averaged over –This looks back specified number of days to calculate average days each customer pays their invoices within. If set too low you may miss the last quarterly or semi-yearly payments. We recommend 180 or 360 but it must not be set lower than 90 days.
Variable X: Ratio of days past due (i.e. 2 = two times the cust average days to pay, 1.5 = one and half times the cust average days to pay) So if your customer averages payment within 20 days of the due date, alert would notify you when customer had an invoice over 40 days past due. We recommend a setting of 2 or 3.
Variable Y: Minimum number of days from the invoice date they are past due. Using an example of 15 the alert will not alert you unless the invoice is at least 15 days past the invoice due date. This was added for those who use terms of due upon receipt. So if you had a customer that averaged 5 days to pay and variable X was 2 times the average or 10 days, they would not show up until the invoice due date was at least 15 days past due.
Variable Z: Enter Branch Numbers for the alert to consider if you wish to limit to certain branches for all alert emails,
* * *
Alert Functionality
Alert Functionality
1. Sorts in descending order by Ratio Days Past Average column
2. Only sends an alert once on each invoice.
3. Will not pick up all the invoices past due on a daily basis.
4. The very first email produced will have ALL your past due accounts and may be a long list (especially if most of your invoices terms are due upon receipt). After that it will only report the new accounts that meet the criteria.
5. New customers won't be reported on since there is no payment history to calculate average days past due. After the first invoice is paid, then the alert will report on that customer compared to the average.
* * *
Best Practices & Tips
Best Practices & Tips
-We recommend sending this alert daily to the AR person who have invoices older than than 2x (VariableX=2) their normal ratio of days to pay.
-Alert set up to only report the new invoices that meet the criteria set in the variables. The original intention of this was to alert on customers that have an invoice slipping past 2 (or variable X) times the average days they normally pay within. It's a heads up to your collections person to get on a call with the customer and find out. If customer normally pays within 10 days of the due date then this alert is telling you the invoice being reported is now 20 days past the due date. It will not report them again since it would make sense that your normal collection process would begin calling on them.
-Use alert ID21 to ensure past due customers are being contacted.
* * *
Related Alerts
Related Alerts
ID21 - AR Past Due Not Contacted
ID134 - Invoices for Sales Orders Past Due
ID273 - Alert all Contract invoices past due > W Days
ID407 - Outstanding Invoice/Credit Past Due X Days
* * *
0 Comments