REPORT DIGEST

 

PRAIRIELAND ENERGY, INC.

 

COMPLIANCE EXAMINATION

For the Two Years Ended:

June 30, 2006

 

Summary of Findings:

Total this audit                          3

Total last audit                          2

Repeated from last audit           1

 

Release Date:

March 8, 2007 

 

 

State of Illinois

Office of the Auditor General

WILLIAM G. HOLLAND

AUDITOR GENERAL

 

To obtain a copy of the Report contact:

Office of the Auditor General

Iles Park Plaza

740 E. Ash Street

Springfield, IL 62703

(217) 782-6046 or TTY (888) 261-2887)

 

This Report Digest and Full Report are also available on

the worldwide web at

http://www.state.il.us/auditor

 

 

 

 

SYNOPSIS

 

  • The Company did not have adequate accounting records of sales and accounts receivables related to sales of energy to private individuals and companies.

 

  • The Company did not require all employees to submit time sheets as required by the State Officials and Employees Ethics Act.

 

  • The Company used University of Illinois facilities, assets, services, and resources without consideration paid to the University.  The University and the Company were not tracking the expenses incurred by the University on behalf of the Company until it was brought to their attention as a result of the audit.  In addition, the transactions were not initially recorded on the financial statements of the Company.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

{Expenditures and Activity Measures are summarized on the reverse page.}


 

 

PRAIRIELAND ENERGY, INC.

COMPLIANCE EXAMINATION

For the Years Ended June 30, 2006

 

FINANCIAL OPERATIONS

FY 2006

FY 2005

OPERATING REVENUES

      Steam Sales...............................................................

      Chilled Water Sales...................................................

      Hot Water Sales........................................................

      Electricity Sales.........................................................

      Budget allocation University of Illinois.........................

            Total...................................................................

 

OPERATING EXPENSES

      Energy Cost Adjustment............................................

      Facilities Rental..........................................................

      Salaries                                                                     

      Office Rent................................................................

      Other........................................................................

            Total...................................................................

 

NONOPERATING REVENUES (EXPENSES)

      Interest......................................................................

      Other........................................................................

      Income Tax Credit (Expense)....................................

            Total...................................................................

 

INCREASE (DECREASE) IN NET ASSETS................

NET ASSETS - Beginning of Year..................................

NET ASSETS - End of Year...........................................

 

 

$7,324,034

2,246,063

   3,750,328

335,680

21,210

$13,677,315

 

 

$10,845,009

2,903,880

46,593

13,596

        89,504

$13,898,582

 

 

$9,107

(514)

70,002

$78,595

 

$(142,672)

$870,422

$727,750

 

$6,556,847

1,566,845

   2,871,692

86,427

0

$11,081,811

 

 

$7,430,498

2,903,970

44,772

14,400

        27,328

$10,420,968

 

 

$3,728

1,920

(202,209)

$(196,561)

 

$464,282

$406,140

$870,422

 

SELECTED ACCOUNT BALANCES

AT JUNE 30,

2006

AT JUNE 30,

2005

Cash..............................................................................

Accounts Receivable......................................................

Accounts Payable...........................................................

Deferred Income Taxes Payable.....................................

$197,509

$656,587

$100,133

$235,642

$156,493

$789,511

$8,962

$315,872

 

CORPORATION PRESIDENT

During Audit Period and Currently:  Mr. Lyle Wachtel


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Inadequate accounting records

 

 

 

 

 

 

 

 

 

 

 

 

 

Accrual basis of accounting recommended

 

 

 

 

 

 

 

 

 

 

 

 


Non compliance with State Officials and Employees Ethics Act

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Violation of University Guidelines

 

Transactions were not recorded until the issue was brought to their attention by the audit

 

 

 

 

 

 

 

 

 

 

Estimated resources used $20,510

 

 

 

 

 

 

 

University Guidelines Requirements

 

INTRODUCTION

 

      Prairieland Energy, Inc. is an Illinois corporation formed and wholly owned by the Board of Trustees of the University of Illinois.  Prairieland was formed November 19, 1996 for the purpose of producing, acquiring and selling various forms of energy for the University and other customers.

 

FINDINGS, CONCLUSIONS, AND RECOMMENDATIONS

 

INADEQUATE SALES AND ACCOUNTS RECEIVABLE RECORDS

 

The Company did not have adequate accounting records of sales and accounts receivable related to sales of energy to private individuals and companies. 

 

