Audit 300206

FY End
2023-06-30
Total Expended
$2.86M
Findings
20
Programs
8
Organization: Town of Middlebury, Vermont (VT)
Year: 2023 Accepted: 2024-03-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
388477 2023-001 Significant Deficiency Yes P
388478 2023-002 Significant Deficiency Yes B
388479 2023-003 Significant Deficiency Yes C
388480 2023-004 Significant Deficiency Yes A
388481 2023-005 Significant Deficiency Yes P
388482 2023-001 Significant Deficiency Yes P
388483 2023-002 Significant Deficiency Yes B
388484 2023-003 Significant Deficiency Yes C
388485 2023-004 Significant Deficiency Yes A
388486 2023-005 Significant Deficiency Yes P
964919 2023-001 Significant Deficiency Yes P
964920 2023-002 Significant Deficiency Yes B
964921 2023-003 Significant Deficiency Yes C
964922 2023-004 Significant Deficiency Yes A
964923 2023-005 Significant Deficiency Yes P
964924 2023-001 Significant Deficiency Yes P
964925 2023-002 Significant Deficiency Yes B
964926 2023-003 Significant Deficiency Yes C
964927 2023-004 Significant Deficiency Yes A
964928 2023-005 Significant Deficiency Yes P

Programs

ALN Program Spent Major Findings
97.039 Hazard Mitigation Grant $1.36M Yes 5
66.458 Capitalization Grants for Clean Water State Revolving Funds $814,557 Yes 5
96.001 Social Security_disability Insurance $600,000 - 0
97.067 Homeland Security Grant Program $33,000 - 0
20.205 Highway Planning and Construction $15,771 - 0
10.664 Cooperative Forestry Assistance $4,560 - 0
97.047 Pre-Disaster Mitigation $668 - 0
45.310 Grants to States $571 - 0

Contacts

Name Title Type
F3VRVGP3FNB9 Nicholas Gill Auditee
8024588003 Andrew Bachand Auditor
No contacts on file

Notes to SEFA

Title: basis of Accounting Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. 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 Town of Middlebury, Vermont has not elected to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance because no indirect costs were allowed under the federal awards. The accompanying schedule of expenditures of federal awards includes the federal award activity of the Town of Middlebury, Vermont 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 Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Town of Middlebury, Vermont, it is not intended to and does not present the financial position, change in net assets of the Town of Middlebury, Vermont.

Finding Details

