Budget
The Budget form allows you to enter projected revenue and expense amounts by business unit for a fiscal year or, by fiscal period, to facilitate reporting comparisons. You can also use actual income and expense data from prior fiscal periods or budget figures from a prior period to build projections for planning and monitoring the agency's financial goals.
Creating a New Budget
-
Open the Financial Center.
-
In the sidebar menu click Views > Budgets.
-
Click New Budget on the toolbar.
Complete the fields as indicated in the table below, and then click Create Budget.
| Field/Option | What is this? | ||||||||
|---|---|---|---|---|---|---|---|---|---|
|
Division |
Select the division for which you want to create a budget. This is a required field. This selection is only visible if Use Different Fiscal Years by Division is checked in Agency Setup. If you have divisions with different fiscal year ends you need to prepare and save budgets for each division separately. |
||||||||
|
Fiscal Year |
Select a fiscal year from the list for which you want to create a budget. This is a required field. |
||||||||
|
Description |
Type in a descriptive name for the budget, such as 2005 Budgets. This is a required field. |
||||||||
|
Budget Setup Options |
|
||||||||
|
Create Budget |
Click this button to populate the Budgets for Fiscal Year by [Activated Business Units] section.
Sample results after clicking the Create Budget button in the Budget Setup Information section:
|
- After clicking Create Budget to create a row in the Budgets for Fiscal Year by [Activated Business Units] section grid for each business unit combination, only those business unit combinations for which you have security access appear in the grid.

- Each row of the grid contains the following information.
| Field | What is this? |
|---|---|
|
Status |
For a newly created budget, the status is In Progress. As budgets are completed for a business unit combination, select Completed from the status list. |
|
Business Unit |
A column appears in the grid for each activated business unit combination (division, branch, department, and/or group) as defined in Business Unit Setup. |
- Highlight a row in the grid and click Edit to open the budget grid for a business unit combination to allow for adjustment of account amounts.
Use this section to enter budget amounts, by fiscal period, for each general ledger income and expense account for which you want budget comparisons.
When edits are complete, click Update on the section menu to retain changes.
Grid Elements
In completing the Budget Setup Information section, if you selected either Copy from Actual or Copy from Budget, data is displayed in the following grid columns based on the selected base year. If you selected New Blank Budget the columns are empty:
| Column | What is this? | ||||||||
|---|---|---|---|---|---|---|---|---|---|
|
Select |
Check this box to select a row and apply an adjustment using the Select grid rows and adjust budget amounts option. |
||||||||
|
GL # |
General ledger account number. A grid row appears for each active income and expense account. |
||||||||
|
GL # Description |
Description for the general ledger account number (Account Name). |
||||||||
|
Prior Year Columns |
|
||||||||
|
Amount |
Total of amounts allocated across the fiscal period columns. |
||||||||
|
(P1) Jan (P2) Feb (P3) Mar (P4) Apr (P5) May (P6) June (P7) July (P8) Aug (P9) Sept (P10) Oct (P11) Nov (P12) Dec |
Fiscal period columns. Amount entered is applied as the budget comparison amount for identified account, business unit combination, and month of the fiscal year. |
In Edit mode, there are two main methods for entering budget data. You can use either or both methods in combination to enter data into fiscal period (P1Jan) amount fields. The Select Grid Rows and Adjust Budget Amounts method described below can streamline data entry by building on available data rather than entering all amounts individually.
Use these options to adjust data for selected grid rows. To apply an adjustment:
- Check the Select box on each row to be adjusted.
- Select to use the Prior Year, Increase or Decrease method to adjust the amounts.
- Click Adjust.
The action selected is applied only to rows with a check mark in the Select column.
Example You may want to budget a 5% increase in selected revenue accounts. You may also want to budget a 3% decrease in selected administrative expense accounts and a 2% increase in employee salary expense. Perform each of these adjustments in a separate selection/adjustment step. Click Save after each adjustment to preserve your changes.
Adjustment options are:
| Option | What is this? |
|---|---|
|
Copy Prior Year to Fiscal Period amounts on selected rows |
Use this option to populate fiscal periods (P1, P2...) for selected rows based on Prior Year data for the year selected from the list. Using this option helps to reduce the amount of keying required to populate the period columns. |
|
Increase Fiscal Period amounts in selected rows by % |
Enter an amount of percentage increase to be applied to selected rows. |
|
Decrease Fiscal Period amounts in selected rows by % |
Enter an amount of percentage decrease to be applied to selected rows. |
In (section) Edit mode you can always type an amount into a fiscal period field. Right-click the mouse to pop up a shortcut menu with copy/paste features useful for copying an amount across the row.
In addition you can highlight a row and click Edit on the section menu to open an individual account row in edit mode.
Opening an individual account row in edit mode displays the following data entry fields:
Due to the length of the Budget grid you must scroll down to the bottom of the page to access the edit fields.
| Field | What is this? | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Business Unit |
Displays the business unit combination for the selected row so you can confirm you are editing the correct unit combination. This is a display-only field. |
||||||||||
|
GL Number |
Displays the selected general ledger account number. This is a display-only field. |
||||||||||
|
Amount |
Displays the sum of all fiscal period budget amounts. This is a display-only field. |
||||||||||
|
Budget Total |
Displays the total of budget amounts allocated to this general ledger account number for all business unit combinations in the budget. |
||||||||||
|
% of Budget Total |
Display-only field containing result of Amount divided by Budget Total displayed as a percent. This field tells you what percentage of the overall budgeted total for this account is budgeted to the current business unit selection. |
||||||||||
|
Data Entry Amount |
This field opens in edit mode as empty. Enter a number to be divided or copied to all Fiscal Periods. You can also enter the desired total, and then manually fill each fiscal period field. |
||||||||||
|
(P1) Jan (P2) Feb (P3) Mar (P4) Apr (P5) May (P6) June (P7) July (P8) Aug (P9) Sept (P10) Oct (P11) Nov (P12) Dec |
Data entry fields for each fiscal period. Fields default filled with existing budget amounts (amounts already entered or allocated through Select Grid Rows and Adjust Budget option).
|
||||||||||
|
Data Entry Command Buttons |
Use the following buttons as tools to speed up the data entry process:
|
||||||||||
|
Remaining to Apply |
Compares the total of the fiscal period amounts to the Data Entry Amount and displays the difference, if any. This field should be zero before updating the row. |
As edits are completed on each business unit row you should change the Status column on the row to Completed. In this way, if you Save & Close the budget to return to it later, you know where you left off in the editing process.