A lottery inventory spreadsheet has exactly one job: prove that the tickets left in your racks match what the terminal says you should have. Most sheets fail because they track packs received and packs sold, and never reconcile against the terminal’s own settlement report. That gap is where the money goes.
The columns a lottery inventory spreadsheet needs
Fewer than most people build, and different ones. Here is the working set.
| Column | Why it earns its place |
|---|---|
| Game number and name | Two games can share a price point and get confused at the rack |
| Pack number | The unit the commission settles on, so it is the unit you count |
| Price point | Lets you value the rack without a lookup |
| Date activated | Old open packs are the most common source of a false count |
| Ticket number at shift start | The number that makes the count possible at all |
| Ticket number at shift end | Same |
| Rack or bin position | So a missing pack has a place it should have been |
| Person on shift | Not to blame anyone, to narrow where a routine broke |
What you do not need is a running dollar total per game calculated by hand. Let the sheet do it from the ticket numbers and the price point, or it will be wrong within a week.
The shift routine that makes it balance
Two minutes at open and two at close, done the same way every time. Read the current ticket number on every open pack, top to bottom in rack order, and write it down before anything is sold. At close, do the same walk in the same order.
The order matters more than it sounds. A clerk who walks the racks in a fixed sequence notices a gap. A clerk who reads them in whatever order catches the eye does not, and a missing pack can sit unnoticed for days.
Then compare the sheet against the terminal report for the same period. A difference on one game is usually a pack activated but not entered. A difference across several games in the same direction is usually a shift where nobody did the walk.
What the spreadsheet cannot tell you
It cannot tell you what you earn. Commission and any bonus structure are set by your state’s lottery, they vary between states and they change, so the only correct source is your own commission’s published retailer material. Do not let a sheet template that came from somewhere else carry a rate you never verified.
It also cannot see the till. A lottery sheet that balances perfectly while the cash drawer runs short every Friday has told you the tickets are fine and nothing else. Those are two separate reconciliations and they need to stay separate.
The point where a sheet stops working
Three signs, and any one of them is enough. You are running more than one store and consolidating sheets by hand. Your racks hold enough games that the open pack walk takes longer than the queue allows. Or nobody has actually completed the sheet for a week and you only find out during a settlement dispute.
At that point the sheet is not the tool any more. Ticket numbers read by the terminal, activation recorded automatically, and a variance report you can open on your phone will do in seconds what the walk does in minutes. That is what our lottery integration page covers, and the register side of it sits on our convenience store POS page.
Keeping the sheet honest until then
If you are staying on a spreadsheet, protect it like a cash register. One person owns the master file. Nobody edits history, corrections go in as a new dated row with a note. Back it up somewhere that is not the counter computer.
And count the closed packs too, not just the open ones. Full packs sitting in the drawer are worth real money and they are the easiest thing in the store to forget. The same discipline applies to every other count you run, which is the argument made in liquor store inventory software and what a count really costs. If the counting itself has got away from you, our inventory management page is the wider picture, and you can describe your rack setup to us if you want a second read.
Frequently asked questions
How often should the racks be counted? Every shift change, at minimum. Lottery is the one category where a daily count is genuinely worth the time, because a discrepancy found the same day can still be traced to a person and a routine.
Should I count full packs in the back as well? Yes, weekly. Unactivated packs are inventory you have accepted responsibility for, and they are the quietest place for stock to go missing because nothing on the terminal moves when they do.
Why does my sheet disagree with the terminal by one pack? Almost always a pack activated at the terminal but never entered on the sheet, or entered twice. Check the activation dates first, before you assume anything worse.
Can I use a template I found online? As a starting structure, yes. Delete any commission percentages, payout figures or settlement dates it came with. Those are set by your own state lottery and a stale number in a template will quietly make every total wrong.
Who should hold the master sheet? One named person, with everyone else working from a printed shift slip they hand in. Shared editing is how a lottery sheet quietly loses a week of history, and nobody notices until a settlement is disputed.
Does a POS with lottery integration remove the count entirely? It removes the manual reading and the arithmetic, which is most of the work. You still want eyes on the racks, because software cannot see an empty bin.