1 / 66

DPI Spring Finance Workshop

DPI Spring Finance Workshop. School Financial Services Team WASBO Accounting Conference March 21, 2019. DPI Spring Finance Workshop Welcome & Overview Daniel Bush School Administration Consultant. Agenda. ESSA School Level Reporting Update WISEdata Finance School Finance Potpourri

torbett
Download Presentation

DPI Spring Finance Workshop

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DPI SpringFinance Workshop School FinancialServices Team WASBO Accounting ConferenceMarch 21, 2019

  2. DPI Spring Finance Workshop Welcome & Overview Daniel BushSchool Administration Consultant

  3. Agenda ESSA School Level Reporting Update WISEdata Finance School Finance Potpourri Biennial Budget Update

  4. DPI Spring Finance Workshop ESSA School Level Reporting Update Daniel BushSchool Administration Consultant

  5. Every Student Succeeds Act Your responsibility: Reportper-pupil federal & non-federal expenditures by school to DPI Our responsibility: Collect this data and report it to the U.S. Department of Education

  6. SLR Implementation Plan 2018-19 School Year Data Fall 2018: Report budget totals by school to DPI Late summer 2019: Report actuals by school to DPI June 2020: DPI reports audited actuals to U.S. Dept. of Education and publishes data to the public DONE!

  7. Where Are We At? Reviewing reporting issues & questions for possible changes this summer Ongoing participation in multi-state Financial Transparency Workgroup Still minimal guidance from U.S. Department of Education

  8. Most Common Question from LEAs “Is this an exclusion?” Reminder: Exclusions are separate from your continuing year-to-year instructional operations

  9. Why Call Something an Exclusion? It’s a large capital cost It’s separate from your instructional program It’s an accounting artifact

  10. 2018-19 School Level Actuals Same “Combined Reporting” portal as School Level Budget Scheduled to open same time asPI-1505 Annual Report Due 2 weeks after the PI-1505

  11. Changes from SLR Budget to SLR Actuals Higher expectations for data consistency vs. PI-1505 Enrollments from WISEdata (same rules as Report Cards)

  12. For More Information School Level Reportingwebpage: https://dpi.wi.gov/sfs/reporting/slr

  13. For More Information ESSA School Level Reporting - What's Next? 2:30 – 3:30 pmSuites 4 & 5

  14. DPI Spring Finance Workshop WISEdata Finance Daniel BushSchool Administration Consultant

  15. Background In 2016 DPI changed how student data was reported… ISES Student

  16. …In 2020 we’re planning to do the same for financial data SAFR Background Finance

  17. What is WISEdata Finance? New financial data reporting system for Wisconsin LEAs DPI-led extension of the Ed-Fi API for national use

  18. What is WISEdata Finance? Financial data is sent directly to DPI from your financial system, just as student data is sent directly from your SIS

  19. Why WISEdata Finance? Eliminate the manual part of financial reporting Better consistency with DPI and local accounts side by side Easier reporting compliance (CRDC, ESSA School Level, PI-1504/1505, etc.)

  20. How Does WISEdata Finance Work? Vendors pull the current WUFAR Chart of Accounts from DPI

  21. How Does WISEdata Finance Work? You push a crosswalk between your local COA and WUFAR to DPI

  22. How Does WISEdata Finance Work? You push your budgets & YTD actuals by account to DPI

  23. WISEdata Finance Ed-Fi Model Local Account Elementary School 4th Grade Teacher Salary 10E 100 120 110400 000 Budget$50,000 Actual$20,000 As of1/10/2021 Location 100 =Elementary School DPI Account Undifferentiated Curriculum Salary 10E 100 110000

  24. Account Tags Vendors must be able to attach “tags” to WUFAR accounts Tags drive ESSA School Level Reporting and other DPI reports

  25. Account Tags Location code must connect to a school or the district/LEA as a whole Multiple location codes can connect to the same place 10 E 800 165 252000 000 District-Wide 80 E 900 411 393000 000 27 E 400 482 156600 341 High School

  26. Account Tags Must use correct DPI grant project codes Option to tag accounts as exclusions 10 E 800 165 252000 000 Exclusion 80 E 900 411 393000 000 27 E 400 482 156600 341 IDEA Flow-Through

  27. Planned Timeline 2018-19: Project development 2019-20: Piloting with continued development 2020-21: Statewide launch

  28. What Does This Mean For You? Coding must be correct • Vendors will pull the current WUFAR chart of accounts directly from the system • Incorrect accounts will be rejected • DPI grant project codes will be required

  29. What Does This Mean For You? “Fixing the report” meansfixing your books • No manual data entry as in current SAFR • Books aren’t truly closed until the audit and review process is complete

  30. What Does This Mean For You? Start planning now to get your software updated and books in order so that… …your books as of June 30, 2020 match your 2019-2020 PI-1505 Annual Report • 2019-2020 PI-1505 Ending Balances =2020-2021 WISEdata Finance Starting Balances

  31. WISEdata Finance Preview Application is still under development Screenshots are not final!

  32. Chart of Accounts Accounts are “DPI” (available to all LEAs) or restricted to specific LEAs Your DPI chart of accounts is unique!

  33. Account Search Searchable listing of your local accounts with associated data • Account dimensions • DPI account • Actual and budget amounts

  34. Account Details Full data history of this local account

  35. Account API Data View Review each individual piece of data submitted

  36. Validation Messages Similar data checking as current SAFR system… …with the validation format of WISEdata Student

  37. WISEdata Finance & School Level Reporting Financial data pulled into SLR application using account tags SLR application used for exclusions, preliminary enrollments, and confirmation of per-pupil numbers

  38. What About Our Current Reports? PI-1504/05 reports become data extracts plus additional details PI-1504/05-SE report replaced with a WISEgrants-like claim for State Special Education Aid & related categorical aids

  39. Longer Term Goals Feed directly into WISEgrants for claims, IDEA MOE, and more Use account tags to help you with CRDC & other requirements

  40. Longer Term Goals …and a searchable, browsable Online WUFAR More to come on thisat the Spring Conference!

  41. Contact: SLR & WISEdata Finance Daniel BushSchool Administration ConsultantSchool Financial Services Teamdaniel.bush@dpi.wi.gov608-266-3862

  42. Questions? Comments?

  43. DPI Spring Finance Workshop School FinancePotpourri Carey BradleyAssistant Director

  44. Community Programs and Services Each function, program or service operated by a school district is a part of the district’s general school operations (normally Fund 10 costs) • Unless documented to be part of the school board’s established community programs or services offered under Wis. Stat. 120.13(19)

  45. Fund 80 Program or Service Cost State law defines eligible community programs and services and WUFAR establishes the Community Service Fund 80. In addition, PI 80 has been created to define ineligible Fund 80 costs. State law specifies: Costs associated with community programs and services shall not be included in the school district's shared cost under s. 121.07 (6).

  46. Fund 80 Program or Service Cost The program or service offered by the school board is either a school cost (Fund 10) or a community program or service cost (Fund 80) • Staff can be jointly funded, but job duties distinct and separate Costs must be the actual, additional cost to operate community programs and services

  47. Decision Tree for Community Programs A tool to ask and answer 10 questions when reviewing existing community programs and services or considering adding a new Fund 80 expense https://dpi.wi.gov/sites/default/files/imce/sfs/pdf/Final-Decision-Tree-for-Potential-Fund-80-03-2019.pdf

  48. Contact: Fund 80 Community Programs Bruce AndersonSchool Administration ConsultantSchool Financial Services Teambruce.anderson@dpi.wi.gov608-267-9707 Community Programs and Services webpage: • https://dpi.wi.gov/sfs/finances/fund-info/community-service/overview

  49. Timely Reporting to DPI Impacts Us All Late financial reports • Budget Annual Budget 1505/04 • Annual 1505/04 Special Education

  50. Timely Reporting to DPI Impacts Us All Late submission of audited financial statements Late submission of Actuarial studies

More Related