Audit 82167

FY End
2022-06-30
Total Expended
$832,429
Findings
4
Programs
3
Year: 2022 Accepted: 2023-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
88927 2022-002 Significant Deficiency - AB
88928 2022-002 Significant Deficiency - AB
665369 2022-002 Significant Deficiency - AB
665370 2022-002 Significant Deficiency - AB

Programs

ALN Program Spent Major Findings
14.267 Continuum of Care Program $333,843 - 0
14.231 Emergency Solutions Grants Program $103,455 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $95,131 Yes 1

Contacts

Name Title Type
EXYBUNKU4WW7 Meg Zaletel Auditee
9073129530 Grant R. Todd Auditor
No contacts on file

Notes to SEFA

Title: Note 3. Passed Through Awards Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Anchorage Coalition to End Homelessness 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 Anchorage Coalition to End Homelessness, it is not intended to and does not present the financial statements of Anchorage Coalition to End Homelessness. 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Anchorage Coalition to End Homelessness has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. No amounts were passed through to subrecipients.

Finding Details

Finding 2022-002 Lack of Internal Control over Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of the Treasury (passed through Alaska Community Foundation and Municipality of Anchorage). Federal Program: ARPA Nonprofit Recovery Fund (Alaska Community Foundation), 2021 ARPA Houselessness Stabilization & Coordinated In/Outflow (Municipality of Anchorage), respectively. ALN: 21.027 Award Numbers: None (Alaska Community Foundation) and #21356 (Municipality of Anchorage), respectively. Award Year: 2021 Type of Finding: Significant deficiency in internal control over compliance and noncompliance. Criteria: Adequate internal control over payroll transactions should be in place to ensure that personnel files are complete with all necessary documentation, which includes documented proof of approved pay rates and documentation of where the payroll expense should be coded. Condition and Context: During our testing of payroll transactions, we noted a substantial number of transactions which we were unable to verify pay rates or a personnel action form indicating approved coding, as required by the Organization?s policies and procedures. The finance department lacked the necessary supervisory capacity to determine and approve personnel information essential to determine the accuracy of payroll expenses. For each of the major programs listed above we attempted to test four payroll transactions and management was unable to provide supporting documentation of pay rates or personnel action forms for nearly all transactions tested. Cause: Lack of an adopted policy for documentation of employee pay rates. Effect: The lack of supporting documentation allows for the potential for misstatement of expenditures due to employees being paid incorrectly or charged to funding sources for which their payroll is an unallowable cost. Questioned Costs: Actual and likely questioned costs estimated to be below the reporting threshold of $25,000. Based on the auditors? review of pay rates, all employees were being paid a reasonable amount based on their position and the auditors? experience with similar entities. Repeat Finding: This is not a repeat finding; however, we have determined it to be a systemic issue. Recommendation: We recommend that management implement employment contracts or personnel action forms that document the approved pay rates for employees that are included in personnel files. Managements Response: Management agrees with this finding. See Corrective Action Plan.
Finding 2022-002 Lack of Internal Control over Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of the Treasury (passed through Alaska Community Foundation and Municipality of Anchorage). Federal Program: ARPA Nonprofit Recovery Fund (Alaska Community Foundation), 2021 ARPA Houselessness Stabilization & Coordinated In/Outflow (Municipality of Anchorage), respectively. ALN: 21.027 Award Numbers: None (Alaska Community Foundation) and #21356 (Municipality of Anchorage), respectively. Award Year: 2021 Type of Finding: Significant deficiency in internal control over compliance and noncompliance. Criteria: Adequate internal control over payroll transactions should be in place to ensure that personnel files are complete with all necessary documentation, which includes documented proof of approved pay rates and documentation of where the payroll expense should be coded. Condition and Context: During our testing of payroll transactions, we noted a substantial number of transactions which we were unable to verify pay rates or a personnel action form indicating approved coding, as required by the Organization?s policies and procedures. The finance department lacked the necessary supervisory capacity to determine and approve personnel information essential to determine the accuracy of payroll expenses. For each of the major programs listed above we attempted to test four payroll transactions and management was unable to provide supporting documentation of pay rates or personnel action forms for nearly all transactions tested. Cause: Lack of an adopted policy for documentation of employee pay rates. Effect: The lack of supporting documentation allows for the potential for misstatement of expenditures due to employees being paid incorrectly or charged to funding sources for which their payroll is an unallowable cost. Questioned Costs: Actual and likely questioned costs estimated to be below the reporting threshold of $25,000. Based on the auditors? review of pay rates, all employees were being paid a reasonable amount based on their position and the auditors? experience with similar entities. Repeat Finding: This is not a repeat finding; however, we have determined it to be a systemic issue. Recommendation: We recommend that management implement employment contracts or personnel action forms that document the approved pay rates for employees that are included in personnel files. Managements Response: Management agrees with this finding. See Corrective Action Plan.
Finding 2022-002 Lack of Internal Control over Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of the Treasury (passed through Alaska Community Foundation and Municipality of Anchorage). Federal Program: ARPA Nonprofit Recovery Fund (Alaska Community Foundation), 2021 ARPA Houselessness Stabilization & Coordinated In/Outflow (Municipality of Anchorage), respectively. ALN: 21.027 Award Numbers: None (Alaska Community Foundation) and #21356 (Municipality of Anchorage), respectively. Award Year: 2021 Type of Finding: Significant deficiency in internal control over compliance and noncompliance. Criteria: Adequate internal control over payroll transactions should be in place to ensure that personnel files are complete with all necessary documentation, which includes documented proof of approved pay rates and documentation of where the payroll expense should be coded. Condition and Context: During our testing of payroll transactions, we noted a substantial number of transactions which we were unable to verify pay rates or a personnel action form indicating approved coding, as required by the Organization?s policies and procedures. The finance department lacked the necessary supervisory capacity to determine and approve personnel information essential to determine the accuracy of payroll expenses. For each of the major programs listed above we attempted to test four payroll transactions and management was unable to provide supporting documentation of pay rates or personnel action forms for nearly all transactions tested. Cause: Lack of an adopted policy for documentation of employee pay rates. Effect: The lack of supporting documentation allows for the potential for misstatement of expenditures due to employees being paid incorrectly or charged to funding sources for which their payroll is an unallowable cost. Questioned Costs: Actual and likely questioned costs estimated to be below the reporting threshold of $25,000. Based on the auditors? review of pay rates, all employees were being paid a reasonable amount based on their position and the auditors? experience with similar entities. Repeat Finding: This is not a repeat finding; however, we have determined it to be a systemic issue. Recommendation: We recommend that management implement employment contracts or personnel action forms that document the approved pay rates for employees that are included in personnel files. Managements Response: Management agrees with this finding. See Corrective Action Plan.
Finding 2022-002 Lack of Internal Control over Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of the Treasury (passed through Alaska Community Foundation and Municipality of Anchorage). Federal Program: ARPA Nonprofit Recovery Fund (Alaska Community Foundation), 2021 ARPA Houselessness Stabilization & Coordinated In/Outflow (Municipality of Anchorage), respectively. ALN: 21.027 Award Numbers: None (Alaska Community Foundation) and #21356 (Municipality of Anchorage), respectively. Award Year: 2021 Type of Finding: Significant deficiency in internal control over compliance and noncompliance. Criteria: Adequate internal control over payroll transactions should be in place to ensure that personnel files are complete with all necessary documentation, which includes documented proof of approved pay rates and documentation of where the payroll expense should be coded. Condition and Context: During our testing of payroll transactions, we noted a substantial number of transactions which we were unable to verify pay rates or a personnel action form indicating approved coding, as required by the Organization?s policies and procedures. The finance department lacked the necessary supervisory capacity to determine and approve personnel information essential to determine the accuracy of payroll expenses. For each of the major programs listed above we attempted to test four payroll transactions and management was unable to provide supporting documentation of pay rates or personnel action forms for nearly all transactions tested. Cause: Lack of an adopted policy for documentation of employee pay rates. Effect: The lack of supporting documentation allows for the potential for misstatement of expenditures due to employees being paid incorrectly or charged to funding sources for which their payroll is an unallowable cost. Questioned Costs: Actual and likely questioned costs estimated to be below the reporting threshold of $25,000. Based on the auditors? review of pay rates, all employees were being paid a reasonable amount based on their position and the auditors? experience with similar entities. Repeat Finding: This is not a repeat finding; however, we have determined it to be a systemic issue. Recommendation: We recommend that management implement employment contracts or personnel action forms that document the approved pay rates for employees that are included in personnel files. Managements Response: Management agrees with this finding. See Corrective Action Plan.