Common use of CLEARANCE PATTERNS Clause in Contracts

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE). 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None The State shall also adjust each clearance pattern to reflect: None. 7.8 Each of the State's clearance patterns is calculated in business days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate The State shall use program specific methodology to develop program specific clearance patterns are developed for each agency that administers a group of federal grant all programs. 7.2 The following shall develop the State's clearance patterns: The Treasury Division of Information Technology within the Department of State Administration shall provide all the data used in the determination of Colorado utilizing the methodology presented in Sections 7.3 to 7.10appropriate clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine The State's central and subsidiary accounting systems which contain the "check date" data, and the State's depository banks, at which demand deposit (CORE)checking) accounts are maintained, from which federal grant programs disbursements are made, will provide a computer tape of disbursements from the State's bank accounts to identify the date of withdrawal of funds for each check. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None The State shall also adjust each clearance pattern to reflect: None. 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group all programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of federal grant programsthis Agreement. 7.2 The following shall develop the State's clearance patterns: The Treasury State Highway and Transportation Department Department of State Education Department of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Human Services Department of Workforce Services Department of Health 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)the Treasurer of the State of Arkansas' Treasury Management System. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None : A. The State shall also adjust each clearance pattern to reflect: None.: N. A. 7.8 Each of the State's clearance patterns is calculated in business calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE). 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period.: 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None The State shall also adjust each clearance pattern to reflect: None. 7.8 Each of the State's clearance patterns is calculated in business Business days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group all programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of federal grant programsthis Agreement. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State Transportation Department of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Education Department of Human Services Department of Workforce Services 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)the Treasurer of the State of Arkansas' Treasury Management System. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None : A. The State shall also adjust each clearance pattern to reflect: None.: N. A. 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group all programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of federal grant programsthis Agreement. 7.2 The following shall develop the State's clearance patterns: The Treasury State Highway and Transportation Department Department of State Education Arkansas Rehabilitation Services Department of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Health and Human Services Department of Workforce Services 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)the Treasurer of the State of Arkansas' Treasury Management System. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None : A. The State shall also adjust each clearance pattern to reflect: None.: N. A. 7.8 Each of the State's clearance patterns is calculated in business calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service FMS prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate Functional Payment. The Commonwealth shall develop separate clearance patterns are developed for each agency that administers a group or instrumentality listed in Section 5.1 of federal grant programsthis Agreement. The clearance pattern for each agency or instrumentality shall be derived from the transactions applicable to the programs for which each entity is responsible. 7.2 The following shall develop the State's clearance patterns: The Treasury Department Finance and Administration Cabinet shall develop all of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10Commonwealth's clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The source of data the Commonwealth shall use when developing its clearance patterns is the actual expenditures of Federal cash as recorded in the Commonwealth's central accounting system. The Commonwealth shall append to this data the date each expenditure was presented for payment or otherwise culminated. For expenditure transactions executed by check or EFT, the source for presentment dates shall be data obtained indirectly from the Commonwealth's bank through the State Treasurer. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None Not Applicable The State shall also adjust each clearance pattern to reflect: None.Not Applicable 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group all programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of federal grant programsthis Agreement. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State Transportation Department of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Education Department of Human Services Department of Workforce Services 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)the Treasurer of the State of Arkansas' Treasury Management System. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None : A. The State shall also adjust each clearance pattern to reflect: None.: N. A. 7.8 Each of the State's clearance patterns is calculated in business calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs.Average Clearance 7.2 The following shall develop the State's clearance patterns: The Treasury Department of NH State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Treasury 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine For the first year that a program is incorporated under this Agreement the State shall use Fiscal Service-provided clearance patterns if available or the clearance pattern of a program currently in compliance with the Act that most closely compares with the newly complying program. For years subsequent to the first year, the State shall use its accounting system data and bank account clearance data to determine an accurate clearance pattern of each program. (COREFor a summary of the results of clearance pattern calculations refer to Exhibit II). 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None NA The State shall also adjust each clearance pattern to reflect: None.NA 7.8 Each of the State's clearance patterns is calculated in business days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs.Not Applicable 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10Bank shall develop clearance patterns for Vendor and Payroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The Commonwealth's controlled disbursement accounts. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None DocuSign Envelope ID: E1334640-5FCB-4711-8B1D-E406BB911891 Not Applicable The State shall also adjust each clearance pattern to reflect: None.Not Applicable 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs.Not Applicable 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10Bank shall develop clearance patterns for Vendor and Payroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The Commonwealth's controlled disbursement accounts. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None Not Applicable The State shall also adjust each clearance pattern to reflect: None.Not Applicable 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate : a. Accounts payable checks issued to State (non-NDOT) vendors for goods and services; b. Benefits checks issued on the "Welfare" check writing system; c. Payroll checks issued through Central Payroll, including NDOT. The payroll clearance patterns pattern is based on net payroll check amounts; d. Accounts payable checks issued to Nevada Department of Transportation (NDOT) vendors; e. If more than 50% of non-payroll disbursements under a Federal program, or specific component of a Federal program, are developed for each agency that administers made to vendors via ACH/direct deposit a group separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of federal grant programsthe program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Controller's Office 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The check activity data maintained within the State's accounting system. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None N/A The State shall also adjust each clearance pattern to reflect: NoneFrom fiscal year 2021 transactions, the total amount of disbursements clearing the bank in the same number of days during the year is divided by the sum of all disbursements clearing. This ratio is multiplied by the number of days to clear, resulting in a clearance factor. The weighted average number of days to clear the State's bank account is the sum of all daily clearance factors. 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs.Not Applicable 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10Bank shall develop clearance patterns for Vendor and Payroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The Commonwealth's controlled disbursement accounts. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. Docusign Envelope ID: AF01C367-B24A-482D-A91C-CA341D43F582 For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None Not Applicable The State shall also adjust each clearance pattern to reflect: None.Not Applicable 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed for each agency that administers a group of federal grant programs.N/A 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Controller's Office 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The check activity data maintained within the State's accounting system. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None N/A The State shall also adjust each clearance pattern to reflect: NoneFrom fiscal year 2020 transactions, the total amount of disbursements clearing the bank in the same number of days during the year is divided by the sum of all disbursements clearing. This ratio is multiplied by the number of days to clear, resulting in a clearance factor. The weighted average number of days to clear the State's bank account is the sum of all daily clearance factors. 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate clearance patterns are developed Functional Payment/Bank Account for each agency that administers a group of federal grant programsvendor payment, payroll and other cost. 7.2 The following shall develop the State's clearance patterns: The Treasury Virgin Islands Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10Finance. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE).Financial Management System and Banco Popular de Puerto Rico 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None The State shall also adjust each clearance pattern to reflect: None.Not Applicable 7.8 Each of the State's clearance patterns is calculated in business calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate : a. Accounts payable checks issued to State (non-NDOT) vendors for goods and services; b. Benefits checks issued on the "Welfare" check writing system; c. Payroll checks issued through Central Payroll, including NDOT. The payroll clearance patterns pattern is based on net payroll check amounts; d. Accounts payable checks issued to Nevada Department of Transportation (NDOT) vendors; e. If more than 50% of non-payroll disbursements under a Federal program, or specific component of a Federal program, are developed for each agency that administers made to vendors via ACH/direct deposit a group separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of federal grant programsthe program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Controller's Office 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The check activity data maintained within the State's accounting system. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None N/A The State shall also adjust each clearance pattern to reflect: NoneFrom fiscal year 2023 transactions, the total amount of disbursements clearing the bank in the same number of days during the year is divided by the sum of all disbursements clearing. This ratio is multiplied by the number of days to clear, resulting in a clearance factor. The weighted average number of days to clear the State's bank account is the sum of all daily clearance factors. 7.8 Each of the State's clearance patterns is calculated in business Calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: Separate : a. Accounts payable checks issued to State (non-NDOT) vendors for goods and services; b. Benefits checks issued on the "Welfare" check writing system; c. Payroll checks issued through Central Payroll, including NDOT. The payroll clearance patterns pattern is based on net payroll check amounts; d. Accounts payable checks issued to Nevada Department of Transportation (NDOT) vendors; e. If more than 50% of non-payroll disbursements under a Federal program, or specific component of a Federal program, are developed for each agency that administers made to vendors via ACH/direct deposit a group separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of federal grant programsthe program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: The Treasury Department of State of Colorado utilizing the methodology presented in Sections 7.3 to 7.10.Controller's Office 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Colorado Operations Resource Engine (CORE)The check activity data maintained within the State's accounting system. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each clearance pattern, the State shall track at least 99% of the funds disbursed, from issuance to clearance, for a period of at least three months. For all clearance patterns developed by statistical sampling, the State shall randomly sample checks to ensure, at a minimum, a 95% confidence interval for a .25 weighted-day level of precision for the checks in the sample. The State shall track at least 99% of the funds disbursed, from issuance to clearance, in the sample period. 7.5 The State shall identify for each check or warrant (hereafter, check) in the population: (1) the date the check was released for payment; (2) the date the check was debited from the State's account, and, (3) the amount of the check. 7.6 The State shall use the following method to calculate the dollar-weighted average day of clearance: To determine the number of days each check was outstanding (clearance time), the issue date shall be subtracted from the date the check cleared the State's account. To determine the percentage of the disbursement paid out each day following issuance, the amount of the checks that clear the State's account each day shall be summed and then divided by the amount of the total disbursement. For each day following issuance, the clearance time of the checks paid out that day shall be multiplied by the percentage of the total disbursement those checks represent. This product is the clearance factor. The dollar-weighted average day of clearance for the disbursement shall be determined by summing the clearance factor of each day following the disbursement. 7.7 The State shall adjust each clearance pattern to reflect the dollar-weighted proportion of funds paid out by EFT/Direct payroll, with the following exceptions: None N/A The State shall also adjust each clearance pattern to reflect: NoneFrom fiscal year 2019 transactions, the total amount of disbursements clearing the bank in the same number of days during the year is divided by the sum of all disbursements clearing. This ratio is multiplied by the number of days to clear, resulting in a clearance factor. The weighted average number of days to clear the State's bank account is the sum of all daily clearance factors. 7.8 Each of the State's clearance patterns is calculated in business calendar days. 7.9 An authorized State official shall certify that each clearance pattern developed by the State accurately corresponds to the clearance activity of the programs to which it is applied. This certification shall be provided to the Fiscal Service prior to the effective date of the Agreement. The State shall recertify its clearance patterns at least every five years. 7.10 The State shall follow the procedures of 31 CFR 205 if it has actual or constructive knowledge, at any time, that a clearance pattern does not correspond to a program's clearance activity.