XBert Type: Standard
Accounting Software: Xero, MYOB, QuickBooks
Country Restriction: All regions
Risk Type: Overdue Risk
Business Function: Purchases
Overview
The "Unusually Overdue Bill Outside Normal Behaviour" XBert identifies supplier bills that are significantly more overdue than your usual payment patterns. This helps you flag important bills that might have slipped through the cracks and prioritise those that are at higher risk of causing disruption or late payment issues.
What it does
This XBert compares unpaid bills to your historical paid bill behaviour to identify outliers — bills that are overdue well beyond your typical timeframes for similar-sized amounts. It enables you to act on bills that are more likely to impact your supplier relationships, project timelines, or business operations.
How it works
XBert analyses your paid bill history and uses the following method:
Groups past Paid bills into 5 equal-sized bins based on bill amount ranges.
Calculates the cutoff overdue days for each bin using the interquartile range (IQR) method (Q3 + 1.5 × IQR).
Reviews current unpaid bills that are at least 7 days overdue.
If a bill is overdue by more than the cutoff for its bin, it is flagged as unusually overdue.
For example, if bills in the $100–$900 range are usually paid within 28 days, but one bill in that range is now 45+ days overdue, it will trigger an alert.
Example/Use Case
Your business typically pays invoices from “ABC Supplies” within 25–30 days. You currently have a $720 bill that is now 49 days overdue. XBert flags this as unusual based on your historical payment behaviour, suggesting this bill be treated as a priority. Paying it late may strain supplier relationships or delay a project, especially if ABC Supplies is a key vendor.
Accounting software
All major Australian-compatible accounting software (e.g., Xero, MYOB, QuickBooks Online).
Which countries it supports
All regions.
Processes
This alert falls under the ‘Purchases (AP)’ category and supports proactive supplier management. To resolve this issue:
Review the bill in your accounting software and confirm it hasn’t already been paid but left unreconciled.
If still unpaid, determine the urgency and importance of the bill:
Is it from a regular supplier?
Will non-payment affect project delivery or supplier relationships?
If you’re unable to pay in full:
Contact the supplier and propose a payment plan.
Consider making a part payment.
Add a comment or reminder in your bookkeeping system noting when payment is scheduled.