AR Aging & Collections Dashboard

About this template

The AR Aging & Collections Dashboard gives your accounting team a real-time view of who owes what and for how long. Prioritize collection efforts, spot delinquency trends early, and keep cash flow healthy across your portfolio. **What you get:** - **Aging summary** — total outstanding receivables broken into standard aging buckets (current, 1-30, 31-60, 61-90, 90+ days) by property and portfolio-wide - **Tenant delinquency list** — sortable table of all tenants with outstanding balances, showing amount owed, days delinquent, and last payment date - **Collection rate tracker** — percentage of rent collected vs. billed each month with historical trend line - **Payment pattern analysis** — identify tenants who consistently pay late, enabling proactive outreach before balances grow - **Write-off tracking** — monitor bad debt write-offs over time by property and reason - **Property comparison** — rank properties by delinquency rate to identify management or tenant quality issues **How it works:** Export your AR aging report or tenant ledger as a CSV. The template calculates aging buckets from transaction dates and current balances. Refresh monthly or weekly to keep your collections team focused on the right accounts. Works with AppFolio AR aging exports. Column mapping guides included for Buildium and other platforms.