cash-flow-forecast
Forecast cash flow and runway for a Well workspace from booked invoices and collected bank transactions. Use when the user asks for a cash-flow forecast, runway, how long until they run out of cash, projected balance, or expected inflows/outflows.
适合你,如果你需要根据实际交易数据预测公司未来现金流
npx oh-my-skill add wellapp-ai/well/cash-flow-forecastcurl -fsSL https://oh-my-skill.com/install.sh | bash -s -- wellapp-ai/well/cash-flow-forecastnpx oh-my-skill verify wellapp-ai/well/cash-flow-forecast怎么用
商店整理自技能原文 · 版本 782601c · 表述以原文为准装上后,Claude 可以根据已开票的发票和银行交易记录,预测现金流和资金存续期。它按实际数据(发票、收款、付款天数)逐期展示预计余额,并告知资金还能维持多久。
当用户询问现金流预测、资金存续期、预计余额、预期收入或支出时触发。
技能原文 SKILL.md
Cash-flow forecast from Well
A trustworthy forecast is grounded in what actually happened — invoices raised, cash collected, and observed days-to-pay — not in optimistic projections. Every forecast must state its time window and filters, and flag thin history explicitly.
Build it from booked + collected
- Discover the schema first (see
well:querying-well-data). - Starting position — current cash:
well_get_schema("account_balances")/accounts, sum the latest balance per account (note the currency). - Expected inflows (booked) — open
invoices(issued, unpaid) with their due dates and outstanding amounts. Adjust each due date by the customer's observed days-to-pay where history exists (derive from pastinvoices+ their settlingtransactions/invoice_transactions). - Expected outflows (booked) — received/payable
invoiceswith due dates; plus recurring outflows visible intransactionshistory (rent, payroll, subscriptions). - Project the balance forward per period (week or month): starting cash + expected inflows − expected outflows. Report the projected balance per period and the runway (the period the balance crosses zero, if any).
Rules
- State the window and filters behind the forecast (e.g. "next 13 weeks, EUR, excludes intra-account transfers"). A forecast without its assumptions is a vanity number.
- Flag thin history. If days-to-pay or recurring-outflow history is sparse (low n), say so — confidence is overstated on thin data.
- Distinguish booked (invoices/contracts that exist) from assumed (run-rate extrapolation), and label which is which.
- Don't sum across currencies without converting (see
exchange_rates).
Present it
A per-period table — opening balance, inflows, outflows, closing balance — the runway in plain terms ("≈ N weeks at current trajectory"), the stated window/filters, and an explicit confidence note when history is thin.