Fix Your Cash Cycle
Working Capital Optimizer
DSO, DIO, DPO — benchmarked and fixed
Get the OptimizeHow to Upload a Claude Skill
Working Capital Optimizer: AR Analysis Walkthrough
Features List
3
Working capital levers analyzed in one session
7
Tab Excel workbook with KPI dashboard included
15+
Industries benchmarked, from manufacturing to SaaS
Why Treasury Teams Use This Skill
CCC Benchmarked by Industry
Your DSO, DIO, and DPO are calculated against industry-specific benchmarks from 15+ sectors — manufacturing, distribution, SaaS, pharma, retail, and more. You see exactly where you stand against median and top-quartile peers, with the cash gap quantified in dollars.
Customer-Level AR Diagnosis
Upload your AR aging report and the skill identifies which specific customers are past due, which have breached their credit limits, and which represent concentration risk. Each issue comes with a recommended action and a cash impact estimate.
Inventory Health Scoring
Slow-moving and obsolete inventory are a hidden cash drain. The skill segments your inventory by age — active, slow (90-180 days), very slow (180-365 days), obsolete (365+) — and quantifies the cash tied up in each bucket, with liquidation and write-down recommendations.
AP Terms Gap Analysis
Paying suppliers earlier than your terms require is a free loan to your vendors. The skill compares your actual DPO to industry benchmarks and your contracted terms, identifies which suppliers have room for term extension, and calculates the cash released by using your full payment window.
Phased Implementation Roadmap
Every run produces a prioritized initiative list scored by cash impact and implementation effort, plus a phased roadmap: quick wins in months 1-3, process improvements in months 4-6, and strategic initiatives in months 7-12. Each initiative has an owner, a cash target, and a due date.
What You Get
-
Working Capital Optimizer (.skill)
The Claude Custom Skill file. Upload it to your Claude account and run it with any combination of AR aging data, inventory reports, and AP schedules. Works from basic totals or detailed customer/SKU-level data.
-
7-Tab Excel Workbook Output
Every run produces an interactive Excel workbook: Dashboard (KPI scorecard with conditional formatting), AR Analysis, Inventory Analysis, AP Analysis, Opportunity Summary, Roadmap, and Assumptions. Edit the Assumptions tab to run scenarios without rebuilding anything.
-
Industry Benchmark Library
Built-in benchmark data for 15+ industries covering DSO, DIO, DPO, CCC, and working capital as a percentage of revenue — at bottom quartile, median, top quartile, and best-in-class levels. Sources include REL/Hackett Group, APQC, and Damodaran.
-
Prioritized Opportunity Register
A scored list of every identified initiative, ranked by impact (cash release and CCC days) and effort (timeline and implementation complexity). Quick wins, strategic initiatives, and fill-ins are separated so you know exactly where to start.
-
Sample AR Aging Report (PDF)
The ABC Distribution AR aging report used in the walkthrough video. Use it to test the skill before running your own data — the report includes credit limit breaches, 60+ day past-due balances, and customer concentration issues for a realistic test case.
When to Run This Skill
Board Cash Flow Review
Your board wants to know how much cash is locked in working capital and what you're doing about it. Run the skill before the meeting, get the benchmark comparison and the opportunity summary, and walk in with a quantified improvement plan — not just a trend chart.
AR Collections Getting Worse
DSO is creeping up and you're not sure which customers are driving it. Upload the aging report and the skill breaks down the problem by customer, flags credit limit breaches and concentration risk, and gives your collections team a prioritized call list with the cash impact of each account.
Inventory Tied Up, Cash Tight
You know slow-moving inventory is a problem but don't know how big. The skill segments every SKU or category by age, shows you the cash tied up in each bucket, and recommends liquidation, markdown, or write-down actions — with a dollar value attached to each one.
Supplier Terms Renegotiation
Before your next procurement review, run the skill to see how your DPO compares to industry benchmarks and your own contracted terms. It identifies which suppliers are worth approaching for extended terms and quantifies the cash benefit — giving you a data-backed case to bring to the negotiation.
Acquisition Working Capital Review
You're buying a business and need to assess its working capital quality. Upload the target's AR aging, inventory, and AP data and get a diagnostic in one session: DSO vs. sector benchmarks, inventory health scoring, AP term gaps, and a cash release opportunity estimate.
What's in the Workbook
| Tab | Type | What It Contains |
|---|---|---|
| Dashboard | KPI Scorecard | DSO, DIO, DPO, CCC — current vs. target vs. benchmark, with conditional formatting (green/amber/red). Net working capital, WC% of revenue, and cash released YTD. |
| AR Analysis | Analysis | Customer-level AR aging, DSO by customer, credit limit status, past-due detail, and customer concentration. Flags breaches and escalation-priority accounts. |
| Inventory Analysis | Analysis | Inventory segmented by age bucket (active, slow, very slow, obsolete). Turns by category, GMROI, slow-moving percentage, and cash tied up by segment. |
| AP Analysis | Analysis | Supplier-level AP with contracted terms, actual DPO, and gap to terms. Early payment discount capture rate and term extension opportunity by supplier. |
| Opportunity Summary | Prioritized List | All initiatives ranked by impact score and effort score. Quick wins, strategic initiatives, and fill-ins separated. Total cash release and CCC improvement shown. |
| Roadmap | Action Plan | Phased implementation plan: Phase 1 (0–3 months), Phase 2 (3–6 months), Phase 3 (6–12 months). Each action has an owner, due date, and cash target. |
| Assumptions | Editable Inputs | All editable inputs in one tab: revenue, COGS, purchases, benchmark targets, scenario parameters. Change any input and all tabs update automatically. |
Common Questions
What data do I need to run this?
Can it analyse just AR, without inventory or AP?
How does the industry benchmarking work?
What does the Excel output look like?
How specific are the cash release numbers?
Is this suitable for an acquisition due diligence?
The Cash Is Already in Your Business. Now Go Get It.
DSO, DIO, and DPO benchmarked against your industry. Cash release opportunities identified and prioritized. Phased roadmap included. Updated for 2026.