PowerSchool ERP Budget Preparation

Detail Page

Use this page to access the full budget record for a ledger account. The Detail page includes the following information:

  • Budgeted and actual amounts for the previous three fiscal years.

  • Budgeted, year-to-date, and projected amounts for the current fiscal year.

  • Base and new amounts at the three standard approval levels, Requested, Recommended, and Approved.

  • Projected amounts for four future years.

When you access an existing ledger account in the Detail page, you can add notes to the ledger record using the Action Bar's Notes item.

To display the Detail page, click the Details item on the Action Bar of any page where this item displays.

Fields

Fields

Description

*Budget Unit*


Code for the low-level Organization Chart record tied to this Revenue Ledger account. The field’s title is defined in the Budget Preparation Profile. Display only.

Account

Code for the revenue account tied to this Revenue Ledger record. Display only.

Active Iteration/Phase

Codes identifying the iteration and phase of the account currently accessed in the worksheet for each of the three standard approval levels: Requested, Recommended, and Approved. If no iteration is loaded for a level, then NONE displays. This field only appears if there are records in Budget Preparation’s Budget Iterations and Phases tables.

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 Revenue Budget - Administrator page.

Prior Year Budget (3rd, 2nd, and Prior Year)

Budget amounts for this ledger account in each of the past three fiscal years. Decimal/12,2

The system updates these fields based on history records in Fund Accounting and Budget Preparation. The update occurs when you run the New Budget Year extraction. The system updates these fields as follows:

  • Prior Year Budget equals the budget in Fund Accounting for this ledger account in the previous fiscal year.

  • 2nd Prior Year Budget and 3rd Prior Year Budget are updated based on the ledger account’s Budget Preparation record for the current fiscal year. The Prior Year and 2nd Prior Year Budget in the current year’s Budget Preparation record become the 2nd and 3rd Prior Year Budget for the record generated from the extraction.

Prior Year Actual (3rd, 2nd, and Prior Year)

Actual revenue amounts for this ledger account in each of the past three fiscal years. Decimal/12,2

The system updates these fields based on history records in Fund Accounting and Budget Preparation. The update occurs when you run the New Budget Year extraction.

The system updates these fields as follows:

  • Prior Year Actual equals the total revenues in Fund Accounting for this ledger account in the previous fiscal year.

  • 2nd Prior Year Actual and 3rd Prior Year Actual are updated based on the ledger account’s Budget Preparation record for the current fiscal year. The Prior Year and 2nd Prior Year Budget in the current year’s Budget Preparation record become the 2nd and 3rd Prior Year Budget for the record generated from the extraction.

Current Year Budget

Budget amount for this ledger account in the current fiscal year. Decimal/12,2

  • If you extracted original budget data from Fund Accounting, this field shows the original revenue budget posted for the ledger account in the current year.

  • If you extracted current budget data, the field shows the budget including any budget transfers and adjustments.

Current Year YTD

Actual year-to-date revenue amount for this Revenue Ledger account, as of the last extraction from Fund Accounting. Decimal/12,2

Current Year Estimate

Projected revenues for the current fiscal year based on the Current Year YTD value and percentage of the year completed. Decimal/12,2

The system calculates the estimate when you run the Apply Budget option at the Requested level. For information on the calculation, refer to Apply Budget Option.

Requested Base

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

A base revenue is any amount that was also included in last year’s budget. The requested level signifies the revenues that a department is requesting for the new year.

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

Note

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

Requested New Program

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

Recommended Base

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

A base revenue is any amount that was also included in last year’s budget. The recommended level signifies the revenues that have 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 Programs

Revenues for this ledger account that were not included in last year’s budget and have gone through the initial level of approval. Decimal/12,2

Approved Base

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

A base revenue is any amount that was also included in last year’s budget. The approved level signifies revenues 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 calculate it. For information, refer to Move Budget Option.

Approved New Programs

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

Important

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

2nd Year - 5th Year Estimate

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.