REPORT DIGEST DEPARTMENT OF MILITARY AFFAIRS FINANCIAL AND COMPLIANCE AUDIT For the Two Years Ended: Summary of Findings: Total this audit 5 Release Date: State of Illinois WILLIAM G. HOLLAND AUDITOR GENERAL To obtain a copy of the Report contact: (217)782-6046 or TDD (217) 524-4646 This Report Digest is also available on |
SYNOPSIS
{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 |
|||
$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 |
$10,587,153
|
$10,210,284
|
$9,875,234
|
|||
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% |
|||
Lincolns 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 |
$79,407 |
$279,768 |
$10,513 .1% |
|||
AWARDS AND GRANTS TOTAL |
$526,119 |
$687,623 |
$995,601 4.3% |
|||
Armory Rental Fund (416) % of TOTAL Expenditures |
|
|
|
|||
$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 - Lincolns 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) |
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 Departments Adjutant General, David Harris. AUDITORS OPINION Our auditors state that the Departments 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. |