Summary: Actual balances by Fund and Object Code.

Usage: Review balances for consistency across years.

Data Sources: Mid-Year PEIMS file.

Definitions:
Fund Code E0316
Object Code E0318

Calculations: None, except for totals.

Resources and Notes:
Please note- Actual balances for a school year are submitted to TEA the following school year. Example; all balances for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year, once Mid-Year PEIMS is finalized.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.

Summary: Actual expenditures by function code.

Usage: Review expenditures for consistency across years.

Data Sources: Mid-Year PEIMS file.

Definitions: Function Code E0317

Calculations: None, except for totals.

Resources and Notes:
Please note – Actual expenditures for a school year are submitted to TEA the following school year. Example: all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.  Years noted on these reports are the actual year the data is reported (2016-2017), not the PEIMS year collected (2017-2018).

Summary: Actual revenues grouped by Object Code.

Usage: Review revenues for consistency across years.

Data Sources: Mid-Year PEIMS file.

Definitions:
Object Codes E0318

Calculations: Object code amounts are summed by type, local, state and federal.

Resources and Notes: Please note- Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.  Years noted on these reports are the actual year the data is reported (2016-2017), not the PEIMS year collected (2017-2018).

Summary: Actual other financing sources by Object Code.

Usage: Review financing sources for consistency across years.

Data Sources: Mid-Year PEIMS file.

Definitions: Object Codes E0318

Calculations: Object code amounts are totaled.

Resources and Notes:

Please note- Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.  Years noted on these reports are the actual year the data is reported (2016-2017), not the PEIMS year collected (2017-2018).

Financial Report – “Shared Service Arrangement Membership

Summary: Displays a list shared services your district participates in with other districts.

Usage: Review for accuracy.

Data Sources: Fall PEIMS submission and Mid-Year PEIMS submission.

Definitions:
PEIMS 011 Record E0755 (Table C042)
Shared Service Type Code E0776 (Table C049)

Resources for definitions and calculations:
Please note- Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Financial Report – Shared Service Fiscal Arrangement

Summary: Displays a list shared services your district acts as the fiscal agent for.

Usage: Review for accuracy.

Data Sources: Mid-Year PEIMS submission.

Definitions:
PEIMS 033 Record E0755 (Table C042)
Shared Service Type Code E0776 (Table C049)
Fund Code E0316 (Code Table C145)

Resources for definitions and calculations:
Please note- Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Shared Service Arrangement fiscal agents should send expenditure reports to each SSA member district showing the 033 DISTRICT FINANCE DATA – SHARED SERVICES ARRANGEMENT ACTUAL record reporting that will be done on behalf of that SSA member district. Fiscal agent districts can use EDIT+ report PRFBD001 – Actual SSA Financial Summary by Fund and SSA Type as a starting point for distribution of the relevant expenditures on behalf of SSA members.

For additional information related to Shared Service Arrangements, reference Module 1 of the Financial Accounting Resource Guide at: https://tea.texas.gov/WorkArea/linkit.aspx?LinkIdentifier=id&ItemID=2147491750&libID=2147491747

Financial Report – M&O Tax Rate and Ending Fund Balance in the General Fund by Fiscal Year

Summary: Displays M&O tax rate (Maintenance & Operations) across years as compared to ending general fund balance.

Usage: Review for accuracy. Compare tax rate relative to ending fund balance.

Data Sources: Mid-Year PEIMS submission and Texas State Comptroller.

Definitions:
Ending Fund Balance-PEIMS 20032 ActualExtension

Fund Code(E0316) Total for General Fund Codes 101, 102, 199, or 420 (Code Table C145).

Object Codes(E0318) Total for codes 3400 through 3699 (Code Table C159).

Resources for definitions and calculations:

The Tax Rates are released annually and published on the Texas Comptrollers Web site.

Please note- Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.  Years noted on these reports are the actual year the data is reported (2016-2017), not the PEIMS year collected (2017-2018).

Summary: Displays total staff count and total students across years.

Usage: Review for accuracy. Compare student growth or decline to staff growth or decline.

Data Sources: Fall PEIMS submission.

Definitions:

