Data Pipeline Finance December - Business Rules

Results:

Error Warning Code

063

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

CHARTER SCHOOL TABOR 3% reporting is required. Location 900-969, Balance Sheet 6721, Amount > 0.

Helpful Hint

The process for Charter reporting is outlined in Appendix K: Charter Allocation of the Chart of Accounts. The Minimum allocation requirement is posted on the "Allocation to Charters & Preschool" tab of the "State Revenue check figures", this is located in the "Statutory Compliance and Reporting" section lower right corner of the website.

Results:

Error Warning Code

064

Status

Active

Tier

2

Type

Error

Data Element Name

Special Reporting Element Code

Error / Warning Message

CONSOLIDATED SCHOOL WIDE PLANS. For Districts that requested to be a Consolidated School-Wide plan district on their Federal grant application, the required use of Consolidated School Wide Plans is detected by the submission of the following record: SRE = 95.

Helpful Hint

Your District was identified as Consolidated School Wide District according to your budget submission. The process for reporting is outlined in Appendix T: Consolidated School Wide Accounting of the Chart of Accounts. If you still have questions you may email grants fiscal at grants_fiscal@cde.state.co.us.

Results:

Error Warning Code

065

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

CONSOLIDATED SCHOOL WIDE PLANS. The amounts debited and credited to Object 0855 must net to zero across all funds.

Helpful Hint

Your District was identified as Consolidated School Wide District according to your budget submission. The process for reporting is outlined in Appendix T: Consolidated School Wide Accounting of the Chart of Accounts. If you still have questions you may email grants fiscal at grants_fiscal@cde.state.co.us.

Results:

Error Warning Code

066

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

Under cost reimbursement type federal grant revenues should match grant expenditures reported, within one dollar. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue for that grant in the current fiscal year. If your grant revenue is lower than your grant expenditures, you may need to book a Grants Accounts Receivable for that grant in the current fiscal year. And/or clear a Grants Deferred Revenue for that grant in the previous fiscal year.

Helpful Hint

The Grant Codes listed are cost reimbursement grant and require revenues to equal expenditures. Review the revenues and expenditures for the listed grant to determine if a Deferred Revenue or an Accounts Receivable should be booked. If you need assistance contact your external auditor or School Finance at schoolfinance@cde.state.co.us.

Results:

Error Warning Code

067

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

FOOD SERVICE ACTIVITY requires at least one record - Fund 21, Source 4000-4999, Grant 4553, 4555, 4556, 4559 or 4582, amount greater than 0.

Helpful Hint

As a District with Food Service Fund it is required to record Revenues with the appropriate grant codes that the awards are funded with. The Claim Data is available on the Food Service Financial page.

Results:

Error Warning Code

068

Status

Active

Tier

2

Type

Error

Data Element Name

Program Code

Error / Warning Message

FOOD SERVICE ACTIVITY requires at least one record - Program 3100 and amount greater than 0.

Helpful Hint

As a District with Food Service Fund it is required to record expenditures with the object codes 0100-0999. Additional resources are available on the Food Service Financial page.

Results:

Error Warning Code

070

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

FOOD SERVICE FUND - CDE-5 REPORT. Federal Reimbursement Total Revenue must be > 0. Fund 10,21; Source 4000; Grant 4553,4555,4556,4559,4574,4582.

Helpful Hint

As a District with Food Service Fund it is required to record Revenues with the appropriate grant codes that the awards are funded with. The Claim Data is available on the Food Service Financial page.

Results:

Error Warning Code

071

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

FOOD SERVICE FUND - CDE-5 REPORT. Purchased Food and Milk Total Expenses (includes Fresh Fruit and Vegetable Program) must be > 0. Fund 21; Program 3100; Object 0630.

Helpful Hint

As a District with Food Service Fund it is required to record Food expenditures with the object code 0630. Additional resources are available on the Food Service Financial page.

Results:

Error Warning Code

072

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

FOOD SERVICE FUND - CDE-5 REPORT. Salaries and Benefits Total Expenses must be > 0. Fund 21; Program 3100; Object 0100-0299.

Helpful Hint

As a District with Food Service Fund it is required to record salary and benefit expenditures with the object codes 0100-0299. Additional resources are available on the Food Service Financial page.

Results:

Error Warning Code

075

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

FULL DAY KINDERGARTEN MILL LEVY OVERRIDE FUND is required. Fund 24, Amount not = 0.

Helpful Hint

Fund 24 is the Full Day Kindergarten Mill Levy Fund must be used by district with a Full Day Kindergarten Mill Levy Fund. Your district is listed on the Mill Levy Table with Full Day Kindergarten Mill Levy Fund, therefore Fund 24 must be used.

Results:

Error Warning Code

076

Status

Active

Tier

1

Type

Warning

Data Element Name

Fund Code

Error / Warning Message

Fund Code (WARNING ONLY) 22 cannot be accepted with Balance Sheet 7481, 8141 and 8153.

Helpful Hint

Balance Sheet Code 8142 grants accounts rec and 7482 grants def rev should only be used with State and Federal Grant between 3000-9999. Local Grants should use Balance sheet codes 7481, 8141 or 8153.

Results:

Error Warning Code

077

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

Fund 11 accounts, with amount not equal to zero, must have a location code between 900 and 969.

Helpful Hint

Fund 11 is the Charter School Fund and must be reported with a Charter School location between 900 and 969.

Results:

Error Warning Code

079

Status

Active

Tier

1

Type

Error

Data Element Name

School District/BOCES Code

Error / Warning Message

Fund 24 may not be reported by this district.

Helpful Hint

Fund 24 is the Full-Day Kindergarten Fund, no longer being used as of July 1, 2019.

Results:

Error Warning Code

080

Status

Active

Tier

1

Type

Error

Data Element Name

School District/BOCES Code

Error / Warning Message

Fund Code 25 must be reported by Transportation Mill Levy Override districts.

Helpful Hint

Fund 25 is the Transportation Fund must be used by district with a Mill Levy for Transportation. Your district is listed on the Mill Levy Table with Transportation Mills, therefore Fund 25 must be used.

Results:

Error Warning Code

081

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 25 with Amount not = 0, must be reported if Source 1410 has been reported.

Helpful Hint

Source code 1410 is Transportation Fees from Individuals, if you are collecting fees for transportation you are required to operate within Fund 25 the Transportation Fund.

Results:

Error Warning Code

084

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 31-39, Objects 0300-0399/0800-0999, can only be accepted with Location 800-999.

Helpful Hint

Fund 31 to 39 are the Debt Service Funds, the expenditures in these funds are purchased professional and technical services such as agent frees, banking fees, negotiation and consulting services or other related expenditures. Location code 800-999 must be used within these funds.

Results:

Error Warning Code

085

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 31-39, Objects 0300-0399/0800-0999, can only be accepted with Programs 5100-5199.

Helpful Hint

Fund 31 to 39 are the Debt Service Funds, the expenditures in these funds are purchased professional and technical services such as agent frees, banking fees, negotiation and consulting services or other related expenditures. Program code 5100-5199 debt services must be used within these funds.

Results:

Error Warning Code

086

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund Code 42 with amount not = 0, cannot be used by this district.

Helpful Hint

Fund 42 is the Special Building and Technology fund must be used by district with a Mill Levy for these purposes. Your district is listed on the Mill Levy Table with these Mills, therefore Fund 42 must be used.

Results:

Error Warning Code

088

Status

Active

Tier

1

Type

Warning

Data Element Name

Fund Code

Error / Warning Message

Funds (WARNING ONLY) 52-59 cannot be accepted with Programs 0001-2099.

Helpful Hint

Program codes 0001-2099 are considered Instructional program codes which should only be used with Instructional Funds. Fund 52-59 are not considered Instructional.

Results:

Error Warning Code

089

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Funds 21, 25, and 31-39 cannot be accepted with Programs 0001-2099.

Helpful Hint

Funds 21, 25 and 31-39 are considered non-instructional funds, therefore we would not expect these funds recorded with the instructional programs 0001-2099.

Results:

Error Warning Code

090

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Funds 31-39 can only be accepted with programs 5100-5199 when object is 0001-0999.

Helpful Hint

