✦ Ask the analyst
Available on every tab in your workspace — answers come with sources, the period, the calculation, and a confidence level.
Answers run on your connected books after signup. The sample keeps every number deterministic — it never improvises a reply.
13-week cash
Your current weekly cash forecast — pick a named scenario to see when and why cash changes.
Opening cash
$620,000
Week 13 · Base
$295,940
Week 13 · Scenario
$344,265
+$48,325
Minimum cash · Scenario
$201,203
W6 · 2026-06-29 · No breach in 13 weeks
Forecast vs what actually happened
Accuracy over the last 5 weeks: ±8.5%Last reconciled week: −$98,600 against the forecast
Collections came in $83,810 behind the model.
One week is not reconciled yet — excluded from the score
Example: these weeks illustrate how the score reads — they are not a real ledger.
Why cash changed
- Revenue growth / project volume (monthly): 0% → 2% — Ramps future invoicing only; cash lands after the 1-week collection lag
Timing assumptions
- New invoicing converts to cash after the observed 1-week collection lag; pre-window invoicing is unchanged.
Monthly ending cash in Scenarios and Week-13 cash here use different horizons and methods (12-month monthly model vs 13-week direct method) — the deltas are not meant to match.
Payment calendar
What the books' own documents say is due, beside the thirteen weeks the model projects.
Payment terms have not been read from the books yet.
Weekly cash bridge
Scroll sideways for the scenario columns →
| Week | Opening | Receipts | Payments | Ending · Base | Actual | Deviation | Ending · Scenario | Δ |
|---|---|---|---|---|---|---|---|---|
| happened 2026-04-13 | — | — | — | $1,067,597 | $1,034,731 | −$32,867 | — | — |
| happened 2026-04-20 | — | — | — | $997,798 | $932,064 | −$65,733 | — | — |
| happened 2026-04-27 | — | — | — | $927,998 | $829,398 | −$98,600 | — | — |
| happened 2026-05-04 | — | — | — | $858,199 | $759,599 | −$98,600 | — | — |
| happened 2026-05-11 | — | — | — | $788,399 | $689,799 | −$98,600 | — | — |
| happened 2026-05-18 | — | — | — | $718,600 | $620,000 | not reconciled yet | — | — |
| W1 2026-05-25 | $620,000 | $240,185 | $309,984 | $550,201 | — | — | $550,201 | $0 |
| W2 2026-06-01 | $550,201 | $240,185 | $309,984 | $480,401 | — | — | $480,401 | $0 |
| W3 2026-06-08 | $480,401 | $240,185 | $309,984 | $410,602 | — | — | $410,602 | $0 |
| W4 2026-06-15 | $410,602 | $240,185 | $309,984 | $340,802 | — | — | $340,802 | $0 |
| W5 2026-06-22 | $340,802 | $240,185 | $309,984 | $271,003 | — | — | $271,003 | $0 |
| W6 2026-06-29 | $271,003 | $240,185 | $309,984 | $201,203 | — | — | $201,203 | $0 |
| W7 2026-07-06 | $201,203 | $240,185 | $226,651 | $214,737 | — | — | $219,541 | +$4,804 |
| W8 2026-07-13 | $214,737 | $240,185 | $226,651 | $228,271 | — | — | $237,878 | +$9,607 |
| W9 2026-07-20 | $228,271 | $240,185 | $226,651 | $241,805 | — | — | $256,216 | +$14,411 |
| W10 2026-07-27 | $241,805 | $240,185 | $226,651 | $255,339 | — | — | $274,553 | +$19,215 |
| W11 2026-08-03 | $255,339 | $240,185 | $226,651 | $268,872 | — | — | $297,791 | +$28,918 |
| W12 2026-08-10 | $268,872 | $240,185 | $226,651 | $282,406 | — | — | $321,028 | +$38,622 |
| W13 2026-08-17 | $282,406 | $240,185 | $226,651 | $295,940 | — | — | $344,265 | +$48,325 |
Opening + receipts − payments = ending, every week. Opening, receipts and payments shown are the Base forecast; the scenario column re-times and re-sizes them per the drivers above.
Forecast basis
where the Base numbers come from
Opening $620,000 + net −$324,060 = week 13 $295,940
Simplifications
- No seasonality was derived from your history — invoicing is modelled flat at the run-rate.
- The downside collection haircut is a default (0.70×), not derived from your own variance.
This is a worked example on sample numbers — sign up to test your own decisions against your approved forecast.