Audit 7248

FY End
2023-03-31
Total Expended
$5.79M
Findings
22
Programs
5
Organization: Dodge County Housing Authority (WI)
Year: 2023 Accepted: 2023-12-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
5483 2023-001 Significant Deficiency Yes P
5484 2023-001 Significant Deficiency Yes P
5485 2023-001 Significant Deficiency Yes P
5486 2023-001 Significant Deficiency Yes P
5487 2023-001 Significant Deficiency Yes P
5488 2023-002 Significant Deficiency Yes P
5489 2023-002 Significant Deficiency Yes P
5490 2023-002 Significant Deficiency Yes P
5491 2023-002 Significant Deficiency Yes P
5492 2023-002 Significant Deficiency Yes P
5493 2023-003 Significant Deficiency Yes P
581925 2023-001 Significant Deficiency Yes P
581926 2023-001 Significant Deficiency Yes P
581927 2023-001 Significant Deficiency Yes P
581928 2023-001 Significant Deficiency Yes P
581929 2023-001 Significant Deficiency Yes P
581930 2023-002 Significant Deficiency Yes P
581931 2023-002 Significant Deficiency Yes P
581932 2023-002 Significant Deficiency Yes P
581933 2023-002 Significant Deficiency Yes P
581934 2023-002 Significant Deficiency Yes P
581935 2023-003 Significant Deficiency Yes P

Contacts

Name Title Type
XNWCB9H1SV44 Donna L Braun Auditee
9203862866 William J Sherry Auditor
No contacts on file

Notes to SEFA

Title: Basis of Accounting Accounting Policies: Accrual basis De Minimis Rate Used: N Rate Explanation: The Housing Authority has not elected to use the 10% indirect cost rate. The accompanying schedule of expenditures of federal awards includes the federal grant activity of the Housing Authority and is presented on the accrual basis of accounting. 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. Therefore, some amounts presented in the schedule may differ from amounts presented in the financial statements.
Title: Loan Balances Accounting Policies: Accrual basis De Minimis Rate Used: N Rate Explanation: The Housing Authority has not elected to use the 10% indirect cost rate. Rural Development loan balances are reported at their beginning of year balances plus any new loans. These loans have continuing compliance requirements and are considered federal expenditures for each year that there is an outstanding balance. End of year balances are $1,484,101 for Rural Housing loans and $3,068,911 for MPR loans.
Title: Interest Rate Subsidy Accounting Policies: Accrual basis De Minimis Rate Used: N Rate Explanation: The Housing Authority has not elected to use the 10% indirect cost rate. Rural development loans are subsidized to reduce the effective interest rate to 1%. The subsidy is a non cash transaction that has been recorded as other government grants revenue and interest expense.
Title: Subrecipients Accounting Policies: Accrual basis De Minimis Rate Used: N Rate Explanation: The Housing Authority has not elected to use the 10% indirect cost rate. The Housing Authority provided no federal awards to subrecipients.
Title: Indirect Cost Rate Accounting Policies: Accrual basis De Minimis Rate Used: N Rate Explanation: The Housing Authority has not elected to use the 10% indirect cost rate. The Housing Authority has not elected to use the 10% indirect cost rate.
Title: Noncash Awards Accounting Policies: Accrual basis De Minimis Rate Used: N Rate Explanation: The Housing Authority has not elected to use the 10% indirect cost rate. Rural Rental Interest Subsidy $110,329; Rural Rental Principal Subsidy $12,994

Finding Details

