OperatingBudgetManual2015

Operating Budget Manual – August 2010

f) As a sub-object is entered, the sub-object name will appear in row 6. If the name does not appear and/or you get an “invalid sub-object” error, it is because you typed an invalid code or because the code was entered as a number. To quickly confirm the entry is text, put a single quote (‘) in front of the code. g) Be sure you do not duplicate sub-object codes. The template will allow this but when you try to upload the file you will receive a fatal error. h) Be sure you do not skip columns or insert blank columns into the data. i) Any extra columns in the template (on the right) can be deleted or just left in case they are needed later. c) All allocations must be in whole dollars – no cents! Use the ROUND() function in formulas to round to zero decimal places. The upload will still complete but all decimals are truncated and the files total allocation will not match the target allocations. d) If necessary you may need to add extra rows in each fund section and add additional accounts within the section. i) Be sure to include the fund and account. ii) Copy all formulas to new rows. iii) Delete any extra rows. iv) Preserve the control total/test area at the bottom of each fund section. v) If you are not using a fund section, just ignore it or hide the rows. Please do not delete the rows, in case it is needed later. e) Be sure there are no duplicate fund/account combinations. f) Be sure the account format is correct. The account should be 8 characters (account 6, sub-account 2), with no spaces or extra zeros. g) Be sure that all accounts used are valid in the chart of accounts. h) Make sure you are not trying to load to a master account where the account is sub-accounted. i) For each fund, be sure the total in your financial plan matches the campus’ target allocation. Use the form at the bottom of each fund section to help you verify this. If the aggregate totals from your upload file do not match your target, by fund, you will not be able to finalize the upload in the web application. 5) Save the template file (from step #2 above). 4) Enter data into the template. Some things to remember… a) Be sure your 5 digit campus id is entered into the cell B5. b) Be sure not to insert columns into the template.

57