Questions, Comments, or Corrections? Let us know!

Should the AFR flat file (csv) generated by my financial software be opened to review before uploading into AFR System?

No, this file should not be opened.  If revisions need to be made to your financial data, make those changes through your software in order to generate a new csv file to upload.

If this csv file is opened in a program such as Excel, the data will be reformatted and will not be recognized by the AFR Upload System.



I got errors on the AFR Upload. How do I resolve these errors so I can upload?

There are several possible issues –

  • Corrupt File: The  AFR Flat File might be corrupt or not formatted correctly. Re-upload a new csv file from your financial software.
  • Invalid Account Codes:  An invalid account code appears in your csv upload file.
    • Compare the list generated in the error message to the NDE master list.
      • If the account code appears in the NDE Master List, send an email to janice.eret@nebraska.gov.
      • If the account code doesn’t not appear in the NDE Master List, you will need to find a code on the NDE Master List that will fit your purpose.  You also may have to contact your vendor if you are unable to make the correction.
  • Invalid Agency IDs:  District or School ID number do not match NDE’s school ID numbers.


Can we upload a separate file for the funds that are not in our financial software?

The AFR System has been programmed so that each time a file is uploaded into the AFR System, the previous file information is overwritten.  Therefore, all of the information must be contained in one file to upload.  If some of your funds are not included in your financial software,  ask your software vendor to help you enter year-end totals into the appropriate disbursement object codes and revenue codes.  Next year, you should have all of your funds brought into your financial software.



Do all of our fund’s transactions have to be included in the AFR Upload System?

Yes.  The AFR flat file (generated by your software to upload into the AFR) must include financial transactions for all district funds.  If some of your funds are not included in your financial software, ask your software provider to help you enter year-end totals in each of the appropriate revenue codes and disbursement object codes for those funds.   When the 2019/20 year begins, each transaction should be entered for all funds.