PowerSchool ERP Budget Preparation

Update Project Budget - Administrator Page


This is the main page associated with the Display Budget option in the Budget Administrator center's Project section. The page has two sections: Search Criteria and Worksheet. The worksheet lets you view and update budget data for the ledger accounts selected in a search.

Through this central page, you can also perform the following actions:

  • Add new Project Ledger accounts.

  • Delete ledger accounts that are not needed.

  • Access and update existing records in the Detail page.

  • Add notes or itemize accounts in the Notes page.

  • Print the data from the worksheet.

Important

Finish importing data from Fund Accounting before deleting any Project Ledger accounts. This way, you can avoid re-extracting data you do not want.

Menu Path:  Budget Preparation > Entry & Processing > Budget Preparation > Budget Administrator > click Display Budget option in the Budget Administrator center's Project section

Action Bar Item

After you display ledger records, the following item becomes available on the Action Bar:

Details

Displays the Details page, which lists the full budget record for a selected Project Ledger account. This page includes all the fields available in the worksheet, plus the account's other budget fields. For information, refer to Detail Page.

Using the Worksheet

The Update Project Budget - Administrator page's worksheet is designed so you can quickly move from one ledger account to the next, updating the budget figures along the way. The worksheet displays the following data for each ledger account:

  • Budget amounts saved at the Requested, Recommended, Approved, and Future Year levels.

  • Codes and descriptions for the ledger account's Project List and Account List records.

  • Approval level where the ledger account's budget figures are frozen.

Use the following keystrokes to move within the worksheet:

  • Up or Down Arrow: Moves you up or down by one row within a column.

  • <Tab>: Moves you to the next column in a row, then to the next row.

  • <Shift + Tab>: Moves you to the previous column in a row.

  • Page Up or Page Down: Displays the next or previous page of accounts.

Applying Budget Projections

You can apply budget projection percentages to your Project Ledger accounts if these percentages are established in the Project List and Account List. To do so, use the Apply/Move Budget option in the Budget Administrator center's Project section.

This option lets you apply budget increases and decreases to selected ledger accounts at the Requested, Recommended, or Future Year level. You also use this option to move budget figures from the Current Year field in the project budget worksheet to the Requested field.

For information, refer to Apply Budget Option.

Moving Budget Figures

You also use the Apply/Move Budget option to copy ledger account data from one set of approval level fields to the next in the project budget worksheet. For example, you can copy data for selected ledger accounts from the Requested level to the Recommended level or from the Recommended level to the Approved level.

For information, refer to Move Budget Option.

Displaying Iteration Data

Above the worksheet, the system displays the current iteration and phase loaded at each standard approval level for the account currently being accessed. The iteration information only appears if records are set up in Budget Preparation's Iterations and Phases tables.

Note that the iteration data can change from account to account if there are different iterations loaded for different accounts.

Saving, Loading, and Editing Iterations

The Budget Administrator center includes the following options for working with iterations at the Requested, Recommended, and Approved levels:

  • Save Iteration - Enables you to save selected accounts to an iteration.

  • Load Iteration - Enables you to load selected accounts from an iteration.

  • Edit Iteration - Enables you to change selected accounts within an iteration

For information, refer to Iteration Options.

Following are the procedures for updating, deleting, and printing ledger records in the worksheet. For information on adding ledger accounts, refer to Add Ledger Entry Page.

Updating Project Ledger records

  1. Select Budget Preparation > Entry & Processing > Budget Preparation > Budget Administrator to display the Budget Administrator center.

  2. Click Display Budget in the Project section to display the Update Project Budget - Administrator page.

  3. In the Search Criteria section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.

  4. Update account data in the budget fields, changing amounts as needed. For information on individual fields, refer to the Fields section.

    • Click Details on the Action Bar to display the Detail page, which accesses an account's full budget record.

    • Click Notes on the toolbar to display the Notes page, where you can itemize an account's individual amounts or enter notes.

  5. Click OK to save the record.

