Criteria: The City should have an accounting system in place that is designed to ensure the City?s financial statements are presented fairly, in all material respects, with generally accepted accounting principles. Condition: Material adjustments were required in order for the financial statements to be fairly stated in all material respects. Context: During our preliminary analytical procedure testing on expenses, we noted a fixed asset that was not properly capitalized on the government-wide financial statements. Since the fixed asset was not properly capitalized, depreciation expense was also not recorded on the asset. During our testing of project reimbursement revenue, we noted revenue recognized in the current year that should have been recognized in the previous fiscal year. Effect: The government-wide financial statements could have been materially misstated in the current year because of the fixed asset omission. The financial statements from the prior year were materially misstated because revenue was not adequately accounted for. Cause: The City records all fixed asset additions initially as an expense and then later reclassifies them to fixed assets at year end. The entity does not have a control in place to ensure that all fixed asset additions are properly reclassified from expense. The finance department includes grant award amounts on its work in process schedules so the department knows the amount of grant funding available for a particular project. The grant amount for the CSO Phase IX-A project was originally entered with the correct total grant amount. A line was later added to the spreadsheet showing a revised MDE grant amount. The revised MDE grant amount was incorrect because it only included the construction portion of the available funding, not the total MDE grant amount which did not change. When the finance director recorded the revenue accrual, they only recorded it up to the incorrect revised MDE grant amount because they thought the available funding was used up. The reimbursement request submitted to MDE was not performed until towards the end of fiscal year ending June 30, 2022 so the discrepancy was not noted until after the audit was completed. Recommendation: We recommend the City record all fixed asset additions on their depreciation schedules as soon as the expenditure in incurred so that when the reclassification is done at year end, the trial balance amount should agree to the depreciation schedules. We also recommend a final review of the expenses in the trial balance for anything unusual during the year end closing process. We recommend the finance department work closely with the individual handling the funding requests for the City and that both individuals cross check each other?s records for discrepancies. We also recommend the City submit grant reimbursement requests as soon as possible so the City has an additional method to verify its revenue accruals for accuracy.
Criteria: The City should have an accounting system in place that is designed to ensure the City?s financial statements are presented fairly, in all material respects, with generally accepted accounting principles. Condition: Material adjustments were required in order for the financial statements to be fairly stated in all material respects. Context: During our preliminary analytical procedure testing on expenses, we noted a fixed asset that was not properly capitalized on the government-wide financial statements. Since the fixed asset was not properly capitalized, depreciation expense was also not recorded on the asset. During our testing of project reimbursement revenue, we noted revenue recognized in the current year that should have been recognized in the previous fiscal year. Effect: The government-wide financial statements could have been materially misstated in the current year because of the fixed asset omission. The financial statements from the prior year were materially misstated because revenue was not adequately accounted for. Cause: The City records all fixed asset additions initially as an expense and then later reclassifies them to fixed assets at year end. The entity does not have a control in place to ensure that all fixed asset additions are properly reclassified from expense. The finance department includes grant award amounts on its work in process schedules so the department knows the amount of grant funding available for a particular project. The grant amount for the CSO Phase IX-A project was originally entered with the correct total grant amount. A line was later added to the spreadsheet showing a revised MDE grant amount. The revised MDE grant amount was incorrect because it only included the construction portion of the available funding, not the total MDE grant amount which did not change. When the finance director recorded the revenue accrual, they only recorded it up to the incorrect revised MDE grant amount because they thought the available funding was used up. The reimbursement request submitted to MDE was not performed until towards the end of fiscal year ending June 30, 2022 so the discrepancy was not noted until after the audit was completed. Recommendation: We recommend the City record all fixed asset additions on their depreciation schedules as soon as the expenditure in incurred so that when the reclassification is done at year end, the trial balance amount should agree to the depreciation schedules. We also recommend a final review of the expenses in the trial balance for anything unusual during the year end closing process. We recommend the finance department work closely with the individual handling the funding requests for the City and that both individuals cross check each other?s records for discrepancies. We also recommend the City submit grant reimbursement requests as soon as possible so the City has an additional method to verify its revenue accruals for accuracy.