Fund 31 to 39 are the Debt Service Funds, program code 5100-5199 debt services must be used within these funds.

Results:

Error Warning Code

091

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Funds 70-85 cannot be accepted with Grants 3000-9999, except for grant 3898.

Helpful Hint

Fund 70 to 85 are the Fiduciary, Permanent and Foundation Funds. Since these are considered District Funds monitored by other agencies we would not expect state and/or federal grants to be coded within these funds.

Results:

Error Warning Code

092

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

GENERAL FUND requires at least one Expend rec - Fund 10,12-17, OBJ 0100-0199, PROG 0010-8999, Amount > 0 (for BOCES.).

Helpful Hint

The process for BOCES reporting is outlined in Appendix D: Board of Cooperative Education Services (BOCES) of the Chart of Accounts.

Results:

Error Warning Code

093

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

GENERAL FUND requires at least one Revenue record - Fund 10-17, SOURCE 1110-5999, amount greater than 0 (for BOCES).

Helpful Hint

The process for BOCES reporting is outlined in Appendix D: Board of Cooperative Education Services (BOCES) of the Chart of Accounts.

Results:

Error Warning Code

094

Status

Active

Tier

2

Type

Warning

Data Element Name

Fund Code

Error / Warning Message

GRANT (WARNING: Provide documentation justifying this variance) The amount the district has recorded for Grants Receipts should equal the amount of CDE payments, making adjustments for accounts receivable and deferred revenue changes from prior year to current year. CDE payments to your district exclude flow through (Source 3951 and 4951).

Helpful Hint

Review the revenues and expenditures for the listed grant to determine if a Deferred Revenue or an Accounts Receivable should be booked. The amounts listed here are also on the Grant Revenue Reconciliation Report. The Amounts sent from CDE to the District are on the Financial Data Warehouse reports. If you need assistance contact your external auditor or School Finance at schoolfinance@cde.state.co.us.

Results:

Error Warning Code

098

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant 3120 cannot be used with Source 3000.

Helpful Hint

Grant Code 3120 is the Career and Technical Funding from Colorado Community College System (CCCS), revenue received from this grant must be coded with 3010 State Revenues from Other State Agencies if directly from CCCS or with 395x if from BOCES/District.

Results:

Error Warning Code

099

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant 3141 expenditures must be reported (Grant 3141, Object 0001-0999) if Grant 3141 revenue is reported (Grant 3141, Source 1000-5999).

Helpful Hint

Grant Code 3141 is the Colorado Preschool Program funding. If receiving this funding grant code 3141 must be used to record expenditures and related allocations/revenues. If the district does not spend the full allocation, the district must use balance sheet code 6724.

Results:

Error Warning Code

100

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant/Project 3162 can only be accepted with Fund 21, Object 0001-0999 or Source 3000 or Balance Sheet 6000-8999.

Helpful Hint

Does Not Apply: Grant Code 3162 is no longer being used.

Results:

Error Warning Code

101

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant/Project 4000-9999 can only be accepted with Object Codes 0001-0999, Balance Sheet codes 6000-9999 and Source Codes 1300-1349, 1500-1599, 1800-1899, 1900-1999, 4000, 4010, 4020, 4553, 4555, 4556, 4559, 4590, 4951, 4952, 4954, 4956, 4959, 5200-5299 and 5300-5399. Except grants 4553, 4555, 4556, 4558 and 4559 which can also be accepted with Source codes 1610-1699.

Helpful Hint

Grant/Project Codes 4000-9999 are Federal Grants which are not allowed to be used with most local source or with state source codes. A listing of State and Federal Grants is available here.

Results:

Error Warning Code

102

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant/Project 4553, 4555, 4556, or 4559 can only be used with Funds 10-17, 19 or 21.

Helpful Hint

Grants/Projects Codes 4553, 4555, 4556 and 4559 are Food Service related Grants/Projects. These Grants/Projects must only be reporting in Funds that accept food service activity which are Funds 10-17, 19 and 21.

Results:

Error Warning Code

103

Status

Active

Tier

2

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant/Project must be between 4000 and 9999, if Source is between 4000 and 4999.

Helpful Hint

Source Codes 4000-4999 are revenues from federal sources, therefore Grant Codes 4000 through 9999 Federal Grants must be used. A listing of State and Federal Grants is available here.

Results:

Error Warning Code

106

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

INTERFUND Loans/ Accounts Payable (Balance Sheet 7401,7402) should equal Interfund Loans/ Accounts Receivable (Balance Sheet 8131,8132) across all funds.

Helpful Hint

The amount recorded as Interfund loans payable in one fund must match the amount recorded in interfund loans receivable in another fund. Review the transactions in the Interfund accounts 7401, 7402, 8131 and 8132 to determine the transaction that is out of balance in these accounts.

Results:

Error Warning Code

107

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

INTERGRANT TRANSFERS must net to zero. The amounts debited and credited to Source 5300-5399 must net to zero.

Helpful Hint

An Intergrant Transfer is a revenue transfer from one grant to another to spend those moneys accordingly. Review your accounts 5300-5399, to determine which account is out of balance, as these accounts must net to zero. Additional information is available in Appendix F-2: Intergrant Transfers.

Results:

Error Warning Code

108

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Warning: As a Title IA recipient (Only Grant 4010), you are required to report grant set-aside expenditures (Appendix F3 Chart of Accounts). Grant set-aside expenditures have not been detected in your financial data. Please review Appendix F3 and your district's grant set-aside activity, and ensure you are coding set-aside expenditures to the correct Federal or State/Local Grant Set-Aside Codes: 9201-9214, 9101-9114.

Helpful Hint

Your District was identified as a District allocating for a Grant Set Aside according to your budget submission. The process for reporting is outlined in Appendix F3: Intergrant Transfers Grant Set Aside of the Chart of Accounts. If you still have questions you may email grants fiscal at grants_fiscal@cde.state.co.us.

Results:

Error Warning Code

109

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

INTERNAL SERVICE FUNDS: To facilitate the elimination of duplicate activities for Federal reporting purposes, an entry must be made to debit source code 1979 with a credit to object code 0529. The amount debited to source code 1979 must equal the sum total of sources 1973, 1974, 1975, 1976, 1977, and 1978.

Helpful Hint

The use of Source Codes 1973-1978 was established to eliminate the duplicate reporting of revenues within internal service activities. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

110

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

INTERNAL SERVICE FUNDS. Total Source 1979 must equal Object 0529. The amounts debited to Source 1979 and credited to Object 0529 must equal.

Helpful Hint

The use of Source Codes 1973-1978 was established to eliminate the duplicate reporting of revenues within internal service activities. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

111

Status

Active

Tier

1

Type

Error

Data Element Name

Job Classification Code

Error / Warning Message

JOB CLASS 600-631, 645-699 cannot be accepted with Program 2200.

Helpful Hint

Job Classes 600s are related to Crafts, Trades and Services. These Job Classes are not used with Program 2200 Support Services Instructional Staff.

Results:

Error Warning Code

112

Status

Active

Tier

1

Type

Error

Data Element Name

Job Classification Code

Error / Warning Message

JOB CLASSES 100-199, 300-399, 500-599, 600-633, and 635-699 cannot be accepted with Programs 0001-2099.

Helpful Hint

Program codes 0001-2099 are considered Instructional program codes which should only be used with Instructional job classes like 200s and 400s.

Results:

Error Warning Code

113

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

LOCATION 300-399 and 930-939 cannot have programs 0010-0019, 0020-0029 or 0040-0049.

Helpful Hint

The location codes 300-399 and 930-939 are considered High School locations, therefore these locations must not be used with 0010-0019 elementary education, 0020-0029 middle school education or 0040-0049 preschool education.

Results:

Error Warning Code

114

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

LOCATION must be 090-999 if Object is 0001-0999.

Helpful Hint

Object Codes 0001-0999 are considered expenditure object codes, therefore the location must be valid and cannot be used with location 000.

Results:

Error Warning Code

115

Status

Active

Tier

1

Type

Warning

Data Element Name

Location Code

Error / Warning Message

LOCATIONS 090-099 may not be reported by this district.

Helpful Hint

A listing of Location Codes is available here.

Results:

