Audit 296757

FY End
2023-06-30
Total Expended
$3.22M
Findings
2
Programs
14
Organization: City of San Bruno (CA)
Year: 2023 Accepted: 2024-03-22

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
Z3XAM3KDUFA5 Nick Pegueros Auditee
6506167054 Ahmed Badawi Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, and capital projects funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital projects funds. Expenditures of federal awards reported on the Schedule of Expenditures of Federal Awards (Schedule) are recognized when incurred. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. The Schedule of Expenditure of Federal Awards (the Schedule) includes expenditures of federal awards for the City of San Bruno, California as disclosed in the notes to the Basic Financial Statements.
Title: Basis of Accounting Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, and capital projects funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital projects funds. Expenditures of federal awards reported on the Schedule of Expenditures of Federal Awards (Schedule) are recognized when incurred. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. Funds received under the various grant programs have been recorded within the general, special revenue, and capital projects funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital projects funds. Expenditures of federal awards reported on the Schedule of Expenditures of Federal Awards (Schedule) are recognized when incurred.
Title: Relationship of Schedule of Expenditures of Federal Awards to Financial Statements Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, and capital projects funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital projects funds. Expenditures of federal awards reported on the Schedule of Expenditures of Federal Awards (Schedule) are recognized when incurred. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. The accompanying Schedule presents the activity of all federal financial assistance programs of the City. Federal financial assistance received directly from federal agencies as well as federal financial assistance passed through the State of California is included in the Schedule. The Schedule was prepared only from the accounts of various grant programs and, therefore, does not present the financial position or results of operations of the City.
Title: Pass-Through Entities' Identifying Number Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, and capital projects funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital projects funds. Expenditures of federal awards reported on the Schedule of Expenditures of Federal Awards (Schedule) are recognized when incurred. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. When federal awards were received from a pass-through entity, the Schedule shows, if available, the identifying number assigned by the pass-through entity. When no identifying number is shown, the City determined that no identifying number is assigned for the program or the City was unable to obtain an identifying number from the pass-through entity.
Title: Indirect Costs Accounting Policies: Funds received under the various grant programs have been recorded within the general, special revenue, and capital projects funds of the City. The City utilizes the modified accrual basis of accounting for the general, special revenue, and capital projects funds. Expenditures of federal awards reported on the Schedule of Expenditures of Federal Awards (Schedule) are recognized when incurred. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis indirect cost rate. The City did not elect to use the 10% de minimis indirect cost rate.

Finding Details

Program: Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing Number 21.027, U.S. Department of Treasury, Direct Program Criteria: Per the State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, metropolitan cities with a population below 250,000 that are allocated more than $10 million in State and Local Fiscal Recovery Funds are required to submit Performance and Expenditure Reports (P&E Reports) quarterly. Internal controls over reporting compliance should ensure accurate, complete, and timely submission of all required reports. Condition: Management that tracked and submitted the P&E Reports left the City in August 2022, and new management was not aware of the requirement nor received correspondence from the U.S. Department of Treasury (Treasury). Effect: The City did not submit any of the required quarterly P&E Reports to the Treasury for the period that covered July 1, 2022 through June 30, 2023. Questioned Costs: None. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the City update policies and procedures for grant reporting and administration such as keeping a listing of grant reporting requirements in their records. Management’s Response: The City agrees that the absence of a structured data collection and analysis process sufficient to fulfill reporting requirements creates a risk of noncompliance with federal statutes, regulations, and terms and conditions of the grant awards. The City will develop, document, and implement a formal year-end closing process and audit preparedness policy and procedures. The responsibilities, deliverables, and deadlines will be clearly outlined and communicated to all staff members. The City remedied the delinquent ARPA SLFRF quarterly P&E Report to the Treasury in January 2024, covering July 1, 2022, through December 31, 2023. Management intends to fully expend the remaining ARPA SLFRF award in FY24 and file the required quarterly P&E Reports in April 2024 and the final report in July 2024.
Program: Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing Number 21.027, U.S. Department of Treasury, Direct Program Criteria: Per the State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, metropolitan cities with a population below 250,000 that are allocated more than $10 million in State and Local Fiscal Recovery Funds are required to submit Performance and Expenditure Reports (P&E Reports) quarterly. Internal controls over reporting compliance should ensure accurate, complete, and timely submission of all required reports. Condition: Management that tracked and submitted the P&E Reports left the City in August 2022, and new management was not aware of the requirement nor received correspondence from the U.S. Department of Treasury (Treasury). Effect: The City did not submit any of the required quarterly P&E Reports to the Treasury for the period that covered July 1, 2022 through June 30, 2023. Questioned Costs: None. Repeat Finding: This is not a repeat finding. Recommendation: We recommend the City update policies and procedures for grant reporting and administration such as keeping a listing of grant reporting requirements in their records. Management’s Response: The City agrees that the absence of a structured data collection and analysis process sufficient to fulfill reporting requirements creates a risk of noncompliance with federal statutes, regulations, and terms and conditions of the grant awards. The City will develop, document, and implement a formal year-end closing process and audit preparedness policy and procedures. The responsibilities, deliverables, and deadlines will be clearly outlined and communicated to all staff members. The City remedied the delinquent ARPA SLFRF quarterly P&E Report to the Treasury in January 2024, covering July 1, 2022, through December 31, 2023. Management intends to fully expend the remaining ARPA SLFRF award in FY24 and file the required quarterly P&E Reports in April 2024 and the final report in July 2024.