2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-003 - Preparation of Schedule of Federal Expenditures (design deficiency) applicable to CFDA #10.427. Criteria: Uniform Guidance requires that the Housing Authority "identify, in its accounts, all federal awards received and expended and the federal programs under which they were received. Federal program and award identification shall include, as applicable, the CFDA title and number, award number and year, name of the federal agency, and name of the pass-through entity. In addition, the Housing Authority is required to prepare appropriate financial statements, including the schedule of expenditures of federal awards expended. Condition: As is the case with many housing authorities, the Housing Authority administers several federal grants that include noncash interest subsidies. The Housing Authority was unable to provide us with a schedule of federal expenditures that included the noncash interest subsidies. Cause: The Housing Authority did not compute non cash interest subsidies and record them in their general ledger. Effect: If the audit firm computes the interest subsidies incorrectly, the wrong amount of assistance expended could be reported in error. Recommendation: We recommend that the Housing Authority assign an individual internally that is qualified to prepare this schedule. Management's Response: The Housing Authority agrees with this finding and will work to alleviate this issue.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-001 - Weakness regarding preparing financial statements (design deficiency) Criteria: Effective internal control over financial reporting involves the identification and analysis of the risks of material misstatement to the company’s audited financial statements and should determine how those identified risks should are managed. Condition: Management has not designed effective controls over the preparation of the financial statements and certain year end journal entries to prevent or detect material misstatements, including footnote disclosures. Management relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Context: The audit firm has been preparing certain year end journal entries and the financial statements and related footnote disclosures for several years. Each year the auditee reviews and approves the journal entries and a draft of the financial statements prior to issuance. Effect: The auditee relies on the auditor firm to make certain year end adjustments and to properly prepare the financial statements and related footnote disclosures. If the audit firm did not properly propose the journal entries and prepare the financial statements and related footnote disclosures, the Housing Authority may not identify the error in advance of issuance. Cause: Due to the limited number of personnel and their financial reporting expertise, management has elected to rely on the audit firm to make certain year end adjustments and prepare its financial statements and related footnote disclosures. Recommendation: It is not cost effective for the auditee to employ additional personnel solely for financial reporting purposes. Therefore, the auditee should use its current knowledge obtained from training seminars and trade associations to mitigate the situation. Views of responsible officials and planned corrective actions: Management acknowledges that they are not experts in financial reporting and cannot afford to hire additional personnel for this purpose. However, they have obtained a wealth of knowledge from training seminars and trade associations. They will continue to be alert to changes in financial reporting requirements to ensure that they are implemented by their auditor on a timely basis.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-002 - Segregation of Duties (design deficiency) Criteria: A good system of internal control provides for an adequate segregation of duties so that no one individual handles a transaction from its inception to completion. Condition: There is a lack of proper segregation of duties between the functions of record keeping, asset custody and authorization. Context: Due to the limited number of office personnel within the Housing Authority, segregation of the accounting functions necessary to ensure adequate internal accounting control is not possible. This is not unusual in operations the size of Housing Authority; however, the Housing Authority’s management should constantly be aware of this condition and realize that the concentration of duties and responsibilities in a limited number of individuals is not desirable from an accounting point of view. Effect: Inadequate segregation of duties could adversely affect the Housing Authority’s ability to detect misstatements in amounts that would be material in relation to the financial statements in a timely period by employees in the normal course of performing their assigned functions. Cause: The Housing Authority does not have the economic resources needed to hire additional qualified accounting staff in order to properly segregate duties. Recommendation: We recommend that the Housing Authority’s board and management be aware of the lack of segregation of duties of the accounting functions and, where possible, implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible. Views of responsible officials and planned corrective actions: The Housing Authority will continue to segregate duties whenever possible and implement oversight procedures to ensure that the internal control policies and procedures are being implemented by staff to the extent possible.
2023-003 - Preparation of Schedule of Federal Expenditures (design deficiency) applicable to CFDA #10.427. Criteria: Uniform Guidance requires that the Housing Authority "identify, in its accounts, all federal awards received and expended and the federal programs under which they were received. Federal program and award identification shall include, as applicable, the CFDA title and number, award number and year, name of the federal agency, and name of the pass-through entity. In addition, the Housing Authority is required to prepare appropriate financial statements, including the schedule of expenditures of federal awards expended. Condition: As is the case with many housing authorities, the Housing Authority administers several federal grants that include noncash interest subsidies. The Housing Authority was unable to provide us with a schedule of federal expenditures that included the noncash interest subsidies. Cause: The Housing Authority did not compute non cash interest subsidies and record them in their general ledger. Effect: If the audit firm computes the interest subsidies incorrectly, the wrong amount of assistance expended could be reported in error. Recommendation: We recommend that the Housing Authority assign an individual internally that is qualified to prepare this schedule. Management's Response: The Housing Authority agrees with this finding and will work to alleviate this issue.