Audit 290453

FY End
2023-06-30
Total Expended
$14.80M
Findings
4
Programs
25
Organization: City of Murfreesboro, Tennessee (TN)
Year: 2023 Accepted: 2024-02-14

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
369029 2023-001 Significant Deficiency Yes B
369030 2023-001 Significant Deficiency Yes B
945471 2023-001 Significant Deficiency Yes B
945472 2023-001 Significant Deficiency Yes B

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $4.08M Yes 0
14.218 Community Development Block Grants/entitlement Grants $1.95M Yes 1
20.507 Federal Transit_formula Grants $1.57M - 0
14.218 Covid-19 Community Development Block Grants/entitlement Grants $1.30M Yes 1
16.922 Equitable Sharing Program $247,426 - 0
14.231 Emergency Solutions Grant Program $207,222 - 0
20.106 Airport Improvement Program $168,539 - 0
20.600 State and Community Highway Safety - Community - Based Traffic Safety Enforcement and Education $89,233 - 0
97.044 Assistance to Firefighters Grant $86,956 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $61,567 - 0
20.106 Faa American Resuce Plan Act Funding for Airports $59,000 - 0
20.205 Highway Planning and Construction $50,545 - 0
20.600 State and Community Highway Safety - Community -Based Traffic Safety Enforcement and Education $40,405 - 0
14.239 Home Investment Partnerships Program $31,811 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $29,897 - 0
20.106 Acrgp Coronavirus Response Grant Program $23,000 - 0
20.616 National Priority Safety Programs - Pedestrian Enforcement and Education $20,802 - 0
94.014 Martin Luther King JR Day of Service Grants $12,755 - 0
14.231 Covid-19 Emergency Solutions Grant Program $12,259 - 0
20.614 National Highway Traffic Safety Administration (nhtsa) Discretionary Safety Grants - Bicycle and Pedestrian Safety $9,979 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals - Nea Arts Engagement in American Communities (aeac) $6,292 - 0
10.680 Cooperative Forest Health Program $5,000 - 0
93.044 Covid - 19 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $3,788 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $2,690 - 0
14.261 Homeless Management Information Systems Technical Assistance $609 - 0

Contacts

Name Title Type
CMF9NNK9Z7D6 Jennifer Brown Auditee
6158935210 James R. Jobe Auditor
No contacts on file

Notes to SEFA

Title: Note A – BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City will use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance, when applicable. The de minimis indirect cost rate was not used/applicable for FYE 2023. The accompanying schedules of expenditures of federal and state awards include the grant activity of the City of Murfreesboro under programs of the federal and state governments for the year ended June 30, 2023. The information in these schedules is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedules present only a selected portion of the operations of the City of Murfreesboro, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City of Murfreesboro. Expenditures reported on the schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Note B – CONTINGENCY Accounting Policies: Expenditures reported on the schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City will use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance, when applicable. The de minimis indirect cost rate was not used/applicable for FYE 2023. The grant expenditure amounts are subject to audit and adjustment. If any expenditures are disallowed by the grantor agencies as a result of such an audit, any claim for reimbursement to the grantor agencies would become a liability of the City of Murfreesboro. In the opinion of management, all grant expenditures are in compliance with the terms of the grant agreements and applicable federal and state laws and regulations.
Title: Note C – DE MIMIMIS INDIRECT COST RATE Accounting Policies: Expenditures reported on the schedules are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City will use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance, when applicable. The de minimis indirect cost rate was not used/applicable for FYE 2023. The City will use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance, when applicable.

Finding Details

