Audit 30926

FY End
2022-09-30
Total Expended
$12.84M
Findings
8
Programs
4
Year: 2022 Accepted: 2023-06-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
32682 2022-001 Significant Deficiency Yes A
32683 2022-002 Significant Deficiency Yes B
32684 2022-001 Significant Deficiency Yes A
32685 2022-002 Significant Deficiency Yes B
609124 2022-001 Significant Deficiency Yes A
609125 2022-002 Significant Deficiency Yes B
609126 2022-001 Significant Deficiency Yes A
609127 2022-002 Significant Deficiency Yes B

Contacts

Name Title Type
V9F4NW2ELL87 Chase Fry Auditee
2025442266 James Larson Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Expenditures reported on the Schedule are reported on the cash basis of accounting, and, accordingly, represent the total cash expended for the programs. The Schedule does not include transactions that might be included using the accrual basis of accounting as contemplated by generally accepted accounting principles. Expenditures reported on the Schedule 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. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate.

Finding Details

Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 CFR 200 Section 200.302 establishes non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: During the current year audit, we had difficulty obtaining the correct financial reports from the accounting software. Context: Fry was unable to extract the correct reports or prepare proper reports. These reports include the Schedule of Federal Expenditures (SEFA), program profit and loss statements, and the functional expense statement. Multiple version of all requested financial documents were provided. Cause: Fry's accounting is not set up properly to allow for easy and accurate record keeping. There is also no review and approval of transactions posted to the accounting software. Effect or Potential Effect: We were unable to trace revenue to the proper general ledger account. We could not trace salary allocations to the project. The major program profit and loss did not tie to the SEFA. Question Costs: None Identification of Repeat Finding: 2021-001 Recommendation: Fry should set up project/class codes for each program, fundraising, and general and administrative in the accounting software. We also recommend Fry hires someone with accounting experience in relation to government grants to assist in the setup and to help maintain records throughout the year. Accounts should be reconciled on a monthly basis and have a review and approval process for all accounts.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, paragraph 430 ?Compensation ? personal services? requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, and that these records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, these records must comply with established accounting policies and practices of the non-Federal entity. Condition: Timesheets implemented during the period under audit, but they are not used to support allocation to programs. We noted that payroll transactions lacked a timesheet or other evidence of proper record-keeping to support the program allocations of salaries and related expenses in the general ledger. Context: Fry failed to keep adequate time records to support the amounts charged to Federal program. Our audit work in this area consisted of internal control testwork over a random sample of expenditures. We consider our samples to be representative of the respective populations, and thus, are statistically valid samples. The issue is considered systemic in nature. Cause: Fry?s does not use timesheets for allocations Effect or Potential Effect: Fry could inadvertently mischarge salaries and wages to its various programs. Question Costs: Indeterminable Identification of Repeat Finding: 2021-002 Recommendation: We recommend that Fry uses the implemented timesheets to support program allocations.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 CFR 200 Section 200.302 establishes non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: During the current year audit, we had difficulty obtaining the correct financial reports from the accounting software. Context: Fry was unable to extract the correct reports or prepare proper reports. These reports include the Schedule of Federal Expenditures (SEFA), program profit and loss statements, and the functional expense statement. Multiple version of all requested financial documents were provided. Cause: Fry's accounting is not set up properly to allow for easy and accurate record keeping. There is also no review and approval of transactions posted to the accounting software. Effect or Potential Effect: We were unable to trace revenue to the proper general ledger account. We could not trace salary allocations to the project. The major program profit and loss did not tie to the SEFA. Question Costs: None Identification of Repeat Finding: 2021-001 Recommendation: Fry should set up project/class codes for each program, fundraising, and general and administrative in the accounting software. We also recommend Fry hires someone with accounting experience in relation to government grants to assist in the setup and to help maintain records throughout the year. Accounts should be reconciled on a monthly basis and have a review and approval process for all accounts.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, paragraph 430 ?Compensation ? personal services? requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, and that these records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, these records must comply with established accounting policies and practices of the non-Federal entity. Condition: Timesheets implemented during the period under audit, but they are not used to support allocation to programs. We noted that payroll transactions lacked a timesheet or other evidence of proper record-keeping to support the program allocations of salaries and related expenses in the general ledger. Context: Fry failed to keep adequate time records to support the amounts charged to Federal program. Our audit work in this area consisted of internal control testwork over a random sample of expenditures. We consider our samples to be representative of the respective populations, and thus, are statistically valid samples. The issue is considered systemic in nature. Cause: Fry?s does not use timesheets for allocations Effect or Potential Effect: Fry could inadvertently mischarge salaries and wages to its various programs. Question Costs: Indeterminable Identification of Repeat Finding: 2021-002 Recommendation: We recommend that Fry uses the implemented timesheets to support program allocations.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 CFR 200 Section 200.302 establishes non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: During the current year audit, we had difficulty obtaining the correct financial reports from the accounting software. Context: Fry was unable to extract the correct reports or prepare proper reports. These reports include the Schedule of Federal Expenditures (SEFA), program profit and loss statements, and the functional expense statement. Multiple version of all requested financial documents were provided. Cause: Fry's accounting is not set up properly to allow for easy and accurate record keeping. There is also no review and approval of transactions posted to the accounting software. Effect or Potential Effect: We were unable to trace revenue to the proper general ledger account. We could not trace salary allocations to the project. The major program profit and loss did not tie to the SEFA. Question Costs: None Identification of Repeat Finding: 2021-001 Recommendation: Fry should set up project/class codes for each program, fundraising, and general and administrative in the accounting software. We also recommend Fry hires someone with accounting experience in relation to government grants to assist in the setup and to help maintain records throughout the year. Accounts should be reconciled on a monthly basis and have a review and approval process for all accounts.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, paragraph 430 ?Compensation ? personal services? requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, and that these records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, these records must comply with established accounting policies and practices of the non-Federal entity. Condition: Timesheets implemented during the period under audit, but they are not used to support allocation to programs. We noted that payroll transactions lacked a timesheet or other evidence of proper record-keeping to support the program allocations of salaries and related expenses in the general ledger. Context: Fry failed to keep adequate time records to support the amounts charged to Federal program. Our audit work in this area consisted of internal control testwork over a random sample of expenditures. We consider our samples to be representative of the respective populations, and thus, are statistically valid samples. The issue is considered systemic in nature. Cause: Fry?s does not use timesheets for allocations Effect or Potential Effect: Fry could inadvertently mischarge salaries and wages to its various programs. Question Costs: Indeterminable Identification of Repeat Finding: 2021-002 Recommendation: We recommend that Fry uses the implemented timesheets to support program allocations.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 CFR 200 Section 200.302 establishes non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: During the current year audit, we had difficulty obtaining the correct financial reports from the accounting software. Context: Fry was unable to extract the correct reports or prepare proper reports. These reports include the Schedule of Federal Expenditures (SEFA), program profit and loss statements, and the functional expense statement. Multiple version of all requested financial documents were provided. Cause: Fry's accounting is not set up properly to allow for easy and accurate record keeping. There is also no review and approval of transactions posted to the accounting software. Effect or Potential Effect: We were unable to trace revenue to the proper general ledger account. We could not trace salary allocations to the project. The major program profit and loss did not tie to the SEFA. Question Costs: None Identification of Repeat Finding: 2021-001 Recommendation: Fry should set up project/class codes for each program, fundraising, and general and administrative in the accounting software. We also recommend Fry hires someone with accounting experience in relation to government grants to assist in the setup and to help maintain records throughout the year. Accounts should be reconciled on a monthly basis and have a review and approval process for all accounts.
Information on the Federal Program: Assistance Living Number 21.027 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, paragraph 430 ?Compensation ? personal services? requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, and that these records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, these records must comply with established accounting policies and practices of the non-Federal entity. Condition: Timesheets implemented during the period under audit, but they are not used to support allocation to programs. We noted that payroll transactions lacked a timesheet or other evidence of proper record-keeping to support the program allocations of salaries and related expenses in the general ledger. Context: Fry failed to keep adequate time records to support the amounts charged to Federal program. Our audit work in this area consisted of internal control testwork over a random sample of expenditures. We consider our samples to be representative of the respective populations, and thus, are statistically valid samples. The issue is considered systemic in nature. Cause: Fry?s does not use timesheets for allocations Effect or Potential Effect: Fry could inadvertently mischarge salaries and wages to its various programs. Question Costs: Indeterminable Identification of Repeat Finding: 2021-002 Recommendation: We recommend that Fry uses the implemented timesheets to support program allocations.