Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.
Criteria: 2 CFR 200.430(i)(1)(viii) states that “budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim changes made to a Federal award based on budget estimates. All necessary adjustments must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated.” Condition: Grant hours are not tracked on the employee monthly timesheet. Wages charged to the
program are based on estimated hours worked. The Alliance does not have procedures in place to convert estimated to actual hours.
Cause: Management used to record actual hours worked by grant. Based on instructions from a prior
auditor, the accounting function stopped tracking actual hours and used estimated hours to apply wages and related costs to its various grants.
Effect: Management is not in compliance with requirements for federal awards. Any costs
disallowed by a federal agency, or a pass-through entity, could require repayment of those costs to the funding source.
Repeat finding of 2022-003
Questioned costs: Not determined – For program personnel that worked solely on the federal award, their time worked was charged 100% to the federal award and there is a written time record of this, so there is no question about these costs. In addition, the Alliance incurred more costs for the program than were reimbursed under the major program federal award or reimbursed under matching funds. Perspective: Management was following a prior auditor’s incorrect advice that such detail of actual time spent on each grant and other functions was not necessary. Due to the predecessor auditor firm’s schedule, the 2022 audit was not complete until March of 2024. This did not allow management to implement their corrective action plan until 2024. Recommendation: Management should ensure that their procedures for recording time worked, for both exempt and nonexempt employees, is a real-time written or electronic record of time worked for each program/grant. The total hours worked should agree with the total hours being paid. For employees that work on more than one program during a day, the time record should reflect all of the programs/grants on which the employee spent time as a program service, or on administrative or fundraising functions. Views of Responsible Officials: The Alliance has reinstituted an hourly timesheet format in order to account for positions with multiple funding sources.