Daily lottery reconciliation calculator
Check cash and inventory differences separately using one day of gross lottery sales, payouts, cancellations, and book movements. Print or download your result, then keep your totals for a first close.
LottoTally lottery close worksheet
Start with one business date
All amounts are in USD. Inventory movements use total ticket face value, not ticket or book counts. For example, 40 tickets at $5 are $200 of inventory.
Use gross sales and subtract cancellations once. Enter 0 where nothing occurred. Count only lottery cash collected, excluding opening float and unrelated store sales.
Your worksheet result
Complete the date and every amount to calculate. Correct invalid entries before printing, downloading, or keeping totals.
This is a worksheet, not a saved LottoTally close or an import file. Keep this result for its cash and inventory checks.
Bring these totals into your first close
Keep the date, sales, payouts, and cancellations in this browser tab for up to two hours. After signup or login, review them in Daily Close and add your POS and commission figures. Cash and inventory checks remain in this worksheet.
No close is saved until you choose to save it in your account. Your first paid Starter subscription has a separate 14-day trial at checkout; a card is required.
Formula
Expected cash equals terminal gross sales plus scratch-off gross sales, minus payouts and cancellations. Terminal sales must exclude scratch-off sales so they are not counted twice. Inventory-implied scratch sales equals starting inventory plus activations, minus returns and ending inventory, all at ticket face value in dollars. Review cash over/short and inventory variance separately; opposite differences never cancel each other.
Use gross sales in this worksheet. If your source already deducts cancellations, do not subtract them again. This cash check assumes cash lottery transactions; reconcile card or other non-cash payments separately.
Common mismatch causes
- Terminal report totals copied from the wrong close date.
- Payouts entered in POS but not subtracted from the close.
- Activated scratch books counted as sold inventory.
- Cash corrections made without a manager note.
Use the calculator's keep-totals button above to carry your own entries into signup. Creating an account is free; the first Starter subscription trial begins separately at checkout with a card.
Create a free account without copying totals