Audit 5067

FY End
2022-06-30
Total Expended
$4.07M
Findings
14
Programs
9
Year: 2022 Accepted: 2023-12-04

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
3124 2022-002 Material Weakness - ABFHJLN
3125 2022-002 Material Weakness - ABFHJLN
3126 2022-002 Material Weakness - ABFHJLN
3127 2022-002 Material Weakness - ABFHJLN
3128 2022-002 Material Weakness - ABFHJLN
3129 2022-002 Material Weakness - ABCGHI
3130 2022-002 Material Weakness - ABCGHI
579566 2022-002 Material Weakness - ABFHJLN
579567 2022-002 Material Weakness - ABFHJLN
579568 2022-002 Material Weakness - ABFHJLN
579569 2022-002 Material Weakness - ABFHJLN
579570 2022-002 Material Weakness - ABFHJLN
579571 2022-002 Material Weakness - ABCGHI
579572 2022-002 Material Weakness - ABCGHI

Contacts

Name Title Type
NYNHWG7TN2F1 Diane Mulholland Auditee
6035427026 Tammy R. Webb Auditor
No contacts on file

Notes to SEFA

Title: NOTE 1 - BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting for federal programs accounted for in the governmental funds, and on the accrual basis of accounting for federal programs accounted for in the proprietary funds, which is described in Note 1 to the City's basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (the "Schedule") includes the federal award activity of the City of Claremont, New Hampshire (the City) under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirement for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City.
Title: NOTE 4 - RELATIONSHIP TO BASIC FINANCIAL STATEMENTS Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting for federal programs accounted for in the governmental funds, and on the accrual basis of accounting for federal programs accounted for in the proprietary funds, which is described in Note 1 to the City's basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The recognition of expenditures of federal awards on the Schedule pertaining to Disaster Grants - Public Assistance (Presidentially Declared Disasters) include $69,622 of eligible expenditures which occurred in the prior year.

Finding Details

Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.
Criteria or specific requirement: The City’s management is responsible for the presentation of financial statements in accordance with generally accepted accounting principles. In addition, the City’s management is responsible for the preparation of the schedule of expenditures of federal awards. Condition: The City received a significant amount of grant funding during the year ending June 30, 2022 including federal funds that were received in advance. Material audit adjustments were required to increase grant receivables and grant revenue. In addition, previously recognized grant expenditures were removed from the current year activity. Cause: The grant activity was primarily recorded on the cash basis in the general ledger, which is not consistent with generally accepted accounting principles. Effect or potential effect: The controls over the financial activities of the City’s grants are weakened. The preliminary federal grant activity was materially misstated within the basic financial statements and in the Schedule of Expenditures of Federal Awards. The failure to reconcile the grant activity increases the risk that errors may occur and remain undetected. Questioned costs: None. Context: The City expended in excess of $750,000 in federal awards and assistance during the year ending June 30, 2022 requiring a compliance audit in accordance with the Uniform Guidance. The recognition of expenditures and the applicable federal revenue in the general ledger was not properly reconciled at the grant level and did not agree with the preliminary schedule of expenditures of federal awards provided for the compliance audit. Recommendation: We recommend that grant activity be reconciled on a per grant basis. Grant awards are for a specified amount; therefore, grant revenue should agree with the corresponding grant expenditures. We further recommend that all federal award expenditures be reported on the Schedule of Expenditures of Federal Awards in accordance with the Uniform Guidance. Views of Responsible Officials: The City’s management concurs with this audit finding.