← ClaudeAtlas

small-business-cash-flow-snapshotlisted

Reads AR/AP, historical cash timing, and known fixed costs from QuickBooks, PayPal, Stripe, or Square — or a CSV upload — and produces a 30/60/90-day cash flow forecast with percentage-variance confidence bands and named risk flags. Delivers a chat summary and a downloadable XLSX. Use when the user asks "forecast my cash flow," "will I make payroll," mentions "runway," or says "cash crunch." Falls back to CSV upload when no connector is live.
simongonzalezdc/codex-small-business-skills · ★ 1 · AI & Automation · score 70
Install: claude install-skill simongonzalezdc/codex-small-business-skills
# Cash Flow Snapshot Produces a 30/60/90-day cash flow forecast with percentage-variance confidence bands and named risk flags. Delivers a two-part output: a concise chat summary and a downloadable XLSX workbook. **Quick start** > "Will I make payroll next month?" Claude pulls AR/AP and fixed costs from connected sources, calculates expected inflows and outflows across 30, 60, and 90-day windows, applies confidence bands based on each customer's historical payment variance, and flags specific risks by name. --- ## Workflow ### Step 1 — Identify available data sources Check which connectors are live. Try in this order: 1. QuickBooks — primary source for AR aging, AP, and fixed costs 2. PayPal — transaction history and settlement timing 3. Stripe — charge and payout history 4. Square — sales and payout history 5. CSV upload — fallback if no connector is connected If no connector is live and no file is attached, ask the user to either connect a source or upload a CSV (income/expense tabular data, any reasonable format). Note which sources were used in the output — this affects confidence band width. ### Step 2 — Pull the data **From QuickBooks:** - AR aging report: customer name, invoice amount, invoice date, due date, days outstanding - AP: vendor name, amount due, due date - Recurring fixed costs: rent, payroll, subscriptions (look for recurring transactions) **From PayPal / Stripe / Square:** - Settlement history: transaction date, amount, settlement date - Use s