Annual Financial Report (AFR) System
The Annual Financial Report (AFR) System enables the Louisiana
Department of Education (LDE) to collect, consolidate, and review computerized
fiscal data from public school districts and selected public schools to support
LDE management decisions; and to respond to various requests for educational
financial data. The
AFR is submitted to the Louisiana Superintendent of Education by September 30 annually.
The AFR provides a summary of financial activities for the school district or
selected school during the fiscal year being reported (i.e., proceeding July 1-
June 30), together with the status of selected funds and/or account groupings
as of the end of that fiscal year (June 30).
The AFR is submitted to the Louisiana Superintendent of Education
by September 30 annually. The AFR provides a summary of financial
activities for the school district or selected school during the fiscal year
being reported (i.e., preceding July 1- June 30), together with the status of
selected funds and/or account groupings as of the end of that fiscal year (June
30).
The submitted fiscal data are not accepted as complete by the LDE
until the district or school has adequately corrected or resolved MFP audit
questions regarding the data; and the school district or agency superintendent
(or equivalent) has subsequently provided written certification to the accuracy
and completeness of final data for the fiscal year.
|
Important Note: |
|
Do not e-mail the spreadsheets or converted text files to the
LDOE. All submitted AFR reports must be in the appropriate text-file format;
and uploaded directly to the Web-based AFR System via the LEADS Portal (https://leads5.doe.louisiana.gov/ptl/). A
district or school may elect to create and update its AFR files entirely
on-line; however, once the file is upload or the on-line option is selected,
the district/school must remain with that same operational mode for the
entire data collection cycle. |
Overview and Reference
Documents
2023 - 2024 Annual Financial Report (AFR) Data Collection Highlights
Overview of Annual Financial Review Process (PowerPoint)
Annual Financial Report System User Guide
Federal Cash Management Improvement Act
FY2023 - 2024 Subawards for Indirect Costs
Calculation User Guide
AFR 2023 - 2024 Instructions
and Forms
2023
- 2024 Fiscal Project Codes (PDF)
GASB
84 and Louisiana School Activity Funds (PDF)
2023
- 2024 Project Code AB1 Reporting.pdf
FY 2023-2024
Coding for Federal & State Grants
2023
- 2024 Revenue Coding Guidance.pdf
2023
- 2024 Expenditure Coding Guidance.pdf
Frequently
Asked Coding Questions & Answers.pdf
2023
- 2024 AFR Form with formulas for City/Parish systems (Excel)
2023
- 2024 AFR Form with formulas for Charters, Lab schools. & Stat. (Excel)
AFR LEA Post Submission Review Process
2023
- 2024 AFR Review Process - Post Submission Audit Review Instructions for
LEAs.pdf
2023
- 2024 AFR Review Checklist - Districts.pdf
2023
- 2024 Response to AFR Checklist - Districts.xls
2023
- 2024 AFR Review Checklist - Charters, Lab schools & State Agencies.pdf
2023
- 2024 Response to AFR Checklist Form - Charters, Lab Schools & State
Agencies.xls
2023
- 2024 Special Reporting Certification - Districts, Charters, Lab Schs & State Agencies.pdf
AFR Filebuild
Tools (Version 2023-2024)
The two zipped "Version 2023-2024" files below each
contain a self-extracting file (.EXE) consisting of an Access module that will
convert content of the formatted Excel spreadsheet (see Forms: FY 2023-2024 AFR
Form - with formulas, above) into the standard AFR600 fixed-width text file format.
The first Access module (AFR_Filebuilder_SITE (Ver 2023-2024)) inserts the user's site code into positions
92-97 of each output record; and is provided for use by entities required to
report AFR data by individual school ( e.g., all charter and lab schools). The
second Access module (AFR_Filebuilder_LEA (Ver 2023-2024)) is for use by RSD-LDE to create a
consolidated AFR600 file for LEA 396; and (if desired) for use by any
multi-school entity that reports a consolidated AFR covering all their sites
(e.g., individual city/parish school districts; SSD # 1, OJJ, etc.). Both
modules require entry of applicable fiscal project codes (e.g., AA0 or other
valid code) for insertion into positions 89-91 of each output record. Completed
AFR text files must be uploaded directly to the
Web-AFR System via the LEADS Portal (see AFR user's guide for more
information). Use of these file creation tools will require 10 MB of hard drive
(specifically C-Drive) on a PC having both Microsoft Excel and Access (Version
2003 or greater compatible). Note: Open the appropriate zipped file, then
execute (by double-clicking icon) the self-extracting file, which will create
the folder "C:\AFR_FILEBUILD" on the target PC and insert the Filebuilder module within that folder. Direct questions
to system.support@la.gov.
Requires Microsoft Access and Excel (both Version
2003 compatible) on user's PC
IMPORTANT:
Please review Operating Instructions Step 1 BEFORE
downloading the zipped files.
OPERATING
INSTRUCTIONS
PDF
AFR_Filebuilder_LEA ZIP
AFR System User's Guide
The AFR System User's Guide identifies or provides data
requirements, record formats, schedule, and instructions for creating and
submitting the AFR data.
Questions regarding the User’s Guide should be directed to staudit@la.gov
2023-2024 AFR User
Guide (Version 1.1)