Deleting Project Ledger records

  1. Select Budget Preparation > Entry & Processing > Budget Preparation > Budget Administrator to display the Budget Administrator center.

  2. Click Display Budget in the Project section to display the Update Project Budget - Administrator page.

  3. In the Search Criteria section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.

  4. Select the record you want to delete.

  5. Click Delete.

  6. In the confirmation dialog, click Yes to delete the record.

Generating the Project Budget List report

  1. Select Budget Preparation > Entry & Processing > Budget Preparation > Budget Administrator to display the Budget Administrator center.

  2. Click Display Budget in the Project section to display the Update Project Budget - Administrator page.

  3. In the Search Criteria section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.

  4. Click OK.

  5. Click Print on the toolbar.

  6. In the Print window, specify how to generate the report, and then click OK. The report's default file name is budget_list.rpt.

Fields

Following are descriptions of the fields associated with the worksheet. The first description is for the display-only field directly above the worksheet. This field only appears if there are records in Budget Preparation’s Budget Iterations and Phases tables.

Fields

Description

Active Iteration/Phase

Codes identifying the iterations and phases of the account currently accessed for each of the three standard approval levels: Requested, Recommended, and Approved. If no iteration is loaded for a level, then NONE displays.

*Project*


Code identifying the low-level Project Ledger record that applies to this account. The title is defined in the Budget Preparation Profile. Display only.

Account

Code of the Account List record that is being used in combination with the project code to identify the account. Display only.

Requested Base

Core Amount budgeted for this ledger account in the upcoming year at the first standard approval level. A base amount is any amount that was also included in last year’s budget. The requested level signifies the amount that a department is requesting for the new year. Decimal/12,2

You can enter the amount or use the Apply/Move Budget option to calculate it. For information, refer to Apply Budget Option.

Tip

You also can use Notes on the toolbar to update this field. For information, refer to Notes Page.

Requested New

Amount your department is requesting for next year that was not included in last year’s budget. Decimal/12,2

Recommended Base

Core amount budgeted for this ledger account in the upcoming year at the second standard approval level. Decimal/12,2

A base amount is any amount that was also included in last year’s budget. The recommended level signifies the amount that has gone through the initial level of approval.

You can enter the amount or use the Apply/Move Budget option to calculate it. For information, refer to Apply Budget Option.

Recommended New

Amount for this ledger account that was not included in last year’s budget and has gone through the initial level of approval.

Approved Base

Core amount budgeted for this ledger account in the upcoming year at the final standard approval level. Decimal/12,2

A base amount is any amount that was also included in last year’s budget. The approved level signifies amounts that have gone through final approval and are ready for posting to Fund Accounting.

You can enter the amount or use the Apply/Move Budget option to move the value from the Recommended level to the Approved level. For information, refer to Move Budget Option.

Approved New

Amount for this ledger account that was not included in last year’s budget and has gone through the final level of approval. Decimal/12,2

Important

The system combines the Approved Base and Approved New values when the budget is posted to Fund Accounting.

2nd Year - 5th Year

Projected budget amounts for each of the four years following the budget year. Decimal/12,2

You can use the Apply/Move Budget option to calculate the estimates based on Future Year percentages in Budget Preparation’s Organization Chart and Account List. For information on calculating estimates, refer to Apply Budget Option.

Freeze

Selection determining the approval level where the ledger account’s budget figures are frozen.

Select:

N - Not Frozen
D - Requested Level
R - Recommended Level
A - Approved Level
F - Future Level

When data is frozen, it cannot be overwritten with the Apply/Move Budget option. If needed, you can update frozen ledger accounts in the Update Project Budget - Administrator page.

*Task* Title

Full description of the low-level Project Ledger record associated with this account. The description also appears below the worksheet. Display only.

Account Title

Full description of the Account List record that is being used in combination with the low-level project to identify the account. The description also displays below the worksheet. Display only.