PA Annual Financial Detail Report – Revenues - Maintain Data

If errors are encountered during the Load data process, you can correct the source data. After corrections, you must purge and reload the data.

PowerSchool recommends that you correct the report’s source data that is retrieved from the Core application.

On the PA Annual Financial Report - Revenue Detail page, enter the Search Criteria to find the required records, and then select Search.
Refer to Search for records for more information.
- To add a record, select Add new. Refer to the Field descriptions, enter valid information, and select Accept.
- To edit a record, select the record and select Accept. Update the information and select Accept.
- To delete, select the record and select Delete. Select Yes.
- To generate a report, select Print, and then select a Destination:
  - Select File to create the report in .rpt format. The default file name is AFRrevData.rpt. You can change the default file name.
  - Select Screen to download the report in .pdf format. The default file name is AFRrevData_<#####>.pdf.
  - Select Excel to download the report in .xlsx format. Select the required Excel Options. The default file name is AFRrevDatarpt<####_#####>.xlsx.
    - Select OK.
      - Download the .rpt file from the View Files page.
      - Save the .pdf or .xlsx file.
        For more information about the Print option, refer to Print Reports.

Field descriptions

The following table describes the fields in the Revenue Detail section of the PA Annual Financial Report - Revenue Detail page.

Field	Description	Load logic - Data source and Valid values
Year	The fiscal year associated with the revenue record. This field is view-only and cannot be updated after saving the record.	Populated during the data load process. The field value is retrieved from the Fiscal Year field on the PA Annual Financial Report - Load Revenues page.
BUDGET UNIT	The last level (low organization) in the reporting structure, as defined in the Fund Accounting Profile. This field is displayed when Full Account Structure (FAS) is turned off. Select the Lookup icon to search for and select an organization. This field is view-only and cannot be updated after saving the record.	Populated during the data load process. The field value is retrieved from the key organization of the revenue ledger record for the selected fiscal year. The field label is retrieved from the Low Orgn field on the Titles tab of the Fund Accounting Profile page. The records on the Organization Search page are retrieved from the Organization Chart page.
Account	The revenue account. This field is displayed when Full Account Structure (FAS) is turned off. Select the Lookup icon to search for and select an account. This field is view-only and cannot be updated after saving the record.	Populated during the data load process. The field value is retrieved from the account code of the revenue ledger record for the selected fiscal year. The records on the Account Search page are retrieved from the Account List page.
Account Number	The full account number (combined organization and account code) for the expenditure record. This field is displayed when Full Account Structure (FAS) is enabled. Select the Lookup icon to search for and select a full account number. This field is view-only and cannot be updated after saving the record.	Calculated during the data load process. The calculated value represents the full account number, constructed by combining the key organization and account code retrieved from the revenue ledger record. The field label is retrieved from the Full Account field on the Titles tab of the Fund Accounting Profile page.
AFR Fund Code	The state-reportable fund code assigned to the revenue record during the Load process.	Calculated during the data load process. The calculated value represents the state-reportable fund code derived from the fund segment of the revenue ledger account code during the load. The values in the drop-down list are retrieved from the Organization Chart page.
AFR Revenue Code	The state-reportable revenue code assigned to the revenue record during the Load process. This value is determined by matching the local revenue source code against the AFR State Revenue Codes table, applying rollup logic if an exact match is not found.	Calculated during the data load process. The calculated value represents the state-reportable revenue code determined by matching the local revenue source code against the AFR State Revenue Codes table. If an exact match is not found, the load process applies rollup logic by replacing the last non-zero digit of the code with a zero and re-searching until a match is found.
Amount	The year-to-date receipt amount through period 13 for the fiscal year.	Calculated during the data load process. The calculated value represents the sum of the year-to-date receipts through period 13 for the revenue account in the selected fiscal year.
Current Year Accrual Amount	The accrual amount applied to the current fiscal year for this revenue record.	Not populated or calculated during the data load process. The field is initialized to 0 when the record is created. Users must manually enter the current year accrual amount after the load completes.
Prior Year Accrual Amount	The accrual amount applied to the prior fiscal year for this revenue record.	Not populated or calculated during the data load process. The field is initialized to 0 when the record is created. Users must manually enter the current year accrual amount after the load completes.