Since this is a short term loan, the repayment of interest and principal will be coded to different functions:

• The interest payment should be coded as 01-2-02510-835  (Function 2510 Fiscal Services, Object 835 Interest on Short Term Bond)
• The principal payment would be coded under 5000 Debt Services  (Function 5000 and Object 831 Redemption of Principal)

If this would have been a payment for a long term loan, the coding is would be in the same function-Debt Services:

• The interest payment would be 01-2-05000-835  (Debt Services Function Code and Object 832 Interest on Long-Term Debt)
• The principal payment would be 01-2-05000-831 (Debt Services Function Code and Object 831 Redemption of Principal)

This error message was generated because the information in the file has been corrupted.

The most common cause of this issue is due to the csv file  exported out of your financial software for uploading was likely opened (after it was created) in Excel instead of WordPad or NotePad.

If this file is opened in Excel, the account code string is read as a formula since there is a leading dash “-” in the account string.

We strongly recommend districts to not open their csv export file in order to avoid this issue.

If you need to open up your csv file, go into either WordPad or NotePad to find your file and open it through one of those programs.  Be sure the file name has .csv at the end to ensure that the file saves as a csv.

If these steps do not resolve this issue, contact your software vendor as soon as possible.

The Employee Benefit Fund (Fund 03) should be used for these types of expenditures so you’re not using spending authority out of the General Fund.

To record employee health insurance claims, use the object code series 28X (Health Benefits) and prorate the expenses among the different employee classes:

• 280 Non-Instructional Staff
• 281  Teacher/Professional Staff
• 282  Instructional Aides & Assistants
• 283  Substitute Teachers
• 284  Technical Staff
• 285  Superintendent/ESU Administrator
• 286  Professional Non-Certificated Staff

To record the payment of reinsurance premiums, use object code 340 (Other Professional Services).

There are a several possible reasons that this error is being generated after uploading your file:

1.  The Agency ID may be incomplete.  It should be appear in this format:  XX-XXXX-XXX   which is   “County Number” – “School Number” – “School/District Level”
2.  The Agency ID is not correct.   If your file does not include your specific Agency ID isn’t correct for your district, it will not be recognized by the system.
3.  An Agency ID for an Alternative, SPED, or Focus Program has been included in the AFR that was uploaded.   Since there is no membership associated with this programs, no expenditures can be reported with that Agency ID.  Expenditures for these schools/programs must be allocated back to the individual student’s originating school.

This was one of the updates made in the

(Districts were notified of this updated Master Code List through newsletters and various presentations.)  Along with several other changes in the coding, Energy related object codes were consolidated into two categories:

• 621  Utility Energy Services –  which includes the following:
  • Natural Gas
  • Bottled Gas
  • Oil
  • Electricity
  • Coal
  • Other Energy

• 626 Fuel – which includes the following:
  • Gasoline
  • Diesel
  • Propane
  • Other fuel

Since this funding is being direct deposited into your General Fund, a reversing entry can take care of that transaction.

This can be corrected by submitting a State of Nebraska W-9  & ACH Enrollment Form to set up direct deposit for state funding directly into the School Nutrition Fund.  This form is available at the bottom of the page at this:  https://www.education.ne.gov/fos/forms/

Submit the completed form to Paul Haas at paul.haas@nebraska.gov

Since this is a question from a small district, this staff member probably provides technology support for both instructional and administrative.

The appropriate function code would not be in the 1100s – Regular Instruction.  Code into one the following function codes.    You could allocate his salary based on the percentage of his time spent:

• 2230 Instruction-Related Technology
• 2580 Administrative Technology Services

Here is how you would determine the appropriate object code for this staff member:

• 114: Technical Staff – This would likely be used in districts that do not have a large separate staff to provide tech support for the district.
• 116: Professional Non-Certificated Staff – This would be used in large districts that have a separate staff that provides support for the district.  The person that is considered the Technology Director would be coded as 116.

The costs would be coded in the appropriate function code.  The following examples to help determine the correct codes:

• 1100:  if the retiring individual is considered Regular Education
• 1200:  if the retiring individual is considered Special Education, the function code would be in the appropriate 1200 code,
• 2120:  if retiring individual is the your guidance counselor

The object code depends on whether the district received State Board Approval for General Fund Expenditure Exclusion for these costs.

• 238:  “Voluntary Termination Agreements” if the district did receive State Board Approval for an Expenditure Exclusion
• 239:   “Early Retirement Contributions” if the district did not request State Board Approval for an Expenditure Exclusion

To see what object codes are available in all of the school district funds, view the Master Account Code List and using the filter function located on Row 1.

For example, to see all of the available codes in the General Fund for a specific function code (i.e. 2510 Fiscal Services), click the down arrow next to Account Code at the top of Column A,  enter 01-2-02510- into the “Search” box, and click “OK.”  All of the object codes under 2510 will appear.

To see all of the revenue codes available in the Activity Fund, enter 01-1-0 into the “Search” box and click “OK.”  All of the General Fund Revenue codes will appear.

To go back to the complete list of account codes, click the down arrow in Column A and click “Clear Filter.”

The disbursement functions available in the Activity Fund are 2900 – Other Support Services and 3200- Enterprise Operations.

The easiest way to see what object codes that are available in the all of the school district funds is by  viewing the Master Account Code List and using the filter function located on Row 1.

For example, to see all of the available disbursement codes in the Activity Fund, click the down arrow next to Account Code at the top of Column A and enter 05-2-0 into the “Search” box. To see all of the revenue codes available in the Activity Fund, enter 05-1-0 into the “Search” box.

The only function code available in the Employee Benefit Fund is 2900 Other Support Services  —  The appropriate function object code string to code this expense into the Employee Benefit Fund would be 03-2-02900-255.

Any costs related to your school nutrition fund must be coded to 3100 Food Services Operations.  Function Code 2190 is available for any costs that do not fit into the 3100 function code.

This project could be coded in either the General Fund (Fund 01), Depreciation Fund (Fund 02), or the Special Building Fund (Fund 08).   If this work is replacing an existing water cooler system, you could use the Deprecation Fund.  Otherwise, you’d use the General Fund or the Special Building Fund.

If you use the Deprecation Fund, you could use Function Code 2900 with Object Codes 450 Construction Services, 490 Other Purchased Property Services, 610 General Supplies, or 739 Other Equipment — depending on the specific expense.   The Depreciation Fund has only Function Code available — 2900.

If either the General or Special Building Fund are used, the code would be 4700 Building Improvements with the same Object Codes listed above.

If the Object Codes listed above don’t seem to fit your expenditures, use the Filter function on the Master Code List to see what Object Codes would be available in those particular funds.

The problem is with the Disbursement Function Code 2190.  The only Disbursement Function Codes that available are 2900 Other Support Services and 3200 Enterprise Operations.  Use the Filter Function in the top row of the Master Code List to see what codes are available to use in each fund.

Object Code 695 Indirect Cost Rate is only available in the School Nutrition Fund in following function codes:

• 3100 Food Service Operations
• 2190 Other Support Services

If you want to identify these costs in federal programs, you could use object code 890 Miscellaneous.  If other expenses are coded to object code 890, you may want to ask your software vendor how to add an identifier.