Understanding the Auditors Quarterly Report For reporting purposes, - - PowerPoint PPT Presentation

Understanding the Auditor’s Quarterly Report

GENERAL FUND OTHER FUNDS

• 1. Special Reserve
• 2. SAO Domestic Violence
• 3. Environmental Prosecution
• 4. Economic Development
• 5. Cost Share Drainage
• 6. Public Building Commission *

For reporting purposes, the General Fund and six other funds are combined. The General Corporate Fund is the main

• perating fund of the County.

GENERAL FUND ANNUAL BUDGET YEAR-TO-DATE

Revenues $ 76,054,792 22,016,415 Expenditures & Encumbrances 75,396,435 36,465,265 Excess (Deficiency) Revenues over Expenditures 658,357 (14,448,050) Other Financing & Net Transfers In (Out) (658,357) (1,824,910) Less: Encumbrances Included Above 542,290 Net Change in Fund Balance (15,731,470) General Fund Balance, Beginning of Year 55,695,106

GENERAL FUND BALANCE, END OF QUARTER

$ 39,963,636

$0 $10 $20 $30 $40 $50 $60 $70 $80 Annual Budget Thru 1st Quarter Thru 2nd Quarter Millions

General Fund Revenues Annual Budget Compared to Actual Quarter-To-Date Through Each of the First Two Quarters of Fiscal Year 2013

All Other Fines Reimbursements Charges for Services Other Taxes Property Taxes * All Other includes Licenses & Permits, Grants, Interest and

• ther Misc. Revenues

*

This chart includes all budgeted revenue items except opening cash on hand of $1.766M

$0 $5 $10 $15 $20 $25 $30 $35 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 $21.20 $20.69 $21.77 $24.50 $26.90 $30.63 $30.54 $31.87 $31.86 $31.47 Millions

Kane County Ten Year History of Property Tax Levies Extended General Fund Only

$0 $1 $2 $3 $4 $5 $6 $7 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013

$6.2 $6.9 $4.9 $4.8 $4.6 $4.0 $3.9 $4.2 $4.4 $4.4 $2.4 $2.8 $2.4 $1.8 $1.8 $1.1 $0.5 $1.3 $1.7 $2.1

Millions

Ten Year History Major Other Tax General Fund Revenues Through Second Quarter Fiscal Years 2004-2013

Sales Tax Income Tax Local Use Tax Personal Property Replacement Tax

$0 $10 $20 $30 $40 $50 $60 $70 $80 Annual Budget Thru 1st Quarter Thru 2nd Quarter

Millions

General Fund Expenditures Annual Budget Compared to Actual Quarter-To-Date Through Each of the First Two Quarters of Fiscal Year 2013

All Other Debt Service - Principal & Interest Capital Commodities Contractual Services Personnel

$55.695 $45.025 $39.964

$0 $10 $20 $30 $40 $50 $60 Beg of Year 1st Quarter 2nd Quarter 3rd Quarter End of Year

Millions

General Fund Balance Changes from Beginning of Fiscal Year to Fiscal Quarter ended May 31, 2013

GENERAL FUND SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS CAPITAL PROJECTS FUNDS PERMANENT FUND Governmental Funds include the

GOVERNMENTAL FUNDS ANNUAL BUDGET YEAR-TO-DATE

Revenues $ 217,551,214 54,961,964 Expenditures & Encumbrances 218,124,401 120,104,140 Excess (Deficiency) Revenues over Expenditures (573,187) (65,142,176) Other Financing & Net Transfers In (Out) 573,187 412,417 Less: Encumbrances Included Above 36,294,686 Net Change in Fund Balance (28,435,073) Governmental Funds Balance, Beginning of Year 232,275,718

GOVERNMENTAL FUNDS BALANCE, END OF QUARTER

$ 203,840,645

$0 $20 $40 $60 $80 $100 $120 $140 $160 $180 Annual Budget Thru 1st Quarter Thru 2nd Quarter Millions

Governmental Fund Revenues Annual Budget Compared to Actual Quarter-To-Date Through Each of the First Two Quarters of Fiscal Year 2013

All Other Fines Reimbursements Charges for Services Other Taxes Property Taxes

This chart includes all budgeted revenue items except opening cash on hand of $53.362M

$0 $10 $20 $30 $40 $50 $60 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Millions

Kane County Ten Year History of Property Tax Levies Extended Overall County Governmental Funds by Fund

Capital Improvement Debt Service Fund Public Building Commission Mill Creek SSA Veteran's Commission Fund County Health Fund County Highway Matching Fund County Bridge Fund County Highway Fund Social Security Fund IMRF Fund Insurance Liability Fund General Fund

$0 $10 $20 $30 $40 $50 $60 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013

$21.20 $20.69 $21.77 $24.50 $26.90 $30.63 $30.54 $31.87 $31.86 $31.47 $15.56 $18.40 $20.08 $20.45 $20.28 $19.42 $20.16 $20.60 $21.71 $22.10 $0.00 $0.00 $0.00 $2.54 $2.54 $2.54 $2.54 $2.54 $1.01 $1.00

Millions

Kane County Ten Year History of Property Tax Levies Extended Overall County Governmental Funds by Category

Debt Service Nonmajor Special Revenue Funds General Fund

$0 $50 $100 $150 $200 $250 Annual Budget Thru 1st Quarter Thru 2nd Quarter Millions

Governmental Fund Expenditures Annual Budget Compared to Actual Quarter-To-Date Through Each of the First Two Quarters of Fiscal Year 2013

All Other Debt Service - Principal & Interest Capital Commodities Contractual Services Personnel

$0 $50 $100 $150 $200 $250 Total Fund Balance Restricted Use Available for Budget Millions

Total Governmental Funds, Funds Restricted, and Funds Available for Budgeted Expenditures as of Fiscal Quarter ended May 31, 2013

Nonmajor Special Revenue Funds Transportation Sales Tax Fund Motor Fuel Local Option Fund General Fund $203,840,645 Total Governmental Funds $168,247,854 Nonspendable, Restricted, Committed

• r Assigned

$35,592,791 Available for other Budgeted Expenditures

GOVERNMENTAL FUNDS PROPRIETARY FUNDS Countywide Funds include the

COUNTYWIDE FUNDS ANNUAL BUDGET YEAR-TO-DATE

Revenues $ 218,192,726 54,995,924 Expenditures & Encumbrances 218,605,143 120,368,734 Excess (Deficiency) Revenues over Expenditures (412,417) (65,372,810) Other Financing & Net Transfers In (Out) 412,417 412,417 Less: Encumbrances Included Above 36,379,146 Net Change in Fund Balance (28,581,247) Countywide Funds Balance, Beginning of Year 251,250,682

COUNTYWIDE FUNDS BALANCE, END OF QUARTER

$ 222,669,435

Repo eport O Over erview

The various charts are not intended to serve as a substitute for the detail provided in the County Auditor’s Quarterly Financial Report… but will hopefully illustrate some of the comparisons and relationships that will make the report a more useful resource. I appreciate your suggestions as to how to improve the effectiveness of the report. Thank you.

Questions? Comments?

We are happy to help you!