Loading...
CM-08-02-030DATE: January 28, 2008 SUBJECT: City Manager Approval ITEM: Federal Asset Forfeiture Annual Certification Report. Department: Police Department Staff Person: Bryan Williams Justification: Funding: Cost: N/A This is a required annual report of monies and property value seized under the Federal Equitable Sharing Agreement. Source of funds: N/A Background Information: This annual report is sent to the Federal government to outline the amount of funds remaining from the previous fiscal year, the amount seized during the current fiscal year, the amount spent on law enforcement purchases during the current fiscal year, and an itemized listing of the purchases. The beginning equitable sharing fund balance was $391,660.88. Federal Drug Seizure Funds for FY 2007 were $85.66, Interest Income -- $9,401.46, and Auction Proceeds -- $4,512.50. Federal Sharing Funds Spent in FY 2007 totaled $290,571.05, with $26,228.75 spent on firearms, $6,705.80 on surveillance equipment, and $257,636.49 on Digital Video Recorder equipment. Updated 3-10-05 Round Rock Police Department Staff Summary Sheet 1 2 3 4 TO Adm. Mgr, Rick White Finance Pgms Mgr, Elaine Wilson ACTION SIGNATURE (Last Isjitme and Date) Approv 6 -awl (M. 6 TO ACTION SIGNATURE (Last Name and Date) Sergeant, Jinn Stuart Asst. Chief, Tim Ryle 5 Chien Bryan Williams Approval Approval/ Not Approval Approval purl jantwo Title & Name: Sherrill Voll, Management Analyst 7 8 9 10 Division: Office of the Chief Subject FY 2007 Asset Forfeiture Annual Certification Report Summary: Phone: 512-671-2722 Nextel: N/A Return Date: 1/18/2008 Date. January 14, 2008 1. This Staff summary package is for a Federal Asset Forfeiture Annual Certification Report required by the United States Department of Treasury. It will require the City Manager's signature. 2. This is a required annual report on monies and property value seized under the Federal Equitable Sharing Agreement. This report is due within 60 days after the close of the fiscal year. 3. Tab 1: Federal Annual Certification Report (with attachment) — signatures needed Tab 2: Financial Documents Prepared by Elaine Wilson —Federal Funds Balance, Trial Balance excerpt, LE Fund Assets Purchased, Auction Proceeds 4. VIEW OF OTHERS: N/A 5. Recommendation is that we submit the Federal Annual Certification Report for the City Manager's signature. TAB 1 Federal Annual Certification Report This report must be submitted within 60 days after the close of your fiscal year to the: Asset Forfeiture and Money Laundering Section U.S. Department of Justice 10th and Constitution Avenue, NW Bond Building, 10" Floor Washington, DC 20530 Fax: (202) 616-1344 E-mail address: afmls.aca@usdoj.gov Law Enforcement Agency: Round Rock Police Department Executive Office for Asset Forfeiture U.S. Department of the Treasury 1341 G Street, NW Suite 900 Washington, DC 20220 Fax: (202) 622-9610 E-mail address: treas.aca@teoaf.treas.gov Police Department 0 Sheriff's Office/Department Contact Person: Jim Stuart O Task Force (attach List of members) 0 Prosecutor's Office 0 Other E-mail Address: jstuart@round-rock.tx.us Mailing Address: (Street) 615 E. Palm Valley Blvd (City) Telephone Number: ( 512 ) 671-2708 Agency Fiscal Year Ends on: (Month/Day/Year) Round Rock (State) Fax Number: ( 512) 218-3267 TX (Zip Code) 78664 9/30/07 NCIC/ORI/Tracking No.: TX24605 Summary of Equitable Sharing Activity (Fiscal Year Ending 2007 Justice Funds Treasury Funds (DEA, FBI, ete)' (IRS, ICE, etc)2 1. Beginning Equitable Sharing Fund Balance (must match Ending Equitable Sharing Fund Balance from prior FY) $ 391.660.88 $ 0.00 2. Federal Sharing Funds Received from the Department of Justice and the Department of the Treasury $ 85.66 $ 0.00 3. Federal Sharing Funds Received from Other Law Enforcement Agencies and Task Forces (complete attachment) $ 0.00 $ 0.00 4. Other Income $ 4.512.50 $ 0.00 5. Interest Income Accrued (0 check if non-interest-bearing account) $ 9.901.46 $ 0.00 6. Total Equitable Sharing Funds (total of lines 1 - 5) $ 406.160.50 $ 0.00 7. Federal Sharing Funds Spent (total of lines a - n) $ ( 290.571.05) $ ( 0.00 ) 8. Ending Equitable Sharing Fund Balance (subtract line 7 from line 6) $ 115.589.45 $ 0.00 9. Appraised Value of Other Assets Received $ 0.00 $ 0.00 Summary of Shared Monies Spent a. Total spent on salaries for new, temporary, not to exceed 1 -year employees $ 0.00 $ 0.00 b. Total spent on overtime $ 0.00 $ 0.00 c. Total spent on informant and "buy money" $ 0.00 $ 0.00 d. Total spent on travel and training $ 0.00 $ 0.00 e. Total spent on communications and computers $ 0.00 $ 0.00 f. Total spent on firearms and weapons $ 26,228.75 $ 0.00 g. Total spent on body armor and protective gear $ 0.00 $ 0.00 h. Total spent on electronic surveillance equipment $ 6.705.80 $ 0.00 i. Total spent on building and improvements $ 0.00 $ 0.00 j. Total spent on drug education and awareness programs $ 0.00 $ 0.00 k. Total spent on other law enforcement expenses (complete attachment) $ 257.636.49 $ 0.00 1. Total transfers to other state and local law enforcement agencies (complete attachment) $ 0.00 $ 0.00 m. Total permissible use transfers (complete attachment) $ 0.00 Amount of line (m) used for drug abuse treatment and prevention programs $ 0.00 n. Total spent on matching grants (complete attachment) $ 0.00 $ 0.00 o. Your agency's budget for current fiscal year $ 18.146.511.00 p. Your jurisdiction's budget for current fiscal year $ 78.858.648.00 q. Your agency's budget for prior fiscal year $ 16.498.533.00 r. Your jurisdiction's budget for prior fiscal year $ 70.595.268.00 Under the penalty of perjury, the undersigned hereby certify that the information in this report is an accurate accounting of funds received and spent by the law enforcement agency under the federal equitable sharing program during this reporting period. Name (Print or Type) Bryan Williams Date 1/14/2008 ( Type) Jim Nuse 1/14/2008 Name Print or Date Law Enforcement Agency Head Governing Body Head Signature: I ettA 1A) vt,6 Atitto Title: Chief of Police Signature: Title: Ma City of Round Rock This form is subject to the Freedom of Information Act and may be released under 5 U.S.C. § 552. See www.usdoj.gov/criminal/afmis.html or www.treas.goviofticesienforcement/teoaf for additional forms. ' Include under Justice funds shared cash, proceeds, and property received from the Drug Enforcement Administration (DEA), Federal Bureau of Investigation (FBI), U.S. Attorney's Office, U.S. Postal Inspection Service, Food and Drug Administration, and U.S. Department of Agriculture. Include under Treasury funds shared cash, proceeds, and property received from the Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF)', Internal Revenue Service (IRS), U.S. Immigration and Customs Enforcement (ICE), U.S. Customs and Border Protection, U.S. Secret Service, and U.S. Coast Guard. *The Bureau of Alcohol, Tobacco, Firearms and Explosives is a component of the Department of Justice, but ATF's equitable sharing is currently processed by the Department of the Treasury. Until further notice, please deposit all equitably shared cash and proceeds from ATF in your agency's Treasury fund. April 2005 Federal Annual Certification Report Attachment 3. Federal Sharing Funds Received from Other Law Enforcement Agencies and Task Forces Name of Law Enforcement Agency Agency Address Amount Received _ Justice Funds Treasury Funds $ $ $ $ $ $ $ $ $ If additional space is needed, please attach additional page. Attachment Yes No k. Total Spent on Other Law Enforcement Expenses Item Purchased Amount Spent Justice Funds Treasury Funds Amount Transferred Justice Funds Treasury Funds $ $ $ $ $ $ If additional space is needed, please attach additional page. Attachment 11 Yes r -T No 1. Total Transfers to Other State and Local Law Enforcement Agencies Name of Law Enforcement Agency Agency Address Amount Transferred Justice Funds Treasury Funds $ $ $ $ $ $ $ $ If additional space is needed, please attach additional page. Attachment ! - Yes m. Total Permissible Use Transfers Name of Recipient Agency Amount Spent Justice Funds Treasury Funds Amount Spent Justice Funds $ $ $ $ $ $ If additional space is needed, please attach additional page. Attachment Yes r" No n. Total Spent on Matching Grants Name of Grant Amount Spent Justice Funds Treasury Funds $ $ $ $. $ $.. If additional space is needed, please attach additional page. Attachment 7 Yes t-- No April 2005 Federal Annual Certification Report Instructions Law Enforcement Agency: Enter the complete name of your state or local law enforcement agency — e.g., Anytown Police Department. This must be consistent with the DAG -71. Check the appropriate box to indicate type of agency. Acronyms should be spelled out. If a task force, provide a list of member agencies, addresses, and lead agency, if designated. Contact Person: Enter the name of the person who can provide additional information on the certification report. E-mail Address: Enter the e-mail address of the contact person or the e-mail address of the agency. Mailing Address: Enter your agency's complete mailing address (number, street, city, state, and zip code). Telephone Number: Enter the phone number of the contact person, including area code and extension, if any. Fax Number: Enter your agency's fax number, including area code. Agency Fiscal Year Ends on: Enter the ending date (month/day/year) of your agency's fiscal year — e.g., 6/30/05. NCIC/ORI/Tracking No.: Enter your valid FBI -issued National Crime Information Center (NCIC)/ORI code — e.g., CA0000000 — or tracking number assigned by the Asset Forfeiture and Money Laundering Section. Beginning Equitable Sharing Fund Balance: Enter on line 1 the amount in your federal forfeiture fund account at the beginning of your fiscal year. The amount entered on line 1 must match the Ending Equitable Sharing Fund Balance reported on your agency's Federal Annual Certification Report for the prior fiscal year. If the Beginning Equitable Sharing Fund Balance differs from the Ending Equitable Sharing Fund Balance reported last year, an amended Federal Annual Certification Report must be submitted. Separate Justice funds from Treasury funds. Include under Justice funds shared cash and/or proceeds received from the Drug Enforcement Administration (DEA), Federal Bureau of Investigation (FBI), U.S. Attorney's Office, U.S. Postal Inspection Service, Food and Drug Administration, and U.S. Department of Agriculture. Include under Treasury funds shared cash and/or proceeds received from the Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF), Internal Revenue Service (IRS), U.S. Immigration and Customs Enforcement (ICE), U.S. Customs and Border Protection, U.S. Secret Service, and U.S. Coast Guard. Please note that ATF is a component of the Department ofJustice, butATF's equitable sharing is currently processed by the Department of the Treasury. Until further notice, please deposit all equitably shared cash and proceeds from ATF in your agency's Treasury fund. Federal Sharing Funds Received from the Departments of Justice and Treasury: Enter on line 2 the total amount of shared cash and/or proceeds received from the federal equitable sharing program. For example, if your fiscal year ends 6/30/05, include all sharing funds received from 7/1/04 through 6/30/05. Separate Justice funds from Treasury fiends. Funds from state and local forfeitures should not be reported on the Federal Annual Certification Report. Federal Sharing Funds Received from Other Law Enforcement Agencies and Task Forces: Enter on line 3 the total amount of federal sharing funds received from other state and local law enforcement agencies and task forces. Please provide a list of the agencies your agency received funds from, their address, and the amount received on the Federal Annual Certification Report Attachment. Other Income: Enter on line 4 the proceeds from the sale of shared property or any amounts returned to your forfeiture fund account — e.g., funds from the sale of a car placed in official use or reimbursements received from your city, county, or state for expenditures made with shared funds. Interest Income Accrued: Enter on line 5 the interest earned on your federal forfeiture fund account during your fiscal year. Account for Justice and Treasury interest income separately. Check box if shared funds are in a non-interest-bearing account. Total Equitable Sharing Funds: Add the beginning equitable sharing fund balance (line 1), the federal sharing funds received from the Department ofJustice and the Department of the Treasury (line 2), federal sharing funds received from state and Iocal law enforcement agencies and task forces (line 3), other income (line 4), and interest income (line 5). Enter on line 6 the total amount. Federal Sharing Funds Spent: Add items a through n. Enter the total amount on line 7. April 2005 Ending Equitable Sharing Fund Balance: Subtract the federal sharing funds spent (line 7) from the total equitable sharing funds (line 6). Enter on line 8 the ending balance. Appraised Value of Other Assets Received: Enter on line 9 the fair market value of any federally forfeited property received — e.g., if the fair market value of a car is $10,000, then enter $10,000 on line 9. Note: When the car is sold, proceeds from the sale must be deposited in your federal equitable sharing account and recorded as other income (line 4) in the year sold. Summary of Shared Monies Spent: Enter on lines a -n the total amount spent for each item listed. Total Spent on Drug Education and Awareness Programs: Enter on line j the total amount your agency spent conducting drug education and awareness programs. Total Spent on Other Law Enforcement Expenses: Enter on line k the total amount of expenses not listed in items a through j. Please provide a list of items purchased and the amount spent on the Federal Annual Certification Report Attachment. Total Transfers to Other State and Local Law Enforcement Agencies: Enter on Iine I the amount transferred to other state and local law enforcement agencies. Please provide a list of recipients, their address, and the amount transferred on the Federal Annual Certification Report Attachment. Before transferring funds, your agency must verify that the receiving agency has a current and valid Federal Equitable Sharing Agreement on file with both the Department of Justice and the Department of the Treasury. Total Permissible Use Transfers: The Department of Justice permits state and local law enforcement agencies to use up to 15 percent of shared funds received during the last two fiscal years to support drug abuse treatment, drug and crime prevention education, housing and job skills programs, or other nonprofit community-based programs or activities, which are formally approved by the chief law enforcement officer— e.g., chief, sheriff, or prosecutor — as being supportive of and consistent with a law enforcement effort, policy, and/or initiative. Law enforcement agencies may not transfer cash to non -law enforcement agencies or private nonprofit organizations. Law enforcement agencies may either 1) directly pay specific expenses on behalf of the recipient agency/organization or 2) reimburse the agency/organization by check for itemized expenditures. Enter on line m the total amount spent on behalf of non -law enforcement agencies and private nonprofit organizations. Please provide a list of recipients and the amount spent on the Federal Annual Certification Report Attachment. Amount Used for Drug Abuse and Prevention Programs: From line m, enter the total amount used for drug abuse treatment and prevention programs. Total Spent on Matching Grants: Enter on line n the amount of federal equitable sharing funds your agency spent to match grants. Please provide the name of grants matched and the amount spent to match each grant on the Federal Annual Certification Report Attachment. Your Agency's Budget for Current Fiscal Year: On line o, enter your agency's budget for the current fiscal year. If completing the certification for FY 2005, enter your agency's budget for FY 2006. Your Jurisdiction's Budget for Current Fiscal Year: Enter on line p your city/county/state's budget for the current fiscal year. If completing the certification for FY 2005, enter your jurisdiction's budget for FY 2006. Your Agency's Budget for Prior Fiscal Year: On line q, enter your agency's budget for the prior fiscal year. If completing the certification for FY 2005, enter your agency's budget for FY 2005. Your Jurisdiction's Budget for Prior Fiscal Year: Enter on line r your city/county/state's budget for the prior fiscal year. If completing the certification for FY 2005, enter your jurisdiction's budget for FY 2005. Law Enforcement Agency Head: The head of your law enforcement agency must sign and date the form. Name and title of the signatory must be printed or typed. Examples of law enforcement agency heads include police chief, sheriff, director, commissioner, superintendent, administrator, chairperson, secretary, city attorney, county attorney, district attorney, prosecuting attorney, state attorney, commonwealth attorney, and attorney general. For task forces, the law enforcement agency head is the person who oversees task force operations and may be the chief law enforcement officer of the lead agency — e.g., police chief or sheriff — or a commander, lieutenant, or captain who oversees task force April 2005 operations. By signing the Federal Annual Certification Report, the signatory certifies that this report is an accurate accounting of federal equitable sharing funds received and spent by the law enforcement agency during the reporting period. Governing Body Head: The head of your governing body must sign and date the form. Name and title of the signatory must be printed or typed. For purposes of this form, a governing body is the person or entity that has appropriations authority over your agency. That is, the governing body has legislative authority to approve your agency's annual budget. Examples of governing body heads include city manager, mayor, city council chairperson, county executive, county council chairperson, director, secretary, administrator, commissioner, and governor. In general, a law enforcement official should not sign as the governing body head. An exception will be granted for law enforcement officials that have appropriations authority over a task force. For task forces with a governing board, the board chairperson should sign as the governing body head. Task forces whose budgets are approved in the same manner as a city, county, or state law enforcement agency should obtain the signature of the appropriate official — e.g., city manager, mayor, etc. By signing the Federal Annual Certification Report, the signatory certifies that this report is an accurate accounting of federal equitable sharing funds received and spent by the law enforcement agency during the reporting period. Mail the Federal Annual Certification Report to the Asset Forfeiture and Money Laundering Section U.S. Department of Justice 10th and Constitution Avenue, NW Bond Building, 10`h Floor Washington, DC 20530 Fax: (202) 6I6-1344 E-mail address: afmls.aca(iD,usdoi.gov Departments of Justice and Treasury at: Executive Office for Asset Forfeiture U.S. Department of the Treasury 1341 G Street, NW Suite 900 Washington, DC 20220 Fax: (202) 622-9610 E-mail address: treas.aca@teoaf.treas.gov The original Federal Annual Certification Report should be sent to the Department from which your agency primarily receives shared funds. A copy should be sent to the other Department and to the U.S. Attorney in the district in which your agency is located. Additional copies of this report can be downloaded from the Department of Justice website at www.usdoj.gov/criminal/afrnls.html or the Department of the Treasury website at www.treas.gov/offices/enforcement/teoaf. April 2005 k. Other Law Enforcement Expenses Descr Cameras/Accessories MDVR12 Kit/Camera/Accessories MDVR12 Kit/Camera/Accessories MDVR12 Kit/Camera/Accessories DVR w/Covert Camera & accessor Software and installation Notification Module Software Quarter Master Module Software Analyst's Notebook License Acq Date Qty Cost 2007-09-29 1 $2,112.43 2007-09-29 1 $2,112.43 2007-09-29 1 $2,112.43 2007-09-29 1 $1,125.67 Cameras/Accessories Total 2007-09-29 1 $11,300.00 2007-09-29 1 $19,600.00 2007-09-29 1 $5,058.00 Software and Installation Total Digital Video Recorder implementation Flashback DVR w/Backseat Camer 2007-09-29 14 $4,167.22 Flashback DVR w/Backseat Camer 2007-09-29 4 $4,167.23 Flashback DVR w.Backseat Camer 2007-09-29 15 $5,415.00 Digital Video Recorder implementation Total Digital Video Recorder Back Office GS -2 2.4 GHZ Transmitter X 2 Planning Netwrk Implementation DVM Server Wireless External Antenna X 3 DVM Backup/Archive UPS/Software Config. Training 2007-09-29 1 $608.72 2007-09-29 1 $5,110.80 2007-09-29 1 $20,845.00 2007-09-29 1 $1,980.00 2007-09-29 1 $2,984.00 2007-09-29 1 $4,680.00 Digital Video Recorder Back Office Total $36,208.52 Total Justice Total Treasury Funds Funds $2,112.43 $2,112.43 $2,112.43 $1,125.67 $0.00 $0.00 $0.00 $0.00 $7,462.96 $11,300.00 $19,600.00 $5,058.00 $0.00 $0.00 $0.00 $0.00 $35,958.00 $58,341.08 $16,668.92 $81,225.00 $0.00 $0.00 $0.00 $0.00 $156,235.00 $608.72 $5,110.80 $20,845.00 $1,980.00 $2,984.00 $4,680.00 Audio Video Equipment Added as Part of Asset #071111 Praetorian 1-4000 1 20,734.88 DMR 5-500 w/ 500 GB 2007-09-29 1 1,037.13 Audio Video Equipment $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 20,734.88 1,037.13 $0.00 0.00 0.00 $21,772.01 $0.00 k. Other Law Enforcement Expenses Total $257,636.49 $0.00 TAB 2 TAB 2 - PAGE 1 City of Round Rock Audit Adjustments Fiscal Year 2007 1. Rollforward Fund Balance as of 09/30/2007 Federal Funds Beginning Fund Balance 10/01/2006 391,660.88 Income per TB 9/30/07 14,499.62 * Total Income Expenses per TB 9/30/07 Total Expense Fund Balance 9/30/2007 14,499.62 290, 571.05 290,571.05 * Income includes: Interest Income Federal Drug Seizure Funds Auction Proceeds 115, 589.45 9,901.46 85.66 4,512.50 TAB 2 -- PAGE 2 Fund 730 - Law Enforcement Fund Balance Net Period Balance 08/30/2007 Activity 09/30/2007 1110 730 00000 Pooled Cash Depository -45.80 2,305.15 2,259.35 1135 730 00000 Investment Pool TexPool 477.16 4.29 481.45 730 00000 Sub -Total - State Seizure Assets 431.36 2,309.44 2,740.80 730 00000 Sub -Total - State Seizure Liabilities 0.00 0.00 0.00 3501 730 Unreserved Fund Balance -172.39 0.00 -172.39 730 Sub -Total - Unallocated Fund Equity -172.39 0.00 -172.39 3501 730 00000 Unreserved Fund Balance -1,168.34 0.00 -1,168.34 730 00000 Sub -Total - State Seizure Fund Equity -1,168.34 0.00 -1,168.34 4610 730 00000 Interest Income -103.19 -4.25 -107.44 730 00000 Sub -Total - State Seizure Revenues -103.19 -4.25 -107.44 730 00000 Sub -Total - State Seizure Expenditures 0.00 0.00 0.00 1110 730 21004 Pooled Cash Depository 101,635.03 -26,194.66 75,440.37 1135 730 21004 Investment Pool TexPool 99,553.32 50,544.28 150,097.60 730 21004 Sub -Total - Local Seizure Assets 201,188.35 24,349.62 225,537.97 2511 730 21004 Accounts Payable -- System 0.00 -10,410.00 -10,410.00 2513 730 21004 Accounts Payable - PD Funds -3,386.23 0.00 -3,386.23 730 21004 Sub -Total - Local Seizure Liabilities -3,386.23 -10,410.00 -13,796.23 3501 730 21004 Unreserved Fund Balance -119,526.34 0.00 -119,526.34 730 21004 Sub -Total - Local Seizure Fund Equity -119,526.34 0.00 -119,526.34 4610 730 21004 Interest Income -4,954.03 -539.62 -5,493.65 4654 730 21004 State & Local Drug Seizure Fnd -130,247.79 0.00 -130,247.79 730 21004 Sub -Total - Local Seizure Revenues -135,201.82 -539.62 -135,741.44 6112 730 21004 Equipment and Machinery 7,793.62 10,410.00 18,203.62 6116 730 21004 Computer Equipment 6,447.79 0.00 6,447.79 6127 730 21004 Computer Software 17,582.00 0.00 17,582.00 730 21004 Sub -Total - Local Seizure Expenditures 31,823.41 10,410.00 42,233.41 1110 730 21021 Pooled Cash Depository 1135 730 21021 Investment Pool TexPool 730 21021 Sub -Total - Federal Seizure Assets 2511 730 21021 Accounts Payable - System 730 21021 Sub -Total - Fed Seizure Liabilities 3116 730 21021 Reserve for FED Drug Seizure 730 21021 Sub -Total - Fed Seizure Equity 4610 730 21021 Interest Income 4665 730 21021 Federal Drug Seizure Funds 730 21021 Sub -Total - Fed Sezure Revenues 6112 730 21021 Equipment and Machinery 6115 730 21021 AudioNisual Equipment 6116 730 21021 Computer Equipment 6127 730 21021 Computer Software 730 21021 Sub -Total - Fed Seizure Expenditures Fund 730 Total BOXED AREA Is Federal Portion ONLY 56,459.88 166,530.37 222, 990.25 -81,225.00 -81,225.00 -391,660.88 -391,660.88 -9,416.57 -85.66 -9,502.23 42, 043.37 207,458.88 5,110.80 30,900.00 285,513.05 -57,345.57 -49,509.73 -106,855.30 76,167.00 76,167.00 0.00 0.00 -484.89 0.00 -484.89 0.00 0.00 0.00 5,058.00 5,058.00 -885.69 117,020.64 116,134.95 -5,058.00 -5,058.00 -391,660.88 -391,660.88 -9,901.46 -85.66 -9,987.12 42,043.37 207,458.88 5,110.80 35,958.00 290,571.05 0.00 0.00 0.00 TAB 2 - PAGE 3 TRANSACTION DATE 09/30/07 ACCOUNT# 13100-730-21004 DATE PREPARED 01/08/08 DESCRIPTION R/C Auction Commission from F100 DEBITS 4639-730-21004 I1 11 13, 375.50 PAGE NO 1 1 1 CREDITS 4639-100-00000 II 22730-100-00000 11 11 13,375.50 3,375.50 13,375.50 13100-730-21021 RIC Auction Commission from F100 4639-730-21021 4639-100-00000 22730-100-00000 11 :. If 11 4,512.50 4,512.50 4,512.50 4,512.50 EXPLANATION: Audit Adj for additional LE revenue 35,776.00 35,776.00 *Federal Portion from Account 22730-100-00000 in the amount of $4,512.50 LE_Federal_Rpt.xfs (NI W 0 v w O) 0 0 0 N: s � w w waw w1w a aOt0)0)10) N N NECV N N 99!91ch o- 61m 0) 09 0) 9 N. i n. o o:o`o olo N N'NiN NiN H 0 0 a) L7 CD L m 2 co 0 0 0 0 N N N O N N O N 0 0 0 ,-- N 0(0 NIN M ti c) a)jw EEErE co O CU co U 0 UU ca co ca m w 0 Y Y Y 1FY RI 03 Cir CU MCOCOM 3 3 33 O O Ce W WILL N N > » Cr] . C_❑❑❑i❑ 11) (0 _se - YfY �l 0 0 U, C6 cu cut Ca Q .0 .0 L rn N U) to co m as 0) Cr) !Luwt;_ i N.N... i rs• , ,J m m.m m m0 01. orio 0 N 0 s -- N 0 M ti N O t• O 00 O a 00 CD 00 O 0.0 o O 00 O Cr) (0 0 10 r` 0 ti 0) (D O 0 O 0 O 0 0 0 rti O N LC) CD O 0 0 O O 0 0 0 N ti 0 M (00 f` 0 O 0 ON-( 0O00100 000+0 O 0O 0�0 00010 O O ID f 0 000 0 t EN 411212 0 00 cap00p O 0'O 0 0'O 0 OHO S O C0 LC) CO N- 0,00 0 (00 10 (00 (0a o 0) 0 CC) 0) 0 CD CD CD CD 0) 0l0(0 0 0 010;0 0 ID OiO'O 0 0 O O E O O O 01010 0 o 0.0ra a 0 oiaio o ti O t00 0 (0 a a 0 O) 0) O O0) 00) to 0) LC) 0 CD 0 0 0 0 0 CD 00 O 0 a 0 0 0o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 CD 0 0 0 0 0 0 0 0 0 0 a 0 0 03 0 0 0 O CD CD (0 0 0 0 O 00 O O 0 8 0 O 0 0 O 0 0 0 0) 0 co 0 O 0 O O 0 0 0 CO Cr) CO CD (0 C0 O CD a 0 0 a 0 0 0 0 LE_Federat_Rptxis Ln a N CV 104 N N'•N N N1N N Cl NIN N NIN N NIN�N A AIA A A1A A AiA A +.+ CO CD i CO (O CO I CD CO CD i. CD CO (0 r 1-- .1-- r rcr r r i r I-- 0 U v 1 -cr cr vkr" Ni Nr nr v • COO COO(OO COD (O0 (OD (0 (0O (0O (0 COOo .J NN N Cr) M MI0 °ti NN t` N N U (DI(D colco v CO Cr 'r VIO tN 0 0) 111 0 0 0 crs 0 Ca 0 0 0 0. 0 , 0 C LL. L co ea E Z 0 O (0 (0 Q 0 co 0 0 CO (0 co O 0 0) 0 CO 0 0 0) N 0 CO 0) N 0) O O 0 a) mE U (0 co 0 (0 0) 0) O ti a O N w rn N O a ti 0 O N w 0) (.11 0) O 0 0 N w 0) cV 0) O ti 0 O N w 0) 0) co 0 N w 0 N O 0 1` 0 O N w 0) N 0) 0 O 0 N 0) 0) CV C11 0 O o 0 N N w 0) 0) 0 ti 0 0 N 0 O co (0 CO (r) ! t wwwwwwlw nIn 0 4 0) (V 0) 0 O 0 N 0) N •O O co 0 N mE 3� 3 00 .0 .0 L (0 CD a) U cts Y 0 co CL) CO U a) (0 U al CU 11) i0 ti) LI 0 00 CU CO CO � 3 0 0 .0 .0 _C - CO CO (0 U (o m U3 a) m U (U a) 3" 3 00 .0 JO (" to CU CO CD m U a) U CU N m a3 a) C.) C.) CO CO N U3 Cu 03 3133 CY. 0 0 0 .0.0.0 N N Ca t3 (U CU co (U LL. LL LL LL 1L LL ().. l.L LL LL LL II ..r.(rrr1�--,-. 00000000100 T- r IN-- 1— N NNN(VNNNNN U U 03 U 0 0 Oi0 N d I d, 919 N N N CI) iCI) 919 NN O 0 (r) 0 co 0 a to to 0 (0 0000 O o o a tri tri tri tri ;f tT ;t ti to tri tri 0 (D 0 tO 00000Qf01Oo 0 0 0 0 0 OiO,O co u) to (1) to in (1) I[ 10 1 tri 'Ai 'TT ;1-- ;1;1;7_ rr rr'r 7 tri to to to u7 Lo O in I to (0 (0 0 1 0) 0 0 0 N 0 M 0 M a M ti • o COD CCD 0 0 M I` N 0 0 M Cr) CO ti ti (r` ti t- o Iola co C) NTr 1.0 (O (0 0.0 0 0 O,0 010 0fo CO (D 0 o 0 00 mm m 1`�r• L).. 0 .0 L N (0 LL. LL. NININ N N 00 0 0 0 N N N N N 0 0 0 ti N 0 M 0 0 AA 00 N N N 0) O 0 0 N O) um Olo t NIN w 0) N C)) O 1- O 0 N O (O ww nm 0)10 t N1N O' jO 1`t1` 0 0 CV 1N O (D 0 (O 0 I CD((D w wiwfw w 2 21212 2 0 N 0) O 0r` O N O!CM !CD N?NiN 0)'0)I0) 0!010 Of:10 0`010 NINfN 0) N Q) 0 ti a 0 N 0 (D 0 O O CO w 0) 0) O 0 0 N w 0) O) 0 0 0 w 0) CV 0) 0 1'— 0 O N O 4) a) a) U) a) a) a) I 0 t a) a3 0 a) a) O((0EE(EU((00(Ea0(EEEIEEEEE N 1 CO CU cu CU CU 000000000100000 a) Q) 03 N Q) a) I CU I CU CU Ca ITI0) (U Ca CU CD DS CU 0 CD CDCD U) U) ) U) U) CO U) ' (01 U) N CO U) Y YYY.)L-IG- - . . .) Y Y Y Ca 0 0 0 U C) 0 0 0 0 U 0(3 0 (ti CU Ca Ca Ca Ca (0 CU CO ca a) (U m CU IX) CD CO CO O O CO CO CD CO 00 .0 CO 3 3 3 3 3 3 3 3 3 3 3I§ 3 3 CL' W CY CL W W W W W W W Er CG X » » » » » » » O 0000000000000 ta Y Y .0 -5 -C X .X .`6 U Z U t1 U (-) U U t) U U v v CD .0 .a .O .0 .0 .0 .0 .0 .0 .p • Q .0 -0 ..D .0.0.0 - .0 .0 .0 -C .0 .0 .0.0 .0 r CU (0 1 (U N CU 1 (o CO CU 1 N i in In in Ca CU LL U.411. U. LL 1 LL U LL 0.1.. ILL LL U.. LL - r r r- .. r r r rIr 000000000000 N N OoiOoo v.)M°M M ti (ti "cfn titN-N.(0 coCy) Nt CCOO1CO CO CD CD (D CD CO CO O CO CD ! CO A A A A A A A A r• ti 11'- 0 0 0 0 0 0 0 0 0 C) N000000000a co 1� 0 0) 0 r CV en Nr CD CV N N N N NCV CO CO CD CO CD CO CD CD CDCDCC) COCOa:CDCO 0 0 0 0 0 010 0 000000,00 0 0 0 0 O o 0 0 0 0 0 0 0 p 0 0 0 0 0 0 0 810 O 0 0 0 00 010 0 O 0 0 010 010 0 (D (0 (D (O (0 CO CD CD o10co o 00 010 coO o 0 (0 0 0 010 0 0 N 0 M ti LI) CD 03 CO I CO CO CO (Dim CD(O N- 1N- N- CD10 0 0 t`fCIO O r CV CV I CV (00 Ito (MD ( C MD MO CD 1 CD CD CO CO 010/0 0 0 80!000 0 010 0 0 000000 0 0 0 0 0 0 co 0 010 N N a (r) ti 0r - N 0 M r• N 0 Cr) 1- 0) 0 r CV C70 (CA Cr) 0) CO1 CD CO CO r•$1,. tit` 010 0 O M M 0 8 0 a 0 0 0 0 to CD CO O 0 0 00 0 0 0 00 N 0 M M O) CO N N M COcr CI) CO OO rfrlr 01010 r NWN 0 (Mi(r) (r) tilh;ti r- 11 �1 N' 0( N( 0 0 (0 cO A A N N- A O O 010 0 CO (r3 (0 0 0 O 0 0 0 0 I` O 0) 0 (') Cr) (r) �r CD COCC 0 0 0 O 0 0 0 O O 0 0 CO 00 000 ca 0 0 0 CD CIO O 0) CO O (0 (0 0 0 0 a 0 O) O (D )-- co N (0 co 0 0 0 0 0 0 0 O a ti 0 0 0 (r) 0) tt CV 10 GOOD O O 0 0 000 0 0