Store Operations Management

Day

Date

Shift / Employee

Report Prepared By

Sales Grand Total

$0.00

Payment Total

$0.00

Payment Variance

$0.00

Drawer Over / Short

$0.00

Sales

SL #	Sales Department	Amount
Department Sales Subtotal		$0.00
27	High Tax Collected
28	Low Tax Collected
29	Scratch-Off Sales
30	On-Lotto Sales
31	Money Order Sales
32	Gas Sales
Sales Grand Total		$0.00

Payments, Payouts & Cash Drops

Item	Amount
Payment Tender Total	$0.00
Cash Payouts / Drops Total	$0.00
All Entered Payment/Payout Items	$0.00

Payment variance = Cash + Credit + Debit + EBT − Sales Grand Total.
Expected ending cash = Opening Cash + Cash Tender − Cash Payouts/Drops.
Drawer over/short = Actual Shift-End Cash − Expected Ending Cash.

Cash Reconciliation & Comments

Expected Ending Cash

Drawer Over / Short

Comments / Issues

Game Machine

SL #	Money In	Profit
1		$0.00
2	Free Play Paid to Customer
Net Game Machine Profit		$0.00

Net game profit = Money In − Money Out − Free Play Paid.

Gas Sales by Grade

Grade	Gallons Sold	Sales Amount	Average / Gallon
Regular
Plus
Premium
Fuel Grade Totals	0.000	$0.00
Reported Gas Sales		$0.00
Gas Sales Variance		$0.00	MATCHED

Enter each grade’s Gallons Sold and Sales Amount manually. The blue Average / Gallon fields are calculated automatically as Sales Amount ÷ Gallons Sold. Gas sales variance = Total grade sales − Reported Gas Sales above.

Store Expenses

SL #	Department	Comments	Amount
Store Expense Grand Total			$0.00

Vendor Payout / Inventory Purchase

SL #	Paid To	Cash Amount	Check Amount	Check #	Total Amount
Vendor / Inventory Grand Total					$0.00

Checks & Deposit Register Filters

From Date

To Date

Search Payee or Check #

Check Status

Vendor Checks

Daily Cash Deposit Tracking

The daily cash amount is pulled from the Cash payment field in each saved Daily Report.

Game Machine Profit Deposit Tracking

The amount is the saved daily net game-machine profit: Money In − Money Out − Free Play Paid.

DEPARTMENTS & INVENTORY

Department Setup and Beginning Inventory

Active sales departments appear automatically in the Daily Report and vendor tags.

Add or Edit Department

Department Name

Beginning Inventory Value

Display Order

Status

Notes

Department List

VENDORS

Vendor Directory and Purchase History

Department tags connect vendors to purchasing needs and Daily Report vendor payouts.

Add or Edit Vendor

Vendor Name

Contact Person

Email Address

Phone

Department Tags

Comments

Vendor Directory and History

ACTIVITY AUDIT

Append-Only Financial and Operational History

Records who changed what, when it changed, and the before/after values.

Audit Filters

User

Area

From Date

Permanent Activity Records

Production requirement: these records must be written by the server, not the browser, and database permissions must prohibit updates and deletes. The current file demonstrates the final data structure locally.

FINANCE & VALIDATION

Owner Decision Dashboard

Review projected bank balances, validate EFTs, and determine required transfers.

Operating Bank AccountInside Operations

Main Ledger Balance Automatically linked from Main Ledger	$0.00
Manual Bank Adjustment Use + or − for bank-only timing differences or immediate decisions
Adjusted Current Operating Balance	$0.00
Pending Cash to Deposit	$0.00
Outstanding Vendor Checks	$0.00
Other Predicted Expenses
Projected Operating Balance	$0.00

Adjusted current balance = Main Ledger balance + Manual bank adjustment. Projected balance = Adjusted current balance + Undeposited operating cash + effective card settlement + gas-company EFT − Outstanding checks − Other predicted expenses. The adjustment does not change the ledger and should be cleared once the related transaction is recorded.

Georgia Lottery AccountTuesday EFT

Current Bank Balance
Pending Transfer Into Account
Calculated Lottery EFT Planning estimate from the latest completed saved lottery week	$0.00
Actual Lottery EFT Due Tuesday Optional override; leave blank to use calculated EFT
EFT Used in Projection	$0.00
Projected Lottery Balance	$0.00
Surplus After EFT	$0.00

