AR by Location
13-Week AR Trend
Total AR by aging bucket (due date) • line = past-due %
Location Summary
| Location | Total AR | Current | 1-30 | 31-60 | 61-90 | 90+ | Past Due | PD % | 60+ % | Invoices | Customers |
|---|
Aging by Location
Top 10 Customers
60+ Day Exposure — Top Customers
| Customer | Location | Salesperson | Total AR | 61-90 | 90+ | 60+ Total | 60+ % |
|---|
60+ AR by Salesperson
60+ AR by Site
Past Due Invoices ≥ 60 Days
Including invoices aging into 60+ by coming Sunday
Collection Score — How it's calculated
| Component | Max Pts | How Earned |
|---|---|---|
| Aging Severity | 25 | 60+ balance as % of total AR — scaled linearly. 50%+ = full 25pts. |
| Velocity | 25 | Weight of 90+ bucket (up to 15pts) + 31-60 bucket (up to 10pts) relative to total AR. |
| Payment Behavior | 20 | Avg days-to-pay: >60d = 20pts, >45d = 15pts, >30d = 5pts. +5pts if trend is deteriorating. |
| Near Boundary | 8 | Has balance in both 1-30 AND 31-60 buckets simultaneously (invoices about to age further). |
| Materiality | 15 | Customer's % of total company AR: >5% = 15pts, >2% = 10pts, >1% = 5pts, >0.5% = 2pts. |
Critical ≥ 70 · High ≥ 50 · Medium ≥ 30 · Watch < 30
Escalate action triggered if: 60+% > 40%, or 90+ > $100K, or avg DTP > 90d, or deteriorating trend with DTP > 60d
Collections Priority Queue
Ranked by urgency score — use as weekly call agenda
| Score ⓘ How? | Tier | Action | Customer | Plant | Salesperson | Total AR | Past Due | 60+ | 90+ | Avg DTP ⓘ | Risk Factors | Hold / Lien | Note |
|---|
Aging Change by Site — Snapshot Data
60+/90+ from month-end snapshots • Total AR from latest weekly snapshot
Detail Table with 60+ AR Changes Month over Month
' + agcTopN + ' customers ranked by Total AR · All others grouped
Period:
Rank by:
Top:
| Customer | Site | Salesperson | Total AR | Now ↓ | ← Monthly Change | Hold / Lien | Note | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Customer | Plant | Salesperson | Inv. | Total AR | Current | 1-30 | 31-60 | 61-90 | 90+ | Past Due | Avg DTP | Hold / Lien | Note |
|---|
⚠ Some invoices have no salesperson assigned. These appear as "Unassigned".
AR by Salesperson
| Salesperson | Plant | Customers | Total AR | Current | 1-30 | 31-60 | 61-90 | 90+ | Past Due | PD % |
|---|
| Direction | Customer | Plant | Invoice # | From Bucket | To Bucket | Prev Balance | Curr Balance | Change |
|---|
ⓘ AR-derived billings data. Figures are based on invoiced amounts from accounts receivable records using
net_revenue where available, falling back to invoice_total. This is not a substitute for audited revenue or financial reporting.
Billings Over Time
By Location
Daily Billings — MTD
Top Customers by Billings
| Customer | Plant | Billed | Invoices |
|---|
By Salesperson
| Salesperson | Plant | Billed | Invoices |
|---|
Monthly Collections
Amount collected by month
Avg Days to Collect
By location over time
On-Time vs Late Payments
Collections Efficiency by Plant
% paid on time, avg DTP, late breakdown
Top Customers by Collections
Ranked by amount collected in selected period
| Customer | Plant | Collected | Invoices | Avg DTP | On Time | Late |
|---|
Forecast vs Actual Collections
Weekly snapshot forecast compared to actual collections
Weekly Detail
Source: manual entry (M) or auto from collections MV (A)| Week Of | Site | Snapshot | Forecast | Optimistic | Conservative | Actual | Src | Variance $ | Var % | Status |
|---|
Vintage Convergence Matrix
Rows = target week • Columns = forecast vintage (T-0 = most recent, T-13 = oldest) • Read across to see how forecast evolved
Blanks (—) = target week was beyond the forecast horizon when that snapshot was taken. Matrix fills left-to-right as weekly snapshots accumulate.
Implied Recovery Rates
Actual ÷ gross forecast • Compared to assumed rate • Drift = implied minus assumed
| Week Of | Site | Gross Forecast | Assumed Rate | Adj. Forecast | Actual | Implied Rate | Rate Drift | Last Entered |
|---|
Enter Actual Collections
One row per closed week • Changes are audited • Manual entries override MV data
| Week Of | Forecast (Adj.) | Current Actual | Enter / Edit Actual | Variance | Last Changed By | Changed At | Prior Amount |
|---|
Forecast vs Actual Collections
Weekly snapshot forecast compared to actual collections • Positive variance = beat forecast
Weekly Detail
Forecast taken closest Monday before each collection week
| Week Of | Site | Snapshot Date | Forecast (Adjusted) | Actual Collected | Variance $ | Variance % | Status |
|---|
Notes
New Note
Monthly Shipped Revenue
All entities
Bookings vs Shipments
Book-to-ship ratio · backlog indicator
Monthly Billings vs Collections
BV + KG · WB has no collections data
Methodology — Two-layer model:
Current invoices (not yet overdue): Expected date = MAX(due_date, invoice_date + customer avg DTP). Each invoice lands in a specific forecast week.
Overdue invoices: Distributed across near-term weeks using a decay curve — heavier weight in early weeks, tapering off. Conservative scenario applies a 15% haircut for potential uncollectables.
Customers with 3+ paid invoices use their own DTP. Others fall back to site avg (BV: 56d · KG: 52d · WB: 68d).
Scenarios: Optimistic = avg − 0.5σ | Base = avg | Conservative = avg + 0.5σ − 15% haircut on overdue.
Solid bars = current invoices | Faded bars = overdue recovery. Base dates in red in the table are past due.
Recovery Rate Assumptions
Configurable haircut by aging bucket and site • Changes saved immediately and audited
Site:
| Aging Bucket | Current Balance | Recovery Rate % | Haircut % | Adjusted Balance | Last Changed | Changed By | Prior Rate |
|---|
Note: Site-specific rates override All Sites defaults.
180+ days past due are flagged At-Risk and shown separately below.
Collections Forecast
Expected cash in by week
Customer-Level Forecast Detail
Open invoices ranked by expected collection date
| Customer / Invoice | Site | Balance | Inv. Date | Avg DTP | σ | Source | Optimistic | Base | Conservative | Opt. Week | Base Week | Cons. Week |
|---|
Notes
Invoice Detail
13-Week AR Trend for this Customer
| Invoice # | Plant | Invoice Date | Due Date | Balance | Days Past Due | Bucket | Note |
|---|