032 DISTRICT FINANCE DATA - ACTUAL

Input Record
Type Code

District ID

Fund
Code

Function
Code

Object
Code

Organi-zation Code

Fiscal
Year

Program
Intent
Code

Actual
Amount

Filler

E0755

E0212

E0316

E0317

E0318

E0319

E0974

E0320

E0774

 

C042

 

C145

C146

C159

   

C147

   

Columns
1 - 3

Columns
4 - 9

Columns
10 - 12

Columns
13 - 14

Columns
15 - 18

Columns
19 - 21

Column
22

Columns
23 - 24

Columns
25 - 35

Columns
36 – 80

032

                 

032

                 

  PEIMS collects financial data in chart of accounts format following the mandatory accounting codes outlined in the Financial Accountability System Resource Guide, Financial Accounting and Reporting Module. Detailed (non-summarized) financial data in a format that reflects local accounting records is reported for actual data.

  The PEIMS data collection format for actual data reflects the mandated minimum account code structure of the Resource Guide. Districts must report the amount associated with each combination of values of the state mandatory minimum account codes used for local accounting purposes. Where districts maintain greater detail than the state-mandated level, which could occur if a district's records include either code values or code accounts beyond the state minimum, such as sub-object accounting, the detail is to be rolled up (summarized) to the state-mandated level by districts prior to delivery to ESCs for PEIMS editing and processing.

  PEIMS code tables for Resource Guide accounting codes (FUND-CODE Table, FUNCTION-CODE Table, OBJECT-CODE Table and PROGRAM-INTENT-CODE Table) contain detail to the minimum state-mandated level of detail. Summary level codes are not included in these code tables, since such summaries are not requested for PEIMS reporting. As mentioned above, districts that use Resource Guide codes that are below the state-mandated level must report data only to the level of detail that is prescribed in the code tables.

  For federal project funds, the FISCAL-YEAR should indicate the state project year during which the project funds were originally allocated. Otherwise, FISCAL-YEAR should indicate the state fiscal year. Both digits of the FUNCTION-CODE should have meaningful values. The OBJECT-CODE values should correspond at least to the greatest level of detail described in the Resource Guide, which in most cases is the third level object code (meaningful fourth digit). Although sub-object accounting, as described in the Resource Guide, is implemented in many districts, this is not reported in PEIMS. The ORGANIZATION-CODE values reported should relate to all organizational units for which the district accounts. Code values associated with campus organizational units should match those registered with TEA.

  Districts should report only the lowest level of detail maintained in their financial records even if higher summary levels of detail are included in their records. For instance, if a district's internal records include information about teachers' salaries (object 6119) and clerical workers' salaries (object 6129), total salaries (object 6110), and total payroll costs (object 6100), only information recorded to the third level object code (objects 6119, 6129) should be reported.

  PEIMS collects actual financial data for the prior school year. These are audited data. Any audit corrections must have been made in the district's records. Districts must report records related to detailed revenue, fund balance, and expenditure accounts. Fund balance accounts (codes 3XXX) should show the post-closing fund balances on August 31 of the prior year, with all audit adjustments posted. The PEIMS data collection format reflects the mandated minimum account code structure in the Resource Guide. The actual financial data reporting requires ACTUAL-AMOUNT, rather than BUDGET-AMOUNT, as in budget reporting.

  Amount refers to "actual pre-closing realized expenditures/expenses and pre-closing revenues".

  If the district was the absorbing district in a consolidation the prior year, the district must report the actual financial data for the consolidated district.

  Actual financial data are reported to reflect the district configuration of the prior year.

Option to Change the Start Date of the Fiscal Year

  School districts may choose a fiscal year that begins on either July 1st or September 1st of each year. A school fiscal year that begins on July 1st will end on June 30th of the next calendar year. In lieu of making a change in this area, districts may continue the current fiscal year reporting period that begins on September 1st and ends on August 31st of the next calendar year.

Budgetary planning activities are impacted for those school districts that decide to implement a fiscal year beginning on July 1st. Districts may delay implementation of a fiscal year start date of July 1st to any future fiscal year.

In order to change the fiscal year start date to July 1, 2012, districts must file with TEA no later than June 30, 2011, a Notification of Intent to Change the Fiscal Year Start Date to July 1, 2012. This form (FIN-003) is available on the TEA website at http://www.tea.state.tx.us/school.finance/audit/FIN_003.pdf.

  In the first year of implementation, the financial accounting period will span ten months in those districts that opted to change, beginning September 1 and ending June 30. However, certain aspects of financial management and reporting will require adjustments in the first year of implementation. These adjustments are required since the state and federal fiscal years did not change, and the administration of state and federal regulatory activities, as well as state funding calculations under the Foundation School Program, require financial data on a 12-month reporting basis. This means that all financial data reported for the first year of implementation, except for the annual financial report, must be based on a 12-month reporting period, as follows:

  For all subsequent fiscal year periods following the first year of implementation of a July 1st fiscal year start date, all financial data will be reported on a 12-month basis spanning July 1st through June 30th. Please note that additional considerations may affect a school district’s decision to implement a change in its fiscal year start date, including the installation of new financial accounting software and/or significant problems in internal financial management activities such as general ledger reconciliation problems. Some school district officials have indicated that the elimination of accrued payroll liabilities will be the primary benefit of a change in the fiscal year start date; however, it is important to understand that this change will not eliminate all accrued payroll liabilities (the exact impact on accrued payroll liabilities can be clarified by visiting with the district’s independent auditor). Prior to making this change, it is also recommended that the district’s administration advise the board of trustees and have the board ratify administration’s proposed decision to change the start date of the fiscal year. District administration should also inform the board of trustees about the impact this change will have on various administrative processes, such as the budget development calendar. It will also be important to monitor any activity during the upcoming legislative session that may impact certain aspects of this financial management issue. Lastly, it is recommended that the district consult with its independent auditor before making a change in the fiscal year start date.

  Changes to deadlines for filing the independent financial audit should result in appropriate modifications to the timing of quality assurance procedures for data submitted through PEIMS.

  GASB 34 had little to no impact on PEIMS reporting. Districts continue to report their governmental fund type information on a modified accrual accounting basis consistent with reporting practices on governmental fund types prior to GASB 34.

For additional information on this topic please visit the TEA Correspondence Webpage at: http://www.tea.state.tx.us/taa/sortf.cgi?command=bydate. More information is available in the TEA correspondence dated May 16, 2001 and the subject line is: Update 7 to the Financial Accountability System Resource Guide.

  Option to Change the Start Date of the Fiscal Year:

Year Fiscal Year Start Date Transitions to July 1st:

Year After Transition to July 1st Fiscal Year Start Date:

For additional information on this topic please visit the TEA Correspondence Webpage at: http://www.tea.state.tx.us/taa/sortf.cgi?command=bydate. More information is available in the TEA correspondence dated January 24, 2001 and the subject line is: Option to Change the Start Date of the Fiscal Year.

Notice of Grant Award New Fund Code(s)

Districts that receive a Notice of Grant Award for a “new grant” in which the fund code does not become effective until 9/1/XX but the grant becomes effective 7/1/XX must report July and August under the applicable generic fund code for those two months:

Special Instructions for Shared Services Arrangement Reporting

The shared services arrangement fiscal agent reports the actual financial data for the prior school year for the shared services arrangement. Actual revenue and expenditure data should be reported using the FUND-CODEs specified for shared services arrangements.