ASBR Revenues Report - Maintain Data | PowerSchool ERP Compliance

Use the Revenue Detail form of the MO Annual Secretary of the Board Report - Revenue Detail page to view, add, edit, and verify the ASBR revenue records that will be reported to the state.

If errors are encountered during the Load data process, you can correct the source data on the Revenue Detail form of the MO Annual Secretary of the Board Report - Revenue Detail page. 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 MO Annual Secretary of the Board Report - Revenue Detail page, filter records using the filter criteria. To enter filter criteria:
1. Select an option in the first field.
2. Select or enter a value.
3. Select Add if the button is enabled.
  Refer to Search for records for more information.
  - To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, and then Yes.
  - To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
  - To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.
  - To download the information, select Download, then select Download PDF or Download as an Excel Document. The default file names are:
    - Excel: MO ASBR - Revenue Detail_<MMDDYYYY_hhmmss>.xlsx
    - PDF: MO ASBR - Revenue Detail_<MMDDYYYY_hhmmss>.pdf

Field descriptions

The following table describes the fields on the Revenue Detail form of the MO Annual Secretary of the Board Report - Revenue Detail page.

Field	Description	Load logic - Data source and Valid values
Year	The fiscal year for 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 Year field on the MO Annual Secretary of the Board Report - Load Expenditures page.
ACCOUNT CODE	Your district's local organizational/budget code from the GL account structure. 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 organizational/budget code in your GL account structure.
Revenue Code	The district's revenue account number, as listed in the general ledger chart of accounts.	Populated during the data load process. The field value is retrieved from the district's revenue ledger.
Title	The description/title of the account from your general ledger. This field is view-only.	Populated during the data load process. The field value is retrieved from the account title/description in your GL account structure.
ASBR Fund	The Missouri state-required fund classification.	Calculated during the data load process. The calculated value represents the Missouri state-required fund type (1-4) that your local fund code maps to via the Fund Data Crosswalk. The system looks up your local fund code and retrieves the corresponding state fund classification: 1 = General Fund 2 = Special Revenue Fund 3 = Debt Service Fund 4 = Capital Projects Fund You can use this field to override the calculated value.
ASBR Location	The Missouri state-required four-character location/school code.	Calculated during the data load process. The calculated value represents the Missouri state-required four-character location code that your local location/school code maps to via the Location Data Crosswalk. The system extracts the location code from your organizational structure (using the Reporting Structure setup) and retrieves the corresponding ASBR location code. You can use this field to override the calculated value.
ASBR Project	The Missouri state-required five-character project code.	Calculated during the data load process. The calculated value represents the Missouri state-required five-character project code that your local project code maps to via the Project Data Crosswalk. The system extracts the project code from your organizational structure (using the Reporting Structure setup) and retrieves the corresponding ASBR project code. You can use this field to override the calculated value.
Amount	The dollar amount of the expenditure.	Populated during the data load process. The field value is retrieved from the actual expenditure transaction amounts in the ledger. You can use this field to override the calculated value.