Audit 350419

FY End
2024-06-30
Total Expended
$42.29M
Findings
2
Programs
19
Organization: City of Roseville (CA)
Year: 2024 Accepted: 2025-03-30
Auditor: Lsl LLP

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
CL1ACZKW59E1 Dennis Kauffman Auditee
9147745314 Brandon Young Auditor
No contacts on file

Notes to SEFA

Title: NOTE 4: LOAN PROGRAMS WITH CONTINUING COMPLIANCE REQUIREMENTS Accounting Policies: Expenditures reported in the Schedule are reported on the modified accrual basis of accounting for the governmental funds and the accrual basis of accounting for the proprietary funds, except for subrecipient 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 expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in the Schedule. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10-percent de minimis indirect cost rate. The loans listed below are administered directly by the City, and balances and transactions relating to these programs are included in the City’s basic financial statements. Loans made during the fiscal year, if any, are included in the federal expenditures presented in the Schedule of Expenditures of Federal Awards. The balance of loans outstanding at June 30, 2024, consists of:
Title: NOTE 5: ARPA PROGRAM EXPENDITURES Accounting Policies: Expenditures reported in the Schedule are reported on the modified accrual basis of accounting for the governmental funds and the accrual basis of accounting for the proprietary funds, except for subrecipient 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 expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in the Schedule. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10-percent de minimis indirect cost rate. The Schedule of Expenditures of Federal Awards (SEFA) includes expenditures related to the ARPA program from FY 2023. For further details, refer to finding 2024-002 the schedule of findings and questioned costs.

Finding Details

Reference Number 2024-002 Federal Program: 21.027 – Coronavirus State and Local Fiscal Recovery Funds Federal Agency U.S. Department of Treasury Pass-Through Entity State of California Evaluation of Finding Significant Deficiency Compliance Area L – Reporting Condition During the allowable cost testing for the 21.027 Coronavirus State and Local Fiscal Recovery Funds program, it was found that an expenditure of $945,041 was recorded in the wrong period. The invoice indicated that the services were rendered as of June 30, 2023, but the expenditure was recorded as July 1, 2023 instead. This misstatement impacts the accuracy of financial reporting and grant compliance. Criteria According to 2 CFR 200.302(b)(3) and 2 CFR 200.303, entities receiving federal funds must maintain effective internal controls over financial reporting to ensure accurate and timely recognition of expenditures in the appropriate period. Cause of Condition The City's internal controls over financial reporting and expenditure recognition were not effectively designed or implemented, leading to recurring errors in the timing of recorded expenditures. Effect or Potential Effect of Condition Improper recording of expenditures can lead to misstatements in financial reports, noncompliance with federal grant requirements, and potential audit findings. Continued recurrence of this issue may impact the entity’s ability to demonstrate sound financial management practices. Recommendation We recommend that management continue to strengthen internal controls over expenditure recognition by implementing enhanced review procedures and periodic reconciliations to ensure expenditures are recorded in the appropriate period. Client Response The City agrees with the recommendation and has implemented new procedures and review processes to ensure expenditures for federal programs are recognized in the appropriate fiscal year's Schedule of Expenditures of Federal Awards (SEFA).
Reference Number 2024-002 Federal Program: 21.027 – Coronavirus State and Local Fiscal Recovery Funds Federal Agency U.S. Department of Treasury Pass-Through Entity State of California Evaluation of Finding Significant Deficiency Compliance Area L – Reporting Condition During the allowable cost testing for the 21.027 Coronavirus State and Local Fiscal Recovery Funds program, it was found that an expenditure of $945,041 was recorded in the wrong period. The invoice indicated that the services were rendered as of June 30, 2023, but the expenditure was recorded as July 1, 2023 instead. This misstatement impacts the accuracy of financial reporting and grant compliance. Criteria According to 2 CFR 200.302(b)(3) and 2 CFR 200.303, entities receiving federal funds must maintain effective internal controls over financial reporting to ensure accurate and timely recognition of expenditures in the appropriate period. Cause of Condition The City's internal controls over financial reporting and expenditure recognition were not effectively designed or implemented, leading to recurring errors in the timing of recorded expenditures. Effect or Potential Effect of Condition Improper recording of expenditures can lead to misstatements in financial reports, noncompliance with federal grant requirements, and potential audit findings. Continued recurrence of this issue may impact the entity’s ability to demonstrate sound financial management practices. Recommendation We recommend that management continue to strengthen internal controls over expenditure recognition by implementing enhanced review procedures and periodic reconciliations to ensure expenditures are recorded in the appropriate period. Client Response The City agrees with the recommendation and has implemented new procedures and review processes to ensure expenditures for federal programs are recognized in the appropriate fiscal year's Schedule of Expenditures of Federal Awards (SEFA).