Audit 310145

FY End
2023-11-30
Total Expended
$1.13M
Findings
4
Programs
6
Organization: Harrisburg Area YMCA (PA)
Year: 2023 Accepted: 2024-06-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
402898 2023-001 Significant Deficiency - AB
402899 2023-001 Significant Deficiency - AB
979340 2023-001 Significant Deficiency - AB
979341 2023-001 Significant Deficiency - AB

Contacts

Name Title Type
REBAQFSFYN97 Megan Mauer Auditee
7172322068 David Manbeck, CPA Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in OMB Circular A-122, Cost Principles for Non-profit Organizations, or the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards, 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. Pass-through entity, identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: Harrisburg Area YMCA has not elected to use the 10% de-minimis, indirect cost rate allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the Federal grant activity of Harrisburg Area YMCA under programs of the Federal government for the year ended November 30, 2023. 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 this Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the financial position, changes in net assets or cash flows of Harrisburg Area YMCA.

Finding Details

Criteria: Uniform Guidance requires an employee whose salary and wages are supported, in whole or in part, with Federal funds to document his/her time spent working on Federal programs in order to ensure that charges to each Federal program reflect an accurate account of the employee’s time and effort devoted to that program. CFR 200.430 states, “Charges to Federal Awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated.” The records must also “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: A sample of 7 payroll transactions were selected for testing from a population of 67 transactions. The sample included all personnel with time allocated to the program. Through testing, it was found that there were no records maintained to support the portion of time and effort dedicated to the program. Cause and Effect: Due to staff turnover during the year, the Organization neglected to maintain the required documentation. The Organization receives federal funding based on allowable costs charged to the program. If documentation is not maintained to support the allowability of costs charged to the program, the Organization may be utilizing the funds for expenses which are unallowable. This may result in the return of federal funds to the funding agency for the unallowable costs, if deemed appropriate. Questioned Costs: Salary and related benefits of employees charged to the program = $223,234 Identification as a repeat finding: There was no single audit requirement in the prior year and therefore, this finding is not reported as a repeated finding. Recommendation: We recommend that controls be reviewed and revised to ensure that time and effort distribution records are prepared for staff who are charged to federal programs. These records should also be reviewed, approved, and maintained by administrative personnel.
Criteria: Uniform Guidance requires an employee whose salary and wages are supported, in whole or in part, with Federal funds to document his/her time spent working on Federal programs in order to ensure that charges to each Federal program reflect an accurate account of the employee’s time and effort devoted to that program. CFR 200.430 states, “Charges to Federal Awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated.” The records must also “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: A sample of 7 payroll transactions were selected for testing from a population of 67 transactions. The sample included all personnel with time allocated to the program. Through testing, it was found that there were no records maintained to support the portion of time and effort dedicated to the program. Cause and Effect: Due to staff turnover during the year, the Organization neglected to maintain the required documentation. The Organization receives federal funding based on allowable costs charged to the program. If documentation is not maintained to support the allowability of costs charged to the program, the Organization may be utilizing the funds for expenses which are unallowable. This may result in the return of federal funds to the funding agency for the unallowable costs, if deemed appropriate. Questioned Costs: Salary and related benefits of employees charged to the program = $223,234 Identification as a repeat finding: There was no single audit requirement in the prior year and therefore, this finding is not reported as a repeated finding. Recommendation: We recommend that controls be reviewed and revised to ensure that time and effort distribution records are prepared for staff who are charged to federal programs. These records should also be reviewed, approved, and maintained by administrative personnel.
Criteria: Uniform Guidance requires an employee whose salary and wages are supported, in whole or in part, with Federal funds to document his/her time spent working on Federal programs in order to ensure that charges to each Federal program reflect an accurate account of the employee’s time and effort devoted to that program. CFR 200.430 states, “Charges to Federal Awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated.” The records must also “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: A sample of 7 payroll transactions were selected for testing from a population of 67 transactions. The sample included all personnel with time allocated to the program. Through testing, it was found that there were no records maintained to support the portion of time and effort dedicated to the program. Cause and Effect: Due to staff turnover during the year, the Organization neglected to maintain the required documentation. The Organization receives federal funding based on allowable costs charged to the program. If documentation is not maintained to support the allowability of costs charged to the program, the Organization may be utilizing the funds for expenses which are unallowable. This may result in the return of federal funds to the funding agency for the unallowable costs, if deemed appropriate. Questioned Costs: Salary and related benefits of employees charged to the program = $223,234 Identification as a repeat finding: There was no single audit requirement in the prior year and therefore, this finding is not reported as a repeated finding. Recommendation: We recommend that controls be reviewed and revised to ensure that time and effort distribution records are prepared for staff who are charged to federal programs. These records should also be reviewed, approved, and maintained by administrative personnel.
Criteria: Uniform Guidance requires an employee whose salary and wages are supported, in whole or in part, with Federal funds to document his/her time spent working on Federal programs in order to ensure that charges to each Federal program reflect an accurate account of the employee’s time and effort devoted to that program. CFR 200.430 states, “Charges to Federal Awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated.” The records must also “Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: A sample of 7 payroll transactions were selected for testing from a population of 67 transactions. The sample included all personnel with time allocated to the program. Through testing, it was found that there were no records maintained to support the portion of time and effort dedicated to the program. Cause and Effect: Due to staff turnover during the year, the Organization neglected to maintain the required documentation. The Organization receives federal funding based on allowable costs charged to the program. If documentation is not maintained to support the allowability of costs charged to the program, the Organization may be utilizing the funds for expenses which are unallowable. This may result in the return of federal funds to the funding agency for the unallowable costs, if deemed appropriate. Questioned Costs: Salary and related benefits of employees charged to the program = $223,234 Identification as a repeat finding: There was no single audit requirement in the prior year and therefore, this finding is not reported as a repeated finding. Recommendation: We recommend that controls be reviewed and revised to ensure that time and effort distribution records are prepared for staff who are charged to federal programs. These records should also be reviewed, approved, and maintained by administrative personnel.