Error Warning Code

116

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

LOCATIONS 461-469 may not be reported by this district.

Helpful Hint

Location codes 461 - 469 are considered online school/program location codes. The Districts using online location codes must be approved for use by the Office of Online and Blended Learning, the listing on approved locations is available here.

Results:

Error Warning Code

117

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

LOCATIONS 800-899 cannot be accepted with Objects 0100-0279, 0281-0299.

Helpful Hint

Location codes 800-899 are considered District-wide costs. Salaries and benefits must not be coded to District-wide costs, the location code must be updated.

Results:

Error Warning Code

118

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

Locations 900-969 cannot be accepted with Source 3110.

Helpful Hint

Location codes 900-969 are charter school location codes, Source 3110 is State Share payments. State Share payments are only distributed to the Districts, for charter schools' allocation of State Share source code 5710 and 5711 must be used. 22-30.5-112(2)(a)(III)(A) This allocation process is outlined in Appendix K-5 Charter Allocation of the Chart of Accounts.

Results:

Error Warning Code

120

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

LOCATIONS 900-969. Must use a distinct charter school location code for each charter school within the district.

Helpful Hint

Location codes 900-969 are charter school location codes, Districts with approved charter schools must use these locations when coding activity for the charter schools. The List of Colorado Schools is available here.

Results:

Error Warning Code

123

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Object 0597 and Source 1957 can only be used by District 8001.

Helpful Hint

District 8001 is the Charter School Institute, Object code 0597 and Source code 1957 is used to record the 1% withheld by CSI. § 22-30.5-515.5, C.R.S.

Results:

Error Warning Code

124

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

OBJECT 0633 can only be accepted with Fund 21 and Program 3100-3199.

Helpful Hint

Object code 0633 is the USDA Donated Foods (Commodities) these expenditures must be recorded within the Food Service Fund 21 and Programs 3100-3199.

Results:

Error Warning Code

125

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

OBJECT 0868, Overhead Costs Expenditures (OCE), must equal Source 1971, Overhead Costs Revenues (OCR).

Helpful Hint

The recording of Overhead Costs allows for the internal charging between the district and the grant, therefore object 0868 must equal source 1971. A resource is also available on the Office Hour/Trainings from September 26.

Results:

Error Warning Code

126

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

OBJECT 0869, Indirect Costs Expenditures (ICE), must equal Source 1972, Indirect Costs Revenues (ICR).

Helpful Hint

The recording of Indirect Costs allows for the internal charging between the district and the grant, therefore object 0869 must equal source 1972. A resource is also available on the Office Hour/Trainings from September 26.

Results:

Error Warning Code

127

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

OBJECTS 0100-0299, 0400-0799 cannot be accepted with Fund 31-39.

Helpful Hint

Fund 31 to 39 are the Debt Service Funds, the expenditures in these funds are purchased professional and technical services such as agent frees, banking fees, negotiation and consulting services or other related expenditures.

Results:

Error Warning Code

128

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

OBJECTS 0511-0512, 0514-0519, 0710-0729, 0740-0749, 0830-0839, 0868-0869 cannot be accepted with Programs 0001-2099.

Helpful Hint

Program codes 0001-2099 are considered Instructional program codes which should only be used with object codes. Object Codes 0511-0512, 0514-0519, 0710-0729, 0740-0749, 0830-0839, 0868-0869 are not considered Instructional.

Results:

Error Warning Code

129

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

OBJECTS 0561, 0562, 0563, 0564, 0565, 0566, and 0569 can only be accepted with Programs 0010-2099.

Helpful Hint

Program codes 0001-2099 are considered Instructional program codes which should only be used with object codes. Object Codes 0561, 0562, 0563, 0564, 0565, 0566, and 0569 are flow-through accounts and are not considered Instructional.

Results:

Error Warning Code

130

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

OBJECTS 0830-0839 and 0910-0919 can only be accepted with Programs 5100-5199.

Helpful Hint

Object codes 0830-0839 are Interest accounts and Object codes 0910-0919 are Redemption of Principal, these object codes are only allowed with Program 5100-5199 Debt Service.

Results:

Error Warning Code

132

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

Objects 0850 through 0859 must each "net" to zero across all funds. You should be using these objects ONLY when reallocating expenses within your district. Please see Appendix E of the Chart of Accounts or call CDE for more details before processing.

Helpful Hint

This process is outlined in Appendix E: Internal Charge Reimbursement Accounts of the Chart of Accounts. A resource is also available on the Office Hour/Trainings from September 26.

Results:

Error Warning Code

133

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Objects 0900-0959, 0961-0969, 0971-0999 can only be accepted with Programs 5000-8999.

Helpful Hint

Object codes 900-999 are Redemption of Principal, payments to Outside Entities, Special Items and Other expenditures. These object codes are only allowed with Program 5100-8999.

Results:

Error Warning Code

134

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

One or more Source Codes 1973-1978 must be reported if Fund 63 or 64 have been reported.

Helpful Hint

Funds 63 and 64 are considered Internal Service Funds. The use of Source Codes 1973-1978 was established to eliminate the duplicate reporting of revenues within internal service activities. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

135

Status

Active

Tier

1

Type

Error

Data Element Name

Program Code

Error / Warning Message

One or more Support Programs 2100-9999 must be reported if Locations 900-969 have been reported.

Helpful Hint

Location codes 900-969 are charter school location codes, Charter Schools are expected to report Object Codes 2100-9999.

Results:

Error Warning Code

136

Status

Active

Tier

2

Type

Error

Data Element Name

Location Code

Error / Warning Message

ON-LINE LOCATION CODE is required. Location 461-469, Amount not = 0.

Helpful Hint

Districts with approved online programs through the Office of Online learning are required to use location 461-469 for the approved program. A listing of programs is available here.

Results:

Error Warning Code

137

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

OTHER SOURCES - (WARNING: you must provide documentation to CDE justifying this variance) The use of Source Code 5000-5099 and/or 5900 "Other Sources" is very uncommon. It is rare that a specific revenue Source Code cannot be found. Therefore, please contact School Finance to clarify your use of Source Code 5000-5099 and/or 5900: Source 5000-5099 and 5900 roll to Source 5900. Note: Contributed Capital is appropriately coded as Source 5900.

Helpful Hint

Source Code 5000-5099 and 5900 are Other Sources, this amount should be confirmed with totals in the Fund Statements and Note Section of the Financial Audit.

Results:

Error Warning Code

138

Status

Active

Tier

1

Type

Error

Data Element Name

Program Code

Error / Warning Message

PROGRAMS 5000-5099, 5300-8999 can only be accepted with Objects 0900-0909, 0920-0929, 0940-0999.

Helpful Hint

Object codes 900-999 are Redemption of Principal, payments to Outside Entities, Special Items and Other expenditures. These object codes are only allowed with Program 5100-8999.

Results:

Error Warning Code

139

Status

Active

Tier

1

Type

Error

Data Element Name

Program Code

Error / Warning Message

PROGRAMS 5000-5199, 5201-8999 cannot be accepted with Objects 0100-0299.

Helpful Hint

Program codes 5000-8999 are considered debt service and other programs. Salaries and benefits must not be coded to these programs.

Results:

Error Warning Code

140

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING ONLY) 5110-5199 can only be accepted with Funds 31-39, 41 or 44-49.

Helpful Hint

Source 5110-5199 is considered a Transfer account only accepted with the listed funds. See the Transfer section listed in the FPP Handbook.

Results:

Error Warning Code

141

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING ONLY) 5221 can only be accepted with Funds 10, 18, 21, or 43 (for purposes of Contributed Capital, GASB 34).

Helpful Hint

Source 5221 is considered a Transfer account only accepted with the listed funds. See the Transfer section listed in the FPP Handbook.

Results:

Error Warning Code

142

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING ONLY) 5231 can only be accepted with Fund 10-18.

Helpful Hint

Source 5221 is cons

Results:

Error Warning Code

143

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING ONLY) 5241 can only be accepted with Fund 31.

Helpful Hint

Source 5241 is considered a Transfer account only accepted with the listed funds. See the Transfer section listed in the FPP Handbook.

Results:

Error Warning Code

