- Home
- Skills
- Finance & Accounting
- Invoice Aging & Collections Chase List
Invoice Aging & Collections Chase List
Turn your QuickBooks, Xero or FreshBooks receivables export into an aging report, DSO and a ranked list of who to chase first.
Free
Works with the AI Agents you already use
Invoice Aging & Collections Chase List
Example session with this skill installed
Here's my open invoices export from QuickBooks. Who owes me money, who should I chase first, and what's my DSO? Draft some payment reminders I can send myself.
- Read your context and instructions
- Compiled the invoice aging
Plan: age your receivables as of 2026-11-07, rank who to chase, then write one reminder draft per customer into ./reminders/ (you approved that folder). Nothing gets sent.
1. Aging, as of 2026-11-07 (USD; the export has no currency column)
| Current | 1-30 | 31-60 | 61-90 | 90+ | Open | Unapplied credits | Net |
|---|---|---|---|---|---|---|---|
| 4,500.00 | 2,000.00 | 4,000.00 | 3,500.00 | 4,800.00 | 18,800.00 | 400.00 | 18,400.00 |
Skipped: the void invoice INV-1065 and the TOTAL footer row.
2. Who to chase first (balance x days overdue)
| # | Customer | Overdue | Oldest due | Days | Avg days late | Tone |
|---|---|---|---|---|---|---|
| 1 | Northwind Pottery Co. | 6,050.00 | 2026-07-10 | 120 | 33.0 | final notice |
| 2 | Bluefin Analytics LLC | 3,500.00 | 2026-08-31 | 68 | 32.5 | firm |
| 3 | Maple Street Bakery | 1,800.00 | 2026-10-05 | 33 | -1.5 | firm |
| 4 | Redwood Trail Outfitters | 750.00 | 2026-10-25 | 13 | 4.0 | friendly |
- Bluefin's INV-1052 is partly paid: 3,500.00 still open of 6,000.00.
- Maple Street Bakery holds a 400.00 unapplied credit (CM-0007): apply it before chasing.
- Off the chase list: Harbor & Pine Design's INV-1063 (2,200.00, 37 days) is disputed. Resolve it separately.
3. DSO
The first run used your open-invoices export, and the script flagged its DSO:
"days": "164.0",
"note": "No fully paid invoices in this file ... which overstates DSO.
Export all invoices for the period for a true figure."
I asked for the full invoice list, including paid invoices, and reran it:
"days": "65.8", "receivables": "18400.00", "invoiced_in_period": "25150.00",
"period": "2026-08-10 to 2026-11-07 (90 days)"
DSO = net receivables on the as-of date / amount invoiced in the period x 90.
4. Drafts written
Four files, one per chase-list customer, in the tones above (e.g. reminder-northwind-pottery-co.txt). Each asks for payment by 2026-11-14, mentions no fees and leaves a [How to pay ...] placeholder.
Next steps
- 4,800.00 of your 18,800.00 is over 90 days, all of it Northwind's INV-1041. Follow the final notice with a phone call [Collections tone and escalation].
- Northwind and Bluefin each pay about a month late on average. Consider shorter terms or deposits for them [Payment terms and prevention].
- Review each draft, delete Maple's internal note, and send them yourself.
General information about collections practice, not legal or accounting advice.
Connects securely to your tools. The creator never sees your data.
About this skill
Export your invoices from QuickBooks Online, Xero, FreshBooks or any CSV and get an accurate receivables picture. Open invoices are enough for aging; include paid ones for DSO and each customer's payment history. A local Python script does all the maths: aging buckets (current, 1–30, 31–60, 61–90, 90+) per customer and currency, DSO with its formula shown, each customer's average days late, and a chase list ranked by balance × days overdue. Partial payments and credit notes count once, disputed invoices stay off the chase list, and currencies are never mixed. If you want, it writes friendly, firm or final-notice reminder drafts to a folder in your project for you to review and send yourself. No legal threats, and late fees only if you supply your own policy.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Requires standard CSV headers. No currency conversion or interest calculation. Supports one row per invoice. Does not send emails directly.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 9 days ago
- Free with an Agensi account
- Software
Python 3
Permissions
Runs the bundled scripts locally on the files the user names. Writes output only inside the user's project, after asking, and makes no network requests.