PowerSchool ERP Pennsylvania

PA Annual Financial Report – Expenditure Crosswalk - File Layout

The State Expenditure Codes upload file is a .csv (comma-separated values) text file.

Each non-blank row must contain exactly four columns in this order:

Fund,Level,Local Value,State Value

Example

10,2,1000,1000

10,2,1001,1001

Requirements

  • Do not include a header row.

  • Fund must exist on the organization chart.

  • Level must be numeric and at least 2.

  • Local Value must be valid for the selected level.

  • State Value is required and cannot exceed 16 characters.

  • Duplicate Fund + Level + Local Value rows are rejected.

  • The selected fiscal year is applied to all rows.