PA Annual Financial Summary Report – Revenues - File Layout and Data Mapping

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

.rpt file - AFRrevsum.rpt
.pdf file - AFRrevsum_<#####>.pdf
.xlsx file - AFRrevsumrpt<####_#####>.xlsx

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

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year associated with the revenue record.	Populated during the file creation process. Retrieved from the Year field on the PA Annual Financial Report - Revenue Detail page.
B	AFR FUND	The AFR revenue fund code.	Populated during the file creation process. Retrieved from the AFR Fund Code field on the PA Annual Financial Report - Revenue Detail page.
C	AFR REVENUE CODE	The four-character Pennsylvania state-assigned revenue classification code from the AFR Revenue Codes table (e.g., 6111).	Populated during the file creation process. Retrieved from the AFR Revenue Code field on the PA Annual Financial Report - Revenue Detail page.
D	REVENUE SOURCE	Revenue source category derived from the first digit of the AFR Revenue Code: LOCAL (6xxx) STATE (7xxx) FEDERAL (8xxx) OTHER (9xxx)	Calculated during the file creation process. The calculated value represents the revenue source category derived from the first digit of the AFR Revenue Code. Codes beginning with 6 resolve to LOCAL, 7 to STATE, 8 to FEDERAL, and 9 to OTHER.
E	REVENUE AMOUNT	Total revenue dollar amount recorded for the account in the specified fiscal year.	Populated during the file creation process. Retrieved from the Amount field on the PA Annual Financial Report - Revenue Detail page.
F	CURRENT YEAR ACCRUAL AMOUNT	Current fiscal year accrual adjustment amount entered manually for the account.	Populated during the file creation process. Retrieved from the Current Year Accrual Amount field on the PA Annual Financial Report - Revenue Detail page.
G	PRIOR YEAR ACCRUAL AMOUNT	Prior fiscal year accrual adjustment amount entered manually for the account.	Populated during the file creation process. Retrieved from the Prior Year Accrual Amount field on the PA Annual Financial Report - Revenue Detail page.