Cashflow Collector

Turn invoice aging exports into prioritized collection plans and polite payment reminder drafts.

Install
cmdop skills install agensi-cashflow-collector

Cashflow Collector is a skill published by agensi that takes raw invoice aging data — exported as CSV or JSON from accounting systems — and produces structured, actionable collection plans. It normalizes input into validated data models, handling ambiguous date formats and preserving source metadata throughout the process.

Once the data is validated, the skill ranks overdue accounts using a weighting that balances invoice value against debt age, grouping them into risk buckets so collection effort is directed toward the highest-impact accounts first. The output is two artifacts: a structured JSON file suitable for downstream integration with other tools or systems, and a human-readable Markdown report summarizing the prioritized accounts.

In addition to planning artifacts, the skill drafts payment reminder messages tailored to individual client contexts — firm in tone but polite — removing the need to compose collection correspondence from scratch.

The skill follows a strict data-validation workflow described as an Output Contract, which enforces consistent, structured output rather than relying on free-form LLM prompting. This makes it appropriate for workflows where reproducible, error-free artifacts matter more than conversational flexibility.

Cashflow Collector is suited to SMEs, bookkeepers, and solo operators who regularly work with invoice aging reports and need to move from raw export data to executable collection actions without manual spreadsheet analysis.

Use cases

  • Convert an accounting CSV export of overdue invoices into a ranked collection priority list
  • Generate a structured JSON collection plan for ingestion by a downstream automation or CRM tool
  • Produce a Markdown summary report of outstanding accounts sorted by risk and value
  • Draft polite but firm payment reminder messages tailored to specific overdue clients
  • Normalize invoice exports with inconsistent or ambiguous date formats into validated data models
  • Identify highest-value aged debts to focus collection effort where financial impact is greatest

When to use it

  • Working with CSV or JSON invoice aging exports from accounting software
  • Need reproducible, consistently structured collection plans rather than ad-hoc LLM output
  • Require both machine-readable JSON artifacts and human-readable Markdown reports from the same run
  • Want automated drafting of client-specific payment reminders without writing them manually
  • Operating as an SME, bookkeeper, or solo operator managing accounts receivable workflows

When not to use it

  • The source data is not invoice aging data — this skill is scoped specifically to that domain
  • Need real-time bank feed or payment gateway integration rather than static export processing
  • Require direct write-back to an accounting system; this skill produces files, not API calls
  • Input data is in a format other than CSV or JSON
  • Looking for a general-purpose financial analysis tool beyond accounts receivable collection