AR Forecast Levers
Collections Dashboard
Aging-bucket policy drives the default forecast. Per-customer and per-invoice "levers" refine timing, haircut, and status. Every change is logged with who + when.
AR driver mode
Open AR
Forecast cash-in
Loading AR collections surface...
Open AR
-
Forecast Cash-in
-
Lost to Policy
-
Collections Gap
-
Stale AR (1yr+)
-
Total Open AR
-
Forecast Cash-in (after policy)
-
Lost to Policy
-
Future
-
- invoices · forecast -
Overdue 0-30
-
- invoices · forecast -
Overdue 31-60
-
- invoices · forecast -
Overdue 61-100
-
- invoices · forecast -
Overdue 100+
-
- invoices · forecast -
Customer Priority
Sorted by a blended balance and aging score. Click a row to drill into its invoices.
| Customer | Open Inv | Total Open | Future | 0-30 | 31-60 | 61-100 | 100+ | Days Idle |
|---|
Priority Call List
Ranked by payment behavior, not a blanket 30/60/90 grid: a customer is listed the moment an
invoice runs past their own demonstrated pay speed. Quick wins first — reliable
payers who just slipped. Log every call, email and note so the history stays with the account.
-
-
| Priority | Customer | Late Balance | Quick-Win $ | Their Norm | Days Past (wtd) | Last Contact | Follow-up | Log |
|---|
Quick win = every late invoice is ≤30 days past the customer's norm — a call or
email usually shakes these loose. Chase = 31–90 days past norm. Escalate = 90+.
Overdue follow-ups sort to the top; accounts with a future follow-up scheduled sink until that date.
Click a customer to see invoices and the full communication history.
DSO Outliers
Customers paying outside their own normal speed — open invoices at least 2 weeks past
the date their trailing-12-month history says they usually pay. Sorted by dollars at stake.
-
-
| Customer | Their Norm (days) | Norm Basis | Late Invoices | Late Open Balance | Worst Days Past Norm | $-Weighted Days Past Norm |
|---|
Stale AR Watch
Open invoices more than 1 year old. Either real money the AR team has forgotten about
(escalate now) or write-off candidates that should be cleaned off the books.
Hidden behind the "Overdue 100+ = Exclude" policy on the bucket cards above.
-
-
| Customer | Invoice # | Invoice Date | Age (days) | Age Band | Open Balance | Last Activity |
|---|
▾ Upcoming Follow-ups
Customers or invoices scheduled for follow-up within the next 14 days.
| Follow-up Date | Scope | Customer | Invoice | Assigned | Status | Note | Actions |
|---|
▾ Aging Bucket Policy
Default treatment for each aging bucket. Click to view or edit.
| Aging Bucket | Inclusion | Haircut % | Placement (days from today) | Last Updated | Actions |
|---|
▾ Recent Activity
Most recent override changes across all customers. Full audit is preserved in
ar_collection_overrides_audit.| When | Who | Operation | Scope | Customer | Invoice | Summary |
|---|