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.
| 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 |
Each week card shows the same information. For example, a week card for Week 1, May 4 – May 10, settling on May 11, shows:
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. |
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 |
| 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.
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):
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:
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.
Click Edit on a week card to adjust line values. Use cases:
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.
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:
Clicking the button opens a blank week card scoped to whichever month/year you're viewing. Fill in the lines manually, save.
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:
The total of Settled + Unsettled is the full face value of every pack you've ever activated and not yet returned.
Different store owners settle packs on different schedules — and CStoreiQ leaves the choice to you:
Both approaches work — CStoreiQ does not auto-settle anything for you.
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.
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.