Scenario_2_PwrBll_AUP.pdf

PDF 400 KB Posted

Attached to
RFP #R005840 Financial Auditing and Related Services
Solicitation number
0000040206
Issued by
Sacramento County, San Francisco City, California

About this file

This document is an internal memorandum from the Mega Millions Consortium Multistate Lottery Association establishing agreed-upon procedures (AUP) for annual financial reviews of Powerball lottery operations. The memorandum, issued by Joshua Johnston, Director of Washington's Lottery and Lead Director for the Mega Millions Consortium on March 13, 2025, outlines standardized audit procedures applicable to member lotteries, the California Lottery, and the Multi-State Lottery Association. The procedures cover the review period of April 1, 2024 through March 31, 2025, with all completed reviews and related reports required for distribution no later than December 31, 2025. The AUP procedures include no material game changes affecting financial aspects during the review period; however, expired prize reporting procedures have been adjusted to require sample sizes of only two draws from each selected month rather than previous requirements.

The procedures establish comprehensive verification requirements across three separate attachments tailored to different lottery entities. Member lotteries must verify the mathematical accuracy of Draw Activity and Fixed Prize Analysis reports, randomly select five draw dates for detailed testing, reconcile sales figures across gaming systems, validate fixed prize calculations, review expired prize settlement data from Virginia Lottery, and confirm cash disbursement transactions and investment purchases through competitive bidding processes involving minimum three brokerage firms. Similar but slightly streamlined procedures apply specifically to the California Lottery and Multi-State Lottery Association. The AUP framework establishes standardized testing parameters, documentation requirements, and reconciliation procedures designed to ensure consistent financial reporting and compliance with Powerball gaming rules and multi-state regulations across all participating lottery jurisdictions.

View the file

Other files

Show all 11

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

To: Members of the Mega Millions Consortium Multistate Lottery Association

From: Joshua Johnston

Date: March 13, 2025

Re: Agreed Upon Procedures for Powerball

As the Mega Millions Lead Director, I hereby endorse the procedures required for party lotteries to conduct their annual reviews for Powerball. This authority is set out in the Mega Millions Members’ Finance and Operations Procedures for Powerball and Power Play (effective 8/23/21), Section 1.2.

There were no game changes that affected the financial aspects of the game during the AUP review period; however, the expired prize reporting procedures in Attachment 1 section f have been adjusted. The sample size will only need to include 2 draws from each month selected

These reviews should be complete and related reports distributed no later than December 31, 2025.

Attachment 1

a. Obtain from the (Your Lottery’s Name) the “Draw Activity” and the “Fixed Prize Analysis” for the period April 1, 2024 – March 31, 2025 and attach those as Exhibits I and II, respectively. Prove the mathematical accuracy of the schedules and note any exceptions.

b. Randomly select five (5) draw dates from the period April 1, 2024 – March 31, 2025.

c. For each draw date selected in step “b” above, compare the total amount of sales as shown on the daily sales report produced by the (Your Lottery’s Name)’s gaming system and the total amount of sales shown on the related daily sales report produced by Internal Control System (“ICS”), with the balance listed in the “sales” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

d. Calculate the total dollar amount of the fixed prizes for the draw dates selected in step “b” above, based on the total number of winners from the (Your Lottery’s Name)’s gaming system for each prize level and the prize structure of the Powerball fixed prizes (as defined in the official game rules). Compare the calculated expense with the amount listed in the “Actual Fixed Prizes” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

e. For each draw date selected in step “b” above, compare the amount of sales, actual fixed prizes, and share of fixed prizes shown on the “Draw Activity” report attached as Exhibit I to the amounts shown on the applicable Powerball Prize Settlement Reports and ensure they are in agreement.

f. For the period identified, randomly select two months and obtain the “Expired Prize

Settlement Report” distributed by the Virginia Lottery. For each of the two months selected, select 2 draws and obtain from the (Your Lottery Name) Internal Control System (ICS) the actual fixed prizes awarded, and the prizes unclaimed. Compare the ICS data back to the data reported from the Virginia Lottery for each draw of the subject months to ensure they are in agreement.

g. Compare the amounts shown as the total of the actual fixed prizes and the total of the share of fixed prizes on the “Draw Activity” report attached as Exhibit I to the applicable amounts shown on the “Fixed Prize Analysis” report attached as Exhibit II and ensure they are in agreement.

h. For the amount (if any) listed in the “Cash Options Amount” column of the “Draw

Activity” report attached as Exhibit I, obtain and compare the amount to the (Lottery Name)’s cash disbursement subsidiary records which summarize the funds disbursed to the prize winner.

