PA Annual Financial Detail Report – Expenditures - Create Files

Use the PA Annual Financial Report - Expenditure Reports page to specify the report criteria and create the report files.

1. On the PA Annual Financial Report - Expenditure Detail page, select Reports.

2. Select the Report Type.

3. Select the Year.

4. Select Include Accounts with Zero Dollars to include accounts with a zero dollar value in the reports.

5. Select Accept.

6. Select a Destination:

   • Select File to create the report in .rpt format. You can change the default file name.

   • Select Screen to download the report in .pdf format.

   • Select Excel to download the report in .xls format. Select the required Excel Options.

     • Select OK.

       • Download the .rpt file from the View Files page.

       • Save the .pdf or .xls file.

The default file names are:

• Summary report:

  • .rpt file - AFRexpsum.rpt

  • .pdf file - AFRexpsum_<#####>.pdf

  • .xlsx file - AFRexpsumrpt<####_#####>.xlsx

• Detail report:

  • .rpt file - AFRexpdet.rpt

  • .pdf file - AFRexpdet_<#####>.pdf

  • .xlsx file - AFRexpdetrpt<####_#####>.xlsx

• Supplemental Expenditure Schedule:

  • .rpt file - AFRexpsup.rpt

  • .pdf file - AFRexpsup_<#####>.pdf

  • .xlsx file - AFRexpsuprpt<####_#####>.xlsx

• AFR File: AFRExpFile.txt

For detailed information about the report’s file layouts, refer to PA Annual Financial Report – Expenditures - File Layouts and Data Mapping.

Follow the state's submission procedures.