Creating Upload Files

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 Name

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