144

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING ONLY) 5242 can only be accepted with Fund 43.

Helpful Hint

Source 5242 is considered a Transfer account only accepted with the listed funds. See the Transfer section listed in the FPP Handbook.

Results:

Error Warning Code

145

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING ONLY) 5243 can only be accepted with Funds 10 or 18.

Helpful Hint

Source 5243 is considered a Transfer account only accepted with the listed funds. See the Transfer section listed in the FPP Handbook.

Results:

Error Warning Code

146

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE (WARNING) 1110-1190 and 3110-5199 and 5300-5999 cannot be used in Internal Service Funds, 63-69.

Helpful Hint

Funds 63 and 69 are considered Internal Service Funds. The use of Source Codes 1110-1190 and 3110-5199 and 5300-5999 are not accepted in these Funds. This process for Internal Service activities is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

147

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 1110-1119 and 1120-1129 can only be accepted with Fund Codes 06, 07,10-19,24-29, 31, 41, 42, 43, 46, 52-59 or 64.

Helpful Hint

Source Codes 1110 - 1129 are Property and Specific ownership taxes. Revenues from these source codes are only allowed in funds which are allowable for recording of tax revenues. Funds that are allowed to record tax revenues are Fund Codes 06, 07,10-19,24-29, 31, 41, 42, 43, 46, 52-59 or 64.

Results:

Error Warning Code

148

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 1110-1119, 1120-1129, 1130-1139, 1140-1149, 1190-1199, 1600, 1960-1969, 5110-5119, 5120-5129, 5130-5139, 5400-5499, 5500-5599 cannot be accepted with Grants 0001-0017, 0019-0020, 0022-9999.

Helpful Hint

SOURCE 1110-1119, 1120-1129, 1130-1139, 1140-1149, 1190-1199, 1600, 1960-1969, 5110-5119, 5120-5129, 5130-5139, 5400-5499, 5500-5599 cannot be accepted with Grants 0001-0017, 0019-0020, 0022-9999.

Results:

Error Warning Code

149

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 1324 can only be accepted with Funds 10-17, 22, 24 or 26-29.

Helpful Hint

Source Code 1324 is Tuition from CDE for Out-of-District Placed Pupils, these activities are only accepted in Funds 10-17, 22, 24 or 26-29.

Results:

Error Warning Code

150

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 1410 can only be accepted with Fund 25.

Helpful Hint

Source Code 1410 is Transportation Fees from Individuals, these activities are only allowed in Fund 25.

Results:

Error Warning Code

151

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 1610-1619 can only be accepted with Funds 11, 21 and Grants 4553, 4555, 4556 or 4558.

Helpful Hint

Source code 1610-1619 are Reimbursable Food Service Revenues. These revenues are only allowed in Funds 11 or 21 with grant codes 4553, 4555, 4556 or 4558.

Results:

Error Warning Code

152

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 1973, 1975-1979 can only be accepted with Funds 11, 26-29, 39, 41, 52-59, 61-69, 71 and 85.

Helpful Hint

The use of Source Codes 1973-1978 was established to eliminate the duplicate reporting of revenues within internal service activities. These sources are only allowed in the accepted funds 11, 26-29, 39, 41, 52-59, 61-69, 71 and 85. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

153

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 1974 can only be accepted with Fund 64.

Helpful Hint

Source Code 1974 is Internal Service Revenue - Risk Management, these revenues are only allowed in Fund 64 Risk Related Activity Fund.

Results:

Error Warning Code

154

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 can only be accepted with Grants 3000-3949.

Helpful Hint

Source Code 3000 is State Revenue from the Colorado Department of Education this source code should only be used with state grants from CDE a grant between grant code 3000-3949. A listing of State and Federal Grants is available here. A listing of State and Federal revenue from CDE is provided on the Financial Data Warehouse reports.

Results:

Error Warning Code

155

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000-4999 are not allowed in Funds 70-79, except for source 3010 with grant 3898.

Helpful Hint

Fund 70 to 79 are Fiduciary and Permanent Funds. Since these are considered District Funds monitored by other agencies we would not expect state and/or federal grants to be coded within these funds.

Results:

Error Warning Code

157

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 3010 can only be accepted with Grants 3120, 3188, 3189, 3243, 3895, 3896, 3897, 3898, 3899 and 3950-3999.

Helpful Hint

Source Code 3010 is State Revenue from other state and local agencies this source code should only be used with state grants that not from CDE. These are grant codes 3120, 3188, 3189, 3243, 3895, 3896, 3897, 3898, 3899 and 3950-3999. A listing of State and Federal Grants is available here.

Results:

Error Warning Code

158

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 3110 can only be accepted with Funds 10-18 or 43.

Helpful Hint

Source 3110 is State Share payments. State Share payments are only accepted in funds 10-18 and 43.

Results:

Error Warning Code

159

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3110 may not be used by BOCES.

Helpful Hint

Source 3110 is State Share payments. State Share payments are only distributed to Districts and are not distributed to BOCES or Charter Schools.

Results:

Error Warning Code

160

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3200 can only be accepted with Grants 3120, 3140 and 3160.

Helpful Hint

Source 3200 is for Adjustments to Categorical Revenue, this source code can only be accepted with the Categorical Grants 3120, 3140 and 3160.

Results:

Error Warning Code

161

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 3951 can only be accepted with Grants 3000-3999.

Helpful Hint

Source 3951 is State revenues provided by a district or BOCES and should only be used with State Grant codes 3000-3999.

Results:

Error Warning Code

162

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 4000 can only be accepted with Grants which CDE Administers. Source 4000 is Federal Revenue from CDE. Source 4010 is Federal Revenue from State agencies other than CDE. Source 4020 is Federal Revenue direct from the Federal Government.

Helpful Hint

Source Code 4000 is Federal Revenue from the Colorado Department of Education this source code should only be used with Federal grants from CDE a grant between grant code 4000-9999. A listing of State and Federal Grants is available here. A listing of State and Federal revenue from CDE is provided on the Financial Data Warehouse reports.

Results:

Error Warning Code

163

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 4000-4999 in Fund 21 can only be accepted with Grants 4012, 4425, 4420, 4553, 4555, 4556, 4557, 4558, 4559, 4561, 4575, 4579, 5525, 5579, 7564, 4574, 4582, 8558.

Helpful Hint

Fund 21 is the Food Service Fund, Only Food Service related grants are accepted within this fund. Federal grants allowed within this fund are 4012, 4425, 4420, 4553, 4555, 4556, 4557, 4558, 4559, 4561, 4575, 4579, 5525, 5579, 7564, 4574, 4582, 8558. Food Service grant code listing is available here.

Results:

Error Warning Code

165

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 4951 can only be accepted with Grants 4000-9999.

Helpful Hint

Source 4951 is Federal revenues provided by a district or BOCES and should only be used with Federal Grant codes 4000-9999.

Results:

Error Warning Code

167

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 5210 cannot be accepted with Fund 74.

Helpful Hint

Source 5210 is considered a Transfer from or to the General Fund, Fund 74 cannot accept transfers. See the Transfer section listed in the FPP Handbook.

Results:

Error Warning Code

170

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 5300-5399 can only be accepted with funds 10-17, 22, 26-29, and grants 4010, 4367, 4424.

Helpful Hint

Source codes 5300-5399 are Intergrant Transfer accounts, are used for the approved transfer of one grant to another to spend those moneys accordingly. The process for Intergrant Transfers is outlined in Appendix F-2: Intergrant Transfers of the Chart of Accounts.

Results:

Error Warning Code

172

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 5710 can only be accepted with Fund 11.

Helpful Hint

Source code 5710 and 5711 are to account for the Charter School Allocations, These codes can only be used within funds 10 and 11. 22-30.5-112(2)(a)(III)(A) This allocation process is outlined in Appendix K-5 Charter Allocation of the Chart of Accounts.

Results:

Error Warning Code

173

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 5711 can only be accepted with Fund 10.

Helpful Hint

Source code 5710 and 5711 are to account for the Charter School Allocations, These codes can only be used within funds 10 and 11. 22-30.5-112(2)(a)(III)(A) This allocation process is outlined in Appendix K-5 Charter Allocation of the Chart of Accounts.