The default Tuesday EFT uses the most recently completed saved weekly lottery estimate. Enter an Actual EFT only when the confirmed amount is available. Projected balance = Current balance + Pending transfer − Effective EFT.

Game Machine AccountWednesday EFT

Current Bank Balance
Pending GM Profit Deposit	$0.00
Previous Week GM Profit	$0.00
Calculated EFT at 56.49%	$0.00
Actual EFT Due Wednesday Optional override; leave blank to use calculated EFT
EFT Used in Projection	$0.00
Projected Game Machine Balance	$0.00
Surplus After EFT	$0.00

The default Wednesday EFT is 56.49% of the total net game-machine profit from the most recently completed Sunday–Saturday week. Enter an Actual EFT only when the confirmed amount becomes available; otherwise the calculated amount is used. Projected balance = Current balance + Undeposited GM profit − Effective EFT.

Game Machine EFT Validation

From Date

To Date

EFT Payment Date

Actual EFT Paid

Validation compares saved daily net game-machine profit against recorded EFT payments. Expected EFT is 56.49% of profit for the selected date range. Actual EFT payments are stored separately so the historical total remains available.

Georgia Lottery — Weekly EFT Validation

Sales Week Start (Sunday)

Actual EFT Draft / Credit

Other Weekly Adjustment (+ charge / − credit)

Weekly Source Totals

Estimated EFT Reconciliation

Planning estimate: activation/settlement charges + On-Lotto net sales − winning payouts − 6% sales commission + manual adjustments. Because Georgia Lottery terminal accounting can include timing, returns, promotional credits, and sweep-calendar adjustments, use the reported EFT as the final source of truth and investigate any variance.

Card Settlement & Gas Company EFT

Estimated Credit & Debit Card Deposit

Calculation Start Date
Calculation End Date
Settlement Delay
Processing Fee Estimate	%
Gross Credit Card Sales	$0.00
Gross Debit Card Sales	$0.00
Estimated Processing Fees	$0.00
Estimated Net Card Deposit	$0.00
Expected Deposit Date	—
Settlement Status
Actual Posted Amount
Card Amount Used in Projection	$0.00

Net deposit = Credit Card Sales + Debit Card Sales − estimated processing fees. The default fee is 2.85%. Enter the actual amount only after the settlement posts.

Gas Company EFT Placeholder

Store Uses Gas-Net Settlement
Gas Settlement Start Date
Gas Ordered Since Start Date	$0.00
Estimated Card Sales Available for Offset	$0.00
Manual Gas Company EFT
Gas EFT Status
Gas EFT Used in Projection	$0.00

Temporary design: enter the gas-company EFT manually. Later, it can be calculated from gas POs, accumulated card settlements, settlement windows, and store-specific netting rules.

Management Notes & Decisions

Notes / Upcoming Obligations

Manual finance and validation fields are saved automatically in this browser. Pending operating cash, outstanding checks, and pending game-machine deposits are calculated from your saved reports and status selections.

Gas Inventory & Purchase Order

Inventory / Order Date

Report Time

Ordered Date

Expected Delivery Date

Actual Received Date

Supplier / Carrier

PO / Confirmation Number

Status

Notes

Saved Gas Orders & Tank Readings

Georgia Lottery Daily Validation

Lottery Business Date

Terminal Report Total Net Due

Report / Terminal Reference

Validation Notes

Daily Report Values — Automatically Pulled

On-Lotto Sales	$0.00
Scratch-Off Sales	$0.00
On-Lotto Cash Payout	$0.00
Scratch-Off Cash Payout	$0.00
Total Lottery Sales	$0.00
Total Winning Payouts	$0.00

Georgia Lottery Terminal Report — Manual Values

Online Gross Sales
Cancels / Discounts
Online Cash Prizes
Online Commission Reported
Instant Sales / Settlements
Instant Cash Prizes
Instant Commission Reported
Other Adjustments (+/−)
Calculated Terminal Net Due	$0.00
Reported vs Calculated Variance	$0.00

Scratch-Off Box Sales — 70 Boxes

For the first saved day, enter the opening ticket number and closing ticket number. For each later date, the prior saved closing number automatically carries forward as that box’s opening number. Quantity sold = Closing − Opening. Box sales = Quantity sold × Ticket price. Prices are seeded with $1, $2, $3, $5, $10, $20, $25, $30, and $50 values and remain editable.

