Skill Locker
All skills
v1.3.03 loop iterations

Cash Flow Forecaster

Most small businesses don't die from lack of revenue — they die from cash flow timing. The Cash Flow Forecaster builds a weekly model that catches the gap where payroll, rent, and a late invoice all hit the same Friday, in time to do something about it.

What this skill does

Cash is not revenue. A signed contract is not cash. An invoice is not cash. Cash is money that has actually arrived in the bank account, and the gap between booking revenue and collecting it is where profitable businesses go broke. The skill models cash on the day it actually clears, with payment terms applied per income stream, so the picture you get is what the bank balance will look like — not what the P&L would suggest.

The model runs weekly for the first month and monthly for months two and three. Weekly resolution matters because monthly resolution hides the killer week. A month can net positive while containing a Friday where payroll, rent, and a quarterly tool subscription all clear before a single retainer arrives. The monthly average lies. The weekly minimum tells the truth, and the skill reports that minimum prominently.

Three scenarios always run. Baseline is what you expect. Conservative shifts revenue two weeks late, discounts pipeline to 50%, adds a 10% expense buffer, and puts one major client at 30 days late — because that's what bad months actually look like. Optimistic exists for motivation; conservative is what you plan around. The skill labels the difference clearly and recommends action based on the conservative scenario, not the cheerful one.

Income gets classified before modelling. Recurring (SaaS, retainers) uses predictable monthlies. Project-based work uses a weighted pipeline and a six-month rolling average — never the best month — because freelance feast-and-famine averages mislead. Seasonal models use same-period-last-year as the anchor. Lumpy enterprise contracts get modelled payment by payment, with the dangerous valleys between them shown explicitly. An income volatility score over 0.3 forces the conservative scenario to use the lowest historical month.

You get the period-by-period model across all three scenarios, the explicit lowest-cash-point week with a date, a runway number for each scenario, a what-if table that always includes the hire scenario, the client-loss scenario, and the late-payment scenario, and a recommendation list with quantified impact — "cutting £800/month from tooling extends conservative runway from 4.1 to 5.6 months." Every assumption is stated. Missing inputs get flagged rather than fabricated. The skill refuses to build a model without a real cash-in-bank figure — a forecast off a guessed opening balance is worse than no forecast.

When this triggers

  • ·You want to know exactly when you run out of money, not roughly
  • ·You're debating a hire and need to see what it does to the worst week, not the average month
  • ·A big client pays slowly and you want to model the gap their next late payment will open up
  • ·Cash in the bank feels tight and you can't tell if it's a timing issue or a real problem
  • ·You're going into a finance conversation — investor, bank, accountant — and need a defensible 90-day cash picture

Example

Trigger

User: 'Solo consultant. £18K in the bank. £9K/mo fixed costs (salary, tools, accountant). Three retainers: £4K, £3K, £2K — paying Net 30. One £12K project, Net 60. VAT bill £6K due in 6 weeks. Can I afford a £3K/mo contractor?'

Output

Cash Flow Summary Current cash: £18,000 90-day outlook: TIGHT Runway: Baseline 6.2 months | Conservative 4.1 months Lowest point (baseline): £2,400 in week 6 (VAT week) Week-by-week (next 4 weeks, baseline) | Wk | Open | In | Out | Close | Note | |----|-------|-------|-------|--------|--------------------| | 1 | 18,000| 0 | 2,100 | 15,900 | Payroll wk | | 2 | 15,900| 9,000 | 1,200 | 23,700 | Retainers land | | 3 | 23,700| 0 | 2,100 | 21,600 | Payroll wk | | 4 | 21,600| 0 | 1,200 | 20,400 | - | Then weeks 5-6: VAT (£6K) hits before the Net 60 project pays. Closing balance hits £2,400 — under any sane buffer floor. What-If | Scenario | Impact | New lowest | |-----------------------|-------------|---------------| | Hire £3K/mo contractor| -£3K/mo | -£900 wk 6 | | £12K project 30d late | timing only | -£3,400 wk 8 | | Lose £4K retainer | -£4K/mo | Runway 3.1mo | Verdict on the hire: NO at current structure. The VAT-plus-Net-60 combination already breaks the safety floor. Hire after the £12K lands, or negotiate Net 30 on it first.

Get this skill + 8 more

Get the full Data & Analysis pillar (9 skills) or the complete library.

Get the full stack — $299

What you get

  • 206-line SKILL.md, ready to drop into ~/.claude/skills/
  • Tested through 3 Karpathy-loop iterations (versions v1.0.0 → v1.3.0)
  • Triggers automatically when relevant — no command to remember
  • Lifetime updates as the skill is refined further

More from Data & Analysis

Browse the full library

297 skills across 31 categories. One purchase, lifetime updates.

See all bundles