Cash Flow Snapshot

What it does

This skill builds a 30/60/90-day cash-flow forecast as a live Excel workbook that answers one question clearly: will you run short, and when. You give it your opening bank balance, the money you expect in, and the bills going out (one-off or recurring), and it produces a dated forecast with a running balance, your lowest point and the exact date it happens, a plain-English shortfall verdict, a weekly summary, and a balance chart. Built for freelancers, sole traders and small businesses anywhere in the world.

Why use this skill

Most owners only discover a cash crunch when it's already on top of them. A generic "make me a cash flow spreadsheet" prompt gives you an empty grid with no logic. This skill expands your recurring income and bills into a proper dated timeline, tracks the running balance day by day, and tells you in plain English whether you dip below the cushion you want to keep. Because every figure is a live formula, you can flex it instantly—chase an invoice a week earlier, delay a purchase—and watch the low point move.

Supported features

• Clear Verdict: A plain-English "will you run short?" answer with your lowest balance and the date it occurs.
• Recurring Items: Handles one-off, weekly, fortnightly, monthly, quarterly and yearly income and bills, expanded across your horizon.
• Buffer Check: Set the minimum balance you want to stay above and the forecast flags any breach.
• Live & Visual: A running-balance ledger, a weekly summary, and a balance chart—all formula-driven, so editing one figure updates everything.
• Works Anywhere: Worldwide and macro-free; opens in Excel, Google Sheets, Apple Numbers and LibreOffice.

This is a planning tool, not financial advice. A forecast is only as good as the estimates you put in.