Finding 1180824 (2024-003)

Material Weakness Repeat Finding
Requirement
HIL
Questioned Costs
-
Year
2024
Accepted
2026-03-18
Audit: 392484
Organization: Porchlight, Inc. (WI)
Auditor: WIPFLI LLP

AI Summary

  • Core Issue: Porchlight, Inc. failed to provide necessary transaction reports and documentation for the grant period, leading to compliance concerns.
  • Impacted Requirements: Non-compliance with Uniform Guidance 200.302(b)(4) regarding fund accountability and procurement procedures, along with late performance report submissions.
  • Recommended Follow-Up: Porchlight, Inc. should establish better tracking systems for performance data, adhere to procurement policies, and ensure timely submission of grant reports.

Finding Text

Condition – Wipfli, LLP was unable to verify the period of performance for the program due to Porchlight, Inc.'s inability to provide detailed transaction reports for the program for the period January 1, 2024 through December 31, 2024. In addition, Porchlight was not able to provide documentation to show proper procurement procedures were followed on purchases. Lastly, Porchlight, Inc. did not file its performance report for the grant award in a timely manner. Criteria – Uniform Guidance 200.302(b)(4) states each non-federal entity must provide for “effective control over, and accountability for, all funds, property, and other assets.” In addition, the federal grant contract provided a requirement for specific procurement requirements for the purchase of goods and materials. Lastly, the federal grant contract provided a performance report be submitted within the provided guidelines. Cause – There was turnover in Porchlight, Inc.’s finance department which contributed to the lack of transaction tracking. Porchlight, Inc. is working on streamlining and implementing processes to address the deficiencies noted in the condition paragraph. Effect – A material weakness in internal control over compliance and an instance of noncompliance exists due to failure to provide accurate data for testing of period of performance, documentation that procurement procedures were followed, and the performance report in order to meet contract submission deadlines. Recommendation – We recommend Porchlight, Inc. implement procedures to ensure accurate tracking of data for testing of period of performance, follow policies and procedures related to procurement purchases, and prepare the grant award and performance reports accurately for timely submission. View of Responsible Officials – Management agrees with the assessment and has committed to a corrective action plan.

Corrective Action Plan

Management agrees with the finding and has implemented corrective actions to improve documentation, grant tracking, and compliance processes. Grant transactions are now recorded and tracked within Sage Intacct using appropriate invoice dates and general ledger posting dates to ensure that expenses are recorded within the correct period of performance for each grant. Sage Intacct provides detailed grant reporting capabilities, allowing the organization to generate transaction‐level reports for individual grants. Documentation procedures have also been strengthened. Supporting documentation for expense transactions is attached directly to transactions within Sage Intacct and is also stored in organized files on Porchlight’s internal server to ensure documentation is readily available for review and audit purposes. Procurement approvals and related documentation are retained within Sage Intacct on a transactional level, archived email records, and internal file storage, ensuring that approvals are documented and accessible. The Financial Director is currently responsible for preparing and submitting grant performance reports. Porchlight is also in the process of recruiting a staff Grants Manager to further strengthen grant management, monitoring, and reporting responsibilities. Porchlight maintains a grant reporting calendar and tracking system, which is maintained electronically on the organization's internal server to ensure that all reporting deadlines are monitored and met. Grant documentation is now maintained in centralized and organized compliance files on the internal server, allowing staff and auditors to easily access grant documentation and supporting records. Management will continue to monitor grant compliance processes and documentation procedures to ensure ongoing compliance with funding requirements and reporting obligations. Person(s) Responsible: Halle Pollay Timing for Implementation: In process

Categories

Procurement, Suspension & Debarment Material Weakness Period of Performance

Other Findings in this Audit

  • 1180822 2024-001
    Material Weakness Repeat
  • 1180823 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1.83M
14.267 CONTINUUM OF CARE PROGRAM $672,043
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $6,183