Results:

Error Warning Code

174

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 5800 through 5899 must net to zero across all funds.

Helpful Hint

Source code 5810, 5811 and 5819 are to account for the Pre School Allocations, These codes can only be used within funds 10, 11 and 19. The amount to be reported by districts are available on the "State Revenue check figures". § 22-28-108(5.5).

Results:

Error Warning Code

175

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 5810 can only be accepted with Fund 19 and 11.

Helpful Hint

Source code 5810, 5811 and 5819 are to account for the Pre School Allocations, These codes can only be used within funds 10, 11 and 19. § 22-28-108(5.5).

Results:

Error Warning Code

176

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

SOURCE 5819 can only be accepted with Fund 10 and 11.

Helpful Hint

Source code 5810, 5811 and 5819 are to account for the Pre School Allocations, These codes can only be used within funds 10, 11 and 19. § 22-28-108(5.5).

Results:

Error Warning Code

177

Status

Active

Tier

2

Type

Error

Data Element Name

School District/BOCES Code

Error / Warning Message

SPECIAL BUILDING AND TECHNOLOGY FUND is required. Fund 42, Amount not = 0.

Helpful Hint

Fund 42 is the Special Building and Technology fund and must be used by districts with a Mill Levy for these purposes. Your district is listed on the Mill Levy Table with these Mills, therefore Fund 42 must be used.

Results:

Error Warning Code

178

Status

Active

Tier

1

Type

Error

Data Element Name

Special Reporting Element Code

Error / Warning Message

SRE 95 can only be accepted from Consolidated School-Wide Districts.

Helpful Hint

If you were Identified as a Consolidated School-Wide District we would expect SRE 95 to be used by your district. The process for Consolidated School-Wide Districts is outlined in Appendix T: Consolidated School Wide Accounting of the Chart of Accounts.

Results:

Error Warning Code

181

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

STATE EQUALIZATION. Requires at least one record (except for BOCES) - Source 3110.

Helpful Hint

Source Code 3110 are State Share Payments for districts. The amount to be reported by districts are available on the "State Revenue check figures".

Results:

Error Warning Code

186

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

STATE SHARE (STATE EQUALIZATION). The amount the district has recorded as State Share must equal the amount of CDE State Share payments within $1.00. State Share equals Gross State Share less Division of Wildlife (DOW) plus Business Incentive Agreements. Be sure to charge applicable CDE "withholdings" as expenses; do not "net" against revenues received. Source 3110.

Helpful Hint

Source Code 3110 are State Share Payments for districts. The amount to be reported by districts are available on the "State Revenue check figures", this is located in the "Statutory Compliance and Reporting" section lower right corner of the website.

Results:

Error Warning Code

187

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

TOTAL TRANSFERS IN AND OUT must net to zero. Transfers and allocations work the same way; The transfer out accounts are reductions of positive revenue.

Helpful Hint

Source 5200s are considered a Transfer account from one fund to another fund must net to zero. The process for reporting is outlined in Appendix F: Intergrant Transfers of the Chart of Accounts. Also see ,the Borrowing of Funds section listed in the FPP Handbook.

Results:

Error Warning Code

188

Status

Active

Tier

1

Type

Error

Data Element Name

School District/BOCES Code

Error / Warning Message

District Code must be a valid code.

Helpful Hint

The first four digits of the uploaded file must be the assigned four digits of your district. Check the first four digits of the file used to upload. The district codes assigned by CDE are available here.

Results:

Error Warning Code

190

Status

Active

Tier

1

Type

Error

Data Element Name

School Code

Error / Warning Message

School Code must be a valid code.

Helpful Hint

Must be a School Code that is assigned for your district, included are current years school codes, prior year closed schools to capture closing costs and the following years opening schools to capture opening costs. The school codes assigned by CDE are available here.

Results:

Error Warning Code

191

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund Code must be a valid code.

Helpful Hint

A listing of Fund Codes is available here.

Results:

Error Warning Code

192

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

Location Code must be a valid code.

Helpful Hint

A listing of Location Codes is available here.

Results:

Error Warning Code

193

Status

Active

Tier

1

Type

Error

Data Element Name

Special Reporting Element Code

Error / Warning Message

Special Reporting Element must be a valid code.

Helpful Hint

A listing of SRE Codes is available here.

Results:

Error Warning Code

194

Status

Active

Tier

1

Type

Error

Data Element Name

Program Code

Error / Warning Message

Program Code must be a valid code.

Helpful Hint

A listing of Program Codes is available here.

Results:

Error Warning Code

195

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Object Source Balance Code must be a valid code.

Helpful Hint

A listing of Object Source Balance Sheet Codes is available here.

Results:

Error Warning Code

196

Status

Active

Tier

1

Type

Error

Data Element Name

Job Classification Code

Error / Warning Message

Job Classification Code must be a valid code.

Helpful Hint

A listing of Job Classification Codes is available here.

Results:

Error Warning Code

197

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant Project Code must be a valid code.

Helpful Hint

A listing of State and Federal Grants is available here.

Results:

Error Warning Code

198

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Object 0868, Overhead Costs, cannot be accepted with Grant Codes 4000-9999.

Helpful Hint

Object code 0868 is for the recording of overhead costs with local or state grant codes, it cannot be accepted with federal grant codes 4000-9999.

Results:

Error Warning Code

199

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Object 0869, Indirect Costs, cannot be accepted with Grant Codes 0001-3999.

Helpful Hint

Object code 0869 is for the recording of indirect costs with federal grant codes 4000-9999, it cannot be accepted with local or state grant codes.

Results:

Error Warning Code

200

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Object 0960 can only be accepted with Grant 3130.

Helpful Hint

Object Code 0960 is for recording payments to outside entities such as School to Work Alliance Program, the grant code 3130 must be used with this object code.

Results:

Error Warning Code

203

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

SWAP Revenue The Expenditures coded to Object 0960, Grant 3130 (Matching Funds Withheld by CDE from State Share, or Funds that have been directly sent by the District to the Division of Vocational Rehabilitation) must equal (within a dollar) the amount on file with CDE.

Helpful Hint

The amount to be reported for SWAP by districts are available on the "State Revenue check figures".

Results:

Error Warning Code

204

Status

Active

Tier

2

Type

Error

Data Element Name

Amount

Error / Warning Message

Source 4010, 4951, Grants 5126/6126 must be equal to Objects 0001-0999, Grants 5126/6126.

Helpful Hint

The Grant Codes listed are cost reimbursement grant and require revenues to equal expenditures. Review the revenues and expenditures for the listed grant to determine if a Deferred Revenue or an Accounts Receivable should be booked. If you need assistance contact your external auditor or School Finance at schoolfinance@cde.state.co.us.

Results:

Error Warning Code

206

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Flow Through BOCES: For these BOCES 9025,9030,9035,9040,9045,9050,9055,9060,9075,9095,9125,9135,9140,9145,9150,9165 it is likely that you should be reporting Purchased Services in your Expenditure Data: Object 0591 Services Purchased within the BOCES or AU Flow-Through Payments made to your member School Districts. Please ensure it is accurate.

Helpful Hint

The process for BOCES reporting is outlined in Appendix D: Board of Cooperative Education Services (BOCES) of the Chart of Accounts. Review the payments made to your member BOCES/District to ensure payments match object code 0591.

Results:

Error Warning Code

207

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

BOCES, and Members of BOCES need to verify that the Flow Through Revenue being reported is accurate. Please verify that the Flow Through Revenue you are reporting is accurate.(Source Codes 1951, 3951, 3952, 3956, 4951, 4952, 4954, 4956).

Helpful Hint

The process for BOCES reporting is outlined in Appendix D: Board of Cooperative Education Services (BOCES) of the Chart of Accounts. Review the receipts from your member BOCES/District to ensure receipts match Source Codes 1951, 3951, 3952, 3956, 4951, 4952, 4954, 4956.

Results:

Error Warning Code

208

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

BOCES, and members of BOCES need to verify that the Flow Through payments made are accurate. Please ensure that your use of Object 0591 is accurate.

Helpful Hint

The process for BOCES reporting is outlined in Appendix D: Board of Cooperative Education Services (BOCES) of the Chart of Accounts. Review the payments made to your member BOCES/District to ensure payments match object code 0591.

