Audit 318675

FY End
2023-09-30
Total Expended
$796,083
Findings
6
Programs
2
Year: 2023 Accepted: 2024-09-06

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
485960 2023-002 Material Weakness - AB
485961 2023-003 Material Weakness - AB
485962 2023-004 - - AB
1062402 2023-002 Material Weakness - AB
1062403 2023-003 Material Weakness - AB
1062404 2023-004 - - AB

Programs

ALN Program Spent Major Findings
93.268 Immunization Cooperative Agreements $622,583 Yes 3
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $55,000 - 0

Contacts

Name Title Type
LT6ZHYBENT87 Jennifer O'Leary Auditee
6309217000 Ron Marklund Auditor
No contacts on file

Notes to SEFA

Title: Note D - Non-Cash Awards Accounting Policies: Note A - Basis of Presentation: The accompanying schedule of expenditures of federal awards includes the federal award activity of Illinois Academy of Family Physicians under programs of the federal government for the year ended September 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 the Schedule presents only a selected portion of the operations of Illinois Academy of Family Physicians, it is not intended to and does not represent the financial position, changes in net assets, or cash flows of Illinois Academy of Family Physicians. Note B - Summary of Significant Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: Y Rate Explanation: Illinois Academy of Family Physicians did elect to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. The Organization did not have any outstanding federal loan or loan guarantees or insurance at September 30, 2023. Illinois Academy of Family Physicians did not receive any federal non-cash awards during the year ended September 30, 2023.
Title: Note E - Sub-Recipients Accounting Policies: Note A - Basis of Presentation: The accompanying schedule of expenditures of federal awards includes the federal award activity of Illinois Academy of Family Physicians under programs of the federal government for the year ended September 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 the Schedule presents only a selected portion of the operations of Illinois Academy of Family Physicians, it is not intended to and does not represent the financial position, changes in net assets, or cash flows of Illinois Academy of Family Physicians. Note B - Summary of Significant Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: Y Rate Explanation: Illinois Academy of Family Physicians did elect to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance. Illinois Academy of Family Physicians did not provide any federal amounts to sub-recipients.

Finding Details

