REPORT DIGEST

DEPARTMENT OF MILITARY AFFAIRS

FINANCIAL AND COMPLIANCE AUDIT

For the Two Years Ended:
June 30, 2000

Summary of Findings:

Total this audit 5
Total last audit 3
Repeated from last audit 1

Release Date:
April 26, 2001

Logo.gif (1870 bytes)

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
Attn: Records Manager
Iles Park Plaza
740 E. Ash Street
Springfield, IL 62703

(217)782-6046 or TDD (217) 524-4646

This Report Digest is also available on
the worldwide web at
http://www.state.il.us/auditor

 

 

 

 

 

 

 

SYNOPSIS

 

 

  • The Department incorrectly calculated its accounts receivable and did not maintain appropriate accounts receivable records.
  • The Department did not appropriately account for transactions within one of its funds.

 

 

 

 

 

 

 

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

 

 

 

 

ILLINOIS DEPARTMENT OF MILITARY AFFAIRS
FINANCIAL AND COMPLIANCE AUDIT
For The Two Years Ended June 30, 2000

EXPENDITURE STATISTICS

FY 00

FY 99

FY 98

Total Expenditures (All Funds)

$26,187,153

$24,565,882

$22,873,543

OPERATIONS TOTAL

% of TOTAL Expenditures

$25,363,056

96.9%

$23,414,417

95.3%

$21,629,935

94.6%

Personal Services, including reimbursable positions

% of Operations Total Expenditures
Average No. of Employees

$10,587,153


41.7%
271

$10,210,284


43.6%
264

$9,875,234


45.6%
269

Other Payroll Costs (FICA, Retirement)

% of Operations Total Expenditures

$1,337,702

5.3%

$1,245,530

5.3%

$1,032,630

4.8%

Contractual Services

% of Operations Total Expenditures

$2,054,032

8.1%

$2,112,086

9.0%

$1,975,638

9.1%

Lincoln’s Challenge

% of Operations Total Expenditures

$7,809,078

30.8%

$6,860,034

29.3%

$6,076,398

28.1%

Facilities Operations and Maintenance

% of Operations Total Expenditures

$3,120,626

12.3%

$2,569,976

11.0%

$2,213,150

10.2%

All Other Items

% of Operations Total Expenditures

$454,465

1.8%

$416,507

1.8%

$456,885

2.2%

CAPITAL PROJECTS
% of TOTAL Expenditures

$79,407
.3%

$279,768
1.1%

$10,513

.1%

AWARDS AND GRANTS TOTAL
% of TOTAL Expenditures

$526,119
2.0%

$687,623
2.8%

$995,601

4.3%

NON-APPROPRIATED FUNDS
Armory Rental Fund (416)
% of TOTAL Expenditures


$218,571
.8%


$184,074
.8%


$237,494
1.0%

Cost of Property and Equipment

$121,627,481

$119,178,218

$118,948,927

CASH RECEIPTS

FY 00

FY 99

FY 98

Federal Reimbursements

$13,057,831

$11,620,974

$12,632,953

Grant - First Choice

0

0

18,018

Grant - Lincoln’s Challenge

500,000

500,000

1,000,000

Sales of Property

0

465,987

0

Other

249,030

286,412

246,279

Total

$13,806,861

$12,873,373

$13,897,250

AGENCY DIRECTOR

During Audit Period: Adjutant General Richard Austin (through July 1999)
Adjutant General David Harris (August 1999)
Currently: Adjutant General David Harris

 

 

 

 

 

 

 

 

 

Accounts receivable for the General Revenue Fund and the Federal Support Agreement Revolving Fund were understated in both FY99 and FY00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The Department did not adhere to SAMS procedures or the appropriation in the administration of its Federal Support Agreement Revolving Fund

 

 

 

 

 

 

 

 

INTRODUCTION

The Department of Military Affairs was established by the Military Code of Illinois (20 ILCS 1805 et seq.). The Department acts as the channel of communication between the federal government and the State of Illinois on all matters pertaining to the State Military. The Adjutant General prepares and executes plans for organizing, supplying, equipping, and mobilizing the Organized Militia for use in national defense, State defense, and emergencies.

FINDINGS, CONCLUSIONS, AND RECOMMENDATIONS

INACCURATE ACCOUNTS RECEIVABLE REPORTING

The Department incorrectly calculated its accounts receivable for financial reporting purposes and did not maintain appropriate accounts receivable records.

During our review of the Generally Accepted Accounting Principles (GAAP) form packages submitted to the State Comptroller and detailed Department records, we noted the accounts receivable for both the General Revenue Fund and the Federal Support Agreement Revolving Fund were inaccurate. The Department did not maintain adequate records of amounts billed and the corresponding collections in order to compile an accurate record of accounts receivable. Instead, the Department reported only the amounts received in the month after the end of the quarter as receivable.

Statewide Accounting Management System (SAMS) Procedures state that accounts receivable should be recognized when the State's claim for future cash is reasonably estimable and the amount due becomes measurable.

The FY99 ending balances in the GAAP packages were understated by approximately $550,000 for the General Revenue Fund and by $535,000 for the Federal Support Agreement Revolving Fund. The FY00 ending balances in the GAAP packages were understated by approximately $560,000 for the General Revenue Fund and by $555,000 for the Federal Support Agreement Revolving Fund. (Finding 1, page 12)

Department personnel concurred with our recommendation to follow SAMS criteria regarding revenue recognition and agreed to keep more detailed records for accounts receivable.

INAPPROPRIATE ACCOUNTING FOR TRANSACTIONS RELATED TO FEDERAL REIMBURSEMENTS AND EXPENDITURES

The Department did not appropriately account for transactions within the Federal Support Agreement Revolving Fund.

During our reconciliation of the fund by program, we noted the Department paid a total of $306,364 out of the wrong appropriation code. Lincoln's Challenge Program payroll expenditures totaling $297,932 and Joint Armed Forces Reserve Center expenditures totaling $8,432 were paid from the Cooperative Funding Agreement appropriation.

We also noted during our reconciliation that federal reimbursements were deposited into the wrong account. Two Army/Air deposits totaling $122,139 were recorded using the Cooperative Funding Agreement account code.

In all cases where exceptions were noted, the Department did not adhere to the procedures outlined in the Statewide Accounting Management Systems (SAMS) Manual regarding the classification of expenditures and receipts by appropriation code or type. Furthermore, by not assigning the correct appropriation code to all expenditures, the Department did not expend its funds for the intended purposes specified by the General Assembly in the Department's appropriation. (Finding 2, pages 13 - 14)

The Department agreed with our recommendation to strengthen controls over federal reimbursements and expenditures. Department personnel stated they have developed a detailed accounting procedure to track federal expenditures and receipts for each of the four Federal Reimbursable Funding Agreement accounts to ensure compliance with the appropriation authorization.

OTHER FINDINGS

The remaining findings are considered less significant and corrective action is in process. We will review progress towards the implementation of our recommendations in our next audit.

Responses were provided by the Department’s Adjutant General, David Harris.

AUDITOR’S OPINION

Our auditors state that the Department’s fiscal year 2000 and 1999 financial statements for nonshared funds are fairly presented in all material respects.

_____________________________________

WILLIAM G. HOLLAND, Auditor General

WGH:KAL:vh

AUDITORS ASSIGNED

This audit was performed by the Auditor General's staff.