Results:

Error Warning Code

210

Status

Active

Tier

2

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

TABOR 3% reporting is required. Balance Sheet 6721, Amount > 0.

Helpful Hint

Districts and Charter Schools are required to report the Tabor 3% with Balance Sheet Code 6721, unless the district can provide a letter of credit.

Results:

Error Warning Code

213

Status

Active

Tier

1

Type

Error

Data Element Name

School District/BOCES Code

Error / Warning Message

District Code must match the district code against which the data was uploaded.

Helpful Hint

Must be the District Code that is assigned for your district. The district codes assigned by CDE are available here.

Results:

Error Warning Code

214

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

Grant/Project must be valid, not 0000, if Fund = 22 and Object is between 0001 and 0999.

Helpful Hint

Fund 22 is the Governmental Designated-Purpose Grants Fund, activity in this fund must be for a valid State or Federal grant code. A listing of State and Federal Grants is available here. A listing of State and Federal revenue from CDE is provided on the Financial Data Warehouse reports.

Results:

Error Warning Code

216

Status

Active

Tier

2

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 90 must be reported by all Districts (0010-3230), with Balance Sheet Codes 7511, 7512, 7513, 7514 and 7515. Fund 90 is the way your District reports General Obligation Bond Debt information. If you have no General Obligation Bond Debt, you must still report Fund 90 with Balance Sheet Codes 7511-7515 with amounts = 0.

Helpful Hint

This is an invalid combination with Balance Sheet codes 7511-7515 and Fund 90. An update is needed to either the Balance Sheet code used or the Fund used. The process for Fund 90 reporting is outlined in Appendix R: District Debt of the Chart of Accounts.

Results:

Error Warning Code

217

Status

Active

Tier

2

Type

Warning

Data Element Name

Fund Code

Error / Warning Message

W - Internal Service Fund(s) use has been detected in your financial data: Funds 61-69. Throughout the year, your employee benefit premiums are most likely credited to a Source Code between 1973-1979. Please remember to eliminate the revenue received as a result of expenditures for services purchased by other funds by making the following journal entry:.

Helpful Hint

The use of Source Codes 1973-1978 was established to eliminate the duplicate reporting of revenues within internal service activities. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

218

Status

Active

Tier

2

Type

Warning

Data Element Name

Grant/Project Code

Error / Warning Message

Warning: As a Title IA recipient (Only Grant 4010), you are required to report grant set-aside expenditures (Appendix F3 Chart of Accounts). Grant set-aside expenditures have not been detected in your financial data. Please review Appendix F3 and your district's grant set-aside activity, and ensure you are coding set-aside expenditures to the correct Federal or State/Local Grant Set-Aside Code.

Helpful Hint

Your District was identified as a District allocating for a Grant Set Aside according to your budget submission. The process for reporting is outlined in Appendix F3: Intergrant Transfers Grant Set Aside of the Chart of Accounts. If you still have questions you may email grants fiscal at grants_fiscal@cde.state.co.us.

Results:

Error Warning Code

219

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Title IA, Grant 4010 is a Cost Reimbursement Grant, and should have related Grant Set-Asides. Grant revenues reported should match the grant expenditures reported, within $1. Revenue reporting for Grant 4010 must equal total expenditures reported for Grant 4010, 9201-9212.

Helpful Hint

Your District was identified as a District allocating for a Grant Set Aside according to your budget submission. The process for reporting is outlined in Appendix F3: Intergrant Transfers Grant Set Aside of the Chart of Accounts. If you still have questions you may email grants fiscal at grants_fiscal@cde.state.co.us.

Results:

Error Warning Code

220

Status

Active

Tier

1

Type

Warning

Data Element Name

Fund Code

Error / Warning Message

Please verify that the Fund 90 Voter Approved Override Information (Source Code 1170-1174) you have reported matches your audit.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

222

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Your district must submit data for Fund 90, for each Source Code: 1170, 1171, 1172, 1173, and 1174. Amounts greater than or equal to zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

224

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 1995 can only be accepted with Grant Codes 4000-9999.

Helpful Hint

Source Code 1995 is for local generated revenue tied to a specific Federal Grant, only if allowed by the Grant.

Results:

Error Warning Code

226

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Amounts reported in Source Codes 1170-1174 and Balance Sheet Codes 7511-7515 reported with Fund 90 must be greater than or equal to zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174 and Balance Sheet Codes 7511-7515, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R: District Debt and Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

227

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

If you report Fund 31, you must also report Fund 90 with Balance Sheet Codes 7511, 7512, 7513, 7514, 7515 with amounts greater than or equal to zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Balance Sheet Codes 7511-7515, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R: District Debt of the Chart of Accounts.

Results:

Error Warning Code

228

Status

Active

Tier

1

Type

Warning

Data Element Name

Fund Code

Error / Warning Message

Please verify that the General Obligations Bonds Payable information you have reported matches your audit:.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt, please confirm the amounts in Balance Sheet codes 7511-7514 to the Debt section of your audit notes, when applicable, to determine if the amounts reported are accurate. The process for Fund 90 reporting is outlined in Appendix R: District Debt of the Chart of Accounts. Note: The district may need to contact the Underwriter to assist with the calculation verification.

Results:

Error Warning Code

229

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 90 can only be accepted with Balance Sheet Codes 7511-7519 and Source Codes 1170-1179.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174 and Balance Sheet Codes 7511-7515, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R: District Debt and Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

230

Status

Activ

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 90 can only be accepted with amounts >= zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174 and Balance Sheet Codes 7511-7515, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R: District Debt and Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

231

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 51 is not a valid fund.

Helpful Hint

Fund 51 was the Food Service Fund when it was within the Enterprise Fund. Per GASB 68, this fund is now reported as a Special Revenue Fund with Fund Code 21.

Results:

Error Warning Code

232

Status

Active

Tier

1

Type

Error

Data Element Name

Job Classification Code

Error / Warning Message

Job class code must be 100-699 if Object Code is 0100-0299.

Helpful Hint

Object Codes 0100-0299 are for the reporting of Salaries and Benefits, the reporting of these expenditures is required to be reported with a valid Job Classification. A listing of Job Classification Codes is available here.

Results:

Error Warning Code

233

Status

Active

Tier

1

Type

Error

Data Element Name

Program Code

Error / Warning Message

If Object Code is between 0001-0999, Program Code must be between 0010-5999.

Helpful Hint

Object Codes 0001-0999 are considered expenditure object codes, therefore the Program code must be valid and cannot be used with Program 0000.

Results:

Error Warning Code

234

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

All Districts must report mill levy override information. Fund 90, Source code 1170, amount authorized - voter approved overrides, must be greater than or equal to zero. If you do not levy a voter approved override mill, please report zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

235

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

All Districts must report mill levy override information. Fund 90, Source code 1171, amount collected - voter approved overrides, must be greater than or equal to zero. If you do not levy a voter approved override mill, please report zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

236

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

All Districts must report mill levy override information. Fund 90, Source code 1172, amount distributed to charter schools - voter approved overrides, must be greater than or equal to zero. If you do not levy a voter approved override mill, please report zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

237

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

All Districts must report mill levy override information. Fund 90, Source code 1173, amount distributed to non-charter schools - voter approved overrides, must be greater than or equal to zero. If you do not levy a voter approved override mill, please report zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

238

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

All Districts must report mill levy override information. Fund 90, Source code 1174, amount retained by district - voter approved overrides, must be greater than or equal to zero. If you do not levy a voter approved override mill, please report zero.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

239

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

The sum of Source Codes 1172, 1173 and 1174 must equal the amount you have reported in Source Code 1171.

Helpful Hint

Fund 90 is a fund that is used for Reporting purposes for District Debt and Voter Approved Overrides. This fund must be reported with Source Codes 1170-1174, even if the amount reported is ZERO. The process for Fund 90 reporting is outlined in Appendix R-1: Voter Approved Override of the Chart of Accounts.

Results:

Error Warning Code

240

Status

Active

Tier

1

Type

Error

Data Element Name

Amount

Error / Warning Message

Amount Finance must be a numeric value with no decimals.

Helpful Hint