DEPARTMENT OF HEALTH AND HUMAN SERVICES 2023-002 Immunization Cooperative Agreements, ALN #93.268 Criteria: According to 2 CFR Section 200.305(b)(3), all reimbursement requests should be based on supporting documentation that shows the cost was incurred before the request for payment and that the payment to vendor was made. Condition: 4 of the 7 cash drawdown reports tested contained expense reimbursements requested for which there was missing supporting documentation for some of the expenses requested for reimbursements. Total questioned costs were $115,617. Cause: The extra expenses that were missing in the test were because IAFP used staff instead of consultants and the Organization did not update our policies and procedures to include time sheets to show how staff was allocated to the grant to support the charges. Effect: The effect is that the Organization requested funds but did not have back up to support that the actual expenses were incurred and was therefore not in compliance with the cash management requirements under Uniform Grant Guidance in relation reimbursement requests. Auditor recommendation: We recommend that the accounting department verify that the expense has been incurred and paid to the vendor before requesting reimbursement from the grantor and ensure that the backup documentation is filed where it can be located. We recommend hiring or training staff in relation to cash management and documentation of allowable cost. Management response: Management will follow the advice and undergo training in cash management and documentation of allowable costs.
DEPARTMENT OF HEALTH AND HUMAN SERVICES 2023-003 Immunization Cooperative Agreements, ALN #93.268 Criteria: According to 2 CFR 200.430 i(i)(vii) charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed and there should be support to the distributions of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award. Condition: In gaining our understanding of controls over allowable costs for payroll, we noted that the Organization did not have proper documentation of time and effort analysis to support charges to the grants. Cause: The Organization used the grant budget to charge salaries to the grant but did not have any documentation showing an analysis of actual time worked on those grants. Effect: The hours charged to a program could be under stated or overstated if the actual hours differed from the grant budget hours. Auditor’s Recommendation: We recommend implementing the use of time sheets with grants or personnel activity reports that document actual hours worked by personnel on each grant. Management Response: Management will implement time sheets for all employees that work on grants that specify what grants they are working on, number of hours for each for all payrolls in 2024 to correct this problem going forward. In addition, the timesheets will include what functions those
DEPARTMENT OF HEALTH AND HUMAN SERVICES 2023-004 Immunization Cooperative Agreements, ALN #93.268 Criteria: According to 2 CFR Section 200.308, all budget revisions over 10% must receive a budget revision from the grantee. Condition: Following a budget revision of over 10%, an approval was not received from the grantee. Cause: At direction from the pass-through agency, the Organization charged salary expenses to the contract services line items on its request reimbursement instead of getting budget revisions to reflect the change in the work performed. Effect: The costs billed on the vouchers for reimbursement, did not match the natural classification of the actual expenses incurred on the grant resulting in expenses reported being over budget on certain line items and under budget on others. Auditor recommendation: We recommend that when there is a budget revision over 10%, the Organization works with the grantor to get formal documentation to support the revision to ensure amounts charged to the grants are in line with budget line items. Management response: Management will ensure a budget revision be done for any increase over 10% and submit that to the grantor to receive formal approval from the grantor.
DEPARTMENT OF HEALTH AND HUMAN SERVICES 2023-002 Immunization Cooperative Agreements, ALN #93.268 Criteria: According to 2 CFR Section 200.305(b)(3), all reimbursement requests should be based on supporting documentation that shows the cost was incurred before the request for payment and that the payment to vendor was made. Condition: 4 of the 7 cash drawdown reports tested contained expense reimbursements requested for which there was missing supporting documentation for some of the expenses requested for reimbursements. Total questioned costs were $115,617. Cause: The extra expenses that were missing in the test were because IAFP used staff instead of consultants and the Organization did not update our policies and procedures to include time sheets to show how staff was allocated to the grant to support the charges. Effect: The effect is that the Organization requested funds but did not have back up to support that the actual expenses were incurred and was therefore not in compliance with the cash management requirements under Uniform Grant Guidance in relation reimbursement requests. Auditor recommendation: We recommend that the accounting department verify that the expense has been incurred and paid to the vendor before requesting reimbursement from the grantor and ensure that the backup documentation is filed where it can be located. We recommend hiring or training staff in relation to cash management and documentation of allowable cost. Management response: Management will follow the advice and undergo training in cash management and documentation of allowable costs.
DEPARTMENT OF HEALTH AND HUMAN SERVICES 2023-003 Immunization Cooperative Agreements, ALN #93.268 Criteria: According to 2 CFR 200.430 i(i)(vii) charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed and there should be support to the distributions of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award. Condition: In gaining our understanding of controls over allowable costs for payroll, we noted that the Organization did not have proper documentation of time and effort analysis to support charges to the grants. Cause: The Organization used the grant budget to charge salaries to the grant but did not have any documentation showing an analysis of actual time worked on those grants. Effect: The hours charged to a program could be under stated or overstated if the actual hours differed from the grant budget hours. Auditor’s Recommendation: We recommend implementing the use of time sheets with grants or personnel activity reports that document actual hours worked by personnel on each grant. Management Response: Management will implement time sheets for all employees that work on grants that specify what grants they are working on, number of hours for each for all payrolls in 2024 to correct this problem going forward. In addition, the timesheets will include what functions those
DEPARTMENT OF HEALTH AND HUMAN SERVICES 2023-004 Immunization Cooperative Agreements, ALN #93.268 Criteria: According to 2 CFR Section 200.308, all budget revisions over 10% must receive a budget revision from the grantee. Condition: Following a budget revision of over 10%, an approval was not received from the grantee. Cause: At direction from the pass-through agency, the Organization charged salary expenses to the contract services line items on its request reimbursement instead of getting budget revisions to reflect the change in the work performed. Effect: The costs billed on the vouchers for reimbursement, did not match the natural classification of the actual expenses incurred on the grant resulting in expenses reported being over budget on certain line items and under budget on others. Auditor recommendation: We recommend that when there is a budget revision over 10%, the Organization works with the grantor to get formal documentation to support the revision to ensure amounts charged to the grants are in line with budget line items. Management response: Management will ensure a budget revision be done for any increase over 10% and submit that to the grantor to receive formal approval from the grantor.