A working sheet that writes to nothing

Short answer

On top of the real due dates you can move a date, split a payment or add a hypothetical line and see what happens to the balance. Nothing here touches invoices, customers or the bank — it is a scenario, and it is labelled as one.

muhasebe.cirometre.com/cash-plan
Cash planA working sheet on top of the real due dates — move a date, split a payment, add a hypothetical line. Nothing is written to any record.
Discard Save scenario
This screen is unofficialChanges here do not touch invoices, customer accounts, the bank or the real due-date calendar. When you pay with a bank transaction the line disappears on its own.
30 days60 days90 days180 days
USDEUR
+ Hypothetical line
Cash today$7,439.08 cash + bank
Lowest balance (actual)$12,786.00 shortfall: 4 Oct (in 0 days)
Lowest balance (scenario)$37,181.22 shortfall: 4 Oct (in 0 days)
End of period (scenario)$61,576.40 actual $53,735.06
Oct 4 – Oct 10$51,904.45 +$8,179.15 in · −$23,847.99 out
Oct 11 – Oct 17$50,073.82 +$79,960.90 · −$2,201.74
Oct 18 – Oct 24$48,243.21 +$7,813.03 · −$20,186.75
Oct 25 – Oct 31$46,412.58 +$76,299.66 · −$1,835.61
The scenario is compared against the real calendar, not instead of it.

Planning in a spreadsheet drifts from reality

A separate spreadsheet is accurate on the day it is built. A week later the invoices have moved and the plan has not.

Planning on top of the live data means the baseline is always current and only your assumptions are hypothetical.

Unofficial on purpose

A planning screen that quietly edits records is dangerous. The banner says what it is, and the scenario is shown next to the real figures rather than replacing them.

Frequently asked questions

Does the cash plan change my records?

No. It is a scenario layer; invoices, customer accounts and the bank are untouched.

Can I compare a scenario with reality?

Yes. The lowest balance and period end are shown for both.

Go deeper