AR Aging Dashboard & Collections Worklist

The problem this kills

Your accounts-receivable team starts every morning the same way: they pull an open-invoices report, squint at a wall of rows, and try to remember who promised what last week. The biggest, oldest, most-at-risk accounts hide in the noise. Promises to pay slip by unwatched. Two people call the same customer; nobody calls the one that actually matters. Call notes live in someone's head, a sticky note, or a private spreadsheet tab — so when that person is out, the trail goes cold.

Meanwhile cash that's already been earned sits uncollected, and your DSO (days sales outstanding — how long money takes to come in) creeps up month after month. This isn't a people problem. It's a missing tool: a clean, prioritized, shared worklist that tells the team exactly who to chase, in what order, and what was said last time.

What you'll build

A simple internal web app for the people who work overdue accounts. You import your open-invoices CSV. The tool sorts every invoice into aging buckets (0–30, 31–60, 61–90, 90+ days), rolls up a balance and a risk score per customer, and calculates your DSO. It then hands the team a prioritized daily worklist — biggest and oldest first — so the highest-value calls happen first.

On each account, a clerk logs the contact: who they reached, the outcome, the promise-to-pay amount and date, and the next action. The tool watches those promise dates and surfaces broken promises the moment they age out. Every morning, Resend emails each clerk their due follow-ups. And when the situation calls for a write-off, a credit hold, or an escalation to a manager or legal, the tool drafts the recommendation — but a real AR manager has to approve it before anyone acts. Nothing is ever posted to your ledger; this is a work-management layer that feeds approved actions back to wherever they belong.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how collections works today, what your export columns are actually named, how you age invoices, your prioritization and approval rules, and your real edge cases (credit memos, partial payments, disputes, VIP accounts). It reflects a short tailored spec back to you for a thumbs-up, then shapes the data model, the buckets, the risk score, and every later step around your answers. You get a tool fitted to your AR shop — not a generic template.

From there the plan walks the agent through the CSV import (with duplicate guards on invoice number), the aging and DSO math, the dashboard, the prioritized worklist, the contact log with promise tracking, the manager approval gate, the daily reminder email, and a clean CSV export. Every step ends with a ready-to-copy prompt. There's a "No API yet?" path so you can build and run the whole thing today from a spreadsheet export, no integration required.

The governance it includes (this is the point)

This is built like a real finance tool, not a toy. The plan bakes in login so only your team gets in; row-level security so a clerk only ever sees their own organization's receivables; a complete audit trail of every contact, promise, and decision — who did what, and when; a hard human-in-the-loop approval gate so no write-off, hold, or escalation happens without an AR manager's sign-off; and duplicate guards so the same invoice can't be loaded or worked twice. Nothing writes to your general ledger — the tool proposes, a person approves, and the action is carried out in your system of record.

Who it's for

Collections specialists, AR clerks, credit managers, and controllers who own overdue accounts and are tired of working them blind out of a spreadsheet. If you can describe how your team decides who to call first and who has to approve a write-off, you can build this.

You've got this — start with the plan, paste the first prompt, and you'll be working a prioritized call list this weekend.