• Total Fall Student Snapshot Count ADA Codes E0787 1,2,3,4,5,6 (Excludes students coded 0) (Code Table C059)
• Staff FTE (Full Time Equivalency) = PEIMS 060 Staff Employment Payroll Record where Fund Code E0316 in Code Table C145 is NOT a Shared Services Arrangement.
  • SSA fund codes excluded are:
    • 292, 293, 294, 295, 297, 298, 300, 301, 302, 307, 309, 311, 312, 313, 314, 315, 316, 317, 319, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 342, 343, 347, 348, 349, 350, 351, 352, 354, 355, 356, 357, 358, 359, 360, 361, 364, 365, 366, 367, 379, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 459

Special Note: An employee who has a payroll shared services arrangement fund code is not included in the Total Staff FTE calculation

Features:
Hover over chart to display counts, matching the table below Click on the Students or Staff key icons to remove or replace the data on the graph.

Financial Well Being Per Pupil Expenditures All Funds

Summary: Displays expenditures per pupil by object code. Can view different years, campuses, and programs

Usage: Review for accuracy and program objectives.

Data Sources: Fall PEIMS submission and Mid-Year PEIMS Submission.

Definitions:

Include Special Ed Funds and Students
-Total Fall Student Snapshot Count from StudentExtension Complex Type (40100) with ADA Codes (E0787) 1,2,3,4,5,6 (NOTE: Excludes students coded 0)
– PEIMS ActualExtension Complex Type (20032) on Object Codes (E0318) for Codes 6000 – 6999.

Exclude Special Ed Funds and Students
-Student ADA as above, but excludes Special Ed Students as indicated on the Fall PEIMS StudentProgramExtension Complex Type (40110) where Special Ed Indicator (E0794)= 0
-Same Object codes as above and excludes SOED PIC codes from total where Program Intent code E0320 = 23 & 33 (Code Table C147) from ActualExtension Complex Type(20032).

Show only SPED Funds and Students
-Displays students coded SPED in Fall PEIMS StudentProgramExtension Complex Type 40110( E0794) and PIC code of SPED from MidYear PEIMS ActualExtension Complex Type(20032) (E0320)=23 or 33 with Object codes listed above ( E0318).

Resources for definitions and calculations:
Example: Data Used for an 09-10 school year report.
– Fall snapshot count for 09-10 from the fall PEIMS submission submitted during the 09-10 school year.
– Actual 09-10 financial data from the Mid year financial submission submitted during 10-11 school year.
– Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 15-16 school year are reported to TEA in January 2017, during the 16-17 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.  Years noted on these reports are the actual year the data is reported (2016-2017), not the PEIMS year collected (2017-2018).

Summary: Displays key financial totals with staff and student data.

Usage: Review for accuracy and program objectives.

Data Sources: Fall PEIMS submission and Mid-Year PEIMS Submission.

Definitions:

Ending Fund Balance-PEIMS 20032 ActualExtension Fund Code(E0316) Total for General Fund Codes 101, 102, 199, or 420 and Object Codes(E0318) 3400 through 3699.

Revenues– PEIMS 20032 ActualExtension Fund Code(E0316) Total for General Fund 101, 102, 199, or 420 and Object Codes(E0318) 5000 through 5999.

Expenditures– PEIMS 20032 Actual Extension Fund Code(E0316) Total for General Fund 101, 102, 199, or 420 and Object Codes(E0318) 6000 through 6900.

Student/Staff FTE Ratio– Enrollment / All staff FTE.

Enrollment-Fall PEIMS Snapshot count.

All Staff FTE– (% Day Employed / 100) for all Role ID’s.

Resources for definitions and calculations:
Example: Data Used for a 17-18 school year report.
-Fall snapshot count for 17-18 from the fall PEIMS submission submitted during the 09-10 school year.
-Actual 17-18 financial data from the Mid year financial submission submitted during 18-19 school year.

-FTEs are calculated in OnDataSuite for school years 2009-2010 and beyond. The current FTE Calculation will only process Staff Responsibilities which contain Monthly Minutes. Prior to 2009-2010, Staff Responsibilities were not reported with Monthly Minutes.

– Actual expenditures for a school year are submitted to TEA the following school year. Example; all revenue and expenditures for the 17-18 school year are reported to TEA in January 2019, during the 18-19 school year. Therefore, updated data for this report can only be generated by the district during the following year.

Mid-Year PEIMS files in OnDataSuite are associated with the year the data is reported (actual 2016-2017 data) as opposed to the year PEIMS collects (2017-2018). All reports reflect the use of the Mid-Year PEIMS data accurately upon the TEA PEIMS collections schedule.  Years noted on these reports are the actual year the data is reported (2016-2017), not the PEIMS year collected (2017-2018).

Sample New Report Notes