Invoice Aging & Collections Chase List

    1

    Turn your QuickBooks, Xero or FreshBooks receivables export into an aging report, DSO and a ranked list of who to chase first.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    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)

    Current1-3031-6061-9090+OpenUnapplied creditsNet
    4,500.002,000.004,000.003,500.004,800.0018,800.00400.0018,400.00

    Skipped: the void invoice INV-1065 and the TOTAL footer row.

    2. Who to chase first (balance x days overdue)

    #CustomerOverdueOldest dueDaysAvg days lateTone
    1Northwind Pottery Co.6,050.002026-07-1012033.0final notice
    2Bluefin Analytics LLC3,500.002026-08-316832.5firm
    3Maple Street Bakery1,800.002026-10-0533-1.5firm
    4Redwood Trail Outfitters750.002026-10-25134.0friendly
    • 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Terminal / Shell
    Read Files
    Write Files

    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.

    Listed9 days ago

    What's inside

    Frequently Asked Questions

    This skill accepts CSV exports from QuickBooks Online, Xero, and FreshBooks, as well as generic CSV files with standard columns for customer names, dates, and balances. Its deterministic Python script ensures financial accuracy that standard LLM prompts often lack.

    SKILL.md (the agent's rules and workflow), scripts/aging.py (the calculator and draft writer, Python standard library only) and reference.md (aging buckets, DSO variants, prioritizing collections and how reminder tone usually escalates). The friendly, firm and final-notice reminder wording is built into the script.

    For each customer it adds up every overdue invoice's open balance times its days overdue, and ranks customers by that total, with ties going to the oldest due date. Disputed or on-hold invoices are kept off the list. Aging buckets (current, 1-30, 31-60, 61-90, 90+) and DSO are reported alongside, with the DSO formula shown.

    One row per invoice works best. If an export repeats an invoice number for line items, the first row is kept and the others are listed as duplicates, so export at invoice level. Currencies are reported separately and never converted, and there is no interest or late-fee calculation unless you supply your own fee policy text. DSO needs paid invoices too; an open-invoices-only export overstates it, and the script says so.

    Point the agent at your export. It first runs the --inspect step, which shows the columns it detected (QuickBooks Online, Xero, FreshBooks or a generic CSV) and any problems, then runs the report as of a date you choose. Reminder drafts are written only if you ask, only into a folder in your project, and are never sent.

    New in Finance & Accounting

    Free