Prize-Draw Management Accounts Pack (Excel)
Monthly management accounts for a prize-draw business, set against your budget.
For UK prize-draw and competition operators. Enter each month's takings, VAT, prizes, direct costs, overheads and a few activity numbers, plus your budget for the year. The pack shows you:
- A profit and loss for every month: net revenue, gross profit and operating profit
- The ratios an operator watches: prizes as % of net revenue, gross and operating margin, marketing cost per new paying customer, takings per draw, and free entries as a share of all entries
- The reporting month and the year to date against budget, with a variance and a Favourable or Adverse status on every line
- Dashboard warnings: behind budget, prizes above your warning level, margin below your target, months that made a loss
What's inside
- 7 sheets: Start Here, Setup, Actuals, Budget, Monthly P&L, Month Report, Dashboard
- Pick the reporting month (1 to 12) and every report moves with it
- A check on every input; calculation sheets protected so formulas aren't typed over by accident (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 management reporting tool, not tax, legal or financial advice, and not statutory accounts. You enter VAT and other amounts the way your bookkeeping records them; the file does not calculate VAT or tax. It does not replace your bookkeeping records or your accountant.
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