Charter Township of Oshtemo
Board Presentation Presented by: Seber Tans, PLC June 25, 2019
Charter Township of Oshtemo Board Presentation Presented by: Seber - - PDF document
Charter Township of Oshtemo Board Presentation Presented by: Seber Tans, PLC June 25, 2019 Results of Our Audit Audit of Financial Statements Management Standards Objective Opinion Internal Control Over
Board Presentation Presented by: Seber Tans, PLC June 25, 2019
Seber Tans, PLC
1
Primary Areas of Focus Cash and Investments Accounts Receivable Property and Equipment Accounts Payable Deferred Inflows Special Assessments Net Position Revenue Recognition Expense Recognition Required Disclosures
Seber Tans, PLC
2
10,000,000 15,000,000 20,000,000 25,000,000 Net investment in capital assets Restricted for public safety Restricted for public works Unrestricted 20,955,255 2,335,483 103,011 5,337,840 22,062,585 1,105,024 116,801 6,575,954
Charter Township of Oshtemo Net Position Breakdown - Primary Government December 31, 2018
2017 2018
Seber Tans, PLC
3
1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 Fund Balance - Restricted for Public Safety Fund Balance - Restricted for Street Lights Fund Balance - Assigned for Public Safety Fund Balance - Assigned for Public Works Fund Balance - Assigned for culture and recreation Fund Balance - Assigned for subsequent years Fund Balance - Unassigned 2,350,633 103,011 140,267 1,391,227 219,277 1,181,889 1,930,419 1,119,324 116,801 278,250 1,454,140 383,070 125,000 3,566,937
Charter Township of Oshtemo Fund Balance Breakdown - Fund Statements December 31, 2018
2017 2018
Seber Tans, PLC
4
1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 Cash Investments Receivables 3,033,194 1,089,561 1,009,144 2,373,863 2,124,272 961,124
Charter Township of Oshtemo General Fund - Balance Sheet - Assets December 31, 2018
2017 2018
Seber Tans, PLC
5
1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 Accounts Payable Unearned
special assessment revenues Deferred inflow - property taxes Fund Balance - Restricted for Public Safety Fund Balance - Restricted for Street Lights Fund Balance - Assigned for subsequent years Fund Balance - Unassigned 575,952 146,898 756,528 437,202 103,011 1,181,889 1,930,419 333,046 153,292 781,141 383,042 116,801 125,000 3,566,937
Charter Township of Oshtemo General Fund - Balance Sheet - Liabilities, Deferred Inflows and Fund Balance December 31, 2018
2017 2018
Seber Tans, PLC
6
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2,000,000 Taxes Licenses and permits State grants Charges for services Interest and rentals Other 714,059 196,609 1,746,749 238,112 11,311 439,180 732,817 213,290 1,877,463 351,528 22,540 165,823 754,279 200,618 1,932,914 363,717 45,500 245,394
Charter Township of Oshtemo General Fund - Revenue Comparison December 31, 2018
2016 2017 2018
Seber Tans, PLC
7
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 General Government Public Safety Public Works Community & Economic Development Capital Outlay Transfers out 1,479,168 210,923 654,118 276,049 353,476 226,000 1,628,141 50,173 611,021 236,476 465,022 1,499,370 1,740,747 50,948 442,112 238,387 280,833 250,136
Charter Township of Oshtemo General Fund - Expenditure Comparison December 31, 2018
2016 2017 2018
Seber Tans, PLC
8
1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 Cash Receivables Accounts Payable Deferred inflow - special assessments for subsequent year Fund Balance - Restricted for Public Safety 2,768,823 1,118,469 114,074 1,859,787 1,913,431 1,973,162 1,800,337 152,323 2,884,894 736,282
Charter Township of Oshtemo Fire Fund - Balance Sheet December 31, 2018
2017 2018
Seber Tans, PLC
9
1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 Total Revenue Total Expenses Transfers in 1,886,368 1,720,655 5,000 1,897,950 3,075,099
Fire Fund - Statement of Revenues & Expenditures December 31, 2018
2017 2018
Seber Tans, PLC
10
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 Cash Receivables Accounts Payable Deferred inflow - special assessments for subsequent year Fund Balance - Assigned for Public Safety 482,338 947,066 1,087 1,288,050 140,267 614,004 1,002,848 5,726 1,332,876 278,250
Charter Township of Oshtemo Police Fund - Balance Sheet December 31, 2018
2017 2018
Seber Tans, PLC
11
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 Total Revenue Total Expenses Transfers in 1,251,138 1,262,786 33,320 1,378,324 1,278,741 38,400
Charter Township of Oshtemo Police Fund - Statement of Revenues & Expenditures December 31, 2018
2017 2018
Seber Tans, PLC
12
200,000 300,000 400,000 500,000 600,000 Cash Receivables Accounts Payable Deferred inflow - special assessments for subsequent year Unavailable Grant Revenues Fund Balance - Assigned for Public Works 530,162 254,499 306,421 205,657
292,663 354,266 93,422 243,724 80,725 229,058
Charter Township of Oshtemo General Sewer Fund - Balance Sheet December 31, 2018
2017 2018
Seber Tans, PLC
13
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 Total Revenue Total Expenses Transfers in 317,653 1,220,624 929,000 777,560 821,085
General Sewer Fund - Statement of Revenues & Expenditures December 31, 2018
2017 2018
Seber Tans, PLC
14
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 Cash Receivables Accounts Payable Deferred inflow - unavailable special assessments Unavailable Grant Revenues Fund Balance - Assigned for Public Works 1,065,853 651,093 310,248 102,054 186,000 1,118,644 1,501,953 392,526 310,505 100,817 258,075 1,225,082
Charter Township of Oshtemo General Water Fund - Balance Sheet December 31, 2018
2017 2018
Seber Tans, PLC
15
400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 Total Revenue Total Expenses 1,429,780 1,461,940 292,835 186,397
Charter Township of Oshtemo General Water Fund - Statement of Revenues & Expenditures December 31, 2018
2017 2018
Seber Tans, PLC
16
Seber Tans, PLC
17
policies, estimates and financial statement disclosures
financial reporting, which included significant accounting practices, estimates and financial statement disclosures.
by the auditor
Seber Tans, PLC
18
trivial
accounting matters that were not satisfactorily resolved.
2019.
auditing matters between management and other independent public accountants.
relevant to those charged with governance.
significant and relevant to those charged with governance.
Seber Tans, PLC
19
governance all material weaknesses and significant deficiencies that have been identified in the Township’s internal controls over financial
and control deficiencies follow:
Material Weakness A deficiency, or combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the Township’s financial statements will not be prevented, or detected and corrected on a timely basis. Significant Deficiency A deficiency, or combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. Deficiency in Internal Control A deficiency in internal control exists when the design or
employees, in the normal course of performing their assigned functions, to prevent, or detect and correct misstatements on a timely basis.
Seber Tans, PLC
20
internal control that we consider to be a material
that have not been identified.
internal control that we consider to be a significant deficiency: