Audit 339091

FY End
2024-06-30
Total Expended
$7.51M
Findings
4
Programs
11
Organization: City of Council Bluffs (IA)
Year: 2024 Accepted: 2025-01-21

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
MP6AX535XXK3 Matt Walsh Auditee
7128905264 Amy Shreck Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, except for sub recipient expenditures, which are recorded on the cash basis. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenses are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of the City of Council Bluffs (the City) under programs of the federal government for the year ended June 30, 2024. The information in this Schedule is presented in accordance with the requirements of the 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 Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, change in net positions, or cash flows of the City.
Title: Significant Accounting Policies Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, except for sub recipient expenditures, which are recorded on the cash basis. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenses are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Expenditures reported on the Schedule are reported on the accrual basis of accounting, except for sub recipient expenditures, which are recorded on the cash basis. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenses are not allowable or are limited as to reimbursement.
Title: Indirect Cost Rate Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting, except for sub recipient expenditures, which are recorded on the cash basis. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenses are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

Assistance Listing Number 14.218 CDBG Entitlement/Special Purpose Grants Cluster Department of Housing and Urban Development, Award Number B-22-MC-19-0005 Department of Housing and Urban Development, Award Number B-23-MC-19-0005 Criteria or specific requirement – Subaward agreements, amendments, and modifications that are at or above the subaward reporting requirement under Title 2 of the Code of Federal Regulations must be reported in in the Subaward Reporting System (FSRS) no later than the last day of the month following the month is which the subaward or subaward amendment obligation was made. Condition – Subaward information was not reported in FSRS within the required time frame. Questioned costs – None. Context – Subaward agreements and modifications were obligated during fiscal year 2024 to which the FFATA requirements applied. Of the one subaward and modification tested, none were submitted in a timely manner. Sampling was not a statistically valid sample. Effect – Reporting provides information to the public to hold the government accountable for each spending decision and assist with reducing wasteful spending. Untimely reporting does not provide an accurate detail of government spending. Cause – Federal awards are awarded by the federal agency late in the calendar year with effective dates of January 1 of the same year. This results in subawards being obligated late in the calendar year after the grant has been awarded to the City. The City reported subaward information in FSRS before the calendar year ended. Recommendation – We recommend that procedures related to the reporting of subaward information in FSRS be improved to provide timely reporting. View of responsible officials – Housing and Economic Development Staff will update its internal policy to submit FFATA with 30 days of the final execution of the CDBG annual budget, Annual Action Plan, and subaward agreements, along with any amendments to these listed agreements. The original agreements typically happen in October and will be completed by November to meet the standard of submitting within 30 days of allocation. We will also review amendments to ensure they are also filed within 30 days of execution.
Assistance Listing Number 14.218 CDBG Entitlement/Special Purpose Grants Cluster Department of Housing and Urban Development, Award Number B-22-MC-19-0005 Department of Housing and Urban Development, Award Number B-23-MC-19-0005 Criteria or specific requirement – Subaward agreements, amendments, and modifications that are at or above the subaward reporting requirement under Title 2 of the Code of Federal Regulations must be reported in in the Subaward Reporting System (FSRS) no later than the last day of the month following the month is which the subaward or subaward amendment obligation was made. Condition – Subaward information was not reported in FSRS within the required time frame. Questioned costs – None. Context – Subaward agreements and modifications were obligated during fiscal year 2024 to which the FFATA requirements applied. Of the one subaward and modification tested, none were submitted in a timely manner. Sampling was not a statistically valid sample. Effect – Reporting provides information to the public to hold the government accountable for each spending decision and assist with reducing wasteful spending. Untimely reporting does not provide an accurate detail of government spending. Cause – Federal awards are awarded by the federal agency late in the calendar year with effective dates of January 1 of the same year. This results in subawards being obligated late in the calendar year after the grant has been awarded to the City. The City reported subaward information in FSRS before the calendar year ended. Recommendation – We recommend that procedures related to the reporting of subaward information in FSRS be improved to provide timely reporting. View of responsible officials – Housing and Economic Development Staff will update its internal policy to submit FFATA with 30 days of the final execution of the CDBG annual budget, Annual Action Plan, and subaward agreements, along with any amendments to these listed agreements. The original agreements typically happen in October and will be completed by November to meet the standard of submitting within 30 days of allocation. We will also review amendments to ensure they are also filed within 30 days of execution.
Assistance Listing Number 14.218 CDBG Entitlement/Special Purpose Grants Cluster Department of Housing and Urban Development, Award Number B-22-MC-19-0005 Department of Housing and Urban Development, Award Number B-23-MC-19-0005 Criteria or specific requirement – Subaward agreements, amendments, and modifications that are at or above the subaward reporting requirement under Title 2 of the Code of Federal Regulations must be reported in in the Subaward Reporting System (FSRS) no later than the last day of the month following the month is which the subaward or subaward amendment obligation was made. Condition – Subaward information was not reported in FSRS within the required time frame. Questioned costs – None. Context – Subaward agreements and modifications were obligated during fiscal year 2024 to which the FFATA requirements applied. Of the one subaward and modification tested, none were submitted in a timely manner. Sampling was not a statistically valid sample. Effect – Reporting provides information to the public to hold the government accountable for each spending decision and assist with reducing wasteful spending. Untimely reporting does not provide an accurate detail of government spending. Cause – Federal awards are awarded by the federal agency late in the calendar year with effective dates of January 1 of the same year. This results in subawards being obligated late in the calendar year after the grant has been awarded to the City. The City reported subaward information in FSRS before the calendar year ended. Recommendation – We recommend that procedures related to the reporting of subaward information in FSRS be improved to provide timely reporting. View of responsible officials – Housing and Economic Development Staff will update its internal policy to submit FFATA with 30 days of the final execution of the CDBG annual budget, Annual Action Plan, and subaward agreements, along with any amendments to these listed agreements. The original agreements typically happen in October and will be completed by November to meet the standard of submitting within 30 days of allocation. We will also review amendments to ensure they are also filed within 30 days of execution.
Assistance Listing Number 14.218 CDBG Entitlement/Special Purpose Grants Cluster Department of Housing and Urban Development, Award Number B-22-MC-19-0005 Department of Housing and Urban Development, Award Number B-23-MC-19-0005 Criteria or specific requirement – Subaward agreements, amendments, and modifications that are at or above the subaward reporting requirement under Title 2 of the Code of Federal Regulations must be reported in in the Subaward Reporting System (FSRS) no later than the last day of the month following the month is which the subaward or subaward amendment obligation was made. Condition – Subaward information was not reported in FSRS within the required time frame. Questioned costs – None. Context – Subaward agreements and modifications were obligated during fiscal year 2024 to which the FFATA requirements applied. Of the one subaward and modification tested, none were submitted in a timely manner. Sampling was not a statistically valid sample. Effect – Reporting provides information to the public to hold the government accountable for each spending decision and assist with reducing wasteful spending. Untimely reporting does not provide an accurate detail of government spending. Cause – Federal awards are awarded by the federal agency late in the calendar year with effective dates of January 1 of the same year. This results in subawards being obligated late in the calendar year after the grant has been awarded to the City. The City reported subaward information in FSRS before the calendar year ended. Recommendation – We recommend that procedures related to the reporting of subaward information in FSRS be improved to provide timely reporting. View of responsible officials – Housing and Economic Development Staff will update its internal policy to submit FFATA with 30 days of the final execution of the CDBG annual budget, Annual Action Plan, and subaward agreements, along with any amendments to these listed agreements. The original agreements typically happen in October and will be completed by November to meet the standard of submitting within 30 days of allocation. We will also review amendments to ensure they are also filed within 30 days of execution.