Skip to content

Schools Division Integrated Planning in the Accountability Framework App

Non-profit education and research organisation, Middle East

In short

How can a schools network replace separate planning spreadsheets with one app?

Each year, the schools division network of the client had to plan business, manpower and finances for all of its schools and centres, in separate spreadsheets that someone had to merge by hand. The cycle had a fixed calendar and a presidential review, so late or inconsistent plans cost real time. We added integrated planning to its existing Accountability Framework app.

Results in numbers

schools on shared templates
30+
departments imported
c. 90
academic years
3

At a glance

  • Business, manpower and financial planning in one app
  • Planning for 3 academic years per school or centre
  • More than 30 schools and centres on one set of templates

The client

The schools division is the school education arm of the client in the region. It runs a network of schools and centres, and already tracked its strategic accountability framework in a Power Apps app on SharePoint.

What it was costing them

  • Manual consolidation: plans from every school and centre arrived in different spreadsheets and had to be merged before review.
  • Inconsistent entries: positions, expense types and departments were typed freely, so totals did not line up.
  • Tight calendar: a yearly cycle with a president's review left little room to correct late or wrong plans.
  • Hand-offs between teams: finance and HR each owned part of the plan, with no one place to see the whole.

What we built

We extended the existing Accountability Framework Power Apps app with planning screens for initiatives, enrolment, manpower and non-staff costs, and an integrated planning view.

  • One template for every school: initiative planning brings student enrolment, manpower and budget requirements into one place.
  • Finance owns what Finance knows: a revenue and student enrolment planning screen for the finance team.
  • HR owns what HR knows: a manpower planning screen for the HR team, with positions from an HR-provided list.
  • Costs by type: a non-staff cost planning screen, with expense types from a finance-provided list.
  • The whole picture for leadership: an integrated planning view for super users that brings the calculations together.
  • Clean start: planning data moved from Excel into new SharePoint lists, using prepared import files with schools, centres, departments, grades and positions.
  • Right access: roles control who can enter and who can see each screen.
  • Safe go-live: user acceptance testing with assigned roles, test data cleared afterwards, and admin training for assigning roles.

Results

  • Four planning areas (initiatives, enrolment, manpower, non-staff costs) and an integrated view added to the existing app.
  • Import files prepared for more than 30 schools and centres and about 90 departments.
  • Planning covers three academic years, with the process for adding a third year defined.
  • Result: fewer rounds of correction between entities, finance and HR before the plan goes to review.

The risk most teams miss

SharePoint lists work for one cycle, but planning rows multiply by school, department, grade and year. In month three, a plan list passes a few hundred rows per sheet, views slow down and thresholds appear, while role lists drift out of date. We prepared clean lookup lists and defined roles, and we recommend moving the plan data to Dataverse before the second cycle.

What we would add today

Improvements we would add on top of what is live.

  • Move planning data to Dataverse with row-level security so each school sees only its own plan, and finance and HR only their sections.
  • Add a business process flow and approval stages, so a plan moves from entity leadership to review to approved with a visible status.
  • Use Dataverse calculated and rollup columns for revenue, staff cost and cost recovery.
  • Publish the integrated plan in Power BI on Dataverse for the leadership review.
  • Deploy through Power Platform pipelines with environment variables for the lists and lookup sources.

Technology

Power Apps (canvas), SharePoint Online lists, Microsoft Excel (import), Microsoft 365.

Tell us how many teams each fill part of your yearly plan, and we will tell you how to bring them into one app.

Products and capabilities

  • Power Apps
  • SharePoint
  • integrated planning
  • budget planning
  • manpower planning
  • data migration
  • role-based access

Related use cases

Finance

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.