Reporting Requirements for Annual Financial Reports of State Agencies and Universities

Pass-Through Activity

Instructions for the SEFA Web Application
Step 6. Format for Download

The data may be downloaded into a spreadsheet format after data entry is complete. This downloaded spreadsheet format can be used to verify the data entry or to serve as a hard copy of SEFA.

1. Access the Main Menu.
2. Click Main Record List.
3. Click Format for download at the bottom of the screen.
4. Use the mouse to highlight all of the displayed data or choose Select all from the browser’s Edit menu.
5. Select Copy from the browser’s Edit menu.
6. Open a new Excel spreadsheet and select Paste from the drop-down menu.
7. Highlight the first column (A) of the Excel spreadsheet.
8. Click Data in Excel’s top menu bar and select Text to Columns.
9. Select the Delimited option and click Next >.
10. Select Comma as the delimeter with a text qualifier of comma ( ‘ ) and then click Next >.
11. Choose General column data format and click Finish.
    Format the data in the spreadsheet to the desired format. To format ALN:
    1. Click Format in Excel’s top menu bar and select Cells from the drop-down menu.
    2. Click the Number tab (at top) and select Custom (in the “Category” left menu).
    3. Enter 00.000 in the TYPE field and click OK.