Common use of CLEARANCE PATTERNS Clause in Contracts

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: N/A 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparedness 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes. 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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/A 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State shall develop separate clearance patterns for the Statewide Payroll and each program and independent functions within specific programs listed in sections 4.2 and 4.3 (any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administration shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data utilized in the development of clearance patterns comes from SABHRS (Statewide Accounting, checks cleared reports from the bankBudget, and reconciliation tapesHuman Resource System). The System is administered by the SABHRS Financial Services Technology Bureau of the State Financial Services Division within the Department of Administration. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AEstimated clearance for vendors, beneficiaries, administration and payroll 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessAgencies administering grants 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersBank statements, checks cleared reports from the bank, and debit reconciliation tapes.reports 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. 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: N/A Not applicable The State shall also adjust each clearance pattern to reflect: NNone/ANA 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AVendor Payments and Payroll 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Treasurer's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe files maintained by the State Treasurer's Office which indicate the date each vendor check, checks cleared reports payroll check, or ACH payment was disbursed, and data obtained from the State's disbursement bank indicating when each vendor check or payroll check cleared the bank, and reconciliation tapes. 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. 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: N/A No exceptions at this time. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions at this time. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AWith the exception of programs administered by recipient Agency 350, Superintendent of Public Instruction, where all federal program payroll charges are based on 100% EFT payroll, the State shall develop a clearance pattern for the payroll and administrative function. This clearance pattern shall be applied to the payroll and administrative components of all programs. 7.2 The following shall develop the State's clearance patterns: Department The Office of EducationFinancial Management, Department in conjunction with the Office of Transportation and Development the State Treasurer (OST) and the Governorapplicable agency, shall develop all of the State's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersType of Clearance Pattern: Payroll and Administrative; Source of Data: Human Resource Management System (HRMS) and OST's EFT and warrant redemption records. Type of Clearance Pattern: Program specific; Source of Data: Agency warrant registers and OST's warrant redemption records. For CFDA 20.205, checks cleared reports from the bank, and reconciliation tapesagency system is TRAINS. 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. 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: NFor most programs, the State distinguishes the payroll clearance from the recipient/A benefit payments as a separate cash flow. However, in Agency 300, composite rate payroll clearance patterns are included in the agency's composite rate. Both the warrant clearance and the EFT payroll are considered in calculating the composite rate. The State shall also adjust each clearance pattern to reflect: N/ANone. Not applicable. 7.8 Each of the State's clearance patterns is calculated in 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: N/APayments made from the State's non-payroll and payroll accounts and for the Medical Assistance Program (CFDA 93.778). 7.2 The following shall develop the State's clearance patterns: Medical Assistance Program Clearance Pattern The New York State Department of EducationHealth calculates the Medical Assistance clearance pattern based upon check presentment data compiled by the State's contractor bank. Functional Clearance Patterns New York State develops functional clearance patterns based on 1) New York's Statewide Financial System records of State employee payroll checks and checks written to non-employees, Department of Transportation and Development and 2) from check presentment files maintained by the GovernorState's Office of Homeland Security and Emergency Preparednesscontractor bank. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesSee 7.11.0. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANot applicable. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AVendor Account Payroll Account AHS-PATH Account Unemployment Insurance Benefits Account Federal Highway Planning & Construction Program (Vendor Account) 7.2 The following shall develop the State's clearance patterns: The State of Vermont-Department of Education, Department of Transportation Finance and Development and the Governor's Office of Homeland Security and Emergency PreparednessManagement 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Vendor account-State's central accounting system Unemployment Insurance Benefits Account-Department of Labor bank records All other accounts-Bank files from the bank, and reconciliation tapes.State Treasurer's Office 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. 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: N/A All Accounts - An adjustment is not necessary since the State includes all payments in its clearance pattern calculations, including those paid electronically. The State shall also adjust each clearance pattern to reflect: Nn/Aa 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AVendor Payments and Payroll 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Treasurer's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe files maintained by the State Treasurer's Office which indicate the date each vendor check, checks cleared reports payroll check, or ACH payment was disbursed, and data obtained from the State's disbursement bank indicating when each vendor check or payroll check cleared the bank, and reconciliation tapes. 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. 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: N/A No exceptions at this time. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions at this time. 7.8 Each of the State's clearance patterns is calculated in 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: N/APayroll Expenses, Contingent Expenses, and Direct Benefits. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Treasurer's Office of Homeland Security Cash Management, Information Technology, Accounting and Emergency PreparednessFinancial Reporting divisions have developed the State's clearance patterns in section 7.1. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Financial information from the bankSouth Carolina Enterprise Information System (SCEIS) and actual bank data shall be used for payroll, contingent and reconciliation tapesdirect benefit expenditures. The South Carolina Department of Employment and Workforce shall provide information/develop clearance patterns for the Unemployment Insurance programs. The South Carolina Department of Health and Human Services shall provide information for the Medical Assistance Program, (CFDA 93.778). The state excludes transfers between funds (Journal Vouchers and Cash Transfers) and transfers between agencies in the same fund (Inter Departmental Transfers). These transfers occur on the same day. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State may develop a separate clearance pattern for an individual program, or develop a composite clearance pattern for a logical group of programs, or develop a clearance pattern on another basis acceptable to the Bureau of the Fiscal Service. The State shall ensure that a clearance pattern accurately represents the flow of Federal funds and that a clearance pattern reflects seasonal or other periodic variations in clearance activity. 7.2 The following shall develop the State's clearance patterns: Department The State will develop the State's clearance patterns. The records of Education, Department the Office of Transportation Management and Development Enterprise Services will serve as the system of record for sampling data. Supplemental data from the Oklahoma State Treasurer and the Governor's Office of Homeland Security and Emergency Preparednessrecipient agency will be utilized. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersDevelopment of clearance patterns will be based on data from at least 3 consecutive months; based on 100 percent of the data, checks cleared reports from the bankor on a sample size sufficient to ensure, at a minimum, a 96 percent confidence interval for a plus or minus .25% weighted-day level of precision; and reconciliation tapestruncated at no less than 99 percent of disbursement dollars. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N/AThere are currently no program components listed in Section 7.1. 7.2 The following shall develop the State's clearance patterns: Tennessee Department of Education, Treasury Tennessee Department of Transportation Finance and Development and the Governor's Office of Homeland Security and Emergency PreparednessAdministration 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes.State Treasurer's Accounts Reconciliation Package (ARP) system State's central accounting system (Edison) 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANot applicable. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State shall develop clearance patterns for each program that uses a delay of draw by measuring the dollar-weighted number of days between the day expenditures are sent to Treasury for payment and the day the related checks clear. Each program is examined to determine the appropriation(s) supporting it (Federal financial assistance to the State is reappropriated by the legislature). The relevant appropriation(s), an integral element of the voucher transmittals (VTs) used by Commonwealth agencies to request payment, control(s) the selection of VTs for the check clearance research. All checks associated with the selected VTs during a fiscal year are examined. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The data is assembled by the State Treasurer and Development and forwarded to the Governor's Office of Homeland Security the Budget, Comptroller Operations, which creates and Emergency Preparednessruns the computer program that measures clearance activity and computes the clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, : (1) electronic files provided by the State's financial institutions indicating the dates checks cleared reports from the bankcleared, and reconciliation tapes(2) electronic files provided by the State Treasurer indicating unique identifying numbers and the related check issuance dates. 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. 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: NIn those instances where an expenditure is paid via EFT/A Direct payroll, the check clearance pattern is determined by using the date the expenditure is sent to the State Treasurer for payment to the date the funds clear the bank. The State shall also adjust each clearance pattern to reflect: N/AThe clearance date of each check is compared to the related date the expenditure was sent to the State Treasurer for payment to determine the actual number of days between these two events. The clearance time of each voucher transmittal is individually calculated and a dollar-weighted average day of clearance is calculated. This clearance time is then applied to all voucher transmittals that are part of the clearance pattern. The clearance time of each check in the study is dollar-weighted to produce the dollar-weighted average day of clearance after expenditure posting. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State shall use the same methodology to develop a separate clearance pattern for each program under the State Departments; Education, Social Services and Transportation. 7.2 The following shall develop the State's clearance patterns: Department The Bureau of Education, Department of Transportation Finance and Development and Management shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe State shall use the following method to develop clearance patterns for System warrants: For a three-month period, all checks or warrants issued shall have their dates compared to check or warrant clearance dates. From this information, dollar-weighted average clearance patterns shall be developed. For calculation purposes, all checks and warrants will be deemed cleared reports from when 99% of the bankchecks or warrants have been cleared. For payroll, the following will be used on a statewide basis. All State payroll will be drawn to be received on the 1st and reconciliation tapes16th of each month. If a payday falls on a Saturday or Sunday, the payday will be moved up to the first working day before the 1st or 16th. This will differ for the months of January and July, when the payday will be the first working day of the calendar and fiscal year. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/AFor the modified average clearance funding technique where percentages of checks mailed is reported by the State Department in section 6.3.2 as less than 1.00%, the program average day of clearance is adjusted to 1 day. 7.8 Each of the State's clearance patterns is calculated in 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: N/A 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparedness 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes. 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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/A 7.8 Each of the State's clearance patterns is calculated in Calendar 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. 7.11 The State will usually use the actual expenditures for calculating payroll costs. However, at June 30 and December 31 of any year, it may be necessary to use estimated costs for payroll expenditures, based upon the day of the week when the State 's payroll system will update the State's accounting system. This is due to when the last payroll in June or December will post to the accounting system. Drawdowns for payroll expenditures will be reconciled within 14 days after these two dates. Draws will be adjusted accordingly. Every effort will be made to ensure accuracy and any errors will be corrected in the next draw. Such errors will be interest neutral.

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: N/AFunctional payments for Benefit payments, vendor payments, administrative and indirect costs. 7.2 The following shall develop the State's clearance patterns: Guam Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessAdministration 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes.Budget & Accounting Information System (BACIS)/AS400 Platform 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AVendor Account Payroll Account AHS-PATH Account Unemployment Insurance Benefits Account Federal Highway Planning & Construction Program (Vendor Account) 7.2 The following shall develop the State's clearance patterns: The State of Vermont-Department of Education, Department of Transportation Finance and Development and the Governor's Office of Homeland Security and Emergency PreparednessManagement 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Vendor account-State's central accounting system Unemployment Insurance Benefits Account-Department of Labor bank records All other accounts-Bank files from the bank, and reconciliation tapes.State Treasurer's Office 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. 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: N/A All Accounts - An adjustment is not necessary since the State includes all payments in its clearance pattern calculations, including those paid electronically. The State shall also adjust each clearance pattern to reflect: Nn/Aa 7.8 Each of the State's clearance patterns is calculated in 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: a. Functional Payment: N/APayroll - State Central Payroll Checks b. The programs as described in section 4.2 that meet or exceed the threshold 7.2 The following shall develop the State's clearance patterns: Department of Education, Budget and Finance Department of Transportation Accounting and Development and the Governor's Office of Homeland Security and Emergency PreparednessGeneral Services, Information & Communication Services Division 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: The State of Hawaii’s Financial Accounting and Management Information System (FAMIS), Check registers, checks cleared reports from the bankReconciliation System, and reconciliation tapesCheck Writing System. The Department of Education’s Central 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/AThe State shall adjust each clearance pattern to reflect actual date the checks cleared the State's bank account for other than Department of Education checks. To arrive at the date the check was debited from the State's account (7.5, Item 2) the average day of clearance must be reduced by 1.45 days. The State computer files show the cashed date as the date the checks were returned to the State Treasury by the drawee bank. However, the checks were redeemed and charged to the State's bank account by the drawee bank on the prior banking day. Accordingly, the average day of clearance is overstated by approximately 1.45 calendar days. The "rounded average day of clearance" in Exhibit II is adjusted to reflect the day the checks were cashed at the drawee bank and charged to the State's bank account. The following is the computation of the 1.45 days factor: State of Hawaii Agencies (Other than Department of Education) Clearance Pattern Adjustment: Check Cashed by Bank; Recorded Cashed by State; Difference-Cashed & Recorded Monday; Tuesday; 1 day Tuesday; Wednesday; 1 day Wednesday; Thursday; 1 day Thursday; Friday; 1 day Friday; Monday; 3 days Total difference = 7 days Computation to determine number of days to be adjusted: 39 weeks x (7/5) = 54.60 (Holiday Factor) 13 weeks x (8/5) = 20.80 52 weeks = 75.40 / 52 weeks = 1.45 days 1.45 days will be reduced from the State-calculated clearance pattern to arrive at the clearance pattern to be used by the State in Exhibit II. 7.8 Each of the State's clearance patterns is calculated in 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: N/AEach program listed in Section 4.2 and 4.3 of this agreement 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The various State agencies' accounting systems create a report that measures clearance activity for warrants with unique identifying numbers and Development and computes the Governor's Office of Homeland Security and Emergency Preparednessclearance patterns. The state agencies administering the programs shall run the report to determine the check clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The North Carolina Department of State Treasurer provides electronic files to the bank, various State agencies' accounting systems that includes warrant clearance dates and reconciliation tapesamounts. 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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/A 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/A 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorNew Mexico State Treasurer's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe State does not use funding techniques which require clearance patterns. 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.: 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: N/A The State does not use funding techniques which require clearance patterns. The State shall also adjust each clearance pattern to reflect: N/AThe State does not use funding techniques which require clearance patterns. 7.8 Each of the State's clearance patterns is calculated in 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: N/AProgram and Payroll 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorWV State Treasurer's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes.Actual Bank Data 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. 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: N/A No Exceptions The State shall also adjust each clearance pattern to reflect: N/ANo Adjustments 7.8 Each of the State's clearance patterns is calculated in 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: N/ASeparate 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 Education, Department State of Transportation and Development and Colorado utilizing the Governor's Office of Homeland Security and Emergency Preparednessmethodology 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: Check registers, checks cleared reports from the bank, and reconciliation tapesColorado 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.: 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANone. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall use the same methodology to develop a separate clearance pattern for each program under the State Departments; Education, Health, Social Services and Transportation. 7.2 The following shall develop the State's clearance patterns: Department The Bureau of Education, Department of Transportation Finance and Development and Management shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe State shall use the following method to develop clearance patterns for System warrants: For a three month period, all checks or warrants issued shall have their dates compared to check or warrant clearance dates. From this information, dollar-weighted average clearance patterns shall be developed. For calculation purposes, all checks and warrants will be deemed cleared reports from when 99% of the bankchecks or warrants have been cleared. For payroll, the following will be used on a statewide basis. All state payroll will be drawn to be received on the 1st and reconciliation tapes16th of each month. If a payday falls on a Saturday or Sunday, the payday will be moved up to the first working day before the 1st or 16th. This will differ for the months of January and July, when the payday will be the first working day of the calendar and fiscal year. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/AFor the modified average clearance funding technique where percentages of checks mailed is reported by the State Department in section 6.3.2 as less than 1.00%, the program average day of clearance is adjusted to 1 day. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: NMedicaid/ACHIP Combined Account checks to 3rd Party Providers by Conduent State Healthcare, LLC Social Service Program Benefits Payroll checks General Warrants (Vendor Payments) 7.2 The following shall develop the State's clearance patterns: The banks under contract with the Virginia Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessTreasury. The bank under contract with Conduent. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersGeneral warrants, checks cleared reports from the bankpayroll checks, social service payments, and reconciliation tapeschecks issued by the Fiscal Agent for Medical Assistance Services Program (CFDA #93.778) and the Children's Health Insurance Program (93.767). 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. 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: N/A No exceptions. See Section 7.13.0 The State shall also adjust each clearance pattern to reflect: N/ASee Section 7.13.0 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State shall develop separate clearance patterns for the Statewide Payroll and for each program and separate functions within specific programs listed in sections 4.2 and 4.3 (any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administration shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data utilized in the development of clearance patterns for comes from SABHRS (Statewide Accounting, checks cleared reports from Budget and Human Resource System). The System is administered by the bank, and reconciliation tapesSABHRS Financial Services Technology Bureau of the State Financial Services Division within the Department of Administration. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall develop separate clearance patterns for the Statewide Payroll and for each program and separate functions within specific programs listed in sections 4.2 and 4.3 (any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administration shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data utilized in the development of clearance patterns for comes from SABHRS (Statewide Accounting, checks cleared reports from Budget and Human Resource System). The System is is administered by the bank, and reconciliation tapesSABHRS Services Bureau of the Information Technology Services Division within the Department of Administration. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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 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: N/AAverage Clearance 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessNH State Treasury 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersFor 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, checks cleared reports from the bank, State shall use its accounting system data and reconciliation tapesbank account clearance data to determine an accurate clearance pattern of each program. (For 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: N/A NA The State shall also adjust each clearance pattern to reflect: N/ANA 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AAll the programs identified in Section 4.2. Where the reimbursable funding technique has been applied, the state voluntary waives recovery of any federal interest liability that may occur through use of this funding technique. 7.2 The following shall develop the State's clearance patterns: Department of EducationFinance, Division of Accounting Department of Transportation Technology and Development and the Governor's Information Office of Homeland Security the State Treasurer The Office of Management and Emergency PreparednessBudget 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe source of expenditure data is Delaware's FSF accounting system. Numerous expenditure reports and queries have been developed to support timing and amounts. Additionally, these expenditures are audited and included in annual SEFA report . These FSF reports detail the amount, length of time checks cleared reports from the bankand ACH payments take to clear in our financial system. Processing daily a bank supplied paid-item file which identifies checks paid, amount paid and reconciliation tapesdate paid. 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. 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: N/A No exceptions are made by Delaware The State shall also adjust each clearance pattern to reflect: N/ADelaware does not adjust clearance pattern. We use a very detailed process of tracking expenditures upon confirmation when then request reimbursement according to our approved TSA clearance patterns. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFunctional Payment. The Commonwealth shall develop separate clearance patterns for each agency or instrumentality listed in Section 5.1 of this 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: Department The Finance and Administration Cabinet shall develop all of Education, Department of Transportation and Development and the GovernorCommonwealth's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe 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, checks cleared reports the source for presentment dates shall be data obtained indirectly from the bank, and reconciliation tapesCommonwealth's bank through the State Treasurer. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each For all clearance patternpatterns 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, for a period of at least three monthsin 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: N/A Not Applicable The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/ANot Applicable 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The Bank shall develop clearance patterns for Vendor and Development and the Governor's Office of Homeland Security and Emergency PreparednessPayroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe 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. 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: N/A Not Applicable The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AEach program or program component as required in section 6.3.2 under the agreement. 7.2 The following shall develop the State's clearance patterns: Department Each entity which receives Federal funds shall be responsible for the development of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparednessits own clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesState accounting records. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/Afor the payroll portion of the administrative costs listed in Sections 4.2 and 4.3 of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administrative Services shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns in accordance with 31 CFR 205.22. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Actual warrant redemption from the bank, and reconciliation tapesrecords of the State Treasurer as well as 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. 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: N/A NONE The State shall also adjust each clearance pattern to reflect: N/ANONE 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State shall use program specific methodology to develop program specific clearance patterns for all programs. 7.2 The following shall develop the State's clearance patterns: The Division of Information Technology within the Department of Education, Department Administration shall provide all the data used in the determination of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparednessappropriate clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe State's central and subsidiary accounting systems which contain the "check date" data, checks cleared reports and the State's depository banks, at which demand deposit (checking) accounts are maintained, from which federal grant programs disbursements are made, will provide a computer tape of disbursements from the bank, and reconciliation tapesState'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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in 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: N/AAll clearance patterns, except for the Unemployment Insurance Program (CFDA 17.225) and WYDOT (CFDA 20.205, 20.608) are developed by the State of Wyoming's State Auditor's Office. The State chose to determine an overall State clearance pattern based on all warrants issued for the Fiscal Year 2019 (July 1, 2018-June 30, 2019). Data was extracted by the SAO Tech Division to pull information from the Paid Checks Table for the fiscal year as outlined above. The extracted data included all instruments of issuance, Regular Warrants (AD), payroll warrants (PY), Manual Warrants (MD) and electronic funds transfers (EFT). The result was a statewide clearance pattern of four (4) days. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessThe State will develop its own clearance patterns in compliance with 31 CFR 205.22 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The data used to develop clearance patterns will come from the bank, State payment and reconciliation tapesaccounting records. 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/ANone. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AAll programs with the exception of programs listed in Sections 7.1.1, 7.1.2, 7.1.3, 7.1.4, and 7.1.5. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and Each State Agency will be responsible for developing the Governor's Office of Homeland Security and Emergency Preparednessclearance pattern(s) for its applicable federal programs. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersDepartmental accounting files, checks cleared reports from the bankpayment document dates, disbursement issue dates, disbursement redemption dates, and reconciliation tapesany other relevant data needed. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/Ana 7.8 Each of the State's clearance patterns is calculated in 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: N/AThere are currently no program components listed in Section 7.1. 7.2 The following shall develop the State's clearance patterns: Tennessee Department of Education, Treasury Tennessee Department of Transportation Finance and Development and the Governor's Office of Homeland Security and Emergency PreparednessAdministration 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes.State Treasurer's Accounts Reconciliation Package (ARP) system State's central accounting system (Edison) 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. 7.4.1 Under this agreement, in Section 7.4, "99% of the funds disbursed, from issuance to clearance" refers to and is equal to "99% of the funds clearing and net of cancellations". The tracking period shall be at least three consecutive months. 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.5.1 In Section 7.5 (1) "the date the check was released" refers to and is equal to "the date the check was issued". 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANot applicable. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/APrograms or Program Components identified in Section 4.2 and 6.3.2 of this Agreement provided a clearance pattern is required for either drawdown or interest calculation purposes in accordance with the funding technique selected. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's The Office of Homeland Security and Emergency Preparednessthe Missouri State Treasurer. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from disbursement data provided by each applicable entity to the bank, and reconciliation tapesOffice of the Missouri 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/ANone. 7.8 Each of the State's clearance patterns is calculated in 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: N/AProgram and Payroll 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorWV State Treasurer's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes.Actual Bank Data 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. 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: N/A No Exceptions The State shall also adjust each clearance pattern to reflect: N/ANo Adjustments 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State may develop a separate clearance pattern for an individual program, or develop a composite clearance pattern for a logical group of programs, or develop a clearance pattern on another basis acceptable to the Bureau of the Fiscal Service. The State shall ensure that a clearance pattern accurately represents the flow of Federal funds and that a clearance pattern reflects seasonal or other periodic variations in clearance activity. 7.2 The following shall develop the State's clearance patterns: Department The State will develop the State's clearance patterns. The records of Education, Department the Office of Transportation Management and Development Enterprise Services will serve as the system of record for sampling data. Supplemental data from the Oklahoma State Treasurer and the Governor's Office of Homeland Security and Emergency Preparednessrecipient agency will be utilized. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersDevelopment of clearance patterns will be based on data from at least 3 consecutive months; based on 100 percent of the data, checks cleared reports from the bankor on a sample size sufficient to ensure, at a minimum, a 96 percent confidence interval for a plus or minus .25% weighted-day level of precision; and reconciliation tapestruncated at no less than 99 percent of disbursement dollars. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall use program specific methodology to develop program specific clearance patterns for all programs. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessAdministrative Services-State Accounting Division 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe source of information used in developing the clearance patterns was the Nebraska Information System (NIS, checks cleared reports from or its successor system). Actual Activity In developing the bankbase clearance pattern, and reconciliation tapesthe State Department of Administrative Services, State Accounting Division tested all State warrant clearance activity (100%) that occurred during the twelve month period beginning July 1, 2014, through June 30, 2015, excluding only the Department of Revenue State tax refund warrants. That base clearance pattern will then be used to develop weighted clearance patterns for all average clearance pattern programs. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANA 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall use program specific methodology to develop program specific clearance patterns for all programs. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessAdministrative Services-State Accounting Division 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe source of information used in developing the clearance patterns was the Nebraska Information System (NIS, checks cleared reports from or its successor system). In developing the bankbase clearance pattern, and reconciliation tapesthe State Department of Administrative Services, State Accounting Division tested all State warrant clearance activity (100%) that occurred during the period beginning July 1, 2019, through June 30, 2020, excluding only the Department of Revenue State tax refund warrants. That base clearance pattern will then be used to develop weighted clearance patterns for all average clearance pattern programs. 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANA 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe District developed check clearance patterns for controlled disbursement types (run IDs) in the District's check writing and cash reconciliation systems. The disbursement types applicable for this Agreement are: 23-Medicaid (Provider Payments) 73-SOAR Checks NPS 81-Payroll Group 1 82-Payroll Group 2 The check clearance patterns are produced without regard to funding type. The District is responsible for the development and appropriate application of these check clearance patterns for the programs covered by the Agreement. 7.2 The following shall develop the State's clearance patterns: Department of EducationFor each disbursement type, Department of Transportation and Development and the GovernorDistrict's Office of Homeland Security Finance and Emergency PreparednessTreasury has analyzed about 50% of the funds disbursed from issuance via checks to the clearance for a period of at least three months. Almost all payments from the District of Columbia are done by ACH or instant wires, where clearances are completed in a matter of hours or minutes. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data provided for testing the check clearance patterns are provided through the District's financial management system, checks cleared reports from the bankSystem of Accounting and Reporting (SOAR) and its Accounts Reconcillation Processing (ARP) component. The ARP component, controlled by the Office of the Chief Information Officer, contains the clearance pattern information required by this agreement. All Payroll is paid via direct deposit and reconciliation tapestherefore results in a zero day clearance time. 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/AAny systemic problems, such as what occurred with the mail distribution during the Anthrax crisis. Adjustments in the clearance patterns will be made to smooth out the resulting anomalies. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/ASeparate 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 Education, Department State of Transportation and Development and Colorado utilizing the Governor's Office of Homeland Security and Emergency Preparednessmethodology 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: Check registers, checks cleared reports from the bank, and reconciliation tapesColorado 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANone. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/Afor the payroll portion of the administrative costs listed in Sections 4.2 and 4.3 of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administrative Services shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns in accordance with 31 CFR 205.22. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Actual warrant redemption from the bank, and reconciliation tapesrecords of the State Treasurer as well as 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. 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: N/A NONE The State shall also adjust each clearance pattern to reflect: N/ANONE 7.8 Each of the State's clearance patterns is calculated in Calendar 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: NMedicaid/ACHIP Combined Account checks to 3rd Party Providers by Conduent State Healthcare, LLC Social Service Program Benefits Payroll checks General Warrants (Vendor Payments) 7.2 The following shall develop the State's clearance patterns: The banks under contract with the Virginia Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessTreasury. The bank under contract with Conduent. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersGeneral warrants, checks cleared reports from the bankpayroll checks, social service payments, and reconciliation tapeschecks issued by the Fiscal Agent for Medical Assistance Services Program (CFDA #93.778) and the Children's Health Insurance Program (93.767). 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. 7.4.1 For the general warrants, social services, and payroll accounts, the respective banks track all checks issued until payment, or until payment is stopped on the individual checks because of theft, loss, or other reasons. In all cases, the Commonwealth's banks produce check clearance patterns for over 99% of the checks issued. For all checks paid during each month, the program calculates the number of business and/or calendar days outstanding by subtracting the issue date from the paid date, and then calculates a dollar weighted average number of days that the checks paid during the month were outstanding. 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.6.1 For CMIA interest calculations, the Virginia Department of Accounts (DOA) prepares an annualized dollar weighted average number of calendar days for the most recently completed SFY that cleared checks were outstanding each month in the general warrant, and payroll accounts. 7.6.2 Where functional or other clearance pattern data is available that is suitable for estimating the programmatic flow of federal funds, DOA shall estimate a program's clearance pattern based upon the expenditure characteristics of the respective program. In estimating a program's clearance pattern for interest calculations, DOA shall use program expenditure data from not less than 3 months, and not more than 12 months, of the fiscal year, including, at a minimum, the last three months of the fiscal year. The State agencies responsible for the respective programs shall provide the required program expenditure data to DOA upon request. For example, if it is determined that a major federal assistance program covered by the Agreement has $1 million in expenditures in the following proportions: 20% payroll by check, 15% payroll by direct deposit, 5% ATA payments to other State agencies, 50% EDI payments and 10% general warrants, then the program's overall clearance pattern would be estimated as follows: Type of Program Expenditure $ Amount Days Dollar Weighted Payroll payments by check $ 200,000 4.61 0.922 Payroll direct deposits $ 150,000 0.00 0.000 ATA payments $ 50,000 0.00 0.000 EDI payments $ 500,000 0.00 0.000 General warrants $ 100,000 10.24 1.024 Total/Overall Clearance Pattern $ 1,000,000 N/A 1.946 Days 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: N/A No exceptions. See Section 7.7.1. The State shall also adjust each clearance pattern to reflect: N/A: 7.7.1 The State adjusts each program's check clearance pattern(s) to reflect, where applicable, the dollar-weighted proportion of funds paid out by either wire transfer or ACH; for example, Electronic Data Interchange (EDI) payments and payroll direct deposits. The State shall also adjust each program's check clearance pattern to reflect, where applicable, simultaneous internal transfer payments, such as book entry transfers, or internal electronic transfers (ATA's). 7.8 Each of the State's clearance patterns is calculated in Calendar calendar days. 7.9 An authorized State official shall certify that each 7.8.1 Each of the State's monthly check clearance patterns is calculated in business and/or calendar days as applicable. Calendar day patterns are used for the calculation of interest. When necessary, available and appropriate, business day clearance patterns may be used for estimating the timing of drawdowns instead of calendar days. When necessary and appropriate, monthly business day check clearance patterns may be converted to calendar days by multiplying the average business day clearance pattern developed for the respective months by the State accurately corresponds to the clearance activity a factor 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 yearsapproximately 1. 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: N/AThe State does not use funding techniques which require clearance patterns. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessThe State does not use funding techniques which require clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe State does not use funding techniques which require clearance patterns. 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: N/A The State does not use funding techniques which require clearance patterns. The State shall also adjust each clearance pattern to reflect: N/AThe State does not use funding techniques which require clearance patterns. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AEach program or program component as required in section 6.3.2 under the agreement. 7.2 The following shall develop the State's clearance patterns: Department Each entity which receives Federal funds shall be responsible for the development of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparednessits own clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesState accounting records. 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.: 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/ABasis for Development Functional Payment - Currently the State has achieved a 99.9% payroll direct deposit participation rate. Program Specific - The State will use actual activity as the methodology to develop a separate clearance pattern for the programs utilizing Estimated Clearance funding technique and Composite Clearance. Currently, the State uses either the pre-issuance or post- issuance methodology for its programs. 7.2 The following shall develop the State's clearance patterns: The Department of EducationAdministration, Department of Transportation and Development and the Governor's Office of Homeland Security Accounts and Emergency PreparednessReports 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The State shall use data contained in the bank, Statewide Management Accounting and reconciliation tapesReporting Tool (SMART) to develop the warrant clearance pattern for those programs where a clearance pattern is needed. The information contained in SMART records the check issue date and when the check was redeemed by the State Treasurer's Office. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo adjustments necessary. 7.8 Each of the State's clearance patterns is calculated in 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: N/ACFDA Program Name 10.553 School Breakfast Program 10.555 National School Lunch Program 10.557 Special Supplemental Nutrition Program for Women, Infants, and Children 10.558 Child and Adult Care Food Program 10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program 84.010 Title 1 Grants to Local Educational Agencies 84.027 Special Education- Grants to States (IDEA, Part B) 93.268 Immunization Grants 93.558 Temporary Assistance for Needy Families 93.563 Child Support Enforcement 93.575 Child Care and Development Block Grant 93.658 ▇▇▇▇▇▇ Care - Title IV-E 93.659 Adoption Assistance, Recovery Act Funded 93.667 Social Services Block Grant 93.767 Children's Health Insurance Program 93.778 Medical Assistance Program 97.036 Disaster Grants - Public Assistance (Presidentially Declared Disasters) 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The SCO will develop the clearance patterns for specified programs and Development and the Governor's Office of Homeland Security and Emergency Preparednessfunds. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe SCO's paid warrants files. 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. 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: N/A NONE The State shall also adjust each clearance pattern to reflect: N/AFor the clearance patterns that are more than one day, the State will adjust by one day each redemption pattern applied to the pre- issuance funded payment components for the programs listed in Section 7.1. Funds are paid out for program purposes by the bank one day earlier than the date stamped on the warrants by the STO. The number of redemption days calculated by the SCO is based on the issuance date of the warrant and the date stamped by the STO after the bank redeems the warrant. (The issuance date is the date the warrants are mailed, released or otherwise made available to the recipients.) This adjustment will reflect accurately when funds are paid out for program purposes. 7.8 Each of the State's clearance patterns is calculated in 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: N/AEstimated clearance for vendors, beneficiaries, administration and payroll 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessAgencies administering grants 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersBank statements, checks cleared reports from the bank, and debit reconciliation tapes.reports 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. 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: N/A Not applicable The State shall also adjust each clearance pattern to reflect: NNone/ANA 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/Aall programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: Department of Education, Transportation Department of Transportation and Development and the Governor's Office Education Department of Homeland Security and Emergency PreparednessHuman Services Department of Workforce Services 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesTreasurer 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. 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: N/A : A. The State shall also adjust each clearance pattern to reflect: N/A: N. A. 7.8 Each of the State's clearance patterns is calculated in 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: N/AFunctional payments for program expenses, payroll and administrative costs. 7.2 The following shall develop the State's clearance patterns: American Samoa Government Treasury Department of Education, Department of Transportation and Development and will develop the Governor's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersIntegrated Financial Accounting Software, checks cleared reports from the bankZion Bank, Territorial Bank of American Samoa, and reconciliation tapes.ANZ American Samoa 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. 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: N/A When developing each pattern, the Territory shall track at least 99% of the funds disbursed, from the issuance to clearance, for a period of at least three months. The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFor each program or logical group of programs subject to the provisions of Subpart A of 31 CFR 205, except for those programs that utilize Electronic Benefit Transfers (EBT). The state will also develop functional clearance patterns for those programs where applicable. 7.2 The following shall develop the State's clearance patterns: Department State agencies will calculate clearance patterns for period 1 (from deposit date to issuance date, where issuance means the actual release of Education, Department payments). The Comptroller of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessPublic Accounts will calculate clearance patterns for period 2 from issuance to clearance. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersAn agency's internal accounting system, checks cleared reports from the bankUniform Statewide Accounting System, the Treasury Warrants System, the Uniform Statewide Payroll/Personnel System and reconciliation tapesthe Standardized Payroll/Personnel Reporting 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: a. Functional Payment: N/APayroll - State Central Payroll Checks b. The programs as described in section 4.2 that meet or exceed the threshold 7.2 The following shall develop the State's clearance patterns: Department of Education, Budget and Finance Department of Transportation Accounting and Development and the Governor's Office of Homeland Security and Emergency PreparednessGeneral Services, Information & Communication Services Division 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: State's central Financial Accounting and Management Information System (FAMIS), Check registersReconciliation System, checks cleared reports from Check Writing System and the bank, and reconciliation tapesDepartment of Education's Central 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/AThe State shall adjust each clearance pattern to reflect actual date the checks cleared the State's bank account for other than Department of Education checks. To arrive at the date the check was debited from the State's account (7.5, Item 2) the average day of clearance must be reduced by 1.45 days. The State computer files show the cashed date as the date the checks were returned to the State Treasury by the drawee bank. However, the checks were redeemed and charged to the State's bank account by the drawee bank on the prior banking day. Accordingly, the average day of clearance is overstated by approximately 1.45 calendar days. The "rounded average day of clearance" in Exhibit II is adjusted to reflect the day the checks were cashed at the drawee bank and charged to the State's bank account. The following is the computation of the 1.45 days factor: State of Hawaii Agencies (Other than Department of Education) Clearance Pattern Adjustment: Monday; Tuesday; 1 day Tuesday; Wednesday; 1 day Wednesday; Thursday; 1 day Thursday; Friday; 1 day Friday; Monday; 3 days Check Cashed by Bank; Recorded Cashed by State; Difference-Cashed & Recorded Total difference = 7 days Computation to determine number of days to be adjusted: 39 weeks x (7/5) = 54.60 (Holiday Factor) 13 weeks x (8/5) = 20.80 52 weeks = 75.40 / 52 weeks = 1.45 days 1.45 days will be reduced from the State-calculated clearance pattern to arrive at the clearance pattern to be used by the State in Exhibit II. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/ABasis for Development Functional Payment - Currently the State has achieved a 99.9% payroll direct deposit participation rate. Program Specific - The State will use actual activity as the methodology to develop a separate clearance pattern for the programs utilizing Estimated Clearance funding technique and Composite Clearance. Currently, the State uses either the pre-issuance or post-issuance methodology for its programs. 7.2 The following shall develop the State's clearance patterns: The Department of EducationAdministration, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparednessthe Chief Financial Officer. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The State shall use data contained in the bank, Statewide Management Accounting and reconciliation tapesReporting Tool (SMART) to develop the warrant clearance pattern for those programs where a clearance pattern is needed. The information contained in SMART records the check issue date and when the check was redeemed by the State Treasurer's Office. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo adjustments necessary. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall develop separate clearance patterns for the Statewide Payroll and each program and independent functions within specific programs listed in sections 4.2 and 4.3 (any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administration shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data utilized in the development of clearance patterns comes from SABHRS (Statewide Accounting, checks cleared reports from the bankBudget, and reconciliation tapesHuman Resource System). The System is administered by the SABHRS Financial Services Technology Bureau of the State Financial Services Division within the Department of Administration. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe programs as described in section 4.2 that meet or exceed the threshold. 7.2 The following shall develop the State's clearance patterns: Department of Education, Child Safety Department of Health Services Department of Economic Security Department of Transportation and Development and the Governor's Office Department of Homeland Security and Emergency PreparednessEducation 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The average clearance days are derived from the bankverification of clearance patterns done in April 2019 (84.126 Rehabilitation Services -- Vocational Rehabilitation Grants to States), April 2021 (93.558 Temporary Assistance for Needy Families) and reconciliation tapesJune 2021 (93.658 ▇▇▇▇▇▇ Care-Title IV-E and 93.659 Adoption Assistance) using an AFIS report and sampling transactions. The State has documented that over 99% of all current payrolls are paid by direct deposit. Bank of America is paid via wire on Wednesday of pay week for payroll. Therefore, when applying funding techniques that require Federal funds to be deposited in a State account on the average clearance day of payroll, Wednesday of the pay week has been established as the date to receive Federal funds. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo additional adjustments. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe programs as described in section 4.2 that meet or exceed the threshold. 7.2 The following shall develop the State's clearance patterns: Department of Education, Child Safety Department of Health Services Department of Economic Security Department of Transportation and Development and the Governor's Office Department of Homeland Security and Emergency PreparednessEducation 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The average clearance days are derived from the bankverification of clearance patterns done in April 2019 (84.126 Rehabilitation Services -- Vocational Rehabilitation Grants to States), June 2016 (93.558 Temporary Assistance for Needy Families) and reconciliation tapesOctober 2016 (93.658 ▇▇▇▇▇▇ Care-Title IV-E and 93.659 Adoption Assistance) using an AFIS report and sampling transactions. The State has documented that over 99% of all current payrolls are paid by direct deposit. Bank of America is paid via wire on Wednesday of pay week for payroll. Therefore, when applying funding techniques that require Federal funds to be deposited in a State account on the average clearance day of payroll, Wednesday of the pay week has been established as the date to receive Federal funds. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo additional adjustments. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFunctional payments for Benefit payments, vendor payments, administrative and indirect costs. 7.2 The following shall develop the State's clearance patterns: Guam Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessAdministration 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapes.Budget & Accounting Information System (BACIS)/AS400 Platform 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: NMedicaid/ACHIP Combined Account checks to 3rd Party Providers by Conduent State Healthcare, LLC Social Service Program Benefits Payroll checks General Warrants (Vendor Payments) 7.2 The following shall develop the State's clearance patterns: The banks under contract with the Virginia Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessTreasury. The bank under contract with Conduent. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersGeneral warrants, checks cleared reports from the bankpayroll checks, social service payments, and reconciliation tapeschecks issued by the Fiscal Agent for Medical Assistance Services Program (CFDA #93.778) and the Children's Health Insurance Program (93.767). 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. 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: N/A No exceptions. See Section 7.13.0 The State shall also adjust each clearance pattern to reflect: N/A: 7.8 Each of the State's clearance patterns is calculated in 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: N/AEach program listed in Section 4.2 and 4.3 of this agreement 7.2 The following shall develop the State's clearance patterns: For the average clearance patterns that are developed by the State, the Department of EducationFinancial Services, Office of Information Technology, is responsible for the development of the average clearance patterns. The State agencies are responsible for providing accurate selection criteria related to program expenditures to ensure proper clearance pattern computation by the Department of Transportation and Development and the Governor's Financial Services, Office of Homeland Security and Emergency PreparednessInformation Technology. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The sources of data the bank, State shall use when developing its average clearance patterns are State warrants and reconciliation tapesEFT/Direct Deposit transactions issued by the Division of Accounting and Auditing and recorded in the FLAIR 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. 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: N/A NA The State shall also adjust each clearance pattern to reflect: N/AThe State shall adjust each average clearance pattern to reflect, when applicable, if Federal funds are requested according to Exhibit I to be received into the State's account 1) after the day that the vouchers are submitted to the Division of Accounting and Auditing for voucher audit for non-payroll warrants and EFT transactions or 2) after the Voucher Audit date per the published payroll schedule for warrants and EFT transactions, thereby reducing the average clearance pattern to reflect the amount of time the Federal funds were held. The State agencies will also be responsible for documenting any instances that the Federal funds are received prior to the day vouchers are submitted and/or prior to the voucher audit date. The State shall adjust the average clearance pattern appropriately to reflect the additional time that the State held the Federal funds. The State agencies shall be required to maintain records of the amount and the number of days Federal funds are expected to be received, based upon requests in accordance with Exhibit I, after the submission of the warrant and EFT transaction request vouchers and the amount of the applicable draw for documentation of the reduction of the clearance pattern for that draw. 7.8 Each of the State's clearance patterns is calculated in 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: N/APayroll Expenses, Contingent Expenses, and Direct Benefits. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Treasurer's Office of Homeland Security Cash Management, Information Technology, Accounting and Emergency PreparednessFinancial Reporting divisions have developed the State's clearance patterns in section 7.1. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Financial information from the bankSouth Carolina Enterprise Information System (SCEIS) and actual bank data shall be used for payroll, contingent and reconciliation tapesdirect benefit expenditures. The South Carolina Department of Employment and Workforce shall provide information/develop clearance patterns for the Unemployment Insurance programs. The South Carolina Department of Health and Human Services shall provide information/develop clearance patterns for the Medical Assistance Program, (CFDA 93.778). The state excludes transfers between funds (Journal Vouchers and Cash Transfers) and transfers between agencies in the same fund (Inter Departmental Transfers). These transfers occur on the same day. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFunctional payments for program expenses, and administrative costs (payroll included). 7.2 The following shall develop the State's clearance patterns: American Samoa Government Treasury Department of Education, Department of Transportation and Development and will develop the Governor's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersONESolution (Financial System), checks cleared reports from the bankZion Bank, and reconciliation tapes.Territorial Bank of American Samoa 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. 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: N/A When developing each pattern, the Territory shall track at least 99% of the funds disbursed, from the issuance to clearance, for a period of at least three months. The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in 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: N/Aall programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: Department of Education, Transportation Department of Transportation and Development and the Governor's Office Education Department of Homeland Security and Emergency PreparednessHuman 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: Check registers, checks cleared reports from the bank, and reconciliation tapesTreasurer 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. 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: N/A : A. The State shall also adjust each clearance pattern to reflect: N/A: N. A. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe District developed check clearance patterns for controlled disbursement types (run IDs) in the District's check writing and cash reconciliation systems. The disbursement types applicable for this Agreement are: 23-Medicaid (Provider Payments) 73-SOAR Checks NPS 81-Payroll Group 1 82-Payroll Group 2 The check clearance patterns are produced without regard to funding type. The District is responsible for the development and appropriate application of these check clearance patterns for the programs covered by the Agreement. 7.2 The following shall develop the State's clearance patterns: Department of EducationFor each disbursement type, Department of Transportation and Development and the GovernorDistrict's Office of Homeland Security Finance and Emergency PreparednessTreasury has analyzed about 50% of the funds disbursed from issuance via checks to the clearance for a period of at least three months. Almost all payments from the District of Columbia are done by ACH or instant wires, where clearances are completed in a matter of hours or minutes. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data provided for testing the check clearance patterns are provided through the District's financial management system, checks cleared reports from the bankSystem of Accounting and Reporting (SOAR) and its Accounts Reconciliation Processing (ARP) component. The ARP component, controlled by the Office of the Chief Information Officer, contains the clearance pattern information required by this agreement. Payroll is generally paid via direct deposit and reconciliation tapestherefore results in a zero day clearance time. 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/AAny systemic problems, such as delivery issues due to the pandemic, will result in adjustments. Adjustments in the clearance patterns will be made to smooth out the resulting anomalies. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AProgram specific 7.2 The following shall develop the State's clearance patterns: The Commonwealth of the Northern Mariana Islands Department of Education, Department of Transportation and Development and the Governor's Finance Office of Homeland Security and Emergency Preparednessthe Secretary 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, CNMI's Financial Management System and reconciliation tapes.bank statements 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. 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: N/A Not applicable The State shall also adjust each clearance pattern to reflect: N/ANot applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/Aall programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: State Highway and Transportation Department Department of Education, Education Department of Transportation and Development and the Governor's Office Human Services Department of Homeland Security and Emergency PreparednessWorkforce Services Department of Health 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesTreasurer 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. 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: N/A : A. The State shall also adjust each clearance pattern to reflect: N/A: N. A. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall develop clearance patterns for each program that uses a delay of draw by measuring the dollar-weighted number of days between the day expenditures are sent to Treasury for payment and the day the related checks clear. Each program is examined to determine the appropriation(s) supporting it (Federal financial assistance to the State is reappropriated by the legislature). The relevant appropriation(s), an integral element of the voucher transmittals (VTs) used by Commonwealth agencies to request payment, control(s) the selection of VTs for the check clearance research. All checks associated with the selected VTs during a fiscal year are examined. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The data is assembled by the State Treasurer and Development and forwarded to the Governor's Office of Homeland Security the Budget, Comptroller Operations, which creates and Emergency Preparednessruns the computer program that measures clearance activity and computes the clearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, : (1) electronic files provided by the State's financial institutions indicating the dates checks cleared reports from the bankcleared, and reconciliation tapes(2) electronic files provided by the State Treasurer indicating unique identifying numbers and the related check issuance dates. 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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/A 7.8 Each of the State's clearance patterns is calculated in 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: N/AAll the programs identified in Section 4.2. 7.2 The following shall develop the State's clearance patterns: Department of EducationFinance, Division of Accounting Department of Transportation Technology and Development and the Governor's Information Office of Homeland Security the State Treasurer The Office of Management and Emergency PreparednessBudget 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe source of expenditure data is Delaware's FSF accounting system. Numerous expenditure reports and queries have been developed to support timing and amounts. Additionally, these expenditures are audited and included in annual SEFA report. These FSF reports detail the amount, length of time checks cleared reports from the bankand ACH payments take to clear in our financial system. Processing daily a bank supplied paid- item file which identifies checks paid, amount paid and reconciliation tapesdate paid. 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. 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: N/A No exceptions are made by Delaware The State shall also adjust each clearance pattern to reflect: N/ADelaware does not adjust clearance pattern. We use a very detailed process of tracking expenditures upon confirmation when then request reimbursement according to our approved TSA clearance patterns. 7.8 Each of the State's clearance patterns is calculated in 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: NMedicaid/ACHIP Combined Account checks to 3rd Party Providers by Conduent (formerly Xerox Corporation) Social Service Program Benefits Payroll checks General Warrants (Vendor Payments) 7.2 The following shall develop the State's clearance patterns: The banks under contract with the Virginia Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessTreasury. The bank under contract with Conduent (formerly Xerox Corporation). 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersGeneral warrants, checks cleared reports from the bankpayroll checks, social service payments, and reconciliation tapeschecks issued by the Fiscal Agent for Medical Assistance Services Program (CFDA #93.778) and the Children's Health Insurance Program (93.767). 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. 7.4.1 For the general warrants, social services, and payroll accounts, the respective banks track all checks issued until payment, or until payment is stopped on the individual checks because of theft, loss, or other reasons. In all cases, the Commonwealth's banks produce check clearance patterns for over 99% of the checks issued. For all checks paid during each month, the program calculates the number of business and/or calendar days outstanding by subtracting the issue date from the paid date, and then calculates a dollar weighted average number of days that the checks paid during the month were outstanding. 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.6.1 For CMIA interest calculations, the Virginia Department of Accounts (DOA) prepares an annualized dollar weighted average number of calendar days for the most recently completed SFY that cleared checks were outstanding each month in the general warrant, and payroll accounts. 7.6.2 Where functional or other clearance pattern data is available that is suitable for estimating the programmatic flow of federal funds, DOA shall estimate a program's clearance pattern based upon the expenditure characteristics of the respective program. In estimating a program's clearance pattern for interest calculations, DOA shall use program expenditure data from not less than 3 months, and not more than 12 months, of the fiscal year, including, at a minimum, the last three months of the fiscal year. The State agencies responsible for the respective programs shall provide the required program expenditure data to DOA upon request. For example, if it is determined that a major federal assistance program covered by the Agreement has $1 million in expenditures in the following proportions: 20% payroll by check, 15% payroll by direct deposit, 5% ATA payments to other State agencies, 50% EDI payments and 10% general warrants, then the program's overall clearance pattern would be estimated as follows: Type of Program Expenditure $ Amount Days Dollar Weighted Payroll payments by check $ 200,000 4.61 0.922 Payroll direct deposits $ 150,000 0.00 0.000 ATA payments $ 50,000 0.00 0.000 EDI payments $ 500,000 0.00 0.000 General warrants $ 100,000 10.24 1.024 Total/Overall Clearance Pattern $ 1,000,000 N/A 1.946 Days 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: N/A No exceptions. See Section 7.7.1. The State shall also adjust each clearance pattern to reflect: N/A: 7.7.1 The State adjusts each program's check clearance pattern(s) to reflect, where applicable, the dollar-weighted proportion of funds paid out by either wire transfer or ACH; for example, Electronic Data Interchange (EDI) payments and payroll direct deposits. The State shall also adjust each program's check clearance pattern to reflect, where applicable, simultaneous internal transfer payments, such as book entry transfers, or internal electronic transfers (ATA's). 7.8 Each of the State's clearance patterns is calculated in Calendar calendar days. 7.9 An authorized State official shall certify that each 7.8.1 Each of the State's monthly check clearance patterns is calculated in business and/or calendar days as applicable. Calendar day patterns are used for the calculation of interest. When necessary, available and appropriate, business day clearance patterns may be used for estimating the timing of drawdowns instead of calendar days. When necessary and appropriate, monthly business day check clearance patterns may be converted to calendar days by multiplying the average business day clearance pattern developed for the respective months by the State accurately corresponds to the clearance activity a factor 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 yearsapproximately 1. 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: N/ANot Applicable 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The Bank shall develop clearance patterns for Vendor and Development and the Governor's Office of Homeland Security and Emergency PreparednessPayroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe 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. 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: N/A Not Applicable The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N/ABasis for Development Functional Payment - Currently the State has achieved a 99.9% payroll direct deposit participation rate. Program Specific - The State will use actual activity as the methodology to develop a separate clearance pattern for the programs utilizing Estimated Clearance funding technique and Composite Clearance. Currently, the State uses either the pre-issuance or post-issuance methodology for its programs. 7.2 The following shall develop the State's clearance patterns: The Department of EducationAdministration, Department of Transportation and Development and the Governor's Office of Homeland Security Accounts and Emergency PreparednessReports 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The State shall use data contained in the bank, Statewide Management Accounting and reconciliation tapesReporting Tool (SMART) to develop the warrant clearance pattern for those programs where a clearance pattern is needed. The information contained in SMART records the check issue date and when the check was redeemed by the State Treasurer's Office. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo adjustments necessary. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/Aall programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: State Highway and Transportation Department Department of Education, Education Arkansas Rehabilitation Services Department of Transportation Health and Development and the Governor's Office Human Services Department of Homeland Security and Emergency PreparednessWorkforce Services 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesTreasurer 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. 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: N/A : A. The State shall also adjust each clearance pattern to reflect: N/A: N. A. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/A 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Controller's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The check activity data maintained within the bank, and reconciliation tapesState'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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/AFrom 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 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: N/Aall programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: Department of Education, Transportation Department of Transportation and Development and the Governor's Office Education Department of Homeland Security and Emergency PreparednessHuman Services Department of Workforce Services 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesTreasurer 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. 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: N/A : A. The State shall also adjust each clearance pattern to reflect: N/A: N. A. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: a. Functional Payment: N/APayroll - State Central Payroll Checks b. The programs as described in section 4.2 that meet or exceed the threshold 7.2 The following shall develop the State's clearance patterns: Department of Education, Budget and Finance Department of Transportation Accounting and Development and the Governor's Office of Homeland Security and Emergency PreparednessGeneral Services, Information & Communication Services Division 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: The State of Hawaii’s Financial Accounting and Management Information System (FAMIS), Check registers, checks cleared reports from the bankReconciliation System, and reconciliation tapesCheck Writing System. The Department of Education’s Central 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/A 7.8 Each of The State shall adjust each clearance pattern to reflect actual date the checks cleared the State's bank account for other than Department of Education checks. To arrive at the date the check was debited from the State's account (7.5, Item 2) the average day of clearance patterns is calculated in Calendar must be reduced by 1.45 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 computer files show the cashed date as the date the checks were returned to the State Treasury by the drawee bank. However, the checks were redeemed and charged to the State's bank account by the drawee bank on the prior banking day. Accordingly, the average day of clearance patterns is overstated by approximately 1.45 calendar days. The "rounded average day of clearance" in Exhibit II is adjusted to reflect the day the checks were cashed at least every five years. 7.10 the drawee bank and charged to the State's bank account. The following is the computation of the 1.45 days factor: 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.Hawaii Agencies (Other than Department of Education) Clearance Pattern Adjustment: Check Cashed by Bank; Recorded Cashed by State; Difference-Cashed & Recorded Monday; Tuesday; 1 day Tuesday; Wednesday; 1 day

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: N/APayroll Expenses, Contingent Expenses, and Direct Benefits. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Treasurer's Office of Homeland Security Cash Management, Information Technology, Accounting and Emergency PreparednessFinancial Reporting divisions have developed the State's clearance patterns in section 7.1. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Financial information from the bankSouth Carolina Enterprise Information System (SCEIS) and actual bank data shall be used for payroll, contingent and reconciliation tapesdirect benefit expenditures. The South Carolina Department of Employment and Workforce shall provide information/develop clearance patterns for the Unemployment Insurance programs. The South Carolina Department of Health and Human Services shall provide information/develop clearance patterns for the Medical Assistance Program, (CFDA 93.778). The state excludes transfers between funds (Journal Vouchers and Cash Transfers) and transfers between agencies in the same fund (Inter Departmental Transfers). These transfers occur on the same day. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: Nthe contingent checks issued to the Department of Health and Human Services to fund the checks/AEFTs issued to recipients on the Medicaid Bank Account. The State will pay one day of interest on the average daily cash balance of CFDA 93.778, as determined by SCEIS, for the one day that the contingent checks used to fund the Medicaid Bank Account are actually outstanding. The State will calculate the interest liability for CFDA 93.778 using the actual check clearing patterns of the checks issued on the Medicaid Bank Account. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFunctional payments for program expenses, and administrative costs (payroll included). 7.2 The following shall develop the State's clearance patterns: American Samoa Government Treasury Department of Education, Department of Transportation and Development and will develop the Governor's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersONESolution (Financial System), checks cleared reports from the bankZion Bank, Territorial Bank of American Samoa, and reconciliation tapes.ANZ American Samoa 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. 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: N/A When developing each pattern, the Territory shall track at least 99% of the funds disbursed, from the issuance to clearance, for a period of at least three months. The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in 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: N/AAll clearance patterns, except for the Unemployment Insurance Program (CFDA 17.225) and WYDOT (CFDA 20.205, 20.608) are developed by the State of Wyoming's State Auditor's Office. The State chose to determine an overall State clearance pattern based on all warrants issued for the Fiscal Year 2024 (July 1, 2023-June 30, 2024). Data was extracted by the SAO Tech Division to pull information from the Paid Checks Table for the fiscal year as outlined above. The extracted data included all instruments of issuance, Regular Warrants (AD), payroll warrants (PY), Manual Warrants (MD) and electronic funds transfers (EFT). The result was a statewide clearance pattern of five (5) days. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessThe State will develop its own clearance patterns in compliance with 31 CFR 205.22 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The data used to develop clearance patterns will come from the bank, State payment and reconciliation tapesaccounting records. 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. 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: N/A None. The State shall also adjust each clearance pattern to reflect: N/ANone. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/ACFDA Program Name 10.553 School Breakfast Program 10.555 National School Lunch Program 10.557 Special Supplemental Nutrition Program for Women, Infants, and Children 10.558 Child and Adult Care Food Program 10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program 84.010 Title 1 Grants to Local Educational Agencies 84.027 Special Education- Grants to States (IDEA, Part B) 84.126 Rehabilitation Services - Vocation Rehabilitation Grants to States 93.268 Immunization Grants 93.558 Temporary Assistance for Needy Families 93.563 Child Support Enforcement 93.575 Child Care and Development Block Grant 93.658 ▇▇▇▇▇▇ Care - Title IV-E 93.659 Adoption Assistance, Recovery Act Funded 93.667 Social Services Block Grant 93.767 Children's Health Insurance Program 93.778 Medical Assistance Program 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The SCO will develop the clearance patterns for specified programs and Development and the Governor's Office of Homeland Security and Emergency Preparednessfunds. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe SCO's paid warrants files. 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. 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: N/A NONE The State shall also adjust each clearance pattern to reflect: N/AFor the clearance patterns that are more than one day, the State will adjust by one day each redemption pattern applied to the pre- issuance funded payment components for the programs listed in Section 7.1. Funds are paid out for program purposes by the bank one day earlier than the date stamped on the warrants by the STO. The number of redemption days calculated by the SCO is based on the issuance date of the warrant and the date stamped by the STO after the bank redeems the warrant. (The issuance date is the date the warrants are mailed, released or otherwise made available to the recipients.) This adjustment will reflect accurately when funds are paid out for program purposes. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe programs as described in section 4.2 that meet or exceed the threshold. 7.2 The following shall develop the State's clearance patterns: Department of Education, Child Safety Department of Transportation and Development and the Governor's Office Economic Security Department of Homeland Security and Emergency PreparednessTransportation 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The average clearance days are derived from the bankverification of clearance patterns done in May 2020 (20.205 Highway Planning and Construction), April 2021 (93.558 Temporary Assistance for Needy Families) and reconciliation tapesJune 2021 (93.658 ▇▇▇▇▇▇ Care-Title IV-E and 93.659 Adoption Assistance) using an AFIS report and sampling transactions. The State has documented that over 99% of all current payrolls are paid by direct deposit. Bank of America is paid via wire on Wednesday of pay week for payroll. Therefore, when applying funding techniques that require Federal funds to be deposited in a State account on the average clearance day of payroll, Wednesday of the pay week has been established as the date to receive Federal funds. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo additional adjustments. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFunctional Payment. The Commonwealth shall develop separate clearance patterns for each agency or instrumentality listed in Section 5.1 of this 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: Department The Finance and Administration Cabinet shall develop all of Education, Department of Transportation and Development and the GovernorCommonwealth's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe 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, checks cleared reports the source for presentment dates shall be data obtained indirectly from the bank, and reconciliation tapesCommonwealth's bank through the State Treasurer. 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each For all clearance patternpatterns 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, for a period of at least three monthsin 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: N/A Not Applicable The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N: 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 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 made to vendors via ACH/Adirect deposit a separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of the program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Controller's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The check activity data maintained within the bank, and reconciliation tapesState'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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/AFrom 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 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: NFunctional Payment/ABank Account for vendor payment, payroll and other cost. 7.2 The following shall develop the State's clearance patterns: The Virgin Islands Department of Education, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessFinance. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, Financial Management System and reconciliation tapes.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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N/ANot Applicable 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The Bank shall develop clearance patterns for Vendor and Development and the Governor's Office of Homeland Security and Emergency PreparednessPayroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe 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. 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: N/A Not Applicable The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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.. Docusign Envelope ID: 2A334EB6-7BC9-4511-AA81-070E934307F3

CLEARANCE PATTERNS. 7.1 The State shall develop separate clearance patterns for each of the following: N/AThe programs as described in section 4.2 that meet or exceed the threshold. 7.2 The following shall develop the State's clearance patterns: Department of Education, Child Safety Department of Health Services Department of Economic Security Department of Transportation and Development and the Governor's Office Department of Homeland Security and Emergency PreparednessEducation 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The average clearance days are derived from the bankverification of clearance patterns done in May 2020 (20.205 Highway Planning and Construction ), April 2021 (93.558 Temporary Assistance for Needy Families) and reconciliation tapesJune 2021 (93.658 ▇▇▇▇▇▇ Care-Title IV-E and 93.659 Adoption Assistance) using an AFIS report and sampling transactions. The State has documented that over 99% of all current payrolls are paid by direct deposit. Bank of America is paid via wire on Wednesday of pay week for payroll. Therefore, when applying funding techniques that require Federal funds to be deposited in a State account on the average clearance day of payroll, Wednesday of the pay week has been established as the date to receive Federal funds. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo additional adjustments. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/ASeparate 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 Education, Department State of Transportation and Development and Colorado utilizing the Governor's Office of Homeland Security and Emergency Preparednessmethodology 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: Check registers, checks cleared reports from the bank, and reconciliation tapesColorado Operations Resource Engine (CORE). 7.4 The State shall use the following methodology when developing its clearance patterns: When developing each For all clearance patternpatterns 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, for a period of at least three monthsin 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANone. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall develop separate clearance patterns for the Statewide Payroll and for each program and separate functions within specific programs listed in sections 4.2 and 4.3 (any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administration shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data utilized in the development of clearance patterns for comes from SABHRS (Statewide Accounting, checks cleared reports from Budget and Human Resource System). The System is is administered by the bank, and reconciliation tapesSABHRS Services Bureau of the State Accounting Division within the Department of Administration. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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 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: N: 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 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 made to vendors via ACH/Adirect deposit a separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of the program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Controller's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The check activity data maintained within the bank, and reconciliation tapesState'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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/AFrom 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 Calendar 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: N: 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 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 made to vendors via ACH/Adirect deposit a separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of the program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Controller's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The check activity data maintained within the bank, and reconciliation tapesState'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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/AFrom 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 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: N/AAll the programs identified in Section 4.2. Where the reimbursable funding technique has been applied, the state voluntary waives recovery of any federal interest liability that may occur through use of this funding technique. 7.2 The following shall develop the State's clearance patterns: Department of EducationFinance, Division of Accounting Department of Transportation Technology and Development and the Governor's Information Office of Homeland Security the State Treasurer The Office of Management and Emergency PreparednessBudget 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe source of expenditure data is Delaware's FSF accounting system. Numerous expenditure reports and queries have been developed to support timing and amounts. Additionally, these expenditures are audited and included in annual SEFA report. These FSF reports detail the amount, length of time checks cleared reports from the bankand ACH payments take to clear in our financial system. Processing daily a bank supplied paid- item file which identifies checks paid, amount paid and reconciliation tapesdate paid. 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. 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: N/A No exceptions are made by Delaware The State shall also adjust each clearance pattern to reflect: N/ADelaware does not adjust clearance pattern. We use a very detailed process of tracking expenditures upon confirmation when then request reimbursement according to our approved TSA clearance patterns. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe programs as described in section 4.2 that meet or exceed the threshold. 7.2 The following shall develop the State's clearance patterns: Department of Education, Child Safety Department of Health Services Department of Economic Security Department of Transportation and Development and the Governor's Office Department of Homeland Security and Emergency PreparednessEducation 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports The average clearance days are derived from the bankverification of clearance patterns done in April 2015 (84.126 Rehabilitation Services -- Vocational Rehabilitation Grants to States), June 2016 (93.558 Temporary Assistance for Needy Families) and reconciliation tapesOctober 2016 (93.658 ▇▇▇▇▇▇ Care-Title IV-E and 93.659 Adoption Assistance) using an AFIS report and sampling transactions. The State has documented that over 99% of all current payrolls are paid by direct deposit. Bank of America is paid via wire on Wednesday of pay week for payroll. Therefore, when applying funding techniques that require Federal funds to be deposited in a State account on the average clearance day of payroll, Wednesday of the pay week has been established as the date to receive Federal funds. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo additional adjustments. 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFor each program or logical group of programs subject to the provisions of Subpart A of 31 CFR 205, except for those programs that utilize Electronic Benefit Transfers (EBT). The State will also develop functional clearance patterns for those programs where applicable. 7.2 The following shall develop the State's clearance patterns: Department DocuSign Envelope ID: 841D0F37-ECA6-45BD-AF3E-EB2AE0DFC6C5 State agencies will calculate clearance patterns for period 1 (from deposit date to issuance date, where issuance means the actual release of Education, Department payments). The Comptroller of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessPublic Accounts will calculate clearance patterns for period 2 from issuance to clearance. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersAn agency's internal accounting system, checks cleared reports from the bankUniform Statewide Accounting System, the Treasury Warrants System, the Uniform Statewide Payroll/Personnel System and reconciliation tapesthe Standardized Payroll/Personnel Reporting 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N: 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 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 made to vendors via ACH/Adirect deposit a separate dollar weighted average clearance pattern will be developed. All non-payroll transactions of the program, or program component, will be included in the development of the pattern. 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation and Development and the GovernorThe State Controller's Office of Homeland Security and Emergency PreparednessOffice 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from The check activity data maintained within the bank, and reconciliation tapesState'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. 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: N/A The State shall also adjust each clearance pattern to reflect: N/AFrom 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 Calendar 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: N/ANot Applicable 7.2 The following shall develop the State's clearance patterns: Department of Education, Department of Transportation The Bank shall develop clearance patterns for Vendor and Development and the Governor's Office of Homeland Security and Emergency PreparednessPayroll accounts. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesThe 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. 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: N/A DocuSign Envelope ID: E1334640-5FCB-4711-8B1D-E406BB911891 Not Applicable The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N/AFor each program or logical group of programs subject to the provisions of Subpart A of 31 CFR 205, except for those programs that utilize Electronic Benefit Transfers (EBT). The State will also develop functional clearance patterns for those programs where applicable. 7.2 The following shall develop the State's clearance patterns: Department State agencies will calculate clearance patterns for period 1 (from deposit date to issuance date, where issuance means the actual release of Education, Department payments). The Comptroller of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessPublic Accounts will calculate clearance patterns for period 2 from issuance to clearance. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersAn agency's internal accounting system, checks cleared reports from the bankUniform Statewide Accounting System, the Treasury Warrants System, the Uniform Statewide Payroll/Personnel System and reconciliation tapesthe Standardized Payroll/Personnel Reporting 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AFor each program or logical group of programs subject to the provisions of Subpart A of 31 CFR 205, except for those programs that utilize Electronic Benefit Transfers (EBT). The State will also develop functional clearance patterns for those programs where applicable. 7.2 The following shall develop the State's clearance patterns: Department DocuSign Envelope ID: C9941766-1D84-47D2-A38B-4771733DBDED State agencies will calculate clearance patterns for period 1 (from deposit date to issuance date, where issuance means the actual release of Education, Department payments). The Comptroller of Transportation and Development and the Governor's Office of Homeland Security and Emergency PreparednessPublic Accounts will calculate clearance patterns for period 2 from issuance to clearance. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersAn agency's internal accounting system, checks cleared reports from the bankUniform Statewide Accounting System, the Treasury Warrants System, and reconciliation tapesthe Standardized Payroll/Personnel Reporting 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. 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: N/A None The State shall also adjust each clearance pattern to reflect: N/ANot Applicable 7.8 Each of the State's clearance patterns is calculated in 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: N/AFunctional payments for program expenses, payroll and administrative costs. 7.2 The following shall develop the State's clearance patterns: American Samoa Government Treasury Department of Education, Department of Transportation and Development and will develop the Governor's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersIntegrated Financial Accounting Software, checks cleared reports from the bankBank of Hawaii, Zion Bank, Territorial Bank of American Samoa, and reconciliation tapes.ANZ American Samoa 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. 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: N/A When developing each pattern, the Territory shall track at least 99% of the funds disbursed, from the issuance to clearance, for a period of at least three months. The State shall also adjust each clearance pattern to reflect: N/ANone 7.8 Each of the State's clearance patterns is calculated in Calendar 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: N/AThe State shall develop separate clearance patterns for the Statewide Payroll and for each program and separate functions within specific programs listed in sections 4.2 and 4.3 (any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: The Department of Education, Department of Transportation and Development and Administration shall develop the GovernorState's Office of Homeland Security and Emergency Preparednessclearance patterns. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registersThe data utilized in the development of clearance patterns for comes from SABHRS (Statewide Accounting, checks cleared reports from Budget and Human Resource System). The System is administered by the bank, and reconciliation tapesSABHRS Services Bureau of the State Accounting Division within the Department of Administration. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo exceptions. 7.8 Each of the State's clearance patterns is calculated in Calendar 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 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: N/Aall programs listed in Sections 4.2, 4.3 and 4.4 (except any interest exempted program) of this Agreement. 7.2 The following shall develop the State's clearance patterns: Department of Education, Transportation Department of Transportation and Development and the Governor's Office Education Department of Homeland Security and Human Services Department of Workforce Services Department of Health Department of Emergency PreparednessManagement 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports from the bank, and reconciliation tapesTreasurer 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. 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: N/A : A. The State shall also adjust each clearance pattern to reflect: N/A: N. A. 7.8 Each of the State's clearance patterns is calculated in 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: N/AThe State shall include the results of the clearance pattern process for programs where the timing of drawdowns is based on clearance patterns. Check clearance patterns are developed for situations in which state warrants are issued for the covered programs listed in section 4.2, including payments to beneficiaries, vendors providing services, payroll, and non-payroll administrative costs. We elected to use the average clearance method rather than the estimated clearance method since it would be more cost-effective and efficient for the State. 7.2 The following shall develop the State's clearance patterns: The State of Utah Department of EducationGovernment Operations Division of Finance shall develop the State's clearance patterns, Department of Transportation and Development and the Governor's Office of Homeland Security and Emergency Preparednesscalculating them at least every five years. 7.3 The sources of data the State shall use when developing its clearance patterns are as follows: Check registers, checks cleared reports Warrant issuance data is extracted from the bank, and reconciliation tapesState's general accounting systems. Clearance dates are provided to the State by the State's warrant processing banks. 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. 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: N/A No exceptions. The State shall also adjust each clearance pattern to reflect: N/ANo adjustments. 7.8 Each of the State's clearance patterns is calculated in Calendar 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.