Audit 26515

FY End
2022-06-30
Total Expended
$1.39M
Findings
8
Programs
13
Organization: Midland Area Agency on Aging (NE)
Year: 2022 Accepted: 2023-01-04
Auditor: Amgl PC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
31500 2022-002 Significant Deficiency - B
31501 2022-002 Significant Deficiency - B
31502 2022-002 Significant Deficiency - B
31503 2022-002 Significant Deficiency - B
607942 2022-002 Significant Deficiency - B
607943 2022-002 Significant Deficiency - B
607944 2022-002 Significant Deficiency - B
607945 2022-002 Significant Deficiency - B

Contacts

Name Title Type
D7ZJLVNG96J6 Linda O'Brien Auditee
4024634565 Tracy Cannon, CPA Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards is presented on the accrual basis of accounting and in accordance with the requirements of the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.
2022-002 ? Significant Deficiency in Internal Control Over Major Federal Programs Program Information: Federal Agency: U.S. Department of Health and Human Services (passed through Nebraska Department of Health and Human Services) Federal Program Title: Special Programs for the Aging Cluster (AL #93.044 Title IIIB-Grants for Supportive Services and Senior Centers, AL #93.045 COVID-19-Title III C-1, C-2-Nutrition Services, AL #93.045 Title III C-1, C-2-Nutrition Services, AL #93.053 Nutrition Services Incentive Program) Grant Award Period: July 1, 2021 through June 30, 2022 Condition: Adequate controls were not in place to ensure the Organization properly tracked employee time worked by program. As a result, payroll expenses have possibly been allocated incorrectly to programs. Criteria: Management is responsible for establishing adequate internal controls to ensure employees properly track time worked by program. Cause: The Organization?s time tracking software allows employee time worked to be allocated to administration duties or time off and those hours are then allocated by program based on how the allocated time was spent in that pay period. Effect: Because of the lack of proper tracking of employee time worked, payroll expenses have possibly been allocated incorrectly to programs. Recommendations: We recommend management implement adequate internal controls to ensure allowable general and administrative employee time is allocated based on a continuous average of allocated hours by program. Management should also review cost allocation plan methods to be sure they are in accordance with the requirements of the Uniform Guidance. View of Responsible Officials and Planned Corrective Actions: The Organization is committed to properly tracking and allocating Federal expenditures. The Organization has created adequate internal control processes to ensure general and administrative time is allocated based on a monthly average of allocated hours by program.