Cage and Cash Control Analytics • Aurora Crown Casino

1

Analytics Overview

CASINO NAME

PREPARED BY

ANALYTICS DATE

REPORTING PERIOD

DEPARTMENT OWNER

REVIEW TYPE

SHIFTS REVIEWED

MAIN PURPOSE

INFORMATION SOURCE

REVIEW STATUS

FINAL MANAGEMENT REVIEW REQUIRED

2

Variance Pattern Review

Total Variance Items

31

Net Variance

-$420

Shortage Items

18 ($1,240)

Overage Items

13 ($820)

Highest Single Variance: $225 shortage

Main Pattern: Small repeated drawer differences during evening close

Needs supervisor follow-up

Variance Pattern Breakdown

Variance Pattern	Count	Total Amount	Main Shift	Risk Level	Manager Note
Small cashier shortages	12	-$685	Evening	Medium	Repeated small differences need supervisor review
Small cashier overages	9	+$510	Day / Evening	Low	Mostly documented but needs consistency
Voucher drawer differences	5	-$280	Evening	Medium	Match voucher batch reports
Main cage count differences	3	-$225	Night	Medium	Manager notes required
Manual adjustment variance	2	+$260	Mixed	Medium	Approval explanation needed

3

Variance Detail Table

Date	Shift	Area / Cashier	Expected	Actual	Difference	Status	Follow-Up Needed
13 May 2026	Day	Cashier C-01	$18,500	$18,525	+$25	Needs note	Add overage explanation
14 May 2026	Evening	Cashier C-02	$22,400	$22,325	-$75	Open	Recount and supervisor note
15 May 2026	Evening	Main Cage	$96,000	$95,875	-$125	Open	Cage manager review
16 May 2026	Night	Cashier C-05	$14,200	$14,200	$0	Complete	No action
17 May 2026	Day	Cashier C-03	$16,750	$16,790	+$40	Needs note	Add overage explanation
18 May 2026	Evening	Voucher Drawer	$8,600	$8,560	-$40	In progress	Match voucher batch

4

Transaction Exception Review (14 total • 7 open)

Exception ID	Transaction Type	Amount / Reference	Department	Status	Owner	Required Action
TX-0513-01	Voucher mismatch	$250	Rewards / Cage	Open	Rewards Desk Manager	Compare voucher batch and cashier entry
TX-0514-02	Manual adjustment	$350	Cage	Open	Cage Manager	Add approved explanation
TX-0515-03	Payout reference missing	$1,200	Cage / Slots	Pending	Cage Supervisor	Attach approval reference
TX-0516-04	Chip redemption note	$18,500	Cage	Closed	Shift Manager	Approved and documented
TX-0517-05	Free play report missing	FP-MAY-26	Marketing / Rewards	Open	Marketing Manager	Attach campaign code report
TX-0518-06	Vault transfer note	$22,000	Vault / Cage	Needs review	Vault Supervisor	Confirm approval support

5

Approval Points Review

Approval Point	Related Activity	Amount / Reference	Required Approver	Current Status	Follow-Up Needed
Manual adjustment approval	Adjustment log	$350	Cage Manager	Open	Add explanation and approval note
Voucher batch correction	Voucher redemption	$250	Rewards Desk Manager	Pending	Compare voucher system report
Large chip redemption	Chip redemption	$18,500	Shift Manager	Approved	No action
Hand pay support approval	Slot hand pay	$6,800	Slot Manager / Cage Supervisor	Approved	Attach reference
Free play campaign support	Promo redemption	FP-MAY-26	Marketing Manager	Pending	Attach campaign code list
Emergency vault replenishment	Vault transfer	$22,000	Shift Manager	Needs review	Confirm approval note

6

Cash Movement Notes

Total Cash Movement $1,286,500

Opening Main Cage Balance $425,000

Closing Main Cage Balance $446,850

Net Cash Movement +$21,850

Vault Cash Transfers $142,000

Cashier Drawer Movement $318,400

Main Movement Driver: Redemption and evening shift volume
Status: Normal volume with open documentation items

Cash Movement Area	Opening	Closing	Net Movement	Status	Manager Note
Main Cage	$425,000	$446,850	+$21,850	Needs final review	Final finance review pending
Cashier Drawers	$180,000	$192,350	+$12,350	Needs review	Variance notes incomplete
Vault Cash	$850,000	$812,500	-$37,500	Needs sign-off	One access signature missing
Voucher Drawer	$8,600	$8,560	-$40	In progress	Voucher batch match needed

7

Count Review Results (42 sheets reviewed • 34 complete)

Count Area	Count Type	Status	Issue Found	Owner	Required Action
Cashier C-02	Drawer count	Needs review	$75 shortage	Cage Supervisor	Recount and note
Cashier C-04	Drawer count	Needs review	$40 overage	Cage Supervisor	Recount and note
Main Cage	Closing count	Needs review	Manager note missing	Cage Manager	Add sign-off
Vault	Access count	Open	One signature missing	Vault Supervisor	Confirm access note
Voucher Drawer	Batch count	In progress	$250 mismatch	Rewards / Cage	Compare reports

8

Control Checklist Results

