Prize-Draw Cash Flow Forecaster (Excel)
See your bank balance for the next 13 weeks, including the weeks a big prize payment lands.
For UK prize-draw and competition operators. Ticket money doesn't reach you straight away: your payment provider takes its fee, may pay out a week or more later and may hold back a rolling reserve, while prizes go out in big lumps. Enter your bank balance, your provider's terms, weekly ticket sales and every payment. The forecaster shows you:
- Money in, money out and your closing bank balance for every week
- Your lowest balance and the week it comes
- The weeks you fall below your chosen cash buffer or below zero, and the extra cash you'd need to stay above the buffer
- How much of your ticket money is still with your payment provider
What's inside
- 5 sheets: Start Here, Setup, Weekly Plan, Cash Flow, Dashboard
- Payout delay (0 to 4 weeks), reserve % and reserve hold period (0 to 26 weeks) you set
- Dashboard warnings and a chart of your balance against your buffer
- A check on every input; calculation sheets protected (no password); plain-English definitions and a fictional worked example
Who built it
Ivan Soloviov, The Lottery CFO. 18 years in lottery finance. Former CFO, European national lottery operator. Earlier at IGT/GTECH.
Format
.xlsx file for Microsoft Excel on desktop. Not built for Google Sheets or Excel online. Version 1.0, November 2026. Instant download after payment.
Please note
This is a planning tool, not tax, legal or financial advice. Check your provider's actual payout and reserve terms. You enter VAT and tax payments yourself; the file does not calculate them. Results depend on the figures you enter.
Refunds: because this is an instant digital download, refunds aren’t offered once the file has been downloaded. If the file is faulty or won’t open, email ivan@thelotterycfo.com and I’ll fix it or refund you.
Rather have a person check your numbers? A Health Check of selected draws, from £495: thelotterycfo.com/health-check