LA Annual Financial Report
The LA Annual Financial Report is accessed by selecting the following menu path: Fund Accounting > State > LA Annual Financial Report.
Report Specific Setup
Setup Information Page
The LA Annual Financial Report Setup Information page must be completed before the report can be run. The setup information page is accessed by clicking the Setup action on the LA Annual Financial Report main page:
The LA Annual Financial Report Setup page appears.
Field Name | Description | DB Table Field |
---|---|---|
LEA Code | Three-digit state code indicating the district. | lafrsetup.lea |
Number of Districts Paying | (Label) | lafrsetup.distcnt |
Default Workday Minutes | Default to use for calculating annual minutes on-site/position records if an individual value is not entered for a person on the LA PEP demographic screen. | lafrsetup.distcntb |
Sales Tax Revenue Included | formerly used in the 001 record - deprecated – no need to set | lafrsetup.distcntc |
Administrative Pay Raises Included | formerly used in the 001 record - deprecated – no need to set | lafrsetup.distcntd |
Instructional Pay Raises Included | formerly used in the 001 record - deprecated – no need to set | lafrsetup.distcnte |
Support Pay Raises Included | formerly used in the 001 record - deprecated – no need to set | lafrsetup.lea |
Keypunch Code Ranges | (Label) | |
Revenue, Expenditures, Funds Balances, and Balance | State-determined keypunch code range corresponding to the record types for Revenue, Expenditures, Funds Balances, and Balance. | lafrsetup.srange1 |
Ad Valorem Taxes | State-determined keypunch code range corresponding to the record types for Ad Valorem Taxes. | lafrsetup.srange2 |
Sales and Use Taxes | State-determined keypunch code range corresponding to the record types Sales and Use Taxes. | lafrsetup.srange3 |
General Fixed Asset/Long-Term Debt | State-determined keypunch code range corresponding to the record types General Fixed Asset/Long Term Debt. | lafrsetup.srange4 |
Proprietary Funds and Fiduciary Funds | State-determined keypunch code range corresponding to the record types Proprietary Funds and Fiduciary Funds. | lafrsetup.srange5 |
Maintaining an Existing Report
From the main report page, highlight the desired report and double-click.
The LA Annual Financial Report Information page will open with Report header information on the top section of the screen.
It is possible to change the Report Title on this page by changing the value in the Report Title entry field and then clicking 'OK'. In maintenance mode, the other fields are display-only.
To maintain Lines, click the green 'OK' icon. To maintain Columns, click the 'Columns' action on the Actions toolbar. Lines and Columns should be maintained for the LAAFR1, LAAFR2, and LAAFR3. The LAAFR4 and LAAFR5 information is entered differently and will be described below.
Note: for more information concerning the corresponding database table lafrhead, please see the 'Tables' section at the end of this manual.
Maintaining Lines
Once the user clicks the 'OK' icon on the LA Annual Financial Report information page, Line information will appear at the bottom of the page, and new Actions 'Insert Row,' 'Delete Row,' and 'Selection Criteria Detail' will appear in the Action Bar.
The user may insert lines between the currently existing lines by using a decimal value, as in the example above. A new line was required between line 1.00 and line 2.00, so line 1.01 was created.
The 'Selection Criteria Detail' action will be discussed below.
Line Information:
Line definitions (database table lafrline) are saved by report id, year, and project number as shown in the top half of the screen.
Field Name | Description | DB Table Field |
---|---|---|
Line Number | The order that information is output on the report, line by line. Decimal 5,2 field. Lines should be entered in the exact order that information should be output on the report. | lafrline.line_no |
Line Description | Usually, the state descriptions are associated with the keypunch code. | lafrline.line_desc |
Keypunch | State-defined keypunch code. | lafrline.keypunch |
Rate 1 | (Tax rate). For LAAFR1, this field is not applicable and is always 0.0000. For LAAFR2, this field refers to the Parish-wide Rate (Manual Entry). For LAAFR3, this field refers to the Non-Debt Service Rate. | lafrline.rate1 |
Rate 2 | (Tax rate). For LAAFR1, this field is not applicable and is always 0.0000. For LAAFR2, this field refers to the District/Ward Rate (LOW). For LAAFR3, this field refers to the Debt Service Rate. | lafrline.rate2 |
Rate 3 | (Tax rate). For LAAFR1, this field is not applicable and is always 0.0000. For LAAFR2, this field refers to the District/Ward Rate (HIGH). For LAAFR3, this field is not applicable and is always 0.0000. | lafrline.rate3 |
Line Type | The possible line types are:
| lafrline.total_line |
Select Criteria ** | The way that the selection criteria are entered is to be pulled out of the database. Possible values are ‘Standard’ and ‘Override’. Standard is recommended for almost all situations. ‘Override’ should be used only if the user maintaining the report is very proficient with SQL. | lafrline.where_type |
Note: the screen inputs do not include every field in the corresponding database table lafrline. Please see the 'Tables' section at the end of this manual for more database table information.
**Select criteria. When the user has highlighted a line and clicks on the Select Criteria action, one of three pages will appear depending on whether the Select Criteria field is set to Standard or Override, and what the Line Type is.
If the Line Type is E, G, or R and the Select Criteria is set to Standard, the Standard Selection Criteria page will open.
Using this page, the user can identify the specific ledgers from which the line should take its data. For a much more detailed explanation of the Standard Selection Criteria page, please refer to the Fund Accounting manual on the General Report Writer (section 13).
If the Line Type is E(expenditure), G(general), or R(revenue) and the Select Criteria is set to Override, the Override Selection Criteria page will open.
Where Part refers to the where part of a SQL statement to retrieve data from the applicable ledger.
GL Where part refers to the where part of a SQL statement to retrieve data from the applicable general ledger. Use of the Override Selection Page is discouraged and may be deprecated in future versions.
If the Line Type is (S)subtotal or (T)total, the Select Criteria should be set to Standard, and the Total Formula page will open.
In the above example, the total formula is taking the sum of the values from lines 2 through 5 inclusive.
It is also possible to enter a total formula as follows: 1113 + 1115 + 1117, which would sum the values of the three selected lines.
For a more detailed explanation of the Selection Criteria and Total Formula pages, please refer to the Fund Accounting manual Section 13 on the General Report Writer.
Maintaining Columns
Once the user clicks the 'Columns' icon on the LA Annual Financial Report information page, Column information will appear at the bottom of the page, and new Actions 'Insert Row,' 'Delete Row,' 'Total Column Formula,' and 'Selection Criteria Detail' will appear in the Action Bar.
The 'Total Column Formula' and 'Selection Criteria Detail' actions will be discussed below.
Column definitions (database table lafrcol) are saved by report id, year, and project number as shown in the top half of the screen.
Field Name | Description | DB Table Field |
---|---|---|
Column Number | Order of column across the top | lafrcol.column_no |
Heading 1 | The first line of the column head | lafrcol.head1 |
Heading 2 | The second line of the column head | lafrcol.head2 |
Total Column | Y or N, Column Totals the values of previous Columns. If N, the column may be summed by other columns which is a total column. Value ‘P’ in this field is not used in LA State Reporting. | lafrcol.total_column |
Column Type (items with strikeout are not used in LA State Reporting). Currently in use – E,R,G,N but others have been used in the past and may be used again | (A) - Approved Expense Budget (Budgeting) (E) - Estimated Expense (Budgeting) (P) - Prior Year Expense (Budgeting) (M) - Encumbrance E - Expense (B) - Expense Budget Control (U) - Expense Budget Detail (X) - Expense/Encumbrance (G) - General Ledger (O) - Original Expense Budget (V) - Original Revenue Budget (N) - None - user with Total columns. (R) - Revenue (D) - Revenue Budget | lafrcol.column_type |
Whole Dollars | Y - Whole Dollar rounds data to the nearest dollar. N - Include Cents uses dollars and cents. | lafrcol.whole_dollar |
Ledger Year | lafrcol.ledger_yr | |
Start Period | Financial period 1 through 13 | lafrcol.start_per |
End Period | Financial period 1 through 13 | lafrcol.end_per |
Select Criteria | The way that the selection criteria are entered to be pulled out of the database. Possible values are ‘Standard’ and ‘Override’. Standard is recommended for almost all situations. ‘Override’ should be used only if the user maintaining the report is very proficient with SQL. | lafrcol.where_type |
Note: the screen inputs do not include every field in the corresponding database table lafrcol. Please see the 'Tables' section at the end of this manual for more database table information.
Validating A Report
Report validation searches for duplicate key organization/account combinations within a report setup. To validate a report, search for a report on the main page of the LA Annual Financial Report, select the desired report, and click on the 'Validate' Action in the Action Bar.
The Validation Report print screen will appear.
Select the Screen, File or Excel option. If there are no duplicates, the report will say so. If there are duplicates, the report will indicate which key organizations/accounts are duplicated.
Copying A Report to Another Year
The 'Copy' feature allows the user to copy the report setup of a report, including lines, columns, and input information, to a different report, project number, or year. It is most useful when copying a previous year's report to a new year's. To copy a report, search for a report on the main page of the LA Annual Financial Report, select the desired report, and click on the 'Copy' Action in the Action Bar.
The 'LA Annual Financial Report - Copy Report Setup' page will appear.
Enter the new report, project number, and year and click 'OK'. When the records have been copied forward, a 'Report Copied' message appears.
Adding Fixed Asset Or Proprietary Funds and Fiduciary Funds Records
To enter the final two reports/record types (LAAFR4 and LAAFR5), select one of those reports from the main report page and click the 'Input' action on the Action Bar.
The LA Annual Financial Report – Record and Override Input page will open.
The final two reports are manually input. Fixed asset information can be obtained from the Fixed Assets Package (if applicable). Records for these last two reports are distinguished from each other by their keypunch codes, using the respective keypunch code ranges which have been entered by the user on the LA AFR Setup page.
Field Name | Description | DB Table Field |
---|---|---|
Keypunch | Enter a keypunch code within the range for the report defined on the LA Annual Financial Report Setup Page. | larptrec.keypunch |
Line Description | Description of the line | larptrec.line_desc |
Starting Balance | Starting Balance - decimal (9,2) | larptrec.sbal |
Additions | Additions - decimal (9,2) | larptrec.adds |
Subtractions | Deletions - decimal (9,2) | larptrec.dels |
Ending Balance | Ending Balance - decimal (9,2) | larptrec.ebal |
The screen inputs do not include every field in the corresponding database table larptrec. Please see the 'Tables' section at the end of this manual for more database table information.
Purging Report Setup Records
Purging report setup records deletes from the database all header, line, column, and input record records for the select report. To purge a report setup, search for a report on the main page of the LA Annual Financial Report, select the desired report, and click on the 'Purge' Action in the Action Bar.
A popup confirmation will appear.
To continue with the purge, click 'Yes.' Otherwise, click 'No' to return to the main LA Annual Financial Report page.
Setting Up A New Report
To create any new report, report header information must be entered. For the LAAFR reports 1 through 3, which pull ledger information, line and columns setup records must be created, while for LAAFR reports 4 and 5, in which financial information is input directly by the user, input records must be created. For all reports, once set up, the report setup information may be copied forward to a new year.
To create a report, click the 'New' icon on the LA Annual Financial Report Main page.
The LA Annual Financial Report - Report Information page will open.
Enter the header information and click OK to save the header record and enter lines.
Field Name | Description | DB Table Field |
---|---|---|
Report | Required 7 character report identifier | lafr_head.rpt_id |
Project Number | Required 3 character project number (state-defined) | lafr_head.project_no |
Year | Year selection dropdown. Stored as 2-digit year. | lafr_head.yr |
Report Title | Not required – 70 character description of the report. | lafr_head.title_text |
Note: for more information concerning the corresponding database table lafrhead, please see the 'Tables' section at the end of this manual.
Adding Lines
While you should enter your lines in order, you are not required to do so. The system arranges the lines numerically after you save a format. However, if you skip any numbers in the sequence you are entering, the system will flag these as missing lines and will not generate your report.
Please see the LA Annual Financial Report#Maintaining Lines section above for a more detailed description of the input fields.
Note: the screen inputs do not include every field in the corresponding database table lafrline. Please see the 'Tables' section at the end of this manual for more database table information.
Adding Columns
To add columns to a new report, click the 'Columns' action from the Action Bar at the top of the LA Annual Financial Report. The bottom of the page will no longer show 'Lines' but will switch to allow column entry, and the page title will change to 'LA Annual Financial Report – Columns.'
Please see the LA Annual Financial Report#Maintaining Columns section above for a more detailed description of the input fields.
Note: the screen inputs do not include every field in the corresponding database table lafrcol. Please see the 'Tables' section at the end of this manual for more database table information.
Generating Reports and Files
The LA Annual Financial Report module can generate hard-copy reports and electronic file for submission to the state. Reports must be run before end-of-fiscal year totals are cleared.
To generate a report, select the desired report from the LA Annual Financial Report main page, and click on the Report action on the Action Bar.
The LA Annual Financial Report - Print Reports page will open.
The user may toggle the radio button to produce either the Hard Copy of the selected LAAFR report (in report, screen, or Excel forms), or the Electronic File, which includes all LAAFR reports for the Electronic File Report Year no matter which LAAFR report was selected.
The Start Date, End Date, and Electronic File Report Year prompts are populated automatically depending on the year of the selected report.
The Override Start Period and Override End Period can be entered optionally. These will override the start and end periods defined in the report columns.
No matter what the initial report selection was, if the 'Electronic File' radio button option is chosen, the system will produce the electronic file submission for the state, consisting of all the reports, including LAAFR1 through LAAFR5. The electronic file, 'lafrfin.tpe,' will be produced in the user's defined $FASTAPDIR.
Finally, a 'Line and Column' validation report, 'finlist.rpt,' may be generated if desired from the List action (pictured above) on the Action Bar of the Print Reports screen. The Line and Column report lists all the line and column record information for the selected report for user validation.
File Layouts And Data Mapping
The electronic file produces the following file layouts.
Table I: Revenue, Expenditures, Funds, Balances & Balance Sheet
Column (position) | Field Name | Length | Comments |
---|---|---|---|
01-03 | Record Identifier | 3 | Constant "AFR" |
04-07 | Session Year | 4 | YYYY (screen input) |
08-10 | LEA Sponsor Code | 3 | hrmstate.state01 |
11-17 | Key Punch Code | 7 | fund/object/function |
18-18 | Filler | 1 | blank |
19-27 | General Funds | 9 | fund amount |
28-28 | General Funds sign | 1 | "-" If the value is negative |
29-37 | Special Funds Federal | 9 | fund amount |
38-38 | Special Funds sign | 1 | "-" If the value is negative |
39-47 | Federal IASA Funds | 9 | fund amount |
48-48 | Federal IASA Funds sign | 1 | "-" If the value is negative |
49-57 | Other Special Funds | 9 | fund amount |
58-58 | Other Special Funds sign | 1 | "-" If the value is negative |
59-67 | Debt Service Funds | 9 | fund amount |
68-68 | Debt Service Funds sign | 1 | "-" If the value is negative |
69-77 | Capital Projects Funds | 9 | fund amount |
78-78 | Capital Projects Funds sign | 1 | "-" If the value is negative |
79-87 | Total Funds | 9 | fund amount |
88-88 | Total Funds sign | 1 | "-" If the value is negative |
89-91 | Project Code | 3 | Project Code from header |
Table II (Section A): Ad Valorem Taxes
Column (position) | Field Name | Length | Comments |
---|---|---|---|
01-03 | Record Identifier | 3 | Constant "AFR" |
04-07 | Session Year | 4 | YYYY (screen input) |
08-10 | LEA Sponsor Code | 3 | hrmstate.state01 |
11-17 | Key Punch Code | 7 | fund/object/function |
18-18 | Filler | 1 | blank |
19-23 | Parishwide Rate | 5 | 999V99 |
24-32 | Parishwide Tax Revenue | 9 | fund amount |
33-33 | Parishwide Tax Revenue Sign | 1 | "-" If the value is negative |
34-38 | District/Ward Rate (Low) | 5 | 999V99 |
39-43 | District/Ward Rate (High) | 5 | 999V99 |
44-46 | Number of Districts | 3 | count of districts |
47-55 | District/Ward Tax Revenue | 9 | fund amount |
56-56 | District/Ward Tax Revenue sign | 1 | "-" If the value is negative |
57-65 | Total Ad Valorem Tax | 9 | fund amount |
66-66 | Total Ad Valorem Tax sign | 1 | "-" If the value is negative |
67-88 | Filler | 22 | blank |
89-91 | Project Code | 3 | Project Code from header |
Table II (Section B): Sales and Use Taxes
Column (position) | Field Name | Length | Comments |
---|---|---|---|
01-03 | Record Identifier | 3 | Constant "AFR" |
04-07 | Session Year | 4 | YYYY (screen input) |
08-10 | LEA Sponsor Code | 3 | hrmstate.state01 |
11-17 | Key Punch Code | 7 | fund/object/function |
18-18 | Filler | 1 | blank |
19-23 | Debt/and Non-Debt Rate | 5 | 999V99 |
24-32 | Non-Debt Service Amount | 9 | fund amount |
33-33 | Non-Debt Service Amount Sign | 1 | "-" If the value is negative |
34-42 | Debt Service Amount | 9 | fund amount |
43-43 | Debt Service Amount Sign | 1 | "-" If the value is negative |
44-52 | Total Sales and Use Taxes | 9 | fund amount |
53-53 | Total Sales and Use Taxes sign | 1 | "-" If the value is negative |
54-88 | Filler | 35 | blank |
89-91 | Project Code | 3 | Project Code from header |
Table III: General Fixed Asset Or Long Term Debt
Column (position) | Field Name | Length | Comments |
---|---|---|---|
01-03 | Record Identifier | 3 | Constant "AFR" |
04-07 | Session Year | 4 | YYYY (screen input) |
08-10 | LEA Sponsor Code | 3 | hrmstate.state01 |
11-17 | Key Punch Code | 7 | fund/object/function |
18-18 | Filler | 1 | blank |
19-27 | Beginning Balance | 9 | ? |
28-28 | Beginning Balance Sign | 1 | "-" If the value is negative |
29-37 | Additions | 9 | fund amount |
38-38 | Additions Sign | 1 | "-" If the value is negative |
39-47 | Deletions | 9 | fund amount |
48-48 | Deletions Sign | 1 | "-" If the value is negative |
49-57 | Ending Balance | 9 | ? |
58-58 | Ending Balance Sign | 1 | "-" If the value is negative |
59-88 | Filler | 30 | blank |
89-91 | Project Code | 3 | Project Code from header |
Table IV: Proprietary Funds & Fiduciary Funds
Column (position) | Field Name | Length | Comments |
---|---|---|---|
01-03 | Record Identifier | 3 | Constant "AFR" |
04-07 | Session Year | 4 | YYYY (screen input) |
08-10 | LEA Sponsor Code | 3 | hrmstate.state01 |
11-17 | Key Punch Code | 7 | fund/object/function |
18-18 | Filler | 1 | blank |
19-27 | Beginning Balance | 9 | ? |
28-28 | Beginning Balance Sign | 1 | "-" If the value is negative |
29-37 | Additions | 9 | fund amount |
38-38 | Additions Sign | 1 | "-" If the value is negative |
39-47 | Deletions | 9 | fund amount |
48-48 | Deletions Sign | 1 | "-" If the value is negative |
49-57 | Ending Balance | 9 | ? |
58-58 | Ending Balance Sign | 1 | "-" If the value is negative |
59-88 | Filler | 30 | blank |
89-91 | Project Code | 3 | Project Code from header |