Creating Upload Files

Model Chart of Accounts

NEO-FS Upload File Format

File and Folder Names

  1. BudgetRevenue.txt
  2. BudgetExpenditure.txt
  3. BudgetBalanceSheet.txt
  4. ActualRevenue.txt
  5. ActualExpenditure.txt
  6. ActualBalanceSheet.txt

File formats: Tab Separated Value. In Excel select Save as

Text (Tab delimited) (*.txt)

Header - First line in each file should have

SAU ReportName RecordCount DateTime
1000 BudgetRevenue 967 04/15/2025 12:00:00 AM

File Naming Convention & Types

Format

BudgetRevenue.txt 
SAUCode FiscalYear Quarter FundCode RevenueCode Title Amount

BudgetExpenditure.txt
SAUCode FiscalYear Quarter FundCode ProgramCode FunctionCode ObjectCode CostCenter Title Amount

BudgetBalanceSheet.txt
SAUCode FiscalYear Quarter FundCode BalanceSheetCode Title Amount

ActualRevenue.txt
SAUCode FiscalYear Quarter FundCode RevenueCode Description Amount

ActualExpenditure.txt
SAUCode FiscalYear Quarter FundCode ProgramCode FunctionCode ObjectCode CostCenter Title Amount

ActualBalanceSheet.txt 
SAUCode FiscalYear Quarter FundCode BalanceSheetCode Title Amount

Data types are as follows:

  • Amount = up to 10000000000.00 10 Billion with two decimal places and no comma separators,
  • BalanceSheetCode = 4 Digit Numeric
  • CostCenter = 2 Digit Numeric (01, 02, 03, 04, 99)
  • Title = 200 Char Text without tabs in them (Support expenditures purchased services students)
  • FiscalYear = 4 Digit Numeric (07/08 would be 2008)
  • FunctionCode = 4 Digit Numeric
  • FundCode = 3 Digit Numeric
  • ObjectCode = 4 Digit Numeric
  • ProgramCode = 4 Digit Numeric
  • Quarter = 2 Digits Numeric (01, 02, 03, 04)
  • Revenue Code = 4 Digit Numeric
  • SAUCode = 4 Digit Numeric 1000-9999

Back to top