Your Cart
Loading

Prize-Draw Cash Flow Forecaster (Excel)

On Sale
£39.00
£39.00
Added to cart

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

You will get a XLSX (20KB) file