Control Checklist Item	Status	Evidence Status	Owner	Management Note
Opening float confirmed	Complete	Available	Cage Supervisor	No issue
Cashier drawer assignments recorded	Complete	Available	Cage Supervisor	No issue
Vault access log reviewed	Needs review	Missing signature	Vault Supervisor	Resolve before closure
Cash transfers documented	Complete	Available	Cage Manager	No issue
Voucher redemptions matched	In progress	Partial	Rewards Desk Manager	$250 mismatch open
Free play reports attached	Open	Missing	Marketing Manager	Campaign code report needed
Manual adjustments explained	Open	Missing explanation	Cage Manager	Add approval note
Shortages and overages reviewed	Needs review	Partial	Cage Supervisor	Recount notes needed
Closing balances reviewed	Pending	Draft close sheet	Cage Manager	Final sign-off pending

9

Shift-Level Control Review

Shift	Cash Movement	Variance Items	Open Exceptions	Count Review Status	Main Issue
Day Shift	$386,500	6	2	Mostly complete	Small overage notes
Evening Shift	$612,000	17	8	Needs review	Voucher mismatch and drawer differences
Night Shift	$288,000	8	4	In progress	Missing sign-off and close notes
Weekly Total	$1,286,500	31	14	Needs management review	Documentation gaps repeated

10

Documentation Gap Review

Documentation Gap	Related Area	Why It Matters	Priority	Owner	Required Action
Missing vault access signature	Vault	Access control evidence incomplete	High	Vault Supervisor	Add approved explanation or signature
Manual adjustment explanation missing	Cage	Adjustment cannot be reviewed properly	Medium	Cage Manager	Add approved note
Campaign code report missing	Marketing / Rewards	Promo redemption review incomplete	Medium	Marketing Manager	Attach report
Voucher batch support missing	Rewards / Cage	Redemption total needs confirmation	Medium	Rewards Desk Manager	Compare batch report

11

Pattern and Trend Notes

Pattern / Trend	Evidence	Possible Meaning	Risk Level	Suggested Follow-Up
Evening close has most variance items	17 variance items on evening shift	Peak pressure may affect count process	Medium	Review evening close staffing and timing
Voucher exceptions repeat	5 voucher-related items	Redemption matching process may need clearer steps	Medium	Review Rewards / Cage handoff
Manual adjustments lack explanations	2 open adjustment notes	Approval documentation needs discipline	Medium	Require adjustment reason field
Vault signature gap repeated	1 missing access signature	Access evidence incomplete	High	Immediate sign-off review

12

Review and Escalation Flags

Flagged Item	Review Type Needed	Reason	Priority	Recommended Next Step
Missing vault access signature	Vault / Security / Compliance	Access control evidence incomplete	High	Resolve before final close
Voucher mismatch	Cage / Rewards / Finance	Records do not yet match	High	Complete comparison
Manual adjustment note missing	Cage / Finance	Adjustment lacks explanation	Medium	Add approved explanation
Cashier shortage pattern	Cage Management	Repeated small differences	Medium	Review by cashier and shift
Emergency vault replenishment approval	Cage / Finance / Management	Approval support must be clear	High	Attach approval reference

13

Management Questions for Review

1. Are variance items isolated or repeated by shift, cashier, or transaction type?

2. Are shortages and overages explained clearly?

3. Are transaction exceptions matched across systems?

4. Are approval points complete before closure?

5. Are cash movement notes supported by evidence?

6. Are count sheets signed and reviewed?

7. Which checklist items remain incomplete?

8. Which documentation gaps could affect audit readiness?

9. Which items need finance, compliance, security, surveillance, or senior management review?

10. What must be closed before final reporting?

MANAGEMENT REVIEW NOTES

14

Follow-Up Action Tracker

Follow-Up Action	Area	Priority	Owner	Due Date	Notes
Resolve $250 voucher mismatch	Rewards / Cage	High	Rewards Desk Manager	20 May 2026	Compare system and cashier report
Complete Cashier C-02 recount note	Cage	High	Cage Supervisor	20 May 2026	$75 shortage
Add manual adjustment explanation	Cage	Medium	Cage Manager	20 May 2026	$350 adjustment
Confirm missing vault access signature	Vault / Security	High	Vault Supervisor	20 May 2026	Access log incomplete

15

Safe Analytics Language Guide

Avoid This Wording	Why It Is Risky	Better Analytics Wording
"Cashier caused the shortage"	Assigns blame before review	"Cashier drawer shortage requires supervisor review"
"Cage failed control"	Premature conclusion	"Control checklist item remains open"
"Vault control failed"	Too strong before review	"Vault access log has a missing signature"
"Rewards made an error"	Blames department	"Voucher mismatch requires Rewards and Cage review"

Human Review and Control Disclaimer

• This app supports cage and cash control analytics only.

• It does not certify balance or official close.

• It does not replace official accounting, finance close, cage SOPs, compliance review, surveillance review, audit procedures, regulatory reporting, security procedures, or management approval.

• Variances, transaction exceptions, approvals, cash movement, counts, vault activity, and documentation gaps must be reviewed under approved casino procedures.

• Use factual, neutral, professional language. Do not assign blame, fault, intent, or final conclusions without official review.

• Final sign-off requires authorized human review.

Control Analytics Snapshot