Export Munis Data for ACFR

Need EERP data exported from General Ledger so it can be brought into ACFR

• Annual Consolidated Financial Report (ACFR) formally CAFR
• Export
• Data File

EERP Export must be completed before importing to ACFR

Financials > General Ledger Menu > Inquiries and Reports > CAFR Statement Builder/GASB34 Interface

1. Click Accounts
2. Enter desired find set
3. Click Accept
4. Click Report Options
5. Enter desired report options. ASCII File Name must be populated for ASCII export
6. Click Accept
7. Click Report Format
8. Select 24 Column Report
9. Click Create ASCII

System Administration > Miscellaneous Administration > File Transfer

1. Select Download from spool directory 
2. Order by Date and double click your file

• Never use the Excel option it adds incompatible characters CAFR cannot process though import
  • ACFR Import Error - Fund Account number cannot contain a single quote
• Excel option is only used for quickly checking selected data for review, not for CAFR import
• Always use the Create ASCII" option with 24 column format
• EERP can only export Current Year or Last Year EERP data.
  • Sites can create their own files manually if CAFR needs data from before Last Year EERP.  CAFR Trainers will tell sites no its not possible, logically it is though.  Just not built into design of EERP to allow it.
    • Run reports in EERP to pull needed data (YTD Budget Report, Balance Sheet, Account Trial Balance)
    • Update a copy of working EERP export for CAFR in Excel then save once correctly populated to needed file format for CAFR Import.
• Export file is created with a user name of **Unknown** so it cannot be found in Saved Reports as an invalid user name will not work with any EERP permissions.

• How to find an exported file of a **Unknown** user name