PowerSchool ERP Ohio

Annual Spending Plan - Create File

Use the OH Annual Spending Plan - Report page to generate the Ohio Annual Spending Report for selected fiscal periods. This page produces financial reports that compare estimated budgets with actual expenditures and revenues, helping Ohio school districts monitor compliance with their spending plans and their cash position throughout the fiscal year.

  1. On the OH Annual Spending Plan page, select Reports.

  2. Refer to the Field descriptions and enter or select the required report criteria.

  3. Select PDF or Excel.

  4. Select Create, and then Yes.

  5. Save the file and select OK.

  6. Navigate to the folder containing the report file.

  7. Inspect the file. Refer to Maintain data and update the data if necessary.

  8. Repeat these steps until all the required data is included.

The default file names are:

  • Summary report:

    • PDF: OH Annual Spending Plan Report_Summary_<MMDDYYYY>_<hhmmss>.pdf

    • Excel: OH Annual Spending Plan Report_Summary_<MMDDYYYY>_<hhmmss>.xlsx

  • Detail report:

    • PDF: OH Annual Spending Plan Report_Detail_<MMDDYYYY>_<hhmmss>.pdf

    • Excel: OH Annual Spending Plan Report_Detail_<MMDDYYYY>_<hhmmss>.xlsx

For detailed information about the report’s file layout, refer to Annual Spending Plan - File Layouts and Data Mapping.

Field descriptions

The following table describes the fields on the OH Annual Spending Plan - Report page.

Field

Description

Summary Report

This option creates a report of aggregated totals by spending plan line with period and FYTD comparisons.

Detail Report

This option creates a report of individual ledger entries grouped by spending plan line number.

Year

The fiscal year to include in the report.

From Period

The starting period for the report range (1-13).

To Period

The ending period for the report range (1-13).

Cash Balance Funds

The fund code(s) to include when calculating the beginning cash balance.

The default is 001.

Select ALL to include all Cash Balance Funds.

Cash Account 1

The primary cash account used for the beginning cash balance calculation.

Cash Account 2

The additional cash account for the beginning cash balance calculation.

Cash Account 3

The additional cash account for the beginning cash balance calculation.

Cash Account 4

The additional cash account for the beginning cash balance calculation.

Cash Account 5

The additional cash account for the beginning cash balance calculation.

Include Zero Balances

Indicates whether to include ledger entries with zero balances.

This option is displayed when Detail Report is selected.