PA Annual Financial Summary Report – File Layout and Data Mapping

The default file names for the PA Annual Financial Summary report are:

.rpt file - AFRexpsum.rpt
.pdf and .xlsx files - AFRexpsumrpt<XXXX_XXXXX>.<extension>

The following table shows the columns, column names, descriptions, and data sources or valid values for the PA Annual Financial Summary report’s .xlsx file format.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year associated with the expenditure record.	Retrieved from the Year field on the PA Annual Financial Report - Expenditure Detail page.
B	AFR FUND	The AFR expenditure fund code.	Retrieved from the AFR Fund field on the PA Annual Financial Report - Expenditure Detail page.
C	AFR FUNCTION	The AFR expenditure function code.	Retrieved from the AFR Function field on the PA Annual Financial Report - Expenditure Detail page.
D	AFR OBJECT	The AFR expenditure object code.	Retrieved from the AFR Object field on the PA Annual Financial Report - Expenditure Detail page.
E	AFR BUILDING	The AFR expenditure building code.	Retrieved from the AFR Building field on the PA Annual Financial Report - Expenditure Detail page.
F	FINAL AMOUNT	The final dollar amount.	Retrieved from the Final field on the PA Annual Financial Report - Expenditure Detail page.
G	ELEMENTARY AMOUNT	The dollar amount for Kindergarten through Sixth Grade expenditures.	Retrieved from the Elementary field on the PA Annual Financial Report - Expenditure Detail page.
H	SECONDARY AMOUNT	The dollar amount for Seventh Grade through Twelfth Grade expenditures.	Retrieved from the Secondary field on the PA Annual Financial Report - Expenditure Detail page.
I	FEDERAL AMOUNT	The dollar amount for costs funded by federal revenues.	Retrieved from the Federal field on the PA Annual Financial Report - Expenditure Detail page.
J	TOTAL AMOUNT	The total dollar amount.	Retrieved from the Total field on the PA Annual Financial Report - Expenditure Detail page.