i. For each purchase (if any) of investments associated with the jackpot prizes:

1. Review broker confirmations to verify that investments are funded in accordance with allowed investment vehicles per the multi-state rules, regulations or procedures.

2. Obtain the bid sheets and supporting documentation and verify the investments were purchased through a competitive bidding process involving a minimum of three brokerage firms.

3. Review the (Lottery Name)’s cash disbursement subsidiary records and confirm that the payment to the broker, plus the cash held by the Lottery for the initial cash payment, equals the “Cash Option Payment” on the settlement report applicable to that draw.

4. Obtain the Security Purchase report which lists the results of the security purchase and verify that the information reported to the group is accurate, including the annuity factor for the non-winning bidders.

j. Compare the total of the period transfers from/to (Your Lottery) to/from the Virginia Lottery for settlement of the fixed prize liability as shown in the (Your Lottery’s Name)’s cash disbursement/cash receipt subsidiary records to the amount listed in the “Qtrly/Yrly Settlements Transfers In (Out)” column on the “Fixed Prize Analysis” report attached as Exhibit II and ensure they are in agreement.

k. Compare the balance listed as the (Your Lottery’s Name)’s receivable as of (period ending date as agreed to by member lotteries) for the fixed prizes as shown on the “Fixed Prize Analysis” report attached as Exhibit II to the (Your Lottery’s Name)’s financial accounting records and to the Powerball Prize Settlement Report as of (period ending date as agreed to by member lotteries) and ensure they are in agreement.

Attachment 2

a. Obtain from the California Lottery the “Draw Activity” for the period April 1, 2024 – March 31, 2025, and attach that as Exhibit I. Prove the mathematical accuracy of the schedule and note any exceptions.

b. Randomly select five (5) draw dates from the period April 1, 2024– March 31, 2025.

as shown on the daily sales report produced by the California Lottery’s gaming system and the total amount of sales shown on the related daily sales report produced by the Internal Control System (“ICS”), with the balance listed in the “sales” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

d. For the amount (if any) listed in the “Cash Options Amount” column of the “Draw

Activity” report attached as Exhibit I, obtain and compare the amount to the California Lottery’s cash disbursement subsidiary records which summarize the funds disbursed to the prize winner.

e. For each purchase (if any) of investments associated with the jackpot prizes:

accordance with allowed investment vehicles per the multi-state rules, regulations or procedures; and

2. Obtain the bid sheets and supporting documentation and verify the investments were purchased through a competitive bidding process involving a minimum of three brokerage firms.

3. Review the California Lottery’s cash disbursement subsidiary records and confirm that the payment to the broker, plus the cash held by the Lottery for the initial cash payment, equals the “Cash Option Payment” on the settlement report applicable to that draw.

4. Obtain the Security Purchase report which lists the results of the security

Attachment 3

a. Obtain from the Multi-State Lottery Association the “Draw Activity” for the period April 1, 2024 – March 31, 2025, and attach that as Exhibit I. Prove the mathematical accuracy of the schedule and note any exceptions.

b. Randomly select five (5) draw dates from the period April 1, 2024 – March 31, 2025.

as shown on the daily sales report produced by the Multi-State Lottery Association Draw Reporting System and the total amount of sales shown on the related daily sales report produced by Centralized Automated Reporting System, with the balance listed in the “sales” column for the respective draw date on the “Draw Activity” report attached as Exhibit I and ensure they are in agreement.

d. For the amount (if any) listed in the “Cash Options Amount” column of the “Draw

Activity” report attached as Exhibit I, obtain and compare the amount to the Multi- State Lottery Association’s cash disbursement subsidiary records which summarize the funds disbursed to the prize winner or specific member State Lottery and verify agreement.

e. For any cash disbursement to a specific member State Lottery, obtain further confirmation that the payment of the “Cash Options Amount” to the validated ticket winner was correctly and fully disbursed.

f. For each purchase (if any) of investments associated with the jackpot prizes:

accordance with allowed investment vehicles per the multi-state rules, regulations or procedures; and

2. Obtain the bid sheets and supporting documentation and verify the investments were purchased through a competitive bidding process involving a minimum of three brokerage firms.

3. Review the Multi-State Lottery Association’s cash disbursement subsidiary records and confirm that the payment to the broker, plus the cash held by the Multi-State Lottery Association for the initial cash payment, equals the “Cash Option Payment” on the settlement report applicable to that draw.

4. Obtain the Security Purchase report which lists the results of the security

Joshua Johnston Director, Washington’s Lottery Lead Director for the Mega Millions Consortium

File details come from the government source that posted it. Updated .