How to Upload a Claude Skill
Cash Flow Forecaster: AR/AP Dataset Walkthrough
Features List
13
Weeks of cash visibility, built from your AR aging
3
Scenarios in every run: base, stress, optimistic
7
Tab Excel workbook with week-by-week cash position
Why Treasury Teams Use This Skill
Built From Your Aging Data
This is not a templated forecast. It reads your actual AR aging report — current, 1-30, 31-60, 61-90, and 91+ day buckets — applies your collection rate assumptions per bucket, and builds a week-by-week receipt schedule that reflects your real customer payment behaviour.
Shortfall Flagged Automatically
The dashboard calculates your lowest cash point across the 13 weeks and compares it to your minimum required balance. If you're heading for a shortfall, the forecast flags it with the week, the amount, and the gap to your credit line — before it happens.
Three Scenarios, One Run
Every forecast includes a base case, a stress case (15% lower receipts, 5% higher disbursements), and an optimistic case (10% higher receipts, 5% lower disbursements). All three scenarios run from the same dataset. Change the scenario factors in the Assumptions tab and everything updates.
Week-by-Week Cash Position
The 13-Week Forecast tab shows opening balance, total receipts, total disbursements, net cash flow, closing balance, and excess or shortfall versus minimum — for every one of the 13 weeks. You see exactly when cash is tight and when it is not.
Fully Editable Assumptions
Collection rates, payment timing percentages, minimum cash balance, and credit line are all editable in a single Assumptions tab. Change any input and the Receipts Detail, Disbursements Detail, 13-Week Forecast, Scenarios, and Dashboard tabs all update automatically through cross-sheet formulas.
What You Get
-
Cash Flow Forecaster (.skill file)
The Claude Custom Skill. Upload it to your Claude account and run it with any AR and AP aging data. Works from totals-only inputs or detailed invoice-by-invoice datasets. No coding required.
-
7-Tab Excel Workbook Output
Every run produces a formula-driven workbook: Dashboard (KPI scorecard with alert status), Data Input, Assumptions, Receipts Detail (week-by-week by AR bucket), Disbursements Detail (week-by-week by AP bucket), 13-Week Forecast (full cash flow statement), and Scenarios (base, stress, optimistic side-by-side).
-
Collection Rate Assumptions
Built-in default collection rates by AR aging bucket — 96% for current, 90% for 1-30 days, 75% for 31-60 days, 55% for 61-90 days, 15% for 91+ days — with week-by-week payment timing spreads. All editable to match your actual customer payment behaviour.
-
Scenario Stress Test Framework
Three pre-configured scenarios: base (actuals), stress (receipts -15%, disbursements +5%), optimistic (receipts +10%, disbursements -5%). Apply any scenario in one click by changing two cells in the Assumptions tab. The Scenarios tab shows all three side-by-side across all 13 weeks.
-
Sample AR/AP Dataset (Excel)
The dataset used in the walkthrough video: 30 AR invoices across 10 customers ($359K total) and 30 AP invoices across 10 suppliers ($431K total), spread across all five aging buckets. Use it to test the skill before running your own data.
When to Run This Skill
Weekly Liquidity Check
Your treasury team needs a rolling 13-week cash position updated each week. Upload the current AR and AP aging reports, run the skill, and get an updated workbook in minutes. The Dashboard flags any week where you breach the minimum balance threshold before it arrives.
Board or Lender Cash Presentation
Heading into a board meeting or lender covenant review where cash flow will be scrutinised? The 13-week forecast and three-scenario analysis give you a defensible, data-driven view of liquidity — built from actual receivables and payables, not a top-down model.
Seasonal Trough Planning
You know a slow quarter is coming and want to map out the cash impact. Upload the current aging data, run the stress scenario (15% lower collections, 5% higher disbursements), and identify exactly which week your cash hits its lowest point and by how much you need your credit line.
Acquisition Cash Due Diligence
Assessing a target company's liquidity? Upload their AR and AP aging reports and run the skill to see how their cash position looks over the next 13 weeks — before and after applying stress assumptions. A fast, structured view of near-term liquidity risk.
High Past-Due AR Triage
When 76% of your receivables are past due, a standard P&L view masks the cash risk. The skill applies bucket-specific collection rates and timing to show you which weeks are most exposed and what the cash shortfall looks like if collections underperform. You can run the optimistic scenario to see what aggressive collection effort would recover.
What's in the Workbook
| Tab | Type | What It Contains |
|---|---|---|
| Dashboard | KPI Scorecard | Current cash, minimum required, total AR, total AP, net working capital. 13-week forecast results: total receipts, disbursements, net cash flow, ending cash, lowest cash point, maximum shortfall. Alert status (OK / Watch / Critical). |
| Data Input | Editable Inputs | Starting cash balance, minimum cash required, credit line available, AR aging balances by bucket (current through 91+), AP aging balances by bucket. All blue cells — edit here, everything else updates. |
| Assumptions | Editable Inputs | Collection rates by AR bucket. Week-by-week payment timing spread for each AR and AP bucket across all 13 weeks. Scenario factors for stress and optimistic cases. |
| Receipts Detail | Calculated | Week-by-week cash receipts from each AR aging bucket across all 13 weeks, plus totals. All formula-driven from Data Input and Assumptions — no manual entry. |
| Disbursements Detail | Calculated | Week-by-week cash disbursements from each AP aging bucket across all 13 weeks, plus totals. Cross-referenced to Assumptions tab for payment timing. |
| 13-Week Forecast | Summary | Full 13-week cash flow statement: opening balance, receipts, disbursements, net flow, closing balance, minimum required, and excess or shortfall per week. The core deliverable for lender and board presentations. |
| Scenarios | Stress Test | Base, stress, and optimistic closing balances side-by-side across all 13 weeks, with minimum required balance shown for comparison. One-glance view of downside and upside liquidity range. |
Common Questions
What data does the skill need?
How does it handle collection uncertainty?
What's in the stress scenario?
How often should I rerun the forecast?
Can it handle more than 10 customers or suppliers?
Is the Excel workbook editable after it's produced?
Know Your Cash Position Before Your Bank Does.
13 weeks of cash visibility, built from your actual AR and AP aging data. Three scenarios included. Board-ready output on the first run. Updated for 2026.