Skip to content

sandbaseai/sandbase-skills / marketing/cash-flow-snapshot

cash-flow-snapshot

Verified

Create a 30/60/90-day cash-flow forecast from AR, AP, opening cash, payment timing, and fixed-cost data. Use when asked about runway, payroll coverage, liquidity risks, or a near-term cash crunch.

FileKindSize
SKILL.mdskill md7.4 KB
reference/examples/worked-example.mdmarkdown3.9 KB
reference/gotchas.mdmarkdown2.4 KB
references/sandbase-api-map.mdmarkdown1.0 KB

reference/examples/worked-example.md

View on GitHub
# Worked example — cash-flow-snapshot

**Scenario:** Small services business. QuickBooks + PayPal connected. Three
active customers, monthly payroll, office rent.

---

## Input data (pulled from connectors)

**AR aging (QuickBooks):**

| Customer       | Invoice | Amount   | Due Date   | Days Outstanding |
|----------------|---------|----------|------------|------------------|
| Acme Corp      | INV-112 | $8,400   | Apr 10     | 12               |
| BlueSky LLC    | INV-108 | $14,200  | Apr 22     | 0                |
| Crestwood Inc  | INV-115 | $6,000   | May 5      | —                |

**Historical payment lag (from PayPal settlements):**

| Customer       | Mean Lag | Std Dev | Payments on Record |
|----------------|----------|---------|--------------------|
| Acme Corp      | 18 days  | 4 days  | 11                 |
| BlueSky LLC    | 7 days   | 2 days  | 8                  |
| Crestwood Inc  | 12 days  | 5 days  | 6                  |

**Fixed costs (QuickBooks recurring AP):**
- Payroll: $22,000 — hits April 15
- Rent: $3,200 — hits May 1
- Software subscriptions: $480 — hits May 1

**Opening cash:** Not supplied. This example can show period net flows and timing
exposure, but cannot determine actual ending liquidity or payroll coverage.

---

## Step 3 output — adjusted inflow dates

| Customer       | Invoice Amount | Adj. Receipt Date | Notes                             |
|----------------|---------------|-------------------|-----------------------------------|
| Acme Corp      | $8,400        | Apr 28            | Due Apr 10 + 18-day mean lag      |
| BlueSky LLC    | $14,200       | Apr 29            | Due Apr 22 + 7-day mean lag       |
| Crestwood Inc  | $6,000        | May 17            | Due May 5 + 12-day mean lag       |

---

## Step 4 output — 30/60/90 forecast

Confidence band calculation:
- Weighted avg stddev: 3.6 days
- Weighted avg mean lag: 12.7 days
- band_pct = 3.6 / 12.7 = **28.3%**

| Window  | Expected Inflows | Expected Outflows | Net      | Low (−28%) | High (+28%) |
|---------|-----------------|-------------------|----------|------------|-------------|
| 0–30d   | $22,600         | $22,000           | +$600    | −$5,796    | +$6,996     |
| 31–60d  | $6,000          | $3,680            | +$2,320  | +$622      | +$4,018     |
| 61–90d  | $0              | $0                | $0       | —          | —           |

---

## Step 5 output — risks flagged

1. **Payroll crunch:** Payroll ($22,000) hits April 15. Low-band inflows through
   April 14: $0 (both AR receipts fall April 28–29). Up to $22,000 must be covered
   by opening cash or another verified source; actual coverage is unknown until
   the opening balance is supplied.
   *Recommend: confirm receivables timing with Acme and BlueSky before April 14.*

2. **Late-payer risk:** Acme Corp historically pays 18 days late. Their $8,400
   invoice (due Apr 10) shifts to April 28 — after payroll.

---

## Step 6 output — chat summary

```
Cash Flow Snapshot — Apr 1 → Jun 29, 2026
Sources: QuickBooks, PayPal
Opening cash: Not supplied — ending liquidity and payroll coverage undetermined

              Expected    Low        High
30-day net:   +$600      −$5,796    +$6,996
60-day net:   +$2,320    +$622      +$4,018
90-day net:   $0         —          —

⚠ 2 risks flagged:
  • Payroll timing gap: $22K payroll hits Apr 15; AR receipts don't clear until
    Apr 28–29. Opening cash must cover the gap, but was not supplied.
  • Late-payer: Acme Corp (mean 18-day lag) shifts $8,400 past payroll date.

Confidence band: ±28% (based on historical payment variance across 3 customers).

This forecast is based on QuickBooks AR/AP and PayPal settlement history.
It is not a substitute for accounting advice — verify with your bookkeeper
before making financing decisions.
```

**XLSX:** `cash-flow-snapshot-2026-04-01.xlsx` — Summary / Detail / Risks sheets.
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 322kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 322kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 322kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 198kUpdated Claude CodeCodexVerifiedInstall