Weekly Settlement

Weekly Settlement

A read-and-review screen that shows the EFT amount the lottery commission will sweep from (or deposit to) your bank account each week. It rolls up seven daily closes into a single Total Net Due number and a single Due Date for each week of the month.

Weekly Settlement is not where money moves. The actual EFT happens on the lottery commission's side; this screen is your preview, your audit trail, and (in edit mode) your chance to adjust individual lines before the EFT runs.

Open the screen: Lottery → Weekly Settlement in the left navigation.


When to use this screen

  • Each settlement morning, review the prior week's settlement to verify the EFT amount you expect to see hit your bank
  • After running a Day Close to confirm it rolled into the right week
  • When the lottery commission calls you about a discrepancy on a past week's invoice
  • To compare your records to the lottery commission's printed Weekly Settlement Invoice
  • When you're ready to mark recently-activated packs as settled for the current week

Screen at a glance

Area What it does
Store Location (top) Pick the store
Year navigator + Month tabs Move through historical weeks
+ Add Settlement (top-right) Create a settlement week manually for the rare case CStoreiQ didn't auto-create one (see "+ Add Settlement" below)
Week cards One card per week within the month — shows date range, due date, and Total Due
Online Due / Instant Due breakdown Side-by-side ledger inside each week card
Edit button (per week) Open the week for line-by-line adjustment

Reading a Week card

Each week card shows the same information. For example, a week card for Week 1, May 4 – May 10, settling on May 11, shows:

  • A header with the week number, date range, due date, and total dollar amount
  • Online Due — your draw-style lottery total for the week
  • Instant Due — your scratch-off total for the week
  • An Edit button to adjust individual line values

Both Online Due and Instant Due expand into the line items below.

Element Meaning
Week # Position in the month (1, 2, 3, etc.)
Date range The 7-day window the settlement covers
DUE date When the EFT will sweep — determined by your store's EFT Day of Week setting (configured per store)
Top-right dollar amount Total Due = Online Due + Instant Due. + means the lottery commission owes you, means you owe the lottery commission.
Online Due All draw-style lottery activity rolled up. Click the small expand arrow to show/hide the line breakdown.
Instant Due All scratch-off / instant activity rolled up.
Edit button Opens line-by-line edit mode — see below.

Online Due lines

Where every line comes from:

Line Source
Sales Sum of Online Gross Sales across the week's day-closes
Cancels Sum of Online Cancels
Sales Commission Sum of Online Sales Commission (computed by Day Close)
Pays Sum of Online Pays/Cashes
Coupons Sum of Online Coupon Cash
Cashing Commission If your terminal pays a cash commission separate from sales commission, it appears here
Discounts Sum of Online Discounts
Service Charge Any lottery service charge for that week
Adjustments Manual overrides applied by store manager or lottery commission

Instant Due lines

Line Source
Settled Total face value of packs you've marked settled for this week (see "Settled" vs "Unsettled" below)
Unsettled Total face value of packs activated at this store but not yet marked settled
Return Sum of returns reported via Return Pack
Sales Commission Computed = Settled × commission rate
Pays Sum of Instant Pays/Cashes
Cashing Commission If applicable
Adjustments Manual overrides

The little arrow icon to the left of each amount opens a drill-down popup showing every day-close that contributed to the line.


Real lottery commission example — what to expect

Here is what a real lottery commission Weekly Settlement Invoice looks like (for a sample retailer, week ending Sat Dec 13, swept Tue Dec 16):

Lottery commission Weekly Settlement Invoice

The same data as text so you can map each line to a CStoreiQ field:

  DRAW-STYLE SUMMARY        INSTANT SUMMARY
  440 SALES     839.50     26 SETTLEMENTS  9,300.00
   0 CANCELS     0.00    459 CASHES    7,729.00-
   0 FREE TICKETS  0.00     0 INSTANT PROMO   0.00
   0 FREE PROMO   0.00       RETURNS     0.00
   0 DISCOUNTS    0.00       SALES COMM   604.50-
    NET SALES   839.50+      NET INSTANT  966.50+
  12 CASHES    309.00-
    SALES COMM   54.45-    ADJUSTMENTS     0.00
    CASH COMM    2.90-    SERVICE FEE     0.00
    NET DRAW   473.15+    TOTAL NET DUE  1,439.65+

  TOTAL EFT AMOUNT 1,439.65+
  SWEEP DATE    TUE DEC16 25

