cash-flow-forecaster

Solid

Build a 13-week rolling cash flow forecast from bank exports, AR aging, AP bills, payroll, and recurring commitments -- the report that tells a small business whether it survives the quarter. Flags the crunch weeks early enough to act.

AI & Automation 288 stars 46 forks Updated 1 months ago MIT

Install

View on GitHub

Quality Score: 86/100

Stars 20%
82
Recency 20%
75
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# Cash Flow Forecaster Profitable businesses die of cash starvation; the 13-week forecast is the instrument that prevents it. Input: bank/transaction exports (.csv/.xlsx), open invoices (AR), upcoming bills (AP), payroll schedule, and known recurring items. Output: a week-by-week cash position with the crunch points circled. ## Workflow 1. **Establish the baseline.** Current cash across accounts (from the most recent export -- state the as-of date prominently). Reconstruct 8-12 weeks of history to learn the rhythm: payroll cadence, rent day, typical weekly card/vendor spend, revenue deposit patterns. 2. **Schedule the knowns.** Inflows: open AR placed in the week each invoice is *likely* paid -- due date plus that customer's historical lateness, not the due date printed on the invoice. Outflows: payroll (with tax deposit timing), rent, loan payments, insurance, subscriptions, credit card due dates, quarterly estimated taxes -- the ambush everyone forgets. 3. **Model the unknowns.** Recurring-but-variable spend from historical averages, labeled `ESTIMATE`. New revenue only if the user provides expected deals -- never invent pipeline. 4. **Build the forecast.** `cash-flow-13wk.csv` + summary: weekly beginning cash, inflows, outflows, ending cash. Flag every week ending below the user's minimum comfort level (ask; default one payroll cycle) as `CRUNCH`, and the first crunch week is the headline. 5. **Scenario the levers.** For each crunch: what closes the gap -- which specifi...

Details

Author
OneWave-AI
Repository
OneWave-AI/claude-skills
Created
10 months ago
Last Updated
1 months ago
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

cashflow-projection

Cashflow projection for the next 90 days. Reads GnuCash snapshot and active project pipeline, models income against outgoings, flags break-even risk. Run monthly or when planning new work.

0 Updated 1 weeks ago
markbaindesign
AI & Automation Listed

burn-rate-runway-planner

Models cash burn, runway, and scenario-based cash flow with explicit triggers, default-alive versus default-dead diagnosis, and a 13-week rolling forecast. Use when planning a fundraise, deciding on layoffs, evaluating hiring plans, modeling a downturn, presenting cash position to the board, or pressure-testing a Chief Financial Officer (CFO) operating plan.

1 Updated 1 months ago
varunk130
AI & Automation Listed

finance-tracker

SMB and startup finance tracking — cash-flow projection, runway calculation, burn-rate diagnostics, founder-finance literacy, monthly close-light cadence, and founder-friendly tooling (Brex / Mercury / Stripe Atlas / Conta Azul / Omie). Distinct from `domains/finance-accounting/skills/bookkeeper-controller` (full-stack accounting) and `domains/finance-accounting/skills/fpa-analyst` (enterprise planning cycles) — this skill addresses founder-side financial awareness at the pre-scale stage. Use when: a founder or small-team operator needs runway visibility within one business day; when cash-flow forecasting is absent or spreadsheet-only; when burn decomposition by category has not been performed; when preparing the first investor board pack; or when selecting between SMB-oriented finance tools.

2 Updated today
Canhada-Labs