PA Annual Financial Report – Revenues - Setup - Revenue Crosswalk

Use the PA Annual Financial Report - Revenues - Revenue Crosswalk page to define and maintain rules that map local revenue values to Pennsylvania AFR state revenue codes.

On the PA Annual Financial Report - Revenues page, select Revenue Crosswalk.
Enter the Search Criteria to find the required crosswalk records, and then select Search.
Refer to Search for records for more information.
- To add a record, select Add new. Refer to the Field descriptions, enter valid information, and select Accept.
- To edit a record, select the record and select Accept. Update the information and select Accept.
- To delete, select the record and select Delete. Select Yes.
- To generate a report, select Print, and then select a Destination:
  - Select File to create the report in .rpt format. The default file name is AFRrevData.rpt. You can change the default file name.
  - Select Screen to download the report in .pdf format. The default file name is AFRrevData_<#####>.pdf.
  - Select Excel to download the report in .xlsx format. Select the required Excel Options. The default file name is AFRrevDatarpt<####_#####>.xlsx.
    - Select OK.
      - Download the .rpt file from the View Files page.
      - Save the .pdf or .xlsx file.
        For more information about the Print option, refer to Print Reports.

Field descriptions

The following table describes the fields on the PA Annual Financial Report - Revenues - Revenue Crosswalk page.

Field	Description
Year	The fiscal year for the crosswalk rule.
Fund	The fund to which the crosswalk rule applies.
Level	The account structure level to crosswalk. The values in the drop-down list are retrieved from the Titles tab of the Fund Accounting Profile page. This field is view-only and cannot be updated after saving the record.
Local Value	The local value to map from.
State Value	The state-reportable value to map to.

Copy

Use the PA Annual Financial Report - Revenues - Revenue Crosswalk - Copy page to copy state revenue codes from one year to another.

On the PA Annual Financial Report - Revenues - Revenue Crosswalk page, select Copy.
Select the Year To Copy and Year To Create.
Select Accept.

Purge

If you need to correct setups or revenue data, purge the existing records and reload the data.

On the PA Annual Financial Report - Revenues - Revenue Crosswalk page, select Purge.
Select the Fiscal Year.
Select Accept, and then Yes.

Load External

Use the PA Annual Financial Report - Revenues - Revenue Crosswalk - Load External page to import state expenditure codes from a .tsv format text file.

For detailed information about the file layout, refer to the PA Annual Financial Report – Revenue Crosswalk - File Layout.

On the PA Annual Financial Report - Revenues - Revenue Crosswalk page, select Load External.
Select the Year to be associated with the revenue function/object codes.
Select Client PC or Server.
Select Upload and then select the file to upload.
Select Accept.
If data for the selected year is loaded, select OK to delete and reload the data.
Select OK.