OperatingBudgetManual2015

Operating Budget Manual – August 2010

I received an error message when I tried to upload my file - error messages and what they mean… Fatal – there are a few errors that will cause the whole upload process to fail. These are called “fatal” errors. Spreadsheet is not correct Campus Campus id in the csv file (cell B5) does not agree with the campus the user is logged into in the Portal

There are duplicate rows with the same fund and account (in the first two columns in the template) – you will receive a complete list of these errors. There are two columns in the file that have the same sub-object code. The error message will include a list of all duplicate sub-objects.

Duplicate fund/account encountered

Duplicate sub-object

Columns with data but no sub-object code.

Missing sub-object code

Critical - After it is determined there are no fatal errors, there are several checks run against the data and if these checks result in errors, the file can be uploaded but not finalized until the errors are fixed. These are called “critical” errors. Some include:

Account number is not valid for the upload campus and fiscal year – chart of accounts The account number used is linked to a specific fund in the chart of accounts and the fund used in the template does not agree with the chart of accounts the account has sub-accounts but the Form 1 is loading to a master account

Invalid Account Number

Input Fund not equal Chart Fund 00300

Allocation to Master Account Invalid - User 99 ACT

Targets do not match

Uploaded data totals by fund do not match targets.

Warnings – inconsistency in the data that might be valid. The file can still be finalized. Warning: $$ missing for 0000 object In this fund/account there is FTE for sub-object 0000 - Non-instructional PSR, but there are no dollars allocated to sub-object 0000

In this fund/account there is FTE for sub-object 0400 - Instructional PSR, but there are no dollars allocated to sub-object 0400 In this fund/account there are dollars for sub-object 0000 – Non- Instructional PSR, but there are no FTE allocated to sub-object 0000 In this fund/account there are dollars for sub-object 0400 - Instructional PSR, but there are no FTE allocated to sub-object 0400

Warning: $$ missing for 0400 object

Warning: FTE missing for 0000 object

Warning: FTE missing for 0400 object

65