lottery reconciliation software
Lottery reconciliation software with serial-gap detection.
Barcode-scan packs in and out. The system tracks every scratcher serial, flags missing tickets the moment a gap appears, and ties shrinkage back to the shift on the clock, reconciled daily against state-commission settlement reports.
Who this is for
Gas station and c-store operators with lottery licenses, single-store through multi-location, where scratcher inventory shrink is a recurring (and often unsolved) loss category.
Why the current workflow breaks.
POS lottery tracking captures sales. It doesn't capture loss.
When a clerk rings up a scratcher sale, the POS records the transaction. What the POS does not know: which specific serial activated, whether all serials from the pack made it back at end-of-day, whether the missing serial correlates with a void burst or a cash variance. The accountability layer is missing by design.
Manual reconciliation runs weekly at best, monthly at worst.
Most independent operators reconcile lottery against the state-commission report once a week or once a month. By the time a missing serial is identified, the shift attribution has degraded. Sometimes the operator gives up entirely and absorbs the shrink as a cost of doing business, typically $50–$200 per store per week.
Pack activation, settlement, and returns are three separate paper trails.
Scratcher books come from the state with paper paperwork. Activation, settlement, and return forms live in separate folders. Cross-referencing them at quarter-end takes hours. If a clerk skipped a settlement form, the reconciliation breaks silently.
The workflow
How it actually runs.
The same sequence on every store, every shift: pre-populated where possible, with attribution baked in.
- 01
Pack arrives. Scanned into inventory.
Clerk scans the pack barcode at receipt. Serial range, game, price point, and activation date all capture automatically. No paper paperwork to file.
- 02
Pack activates. Scanned into active inventory.
When a pack moves to the dispenser, the clerk scans it. Serial range and activation timestamp record. The pack now exists in the active-inventory ledger.
- 03
Sales scan against active inventory.
Each scratcher sale rings against a specific serial. The system knows exactly which serials have sold and which remain in the active pack.
- 04
Serial gaps flag in real time.
When serial #023 sells but #024 is missing without sale (and #025 is still in the pack), that's a gap. Flagged immediately with the on-shift clerk attached and the dollar exposure computed.
- 05
Daily reconciliation against the state commission.
Overnight, the CA Lottery (or NY, TX, FL, PA, IL) settlement report ingests. StationPro's tracked sales reconcile against the commission's record. Mismatches surface with the underlying serial-level detail.
- 06
Quarter-end commission filing exports ready.
The state-commission filing pack is generated from the underlying transactions. The reconciliation work that used to take a weekend takes 20 minutes of review.
Who uses this, and how.
Single-store independent with lottery shrink suspicion.
You're sure the lottery is leaking but you can't prove which shift. Within 30 days of going live, the pattern surfaces: which clerks, which times of day, what dollar exposure per week.
Multi-store operator comparing lottery performance.
Portfolio view shows lottery velocity per store, missing-ticket frequency per store, shift-attribution patterns across stores. The "is it just this store" question gets a real answer.
Operator filing CA Lottery quarterly reports.
The filing pack generates from the underlying transactions, reconciled against the commission's settlement records. Twenty minutes of review replaces a weekend.
New operator getting onboard with state lottery.
The accountability layer prevents the year-one mistakes most operators make, packs activated but never tracked, returns submitted late, settlement reports never reconciled.
Side by side
StationPro vs. manual lottery workflow.
| Dimension | StationPro | Manual lottery workflow |
|---|---|---|
| Serial-level tracking | Yes, every serial scanned | Pack-level only |
| Missing-ticket detection | Real-time, with shift attribution | Weekly or monthly reconciliation |
| State-commission reconciliation | Nightly, automatic | Manual review at quarter-end |
| Shift attribution | Per missing serial | Usually impossible to determine |
| Hardware required | Phone or tablet (camera) | Manual count and paper logs |
| Quarter-end filing prep | ≈20 minutes review | Weekend spreadsheet rebuild |
| States supported | CA, NY, TX, FL, PA, IL, more on req | Whatever the operator builds |
Questions, answered.
How does serial-gap detection actually work?
Every scratcher pack is a sequential range of serials. As tickets sell, StationPro tracks which serials sold and which remain. When serial #023 sells but #024 disappears without a sale (and #025 still exists in the active pack), that's a gap, flagged with the clerk on shift at the moment the gap appears, plus the dollar exposure.
Which state lotteries do you support?
California (CDLC), New York, Texas, Florida, Pennsylvania, and Illinois have full nightly reconciliation against state-commission settlement reports. Other states are supported at the data and tracking layer; commission-report ingestion gets added by request on a per-state basis.
Do I need a dedicated barcode scanner?
No. Any phone or tablet camera works. A dedicated USB barcode scanner ($40 range) speeds up the in/out workflow for high-volume stores but isn't required. Most operators run with a tablet at the lottery counter.
What if my POS already tracks lottery?
POS lottery tracking captures sales, that's real, but it's not the accountability layer. We work alongside the POS: it handles the transaction, we handle serial-level tracking, shift attribution, and commission reconciliation. The two systems complement.
How much shrink do operators usually find?
Pilot data ranges from $50/week (well-managed single store) to $400+/week (multi-store operator with previously undetected pattern). The median is roughly $150/week per store of recovered or prevented lottery shrink in the first 90 days.
Will this accuse a clerk of theft?
No. Every missing serial surfaces as a variance with shift attribution, not an accusation. The dashboard shows who was on shift and the dollar exposure; the operator decides whether it's training, error, or something else.
Keep reading.
Related features
Tools and templates
From the blog
Loss attribution beats theft prevention.
Why the goal isn't to stop shrinkage at an independent station, it's to know who, when, and how. A field guide to building an attribution system instead of a security one.
The lottery shrinkage playbook.
How to instrument scratcher accountability across barcode scanning, serial-gap detection, and shift attribution. The four-week sprint that closes the leak.
See where your station is leaking money.
A 30-minute call. We build the demo around your stations, not a generic deck.