ROLLING PRAIRIE LIBRARY SYSTEM CONTENTS June 30, 2003 INDEPENDENT AUDITORS’ REPORT ON THE FINANCIAL STATEMENTS 1 INDEPENDENT AUDITORS’ REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMEN TS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS 2 General Purpose Financial Statements: Combined Balance Sheet - All Fund Types and Account Groups 3 and 4 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - All Governmental Fund Types 5 - 7 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual - All Budgeted Governmental Fund Types 8 - 13 Combined Statement of Revenues, Expenses and Changes in Retaine d Earnings - All Proprietary Fund Types 14 Combined Statement of Cash Flows - All Proprietary Fund Types 15 Notes to Financial Statements 16 - 25 SUPPLEMENTAL FINANCIAL INFORMATION Combining Statements - Governmental Fund Types: Combining Balance Sheet - Special Revenue Funds 26 and 27 Combining Statement of Revenues, Expenditures and Changes in Fund Balances - Special Revenue Funds 28 and 29 - Budget and Actual - Budgeted Special Revenue Funds 30 ROLLING PRAIRIE LIBRARY SYSTEMCOMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPSJune 30, 2003Governmental TypesSpecial Capital General Revenue ProjectsASSETSCash $ 6 ...
ROLLING PRAIRIE LIBRARY SYSTEM CONTENTS June 30, 2003 INDEPENDENT AUDITORS’ REPORT ON THE FINANCIAL STATEMENTS INDEPENDENT AUDITORS’ REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMEN TS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDSGeneral Purpose Financial Statements: Combined Balance Sheet - All Fund Types and Account Groups Combined Statement of Revenues, Expenditures and Changes in Fund Balances - All Governmental Fund Types Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual - All Budgeted Governmental Fund Types Combined Statement of Revenues, Expenses and Changes in Retaine d Earnings - All Proprietary Fund Types Combined Statement of Cash Flows - All Proprietary Fund Types Notes to Financial Statements SUPPLEMENTAL FINANCIAL INFORMATION Combining Statements - Governmental Fund Types: Combining Balance Sheet - Special Revenue Funds Combining Statement of Revenues, Expenditures and Changes in Fund Balances - Special Revenue Funds Combining Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual - Budgeted Special Revenue Funds
1
2
3 and 4 5 - 7 8 - 13
14 15 16 - 25
26 and 27 28 and 29
30
ROLLING PRAIRIE LIBRARY SYSTEM COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS June 30, 2003
ASSETS Cash Investments Accounts receivable Grants receivable Due from other funds Prepaid expenditures Fixed assets (net of accumulated depreciation) TOTAL ASSETS LIABILITIES AND FUND EQUITIES Liabilities: Accounts payable Accrued payroll Due to other funds Total liabilities Fund Equities: Investment in general fixed assets Retained earnings Fund balance - unreserved Fund balance - reserved for encumbrances Total fund equities TOTAL LIABILITIES AND FUND EQUITIES
ROLLING PRAIRIE LIBRARY SYSTEM COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - - ALL GOVERNMENTAL FUND TYPES Year ended June 30, 2003
Revenues: State grants: Area and per capita grant Other grants Federal grants Interest income Other revenue Total revenues Expenditures: Salaries and wages: Library professionals Other professionals Support services Payroll taxes and fringe benefits: Social security/Medicare IMRF Unemployment taxes Workers' compensation insurance Health, life and dental insurance Other Library materials: Printed materials Building and grounds: Utilities Insurance - building Repair and maintenance - building Janitorial supplies Other Delivery: Gas and oil Repair and maintenance - vehicles Insurance - vehicles Other
ROLLING PRAIRIE LIBRARY SYSTEM COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - - ALL GOVERNMENTAL FUND TYPES (Continued) Year ended June 30, 2003 General Special Fund Revenue $ 6,553 1,281 2,785 700 266 469 1,971 62 2,372 3,004 7,112 39 (303) 2,156 5,745 1,602 663 409 1,770 1,745 5,200 2,140 213 30 503 16,433 155,905
Expenditures, continued: Travel and continuing education - staff/board: In-state travel Out-of-state travel Registration Continuing education and meetings - other: Honoraria Materials and supplies Speaker travel Meeting expenses Public relations Insurance - liability Supplies, postage, printing: Computer supplies Office supplies Library supplies Postage Printing and copying Telephone: Local and long distance Telecommunications Equipment rental, repair and maintenance: Equipment rental Equipment repair and maintenance Maintenance agreements Insurance - equipment and EDP Professional services: Accounting Legal Consulting Contractual services: Central data processing Agreements with libraries/other co-ops Other
ROLLING PRAIRIE LIBRARY SYSTEM COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES -- ALL GOVERNMENTAL FUND TYPES (Continued) Year ended June 30, 2003
Expenditures, continued: Member reimbursements Miscellaneous Capital outlays: Equipment Computer equipment Computer software Total expenditures Excess (deficiency) of revenues over (under) expenditures Other financing sources (uses): Transfers in Transfers out Total other financing sources (uses) Excess (deficiency) of revenues and other sources over (under) expenditures and other uses Fund balances, beginning of year Fund balances, end of year
See Notes to Financial Statements.
Capital General Special Projects Fund Revenue Fund 2,430 7,995 1,977 4,281 1,100 1,167 870,192 157,154 -37,868 (145,373) 6,129 49,385 (49,385) (49,385) - 49,385 (11,517) (145,373) 55,514 266,017 150,569 457,380 $ 254,500 5,196 512,894
ROLLING PRAIRIE LIBRARY SYSTEM COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - ALL BUDGETED GOVERNMENTAL FUND TYPES Year ended June 30, 2003
Revenues: State grants: Area and per capita grant Other grants Federal grants Interest income Other revenue Total revenues Expenditures: Salaries and wages: Library professionals Other professionals Support services Other Payroll taxes and fringe benefits: Social security/Medicare IMRF Unemployment taxes Workers' compensation insurance Health, life and dental insurance Other Library materials: Printed materials Building and grounds: Utilities Insurance - building Repair and maintenance - building Janitorial supplies Other Delivery: Gas and oil Repair and maintenance - vehicles Insurance - vehicles Other
- 8 -
General Fund Variance -Favorable Budget Actual (Unfavorable)
Special Revenue Funds Variance -Favorable Budget Actual (Unfavorable)
15,800
15,800
-
(15,800)
(15,800)
Capital Projects Fund Variance -Favorable Budget Actual (Unfavorable)
12,500
12,500
- 9 -
6,129
6,129
(6,371)
(6,371)
ROLLING PRAIRIE LIBRARY SYSTEM COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - ALL BUDGETED GOVERNMENTAL FUND TYPES (Continued) Year ended June 30, 2003
Expenditures, continued: Travel and continuing education - staff/board: In-state travel Out-of-state travel Registration Continuing education and meetings - other: Honoraria Materials and supplies Speaker travel Meeting expenses Other Public relations Insurance - liability Supplies, postage, printing: Computer supplies Office supplies Library supplies Postage Printing and copying Telephone: Local and long distance Telecommunications Equipment rental, repair and maintenance: Equipment rental Equipment repair and maintenance Maintenance agreements Insurance - equipment and EDP Professional services: Accounting Legal Consulting Contractual services: Central data processing Agreements with libraries/other cooperatives Other