Your CStoreiQ Weekly Settlement card for that same week should show:

  • Online Due: $473.15 (Net Draw)
  • Instant Due: $966.50 (Net Instant)
  • Total Due: $1,439.65 (+ means the lottery commission is depositing into your account)
  • DUE date: Tue Dec 16 (the SWEEP DATE on the lottery commission invoice)

If your card doesn't match the lottery commission invoice, find the day in the week that's off via drill-down and re-open that Day Close if it's still editable.


Edit mode

Click Edit on a week card to adjust line values. Use cases:

  • The lottery commission invoice shows a service charge you didn't catch in Day Close
  • A manual adjustment from the lottery commission (refund, dispute)
  • Coupon promo wasn't reflected in terminal totals

In edit mode every line becomes a typeable field. After typing, click Save. The line is updated and the new Total Due is recomputed live.

Edit mode is locked once the EFT sweep date passes — the same settlement-lockout rule that protects Day Close. Edits to past-EFT weeks must be done via CStoreiQ support.


+ Add Settlement — when to use it

Normally you do not click + Add Settlement. The settlement week is auto-created by CStoreiQ as soon as the first Day Close for that 7-day window happens. The + Add Settlement button is for the rare case of:

  • A week where no day-closes exist at all (the store was closed all 7 days) but you still need a $0 placeholder for the audit trail
  • Onboarding — backfilling weeks before CStoreiQ was in use

Clicking the button opens a blank week card scoped to whichever month/year you're viewing. Fill in the lines manually, save.


"Settled" vs "Unsettled" — and how you mark a pack settled

When you activate an instant pack, the lottery commission considers you liable for its full face value sooner or later. CStoreiQ tracks this as two buckets:

  • Settled — packs you've already accounted for on a weekly settlement. These contribute to your Net Due for the week they were settled in.
  • Unsettled — packs that have been activated but haven't been marked settled yet. They sit waiting for you to settle them.

The total of Settled + Unsettled is the full face value of every pack you've ever activated and not yet returned.

How you control the timing

Different store owners settle packs on different schedules — and CStoreiQ leaves the choice to you:

  • Settle at activation — some stores prefer to mark each pack settled the moment they activate it. The pack's full value becomes part of that week's Net Due immediately.
  • Settle later (within the state's window) — most lottery commissions give you a number of days after activation (commonly 20–25 days, varies by state) before you have to settle. Some stores prefer to hold off and settle a batch at once when the deadline is near.

Both approaches work — CStoreiQ does not auto-settle anything for you.

How to mark packs settled

  1. Open Weekly Settlement and pick the week you're settling into.
  2. Find the Settlements line under Instant Due. Click the small arrow next to its dollar amount.
  3. A side panel opens showing every Unsettled pack at this store. Each row shows the pack number, game, activation date, and face value.
  4. Tick the checkbox next to each pack you're settling this week.
  5. Click Save in the side panel. The selected packs flip from Unsettled to Settled and their value rolls into this week's Settlements total.

If you don't want to track settlements pack-by-pack, you can instead type a dollar amount directly into the Settlements field in Edit mode. The per-pack list stays Unsettled, but the Total Due at the top of the week card still reflects the amount you entered.


Where to find the lottery commission's printed copy

The lottery commission prints a weekly settlement invoice on the lottery terminal automatically on the EFT day. You can also request a reprint from the lottery commission portal. Compare it to your CStoreiQ Weekly Settlement card each settlement morning.


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 ...
    • Day Close

      The single most important screen in the Lottery module. Run Day Close every business day, end of shift — even on slow days with zero lottery sales. Day Close is what feeds the Weekly Settlement that determines your EFT sweep amount, and a missing day ...
    • Activation Report

      A historical, read-only listing of every pack that was activated (placed into a bin for sale) at a store over a date range. This is the report you pull when you need to verify activity for a lottery commission audit, troubleshoot a discrepancy with ...
    • 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 ...