Enter Budget Tab

This tab is used to review worksheets, enter proposed preliminary amounts as a baseline, enter or update proposed amounts, quickly see your budgeted, actuals, and variance amounts for revenues and expenses at the top of the worksheet, and review amounts for budgets.

Current & Historical Details

By default, the columns that will appear on the Enter Budget tab do not include actuals adjustments, variances, or historical intial budgets. If you would like to see additional information, will need to click the Column Selector button and add the content you want to see on the worksheet using the checkboxes.

Tip

Historical budget data is only available if it was related during the copy budget process.

If historical budget information exists, you can add or remove columns with details from previous budget years. Reviewing historical information can aid in determining what caused spending to be over or under budget in previous years, what a budget should be in a future year, or whether to approve a current year budget. You can chose to view the following:

Note

Budget information shown in the Current and Historical actuals sections varies according to your school's GL configuration year and not the budget's start or end dates.

How To

Add/Remove Line Items to the Budget

Worksheets and line items are added to the Enter Budget datasheet from the Set Up Worksheets tab. There you can add or remove from the worksheets.

Add Comments and Attachments

Click the Comments icon .
From the Comment popup, you can read the existing comments, mark them all as read, and add your own comments.
Click New comment and enter your text.
If you want to upload an attachment, click Attach, locate the file, then click Open.
Click Add to save your text and/or attachment.

Use the Column Selector

Most spreadsheets used in J1 Web provide the option to show or hide content related to the data being viewed. When viewing a details spreadsheet in J1 Web Finance, the Column Selector allows you to choose which columns and information should be shown on the spreadsheet. By default, the spreadsheets show the most relevant information, but you can choose the information you want to view.

Click the Column Selectoricon above the worksheet details.
The column selector appears on the right side of the page, in place of the filtering options. Spreadsheets may differ slightly depending on the columns and information available. Select the checkboxes of the columns to be added, and deselect the checkboxes of the columns you want removed.
The columns are automatically added or removed from the spreadsheet when you click Apply.
- Column Selector options do not persist, so if you leave the page after customizing the columns, you need to make your selections again.
- While you can select columns to include when you click the Download option, if you customize the columns on your spreadsheet prior to downloading the spreadsheet, the columns appear preselected on the Download to Excel pop-up.
When you are finished, close the Column Selector menu.

While column selectors may differ for each spreadsheet, their function remains the same. Select or deselect checkboxes next to the columns to determine which ones appear in the spreadsheet.

For example, the images below show two different pages in J1 Web Finance and the column options available. When working with the GL Transactions feature, the column selector shows several sections of information that can be viewed, while on the GL Account Activity tab, there's a more limited list of available columns.

Download to Excel

Select the checkboxes next to the rows you want to export.
From the Options drop-down, select Download to Excel. The Download to Excel pop-up opens.
Select options for the Excel format and data columns.
sidebar. Download to Excel Options
Workbook Creation Options: This option lets you choose how you want the data to be organized when it's exported. If you are exporting a large number of rows, you may want to separate the data into different worksheets or even workbooks. Once you select this option, the Separate (Sheets or Workbooks) By drop-down becomes available so you can choose the groupings for each worksheet or workbook.
Separate (Sheets or Workbooks) By: This field becomes available when you choose to organize your export into multiple worksheets or workbooks. In general, you'll have the option to separate the data based on the columns. You will only see options for the visible columns.
Notice
For example, if you are exporting a set of definitions, you might choose to organize the data into two workbooks: one for active definitions, and one for inactive definitions. Do this by selecting the "Active" column in this drop-down. All of your rows designated as active will be in one workbook, and the inactive ones in a separate workbook.
Workbook Format: This section lets you set some Excel display options for your data. For more information about each of these features, consult Microsoft Excel help.
Autofit columns: Fits column width to the data so that fields are not truncated.
Turn on filtering: Turns on the AutoFilter feature, which allows you to show only rows that meet your selected criteria.
Freeze Top Row: Your worksheet displays the column title in the first row by default. Selecting this option keeps the top row at the top so that as you scroll down through your data, the column headings remain displayed.
Show totals for numeric columns: This option will include the sum of a column of numbers at the bottom of that column.
Columns to Include: These options are specific to the page you are viewing, so they will vary. You will only see options for columns that you can see on the page. All of the columns are selected by default, but you can deselect any of the columns you don't want to include.
Click Download. Your .xlsx or .zip file is saved in the file location that you have set in your browser settings.