In this lesson you will learn how to do the monthly budget spreadsheet with percents.
Navigation: There are multiple menu paths for this procedure. This lesson will use the Budget menu path.
Accounting > Inquiries & Reports > Budget Reports > Monthly Budget Spreadsheets > Monthly Budget Spreadsheet with Percents
Budget > Inquiries & Reports > Budget Reports > Monthly Budget Spreadsheets > Monthly Budget Spreadsheet with Percents
Click the State of Nebraska link.Step 1
Click the Budget link.Step 2
Click the Inquiries & Reports link.Step 3
Click the Budget Reports link.Step 4
Click the Monthly Budget Spreadsheets link.Step 5
Click the Monthly Budget Spreadsheet with Percents link.Step 6
Choose the appropriate version by clicking the check box next to it.
Click the NIS0004 option.Step 7
Click the Data Selection option.Step 8
Click the Submit button.Step 9
Warning: Do not change the Left Operand field on any existing data selection lines.
Leave the first two rows (Object Account and Ledger Types) as is.Step 10
Click the Right Operand list of the third row (Agency Number).Step 11
Click the Literal list item.Step 12
Enter the three digit agency number into the Literal Value: field.
For this lesson enter "065".Step 13
Click the OK button.Step 14
If applicable complete the following:
In the fourth row (Agency Division), complete the following:
Right Operand - enter the 3-digit division number
In the fifth row (Program Number), complete the following:
Right Operand - enter the 3-digit program number
In the sixth row (Agency Subprogram), complete the following:
Right Operand - enter the subprogram number
In this lesson we are not going to complete any of these rows.Step 15
Click the OK button.Step 16
The Processing Options allows you to enter the Fiscal Year.
In this lesson we are not going to change the Fiscal Year.Step 17
Click the OK button.Step 18
To run the report in CSV format click the Document Setup tab.Step 19
Click the OK button.Step 20
Click the Close button.Step 21
To view the report you will need to go to View Job Status. For more information go to the Reports Lesson under the System Basics work instructions.
You have successfully completed this lesson.
Table of Contents Start Topic