Audit 341029

FY End
2024-06-30
Total Expended
$978,604
Findings
6
Programs
3
Organization: City of Auburn (CA)
Year: 2024 Accepted: 2025-02-03
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
521103 2024-002 Material Weakness - B
521104 2024-003 Material Weakness - I
521105 2024-004 Material Weakness - L
1097545 2024-002 Material Weakness - B
1097546 2024-003 Material Weakness - I
1097547 2024-004 Material Weakness - L

Contacts

Name Title Type
EU2ATPHDLMM8 Gretchen Johnson Auditee
5308234211 James Ramsey Auditor
No contacts on file

Notes to SEFA

Title: Direct and Indirect (Pass-Through) Federal Awards Accounting Policies: The accompanying schedule of expenditures of federal awards (Schedule) includes the federal award activity of the City of Auburn, California (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 Title 2 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, changes in net position/fund balance, or cash flows of the City. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. When applicable, 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. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10-percent de minimis indirect cost rate. Federal awards may be granted directly to the City by a federal granting agency or may be granted to other government agencies which pass-through federal awards to the City. The Schedule includes both of these types of Federal award programs when they occur.

Finding Details

Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Allowable Costs Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: 2 CFR 200.430(g)(vii) states that budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: a) the system for establishing the estimates produces reasonable approximations of the activity performed; b) significant changes in the related work activity (as defined by the recipient’s written policies) are promptly identified and entered in to the records, and c) the recipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We found that although the City charged 50% of the budgeted amount of an employees compensation to the program, the City did not perform a lookback to ensure that only 50% of the employees actual compensation was charged to the program. Cause: The City did not have procedures in place to perform a lookback of budgeted costs charged to grant programs. Effect: The City overcharged the program by the excess of the budgeted costs against the actual costs. Questioned Costs: None reported. Context/Sampling: We selected 100% of the City’s payroll costs of the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City establish procedures to perform a lookback of budgeted expenditures charged to grants. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.
Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Procurement Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: Per 2 CFR part 200, subpart D, section 200.303, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award is compliance with federal statues, regulations, and the terms and conditions of the federal award. Prior to entering into subawards and contracts with award funds, recipients must verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded pursuant to 31 CFR section 19.300. Condition: We identified that the City’s purchasing and contracting policy does not require the verification of the debarment and suspension status of vendors prior to entering into agreements. We also noted that the City did not maintain documentation that they verified that the contractor was not suspended or debarred prior to entering into a covered transaction. Cause: The City’s policy does not require the verification of the debarment and suspension of a vendor prior to entering into a covered transaction, nor does it address on what type of documentation should be maintained to ensure they are not suspended and debarred. Effect: Noncompliance with these requirements could result in disbursements of Federal funds to suspended and debarred parties. Questioned Costs: None reported. Context/Sampling: We selected 2 out of 4 of the City’s procurement transactions associated with the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City include policies and procedures within their procurement policy to check whether or not vendors are suspended and debarred and to maintain that documentation within the procurement file. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.
Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: 2 CFR 200.303(a) requires that the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: We noted that the supporting documentation provided did not tie to the annual report submitted by the City or evidence of review. Cause: The City’s internal control environment was impacted by a shortage of staff necessary to fully conduct the program. Effect: The City’s reports on the awards were not reviewed for accuracy. Questioned Costs: None reported. Context/Sampling: We selected 100% of the City’s reports for the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City continue to strengthen its policies and procedures over reporting to ensure that that the supporting documentation and evidence of review is maintained. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.
Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Allowable Costs Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: 2 CFR 200.430(g)(vii) states that budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: a) the system for establishing the estimates produces reasonable approximations of the activity performed; b) significant changes in the related work activity (as defined by the recipient’s written policies) are promptly identified and entered in to the records, and c) the recipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We found that although the City charged 50% of the budgeted amount of an employees compensation to the program, the City did not perform a lookback to ensure that only 50% of the employees actual compensation was charged to the program. Cause: The City did not have procedures in place to perform a lookback of budgeted costs charged to grant programs. Effect: The City overcharged the program by the excess of the budgeted costs against the actual costs. Questioned Costs: None reported. Context/Sampling: We selected 100% of the City’s payroll costs of the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City establish procedures to perform a lookback of budgeted expenditures charged to grants. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.
Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Procurement Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: Per 2 CFR part 200, subpart D, section 200.303, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award is compliance with federal statues, regulations, and the terms and conditions of the federal award. Prior to entering into subawards and contracts with award funds, recipients must verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded pursuant to 31 CFR section 19.300. Condition: We identified that the City’s purchasing and contracting policy does not require the verification of the debarment and suspension status of vendors prior to entering into agreements. We also noted that the City did not maintain documentation that they verified that the contractor was not suspended or debarred prior to entering into a covered transaction. Cause: The City’s policy does not require the verification of the debarment and suspension of a vendor prior to entering into a covered transaction, nor does it address on what type of documentation should be maintained to ensure they are not suspended and debarred. Effect: Noncompliance with these requirements could result in disbursements of Federal funds to suspended and debarred parties. Questioned Costs: None reported. Context/Sampling: We selected 2 out of 4 of the City’s procurement transactions associated with the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City include policies and procedures within their procurement policy to check whether or not vendors are suspended and debarred and to maintain that documentation within the procurement file. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.
Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: 2 CFR 200.303(a) requires that the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: We noted that the supporting documentation provided did not tie to the annual report submitted by the City or evidence of review. Cause: The City’s internal control environment was impacted by a shortage of staff necessary to fully conduct the program. Effect: The City’s reports on the awards were not reviewed for accuracy. Questioned Costs: None reported. Context/Sampling: We selected 100% of the City’s reports for the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City continue to strengthen its policies and procedures over reporting to ensure that that the supporting documentation and evidence of review is maintained. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.