PowerSchool ERP Budget Preparation

Revenue Detail Page

Use this page to review and update 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.

You can update this information for budgeting purposes. Figures entered in the page's Budget Year and Future Year fields are saved to the Revenue Budget Process pages for their respective levels.

When you access an account in the Detail page, you can itemize the account or add notes using the Notes item on the toolbar.

To display the Detail page, search for and list ledger accounts in the Revenue Budget Process - Requested page, select an account by pointing to the appropriate row of the worksheet, and then click the Detail item.

The Detail page’s fields are numeric. Decimal/12,2

Fields

Fields

Description

*Budget Unit*


Code for the low-level Organization Chart record tied to this Revenue Ledger account. Display only.

Account

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

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. 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. However, you can still update frozen ledger accounts in the Revenue Budget Process - Requested page.

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

Budget amounts for this ledger account in each of the past three fiscal years.

The following updates occur when you run the New Budget Year extraction, based on history records in Fund Accounting and Budget Preparation:

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

  • 2nd Prior Year 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 the past three fiscal years. The following updates occur when you run the New Budget Year extraction, based on history records in Fund Accounting and Budget Preparation:

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

  • 2nd Prior Year 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. If original budget data was extracted from Fund Accounting, this field shows the original revenue budget posted for the ledger account in the current year.

If current budget data was extracted, this 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.

Current Year Estimate

Projected revenues for the current fiscal year based on the Current Year YTD value and percentage of the year completed. The system calculates the estimate when the Apply Budget Option is run at the Requested level.

Requested Base

Core revenues budgeted for this ledger account in the upcoming year at the first standard approval level. A base revenue is any amount that was also included in last year’s budget. The requested level signifies the revenues requested for the new year.

You can enter the amount, or it can be system-calculated with the Apply Budget option.

Tip: You can also use the Notes item to update this field.

Requested New Program

Revenues your department is requesting for next year that were not included in last year’s budget.

Recommended Base

Core revenues budgeted for this ledger account in the upcoming year at the second standard approval level. 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 first standard level of approval.

Recommended New Programs

Revenues for this ledger account that were not included in last year’s budget and have gone through the first standard level of approval.

Approved Base

Core revenues budgeted for this ledger account at the final standard approval level. A base revenue is any amount that was also included in last year’s budget. The approved level signifies the revenues that have gone through final approval and are ready for posting to Fund Accounting.

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.

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. If desired, you can enter the amounts. The projections can also be generated using the Budget Administrator center’s Apply/Move Budget option. For information on this option, refer to Revenue Budgeting for Administrators.