Item 2023‐002 Property and Equipment Management Assistance Listing Number 93.600 Head Start Cluster U.S. Department of Health and Hum an Services Pass‐through Grant No. 09CH011437-03-04; 09CH011437-03-C3; 09HP000160-04-04 09HP000160-05-02; 09HE000035-01-C5; 09HE000035-01-C6 Condition – The Inventory tracking sheet did not contain all required asset information. Criteria – 2 CFR Part 200.313(d)(1) of the Uniform Guidance requires that property records must be maintained for equipment acquired under a federal award that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. Cause – The Agency did not include all required property information in its property records due to staff turnover. Questioned Costs – Not determinable. Effect – Failure to comply with equipment management requirements could result in noncompliance with the grant agreements. Recommendation – We recommend the Agency follow the requirements of 2 CFR Part 200.313 to ensure all assets are adequately accounted for. CRI also recommends that the Agency include all of the information required by the granting Agency and Uniform Guidance in one central tracking spreadsheet and include the following fields in addition to the items previously being tracked and that that spreadsheet is used to conduct a physical observation at least once every two years. • the source of funding for the property (including the Federal award identification number), • who holds title, • the acquisition date, • cost of the property, • percentage of Federal participation in the project costs for the Federal award under which the property was acquired, • use and • condition of the property, • and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Finding 2022 – 03 Property and Equipment Federal Program - Emergency Solutions Grant CFDA 14.231 Criteria: A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: The Organization has not taken physical inventory of its fixed assets purchased with grant funds. Effect: Assets purchased may be lost, damaged or stolen and could lead to loss of assets or the reporting of misleading financial information. Cause: The Organization does not have procedures in place to take inventory of equipment acquired under federal awards. Recommendation: Implement an inventory policy and procedures to verify existence and condition of assets acquired with federal awards at least every two years. Views of responsible officials: The Organization agrees with this finding and Program Directors will perform annual inventories of equipment within their respective departments.
Finding 2022 – 03 Property and Equipment Federal Program - Emergency Solutions Grant CFDA 14.231 Criteria: A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: The Organization has not taken physical inventory of its fixed assets purchased with grant funds. Effect: Assets purchased may be lost, damaged or stolen and could lead to loss of assets or the reporting of misleading financial information. Cause: The Organization does not have procedures in place to take inventory of equipment acquired under federal awards. Recommendation: Implement an inventory policy and procedures to verify existence and condition of assets acquired with federal awards at least every two years. Views of responsible officials: The Organization agrees with this finding and Program Directors will perform annual inventories of equipment within their respective departments.
Finding 2022 – 03 Property and Equipment Federal Program - Emergency Solutions Grant CFDA 14.231 Criteria: A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: The Organization has not taken physical inventory of its fixed assets purchased with grant funds. Effect: Assets purchased may be lost, damaged or stolen and could lead to loss of assets or the reporting of misleading financial information. Cause: The Organization does not have procedures in place to take inventory of equipment acquired under federal awards. Recommendation: Implement an inventory policy and procedures to verify existence and condition of assets acquired with federal awards at least every two years. Views of responsible officials: The Organization agrees with this finding and Program Directors will perform annual inventories of equipment within their respective departments.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.218 Program: CDBG-Entitlement Grants Cluster Award/Pass-Through Entity Identifying Numbers: HHI-21-03, HHI-22-21, NCIP-FY20-010 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Additionally, per the Uniform Guidance in 2 CFR §200.313, Equipment, property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. Further, a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR §200.313(d)(2)). Condition: Of the one transaction subject to equipment real property management requirements in 2022 we noted that: (1) There is no separate listing of equipment purchased using federal funds being maintained. However, no additional equipment was noted and no sales of equipment purchased with federal funding occurred in 2022. (2) No physical inventory count was performed for equipment purchased using federal funds in 2022. However, one would not be considered overdue until 2023. Cause: The Village does not have adequate policies and procedures in place regarding monitoring of equipment acquired under Federal awards. Effect or Potential Effect: There is a risk that inadequate recordkeeping of equipment could lead to misappropriation of assets and noncompliance with Federal regulations resulting in a return of Federal awards received. Questioned Costs: None. Context: This is a condition identified per review of the Village’s compliance with the specified requirements of one transaction. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend that Village implement policies, procedures, and controls that will ensure that equipment purchased under Federal awards are tracked and maintained, in order to adhere to Federal regulations related to equipment and its related maintenance. Views of Responsible Officials: Management agrees with the finding. Management will enhance and enforce existing policies regarding Equipment and Real Property management.
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.218 Program: CDBG-Entitlement Grants Cluster Award/Pass-Through Entity Identifying Numbers: HHI-21-03, HHI-22-21, NCIP-FY20-010 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Additionally, per the Uniform Guidance in 2 CFR §200.313, Equipment, property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. Further, a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR §200.313(d)(2)). Condition: Of the one transaction subject to equipment real property management requirements in 2022 we noted that: (1) There is no separate listing of equipment purchased using federal funds being maintained. However, no additional equipment was noted and no sales of equipment purchased with federal funding occurred in 2022. (2) No physical inventory count was performed for equipment purchased using federal funds in 2022. However, one would not be considered overdue until 2023. Cause: The Village does not have adequate policies and procedures in place regarding monitoring of equipment acquired under Federal awards. Effect or Potential Effect: There is a risk that inadequate recordkeeping of equipment could lead to misappropriation of assets and noncompliance with Federal regulations resulting in a return of Federal awards received. Questioned Costs: None. Context: This is a condition identified per review of the Village’s compliance with the specified requirements of one transaction. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend that Village implement policies, procedures, and controls that will ensure that equipment purchased under Federal awards are tracked and maintained, in order to adhere to Federal regulations related to equipment and its related maintenance. Views of Responsible Officials: Management agrees with the finding. Management will enhance and enforce existing policies regarding Equipment and Real Property management.
Federal Agencies: Department of Housing and Urban Development Federal Assistance Listing Numbers: 14.218 Program: CDBG-Entitlement Grants Cluster Award/Pass-Through Entity Identifying Numbers: HHI-21-03, HHI-22-21, NCIP-FY20-010 Criteria: The Uniform Guidance in 2 CFR §200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Additionally, per the Uniform Guidance in 2 CFR §200.313, Equipment, property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. Further, a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR §200.313(d)(2)). Condition: Of the one transaction subject to equipment real property management requirements in 2022 we noted that: (1) There is no separate listing of equipment purchased using federal funds being maintained. However, no additional equipment was noted and no sales of equipment purchased with federal funding occurred in 2022. (2) No physical inventory count was performed for equipment purchased using federal funds in 2022. However, one would not be considered overdue until 2023. Cause: The Village does not have adequate policies and procedures in place regarding monitoring of equipment acquired under Federal awards. Effect or Potential Effect: There is a risk that inadequate recordkeeping of equipment could lead to misappropriation of assets and noncompliance with Federal regulations resulting in a return of Federal awards received. Questioned Costs: None. Context: This is a condition identified per review of the Village’s compliance with the specified requirements of one transaction. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend that Village implement policies, procedures, and controls that will ensure that equipment purchased under Federal awards are tracked and maintained, in order to adhere to Federal regulations related to equipment and its related maintenance. Views of Responsible Officials: Management agrees with the finding. Management will enhance and enforce existing policies regarding Equipment and Real Property management.
2022-002 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing #84.425C, 2021G-797, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Equipment and Real Property Management Significant Deficiency in Internal Control over Compliance and Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. The non-Federal entity must conform with equipment and real property management procedures identified in 2 CFR 200.313 (c) through (e). Condition: In our sample of expenditures selected for testing, we noted the following items: a) No support to substantiate a physical inventory of federal-funded equipment was performed within the last two years. b) Federal-funded equipment is not distinguished separately from non-federal-funded equipment within the Club?s fixed asset listing. Cause: The Club has not implemented controls over equipment and real property management to comply with federal requirements. Effect: Without established controls over equipment and real property management, the risk is increased that equipment could be misappropriated or that the federal agency would not be reimbursed if federal funded equipment was disposed. Questioned Costs: None reported Context: There were two fixed asset purchases, totaling $444,129, charged to the federal award, which were both tested. Repeat Finding from Prior Year: No Recommendation: We recommend that management implement control processes to conform with the Uniform Guidance equipment and real property management requirements noted above. Views of Responsible Officials: Management is in agreement.
Finding 2022-003: Equipment and Real Property Management Identification of the federal program: Federal Equitable Sharing, ALN 16.922 Criteria: Compliance Requirement F Equipment /Real Property Management in in Part 4 of the 2022 Compliance Supplement for this program states that, ?Although 2 CFR Sections 200.311 and 313 are not applicable, the Guide, Section VI, details requirements for tangible property. Property purchased with equitable sharing funds, or obtained for official use, is subject to inventory control, log maintenance, and disposal requirements.? The Guide states the local law enforcement agency must ?maintain and follow written policies for accounting, bookkeeping and inventory control?? The requirement for inventory control in 2 CFR 200.313 (d)((1) states procedures for managing equipment include, ?Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and the cost percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property.? Condition: The County maintains an inventory of equipment, however that inventory does not include the acquisition date, the source of funding, the cost percentage of Federal participation or federal award data. Disposed assets are deleted from the inventory and disposition data is not maintained. The inventory record is not complete enough to determine compliance with the Guide. Source documents supporting entries in the inventory record have not been retained. Cause: The county had an existing asset management software but developed its own inventory system exclusively using an Excel spreadsheet in 2022. The compliance requirements were not adequately considered when developing the spreadsheet and there was no effective internal control over its development and use. Effect: Denial or extinguishment of sharing requests; temporary or permanent exclusion from the Program; freeze on receipt and/or expenditure of shared funds; return of funds or offsets from future sharing. Questioned Costs: Not applicable Context: The inventory record does identify the equipment, its serial or other number and its location. Assets purchased using federal funds from other programs would also be subject to the same condition. Recommendation: The existing system should be modified be compliant with the Uniform Guidance requirements, or a specifically designed software should be used. Source documents supporting inventory records should be retained. Disposition data should be maintained. Views of Responsible Officials: Management concurs with this finding and recommendation.
Compliance Matrix: Equipment and Real Property Management ? 14.228 ? Community Development Block Grants/State?s Program and Non-Entitlement Grant in Hawaii, Grant #B-06-BG-22-0001 Criteria: An entity must use, manage, and dispose of equipment acquired under a federal award in accordance with 2 CFR section 200.313 (d) (2) which requires a physical inventory of the property must be taken and results reconciled with the property records at least once every two years. Condition/Context: During our testing of the Community Development Block Grants/State?s Program, we noted that the City was unable to provide a reconciliation of the physical inventory to the property records. Cause: The City does not have adequate processes and controls in place to ensure that the physical inventory is taken at least once every two years and reconciled to the property records. Effect: The City could not provide supporting documentation that the required physical inventory and reconciliation to the property records was performed. Questioned Costs: For the purposes of this finding, there were no questioned costs. Identification of a repeat finding: This is a repeat finding from the previous audit, 2021-002. Recommendation: We recommend the City strengthen internal controls to ensure that the City maintains record of the physical inventory and reconciliations to the property records. Current Status: The City provided auditors? with documentation showing that a physical inventory of the property was conducted in January 2023. The physical inventory was conducted after the fiscal year- end of the compliance period being tested. Based upon the documentation provided to the auditors, we find the issue to be resolved.
FINDING 2022-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Equipment and Real Property Management Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): CY 2022 Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Noncompliance Condition and Context State and Local Fiscal Recovery Funds (SLFRF) may be used to acquire real and personal property, supplies, and equipment. Equipment purchased with SLFRF funds requires management, among other things, to maintain property records, complete a physical inventory, safeguard against loss, and properly maintain the equipment. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased. The County did not maintain adequate property records for assets purchased with SLFRF award funds. A population of 23 assets, totaling $812,524, paid from SLFRF funds during the audit period was identified. A sample of 5 assets, totaling $329, 394, were selected for testing. Of the 5 assets tested, 2 were not added to the property records and 3, while added to the property records, did not have the appropriate identifying information to show the assets were purchased with federal grant funds. Assets purchased with SLFRF award funds are to be used for the originally authorized purpose as long as needed for that purpose, during which time the County must not dispose of or encumber its title or other interests. If the real property is no longer needed for the originally authorized purpose instructions from the federal awarding agency that provide for one of three alternatives are required. The alternatives include retaining title after compensating the federal awarding agency, selling the property and compensating the federal awarding agency or transferring title to the federal awarding agency or to a third-party designated/approved by the federal awarding agency. During the audit period, the County had one disposal. The disposal was a building that was originally purchased with SLFRF grant funds in 2021 for $201,631. At the time of purchase, the County did not obtain the required appraisals, as such the purchase was considered a questioned cost in the prior audit. In 2022, the County had an agreement to sell the building to a non-profit organization for $200,000. However, the County did not adhere to the agreement, nor request instruction from the federal awarding agency. Instead, the County gave the building, without approval from the federal awarding agency, to the non-profit organization. As such, the County did not follow proper protocol for the disposition of real property. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313 states in part: ". . . (d) Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. . . ." 2 CFR 200.311 states in part: ". . . (c) Disposition. When real property is no longer needed for the originally authorized purpose, the non-Federal entity must obtain disposition instructions from the Federal awarding agency or pass-through entity. The instructions must provide for one of the following alternatives: (1) Retain title after compensating the Federal awarding agency. The amount paid to the Federal awarding agency will be computed by applying the Federal awarding agency's percentage of participation in the cost of the original purchase (and costs of any improvements) to the fair market value of the property. However, in those situations where the non-Federal entity is disposing of real property acquired or improved with a Federal award and acquiring replacement real property under the same Federal award, the net proceeds from the disposition may be used as an offset to the cost of the replacement property. (2) Sell the property and compensate the Federal awarding agency. The amount due to the Federal awarding agency will be calculated by applying the Federal awarding agency's percentage of participation in the cost of the original purchase (and cost of any improvements) to the proceeds of the sale after deduction of any actual and reasonable selling and fixing-up expenses. If the Federal award has not been closed out, the net proceeds from sale may be offset against the original cost of the property. When the non-Federal entity is directed to sell property, sales procedures must be followed that provide for competition to the extent practicable and result in the highest possible return. (3) Transfer title to the Federal awarding agency or to a third party designated/approved by the Federal awarding agency. The non-Federal entity is entitled to be paid an amount calculated by applying the non-Federal entity's percentage of participation in the purchase of the real property (and cost of any improvements) to the current fair market value of the property." Cause A proper system of internal controls was not designed by management of the County. Embedded within a properly designed and implemented internal control system should be controls consisting of policies and procedures. Policies reflect the County's management of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, not all required elements of the property record were documented for assets acquired with SLFRF award funds, nor was an asset properly disposed of. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County establish a proper system of internal controls and develop policies and procedures to ensure property records contain all required elements and that assets are properly disposed of. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Criteria - Management is responsible for maintaining capital asset records that are accurate. Code of Federal Regulations (CFR) ?200.313(d) Equipment states, at a minimum, the following must be met: 1. Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. 2. A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. 3. A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. 4. Adequate maintenance procedures must be developed to keep the property in good condition. 5. If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. Condition - The capital asset records are insufficient as they do not include the source of funding, acquisition date, or the cost of the property as well as certain other information required by Federal regulations. Additionally, no physical inventory has occurred nor is there a control system that has been implemented over these assets. Effect of Condition - The Town is not in compliance with CFR ?200.313(d). Additionally, capital assets have been excluded from these financial statements. Recommendation - We recommend the Town invest in capital asset software to maintain the capital assets and have a physical inventory performed. Management?s Response - (2) Audit Finding 2022-002 - The Town did not have accurate capital asset records. (a) Implementation Plan of Actions - The Town is looking into capital asset software and is having a physical inventory performed. (b) Implementation Date - This will be implemented for the year ended December 31, 2023. (c) Persons Responsible for Implementation - The Town Board and Supervisor of the Town of Alexander.
2022-004 Department of Health and Human Services Federal Financial Assistance Listing #93.697 COVID-19 Testing and Mitigation for Rural Health Clinics Equipment and Real Property Management Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over federal awards that provides reasonable assurance that the Facility is managing the federal award in compliance with federal statutes, regulations and terms and conditions of the federal award. The non-Federal entity must conform with equipment and real property management procedures identified in 2 CFR 200.313 (c) through (e). Condition: Federal-funded equipment and real property is not distinguished separately from non-federal-funded equipment and real property within the Facility?s fixed asset listing. Cause: The Facility has not implemented controls over equipment and real property management to comply with federal requirements. Effect: Without established internal controls over equipment and real property management, there is an increased risk that equipment and real property could be misappropriated or the federal agency would not be notified or reimbursed if the federal funded equipment and real property was disposed. Questioned Costs: None reported. Context: A nonstatistical sample of 3 ($52,061) from a population of 13 capitalized assets ($88,913) were tested. Repeat Finding from Prior Years: No Recommendation: We recommend the Facility implement control processes to conform with the Uniform Guidance equipment and real property management requirements noted above. Views of Responsible Officials: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: ? Equipment (2 CFR 200.313) ? General procurement standards (2 CFR 200.318) ? Competition (2 CFR 200.319) ? Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management?s Response: Management agrees with the finding.
Assistance Listing Number(s): 21.027 Name of Federal Program or Cluster: Coronavirus State and Local Fiscal Recovery Funds Name of Federal Agency: Department of the Treasury Name of Pass-through Entity: The Salvation Army of Dane County Criteria or Specific Requirement: 2 CFR section 200.313(i) requires non-federal entities to maintain records sufficient to detail the history of procurement, including, but not necessarily limited to, the rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. Condition: YWCA?s internal controls over review of procurement methods, rationale, and decisions, were not properly documented. Cause: Written policies and procedures for procurement did not include who was responsible, what documentation is required, and retention of the control documentation for procurement methods, rationale, and decisions. In addition, YWCA experienced turnover in the CFO position, which is responsible for reviewing and approving procurement methods, rationale, and decisions. Effect or Potential Effect: Contracts entered into may be disallowed. Repeat Finding: No. Recommendation: We recommend written policies and procedures over procurement to be established to clearly document who is responsible for reviewing, what is to be reviewed, and how and where to document the review of procurement methods, rationale, and decisions. Views of Responsible Officials: YWCA agrees with the finding and is establishing policies and procedures to provide for documentation and review of procurement methods, rationale, and decisions. This is expected to be completed by September 2023.
2022-003 - Emergency Solutions Grant - Assistance Listing No. 14.231 Significant Deficiency in Internal Control Over Compliance and Noncompliance – F. Equipment and Real Property Management Criteria: 2 CFR 200.303 includes requirements related to internal controls for federal award programs, including that the Agency must, among other things, “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.” These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)”. 2 CFR 200.313 includes requirements related to maintaining records of equipment purchased at a value with equals or exceeds the lesser of the Organization’s capitalization threshold or $5,000. “Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property.” Condition and Context: During 2022, FSA purchased equipment of $1,236. FSA’s capitalization threshold of $1,000. FSA did not capitalize the equipment. Due to the fact that FSA did not capitalize the equipment purchased, the equipment was not appropriately tracked in accordance with Uniform Guidance. Cause and Effect: We noted a lack of internal controls surrounding the equipment and real property management process resulted in equipment not appropriately being capitalized and tracked in accordance with federal guidelines. This deficiency could also lead to noncompliance related to the disposal of equipment and real property purchased with federal funds. Recommendation: We recommend FSA implement procedures to ensure equipment and real property purchased with federal funding is appropriately capitalized and tracked. Views of Responsible Officials and Planned Corrective Actions: Family Service Association of Howard County, Inc. (FSA) acknowledges and agrees with the audit findings. We are actively working on ways to enhance our systems and improve staff training and staff transition to address the identified areas of improvement. Our goal is to ensure that we meet the highest standards. Family Service Association of Howard County Inc. (FSA) will implement procedures to ensure equipment and real property purchased with federal funding is appropriately capitalized and tracked beginning April 2024.
2022-003: Evidence of physical inspection of equipment purchased with federal funds was not maintained ? Significant deficiencyCluster: Not applicableFederal Granting Agency: Health Resources and Services Administration (?HRSA?)Award Name: COVID-19 National Bioterrorism Hospital Preparedness Program (?Bioterrorism Program?)Award #: N/AAssistance Listing #: 93.889Award Year: Fiscal year 2022Pass-through entity: North Carolina Healthcare Foundation; North Carolina Department of Health and Human Services ? Division of Health Service Regulation, Office of Emergency Medical ServicesPass-through award #: U3REP 200659; 42705; 44024Condition:As part of our testing over the equipment compliance requirements related to the Bioterrorism Program, we noted no physical inventory of equipment performed by management that was purchased with federal funds since the inception of the grants in July 2019. Management has noted that routine maintenance checks are performed periodically on all equipment, however, we were unable to obtain management?s evidence of these checks for our 25 selections. At the end of the fiscal year, there were approximately 225 pieces of equipment with a value of approximately $800,000.Criteria:2 CFR 200.313 d(2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years.Cause:Management?s process and controls do not include performing a formal physical inventory of federal equipment and retaining evidence of this process at least once every two years and management was not aware of this requirement.Effect:The Company may not maintain complete and accurate property records or safeguard equipment appropriately.Recommendation:We recommend the Company create a control and revise its process surrounding physical inventories of equipment to include a requirement that the inventory is completed in accordance with the criteria noted above. Additionally, a full inventory of all equipment should be performed as soon as practical.Management?s Views and Corrective Action Plan:Management?s views and corrective action plan is included at the end of this report after the summary schedule of prior audit findings and status.
2022-003: Evidence of physical inspection of equipment purchased with federal funds was not maintained ? Significant deficiencyCluster: Not applicableFederal Granting Agency: Health Resources and Services Administration (?HRSA?)Award Name: COVID-19 National Bioterrorism Hospital Preparedness Program (?Bioterrorism Program?)Award #: N/AAssistance Listing #: 93.889Award Year: Fiscal year 2022Pass-through entity: North Carolina Healthcare Foundation; North Carolina Department of Health and Human Services ? Division of Health Service Regulation, Office of Emergency Medical ServicesPass-through award #: U3REP 200659; 42705; 44024Condition:As part of our testing over the equipment compliance requirements related to the Bioterrorism Program, we noted no physical inventory of equipment performed by management that was purchased with federal funds since the inception of the grants in July 2019. Management has noted that routine maintenance checks are performed periodically on all equipment, however, we were unable to obtain management?s evidence of these checks for our 25 selections. At the end of the fiscal year, there were approximately 225 pieces of equipment with a value of approximately $800,000.Criteria:2 CFR 200.313 d(2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years.Cause:Management?s process and controls do not include performing a formal physical inventory of federal equipment and retaining evidence of this process at least once every two years and management was not aware of this requirement.Effect:The Company may not maintain complete and accurate property records or safeguard equipment appropriately.Recommendation:We recommend the Company create a control and revise its process surrounding physical inventories of equipment to include a requirement that the inventory is completed in accordance with the criteria noted above. Additionally, a full inventory of all equipment should be performed as soon as practical.Management?s Views and Corrective Action Plan:Management?s views and corrective action plan is included at the end of this report after the summary schedule of prior audit findings and status.
2022-003: Evidence of physical inspection of equipment purchased with federal funds was not maintained ? Significant deficiencyCluster: Not applicableFederal Granting Agency: Health Resources and Services Administration (?HRSA?)Award Name: COVID-19 National Bioterrorism Hospital Preparedness Program (?Bioterrorism Program?)Award #: N/AAssistance Listing #: 93.889Award Year: Fiscal year 2022Pass-through entity: North Carolina Healthcare Foundation; North Carolina Department of Health and Human Services ? Division of Health Service Regulation, Office of Emergency Medical ServicesPass-through award #: U3REP 200659; 42705; 44024Condition:As part of our testing over the equipment compliance requirements related to the Bioterrorism Program, we noted no physical inventory of equipment performed by management that was purchased with federal funds since the inception of the grants in July 2019. Management has noted that routine maintenance checks are performed periodically on all equipment, however, we were unable to obtain management?s evidence of these checks for our 25 selections. At the end of the fiscal year, there were approximately 225 pieces of equipment with a value of approximately $800,000.Criteria:2 CFR 200.313 d(2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years.Cause:Management?s process and controls do not include performing a formal physical inventory of federal equipment and retaining evidence of this process at least once every two years and management was not aware of this requirement.Effect:The Company may not maintain complete and accurate property records or safeguard equipment appropriately.Recommendation:We recommend the Company create a control and revise its process surrounding physical inventories of equipment to include a requirement that the inventory is completed in accordance with the criteria noted above. Additionally, a full inventory of all equipment should be performed as soon as practical.Management?s Views and Corrective Action Plan:Management?s views and corrective action plan is included at the end of this report after the summary schedule of prior audit findings and status.
Finding 2022-011 Equipment and Real Property Management - Material Noncompliance and Material Weakness in Internal Controls Over Compliance Agency/Passthrough Grantor Department of Health and Human Services passed through the State of Alaska Department of Health and Social Services ALN and Program Name 93.323 – COVID-19-Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Award # C0621-570-BB Award Year 3/15/2021-6/30/2022 Criteria or Specific Requirement The regulations in 2 CFR 200.313(d)(1) notes equipment and real property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. Condition We reviewed a sample of 6 items owned by the Municipality and noted 1 instance in which managements internal controls were not functioning as designed, and in which equipment records were not properly maintained. Cause Controls to review and track equipment and real property funded by federal awards are not properly maintained by program personnel. In addition, there is no reconciliation from the program equipment and real property lists to the general ledger detail to ensure all equipment and/or real property is being recorded and properly capitalized, if applicable. Effect or Potential Effect The Municipality was not in compliance with Equipment and Real Property requirements outlined in 2 CRF 200.313. The Municipality could be exposed to a reduction or elimination of funds by the Federal awarding agency. Questioned costs Not applicable Context For Epidemiology and Laboratory Capacity for Infectious Diseases we selected a sample of 6 items of equipment with a book value of $848,963 from a population of 41 items with a total book value of $886,733 and noted 1 exception with a book value of $843,569. The sample tested was selected using nonstatistical sampling methods and was not a statistically valid sample. Identification as a repeat finding Not a repeat finding. Recommendation We recommend an inventory is completed at least annually to compare items purchased with federal funds to counts and the values recorded in the general ledger. Views of Responsible Officials Management agrees with this finding. Staff will perform regular reconciliations for the equipment and real property listing to ensure that its accuracy is maintained.
Finding 2022-012 Equipment and Real Property Management - Noncompliance and Significant Deficiency in Internal Control Over Compliance Agency/Passthrough Grantor Department of Transportation passed through the State of Alaska Department of Transportation and Public Facilities ALN and Program Name 20.205 – Highway Planning and Construction Cluster Award # AMATS 2023, AK-26-0003-01 Award Year 2022, 2015 Criteria or Specific Requirement The regulations in 2 CFR 200.313(d) includes the following provisions: (1) equipment and real property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. (2) A Physical Inventory of the property must be taken and the results reconciled with the property records at least once every two years (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Condition We reviewed a sample of 4 items owned by the Municipality and noted 3 instances in which management’s internal controls were not functioning as designed, and in which equipment records were not properly maintained. Furthermore, there was no documentation of a physical inventory being performed that was subsequently reconciled to the property records. Cause Controls to review, inventory, and track equipment and real property funded by federal awards are not properly maintained by program personnel. In addition, there is no reconciliation from the program equipment and real property lists to the general ledger detail to ensure all equipment and/or real property is being recorded and properly capitalized, if applicable. Effect or Potential Effect The Municipality was not in compliance with Equipment and Real Property requirements outlined in 2 CRF 200.313. The Municipality could be exposed to a reduction or elimination of funds by the Federal awarding agency. Questioned Costs Not applicable. Context For the Highway Planning and Construction Cluster we selected a sample of 4 items of equipment with a book value of $9,382 from a population of 27 items with a total book value of $132,626 and noted 4 exceptions with a book value of $9,382. The sample tested was selected using nonstatistical sampling methods and was not a statistically valid sample. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend an inventory is completed at least annually to compare items purchased with federal funds to counts and the values recorded in the general ledger. Views of Responsible Officials Management agrees with this finding. Staff will perform regular reconciliations for the equipment and real property listing to ensure that its accuracy is maintained.
Finding 2022-012 Equipment and Real Property Management - Noncompliance and Significant Deficiency in Internal Control Over Compliance Agency/Passthrough Grantor Department of Transportation passed through the State of Alaska Department of Transportation and Public Facilities ALN and Program Name 20.205 – Highway Planning and Construction Cluster Award # AMATS 2023, AK-26-0003-01 Award Year 2022, 2015 Criteria or Specific Requirement The regulations in 2 CFR 200.313(d) includes the following provisions: (1) equipment and real property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. (2) A Physical Inventory of the property must be taken and the results reconciled with the property records at least once every two years (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Condition We reviewed a sample of 4 items owned by the Municipality and noted 3 instances in which management’s internal controls were not functioning as designed, and in which equipment records were not properly maintained. Furthermore, there was no documentation of a physical inventory being performed that was subsequently reconciled to the property records. Cause Controls to review, inventory, and track equipment and real property funded by federal awards are not properly maintained by program personnel. In addition, there is no reconciliation from the program equipment and real property lists to the general ledger detail to ensure all equipment and/or real property is being recorded and properly capitalized, if applicable. Effect or Potential Effect The Municipality was not in compliance with Equipment and Real Property requirements outlined in 2 CRF 200.313. The Municipality could be exposed to a reduction or elimination of funds by the Federal awarding agency. Questioned Costs Not applicable. Context For the Highway Planning and Construction Cluster we selected a sample of 4 items of equipment with a book value of $9,382 from a population of 27 items with a total book value of $132,626 and noted 4 exceptions with a book value of $9,382. The sample tested was selected using nonstatistical sampling methods and was not a statistically valid sample. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend an inventory is completed at least annually to compare items purchased with federal funds to counts and the values recorded in the general ledger. Views of Responsible Officials Management agrees with this finding. Staff will perform regular reconciliations for the equipment and real property listing to ensure that its accuracy is maintained.
Finding 2022-013 Equipment and Real Property Management - Noncompliance and Significant Deficiency in Internal Control Over Compliance Agency/Passthrough Grantor Department of Transportation passed through the State of Alaska Department of Transportation and Public Facilities, Department of Health and Human Services passed through the State of Alaska Department of Health and Social Services ALN and Program Name 20.205 – Highway Planning and Construction Cluster 93.323 – COVID-19-Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Award # 93.323 – C0621-570-BB 20.205 – AMATS 2023, AK-26-0003-01 Award Year 93.323 - 3/15/2021-6/30/2022 20.205 – 2022, 2015 Criteria or Specific Requirement The regulations in 2 CFR 200.313(d)(1) notes equipment and real property records must be maintained that include disposition data including the date of disposal and sales price of property. Condition Testing of a sample of 5 items that were disposed of during the year identified 5 instances in which management’s internal controls were not functioning as designed and equipment disposals were not properly reflected in the property records. Cause Management did not have in place sufficient controls over the disposal of equipment to ensure proper recording of disposals of equipment. Equipment records are not reviewed by individuals with necessary skills, knowledge, and experience to ensure records are updated properly. Effect or Potential Effect Anchorage was not in compliance with Equipment and Real Property requirements outlined in 2 CRF Sections 200.313. Anchorage could be exposed to a reduction or elimination of funds by the Federal awarding agency. Questioned Costs Not applicable. Context For the Highway Planning and Construction Cluster, we selected all 4 items of equipment identified as being disposed during the year which totaled $18,537 and noted 4 exceptions where assets were recorded as disposed which were still in service. For Epidemiology and Laboratory Capacity for Infectious Diseases, we selected the 1 item of equipment disposed which was $2,910 and noted 1 exception where management did not approve of the disposed equipment. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend an inventory is completed at least annually to compare items purchased with federal funds to counts and the values recorded in the general ledger. Views of Responsible Officials Management agrees with this finding will enhance controls over the review and disposal of equipment and real property and enhance supervisory reviews over this accounting function.
Finding 2022-013 Equipment and Real Property Management - Noncompliance and Significant Deficiency in Internal Control Over Compliance Agency/Passthrough Grantor Department of Transportation passed through the State of Alaska Department of Transportation and Public Facilities, Department of Health and Human Services passed through the State of Alaska Department of Health and Social Services ALN and Program Name 20.205 – Highway Planning and Construction Cluster 93.323 – COVID-19-Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Award # 93.323 – C0621-570-BB 20.205 – AMATS 2023, AK-26-0003-01 Award Year 93.323 - 3/15/2021-6/30/2022 20.205 – 2022, 2015 Criteria or Specific Requirement The regulations in 2 CFR 200.313(d)(1) notes equipment and real property records must be maintained that include disposition data including the date of disposal and sales price of property. Condition Testing of a sample of 5 items that were disposed of during the year identified 5 instances in which management’s internal controls were not functioning as designed and equipment disposals were not properly reflected in the property records. Cause Management did not have in place sufficient controls over the disposal of equipment to ensure proper recording of disposals of equipment. Equipment records are not reviewed by individuals with necessary skills, knowledge, and experience to ensure records are updated properly. Effect or Potential Effect Anchorage was not in compliance with Equipment and Real Property requirements outlined in 2 CRF Sections 200.313. Anchorage could be exposed to a reduction or elimination of funds by the Federal awarding agency. Questioned Costs Not applicable. Context For the Highway Planning and Construction Cluster, we selected all 4 items of equipment identified as being disposed during the year which totaled $18,537 and noted 4 exceptions where assets were recorded as disposed which were still in service. For Epidemiology and Laboratory Capacity for Infectious Diseases, we selected the 1 item of equipment disposed which was $2,910 and noted 1 exception where management did not approve of the disposed equipment. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend an inventory is completed at least annually to compare items purchased with federal funds to counts and the values recorded in the general ledger. Views of Responsible Officials Management agrees with this finding will enhance controls over the review and disposal of equipment and real property and enhance supervisory reviews over this accounting function.
Finding 2022-013 Equipment and Real Property Management - Noncompliance and Significant Deficiency in Internal Control Over Compliance Agency/Passthrough Grantor Department of Transportation passed through the State of Alaska Department of Transportation and Public Facilities, Department of Health and Human Services passed through the State of Alaska Department of Health and Social Services ALN and Program Name 20.205 – Highway Planning and Construction Cluster 93.323 – COVID-19-Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Award # 93.323 – C0621-570-BB 20.205 – AMATS 2023, AK-26-0003-01 Award Year 93.323 - 3/15/2021-6/30/2022 20.205 – 2022, 2015 Criteria or Specific Requirement The regulations in 2 CFR 200.313(d)(1) notes equipment and real property records must be maintained that include disposition data including the date of disposal and sales price of property. Condition Testing of a sample of 5 items that were disposed of during the year identified 5 instances in which management’s internal controls were not functioning as designed and equipment disposals were not properly reflected in the property records. Cause Management did not have in place sufficient controls over the disposal of equipment to ensure proper recording of disposals of equipment. Equipment records are not reviewed by individuals with necessary skills, knowledge, and experience to ensure records are updated properly. Effect or Potential Effect Anchorage was not in compliance with Equipment and Real Property requirements outlined in 2 CRF Sections 200.313. Anchorage could be exposed to a reduction or elimination of funds by the Federal awarding agency. Questioned Costs Not applicable. Context For the Highway Planning and Construction Cluster, we selected all 4 items of equipment identified as being disposed during the year which totaled $18,537 and noted 4 exceptions where assets were recorded as disposed which were still in service. For Epidemiology and Laboratory Capacity for Infectious Diseases, we selected the 1 item of equipment disposed which was $2,910 and noted 1 exception where management did not approve of the disposed equipment. Identification as a Repeat Finding Not a repeat finding. Recommendation We recommend an inventory is completed at least annually to compare items purchased with federal funds to counts and the values recorded in the general ledger. Views of Responsible Officials Management agrees with this finding will enhance controls over the review and disposal of equipment and real property and enhance supervisory reviews over this accounting function.
U.S. Department of Housing and Urban Development - Community Development Block Grants/ Entitlement Grants Cluster (ALN #14.218) Condition: During the audit, it was noted that the City was not conducting an inventory of equipment and real property purchased with CDBG grants funds. Criteria: The Code of Federal Regulations [2 CFR section 200.313(d)(1) and 200.313(d)(2)] requires equipment and real property records must be maintained that include a description of the property or equipment, a serial or identification number (if applicable), the source of funding, acquisition date, cost of the property or equipment, location, and condition. In addition, the Code of Federal Regulations requires that a physical inventory of equipment and real property must be taken, and the results reconciled with the records at least once every two years. Cause: The City does not have controls in place to ensure that an inventory of equipment and real property purchased with grant funds is being conducted and maintained. Effect: The City is not in compliance with the Equipment and Real Property federal requirements. Failure to comply with grant award requirements could jeopardize future funding. Questioned Costs: This finding does not result in questioned costs. Recommendations: We recommend that the City implement procedures to ensure that all federal equipment and real property requirements are followed, including maintaining an accurate and complete listing of equipment and real property purchased with grant funds and conducting an inventory on those items at least every two years. Views of Responsible Officials: Expenditures of CDBG grant funding for capital outlays on equipment and real property are readily identifiable within the City’s fixed assets module of the accounting system, including subsequent retirements of any such capital assets. The Department acknowledges related physical inventory observations to identify these assets have not been consistently performed. The Department will work to formalize such inventory procedures working off of an available assets listing generated from within the fixed assets system. The City will look to complete such process as soon as is feasibly possible.
FINDING 2022-002 Information on the federal program: Subject: Water and Waste Disposal Systems for Rural Communities – Equipment and Real Property Management Federal Agency: U.S. Department of Agriculture Assistance Listing Number: 10.760 Federal Award Number: 92-02 92-03 Pass-Through Entity: N/A Compliance Requirements: Equipment and Real Property Management Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.313(d)(1) states in part: "Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property" Condition: An effective internal control system was not in place at the City to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. Cause: Management had not established a system of internal control that would have ensured proper procedures are followed to comply with the Equipment and Real Property Management compliance requirements. Effect: The failure to establish an effective internal control system enabled noncompliance to go undetected and the proper tracking of assets acquired with federal funds was not taking place. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have resulted in the loss of federal funds to the City. Questioned Costs: There were no questioned costs identified. Context: The City did not maintain an updated asset listing that reflects the construction in process balance related to the project funded with federal funds. Identification as a repeat finding, if applicable: No Recommendation: We recommend that the City’s management establish controls related to the grant agreement and the Equipment and Real Property compliance requirement to ensure that assets being purchased with federal funds are added to the capital asset listing and all required information is maintained on the capital asset listing. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster AL Number Award Number Award Period Grant Name 20.509 A18AV01093/218AV00785 1/1/2018-9/30/2023 Road Maintenance Programs Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) 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. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated (2 CFR section 200.313(d)(3)). Condition/Context: Management has not implemented an effective internal control system. • A physical inventory was taken in 2021 but was not reconciled to the general ledger. 15.029 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. 20.205 • A physical inventory was conducted in 2021; however, there were no documented controls over the inventory, and it was not reconciled to the property records. • 3 of 3 Individually Important Items (IIIs) equipment additions did not have all required approvals. • 1 of 2 equipment addition samples had no support provided. • 1 of 2 equipment addition samples did not have all required approvals. 20.509 • A physical inventory was conducted in 2021; however, there were no documented controls over the Inventory, and it was not reconciled to the property records. • 6 of 6 equipment samples including prior year equipment did not have support provided. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Due to turnover in key personnel, Joint Programs had a breakdown in internal controls during 2022. Effect: Without an effective internal control system, an entity’s objective: operations, reporting, and compliance cannot be achieved. In addition, property records can be incorrect, and property can be damaged or lost without the knowledge of management. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-004. Recommendation: We recommend that Joint Programs use the Green Book to design, implement, and operate internal controls to achieve its objectives related to operations, reporting, and compliance. In addition, we recommend that the physical inventory taken is reconciled with the property records at least once every two years. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Finding 2022 – 03 Property and Equipment Federal Program - Emergency Solutions Grant CFDA 14.231 Criteria: A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: The Organization has not taken physical inventory of its fixed assets purchased with grant funds. Effect: Assets purchased may be lost, damaged or stolen and could lead to loss of assets or the reporting of misleading financial information. Cause: The Organization does not have procedures in place to take inventory of equipment acquired under federal awards. Recommendation: Implement an inventory policy and procedures to verify existence and condition of assets acquired with federal awards at least every two years. Views of responsible officials: The Organization agrees with this finding and Program Directors will perform annual inventories of equipment within their respective departments.
Finding 2022 – 03 Property and Equipment Federal Program - Emergency Solutions Grant CFDA 14.231 Criteria: A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: The Organization has not taken physical inventory of its fixed assets purchased with grant funds. Effect: Assets purchased may be lost, damaged or stolen and could lead to loss of assets or the reporting of misleading financial information. Cause: The Organization does not have procedures in place to take inventory of equipment acquired under federal awards. Recommendation: Implement an inventory policy and procedures to verify existence and condition of assets acquired with federal awards at least every two years. Views of responsible officials: The Organization agrees with this finding and Program Directors will perform annual inventories of equipment within their respective departments.
Finding 2022 – 03 Property and Equipment Federal Program - Emergency Solutions Grant CFDA 14.231 Criteria: A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: The Organization has not taken physical inventory of its fixed assets purchased with grant funds. Effect: Assets purchased may be lost, damaged or stolen and could lead to loss of assets or the reporting of misleading financial information. Cause: The Organization does not have procedures in place to take inventory of equipment acquired under federal awards. Recommendation: Implement an inventory policy and procedures to verify existence and condition of assets acquired with federal awards at least every two years. Views of responsible officials: The Organization agrees with this finding and Program Directors will perform annual inventories of equipment within their respective departments.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: • Equipment (2 CFR 200.313) • General procurement standards (2 CFR 200.318) • Competition (2 CFR 200.319) • Methods of procurement to be followed (2 CFR 200.320) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town’s management was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management’s Response: Management agrees with the finding.