Free Template
A 9-sheet Google Sheets template for running AR collections: aging buckets, cadence stages, promise-to-pay tracking, and a daily action queue. Built for a real multi-client accounting firm - not a generic template.
Invoices
Open invoices with aging days, collection stage, priority, last contact, and next follow-up - formula-driven from a single As_Of_Date
Customers
Client master list: contact details, risk tier, payment terms, preferred channel, and best call window
Call_Log
Every outreach attempt with channel, outcome, sentiment, intent detected, and an AI-written summary
Promises_to_Pay
Commitments captured from calls, with promise date, amount, honor/broken status, and AI confidence score
Follow_Up_Cadence
The rule engine - which stage triggers which channel, tone, and escalation at how many days past due
Payment_Patterns
Per-client behavioral data: avg days to pay, P2P honor rate, best contact window, dispute history
Dashboard
Formula-driven KPI summary - the data source for the Claude Cowork Live Artifact dashboard
Pair it with the AR Prompt Playbook and the walkthrough on building a live dashboard with Claude Cowork.
Yes, free to use. It includes all nine sheets, the formula logic for aging and stage calculation, the cadence rule engine, and sample data from a real multi-client accounting firm demo.
It's shared as a Google Sheets file, but the formula logic works the same if you convert it to Excel. For a live connection AI tools like Claude Cowork can read without re-uploading, keep it as Google Sheets and share the link.
A verbal or written commitment from a client to pay by a specific date. P2Ps are logged manually after a call, or automatically when an AI voice agent detects a commitment mid-conversation. The Promises_to_Pay sheet tracks whether each one was honored or broken.