Cash Flow Snapshot
by OnwireFlow
Generate professional 30/60/90-day cash flow forecast workbooks with live formulas and shortfall alerts.
Free
Works with the AI tools you already use
See it in action
You say
Can you forecast my cash for the next 90 days? I want to know if I'll be okay. My current bank balance is €4,200 and I want to keep at least €1,000 in the account.
Money coming in:
- Client A project invoice €3,500, due 20 June (one-off)
- Monthly retainer from Client B €1,800 (recurring monthly)
- Client C milestone €2,200 around 10 July (one-off)
Money going out (monthly unless noted):
- Office rent €1,200
- Software subscriptions €180
- Insurance €95
- My own drawings €2,000
- A contractor €2,600, one-off on 28 June
Your agent does
A ready Excel workbook (.xlsx) and a plain-English verdict, for example:
"Over the next 90 days you stay positive. You open at €4,200, take in €11,100 and pay out €13,025, closing at €2,275. Your lowest point is €2,275 — it stays above your €1,000 buffer, so you're okay on cash, but the trend is downward, so keep an eye on it after this window."
The workbook has four tabs:
- Snapshot — opening/closing balance, total in/out, net change, lowest balance and its date, your buffer, the "will you run short?" line, and a balance chart
- Forecast — every expected payment in and out, dated, with a live running balance (editable)
- Weekly Summary — money in, out, net and your balance at the end of each week
- Start Here — how to use and adjust it
Every figure is a live formula, verified with zero formula errors, and works in Excel, Google Sheets, Apple Numbers and LibreOffice — no macros.
About this skill
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.
How to install
Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
3 installs
Downloaded by developers to date
Free forever
No account required to browse
Trust & safety
Security scanned
Verified clean 1 month ago
- Free to download with an account
Creator
I'm a bookkeeping and tax practitioner who turns everyday finance headaches into simple, reliable AI skills. My tools help freelancers, sole traders and small companies anywhere in the world invoice correctly, sort their expenses, and stay on top of cash flow — country-aware, formula-driven, and built to actually work. More finance and compliance skills on the way.
Frequently Asked Questions
Popular in Finance, Legal & Accounting
gtm-engine
High-conversion sales outreach, SaaS agreements, and marketing collateral for revenue-focused AI agents.
legal-doc-generator
Generate production-ready, platform-specific Terms of Service, Privacy Policies, and Refund Policies for your SaaS.
Expense Categoriser Global
Turn messy bank statements into clean, categorized business expense tables and formula-driven Excel workbooks.
Invoice Builder Global
Generate a complete, country-compliant Excel invoicing and tax tracking system for any business worldwide.