Prairieland Energy entered into agreements with several private individuals and companies to provide electricity, steam and chilled water starting in October 2004.  The Company maintains its accounting records on a cash basis and used an informal excel spreadsheet to track the activity related to these energy sales. The Company did not have an accounts receivable subsidiary ledger that kept track of amounts owed to the Company for energy sales. Energy sales were recorded based on deposits reflected on the Company bank statements and not based on a detailed sales or cash receipts journal.    (Finding 1, page 9)

 

        We recommended the Company maintain its accounting records on the accrual basis and establish an accounts receivable subsidiary ledger, sales journal, and cash receipts journal. 

 

        The Company acknowledged the need to have adequate accounting records for its activities and stated that they are in the process of converting accounting processes to an accrual basis and will establish the appropriate ledgers and journals for FY 2007.

 

 
 
TIME SHEETS NOT REQUIRED

 

        The Company did not require all employees to submit time sheets as required by the State Officials and Employees Ethics Act (Act).

 

        The Act required the Illinois Board of Higher Education (IBHE), with respect to State employees of public universities, to adopt and implement personnel policies.  The Act (5 ILCS 430/5-5(c)) states, “The policies shall require State employees to periodically submit time sheets documenting the time spent each day on official State business to the nearest quarter hour; contractual State employees may satisfy the time sheet requirement by complying with the terms of their contract, which shall provide for a means of compliance with this requirement.”  The IBHE adopted personnel policies for public universities on February 3, 2004 in accordance with the Act.  The company has not incorporated these policies into the Company’s policies.

 

        We noted the Company’s employee, who was paid a salary, did not submit time sheets in compliance with the Act.

 

        Company personnel stated they were not aware this was a requirement for this University subsidiary. (Finding 2, Page 10)

 

        We recommended that the Company amend its policies to require all employees to submit time sheets in compliance with the Act.

 

        The Company stated that they will monitor the University’s progress, coordinate with the University on any proposed solution(s), and determine what additional actions the Company may be required to take to comply with the Act.

 

USE OF UNIVERSITY RESOURCES

 

      The Company used University of Illinois facilities, assets, services, and resources without consideration paid to the University.  The University and the Company were not tracking the expenses incurred by the University on behalf of the Company until it was brought to their attention as a result of the audit.  In addition, the transactions were not initially recorded on the financial statements of the Company.

 

        The Company was formed on November 19, 1996 and is a component unit of the University of Illinois.  The Company is recognized by the University as a University Related Organization (URO) pursuant to a contract between the University and the Company.

 

        During the year ended June 30, 2006 the Company received legal services and management oversight for which the University failed to bill the Company or to charge the cost of these expenses to the Company’s ledger account.  As a result, the Company did not provide any consideration to the University for these resources provided by the University.  Total resources used for the year ended June 30, 2006 were estimated to be $20,510.  This amount was subsequently recorded on the Company’s Statement of Revenues, Expenses and Changes in Net Assets as revenue and as an expense.

 

        University Guidelines adopted November 30, 1982, (as amended September 10, 1997) by the Legislative Audit Commission, Section VI, University Related Organizations, Subsection E: Use of University Facilities state that the University may allow the University Related Organization to use University facilities, assets, services, and resources provided that such use is supported by consideration at rates charged other University users, if such charges are regularly made, or at the cost of furnishing such services if no internal charges are in existence.

 

        Further, Subsection F, requires that the University budget processes or the contract will expressly identify all support provided the URO.  Revenue accounts will be maintained to identify all payments received from the URO for repayment of funds advanced and as reimbursement for the use of university assets, facilities or services.  If the URO maintains separate financial records, companion entries will, of course, appear in these records as well.

 

        Company personnel stated they felt the use of University resources was covered in the lease agreement currently in place.  The Company was not aware that a specific accounting of each service was required beyond the existing lease provisions. (Finding 3, Pages 11-12)

 

        We recommended that the Company work with the University to establish a system for tracking the use of University resources and that appropriate amounts be recorded on the Company’s financial statements.

 

        Company personnel stated that they will monitor and track University resource use and account for it more directly in FY 2007.

 

       

AUDITORS’ OPINION

 

Our financial audit for the year ended June 30, 2006 was previously issued.

 

Our auditors stated the Corporation’s June 30, 2006 financial statements are fairly presented in all material respects.

 

 

 

 

____________________________________

WILLIAM G. HOLLAND, Auditor General

 

WGH:TLK:pp

 

SPECIAL ASSISTANT AUDITORS

 

Our special assistant auditors were Clifton Gunderson LLP.