Audit 9302

FY End
2023-06-30
Total Expended
$3.46M
Findings
4
Programs
4
Organization: City of Beaveron (MI)
Year: 2023 Accepted: 2024-01-03

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
7186 2023-004 Material Weakness Yes P
7187 2023-005 - - P
583628 2023-004 Material Weakness Yes P
583629 2023-005 - - P

Contacts

Name Title Type
H9XMAJZUC247 Shannon Sirpilla Auditee
9894353511 Robert Friske Auditor
No contacts on file

Notes to SEFA

Title: U.S. Department of Agriculture Loan Agreement Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Thunder Bay Community Health Service, Inc. and is presented using the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. The expenditures in the Schedule of Expenditures of Federal Awards are in agreement with the amounts reported in the financial statements and reports submitted to the Department of Health and Human Services. Although some grant awards are for different periods than the Center's fiscal year, all expenditures in the schedule are for the year ended February 28, 2023. De Minimis Rate Used: N Rate Explanation: The City of Beaverton has not elected to use the 10% de minimis indirect costs rate. The amount expended under AL 10.766, Communities Facilities Loans and Grants, includes beginning loan balances of $1,602,000 and advances on loans during the year totaling $519,000. The loans had outstanding principal balances totaling $1,900,000 as of June 30, 2023.
Title: Reconciliation of Federal Awards Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Thunder Bay Community Health Service, Inc. and is presented using the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. The expenditures in the Schedule of Expenditures of Federal Awards are in agreement with the amounts reported in the financial statements and reports submitted to the Department of Health and Human Services. Although some grant awards are for different periods than the Center's fiscal year, all expenditures in the schedule are for the year ended February 28, 2023. De Minimis Rate Used: N Rate Explanation: The City of Beaverton has not elected to use the 10% de minimis indirect costs rate. Federal awards revenue for the year ended June 30, 2023 is reported as follows: Expenditures per schedule of expenditures of federal awards $3,459,791 Community Facilities Loans and Grants (AL# 10.766) - Represents the beginning loan balance of loan agreement with U.S. Department of Agriculture. (2,121,000) Federal grants per statement of activities $1,338,791

Finding Details

AL# 11.300 Investments for Public Works & Economic Develpment - Written Policies Required by the Uniform Guidance (repeated from prior year)Material Weakness in Internal Control over Compliance Criteria: The Uniform Guidance requires a non-federal entity that has expended federal awards for a grant awarded on or after December 26, 2014 to have written policies pertaining to allowability of costs charged to federal programs, cash management, financial management, procurement, compensation/payroll, and travel costs (§200.300 - 328). Condition: Although the City has processes in place to cover these areas, the City lacks formal written policies covering these areas. Cause: This condition appears to be the result of a time lag in identifying the requirement and developing a plan for compliance. Effect: As a result of this condition, the City did not fully comply with the Uniform Guidance applicable to the above noted grants. Questioned Costs: No costs have been questioned as a result of this finding. Recommendation: We recommend that the City ensures these policies are updated to conform with the Uniform Guidance as soon as practical, but no later than the end of fiscal year 2024. View of Responsible Officials: We agree with the finding. The City is currently working on updating all current procedures and policies to ensure that they are compliant with Uniform Guidance for all current and future Federal Awards.
AL# 11.300 Investments for Public Works & Economic Develpment - Other Tests and Provisions Compliance Other Matters Criteria: The City is required to erect and maintain in good condition and repair a sign or signs in accordance with EDA specifications. Prior to on-site construction, a reproducible photograph of the sign must be submitted to EDA along with evidence that the sign is located at the project site. Condition: During our inquiry of grant specific conditions the City was not able to readily produce a photograph of a sign at the site of the project. Additionally, the City did not have a sign erected at a second project site. Cause: This condition appears to be the result of a lack of administrative oversight. Effect: As a result of this condition, the City did not fully comply with the grant specific conditions of a major federal program/award. Questioned Costs: No costs have been questioned as a result of this finding. Recommendation: We recommend that the City ensures a sign is erected at both project sites and photographs are retained in the project files. View of Responsible Officials: We agree with the finding. The City, immediately after auditor inquiry, took a photograph of the erected sign and will retain it in the project file. Additionally, the City has provided a copy of the photograph to the Economic Development Administration.
AL# 11.300 Investments for Public Works & Economic Develpment - Written Policies Required by the Uniform Guidance (repeated from prior year)Material Weakness in Internal Control over Compliance Criteria: The Uniform Guidance requires a non-federal entity that has expended federal awards for a grant awarded on or after December 26, 2014 to have written policies pertaining to allowability of costs charged to federal programs, cash management, financial management, procurement, compensation/payroll, and travel costs (§200.300 - 328). Condition: Although the City has processes in place to cover these areas, the City lacks formal written policies covering these areas. Cause: This condition appears to be the result of a time lag in identifying the requirement and developing a plan for compliance. Effect: As a result of this condition, the City did not fully comply with the Uniform Guidance applicable to the above noted grants. Questioned Costs: No costs have been questioned as a result of this finding. Recommendation: We recommend that the City ensures these policies are updated to conform with the Uniform Guidance as soon as practical, but no later than the end of fiscal year 2024. View of Responsible Officials: We agree with the finding. The City is currently working on updating all current procedures and policies to ensure that they are compliant with Uniform Guidance for all current and future Federal Awards.
AL# 11.300 Investments for Public Works & Economic Develpment - Other Tests and Provisions Compliance Other Matters Criteria: The City is required to erect and maintain in good condition and repair a sign or signs in accordance with EDA specifications. Prior to on-site construction, a reproducible photograph of the sign must be submitted to EDA along with evidence that the sign is located at the project site. Condition: During our inquiry of grant specific conditions the City was not able to readily produce a photograph of a sign at the site of the project. Additionally, the City did not have a sign erected at a second project site. Cause: This condition appears to be the result of a lack of administrative oversight. Effect: As a result of this condition, the City did not fully comply with the grant specific conditions of a major federal program/award. Questioned Costs: No costs have been questioned as a result of this finding. Recommendation: We recommend that the City ensures a sign is erected at both project sites and photographs are retained in the project files. View of Responsible Officials: We agree with the finding. The City, immediately after auditor inquiry, took a photograph of the erected sign and will retain it in the project file. Additionally, the City has provided a copy of the photograph to the Economic Development Administration.