2023 – 1 General Journal Entries - The Town posts general journal entries to numerous accounts each month in the general ledger to re-class and adjust monthly postings which are prepared and recorded by the same individual. In many cases, a month end adjustment is recorded correcting numerous different items. General ledger adjustments present additional risks of misstatement. Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Criteria: Journal entries should have the proper documentation and supporting backup Cause: Unknown Effect: Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Recommendation: The Town of Middlebury, Vermont should implement a system for recording journal entries and the necessary backup for those journal entries. Management Response: The Town of Middlebury, Vermont is working on developing a system of documenting journal entries, with proper back up and support.
2023 – 2 Year End Audit Entries and Financial Reporting - The audit resulted in over 30 adjusting journal entries proposed to management. Some of these entries were material to the financial statements as a whole and required in order to issue an unmodified opinion. The Town does not have the experience and training needed to – - Prepare all of its year end reconciliations and journal entries and prepare financial statements, complete with notes, in accordance with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established internal controls over the preparation of year-end reconciliations and journal entries and the preparation of the financial statements. - Select and apply accounting principles that are in conformity with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established, internal controls over the selection and application of accounting principles. Criteria - Under SAS 115, an internal control deficiency exists when management does not possess the financial expertise to prepare end reconciliations and prepare financial statements in accordance with generally accepted accounting principles. Cause: Unknown Effect: Because management lacks expertise in financial accounting and reporting, there is more than a remote likelihood that a misstatement of the entity’s financial statements that is more than inconsequential will not be prevented or detected under the provisions of SAS 115. Recommendation: To correct these deficiencies, management would need to hire personnel with adequate accounting experience to perform these functions. The Town would need to weigh the costs of these corrections verse the benefit. Management Response: The Town hired a new director of finance with a strong educational background.
2023 – 3 Loan Reimbursement Requests - During the course of our audit it was noted that loan reimbursement request is not being conducted timely. Criteria: Loan reimbursements should be requested in a timely manner or else the taxpayers are being responsible to cover the bills. This also makes calculating expenditures related to possible single audits to be reconciled. Cause: Unknown Effect: Taxpayers are being responsible to cover the bills of projects that they previous approved to be paid by debt. Recommendation: Request reimbursement of loans throughout the project. Management Response: Management is making more of an effort to request reimbursement throughout a project rather than completion.
2023 – 4 Depreciation Schedules - During the course of our audit it was noted that the depreciation schedules were not completed, this led to a delay in the completion of the audit. Criteria: Management should review all assets to ensure that depreciation expenses is calculating properly and that live assets are applied consistently based on capitalization policy. The depreciation schedule for should be updated quarterly at the very least to ensure that they are ready for the audit. Cause: Unknown Effect: Funds are not adequately representing a true reflection of the depreciating assets throughout the year Recommendation: A standard monthly entry would provide the financial statements with an adequate representation of the depreciation expense per month. Management Response: Management is going to keep up to date with its depreciation schedule and monthly entry.
2023 – 5 Reconciliations - During the course of our audit it was noted that cash, investments and accounts payable and account receivable are not being reconciled monthly. Criteria: Management should reconcile all accounts receivable, investments and accounts payable accounts monthly to prevent errors from compounding. Cause: Unknown Effect: Unrecorded activity was noted throughout the year. Recommendation: All cash, investments and accounts payable and receivable should be reconciled monthly Management Response: Management will reconcile all cash, investments and accounts payable accounts monthly.
2023 – 1 General Journal Entries - The Town posts general journal entries to numerous accounts each month in the general ledger to re-class and adjust monthly postings which are prepared and recorded by the same individual. In many cases, a month end adjustment is recorded correcting numerous different items. General ledger adjustments present additional risks of misstatement. Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Criteria: Journal entries should have the proper documentation and supporting backup Cause: Unknown Effect: Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Recommendation: The Town of Middlebury, Vermont should implement a system for recording journal entries and the necessary backup for those journal entries. Management Response: The Town of Middlebury, Vermont is working on developing a system of documenting journal entries, with proper back up and support.
2023 – 2 Year End Audit Entries and Financial Reporting - The audit resulted in over 30 adjusting journal entries proposed to management. Some of these entries were material to the financial statements as a whole and required in order to issue an unmodified opinion. The Town does not have the experience and training needed to – - Prepare all of its year end reconciliations and journal entries and prepare financial statements, complete with notes, in accordance with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established internal controls over the preparation of year-end reconciliations and journal entries and the preparation of the financial statements. - Select and apply accounting principles that are in conformity with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established, internal controls over the selection and application of accounting principles. Criteria - Under SAS 115, an internal control deficiency exists when management does not possess the financial expertise to prepare end reconciliations and prepare financial statements in accordance with generally accepted accounting principles. Cause: Unknown Effect: Because management lacks expertise in financial accounting and reporting, there is more than a remote likelihood that a misstatement of the entity’s financial statements that is more than inconsequential will not be prevented or detected under the provisions of SAS 115. Recommendation: To correct these deficiencies, management would need to hire personnel with adequate accounting experience to perform these functions. The Town would need to weigh the costs of these corrections verse the benefit. Management Response: The Town hired a new director of finance with a strong educational background.
2023 – 3 Loan Reimbursement Requests - During the course of our audit it was noted that loan reimbursement request is not being conducted timely. Criteria: Loan reimbursements should be requested in a timely manner or else the taxpayers are being responsible to cover the bills. This also makes calculating expenditures related to possible single audits to be reconciled. Cause: Unknown Effect: Taxpayers are being responsible to cover the bills of projects that they previous approved to be paid by debt. Recommendation: Request reimbursement of loans throughout the project. Management Response: Management is making more of an effort to request reimbursement throughout a project rather than completion.
2023 – 4 Depreciation Schedules - During the course of our audit it was noted that the depreciation schedules were not completed, this led to a delay in the completion of the audit. Criteria: Management should review all assets to ensure that depreciation expenses is calculating properly and that live assets are applied consistently based on capitalization policy. The depreciation schedule for should be updated quarterly at the very least to ensure that they are ready for the audit. Cause: Unknown Effect: Funds are not adequately representing a true reflection of the depreciating assets throughout the year Recommendation: A standard monthly entry would provide the financial statements with an adequate representation of the depreciation expense per month. Management Response: Management is going to keep up to date with its depreciation schedule and monthly entry.
2023 – 5 Reconciliations - During the course of our audit it was noted that cash, investments and accounts payable and account receivable are not being reconciled monthly. Criteria: Management should reconcile all accounts receivable, investments and accounts payable accounts monthly to prevent errors from compounding. Cause: Unknown Effect: Unrecorded activity was noted throughout the year. Recommendation: All cash, investments and accounts payable and receivable should be reconciled monthly Management Response: Management will reconcile all cash, investments and accounts payable accounts monthly.
2023 – 1 General Journal Entries - The Town posts general journal entries to numerous accounts each month in the general ledger to re-class and adjust monthly postings which are prepared and recorded by the same individual. In many cases, a month end adjustment is recorded correcting numerous different items. General ledger adjustments present additional risks of misstatement. Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Criteria: Journal entries should have the proper documentation and supporting backup Cause: Unknown Effect: Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Recommendation: The Town of Middlebury, Vermont should implement a system for recording journal entries and the necessary backup for those journal entries. Management Response: The Town of Middlebury, Vermont is working on developing a system of documenting journal entries, with proper back up and support.
2023 – 2 Year End Audit Entries and Financial Reporting - The audit resulted in over 30 adjusting journal entries proposed to management. Some of these entries were material to the financial statements as a whole and required in order to issue an unmodified opinion. The Town does not have the experience and training needed to – - Prepare all of its year end reconciliations and journal entries and prepare financial statements, complete with notes, in accordance with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established internal controls over the preparation of year-end reconciliations and journal entries and the preparation of the financial statements. - Select and apply accounting principles that are in conformity with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established, internal controls over the selection and application of accounting principles. Criteria - Under SAS 115, an internal control deficiency exists when management does not possess the financial expertise to prepare end reconciliations and prepare financial statements in accordance with generally accepted accounting principles. Cause: Unknown Effect: Because management lacks expertise in financial accounting and reporting, there is more than a remote likelihood that a misstatement of the entity’s financial statements that is more than inconsequential will not be prevented or detected under the provisions of SAS 115. Recommendation: To correct these deficiencies, management would need to hire personnel with adequate accounting experience to perform these functions. The Town would need to weigh the costs of these corrections verse the benefit. Management Response: The Town hired a new director of finance with a strong educational background.
2023 – 3 Loan Reimbursement Requests - During the course of our audit it was noted that loan reimbursement request is not being conducted timely. Criteria: Loan reimbursements should be requested in a timely manner or else the taxpayers are being responsible to cover the bills. This also makes calculating expenditures related to possible single audits to be reconciled. Cause: Unknown Effect: Taxpayers are being responsible to cover the bills of projects that they previous approved to be paid by debt. Recommendation: Request reimbursement of loans throughout the project. Management Response: Management is making more of an effort to request reimbursement throughout a project rather than completion.
2023 – 4 Depreciation Schedules - During the course of our audit it was noted that the depreciation schedules were not completed, this led to a delay in the completion of the audit. Criteria: Management should review all assets to ensure that depreciation expenses is calculating properly and that live assets are applied consistently based on capitalization policy. The depreciation schedule for should be updated quarterly at the very least to ensure that they are ready for the audit. Cause: Unknown Effect: Funds are not adequately representing a true reflection of the depreciating assets throughout the year Recommendation: A standard monthly entry would provide the financial statements with an adequate representation of the depreciation expense per month. Management Response: Management is going to keep up to date with its depreciation schedule and monthly entry.
2023 – 5 Reconciliations - During the course of our audit it was noted that cash, investments and accounts payable and account receivable are not being reconciled monthly. Criteria: Management should reconcile all accounts receivable, investments and accounts payable accounts monthly to prevent errors from compounding. Cause: Unknown Effect: Unrecorded activity was noted throughout the year. Recommendation: All cash, investments and accounts payable and receivable should be reconciled monthly Management Response: Management will reconcile all cash, investments and accounts payable accounts monthly.
2023 – 1 General Journal Entries - The Town posts general journal entries to numerous accounts each month in the general ledger to re-class and adjust monthly postings which are prepared and recorded by the same individual. In many cases, a month end adjustment is recorded correcting numerous different items. General ledger adjustments present additional risks of misstatement. Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Criteria: Journal entries should have the proper documentation and supporting backup Cause: Unknown Effect: Without proper backup for adjustments made to the trial balance, it would be easy for material amounts of improper recognition to occur. Recommendation: The Town of Middlebury, Vermont should implement a system for recording journal entries and the necessary backup for those journal entries. Management Response: The Town of Middlebury, Vermont is working on developing a system of documenting journal entries, with proper back up and support.
2023 – 2 Year End Audit Entries and Financial Reporting - The audit resulted in over 30 adjusting journal entries proposed to management. Some of these entries were material to the financial statements as a whole and required in order to issue an unmodified opinion. The Town does not have the experience and training needed to – - Prepare all of its year end reconciliations and journal entries and prepare financial statements, complete with notes, in accordance with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established internal controls over the preparation of year-end reconciliations and journal entries and the preparation of the financial statements. - Select and apply accounting principles that are in conformity with accounting principles generally accepted in the United States of America. Accordingly, the Town is unable to, and has not established, internal controls over the selection and application of accounting principles. Criteria - Under SAS 115, an internal control deficiency exists when management does not possess the financial expertise to prepare end reconciliations and prepare financial statements in accordance with generally accepted accounting principles. Cause: Unknown Effect: Because management lacks expertise in financial accounting and reporting, there is more than a remote likelihood that a misstatement of the entity’s financial statements that is more than inconsequential will not be prevented or detected under the provisions of SAS 115. Recommendation: To correct these deficiencies, management would need to hire personnel with adequate accounting experience to perform these functions. The Town would need to weigh the costs of these corrections verse the benefit. Management Response: The Town hired a new director of finance with a strong educational background.
2023 – 3 Loan Reimbursement Requests - During the course of our audit it was noted that loan reimbursement request is not being conducted timely. Criteria: Loan reimbursements should be requested in a timely manner or else the taxpayers are being responsible to cover the bills. This also makes calculating expenditures related to possible single audits to be reconciled. Cause: Unknown Effect: Taxpayers are being responsible to cover the bills of projects that they previous approved to be paid by debt. Recommendation: Request reimbursement of loans throughout the project. Management Response: Management is making more of an effort to request reimbursement throughout a project rather than completion.
2023 – 4 Depreciation Schedules - During the course of our audit it was noted that the depreciation schedules were not completed, this led to a delay in the completion of the audit. Criteria: Management should review all assets to ensure that depreciation expenses is calculating properly and that live assets are applied consistently based on capitalization policy. The depreciation schedule for should be updated quarterly at the very least to ensure that they are ready for the audit. Cause: Unknown Effect: Funds are not adequately representing a true reflection of the depreciating assets throughout the year Recommendation: A standard monthly entry would provide the financial statements with an adequate representation of the depreciation expense per month. Management Response: Management is going to keep up to date with its depreciation schedule and monthly entry.
2023 – 5 Reconciliations - During the course of our audit it was noted that cash, investments and accounts payable and account receivable are not being reconciled monthly. Criteria: Management should reconcile all accounts receivable, investments and accounts payable accounts monthly to prevent errors from compounding. Cause: Unknown Effect: Unrecorded activity was noted throughout the year. Recommendation: All cash, investments and accounts payable and receivable should be reconciled monthly Management Response: Management will reconcile all cash, investments and accounts payable accounts monthly.