Audit 317918

FY End
2023-06-30
Total Expended
$9.11M
Findings
2
Programs
17
Organization: Town of Billerica (MA)
Year: 2023 Accepted: 2024-08-27

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
QMCGRAJ9CY26 Paul Watson Auditee
9786710923 Todd Jurczyk Auditor
No contacts on file

Notes to SEFA

Accounting Policies: a) Basis of Accounting - The accompanying Schedule of Expenditures of Federal Awards is presented on the modified accrual basis of accounting. Accordingly, expenditures are recognized when the liability is incurred. 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. b) Cash Assistance – National School Lunch Program and School Breakfast Program - Program expenditures represent federal reimbursement for meals provided during the year. c) Non-Cash Assistance (Commodities) – National School Lunch Program – Program expenditures represent the value of donated foods received during the year. De Minimis Rate Used: N Rate Explanation: The Town has not elected to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.

Finding Details

2023-002: Reporting to Federal Government Compliance Requirement: Reporting Type of Finding: Compliance and Internal Control over Compliance – Other Matter Criteria or Specific Requirement: Grantees must comply with reporting requirements established by the U.S. Treasury. The Town is required to submit “Project and Expenditure” reports to the U.S. Treasury quarterly, which include, among other data, total expenditures incurred through the reporting period. Condition: The quarterly report submitted by the Town for the period April to June 2023 did not reconcile with actual expenditures charged to the general ledger. Questioned Costs: None reported. Context: The Town filed the quarterly report timely, but did not report all expenditures that had been incurred through the end of the reporting period. Effect: The expenditures reported were understated by approximately $572,000. Cause: The Town generated an expenditure report from the general ledger system to assist in preparing the reporting submission; however, the report was not generated with the proper parameters to include all expenditures. Recommendation: The Town should implement procedures to ensure that all expenditures incurred in a given reporting period are included on the applicable project and expenditure report. The Town should also ensure that the omitted expenditures are included in the next reporting submission. Views of Responsible Officials and Planned Corrective Actions: Management was aware of the reporting inaccuracy, which was the result of a clerical error in generating reports. The error will be corrected on the subsequent report submitted in fiscal 2024.
2023-002: Reporting to Federal Government Compliance Requirement: Reporting Type of Finding: Compliance and Internal Control over Compliance – Other Matter Criteria or Specific Requirement: Grantees must comply with reporting requirements established by the U.S. Treasury. The Town is required to submit “Project and Expenditure” reports to the U.S. Treasury quarterly, which include, among other data, total expenditures incurred through the reporting period. Condition: The quarterly report submitted by the Town for the period April to June 2023 did not reconcile with actual expenditures charged to the general ledger. Questioned Costs: None reported. Context: The Town filed the quarterly report timely, but did not report all expenditures that had been incurred through the end of the reporting period. Effect: The expenditures reported were understated by approximately $572,000. Cause: The Town generated an expenditure report from the general ledger system to assist in preparing the reporting submission; however, the report was not generated with the proper parameters to include all expenditures. Recommendation: The Town should implement procedures to ensure that all expenditures incurred in a given reporting period are included on the applicable project and expenditure report. The Town should also ensure that the omitted expenditures are included in the next reporting submission. Views of Responsible Officials and Planned Corrective Actions: Management was aware of the reporting inaccuracy, which was the result of a clerical error in generating reports. The error will be corrected on the subsequent report submitted in fiscal 2024.