PA Annual Financial Detail Report – File Layout and Data Mapping

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

.rpt file - AFRexpdet.rpt
.pdf and .xlsx files - AFRexpdetrpt<XXXX_XXXXX>.<extension>

The following table shows the columns, column names, descriptions, and data sources or valid values for the PA Annual Financial Detail 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	ROLL-UP FUNCTION	The account to roll the expenditure function amounts to.	Retrieved from the AFR Function field on the PA Annual Financial Report - Expenditure Detail page.
D	AFR FUNCTION	The AFR expenditure function code.	Retrieved from the AFR Function field on the PA Annual Financial Report - Expenditure Detail page.
E	AFR OBJECT	The AFR expenditure object code.	Retrieved from the AFR Object field on the PA Annual Financial Report - Expenditure Detail page.
F	AFR BUILDING	The AFR expenditure building code.	Retrieved from the AFR Building field on the PA Annual Financial Report - Expenditure Detail page.
G	BUDGET UNIT	The last level (low organization) in the reporting structure, as defined in the Fund Accounting Profile.	Retrieved from the BUDGET UNIT field on the PA Annual Financial Report - Expenditure Detail page.
H	FUNCTION	The local expenditure function code.	Retrieved from the Function field on the PA Annual Financial Report - Expenditure Detail page.
I	ACCOUNT	The expenditure account.	Retrieved from the Account field on the PA Annual Financial Report - Expenditure Detail page.
J	FINAL AMOUNT	The final dollar amount.	Retrieved from the Final field on the PA Annual Financial Report - Expenditure Detail page.
K	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.
L	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.
M	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.
N	TOTAL AMOUNT	The total dollar amount.	Retrieved from the Total field on the PA Annual Financial Report - Expenditure Detail page.