Benchcraft / Finance desk
Reconciliation   /   Service business finance lead

Receipts Scenario

Build a weighted receipt scenario from balances, expected timing and an owner-supplied probability.

01 / Inputs

Working sheet

Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.

ReferenceOpen EURExpected dateReceipt probability %Row
02 / Review

Decision sheet

MonthItemsGross openWeighted
2026-111€900.00€720.00
2026-121€400.00€200.00
How the rule works

Weights are assumptions, not guaranteed collections. Dates place amounts into expected calendar months.

Read the worked example