PA Annual Financial Report – Expenditures - Setup - Expenditure Crosswalk

Use the PA Annual Financial Report - Expenditures - Expenditure Crosswalk page to define and maintain crosswalk rules that map local expenditure values to Pennsylvania AFR state expenditure codes.

On the PA Annual Financial Report - Expenditures page, select Expenditure 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 PAAFRExpCrosswalk.rpt. You can change the default file name.
  - Select Screen to download the report in .pdf format. The default file name is PAAFRExpCrosswalk_<#####>.pdf.
  - Select Excel to download the report in .xlsx format. Select the required Excel Options. The default file name is PAAFRExpCrosswalkrpt<####_#####>.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 - Expenditures - Expenditure Crosswalk page.

Field	Description
Year	The fiscal year for the crosswalk rule.
Fund	The state fund code that, together with the function and object codes, identifies a state-approved expenditure code combination for the Annual Financial Report.
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.
Local Value	The local value to map from.
State Value	The state-reportable value to map to.

Copy

Use the PA Annual Financial Report - Expenditures - Expenditure Crosswalk - Copy page to copy AFR expenditure crosswalk records from a source year to a different target year.

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

Purge

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

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

Load External

Use the PA Annual Financial Report - Expenditures - Expenditure Crosswalk - Load External page to load expenditure crosswalk values from a comma-delimited file.

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

On the PA Annual Financial Report - Expenditures - Expenditure Crosswalk page, select Load External.
Select the Year to be associated with the expenditure 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.