Draw Cost Tracker and Budget Controller (Excel)
Keep every cost of a draw in one place and see which budget lines are over, or close to it.
For UK prize-draw and competition operators. Set a budget for up to ten cost categories, then log each invoice, order or payment as Paid or Committed. The tracker shows you:
- Paid, committed and left in budget for every category
- Which categories are over budget or close to their limit
- Your result so far: net ticket income against everything paid and committed
- Break-even tickets (on the budget or actual cost, whichever is higher), and how many more you need to sell
- The forecast result if the draw sells out
What's inside
- 5 sheets: Start Here, Budget, Cost Log (200 lines), Budget vs Actual, Dashboard
- Category and Paid/Committed dropdowns, with a check on every log line
- A VAT assumption for ticket income (none, 20%, or your own rate) and a payment fee %
- Dashboard warnings and a chart of the share of each budget used
- 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 and record-keeping tool, not tax, legal or financial advice. The VAT setting is a modelling choice only and does not say which treatment applies to you. It does not replace your bookkeeping records.
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