working-capital-review

Analyzes AR, inventory, and AP aging to compute DSO, DIO, DPO, and cash conversion cycle.

Updated Jun 21, 2026
One-click install
npx skills add https://github.com/lwokeray/cowork-plugins --skill working-capital-review-lwokeray
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: working-capital-review
Source: https://github.com/lwokeray/cowork-plugins/tree/main/plugins/finance-cowork/skills/working-capital-review
Command: npx skills add https://github.com/lwokeray/cowork-plugins --skill working-capital-review-lwokeray

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Finance teams struggle to turn raw receivables, inventory, and payables data into consistent working-capital metrics and actionable cash-release opportunities without mixing definitions, scopes, or periods. ## Core Features & Use Cases - Working-Capital Metrics: Computes DSO, DIO, DPO, cash conversion cycle, and turnover ratios using consistent scope, period, currency, and average balances. - Aging and Concentration Analysis: Reviews AR, inventory, and AP aging, migration, disputes, unapplied cash, and customer/vendor/SKU concentration tied to GL control accounts. - Action Register: Builds a prioritized collections, dispute, inventory, and payables action register with cash impact, owners, due dates, and completion criteria. - Use Case: Ask it to analyze June working capital and it will tie aging reports to the GL, calculate the cash conversion cycle, and deliver a prioritized queue of cash-release opportunities with evidence and constraints. ## Quick Start Ask the assistant to analyze this month's working capital and identify the items with the largest feasible cash-release impact.

Frequently Asked Questions about working-capital-review

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate DSO, DIO, and DPO for working capital analysis?▼

DSO equals average accounts receivable divided by credit revenue times days in period, DIO uses average inventory over COGS, and DPO uses average AP over purchases or a disclosed cost base. The cash conversion cycle is DSO plus DIO minus DPO, and all ratios must share the same scope, period, and currency.

How to prioritize collections from an AR aging report?▼

Prioritize by amount, age, dispute status, customer risk, promise-to-pay evidence, and commercial sensitivity rather than sorting by largest balance alone. Separate items into direct collection, billing disputes, unapplied cash, and credit or legal review before estimating a realistic collection window.

Why does my DSO differ from the management report?▼

Differences usually come from gross versus net AR, credit revenue versus total revenue, or inconsistent average balance definitions. Align the definitions across both calculations and build a bridge reconciling the two figures.

Can this skill execute payments, write-offs, or credit limit changes?▼

No. It only produces analysis, scenarios, and recommendations. Contacting customers or vendors, changing credit limits or terms, issuing write-offs, and releasing payments are explicitly out of scope and require separate approved processes.

What happens when AR or AP aging does not tie to the GL?▼

The skill stops and flags the data as source incomplete, since unreconciled subledgers make ratios and opportunities unreliable. Reconcile manual journal entries, unposted batches, or debit balances first, then proceed with ratio and opportunity analysis.