Lottery Inventory

Lottery Inventory

A live, read-only snapshot of every lottery pack at one store — what's in the bins (sellable), what's in the safe (not sellable), and what each is worth. This is your audit tool: it answers the questions "how many packs do we have right now?" and "how much lottery inventory is on hand?" without having to walk the dispenser.

Open the screen: Lottery → Lottery Inventory in the left navigation.


When to use this screen

  • The end-of-month inventory count
  • Spot-checking after a busy day — "did we run out of any games?"
  • Cross-referencing the lottery commission portal's count of activated packs vs. yours
  • Before running Day Close — verify your bin count matches the physical dispenser

Screen at a glance

Lottery Inventory screen

Area What it does
Store Location (top-right) Pick the store. Inventory is per-store.
Bins / Safe tabs (top-left) Toggle between the two locations. Each tab shows its own count.
Packs in Bins / Total Value cards Summary of the currently-visible tab
Active Packs / Inactive Packs grid The per-pack detail
Search packs Filter the grid by game number, pack number, or game name
End of Day Reconciliation banner A shortcut to Day Close at the bottom

Tab: Bins (Active packs)

Shows every pack with a bin number greater than zero — that is, every pack currently sellable on the counter.

Columns

Column Meaning
Bin # Physical dispenser slot number
Game # lottery game ID
Game Name Friendly name from the game master
Pack # Pack identifier (length depends on your state)
Ticket $ Price per ticket — from the game definition
Pack Value Tickets × Ticket $ — original face value of the full pack
Sold Qty How many tickets in this pack have been sold (last known from Day Close)
Sold Amt Sold Qty × Ticket $ — dollar value of sales from this pack

Example values from a sample store

Bin Game # Game Name Pack # Ticket $ Pack Value Sold Qty Sold Amt
2 1365 10x -$1 106746 $1.00 $300.00 88 $88.00
7 1371 Stacks of green -$2 107547 $2.00 $300.00 0 $0.00
8 1366 20x -$2 108143 $2.00 $300.00 20 $40.00
3 1356 $50 frenzy 109798 $1.00 $300.00 42 $42.00
4 1336 Supreme Jumbo Bucks -$1 109798 $1.00 $300.00 131 $131.00
14 1367 30x Cash Word 110539 $3.00 $300.00 18 $54.00
6 1357 $100 Frenzy -$2 110662 $2.00 $300.00 14 $28.00
18 1858 Giant Jumbo Bucks Crossword 115362 $5.00 $300.00 3 $15.00

The Total Value card sums the Pack Value column. The Packs in Bins card counts the rows.


Tab: Safe (Confirmed + Inactive packs)

Shows every pack with no bin assigned. Two kinds of pack appear here, both side-by-side:

Status badge What it means
Confirmed (not activated) Newly received from a shipment, never been on the counter
Inactivated Was on the counter, you pulled it off via Inactivate Pack

The grid columns are the same as the Bins tab, except there is no Bin # column (there is no bin), and Sold Qty is whatever the pack had when it was last on the counter (zero if it was never activated).


Summary cards

Card Math What to verify
Packs in Bins (top header) Count of active packs Should equal the physical number of full slots in your dispenser
Safe (top header) Count of safe packs Should equal the boxes / pallets in back-office storage
Packs in Bins (main card) Same as above, larger Quick eye-check
Total Value (main card) Sum of Pack Value of currently-visible tab Dollar value of inventory in that location

Note: Total Value is the face value of the full pack as received, not the value of unsold tickets remaining. If you need remaining value, subtract Sold Amt from Pack Value — that's the dollar amount of unsold tickets still in the pack.


Filtering the grid

The Search packs box at the top of the grid filters live as you type, across:

  • Game number (e.g., 1996)
  • Pack number (e.g., 548394)
  • Game name (e.g., Giant Jumbo Bucks)

Clear the search box to see the full list again.


Common audits this screen is for

"How many active packs do we have?"

Switch to the Bins tab. Read the count next to Packs in Bins.

"What's our total lottery inventory on hand?"

The combined face value = (Bins tab Total Value) + (Safe tab Total Value). Look at both tabs.

"Why isn't game 1996 selling?"

Type 1996 in Search packs. Look at the Sold Qty column. If it's zero, that pack hasn't sold any tickets since it was activated.

"Which bins are empty?"

Lottery Inventory doesn't directly show empty bins — only filled ones. To find empties, compare the Bin # values in the grid against the bin numbers physically present on your dispenser. Any number that's missing from the grid is an empty slot.

"Did the count from the lottery commission's portal match ours?"

Their Activated Packs report should match the Packs in Bins count here for the same store and date. If it doesn't, run the Activation Report for the relevant date range to see every activation event.


What CStoreiQ does NOT show on this screen

  • Sold-out packs. Once a pack's ticketNo hits the maximum, it stays in the bin (showing Sold Qty = max) until you inactivate or return it. To find sold-out packs specifically, look for rows where Sold Qty = Tickets per pack.
  • Returned packs. Those are out of inventory — see the Recently Returned Packs list on Return Pack.

Related articles

    • Related Articles

    • Lottery Dashboard

      A single-screen overview of where the lottery operation stands right now at one store: today's sales, today's payouts, how many packs are active, what needs your attention, and one-click access to every action in the module. Open this first thing in ...
    • Reports: Purchase, Sales & Inventory

      Reports CStoreIQ's Reports module is your central hub for generating detailed financial and operational reports across all your stores. It covers purchases, sales, inventory, fuel, and accounting data, giving you the insights you need to make ...
    • How to View and Manage Current Inventory

      Managing and understanding your current inventory is essential for tracking stock levels and making informed decisions. Here's a simple guide to help you view and manage inventory effectively: Step 1: Log into the System Log in to your account using ...
    • Managing Parent-Child Relationships in Inventory Management

      Parent-child relationships in inventory management are essential for maintaining an accurate overview of stock. These relationships link items (like cartons and packs) to ensure proper tracking and depletion of inventory. Without such relationships, ...
    • How to Add Stock Transactions for Inventory Management?

      The "Stock Transaction" feature enables meticulous management and monitoring of inventory changes, catering to a variety of stock movements such as physical counts, adjustments, transfers, spoilage, and internal usage. Process for Adding Stock ...