Ataski
Sign up
Sample workspace — example data, not your own. Sign up free to run it on your own.
Ataski Financial Analyst
Example Ask the analyst
✦ 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 Scenario changes pinned to Forecast · April close · v1

Opening cash

$918,000

Week 13 · Base

$924,332

Week 13 · Scenario

$1,036,198

+$111,866

Minimum cash · Scenario

$529,169

W6 · 2026-06-29 · No breach in 13 weeks

Weekly ending cash — Base vs Scenario
$477,538 $713,245 $948,952 $1,184,659 $1,420,366 2026-04-13 — Actual $1,375,261 · Base $1,420,366 · Δ −$45,105 2026-04-20 — Actual $1,256,746 · Base $1,346,955 · Δ −$90,209 2026-04-27 — Actual $1,138,231 · Base $1,273,545 · Δ −$135,314 2026-05-04 — Actual $1,064,821 · Base $1,200,135 · Δ −$135,314 2026-05-11 — Actual $991,410 · Base $1,126,725 · Δ −$135,314 2026-05-18 — Actual $918,000 · Base $1,053,314 · not reconciled yet −$135,314 W1 · 2026-05-25 — Base $844,590 · Scenario $853,195 · Δ +$8,605 · net −$73,410 W1 · 2026-05-25 — Base $844,590 · Scenario $853,195 · Δ +$8,605 · net −$73,410 W1 · 2026-05-25 — Base $844,590 · Scenario $853,195 · Δ +$8,605 · net −$73,410 W2 · 2026-06-01 — Base $771,179 · Scenario $788,390 · Δ +$17,210 · net −$73,410 W2 · 2026-06-01 — Base $771,179 · Scenario $788,390 · Δ +$17,210 · net −$73,410 W2 · 2026-06-01 — Base $771,179 · Scenario $788,390 · Δ +$17,210 · net −$73,410 W3 · 2026-06-08 — Base $697,769 · Scenario $723,584 · Δ +$25,815 · net −$73,410 W3 · 2026-06-08 — Base $697,769 · Scenario $723,584 · Δ +$25,815 · net −$73,410 W3 · 2026-06-08 — Base $697,769 · Scenario $723,584 · Δ +$25,815 · net −$73,410 W4 · 2026-06-15 — Base $624,359 · Scenario $658,779 · Δ +$34,420 · net −$73,410 W4 · 2026-06-15 — Base $624,359 · Scenario $658,779 · Δ +$34,420 · net −$73,410 W4 · 2026-06-15 — Base $624,359 · Scenario $658,779 · Δ +$34,420 · net −$73,410 W5 · 2026-06-22 — Base $550,948 · Scenario $593,974 · Δ +$43,025 · net −$73,410 W5 · 2026-06-22 — Base $550,948 · Scenario $593,974 · Δ +$43,025 · net −$73,410 W5 · 2026-06-22 — Base $550,948 · Scenario $593,974 · Δ +$43,025 · net −$73,410 W6 · 2026-06-29 — Base $477,538 · Scenario $529,169 · Δ +$51,630 · net −$73,410 W6 · 2026-06-29 — Base $477,538 · Scenario $529,169 · Δ +$51,630 · net −$73,410 W6 · 2026-06-29 — Base $477,538 · Scenario $529,169 · Δ +$51,630 · net −$73,410 W7 · 2026-07-06 — Base $510,794 · Scenario $571,030 · Δ +$60,236 · net +$33,256 W7 · 2026-07-06 — Base $510,794 · Scenario $571,030 · Δ +$60,236 · net +$33,256 W7 · 2026-07-06 — Base $510,794 · Scenario $571,030 · Δ +$60,236 · net +$33,256 W8 · 2026-07-13 — Base $544,051 · Scenario $612,891 · Δ +$68,841 · net +$33,256 W8 · 2026-07-13 — Base $544,051 · Scenario $612,891 · Δ +$68,841 · net +$33,256 W8 · 2026-07-13 — Base $544,051 · Scenario $612,891 · Δ +$68,841 · net +$33,256 W9 · 2026-07-20 — Base $577,307 · Scenario $654,753 · Δ +$77,446 · net +$33,256 W9 · 2026-07-20 — Base $577,307 · Scenario $654,753 · Δ +$77,446 · net +$33,256 W9 · 2026-07-20 — Base $577,307 · Scenario $654,753 · Δ +$77,446 · net +$33,256 W10 · 2026-07-27 — Base $610,563 · Scenario $696,614 · Δ +$86,051 · net +$33,256 W10 · 2026-07-27 — Base $610,563 · Scenario $696,614 · Δ +$86,051 · net +$33,256 W10 · 2026-07-27 — Base $610,563 · Scenario $696,614 · Δ +$86,051 · net +$33,256 W11 · 2026-08-03 — Base $857,820 · Scenario $952,476 · Δ +$94,656 · net +$247,256 W11 · 2026-08-03 — Base $857,820 · Scenario $952,476 · Δ +$94,656 · net +$247,256 W11 · 2026-08-03 — Base $857,820 · Scenario $952,476 · Δ +$94,656 · net +$247,256 W12 · 2026-08-10 — Base $891,076 · Scenario $994,337 · Δ +$103,261 · net +$33,256 W12 · 2026-08-10 — Base $891,076 · Scenario $994,337 · Δ +$103,261 · net +$33,256 W12 · 2026-08-10 — Base $891,076 · Scenario $994,337 · Δ +$103,261 · net +$33,256 W13 · 2026-08-17 — Base $924,332 · Scenario $1,036,198 · Δ +$111,866 · net +$33,256 W13 · 2026-08-17 — Base $924,332 · Scenario $1,036,198 · Δ +$111,866 · net +$33,256 W13 · 2026-08-17 — Base $924,332 · Scenario $1,036,198 · Δ +$111,866 · net +$33,256 $844,590 $924,332 $1,036,198 net / wk W1 W3 W5 W7 W9 W11 W13
Base (current forecast) Scenario Weekly net · receipts − payments Actual

