Payment Processing Cost Calculator (Excel)
Compare what payment providers really cost your draws: not just the headline %, but fixed fees, chargeback fees, monthly fees and cash held back in reserve.
You enter your monthly sales and the terms from up to three provider quotes. The calculator shows, for each one:
• total cost per month and per year
• cost per ticket, and as a % of takings
• cash tied up in a rolling reserve
• which provider is cheapest, and how much you'd save a year compared with the most expensive
A basket-size table shows why single-ticket payments cost you more and how bundles spread the fixed fee. Example providers are fictional: you enter the terms from your own quotes.
Built by Ivan Soloviov, The Lottery CFO. 18 years in lottery finance. Former CFO, European national lottery operator. Earlier at IGT/GTECH.
Format: .xlsx for Microsoft Excel desktop. Not built for Google Sheets or Excel online.
Please note: a planning tool, not financial advice. Rates vary by card type and volume; use your own written quotes.
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