Ataski
Sign up free
Sample workspace — example data, not your own. Sign up free to run it on your own.
Financial Analyst Today Performance Forecast Business model Decisions Reports
⋯
Today Performance Forecast Business model Decisions Reports Data & settings
Data & settings
✦ Ask the analyst

Available on every tab in your workspace — answers come with sources, the period, the calculation, and a confidence level.

What happens to cash if collections slip two weeks? How did this forecast change since the last close, and why?

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.

 Download Excel Download CSV
Example Cash base · current 13-week forecast · from 2026-05-25 13 weeks · weekly · direct method Base only Expand the sales team Efficiency push
Opening cash
$312,000
Week 13 · Base
$245,949
Week 13 · Scenario
Pick a scenario to compare
Minimum cash · Base
$245,949
No breach in 13 weeks
Weekly ending cash — Base vs Scenario
$245,949 $276,434 $306,919 W1 W4 W7 W10 W13 W1 · 2026-05-25 — Base $306,919 W2 · 2026-06-01 — Base $301,838 W3 · 2026-06-08 — Base $296,758 W4 · 2026-06-15 — Base $291,677 W5 · 2026-06-22 — Base $286,596 W6 · 2026-06-29 — Base $281,515 W7 · 2026-07-06 — Base $276,434 W8 · 2026-07-13 — Base $271,353 W9 · 2026-07-20 — Base $266,273 W10 · 2026-07-27 — Base $261,192 W11 · 2026-08-03 — Base $256,111 W12 · 2026-08-10 — Base $251,030 W13 · 2026-08-17 — Base $245,949
Base (current forecast)

Weekly cash bridge

Week Opening Receipts Payments Ending · Base
W1 2026-05-25 $312,000 $34,642 $39,723 $306,919
W2 2026-06-01 $306,919 $34,642 $39,723 $301,838
W3 2026-06-08 $301,838 $34,642 $39,723 $296,758
W4 2026-06-15 $296,758 $34,642 $39,723 $291,677
W5 2026-06-22 $291,677 $34,642 $39,723 $286,596
W6 2026-06-29 $286,596 $34,642 $39,723 $281,515
W7 2026-07-06 $281,515 $34,642 $39,723 $276,434
W8 2026-07-13 $276,434 $34,642 $39,723 $271,353
W9 2026-07-20 $271,353 $34,642 $39,723 $266,273
W10 2026-07-27 $266,273 $34,642 $39,723 $261,192
W11 2026-08-03 $261,192 $34,642 $39,723 $256,111
W12 2026-08-10 $256,111 $34,642 $39,723 $251,030
W13 2026-08-17 $251,030 $34,642 $39,723 $245,949

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.

Model your own scenario See the prepared response

This is a worked example on sample numbers — sign up to test your own decisions against your approved forecast.

Cash composition (13-week totals)

Recurring (Stripe) 450,346
Payroll & overhead 516,397

Forecast basis · where the Base numbers come from

Opening cash $312,000 · configured bank balance · week 1 starts 2026-05-25 Example
AR collections no opening AR pool
New invoicing not modelled
Supplier payments not modelled
Scheduled one-offs 0 payments · 0 receipts in the window Example

Simplifications: downside collection haircut is the conservative default (0.70×), not derived from observed variance

Direct method: receipts = AR aging buckets × the collection curve + recurring / new-invoicing run-rate at the observed collection lag + dated one-off receipts. Payments = weekly cost run-rate + DPO-timed supplier spend + dated one-offs. A selected scenario re-times and re-sizes these streams per its drivers — it is never a statistical band.