Creating Ad Hoc Reports – Finance Report Center – PEIMS – Actual – MidYear
NOTE: The year will indicate the year occurred, not the year it was reported to PEIMS.
Example: The 2021-2022 Mid Year PEIMS data will display under the 2020-2021 year.
The Finance Report Center (Ad-Hoc) is a query tool of the raw Actual PEIMS data. The only business logic applied is when you utilize the Object filter. If you do not filter on Object codes, there is no logic of revenue to expenditure, etc. applied to the query results.
Object Filter options:
- Actual – Mid Year PEIMS
Criteria 1 = “Fund” + filter “199, 211”, etc
Criteria 2 = “Function” + filter “11”
Criteria 3 = “Object” + filter “Expenditures”-6100 (payroll)
Best Practices :
- Verify General Fund Expenditures by Function to the Statement of Revenues, Expenditures & Changes in Fund Balances.
- For each Major Fund group (column), Verify
- Revenue by type (57XX, 58XX, & 59XX),
- Expenditures by Function,
- Excess (deficiency) of Revenues over Expenditures,
- Other Financing Sources (Uses),
- Net Change in Fund Balances, and
- Fund Balances – Ending
- For each Major Fund group (column), verify Fund Balance amounts and classifications to the Balance Sheet, Governmental Funds.
- Check this comparison to prior year; be sure to explain any major increases/decreases
- Dig Deeper? NOTE: IF there are combining statements:
- PDM2-100-003 – For each Fund Group number (1XX, 2XX, etc.), verify:
- Revenue by type (57XX, 58XX, & 59XX)
- Transfers in and Transfers Out
- Other Resources and Other Uses
- Expenditures by Function group
- For Food Service and Debt Service (Actual Amounts), agree:
- Revenue by type (57XX, 58XX, & 59XX),
- Expenditures by Function
- Net Change in Fund Balance
- Ending Fund Balance
Compare the amounts reported in Mid-Year PEIMS for member districts in any SSAs for which the LEA was the fiscal agent and compare it to the Notes to the Financial Statements.