AR is how a collision business gets paid — and CCC's AR Summary report is the single weakest native report in the stack for anyone operating more than one shop. It's slow, it doesn't age properly across carriers, and it can't give you a clean "who owes us what, right now" view.
Why It Breaks
AR Summary joins invoices, payments, carrier splits, and status across every open workfile. CCC runs that query live. At 20+ shops it hurts. At 50+ it times out. Aging buckets in particular — 0–30, 31–60, 61–90, 90+ — are computed awkwardly and usually need to be re-cut in Excel anyway.
What MSOs Actually Need
- AR by shop, by carrier, by aging bucket — single view, updated daily.
- Net-new AR in each bucket since yesterday (what just aged into 60+).
- Drill-down to individual RO / claim / check number.
- Controller-grade exports that reconcile cleanly to the accounting system.
The Fix
Nightly pull of AR data into a warehouse, pre-aged and pre-joined to carrier and shop dimensions. A controller dashboard renders in seconds and exports to the same format your bookkeeper already uses.
Typical build: 2 weeks. Related: WIP Aging: The Hidden Cashflow Killer.