Forecast vs what actually happened

Accuracy over the last 5 weeks: ±8.5%

Last reconciled week: −$135,314 against the forecast

Collections came in $115,017 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

  • Monthly overhead (non-payroll operating costs): $248,400 → $211,140 — Applied as a weekly run-rate delta of $8,605 from week 1
  • Revenue growth / project volume (monthly): 0% → 2% — Invoicing changes inside the horizon, but with the 8-week collection lag none of the incremental receipts arrive within 13 weeks

Timing assumptions

  • Overhead changes apply from week 1 at a weekly run-rate.
  • New invoicing converts to cash after the observed 8-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,420,366 $1,375,261 −$45,105 — —
happened 2026-04-20 — — — $1,346,955 $1,256,746 −$90,209 — —
happened 2026-04-27 — — — $1,273,545 $1,138,231 −$135,314 — —
happened 2026-05-04 — — — $1,200,135 $1,064,821 −$135,314 — —
happened 2026-05-11 — — — $1,126,725 $991,410 −$135,314 — —
happened 2026-05-18 — — — $1,053,314 $918,000 not reconciled yet — —
W1 2026-05-25 $918,000 $503,464 $576,875 $844,590 — — $853,195 +$8,605
W2 2026-06-01 $844,590 $503,464 $576,875 $771,179 — — $788,390 +$17,210
W3 2026-06-08 $771,179 $503,464 $576,875 $697,769 — — $723,584 +$25,815
W4 2026-06-15 $697,769 $503,464 $576,875 $624,359 — — $658,779 +$34,420
W5 2026-06-22 $624,359 $503,464 $576,875 $550,948 — — $593,974 +$43,025
W6 2026-06-29 $550,948 $503,464 $576,875 $477,538 — — $529,169 +$51,630
W7 2026-07-06 $477,538 $503,464 $470,208 $510,794 — — $571,030 +$60,236
W8 2026-07-13 $510,794 $503,464 $470,208 $544,051 — — $612,891 +$68,841
W9 2026-07-20 $544,051 $503,464 $470,208 $577,307 — — $654,753 +$77,446
W10 2026-07-27 $577,307 $503,464 $470,208 $610,563 — — $696,614 +$86,051
W11 2026-08-03 $610,563 $717,464 $470,208 $857,820 — — $952,476 +$94,656
W12 2026-08-10 $857,820 $503,464 $470,208 $891,076 — — $994,337 +$103,261
W13 2026-08-17 $891,076 $503,464 $470,208 $924,332 — — $1,036,198 +$111,866

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

Where cash comes from +$6,759,035
New invoicing taken from the Plan
$2,180,000/month · collected after 8 wk sample data
+$6,545,035
One-off receipts sample data
1 scheduled
+$214,000
Where cash goes −$6,752,702
Operating costs taken from the Plan
$248,400/month · no lag taken from the Plan
−$745,774
Supplier payments taken from the Plan
$1,787,600/month · paid after 6 wk sample data
−$6,006,928
Starting point $918,000
Opening cash sample data
balance the forecast starts from on 2026-05-25
+$918,000

Opening $918,000 + net +$6,332 = week 13 $924,332

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.
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.

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.

How forecast accuracy is scored → · Reference →