state fiscal year close all most some of what county accountants need to know about the joy that...
TRANSCRIPT
![Page 1: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/1.jpg)
State Fiscal Year Close
All Most Some of What County Accountants Need to Know About the Joy That Happens Every July
Presented by Lennie Bottorff2015 County Accounting Conference
Colorado Springs, CO May 13-15, 2015
![Page 2: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/2.jpg)
State Fiscal Year Close
• Gain understanding of where the money comes from (The Long Bill Explored)• Provide a high-level view of the close-out procedures • Share ideas on using monthly allocation tracking reports to “predict” outcomes
Objectives:
![Page 3: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/3.jpg)
3
Where Does the Money Come From?
• The Long Appropriation Bill• Supplemental Appropriation Bills•Other Bills carrying Appropriation Adjustments• Legislative Authority
![Page 4: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/4.jpg)
4
Where Does the Money Come From?
The Long Appropriation Bill
![Page 6: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/6.jpg)
6
For the 2014-15 Supplemental Bill and the 2015-16 Long Bill, you’ll need to look at bills in the current session.
For the 2014-15 Long Bill, you’ll need to look at bills passed in the Prior (2014) session.
![Page 7: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/7.jpg)
7
When you click on “Prior Session”, you’ll see this screen. The Long Bill funding SFY 2014-15 was passed in the 2014 Legislative Session.
![Page 8: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/8.jpg)
8
The Long Bill was House Bill 14-1336, so select “House Bills 1301-1350” from the drop-down list. Then click on “Go->”.
![Page 9: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/9.jpg)
9
Scroll down until you see HB14-1336, then click on the link.
![Page 10: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/10.jpg)
10
The Long Bill is sub-divided into its effect on individual agencies. So, you can “View” or “Download” the portion that applies to either CDHS or CDHCPF.
![Page 11: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/11.jpg)
11
Each year, the Legislature passes the Long Appropriations Bill. The number of the bill changes from year to year. The Long Bill forSFY-16 is Senate Bill 15-234
![Page 12: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/12.jpg)
12
Each Department’s appropriations are detailed within the bill.
![Page 13: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/13.jpg)
13
The first appropriation group of specific interest to counties appears on Human Services Pages 86 and 87 and on Health Care Policy and Financing Pages 55 and 56 as County Administration.
These appropriation groups include several lines, including County Administration and County Tax Base Relief.
![Page 14: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/14.jpg)
14
The next appropriation of interest is titled on Page 87 and continues through Pages 88 and 89 for Child Welfare Services.
![Page 15: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/15.jpg)
15
Take special note of the footnotes identified with the Title. Footnote 31 is of great importance. It gives us specific authority to spend the appropriation across line items, in order to best serve clients. The footnote, itself, is on Page 111.
![Page 16: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/16.jpg)
16
![Page 17: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/17.jpg)
17
There are several appropriations of interest on page 87. We will focus our attention on Child Welfare Services.
![Page 18: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/18.jpg)
18
“Cash Funds” refers to funds received from an entity other than the State General Fund or Federal Funds. “Reappropriated Funds”, which used to be referred to as “Cash Funds Exempt”, refers to “Cash Funds” which are not counted as revenue against the TABOR limitations, because they are inter-governmental transfers.
![Page 19: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/19.jpg)
19
In this case, “Cash Funds” refers to the County Share amount of $64,034,448, which is only an estimate. The Legislature will “allow” counties to spend as much County Funds as they wish.
![Page 20: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/20.jpg)
20
The non-Medicaid General Fund appropriation is $180,190,655. This can only be adjusted by transfer to HCPF or by Supplemental Appropriation.
![Page 21: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/21.jpg)
21
The “Reappropriated Funds” amount of $14,943,615is designated by letternote (a), on Page 88, as Federal and State Medicaid Funds appropriated to HCPF.
![Page 22: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/22.jpg)
22
These funds are intended to finance the Medicaid treatment portion of RMH and CHRP Programs, as well as the ACM portion of CW Administration.
![Page 23: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/23.jpg)
23
The $88,692,589 appropriated as “Federal Funds” are identified in letternote (f), on Page 89, from three sources:
![Page 24: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/24.jpg)
24
$61,082,727 is from Title IV-E, $23,590,313 is from Title XX, and $4,019,549 is from Title IV-B. These amounts may only be adjusted by a Supplemental Appropriation.
![Page 25: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/25.jpg)
25
Footnote f says “$64,153,620 shall be from Title IV-E …”. Lennie said $61,082,727. A difference of $3,070,893.
Did Lennie Lie ????Where are the pitchforks ??
![Page 26: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/26.jpg)
26
Family and Children’s Programs, also known as Core Services, uses the same footnote. So, the difference represents the Title IV-E Funds appropriated for Core Services.
![Page 27: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/27.jpg)
27
The Child Care appropriation group also contains several individual appropriations. We’ll focus our attention on the Child Care Assistance Program.
![Page 28: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/28.jpg)
28
The total General Fund appropriated for the Child Care allocation is $13,949,428. This amount may only be increased by a Supplemental Appropriation.
![Page 29: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/29.jpg)
29
The total Local Funds estimated for the Child Care allocation are $9,599,282. Per letternote (f), $9,260,049 of this is the Child Care Direct MOE. I’ve asked the State for clarification as to why the actual MOE being collected is only $7,899,282.
![Page 30: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/30.jpg)
30
The total Federal Funds appropriated for the Child Care allocation are $53,784,568.
![Page 31: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/31.jpg)
31
Per letternote (g), $53,684,568 of this is from the Child Care Development Fund. The remaining $100,000 is from Title XX.
![Page 32: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/32.jpg)
32
The final Long Bill appropriation we’ll look at is the Colorado Works appropriation, which is on Page 92. The main appropriation is labeled “County Block Grants”.
![Page 33: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/33.jpg)
33
There is a $22,349,730 Estimated County Share appropriation included.
![Page 34: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/34.jpg)
34
Per letternote (b), of this amount, $22,149,730 is the County Actual Spending Level MOE, with the remainder estimated to be captured through TANF Collections.
![Page 35: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/35.jpg)
35
All $130,198,357 of the Federal Funds appropriated to Colorado Works are from the TANF Block Grant.
![Page 36: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/36.jpg)
36
Footnote 37c created a $2,000,000 carve-out of the Colorado Works allocation for “Employment-Focused Programs”.
![Page 37: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/37.jpg)
37
Additional Spending Authority can be obtained through Supplemental
Appropriations bills and other Appropriation-Adjusting bills.
![Page 38: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/38.jpg)
38
House Bill 14-1317 expanded and standardized many of the policies and processes associated with the Child Care Assistance Program.
![Page 39: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/39.jpg)
39
The appropriations clause for House Bill 14-1317 was lengthy. Most notably, it added $8,279,903 to the county Child Care allocations, in anticipation of the increased need created by the bill.
![Page 40: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/40.jpg)
40
House Bill 14-1368 transferred responsibility for caring for developmentally disabled youth, between the ages of 18 and 21, from Child Welfare to the HCBS Adult Services program.
![Page 41: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/41.jpg)
41
The Appropriations clause of this bill actually reduces the Child Welfare Services appropriation, in recognition of the reduced demand for Child Welfare resources.
![Page 42: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/42.jpg)
42
Under no circumstances may we authorize counties to spend more General Fund dollars than are appropriated in the Long Bill and Supplemental Appropriations bills.
![Page 43: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/43.jpg)
43
26-1-121. Appropriations.
(1) (c) When the executive director determines that adequate appropriations for the payment of the costs described in paragraph (a) of this subsection (1) have not been made and that an overexpenditure of an appropriation will occur based upon the state department's estimates, the state board may take actions consistent with state and federal law to bring the rate of expenditure into line with available funds. The general assembly declares that case load and utilization based on medical necessity are legitimate reasons for supplemental funding.
![Page 44: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/44.jpg)
44
Please note that there is not an appropriation for Pass-thru’s in the Long Bill, nor in Supplemental Appropriation bills.
Pass-thru’s are non-appropriated, because statute allows for open-ended earning of Federal Revenues.
![Page 45: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/45.jpg)
45
26-1-122.County appropriations and expenditures - advancements - procedures.
(4) (h) Notwithstanding any other provision of this article, the county department may spend in excess of twenty percent of actual costs for the purpose of matching federal funds for the administration of the child support enforcement program or for the administrative costs of activities involving food stamp, public assistance, or medical assistance fraud investigations or prosecutions.
![Page 46: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/46.jpg)
46
Analysis of SFY-15 County Administration Close-Out Based on Projected Expenditures
During SFY-15, counties are projected to incur the following County Admin expenditures:Medicaid - $47,531,200Food Assistance - $58,332,100Child Support - $3,690,200Leap/Other St. Only - $2,757,600Total Expenditures - $112,311,100
![Page 47: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/47.jpg)
47
Those Expenditures will have the following impact on Federal Revenues:Medicaid-Reimb - $31,455,300CDHS Federal:Food Assistance - $29,166,100Child Support - $ 2,435,600Total CDHS Federal - $31,601,700[The CDHS portion of the Long Bill limited our ability to use Federal Revenues to $26,841,168. Therefore, the remaining $4,760,532 has to be moved to the Pass-thru appropriation to be used.]
Analysis of SFY-15 County Administration Close-Out Based on Projected Expenditures
![Page 48: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/48.jpg)
48
In summary, the Revenues that can be used in County Administration are: CDHCPF Federal - $ 31,455,300 CDHS Federal - $ 26,841,168 Total Federal - $ 58,296,468General Fund - $ 30,510,741Total CA Revenues - $ 88,807,209P/T Revenues - $ 4,760,532Grand Total - $ 93,567,741
Analysis of SFY-15 County Administration Close-Out Based on Projected Expenditures
![Page 49: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/49.jpg)
49
My Estimation: (Note all of the “Ifs”)IF expenditures continue at their current pace, and IF all of the expenditures are determined eligible for the Federal reimbursement rate initially used in CFMS, and IF the close-out methodology doesn’t do something strange with the distribution of funds, there may actually be General Fund to revert for the first time in my history.
Analysis of SFY-15 County Administration Close-Out Based on Projected Expenditures
![Page 50: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/50.jpg)
50
Section II -A High-level view of the close-out
procedures
This is a repeat of my presentation at the 2001 County
Accounting Conference
![Page 51: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/51.jpg)
51
Overview of Close-Out Process
• Verify Final Child Welfare Allocations• Obtain Final County Expenditure Totals• Determine Each County’s Over- or Under-
Expenditure Levels• Perform Surplus Distribution Calculations• Move Remaining Deficits to TANF Transfer
or to County-Only
![Page 52: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/52.jpg)
52
Verify Final Child Welfare Allocation
Child Welfare Allocations Have Been Adjusted For:
• Final Determinations of the Child Welfare Allocations Committee
• Distribution of Supplemental Funding• Mitigation Requests• Transfers to Core Services/EPP
![Page 53: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/53.jpg)
53
Obtain Final County Expenditure Totals
• Move any 100% CW Administration Over- or Under-Expenditures to 80/20 Line
• Reconcile Expenditure Report to Existing CFMS Reports
• Reconcile Total Expenditure Data to COFRS Balances
![Page 54: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/54.jpg)
54
Determine Each County’s Over- or Under-Expenditure Levels
• Re-Allocate State Share of RTC/CHRP Over- or Under-Expenditures from RTC/CHRP Lines to 80/20 Line:
– Multiply Over- or Under-Expenditure Amount by Federal Earning Rate (Approximately 50%)
– Divide This Amount by 80% to Establish a Comparable County Share
• Adjust RTC/CHRP Allocations to Expenditure Level
![Page 55: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/55.jpg)
55
Determine Each County’s Over- or Under-Expenditure Levels
(Continued)
• Adjust 80/20 Allocation by Amount Calculated
• Subtract 80/20 Expenditures from Net 80/20 Allocation. This Represents Each County’s Net Over- or Under-Expenditure of the Child Welfare Allocation
![Page 56: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/56.jpg)
56
Perform Surplus Distribution Calculations
Perform the Following Steps for All Over-Expended Small- and Medium-Sized Counties:
a Divide Each Over-Expended County’s 80/20 Child Welfare Allocation by the Total 80/20 Allocation of all Small and Medium-Sized Over-Expended Counties. The Total of this Column Should Equal 100%
![Page 57: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/57.jpg)
57
Surplus Distribution Calculations (Continued)
bDivide Each Over-Expended County’s Over-Expenditure by its 80/20 Child Welfare Allocation
c Calculate the Inverse Over-Expenditure Percentage by Dividing the Result of Step b into 1
d Calculate Each County’s Inverse Percentage from Step c as a Percentage of the Total of All Counties’ Inverse Percentages. The Total of this Column Should be 100%
![Page 58: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/58.jpg)
58
Surplus Distribution Calculations (Continued)
e Determine the Average of Each Over-Expended County’s Child Welfare Allocation as a Percentage of the State-Wide Total Child Welfare Allocation (Step a) and Each County’s Inverse Percentage as a Percentage of the State-Wide Total of Inverse Percentages (Step d). This Determines Each County’s Surplus Distribution Factor
![Page 59: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/59.jpg)
59
Surplus Distribution Calculations (Continued)
f Multiply the Surplus Distribution Factor, as Calculated in Step e, by the Surplus Distribution Pool. This Pool is Composed of the Total Amount of Under-Expenditures in Small and Medium-Sized Counties, Plus Any Unused Mitigation Pool Funds. This Step Determines the First Tier Distribution
![Page 60: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/60.jpg)
60
Surplus Distribution Calculations (Continued)
g Step f will result in a Distribution to Some Over-Spent Counties Which Exceeds Their Over-Expenditure Amount. Calculate the Amount of Such Over-Distributions. This Amount Becomes the Surplus Distribution Pool for the Second Tier Surplus Distribution
![Page 61: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/61.jpg)
61
Surplus Distribution Calculations (Continued)
h Repeat Steps a through g for all Counties With Remaining Over-Expenditures Until You No Longer Have a Mixture of Under-Spent and Over-Spent Counties
![Page 62: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/62.jpg)
62
Surplus Distribution Calculations (Continued)
i Complete the Surplus Distribution Process for Non-Managed Care, Ten Large Counties. The Surplus Distribution Pool Will Include the Under-Expenditures From Any of the Non-Managed Care Ten Large Counties and Any Unused Ten Large County Mitigation Funds
![Page 63: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/63.jpg)
63
Surplus Distribution Calculations (Continued)
j If There Are Small, Medium-Sized, or Non-Managed Care Ten Large Counties With Remaining Deficits, and Any Surpluses Which Have Not Yet Been Distributed, Complete Steps a Through g To Cover Deficits in These Counties to the Extent Possible
![Page 64: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/64.jpg)
64
Surplus Distribution Calculations (Continued)
k If There Are Managed Care Ten Large Counties With Remaining Deficits, and Any Surpluses Which Have Not Yet Been Distributed, Complete Steps a Through g To Cover Deficits in These Counties to the Extent Possible. This Completes the Surplus Distribution Process
![Page 65: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/65.jpg)
65
Move Remaining Deficits to TANF Transfer or to County-Only
• Determine the Portion of Each County’s Remaining Over-Expenditures That Can Be Covered With TANF Transfers:
– Does County Have Colorado Works Under-Expenditures?
– Did County Authorize TANF Transfer?– Is Transfer Needed to Cover Child Care
Over-Expenditures?
![Page 66: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/66.jpg)
66
Move Remaining Deficits to TANF Transfer or to County-Only(Continued)
• Reduce Child Welfare Expenditures and Increase TANF Transfer Expenditures By The Amount to be Transferred
• Calculate Remaining Over-Expenditure Amounts
• Reduce Child Welfare Expenditures and Increase County-Only Expenditures By The Amount of Remaining Over-Expenditures
![Page 67: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/67.jpg)
67
Move Remaining Deficits to TANF Transfer or to County-Only(Continued)• Note: Coming soon to a Close-Out near you!
- If there are funds remaining after the previous steps are completed, CMP Counties that elected to participate in Managed Care Savings will have a second chance at Surplus Distribution.
- If there are still funds remaining, CMP Counties that elected to participate in Surplus Distribution will have a second chance to receive the General Fund Portion of their savings.
![Page 68: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/68.jpg)
68
Section III – Shared Ideas
What can counties do to avoid County-Only dollars being used
to cover allocated programs?
![Page 69: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/69.jpg)
69
What can counties do to avoid County-Only dollars being used to cover allocated programs?
1. Find the optimal way to code expenditures LEGALLY, in order to maximize expenditures to allocations where your county is adequately funded, and minimize expenditures to those that are under-funded.
Potential Problems:1) Did I mention it must be LEGAL?2) Don’t automatically assume that 100% time reporting is going to drive costs where you “want” them to go. (Be careful what you wish for …)
![Page 70: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/70.jpg)
70
What can counties do to avoid County-Only dollars being used to cover allocated programs?
2. Authorize TANF Transfers in such a way that they maximize our ability to use them to bail your county out of Child Welfare and/or Child Care over-expenditures.
Potential Problems:1) This may use up your County TANF Reserve faster than you had planned.2) If you have other plans for funds transferred to Child Care from TANF, this may use up those funds on Close-Out, instead.
![Page 71: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/71.jpg)
71
What can counties do to avoid County-Only dollars being used to cover allocated programs?
3. Monitor your allocated expenditures monthly, so you can advise your Director to enact cost-reduction measures in time for those measures to take effect.
Potential Problems:You need to consider future expenditure patterns that can be anticipated. (e.g. Large remodel costs, Pending OOH placements, Provider rate increases, etc.)
![Page 72: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/72.jpg)
72
What can counties do to avoid County-Only dollars being used to cover allocated programs?
4. Monitor your RTC placements, so that you know what expenditures you’re actually generating, as opposed to the amount that is showing in CFMS each month.
Potential Problems:1) There can be expenditures that “carry over” from year-to-year, due to slow provider reimbursement requests.2) There is a great deal of effort involved.
![Page 73: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/73.jpg)
73
What can counties do to avoid County-Only dollars being used to cover allocated programs?
5. As a last resort, re-classify expenditures from allocations that are going to be significantly over-expended into the pass-thru appropriations.
Potential Problems:1) You lose any chance at reimbursement at the standard rate, in order to be “guaranteed” 33% reimbursement.2) Future allocations could be reduced, if they are calculated based on historical expenditures.3) County Contingency revenue could be reduced.
![Page 74: State Fiscal Year Close All Most Some of What County Accountants Need to Know About the Joy That Happens Every July Presented by Lennie Bottorff 2015 County](https://reader035.vdocuments.us/reader035/viewer/2022062221/56649eca5503460f94bd87ae/html5/thumbnails/74.jpg)
74
What can counties do to avoid County-Only dollars being used to cover allocated programs?
Other Ideas????