PowerSchool ERP Indiana

Form 9 Report - File Layout and Data Mapping

The default file name for the Form 9 report is <Corporation Number>form9.csv.

The following table lists the columns, column names, descriptions, and data sources or valid values for the Form 9 report.

Column

Column Name

Description

Data Source or Valid Values

A

Corporation Number

The four-digit state-assigned corporation identification number that identifies your school corporation/district to the Indiana Department of Education (IDOE).

Retrieved from the Corporation Number field on the IN Biannual Form 9 Report – Load page.

B

Section

The specific reporting category of the financial data as required by the State of Indiana.

Valid values:

  • 1 = Revenue

  • 2 = Expenditure

  • 3 = Revenue Exception

  • 4 = Expenditure Exception

  • 5 = Beginning Balance

  • 6 = Ending Balance

  • 8 = Encumbrances

  • M = Minus Adj to Beg Bal

  • P = Plus Adj to Beg Bal

Retrieved from the Section field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

C

Fund

The specific fund for which financial data is being reported.

Retrieved from the Fund field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

D

Account/Budget Code

The function or program code (for expenditures) or revenue account code (for revenue) that identifies where funds came from or how they were used.

Retrieved from the Account field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

E

Object

The expenditure object code that identifies the nature or type of purchase.

Retrieved from the Object field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

F

Amount

The cumulative total for all 13 periods for this organization/account or fund/account.

Retrieved from the Amount field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

G

Building

The four-digit Indiana Department of Education state building identification code indicating which school building or location the transaction is associated with.

Retrieved from the Building field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

H

Subcategory

A two-digit special designation code used to identify certain high per-pupil expenditure transactions that require additional state reporting detail or explanation.

Retrieved from the Subcategory field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.