Small Business 13-Week Cash Flow Forecaster
--- name: small-business-13-week-cash-flow-forecaster 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…
Open the source (opens github.com) https://github.com/f/prompts.chat
What it is
Prompts from f.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
The prompt
--- name: small-business-13-week-cash-flow-forecaster 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. --- # Small Business 13-Week Cash Flow Forecaster 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. ## Files in this skill - `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) - `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 - `references/cash-levers.md` - what to do about a gap: collect, defer, cut, finance, in order of cost and speed - `templates/cash-flow-brief.md` - the one-page brief to hand back - `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 - `examples/studio-forecast.md` - the real output of the forecaster on that file - `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 ## Workflow ### 1. Collect the inputs 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. ### 2. Run the forecaster ``` python3 scripts/cashflow13.py examples/studio-cashflow.csv python3 scripts/cashflow13.py forecast.csv --opening 41250 --min 15000 python3 scripts/cashflow13.py forecast.csv --stress-cut 30 --stress-delay 21 --week 9 python3 scripts/cashflow13.py forecast.csv --json python3 scripts/cashflow13.py --self-test ``` 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. ### 3. Read the result - Look at the low point first, in both cases: the week, the amount, and the gap to the buffer. - 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. - Stress case: if it goes below zero, is the credit line enough, and for how long? - Concentration: one customer above about 30% of receipts makes their payment date the forecast. - Run-rate: negative means the business relies on one-off income; say how many weeks the closing cash lasts without it. ### 4. Turn it into actions 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. ### 5. Deliver and roll forward 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. ## Example result 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…
Written by the prompts.chat (CC0 prompt collection) community (f). Not tested by InnerVault.
How to get it
Setup steps: not applicable.
Related
-
Creative Branding Strategist
PromptsYou are a creative branding strategist, specializing in helping small businesses establish a strong and memorable brand identity. When given information about a business's values, target audience, and industry, you…
-
Small Business Loan Broker Agent
PromptsAct as a Small Business Loan Broker Agent. You are an expert in connecting small businesses with necessary financial products such as loans, lines of credit, and other services listed at [David Allen…
-
Act as a Professional Salesman. You are a masterful closer in the small business loan industry, adept at turning cold traffic and clients in the educational phase into committed customers. Your task is to: - Engage…
-
Act as a personal capsule wardrobe stylist. You have helped hundreds of people, from busy parents to frequent travelers and new graduates, build small wardrobes where almost everything goes with everything. You plan…
-
Startup Idea Generator
PromptsGenerate digital startup ideas based on the wish of the people. For example, when I say "I wish there's a big large mall in my small town", you generate a business plan for the digital startup complete with idea name…
-
ultra-realistic single photograph, evening interior of a small Turkish dessert shop on a busy street, shot with a full-frame DSLR, 35mm lens at f/1.8, ISO 800, soft warm tungsten lighting mixed with cold blue light…