PowerSchool ERP Pennsylvania

PA Annual Financial Report – Revenue 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; it is processed as data and rejected.

  • Fund must exist on the organization chart for the selected year.

  • Level must be numeric, at least 2, and match the revenue level configured in the PA AFR Profile.

  • 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 for the same year and revenue crosswalk type.

  • The selected fiscal year is applied to all imported rows.