Reports and analytics

Open AR by Customer bucketed Current / 1-30 / 31-60 / 61-90 / 90+. Drills from total → AccountOwner → Customer → individual Invoice. Controller's daily landing report and the period-close reconciliation point with fin-accounting's AR subledger.

Days Sales Outstanding computed monthly on a trailing-12 basis with month-over-month delta. Splits best-possible DSO vs. actual to size the collections gap.

Per DunningPolicy and per band: number of DunningEvents sent, payments received within N days of send, response and bounce rates. Used to tune policy thresholds and template copy.

Per period: BankFeedTransactions in, auto-matched at high confidence, auto-matched at low confidence (clerk-reviewed), and manual entries. Tracks the auto-match win rate the AR Clerk's productivity rests on.

Per Customer: open AR, average days late, count of disputes, count of write-offs, active credit-hold flag, count of dunning sends. Drives the AR Manager's customer-level credit reviews.

Per period: every WriteOff with Customer, original Invoice, amount, reason, and approver. Reconciles to the Bad Debt Expense GL account.

Annualized invoice amount across all Active RecurringInvoiceSchedules with month-over-month new / churned / upgraded / downgraded movement. The CRR / ARR view from the billing side.

Open CollectionsCases by Stage (Internal → ExternalAgency → LegalReview → Litigation → Settlement → Closed) with median time-in-stage and recovery rate. The AR Manager's escalation operating report.