Condition: A prior year Community Development Block Grant (CDBG grant) was monitored by HUD. As a result of the monitoring, the client was made aware that additional detail may be needed to better support the payroll related expenditures charged to housing rehab and affordable housing allowance activities. Detailed time is not being kept of the amount of time spent on each specific activity, providing a description of the activity assisted, including its location (address). Criteria: Per 24 CFR 570.506 (a) Grantee shall establish and maintain sufficient records to enable the Secretary to determine whether the recipient has met the requirements of this part. At a minimum, the following records are needed: (a) records providing a full description of each activity assisted (or being assisted) with CDBG funds, including its location (if the activity has a geographical locus). Cause of Condition: Time allocated to the housing rehab and affordable housing function is documented on time sheets submitted to the Finance Department. However, the detail of the time charged to the specific activities is not being retained in a distinct orderly fashion that can be reconciled to the time charged per the time sheet. Effect: Administrative costs under the CDBG grant have a 20% cap. Amounts could be erroneously charged to an activity thereby reducing the amount charged to administrative costs. Administrative costs if they had been reported correctly could exceed the cap resulting in unallowed costs. Recommendation: Detail time of all housing rehabilitation, affordable housing and any other activities charged with payroll costs should be retained. The records of the time should include a full description of the activity assisted including its location (if the activity has a geographical locus). The detail time retained should be easily traceable to the time charged to each activity per the time sheets submitted to the Finance Department. Views of Responsible Officials and Planned Corrective Actions: The City continues to work with a consultant to assist staff with administration of the Community Development Block Grants program. Community Development has also hired a new Assistant Director and Grant Coordinator during FY 24 who have worked with the consultant to review processes and implement changes as necessary. Process reviews include reviewing methods for tracking and reporting time and activity spent on the programs.
Condition: A prior year Community Development Block Grant (CDBG grant) was monitored by HUD. As a result of the monitoring, the client was made aware that additional detail may be needed to better support the payroll related expenditures charged to housing rehab and affordable housing allowance activities. Detailed time is not being kept of the amount of time spent on each specific activity, providing a description of the activity assisted, including its location (address). Criteria: Per 24 CFR 570.506 (a) Grantee shall establish and maintain sufficient records to enable the Secretary to determine whether the recipient has met the requirements of this part. At a minimum, the following records are needed: (a) records providing a full description of each activity assisted (or being assisted) with CDBG funds, including its location (if the activity has a geographical locus). Cause of Condition: Time allocated to the housing rehab and affordable housing function is documented on time sheets submitted to the Finance Department. However, the detail of the time charged to the specific activities is not being retained in a distinct orderly fashion that can be reconciled to the time charged per the time sheet. Effect: Administrative costs under the CDBG grant have a 20% cap. Amounts could be erroneously charged to an activity thereby reducing the amount charged to administrative costs. Administrative costs if they had been reported correctly could exceed the cap resulting in unallowed costs. Recommendation: Detail time of all housing rehabilitation, affordable housing and any other activities charged with payroll costs should be retained. The records of the time should include a full description of the activity assisted including its location (if the activity has a geographical locus). The detail time retained should be easily traceable to the time charged to each activity per the time sheets submitted to the Finance Department. Views of Responsible Officials and Planned Corrective Actions: The City continues to work with a consultant to assist staff with administration of the Community Development Block Grants program. Community Development has also hired a new Assistant Director and Grant Coordinator during FY 24 who have worked with the consultant to review processes and implement changes as necessary. Process reviews include reviewing methods for tracking and reporting time and activity spent on the programs.
Condition: A prior year Community Development Block Grant (CDBG grant) was monitored by HUD. As a result of the monitoring, the client was made aware that additional detail may be needed to better support the payroll related expenditures charged to housing rehab and affordable housing allowance activities. Detailed time is not being kept of the amount of time spent on each specific activity, providing a description of the activity assisted, including its location (address). Criteria: Per 24 CFR 570.506 (a) Grantee shall establish and maintain sufficient records to enable the Secretary to determine whether the recipient has met the requirements of this part. At a minimum, the following records are needed: (a) records providing a full description of each activity assisted (or being assisted) with CDBG funds, including its location (if the activity has a geographical locus). Cause of Condition: Time allocated to the housing rehab and affordable housing function is documented on time sheets submitted to the Finance Department. However, the detail of the time charged to the specific activities is not being retained in a distinct orderly fashion that can be reconciled to the time charged per the time sheet. Effect: Administrative costs under the CDBG grant have a 20% cap. Amounts could be erroneously charged to an activity thereby reducing the amount charged to administrative costs. Administrative costs if they had been reported correctly could exceed the cap resulting in unallowed costs. Recommendation: Detail time of all housing rehabilitation, affordable housing and any other activities charged with payroll costs should be retained. The records of the time should include a full description of the activity assisted including its location (if the activity has a geographical locus). The detail time retained should be easily traceable to the time charged to each activity per the time sheets submitted to the Finance Department. Views of Responsible Officials and Planned Corrective Actions: The City continues to work with a consultant to assist staff with administration of the Community Development Block Grants program. Community Development has also hired a new Assistant Director and Grant Coordinator during FY 24 who have worked with the consultant to review processes and implement changes as necessary. Process reviews include reviewing methods for tracking and reporting time and activity spent on the programs.
Condition: A prior year Community Development Block Grant (CDBG grant) was monitored by HUD. As a result of the monitoring, the client was made aware that additional detail may be needed to better support the payroll related expenditures charged to housing rehab and affordable housing allowance activities. Detailed time is not being kept of the amount of time spent on each specific activity, providing a description of the activity assisted, including its location (address). Criteria: Per 24 CFR 570.506 (a) Grantee shall establish and maintain sufficient records to enable the Secretary to determine whether the recipient has met the requirements of this part. At a minimum, the following records are needed: (a) records providing a full description of each activity assisted (or being assisted) with CDBG funds, including its location (if the activity has a geographical locus). Cause of Condition: Time allocated to the housing rehab and affordable housing function is documented on time sheets submitted to the Finance Department. However, the detail of the time charged to the specific activities is not being retained in a distinct orderly fashion that can be reconciled to the time charged per the time sheet. Effect: Administrative costs under the CDBG grant have a 20% cap. Amounts could be erroneously charged to an activity thereby reducing the amount charged to administrative costs. Administrative costs if they had been reported correctly could exceed the cap resulting in unallowed costs. Recommendation: Detail time of all housing rehabilitation, affordable housing and any other activities charged with payroll costs should be retained. The records of the time should include a full description of the activity assisted including its location (if the activity has a geographical locus). The detail time retained should be easily traceable to the time charged to each activity per the time sheets submitted to the Finance Department. Views of Responsible Officials and Planned Corrective Actions: The City continues to work with a consultant to assist staff with administration of the Community Development Block Grants program. Community Development has also hired a new Assistant Director and Grant Coordinator during FY 24 who have worked with the consultant to review processes and implement changes as necessary. Process reviews include reviewing methods for tracking and reporting time and activity spent on the programs.