Lottery management software hub
Free Scratch-off inventory spreadsheet
Copy this structure into Sheets or Excel to track book movement today. It is useful for a manual operator, but the handoff to Lottotally matters when multiple shifts, multiple books, and manager review start creating risk.
Replace the spreadsheet with Lottotally1. Datecolumn
2. Game Namecolumn
3. Book Numbercolumn
4. Face Valuecolumn
5. Starting Countcolumn
6. Activationscolumn
7. Tickets Soldcolumn
8. Ending Countcolumn
9. Expected Cashcolumn
10. Actual Cashcolumn
11. Over Shortcolumn
12. Notescolumn
| Date | Game Name | Book Number | Face Value | Starting Count | Activations | Tickets Sold | Ending Count | Expected Cash | Actual Cash | Over Short | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-05-15 | Example Game | BK-1042 | $5 | 300 | 0 | 44 | 256 | $220 | $218 | -$2 | Check shift close |
Date,Game Name,Book Number,Face Value,Starting Count,Activations,Tickets Sold,Ending Count,Expected Cash,Actual Cash,Over Short,NotesHow to use it
- Add one row per book per close day.
- Record starting and ending ticket counts before entering cash.
- Use Over Short to flag rows that need manager review.
Mistakes to watch for
- Mixing activated books with counted books.
- Typing book numbers inconsistently across shifts.
- Resolving over/short rows without a note.
Next: use the lottery reconciliation calculator or compare workflows in the Lottotally vs LottoVault guide.