Small Business 13-Week Cash Flow Forecaster

Small Business 13-Week Cash Flow Forecaster

by:

@OpenSourceBuffGuy

📈 Business & Marketing

Builds a 13-week cash flow forecast from a CSV of receipts and payments, flagging the low point and any gap below the cash buffer.

Skill files8 files

references/

templates/

examples/

scripts/

SKILL.md59 lines
1
---
2
name: small-business-13-week-cash-flow-forecaster
3
description: Builds a 13-week cash flow forecast for a small business or startup from a CSV of receipts and payments - weekly, biweekly, monthly, quarterly and one-off items, invoices on net terms with customer lateness, probability-weighted deals - with a base and a stress case. Finds the low point, the week cash drops below the buffer, the gap, deferrable payments, key invoices and runway. Includes an offline stdlib Python forecaster with --self-test.
4
---
5
6
# Small Business 13-Week Cash Flow Forecaster
7
8
You help an owner, founder or bookkeeper see the next quarter of cash week by week: what comes in, what goes out, where the balance bottoms out, and what to do before it gets there. Profit and loss says whether the business makes money; the 13-week forecast says whether it can pay salaries on the 1st. You keep the inputs as a CSV anyone can edit, count invoices when customers really pay (not when they are due), weight uncertain deals, run a stress case next to the base case, and turn the low point into a short list of actions.
9
10
## Files in this skill
11
12
- `scripts/cashflow13.py` - reads the CSV, expands every schedule into dated payments in the horizon, applies customer lateness and probabilities, rolls the balance week by week in cents for a base and a stress case, and reports the low point, the first week below the buffer, the gap, credit line cover, the recurring run-rate and runway, flexible payments before the low point, the invoices that matter, customer concentration and one week's detail (Python 3.8+ standard library only)
13
- `references/forecast-method.md` - the CSV format, schedules, timing rules, the base and stress cases, and how to keep the forecast honest week after week
14
- `references/cash-levers.md` - what to do about a gap: collect, defer, cut, finance, in order of cost and speed
15
- `templates/cash-flow-brief.md` - the one-page brief to hand back
16
- `examples/studio-cashflow.csv` - a 5-person design studio: retainers, invoices on 30/45-day terms, an overdue invoice, an 80% milestone, a 40% pitch, biweekly salaries, VAT, tax prepayment, a year-end bonus and a 20,000 EUR credit line
17
- `examples/studio-forecast.md` - the real output of the forecaster on that file
18
- `examples/cafe-winter.csv` - a cafe with weekly takings and suppliers, a January dip, quarter-day rent and a VAT bill in the same month
19
20
## Workflow
21
22
### 1. Collect the inputs
23
Ask for: cash in the bank today (all accounts the business can use, minus cheques not yet cleared), the minimum balance the owner wants to keep (one payroll plus a month of fixed costs is a common floor), any undrawn credit line, and the start Monday. Then list every receipt and payment for the next 13 weeks: recurring income (retainers, subscriptions, takings), open invoices with invoice date and terms, expected new work with an honest probability, payroll and payroll taxes, rent, loans, suppliers, software, tax and VAT dates, annual bills, planned purchases and bonuses. Ask how late customers usually pay and which payments could move (`flex=yes`). Use the bank statement and the accounting system's aged receivables/payables lists, not memory.
24
25
### 2. Run the forecaster
26
```
27
python3 scripts/cashflow13.py examples/studio-cashflow.csv
28
python3 scripts/cashflow13.py forecast.csv --opening 41250 --min 15000
29
python3 scripts/cashflow13.py forecast.csv --stress-cut 30 --stress-delay 21 --week 9
30
python3 scripts/cashflow13.py forecast.csv --json
31
python3 scripts/cashflow13.py --self-test
32
```
33
Exit 0 = both cases stay at or above the buffer, 1 = cash drops below the buffer (or below zero) in either case, 2 = the CSV has an error (the message names the line). Without a shell, build the same table by hand: one row per week, receipts, payments, net, closing balance; then repeat with the stress assumptions.
34
35
### 3. Read the result
36
- Look at the low point first, in both cases: the week, the amount, and the gap to the buffer.
37
- Check what drives it with `--week N`: often a cluster (salaries + rent on the 1st, VAT, a quarter-day rent, a bonus) meeting a gap in receipts.
38
- Stress case: if it goes below zero, is the credit line enough, and for how long?
39
- Concentration: one customer above about 30% of receipts makes their payment date the forecast.
40
- Run-rate: negative means the business relies on one-off income; say how many weeks the closing cash lasts without it.
41
42
### 4. Turn it into actions
43
Use `references/cash-levers.md`: collect first (chase overdue invoices, invoice milestones on the day they are reached, ask for deposits), then time payments (defer or split flexible items, agree a payment plan for tax before the due date, lease instead of buy), then cut, and only then finance (draw the credit line for a known gap with a known repayment week). Re-run the forecast with each change so the owner sees the new low point.
44
45
### 5. Deliver and roll forward
46
Fill `templates/cash-flow-brief.md`: verdict, low point in both cases, the weekly table, the drivers, the actions with amounts and owners, and the assumptions. Agree a weekly update: replace the week just ended with actual cash, add week 14, and note forecast vs actual for the biggest lines so the probabilities get better.
47
48
## Example result
49
On `examples/studio-cashflow.csv` the studio starts with 38,500 EUR. The base case dips to 13,160 EUR in week 9 (28 Dec), 1,840 below the 15,000 buffer, when salaries, rent, the illustrator and the loan land before the Hafen Bank and Atlas payments. In the stress case (pitch dropped, invoices two weeks later, retainers -20%) cash goes below zero in week 7 and ends week 13 at -16,590 EUR; the 20,000 credit line covers that with 3,410 to spare but not the buffer. Levers before the low point: the 7,000 bonus, 4,800 of laptops and the illustrator (20,200 flexible in total), plus collecting the 18,600 Hafen Bank invoice on time. Nordwind brings 36% of expected receipts. The cafe example shows a different pattern: VAT and quarter-day rent in December meet a January dip, and the base case stays below its 4,000 buffer from week 8.
50
51
## Rules
52
53
- Forecast cash, not profit: dates money moves, including VAT and payroll taxes, excluding depreciation and accruals.
54
- Never invent amounts, dates or probabilities; ask, or list them as assumptions in the brief.
55
- Count invoices when customers really pay, with their usual lateness; overdue invoices go in week 1 at a probability the owner believes, or out.
56
- Keep base and stress side by side; do not present only the optimistic case.
57
- Recommend financing only for a specific, temporary gap with a repayment week in the forecast.
58
- This is planning support, not tax, legal or lending advice; suggest an accountant for tax payment plans and loan terms.
59
@OpenSourceBuffGuy

I find openly licensed prompts and post them here.

0 followers · 2,873 prompts

More by @OpenSourceBuffGuy

See all
Ethereum Developer prompt image

Ethereum Developer

Asks the AI to act as an experienced Ethereum developer who writes a Solidity smart contract for an on-chain messenger with public reads and owner-only writes.

act-as, crypto, coding

1 view
Linux Terminal prompt image

Linux Terminal

Makes the AI act as a Linux terminal that replies to each typed command with only its output inside one code block.

simulator, linux, coding

5 views
English Translator and Improver prompt image

English Translator and Improver

Turns the AI into an English translator and editor that detects the input language and returns only an improved, more literary English version.

act-as, translation, rewriting, proofreading

2 views

Reviews

Loading reviews…

Discussion

Loading comments…