Audit 320453

FY End
2023-12-31
Total Expended
$2.41M
Findings
4
Programs
4
Year: 2023 Accepted: 2024-09-23
Auditor: Ritz Holman LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
497893 2023-001 Significant Deficiency - A
497894 2023-001 Significant Deficiency - A
1074335 2023-001 Significant Deficiency - A
1074336 2023-001 Significant Deficiency - A

Contacts

Name Title Type
EALBEGKJUKL5 Terese Caro Auditee
4143430163 Renee Messing Auditor
No contacts on file

Notes to SEFA

Title: Outstanding Loans Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal grant activity of Legacy Redevelopment Corporation and Affiliates and is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic consolidated financial statements. De Minimis Rate Used: N Rate Explanation: The Organization has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. Loans outstanding at December 31, 2023, were $690,000 under the Home Investment Partnerships Program, $649,331 under the Community Development Financial Institutions program, $385,610 under the Milwaukee Community Development Block Grant Program, $235,000 under the Racine Community Development Block Grant Program, and $40,000 under, the Community Development Block Grant Program (CARES).

Finding Details

1) Federal program and specific federal award Identification: Financial Statements and ALN #21.024 2) Criteria: The Organization utilizes a subsidiary system to maintain and monitor loan account balances. The subsidiary system should be reconciled on a regular basis to the general ledger control accounts. 3) Condition: The loan receivable balances in the general ledger were not fully reconciled to the subsidiary system during the year. 4) Cause: The Organization experienced a change in outside accounting services during the year and had a gap in services for part of the year. As a result, certain accounting processes and reconciliations were behind schedule. 5) Effect: Without timely reconciliation procedures, loans receivable could be incorrectly reported in the financial statements. 6) Questioned costs: No questioned costs were identified. 7) Prevalence or consequence: Partial reconciliation of loan balances was performed, however the full reconciliation was completed during the audit process. 8) Repeated audit finding: This is not a repeat finding. 9) We recommend that reconciliations of loans receivable be completed on a monthly basis by the outside accounting service provider. The reconciliations should be reviewed and approved by management. 10) Views of responsible officials at auditee: We agree with the finding and recommendation regarding reconciliation of the loan receivable accounts. Procedures have been put into place beginning September 1, 2024 for reconciliations to be submitted to management for review and approval. In addition, a meeting will be held with the outside accounting services team to review all lending activity for proper reporting.
1) Federal program and specific federal award Identification: Financial Statements and ALN #21.024 2) Criteria: The Organization utilizes a subsidiary system to maintain and monitor loan account balances. The subsidiary system should be reconciled on a regular basis to the general ledger control accounts. 3) Condition: The loan receivable balances in the general ledger were not fully reconciled to the subsidiary system during the year. 4) Cause: The Organization experienced a change in outside accounting services during the year and had a gap in services for part of the year. As a result, certain accounting processes and reconciliations were behind schedule. 5) Effect: Without timely reconciliation procedures, loans receivable could be incorrectly reported in the financial statements. 6) Questioned costs: No questioned costs were identified. 7) Prevalence or consequence: Partial reconciliation of loan balances was performed, however the full reconciliation was completed during the audit process. 8) Repeated audit finding: This is not a repeat finding. 9) We recommend that reconciliations of loans receivable be completed on a monthly basis by the outside accounting service provider. The reconciliations should be reviewed and approved by management. 10) Views of responsible officials at auditee: We agree with the finding and recommendation regarding reconciliation of the loan receivable accounts. Procedures have been put into place beginning September 1, 2024 for reconciliations to be submitted to management for review and approval. In addition, a meeting will be held with the outside accounting services team to review all lending activity for proper reporting.
1) Federal program and specific federal award Identification: Financial Statements and ALN #21.024 2) Criteria: The Organization utilizes a subsidiary system to maintain and monitor loan account balances. The subsidiary system should be reconciled on a regular basis to the general ledger control accounts. 3) Condition: The loan receivable balances in the general ledger were not fully reconciled to the subsidiary system during the year. 4) Cause: The Organization experienced a change in outside accounting services during the year and had a gap in services for part of the year. As a result, certain accounting processes and reconciliations were behind schedule. 5) Effect: Without timely reconciliation procedures, loans receivable could be incorrectly reported in the financial statements. 6) Questioned costs: No questioned costs were identified. 7) Prevalence or consequence: Partial reconciliation of loan balances was performed, however the full reconciliation was completed during the audit process. 8) Repeated audit finding: This is not a repeat finding. 9) We recommend that reconciliations of loans receivable be completed on a monthly basis by the outside accounting service provider. The reconciliations should be reviewed and approved by management. 10) Views of responsible officials at auditee: We agree with the finding and recommendation regarding reconciliation of the loan receivable accounts. Procedures have been put into place beginning September 1, 2024 for reconciliations to be submitted to management for review and approval. In addition, a meeting will be held with the outside accounting services team to review all lending activity for proper reporting.
1) Federal program and specific federal award Identification: Financial Statements and ALN #21.024 2) Criteria: The Organization utilizes a subsidiary system to maintain and monitor loan account balances. The subsidiary system should be reconciled on a regular basis to the general ledger control accounts. 3) Condition: The loan receivable balances in the general ledger were not fully reconciled to the subsidiary system during the year. 4) Cause: The Organization experienced a change in outside accounting services during the year and had a gap in services for part of the year. As a result, certain accounting processes and reconciliations were behind schedule. 5) Effect: Without timely reconciliation procedures, loans receivable could be incorrectly reported in the financial statements. 6) Questioned costs: No questioned costs were identified. 7) Prevalence or consequence: Partial reconciliation of loan balances was performed, however the full reconciliation was completed during the audit process. 8) Repeated audit finding: This is not a repeat finding. 9) We recommend that reconciliations of loans receivable be completed on a monthly basis by the outside accounting service provider. The reconciliations should be reviewed and approved by management. 10) Views of responsible officials at auditee: We agree with the finding and recommendation regarding reconciliation of the loan receivable accounts. Procedures have been put into place beginning September 1, 2024 for reconciliations to be submitted to management for review and approval. In addition, a meeting will be held with the outside accounting services team to review all lending activity for proper reporting.