Lottery reconciliation checklist for gas stations and c-stores.

Why daily lottery reconciliation matters

Lottery is the most attribution-friendly inventory in a c-store: every ticket has a unique serial number, every pack has a sequential range, and the state commission publishes a daily settlement report. The ingredients for clean reconciliation exist by design.

What kills attribution is cadence. A pack settled at month-end with two missing serials produces a shrink number ($10 of $5 tickets) with no shift attached. The same gap caught the day it appeared has the shift, the clerk, the time of day, and (with cameras) the clip.

The 10-item daily reconciliation checklist

1. Starting pack inventory

Count packs in the dispenser, the safe, and any back-room storage. Match against yesterday's closing count. Any new packs received today should already be scanned into inventory with their serial ranges captured.

2. Activated packs

Every pack on the dispenser should be activated with the state. Sales from inactive packs don't count toward your commission; the operator absorbs them. Verify activation on every pack currently on the dispenser.

3. Sold tickets per pack

For each active pack, scanned sales should equal the pack-inventory decrement. Pack of 60 serials, 47 sold, 13 should remain. If actual remaining is 11, two serials are missing, investigate before settling the pack.

4. Paid prizes

Winning-ticket cash-outs reduce the cash drawer. Each should be logged against the redemption record. Top-tier prizes have a state validation step; track that separately from instant-win redemptions.

5. Settled packs

Only settle packs with all serials accounted for. Premature settlement is the single biggest shrink-cost mistake, once you settle, the state credits the commission and the missing tickets become your loss.

6. Lottery cash collected

Cash collected from lottery sales minus cash paid for prizes equals net cash for the lottery category. Reconcile this against your cash-drawer variance, lottery cash and store cash should net cleanly.

7. Missing tickets (serial gaps)

Any serial gap from step 3 escalates here. Each gap gets tagged with the on-shift clerk during the gap window. Pattern signals (same clerk, repeated gaps) flag for next-day owner review.

8. State-lottery terminal report

Pull the daily settlement report from the lottery terminal. Both scratcher and draw-game data should be there. This is the state's view of what you sold; compare to your tracked sales.

9. POS lottery report

Pull the POS-side lottery sales total. It should match the terminal report (within rounding). Mismatches are typically POS-vs-terminal sync issues, a ticket rung at the register that didn't make it to the terminal, or vice versa.

10. Manager signoff

The reconciled close gets manager initials. Closes that don't get signed off are reopened next morning. Treating signoff as ceremonial defeats the point; treat it as the gate.

Daily vs. weekly lottery reconciliation

Both cadences exist for a reason, but they serve different purposes and operators sometimes conflate them.

Run daily for attribution. Run weekly for rollup. Run monthly only for accounting. Don't skip daily because "we reconcile weekly", the two are not substitutes.

Example: a variance scenario

Tuesday 11 PM close. Store has 4 active packs on the dispenser:

Pack A (60 $5 tickets, activated Mon):
  expected sold = 18, actual sold = 18  ✓ balanced
Pack B (60 $5 tickets, activated Mon):
  expected sold = 22, actual sold = 24  ✗ +2 ticket variance
Pack C (30 $10 tickets, activated Tue):
  expected sold = 9, actual sold = 8    ✗ -1 ticket variance
Pack D (60 $2 tickets, activated Tue):
  expected sold = 14, actual sold = 14  ✓ balanced

Net cash from lottery: $362
Cash drawer lottery row: $352
Variance: $-10 (matches pack C exposure)

Two issues to investigate. Pack B shows two extra tickets sold than the inventory says left, most likely a POS-vs-terminal sync issue (terminal recorded the sale, the operator counted the remaining pack wrong). Pack C shows one fewer than expected, a $10 ticket missing, same as the $-10 cash variance. Cross-reference: same overnight shift, same clerk. Pattern flagged for owner review tomorrow morning.

Spreadsheet vs. software for lottery reconciliation

What to do when a serial is missing

Don't settle the pack. Open an investigation row with the missing serial, the expected dollar exposure, and the active-pack location. Cross-reference: which shifts were on the clock between the last confirmed sale of an earlier serial and the first confirmed sale of a later one. Most missing serials sit between two confirmed ones, the window narrows attribution to a specific shift or two.

Pull camera footage for the window if available. Review the redemption log: a winning ticket cashed out by the clerk after a customer left produces the same signature (no scan-sale, no inventory decrement). Most missing tickets resolve as process error within 48 hours of investigation; the residual is the actual shrink number.