Check the format of the amount field Excel Files: update to be numeric Text Files: ensure amount field is 13 characters if negative fill with spaces preceding the negative sign.

Results:

Error Warning Code

241

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source Code 3115 is not allowed. Please use Source Code 3000, with Grant Code 3115.

Helpful Hint

Source Code 3115 is not allowed. Please use Source Code 3000, with Grant Code 3115.

Results:

Error Warning Code

242

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

TOTAL TRANSFERS IN AND OUT must net to zero. Transfers and allocations work the same way; The transfer out accounts are reductions of positive revenue.

Helpful Hint

Source 5200s are considered a Transfer account from one fund to another fund must net to zero. The process for reporting is outlined in Appendix F: Intergrant Transfers of the Chart of Accounts. Also see ,the Borrowing of Funds section listed in the FPP Handbook.

Results:

Error Warning Code

243

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

As a district with Commodities Revenues, you should report Source 4010 with an appropriate Grant Code: 4555, 4553, 4556, 4559.

Helpful Hint

As a district with Commodities Revenues, you should report Source 4010 with an appropriate Grant Code: 4555, 4553, 4556, 4559. The expected amount to be reported as provided by CDHS is available here.

Results:

Error Warning Code

244

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

As a district with Commodities Expenditures, you should report Object Code 0633.

Helpful Hint

Object code 0633 is the USDA Donated Foods (Commodities) these expenditures must be recorded within the Food Service Fund 21 and Programs 3100-3199 by Districts. The expected amount to be reported as provided by CDHS is available here.

Results:

Error Warning Code

247

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Funds 50-69 cannot be accepted with balance sheet code 6770.

Helpful Hint

Balance Sheet code 6770 is for the recording of Unassigned Fund Balance, review the fund equity accounts to determine the fund equity account to be used within these funds Per GASB 54.

Results:

Error Warning Code

248

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Funds 20- 49 can only be accepted with Balance Sheet 6770 when the amount is < or = to zero.

Helpful Hint

Balance Sheet code 6770 is for the recording of Unassigned Fund Balance, review the fund equity accounts to determine the fund equity account to be used within these funds Per GASB 54.

Results:

Error Warning Code

249

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

(WARNING) Commodities Reported. The amount the district has reported as Commodities Expenditures (Fund 21, Object 0633) does not agree with the Commodities usage amount supplied by the Colorado Department of Human Services.

Helpful Hint

Object code 0633 is the USDA Donated Foods (Commodities) these expenditures must be recorded within the Food Service Fund 21 and Programs 3100-3199 by Districts. The expected amount to be reported as provided by CDHS is available here.

Results:

Error Warning Code

250

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

(WARNING) Commodities Expenditures and Revenue should equal. Commodities expenditures (Fund 21, Object 0633) currently do not equal Commodities revenue (Fund 21, Source 4010, Grant Code 4553 or 4555 or 4556 or 4559). Please ensure that you can explain the difference.

Helpful Hint

Object code 0633 is the USDA Donated Foods (Commodities) these expenditures must be recorded within the Food Service Fund 21 and Programs 3100-3199 by Districts. The expected amount to be reported as provided by CDHS is available here.

Results:

Error Warning Code

251

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

The sum of Source Codes 1979 must equal the Sum of Source Codes 0529.

Helpful Hint

Source Code 1979 and Object Code 0529 are Internal Service accounts used to eliminate overreporting Revenues and Expenditures. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

252

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source Code 1979 can only be reported when the following account(s) are present in the district's data: Object Code 0529 and an amount < or = zero.

Helpful Hint

Source Code 1979 and Object Code 0529 are Internal Service accounts used to eliminate overreporting Revenues and Expenditures. This process is outlined in Appendix P: Internal Service Activities of the Chart of Accounts.

Results:

Error Warning Code

253

Status

Active

Tier

1

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

(Warning) In Fund 21, the sum of Balance Sheet Codes 8171, 8172, 8173, 8181 and 8182 should equal the sum of Balance Sheet Code 6710.

Helpful Hint

Balance Sheet Code 6710 is classified as a Non-Spendable fund balance account, this should equal the sum of Balance Sheet Codes 8171, 8172, 8173, 8181 and 8182.

Results:

Error Warning Code

256

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

Error: Location Codes 100-599 and 900-969 cannot be accepted with a blank unique school code, School Code 0000, or school code 9980, if Object Code is 0001-0999.

Helpful Hint

Location codes 100-599 and 900-969 are school location codes, District schools must use this location codes with a valid school code. The List of Colorado Schools and codes is available here.

Results:

Error Warning Code

257

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund Code 06 with amount not = 0, cannot be used by this district.

Helpful Hint

Fund 06 is the Supplemental Capital Construction, Technology and Maintenance Fund must be used by district with a Mill Levy for these purposes. Your district is listed on the Mill Levy Table with these Mills, therefore Fund 06 or 46 must be used.

Results:

Error Warning Code

258

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund Code 46 with amount not = 0, cannot be used by this district.

Helpful Hint

Fund 46 is the Supplemental Capital Construction, Technology and Maintenance Fund must be used by district with a Mill Levy for these purposes. Your district is listed on the Mill Levy Table with these Mills, therefore Fund 06 or 46 must be used.

Results:

Error Warning Code

260

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 46 can only be used by allowed districts.

Helpful Hint

Fund 46 is the Supplemental Capital Construction, Technology and Maintenance Fund must be used by district with a Mill Levy for these purposes. Your district is listed on the Mill Levy Table with these Mills, therefore Fund 06 or 46 must be used.

Results:

Error Warning Code

261

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Fund 06 can only be used by allowed districts.

Helpful Hint

Fund 06 is the Supplemental Capital Construction, Technology and Maintenance Fund must be used by district with a Mill Levy for these purposes. Your district is listed on the Mill Levy Table with these Mills, therefore Fund 06 or 46 must be used.

Results:

Error Warning Code

264

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

District must report, Unique School Code 7233, Source 6000-6999, amount > 0.

Helpful Hint

School Code 7233 is assigned to Rocky Mountain Prep within District Code 0180 APS, A Fund Balance within Source 6000-6999 must be reported.

Results:

Error Warning Code

267

Status

Active

Tier

1

Type

Warning

Data Element Name

School Code

Error / Warning Message

(Error) Only unique school codes assigned to the district may be used by the district: Excludes Unique School Code (0000, 7233, 9980).

Helpful Hint

A valid School Code must be reported by the District/BOCES. The List of Colorado Schools and codes is available here.

Results:

Error Warning Code

268

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Error: Object Codes 0700-0729, 0750-0799 can only be used with Program Codes 4000-4999.

Helpful Hint

Object Codes 0700-0729, 0750-0799 include Property, Land, Buildings, Loss, Infrastructure and Lease, these expenditures must be coded with program codes 4000-4999 Facilities Acquisition and Construction Services.

Results:

Error Warning Code

269

Status

Active

Tier

1

Type

Error

Data Element Name

Location Code

Error / Warning Message

For each location code 461-469 reported, there must be at least one salary account Object 0100-0199 reported.

Helpful Hint

Location codes 461 - 469 are considered online school/program location codes. These locations are required to include Salary Activity in object code 0100-0199. The Districts using online location codes must be approved for use by the Office of Online and Blended Learning, the listing on approved locations is available here.

Results:

Error Warning Code

270

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

[Please Verify] DEPRECIATION ACCOUNTS - Object Code 0740. Please verify that the Depreciation Account is used with an appropriate program code.

Helpful Hint

Confirm the amount reported as Object Code 0740 Depreciation with the amount that is reported in your Financial Audit.

Results:

Error Warning Code

271

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source Code 6723 District Emergency Reserve can only be used by approved districts.

Helpful Hint

Source Code 6723 District Emergency Reserve is currently only approved to be used by District 0880 Denver.

Results:

Error Warning Code

273

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Small Attendance Center: If Object 0001-0999, grant 3170 < Source 3000, grant 3170, you must report Balance Sheet 7482, grant 3170, amount = Source 3000, Grant 3170 - Object 0001-0999, Grant 3170.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

274

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

