I turned our AR spreadsheet into a live collections dashboard using Claude. here's the exact prompt
Many B2B firms run their Accounts Receivable from Spreadsheet. The data lives in a spreadsheet - aging buckets, who we called, what they said, whether they made a promise to pay.
The spreadsheet is fine for storing data. It is terrible at telling you what to do today.
It does not flag that someone promised to pay on the 22nd and it is now the 24th. It does not surface that one client has gone four consecutive calls without picking up - which is a pattern, not bad luck. It does not tell you that $19k is sitting at 90+ days with no action owner.
So I tried something in Claude Cowork (the "Cowork" tab on claude.ai, not regular chat). It has a feature called Live Artifacts - basically Claude builds you a running React app from your data, right inside the chat. Not a screenshot. An actual interactive dashboard with charts, tabs, search, and filters.
Here is exactly what I did.
>!(Disclaimer: I have used DEMO data and not actual data here) !<
AI-Powered AR Collections Dashboard
I uploaded our AR collections tracker and asked Claude to build a live dashboard showing:
- Total AR outstanding
- Past-due invoices
- Active Promises to Pay (P2Ps)
- P2P honor rate
- Open disputes
- Pre-legal accounts
- AR aging distribution
- Collection-stage breakdown
- Daily action priorities
That was essentially the entire prompt.
What Claude Built
For our demo data, the dashboard surfaced:
- $116,475 in outstanding receivables
- 23 past-due invoices
- 8 active P2Ps worth $45,100
- 75% P2P honor rate
- 2 open disputes
- 2 pre-legal accounts
It also generated visualizations showing:
- AR distribution by aging bucket
- Accounts by collection stage
- Daily workload and priorities
The Biggest Insight
The collection-stage chart immediately highlighted where most invoices were getting stuck.
In our case, the largest group of accounts had received an initial reminder but hadn’t responded. That made it obvious where additional outreach would have the biggest impact before accounts progressed into more difficult collection stages.
It’s the kind of insight that’s difficult to spot in a spreadsheet but becomes obvious in a dashboard.
Daily Action Queue
The dashboard also creates a simple morning briefing:
- Calls due today
- Promises to Pay due today
- Broken commitments requiring escalation
- Open disputes awaiting response
- Pre-legal accounts needing attention
You open it and immediately know where to focus.
Why It’s Useful
The real value comes from combining operational data, customer interactions, and collection rules into a single view.
As new customer conversations and payment commitments are recorded, the dashboard updates automatically and surfaces the next recommended actions. Instead of manually maintaining collection notes and follow-up lists, the system continuously prioritizes the work that matters most.
What I Like About This Approach
Rather than buying another specialized collections platform, we’re using:
- A spreadsheet as the data layer
- AI as the reporting and visualization layer
- Automated outreach as the execution layer
The result is a lightweight collections system that gives management visibility while helping collectors focus on the highest-impact accounts every day.