Box	Qty Sold	Box Sales
Scratch Box Total	0	$0.00
Daily Report Scratch-Off Sales		$0.00
Box Total Variance		$0.00

Activated Scratch-Off Packs / Bundles

Activation Date

Box #

Game / Pack Number

Ticket Face Value

Tickets in This Pack

Gross Pack Value

How this works: Ticket Face Value is the printed price of one ticket, such as $1, $2, $5, or $10. Tickets in This Pack is the actual ticket quantity for that game/pack. Gross Pack Value calculates instantly as Ticket Face Value × Tickets in This Pack. The quantity is not assumed because pack sizes can vary.

Scheduling model used here: an activation is assigned to the sales week beginning two Sundays after its activation week, and its projected EFT date is the following Tuesday. This reproduces your example: activation July 5 → settlement week July 19–25 → EFT Tuesday July 28. Confirm the exact sweep date against the Georgia Lottery sweep calendar or terminal statement.

Saved Lottery Days

REPORTS

Saved Operational Records

Future backend version: saved reports will be locked after submission and editable only by an Admin or a user with special permission.

Saved Daily Reports

MAIN LEDGER

Cash Flow Tracker

Imported historical entries remain editable. New entries recalculate the running balance automatically.

Add or Update Ledger Entry

Date

Item

Ledger Filters

From Date

To Date

Cash Flow Ledger

INVESTMENT POSITION

Partner Contributions & Overall Store Investment

Seven owners / partners / investors. Ownership is initially shown equally at 1/7 each and remains editable.

Investment Reconciliation

Reconciliation Summary
The summary will update automatically based on the latest ledger entries, reconciliation dates, and partner-paid expenses.

Partner Investment Position

Use of Funds

Investment Assumptions & Manual Adjustments

Bank and Register are fixed payment sources. Zishan remains a historical fixed payer and is not treated as a system user or investor. Aqeeb is preloaded as Store Manager.

Business / Store Valuation

Goodwill Value

Inventory Value

Game Machine Income Reinvested

Goodwill Still Owed

Investment Notes

USERS & ROLES

People, Responsibilities & Access Structure

Maintain the people who use the system and document the operational duties assigned to employees and managers.

Add or Update User

User Name

Role

Status

Custom Role (when Other)

Duties / Responsibilities

Current Users

Standard Role Guidance

Role	Typical Access / Responsibility
Owner / Investor / Partner	Review finance, validations, accumulated reports, bank projections, and management decisions.
Employee	Enter assigned daily sales, lottery, cash, inventory, and operational information according to documented duties.
Store Manager	Supervise employee data entry, verify shift records, review exceptions, assign pending items, and coordinate orders.
Admin	Manage users, permissions, report corrections, system setup, and locked-record exceptions.

PENDING ITEMS

Operational To-Do & Follow-Up Register

Assign work to a system user and track responsibility, status, and the most recent status-change date.

Add or Update Pending Item

Item

Assignee

Priority

Status

Due Date (optional)

Description / Comments

Pending Items

Assignee

Priority

Status

Sales

Payments, Payouts & Cash Drops

Cash Reconciliation & Comments

Game Machine

Gas Sales by Grade

Store Expenses

Vendor Payout / Inventory Purchase

Accumulated Summary Filters

Checks & Deposit Register Filters

Add or Edit Department

Department List

Add or Edit Vendor

Vendor Directory and History

Audit Filters

Permanent Activity Records

Operating Bank AccountInside Operations

Georgia Lottery AccountTuesday EFT

Game Machine AccountWednesday EFT

Game Machine EFT Validation

Georgia Lottery — Weekly EFT Validation

Weekly Source Totals

Estimated EFT Reconciliation

Card Settlement & Gas Company EFT

Estimated Credit & Debit Card Deposit

Gas Company EFT Placeholder

Management Notes & Decisions

Gas Inventory & Purchase Order

Saved Gas Orders & Tank Readings

Georgia Lottery Daily Validation

Daily Report Values — Automatically Pulled

Georgia Lottery Terminal Report — Manual Values

Scratch-Off Box Sales — 70 Boxes

Activated Scratch-Off Packs / Bundles

Saved Lottery Days

Saved Daily Reports

Add or Update Ledger Entry

Ledger Filters

Cash Flow Ledger

Investment Reconciliation

Partner Investment Position

Use of Funds

Investment Assumptions & Manual Adjustments

Add or Update User

Current Users

Standard Role Guidance

Add or Update Pending Item

Pending Items