ELPA: If Object 0001-0999, grant 3140 < Source 3000, grant 3140, you must report Balance Sheet 7482, grant 3140, amount = Source 3000, Grant 3140 - Object 0001-0999, Grant 3140.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

275

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Gifted and Talented: If Object 0001-0999, grant 3150 < Source 3000, grant 3150, you must report Balance Sheet 7482, grant 3150, amount = Source 3000, Grant 3150 - Object 0001-0999, Grant 3150.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

276

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Special Education (ECEA): If Object 0001-0999, grant 3130 < Source 3000, grant 3130, you must report Balance Sheet 7482, grant 3130, amount = Source 3000, Grant 3130 - Object 0001-0999, Grant 3130.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

277

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

READ Act: If Object 0001-0999, grant 3206 < Source 3000, grant 3206, you must report Balance Sheet 7482, grant 3206, amount = Source 3000, Grant 3206 - Object 0001-0999, Grant 3206.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

278

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 with Grant 3170 must be >, = Object Code 0001-0999 with Grant 3170.

Helpful Hint

Grant Code 3170 is considered a Categorical grant, reporting of Expenditures are required.

Results:

Error Warning Code

279

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 with Grant 3140 must be >, = Object Code 0001-0999 with Grant 3140.

Helpful Hint

Grant Code 3140 is considered a Categorical grant, reporting of Expenditures are required.

Results:

Error Warning Code

280

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 with Grant 3150 must be >, = Object Code 0001-0999 with Grant 3150.

Helpful Hint

Grant Code 3150 is considered a Categorical grant, reporting of Expenditures are required.

Results:

Error Warning Code

281

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 with Grant 3130 must be >, = Object Code 0001-0999 with Grant 3130.

Helpful Hint

Grant Code 3130 is considered a Categorical grant, reporting of Expenditures are required.

Results:

Error Warning Code

282

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 with Grant 3206 must be >, = Object Code 0001-0999 with Grant 3206.

Helpful Hint

Grant Code 3206 is considered a Categorical grant, reporting of Expenditures are required.

Results:

Error Warning Code

283

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Expelled and At-Risk: If Object 0001-0999, grant 3183 < Source 3000, grant 3183, you must report Balance Sheet 7482, grant 3183, amount = Source 3000, Grant 3183 - Object 0001-0999, Grant 3183.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

284

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Comprehensive Health Education: If Object 0001-0999, grant 3190 < Source 3000, grant 3190, you must report Balance Sheet 7482, grant 3190, amount = Source 3000, Grant 3190 - Object 0001-0999, Grant 3190.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

285

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

(Error) ELPA: If Source 3000 or Source 3951-3959, grant 3140 is reported, then Object 0001-0999, Grant 3140 must be reported.

Helpful Hint

Grant code 3140 requires the reporting of expenditures to be equal to or greater than the revenues. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue for that grant. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

286

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

(Error) Small Attendance Center: If Source 3000 or Source 3951-3959 , Grant 3170 is reported, then Object 0001-0999, grant 3170 must be reported.

Helpful Hint

Grant code 3170 requires the reporting of expenditures to be equal to or greater than the revenues. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue. for that grant.

Results:

Error Warning Code

287

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

(Error) Gifted and Talented: If Source 3000 or Source 3951-3959, Grant 3150 is reported, then Object 0001-0999, Grant 3150 must be reported.

Helpful Hint

Grant code 3150 requires the reporting of expenditures to be equal to or greater than the revenues. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.for that grant.

Results:

Error Warning Code

288

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

(Error) ECEA: If Source 3000 or Source 3951-3959, Grant 3130 is reported, then Object 0001-0999, Grant 3130 must be reported.

Helpful Hint

Grant code 3130 requires the reporting of expenditures to be equal to or greater than the revenues. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue . If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.for that grant.

Results:

Error Warning Code

289

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

(Error) READ Act: If Source 3000 or Source 3951-3959, Grant 3206 is reported, then Object 0001-0999, Grant 3206 must be reported.

Helpful Hint

Grant code 3206 requires the reporting of expenditures to be equal to or greater than the revenues. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.for that grant.

Results:

Error Warning Code

290

Status

Active

Tier

1

Type

Error

Data Element Name

Amount

Error / Warning Message

Error: Fund 21, Source Code 5200-5299, amount cannot be less than zero.

Helpful Hint

Source 5200s are considered a Transfer account, Fund 21 cannot accept transfers out of the fund, per Federal Regulations. See the Borrowing of Funds section listed in the FPP Handbook.

Results:

Error Warning Code

291

Status

Active

Tier

1

Type

Error

Data Element Name

Grant/Project Code

Error / Warning Message

(Error) Foster Care: If Source 3000 or Source 3951-3959, Grant 3243 is reported, then Object 0001-0999, Grant 3243 must be reported.

Helpful Hint

Grant code 3243 requires the reporting of expenditures to be equal to or greater than the revenues. If your grant revenue is higher than your grant expenditures, you may need to book a Grants Deferred Revenue. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 for that grant.

Results:

Error Warning Code

292

Status

Active

Tier

2

Type

Warning

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Source 3000 with Grant 3243 must be >, = Object Code 0001-0999 with Grant 3243.

Helpful Hint

Grant Code 3243 is considered a Categorical grant, reporting of Expenditures are required.

Results:

Error Warning Code

294

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Object 0868, Overhead Costs, cannot be accepted with Fund 21.

Helpful Hint

Object code 0868 is for the recording of overhead costs with local or state grant codes, it cannot be accepted with federal grant codes 4000-9999.

Results:

Error Warning Code

295

Status

Active

Tier

1

Type

Error

Data Element Name

Fund Code

Error / Warning Message

Object 0869, Indirect Costs, amount must be less than zero, with Grant Code 0000, except for Fund 21.

Helpful Hint

Object code 0869 is for the recording of indirect costs with federal grant codes 4000-9999, it cannot be accepted with local or state grant codes. It is allowed in grant code 0000 within Funds 10 and 21.

Results:

Error Warning Code

296

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Object 0869, Indirect Costs, must be greater than zero, with grant codes 4000-9999.

Helpful Hint

Object code 0869 is for the recording of indirect costs with federal grant codes 4000-9999, it cannot be accepted with local or state grant codes. It is allowed in grant code 0000 within Funds 10 and 21.

Results:

Error Warning Code

303

Status

Active

Tier

1

Type

Warning

Data Element Name

Location Code

Error / Warning Message

For BOCES, Location Codes 100-599 and 900-969 cannot be accepted with a blank unique School Code, School Code 0000, or School Code 9980 If Object Code is 0001-0999. The BOCES has 407 instances of using Unique School Code 0000 with a location code of 100-599 and 900-969 with Object Code of 0100-0999. It is up to the BOCES to review all instances of this type.

Helpful Hint

A valid School Code must be reported by the District/BOCES. The List of Colorado Schools and codes is available here.

Results:

Error Warning Code

304

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

READ Act: If Object 0001-0999, grant 3206 < Source 3000, grant 3206, you must report Balance Sheet 7482, grant 3206, amount = Source 3000, Grant 3206 - Object 0001-0999, Grant 3206.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

305

Status

Active

Tier

2

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

Small Rural Funding: If Object 0001-0999, grant 3230 < Source 3000, grant 3230, you must report Balance Sheet 7482, grant 3230, amount = Source 3000, Grant 3230 - Object 0001-0999, Grant 3230.

Helpful Hint

The grant listed is required to have expenditures reported equal or greater than the revenues reported. If expenditures are less than the revenues the district will need to report an unearned revenue for the grant reducing the revenues to equal expenditures and recording this entry with balance sheet code 7482 unearned revenue.

Results:

Error Warning Code

306

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

If a district reports Fund 90, Balance Sheet Code 7511, they must also report Object Code 0913, amount > or = to zero. Please review your independent audit to ensure you are reporting Capital Lease Payments if applicable.

Helpful Hint

Object Code 0913 may be required by your district, Review the Capital Lease section of your Audit notes to determine the amount required to be reported.

Results:

Error Warning Code

307

Status

Active

Tier

1

Type

Error

Data Element Name

Object/Source/Balance Sheet Code

Error / Warning Message

The GO Bonds Payable amount you are transmitting is the same as last year (amount > zero).