How to reconcile scratch-off lottery at the end of the day
Scratch-off lottery is the line on a convenience store's day that goes wrong most quietly. The tickets are cash, the packs are sold by a clerk under pressure, and the state bills the store whether or not every ticket was rung. A store that does not reconcile lottery every day finds out about the problem on the weekly sweep, when the money has already left the account.
This guide is the daily routine that catches it the same night. It takes about ten minutes for a store with twenty active packs, and it works the same way whether the counting is done on paper, in a spreadsheet, or in a point of sale that does the arithmetic.
What you are reconciling, and why the state does not do it for you
Instant tickets arrive in packs. Each pack carries a game number, a pack number, a fixed number of tickets, and one price for every ticket in it. Before a single ticket can be sold or cashed, the pack is activated at the state lottery terminal. From that moment the state considers the pack yours, and in most states it will be billed on the next settlement whether the tickets are sold, lost, or still in the case.
The state terminal knows which packs were activated, which were settled, which winners were cashed, and what the draw games sold. It does not know how many individual scratch tickets left the counter today. Only two things know that: the physical count of what is left in each pack, and the register's record of what was rung. Reconciliation is the act of making those two agree.
Step 1. Fix the starting number for every active pack
Every pack in the display has a next ticket showing. Write down that ticket number for every active pack at the start of the day, or carry forward last night's ending number, which should be the same. If it is not the same, that is the first finding of the day: a ticket was sold or removed between the close and the open, and it is easier to ask about at 7 AM than at 10 PM.
Record the game, the pack number, the ticket price, and the starting ticket number on one line per pack. A pack that was activated today starts at its first ticket, and a pack that ran out during the day is closed out with its last ticket.
Step 2. Read the ending number at close
At the end of the day, read the ticket now showing in each pack and write it on the same line. Read it from the ticket, not from memory, and read every pack, including the ones nobody thinks sold today. The packs that "did not sell" are where the unrecorded sales hide.
- Count in the same order every day, left to right, top to bottom, so a skipped pack is obvious.
- One person reads, another writes, when two people are on. A single clerk should photograph the display as a backup.
- A pack that sold out is marked depleted with its last ticket number and comes off tomorrow's list.
Step 3. Turn the difference into dollars
Tickets sold from a pack is the difference between the ending number and the starting number. Multiply by the ticket price and you have the expected instant sales for that pack. Add the packs up and you have the expected instant sales for the day.
A worked example. A $5 game sold in packs of 60 showed ticket 012 at open and ticket 037 at close. That is 25 tickets sold, and 25 times $5 is $125 from that pack. A $20 game showed 004 at open and 004 at close: nothing sold, and that pack contributes $0 whatever the clerk remembers. Do this for every pack; a store with twenty active packs has twenty lines and one total.
Direction matters. Some states dispense from the low number up and some from the high number down. The count is the difference either way, but the sheet should say which, and it should not change from day to day.
Step 4. Match it to the register
Pull the day's lottery sales from the point of sale. This is the total the cashiers actually rang as instant tickets, and it is the number the drawer was counted against. Set it beside the expected total from the packs. If the two agree to the dollar, the day is closed. If they do not, the gap is the variance, and it has a short list of causes.
- A ticket rung under the wrong game or price, which shows as a matching over on one pack and under on another.
- A pack replaced mid-shift without a line on the sheet, so its opening number was never recorded.
- Free-ticket prizes dispensed to a winner but never rung, which the state still counts as a ticket gone.
- Tickets taken and not rung at all, which is the one this routine exists to find early.
Step 5. Account for payouts and the drawer
Winning tickets cashed at the counter come out of the same drawer the sales went into. The lottery terminal's daily report lists every validation paid, and the register should carry each one as a lottery payout. Lottery cash in the drawer at close is instant sales plus draw-game sales, minus payouts. Reconcile that figure to the physical drawer count separately from the ticket count above, because a payout error and a ticket error look the same in the drawer and completely different on the pack sheet.
Step 6. Keep the weekly settlement honest
Once a week the state sweeps the account. The invoice is built from packs settled, draw-game sales, and cashed prizes, less the store's commission, which in most states is a flat percentage set for the retailer, not per game. If the daily sheets were kept, the weekly number should be predictable to the dollar before the invoice arrives. If it surprises anyone, the daily routine has a hole in it, usually a pack that was activated and never put on the sheet.
Keep lottery out of the store's sales figure. Instant and draw tickets are sold on the state's behalf; the store's income is the commission and the cashing bonus, not the ticket price. A daily report that adds $2,000 of lottery to $4,000 of merchandise is overstating the day by a third.
How Storeveu does this
Storeveu keeps the pack sheet for you. Each pack is a box with a game, a price, an activation date and a starting ticket, and the register sells against it at the state's price, which a cashier cannot change. At shift close the operator enters the ending ticket for every active box, or scans it, and the register computes tickets sold and the expected dollars, compares them to what was rung, and shows the variance by pack. A store can require the scan before a shift is allowed to close, restrict lottery to cash, and see the week's settlement built from the same boxes with the store's own commission rate applied.
Games are loaded per state, so a store in Maine, New Hampshire or Washington sees its own catalog and nothing else, and lottery stays out of the business sales total by design.
Questions operators ask
How often should lottery be counted?
Every day, at close, and at every shift change where the drawer changes hands. A daily count finds a problem the same night; a weekly count finds it after the money has already gone out on the sweep.
What if the pack count and the register disagree?
Find the pack with the gap first, not the total. Check whether a ticket was rung under a different game, whether a pack was swapped without a line on the sheet, and whether a free-ticket prize was dispensed and not rung. If nothing explains it, the gap is a missing sale, and the shift it happened on is on the sheet.
Do draw games need the same count?
No. Draw-game sales, cancels and payouts come from the lottery terminal's daily report, which is authoritative. Reconcile that report to what the register rang as draw sales, and treat the physical count as an instant-ticket exercise only.
Should lottery sales be in my daily sales total?
No. Tickets are sold on the state's behalf. The store's income is the commission and any cashing bonus. Report lottery on its own line so the merchandise number and the lottery number can each be checked against their own source.