ASBR Expenditures Report - Maintain Data | PowerSchool ERP Compliance

Use the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page to view, add, edit, and verify the ASBR expenditure 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 Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure 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 - Expenditure 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 - Expenditure Detail_<MMDDYYYY_hhmmss>.xlsx
    - PDF: MO ASBR - Expenditure Detail_<MMDDYYYY_hhmmss>.pdf

Field descriptions

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

Field	Description	Load logic - Data source and Valid values
Year	The fiscal year for the expenditure 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.
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.
Function	Your district's local function code from the 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 your local function code (identified by using the Reporting Structure setup).
Object	Your district's local object code from the 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 your local object code in the account structure.
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.
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 Function	The Missouri state-required four-character function code.	Calculated during the data load process. The calculated value represents the Missouri state-required four-character function code that your local function code maps to via the Function Data Crosswalk. The system matches your local function code and retrieves the corresponding ASBR function code that classifies the activity or purpose for state reporting. You can use this field to override the calculated value.
ASBR Object	The Missouri state-required object code.	Calculated during the data load process. The calculated value represents the Missouri state-required object code that your local object code maps to via the Object Data Crosswalk. The system matches your local object code and retrieves the corresponding ASBR object code that classifies the type of expenditure for state reporting. 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.
ASBR Source	The Missouri state-required one-character revenue source code.	Calculated during the data load process. The calculated value represents the Missouri state-required one-character revenue source code extracted from your organizational structure based on the Reporting Structure setup. The system identifies which organizational level contains the source code and extracts it from that position in your account structure. You can use this field to override the calculated value.